Excel 2010 Advanced
Advanced Microsoft Excel 2010 Course Outline
Advanced Excel Training for business users
Duration: |
Intended audience: |
1 day |
Anyone who is comfortable and familiar with using Excel 2010 at intermediate level and wants to expand their knowledge |
Aims: |
To enlarge on an Intermediate level of knowledge by the use of worked examples and Advanced Excel Exercises |
Objectives:
|
By the end of the session delegates will be able to:·
|
Prerequisites: |
A good knowledge of Excel 2010 at Intermediate Level |
Refresher on Excel Intermediate Topics
Data Consolidation
Consolidating from multiple worksheets
Consolidating from multiple workbooks
Workbook and Worksheet Protection
Protecting and Locking Cells
Protecting and unprotecting worksheets
Password protecting
Hiding Formulas
Advanced Logical Functions
=IF(AND}, =IF(NOT), =IF(OR)
=SUMIFS
=COUNTIFS
=AVERAGEIFS
Lookups
=VLOOKUP
=HLOOKUP
=INDEX and MATCH
Working with Templates
Using Excel built-in templates
Create your own templates
Data Validation
Pivot Tables
Choosing data to Pivot
Editing the layout
Formatting the Pivot Table
Grouping
Calculated fields
Updating source data
PivotCharts
What If Analysis
Scenario Manager
Goal Seek
Data Tables
Installing and Using Solver
Error Trapping Functions
=ISERROR
=ISERR
=IFERROR
Introduction to Macros
Recording a macro
Absolute and relative macros
Assigning macros
Running and deleting macros
See our Excel Advanced video tutorials here
Need something a bit more advanced? Try our Excel 2010 Business Analysis course
There are also a number of Excel Advanced articles on our blog
Workshop very useful as it introduced a lot of new Excel techniques I was not aware of and I also gained a few tips for improvement of some that I was already using.
Heather, WGSM
Presenter really good and the examples were well set up
Tariq, Lions Festivals