Microsoft Excel 2011 Level 2 - Office for Mac

1 Day Course
Hands On
Official Microsoft Curriculum
Code DMEX11L2

Book Now - 1 Delivery Method Available:

Scheduled Online Onsite

Overview

In Microsoft Excel for Mac 2011 Level 1, you created, edited, formatted, and printed basic spreadsheets. You now have a need to streamline repetitive tasks and display spreadsheet data in more visually effective ways.

In this course, you will use Microsoft Excel for Mac 2011 to streamline and enhance your spreadsheets with templates, charts, graphics, and formulas.

Objectives

Delegates will learn how to:

  • Use advanced formulas
  • Organise worksheet and table data using various techniques
  • Create and modify charts
  • Insert and modify graphic objects in a worksheet
  • Customise and enhance workbooks and the Microsoft Office Excel environment

Training Partners

We work with the following best of breed training partners using our bulk buying power to bring you a wider range of dates, locations and prices.

Modules

Hide 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

Additional Learning

The courses below may help you meet the knowledge level required to take this course. If you are unsure please ask a training advisor .

or call:408-759-5074

Course PDF

Print

Share this Course

+1
Share

Recommend this Course

Sections