Microsoft Excel 2010 Intermediate Training Course

Microsoft Excel 2010 Intermediate Training Course


Event outline

Course Overview

So now you’re ready to take your MS Excel 2010 skills to the next level beyond the introductory level. This intermediate level course is designed to give you a deeper understanding of the powerful MS Excel features available in this software.

The pd training MS Excel 2010 Intermediate Training Course provides skill building in more advanced Excel features such as advanced formatting, documenting, auditing, advanced charting, templates and settings, tables, and more. This intermediate course is the second course in a series of three, and polishes and adds to the basic skills taught in the introductory course.

Learning Outcomes

  • Switch between workbooks
  • Create 3-D formulas linking worksheets & workbooks
  • Add a Watch window
  • Create a workspace
  • Use functions to format text
  • Transpose data
  • Add backgrounds & watermarks
  • Name cells & ranges
  • Sort & filter data
  • Create, format and modify tables
  • Use structured references in table formulas
  • Calculate SUM, AVERAGE and COUNT values in filtered tables
  • Insert, edit and delete hyperlinks
  • Send worksheets via e-mail
  • Create combination charts & trendlines
  • Insert sparklines
  • Use audit features
  • Protect a worksheet
  • Customise the Ribbon
  • Download templates
  • Create PivotCharts

Course Outline

Lesson 1
Using Multiple Worksheets and Workbooks

  • Using multiple workbooks
  • Linking worksheets with 3-D formulas
  • Linking workbooks
  • Managing workbooks

Lesson 2
Advanced Formatting Tips

  • Using special number formats
  • Using functions to format text
  • Working with styles
  • Working with themes
  • Other advanced formatting

Lesson 3
Outlining and Subtotals

  • Outlining and consolidating data
  • Creating subtotals

Lesson 4
Cell and Range Names

  • Creating and using names
  • Managing names

Lesson 5
Tables Explained

  • Sorting and filtering data
  • Advanced filtering
  • Working with tables

Lesson 6
Collaboration and Sharing Features

  • Saving workbooks as Web pages
  • Using hyperlinks
  • Sharing workbooks

Lesson 7
Advanced Charting

  • Chart formatting options
  • Combination charts
  • Graphical elements

Lesson 8
Documenting and Auditing

  • Auditing features
  • Comments in cells and workbooks
  • Protection
  • Workgroup collaboration

Lesson 9
Templates and Settings

  • Changing application settings
  • Using built-in templates
  • Creating and managing templates

Lesson 10
PivotTables and PivotCharts

  • Working with PivotTables
  • Rearranging PivotTables
  • Formatting PivotTables
  • Using PivotCharts

Dates & registration

There are no dates listed for this event.

Provider information

pd training is an Australian-owned, international training and professional development and services organisation, with approximately 400 specialist trainers across Australia, delivering thousands of courses each year in our 16 areas of specialty.