Professional Basic / Intermediate & Advanced Excel Computer Trainer In Dubai

BASIC / INTERMEDIATE EXCEL – MICROSOFT OFFICE 2016 / 2019

Training Course Outlines For Windows / Mac Computer :

STARTING THE EXCEL PROGRAM:
What is the Active Cell?
The Excel cell referencing system
Entering numbers and text
Default text and number alignment
Entering a date
Worksheets and Workbooks
Saving a workbook
Closing a workbook
Creating a new workbook
Opening a workbook
Switching between workbooks
Saving a workbook using another name
Saving a workbook using a different file type
SELECTION TECHNIQUES:
Manipulating rows and columns
Manipulating cells and cell content
Worksheets
Font formatting
Alignment formatting
Number formatting
Freezing row and column titles
FORMULAS:
 Creating formulas
 The easy way to create formulas
 Copying formulas
 Operators
 Using operators in formulas
 Relative cell referencing
 Absolute cell referencing
FUNCTIONS:
 What is a function?
 Sum function
 Average function
 Max function
 Min function
 Count function
 The COUNTA function
 The COUNTBLANK function
 The Round function
 Using the IF function


ADVANCED EXCEL – MICROSOFT OFFICE 2016 / 2019
FOR OFFICE PURPOSE:
Use of operators
 Advanced formulas
Understanding of relative reference, absolute reference & mixed reference
Use of if statement, multiple if statement
 Filter & advanced autofilter – ( used to generate reports)
 Conditional formatting, hyperlink
 Use of validations
How to create and use of macro in workbook
Chart / 3d chart / use of pie chart & smart art
Sumif, sumifs, countif , countifs , averageif & averageifs
 Use of consolidate & subtotals
Pivot table with chart report features – (used to generate reports)
 Vlookup with iserror / isna functions – (used to generate reports)
 Sorting & multiple sorting
Data analysis through goal seek & data table features
Linking of worksheet / workbook
Import / export of data
How to protect file, worksheet & workbook
Use of template
Use of other applications in the workbook
How to customize the applications
Printing setup
Many more …… with assignments & important notes


FLEXIBLE FOR HOME TUITION!
ONE TO ONE OR GROUP STUDENTS!
REASONABLE FEES!
HOURLY CLASSES!

PLEASE CONTACT ON: 0529737445 / 0505944072 ( What’s App )