About this course

Course type Essentials
Course code DMEX11L2
Duration 1 Day

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.

Prerequisites

  • 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

Delegates will learn how to

At the end of this course you will be able 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

Outline

Lesson 1: Calculating Data with Advanced Formulas

  • Topic 1A: Apply Cell and Range Names
  • Topic 1B: Calculate Data Across Worksheets
  • Topic 1C: Use Specialised Functions
  • Topic 1D: Analyse Data with Logical and Lookup Functions

Lesson 2: Organising Worksheet and Table Data

  • Topic 2A: Create and Modify Tables
  • Topic 2B: Format Tables
  • Topic 2C: Sort or Filter Data
  • Topic 2D: Use Functions to Calculate Data
  • Topic 2E: Create a PivotTable Report

Lesson 3: Presenting Data Using Charts

  • Topic 3A: Create a Chart
  • Topic 3B: Modify Charts
  • Topic 3C: Format Charts

Lesson 4: Inserting Graphic Objects

  • Topic 4A: Insert and Modify Pictures and Clip Art
  • Topic 4B: Draw and Modify Shapes
  • Topic 4C: Illustrate Workflow Using SmartArt Graphics
  • Topic 4D: Layer and Group Graphic Objects

Lesson 5: Customising and Enhancing the Excel Environment

  • Topic 5A: Customise the Excel Environment
  • Topic 5B: Customise Workbooks
  • Topic 5C: Manage Themes
  • Topic 5D: Create and Use Templates
Lesson 6: Analysing Data Using PivotTables and PivotCharts
  • Topic 6A: Create a PivotTable Report
  • Topic 6B: Analyse Data Using PivotCharts
Essentials

1 Day

Duration
Microsoft Office
Delivery Method

Delivery method

Classroom

Face-to-face learning in the comfort of our quality nationwide centres, with free refreshments and Wi-Fi.

Find dates and prices

Online booking is currently not available for this course, to find out more please call us on 0345 074 7998 or email us at info@qa.com to discuss how we can help.

Trusted, awarded and accredited

Fully accredited to ensure we provide the highest possible standards in learning

All third party trademark rights acknowledged.