Microsoft Excel for Mac Users

Microsoft Excel for Mac Users

Introduction Level

• The Excel Environment
• Copying, Moving and Deleting Information
• Copying, Moving, Resizing and Deleting Rows and Columns
• Using the Format Painter
• Formatting in Excel (Border and Shading, Cell Formatting)
• Wrap Text feature
• Merge and Centre feature
• Text Alignment and Text Formatting
• Creating basic formulas using mathematical operators (+,-,/ and *)
• Using BODMAS rules to create formulas
• Creating Percentage formulas
• Absolute Cell Referencing (using Dollar ($ signs) in formulas)
• Managing Worksheets (Insert, Delete, Rename, Move, Copy worksheets and colouring worksheet tabs)
• Using and Managing the Autosum feature (Sum and Average feature)
• Using Excel Functions:
  • Sum Function and Average Function
  • Max Function and Min Function
  • Count Function

Intermediate Level 

• Paste special features
• Charts and Formatting Charts
• Conditional Formatting and Conditional Formulas
• Security (adding protection)
• Sub totalling information
• Filtering and advanced filtering
• Named cells, ranges and using names in formulas
• Database functions
• Linking formulas & functions
• Mixed reference formulas
• Auditing Formulas
• Freeze Panes
• Printing using freeze panes and Print Area

Advanced Level

• Advanced Charts and Linking Charts to Other Applications
• Scenarios
• Data Tables
• Goal Seek
• Data Validation
• Pivot Tables
• Formulas & Functions
  • Consolidated Formulas
  • Date Formulas and Functions
  • Referencing Formulas
  • Error Functions
  • Logical Functions (IF, AND, OR)
  • Nested Functions (IF, AND, OR)
  • Lookup Functions (VLookup, HLookup)
  • Mathematical Functions (Sumif, Sumifs)
  • Statistical Functions (Countif, Countifs, Averageif, Averageifs,
    Countblank)
  • Text Functions (Trim, Left, Right, Mid, Concatenate)

Microsoft Excel for Mac Users

Introduction Level

• The Excel Environment
• Copying, Moving and Deleting Information
• Copying, Moving, Resizing and Deleting Rows and Columns
• Using the Format Painter
• Formatting in Excel (Border and Shading, Cell Formatting)
• Wrap Text feature
• Merge and Centre feature
• Text Alignment and Text Formatting
• Creating basic formulas using mathematical operators (+,-,/ and *)
• Using BODMAS rules to create formulas
• Creating Percentage formulas
• Absolute Cell Referencing (using Dollar ($ signs) in formulas)
• Managing Worksheets (Insert, Delete, Rename, Move, Copy worksheets and colouring worksheet tabs)
• Using and Managing the Autosum feature (Sum and Average feature)
• Using Excel Functions:
  • Sum Function and Average Function
  • Max Function and Min Function
  • Count Function

Intermediate Level 

• Paste special features
• Charts and Formatting Charts
• Conditional Formatting and Conditional Formulas
• Security (adding protection)
• Sub totalling information
• Filtering and advanced filtering
• Named cells, ranges and using names in formulas
• Database functions
• Linking formulas & functions
• Mixed reference formulas
• Auditing Formulas
• Freeze Panes
• Printing using freeze panes and Print Area

Advanced Level

• Advanced Charts and Linking Charts to Other Applications
• Scenarios
• Data Tables
• Goal Seek
• Data Validation
• Pivot Tables
• Formulas & Functions
  • Consolidated Formulas
  • Date Formulas and Functions
  • Referencing Formulas
  • Error Functions
  • Logical Functions (IF, AND, OR)
  • Nested Functions (IF, AND, OR)
  • Lookup Functions (VLookup, HLookup)
  • Mathematical Functions (Sumif, Sumifs)
  • Statistical Functions (Countif, Countifs, Averageif, Averageifs,
    Countblank)
  • Text Functions (Trim, Left, Right, Mid, Concatenate)

Microsoft Excel Data Visualised and Data Formatting

There is no formal assessment for this course and learners knowledge will be tested with informal activities throughout the session. For accredited Microsoft Office training options please view our ICDL courses or contact us for further options.

Microsoft Excel Data Visualised and Data Formatting

There is no formal assessment for this course and learners knowledge will be tested with informal activities throughout the session. For accredited Microsoft Office training options please view our ICDL courses or contact us for further options.

• 1-day training from NILC’s Microsoft certified trainers
• Practice files that will be used throughout the course
• PDF course manual with full step-by-step guide and images of each skill covered
• Recording from each training day (virtual-live courses only)
• Course completion certificate

• 1-day training from NILC’s Microsoft certified trainers
• Practice files that will be used throughout the course
• PDF course manual with full step-by-step guide and images of each skill covered
• Recording from each training day (virtual-live courses only)
• Course completion certificate