Microsoft Excel 2011 Level 2 - Office for Mac

1 Day Course
Hands On
Official Microsoft Curriculum
Code DMEX11L2

This course has been retired. Please view currently available User Microsoft Office Training Courses.

Modules

Collapse all

Calculating Data with Advanced Formulas (4 topics)

  • Apply Cell and Range Names
  • Calculate Data Across Worksheets
  • Use Specialised Functions
  • Analyse Data with Logical and Lookup Functions

Organising Worksheet and Table Data (5 topics)

  • Create and Modify Tables
  • Format Tables
  • Sort or Filter Data
  • Use Functions to Calculate Data
  • Create a PivotTable Report

Presenting Data Using Charts (3 topics)

  • Create a Chart
  • Modify Charts
  • Format Charts

Inserting Graphic Objects (4 topics)

  • Insert and Modify Pictures and Clip Art
  • Draw and Modify Shapes
  • Illustrate Workflow Using SmartArt Graphics
  • Layer and Group Graphic Objects

Customising and Enhancing the Excel Environment (4 topics)

  • Customise the Excel Environment
  • Customise Workbooks
  • Manage Themes
  • Create and Use Templates

Analysing Data Using PivotTables and PivotCharts (2 topics)

  • Create a PivotTable Report
  • Analyse Data Using PivotCharts

Prerequisites

Delegates should be able to:

  • Create basic spreadsheets
  • Select and edit data
  • Perform basic formatting
  • Open, close and save files
  • Create basic formulas – AutoSum
  • Use Insert Function to create built-in functions
  • Work with absolute references
  • Use the Autofill feature

Course PDF

Print

Sections