Microsoft Excel 2010: Advanced

Course Overview

This course is suitable for people who have attended the intermediate course or have good knowledge and understanding of Excel 2010 and would like to explore the more complex functionality it can offer.

CourseMonster are unbiased and "vendor neutral" which means that we can find the right course for you or your company by looking at our entire database of Microsoft training providers.

Related Courses

• Microsoft Excel 2010: Introduction for Beginners
• Microsoft Excel 2010: Intermediate Level 2
• Microsoft Excel 2010: Advanced
• Microsoft Excel 2007 or 2010: Advanced - Validate & Summarise
• Microsoft Excel 2007 or 2010: Advanced - Formulae & Functions
• Microsoft Excel 2007/2010: Intermediate
• Microsoft Excel 2010: Intermediate
• Microsoft Excel 2010: Visual Basic
• Microsoft Excel 2010: upgrade from Excel 2003 2007
• Microsoft Excel 2010: Expert 2010

Course Outline

Working with Multiple Worksheets and Workbooks

Using multiple worksheets

• Navigating between sheets
• Moving and copying sheets
• Linking worksheets
• Creating 3-D formulas
• Consolidating data
• Linking workbooks
• Creating a formula to link workbooks
• Using the paste link option
• Maintaining links

Using logical functions

• Naming ranges
• Creating named ranges
• Using named ranges in formulas
• The IF function (recap)
• Creating nested IF functions
• AND and OR functions
• Combining logical functions

Working with lookups

• The VLOOKUP function

Functions

• Creating a dropdown list using logical functions
• PMT
• AND
• OR
• INDEX
• MATCH

PivotTables and PivotCharts

• Using the PivotTable Wizard
• Rearranging PivotTables
• Using the PivotTable toolbar
• Creating PivotCharts
• Using Slicers to manipulate PivotTables

Using analytical options

• Using Goal Seek
• Using the solver add-in
• Working with scenarios
• Creating and saving scenarios
• Viewing screnarios
• The HLOOKUP function

Conditional formulas and formatting

• The IF function
• Conditional Formatting
• Based on a cell value
• Based on a formula
• Identifying cells with conditional formatting
• Copying conditional formats

Macros

• Creating macros
• Using the macro recorder
• Viewing and editing macro VBA code