MOF 004 – Microsoft Excel (Intermediate to advanced) (VL), 15 & 16 February 2021

MOF 004 – Microsoft Excel (Intermediate to advanced) (VL), 15 & 16 February 2021

Teachers
Mrs. Surya
Category:
IT (VL)/ Popular Virtual Learning Programs/ Virtual Learning Programs/
RM 500.00
Acellus-Mastering-Microsoft-Excel

RM 500.00

Duration: 2 Days
Lectures: Virtual Learning (Microsoft Teams)
Certificate of Attendance

INTRODUCTION

Microsoft Excel is an all-purpose software application for creating and sharing information through spread sheets. With a robust set of functions to automatically perform complex calculations, features to rapidly convert data into charts and graphs, and tools to securely share business information with to others, it is the most widely-used spread sheet application worldwide. Our facilitators have extensive real-world experience to help you rapidly master the fundamentals of Excel, regardless of which version you are using.

Objective

  • Format worksheets, cells and numbers
  • Perform sorting and data filtering
  • Prevent data entry errors using Data Validation
  • Perform data protection
  • Use common functions to manipulate data
  • Analyze and summarize data within seconds
  • Create and customize chart with confidence
  • Perform data analysis within minutes

Methodology

  • Hands-on
  • Exercise
  • Case study
  • Test
  • Brain-storming session

2 Days Training Modules

This content is restricted to members only. Please log in to view more details

Day One

  • Understanding Workbooks and Worksheets
  • Ribbon Tabs, Contextual Tabs, Quick Access Toolbar
  • Cells
  • Setting Excel Options

  • Entering Text, Values, Dates, Times into Worksheets
  • Learning some handy data-entry techniques
  • Using Ctrl+Enter
  • Using AutoFill
  • Using AutoComplete
  • Using AutoCorrect for Shorthand Data Entry
  • Using a Form for Data Entry
  • Remove Duplicate
  • Text to Columns
  • Applying Number Formatting
  • Customizing Number Formats

  • Changing the name of a worksheet
  • Changing a sheet tab’s color
  • Hiding and Unhiding a worksheet
  • Comparing Sheets side by side
  • Splitting the worksheet window into panes
  • Using Freeze Panes
  • Working with Rows and Columns

  • Selecting cells & ranges
  • Copying or Moving Ranges
  • Using the Office Clipboard to Paste
  • Using the Paste Special Dialog Box
  • Creating Range Names in your Workbooks
  • Managing Names
  • Adding Comments to Cells
  • Using Formatting
  • Changing Text Alignment
  • Wrapping or Shrinking Text to fit the cell
  • Using Colors and Shading
  • Adding Border and Lines
  • Adding a Background Image
  • Applying Styles & Theme

  • Changing Page View
  • Page Layout View
  • Page Break Preview
  • Page Setup Settings
  • Specifying the Print Area
  • Printing row and column titles
  • Scaling printed output
  • Adding Header or Footer

  • Understanding Formula Basics
  • Using Operators in Formulas
  • Understanding Operator Precedence in Formulas
  • Function Arguments
  • Inserting Functions into Formulas
  • Using Cell References in Formulas
  • Using Relative, Absolute, and Mixed References
  • Text Category Functions
  • Dates and Times Category Functions
  • Math, Statistic and Number Category Functions
  • Lookup Category Functions
  • Logic Category Functions

Day Two

  • Easier-to-Understand Formulas with Named Ranges
  • Assign name to a Constant

  • What is Comment?
  • Adding and Formatting a Comment
  • Comment’s Shape

  • Sorting
  • Tactics of Sorting
  • Custom Sorts
  • Auto Filter
  • Number, Date, Text Filters
  • Subtotal & Outlines

  • Type of Data verification & Controls
  • Errors handling with Data Validation
  • Conditional Formatting
  • Rules Manager

  • Text Functions
  • Number Functions
  • Date Functions
  • Conditional Control Functions
  • Lookup Functions
  • Functions application to real working environment

  • Introduction to Pivot Tables
  • Drag & Drop Techniques
  • Sorting in Pivot Tables
  • Pivot Fields Grouping
  • Subtotals and Blank Lines Controls
  • Summary Calculation
  • Running Total

  • Create and format a chart
  • Chart Elements
  • Data Series
  • Comparative Diagram
  • Combination Chart
  • Pie Chart

 

  • Tips of Tricks of Applying Password in Excel
  • Locked and Hidden Cells
  • Type of Hyperlinks
  • Hyperlinks to other application

About Instructors

Mrs. Surya
Microsoft Office Microsoft Project Microsoft Visio Microsoft Publisher Microsoft Outlook AutoCAD Adobe Photoshop Adobe Illustrator Adobe Flash Adobe Dreamweaver

Reviews

Average Rating

0
RM 500.00
0 Ratings

Detailed Rating

Stars 5
0
Stars 4
0
Stars 3
0
Stars 2
0
Stars 1
0

There are no reviews yet.

Be the first to review “MOF 004 – Microsoft Excel (Intermediate to advanced) (VL), 15 & 16 February 2021”