Microsoft Office 2010 Excel (Advanced Level)

Key Learning Outcomes

1. Understand how data is handled in Excel and explore a range of methods for cleaning up and manipulating data effectively
2. Using advanced techniques in formula building including defining Named Ranges, managing named ranges, and using named ranges within function based formulas
3. Understand creative use of key FUNCTIONS that include SUMPRODUCT, VLOOKUP, MATCH and many more and work on examples that demonstrate how creative formulas can be used to achieve complex analytical tasks
4. Building multi-tiered Pivot Tables and use advanced techniques from the various features of Pivot tables for interesting ways to analyze data, including powerful field manipulations and different ways to summarize data
5. Adding fields or tiers to Pivot Tables
6. Drilling to detail
7. Manipulating fields and Value fields
8. Building Grouped Fields
9. Building Formula Fields within the Pivot Table
10.Understand the use of Data Validation lists to add interactivity to your spreadsheet calculators and models
11.Productivity and quality Tips and Tricks - Plenty of tips and tricks to enhance output and enable speedy working – printing, spreadsheet building, keyboard shortcuts and discovering little-known productivity techniques
12.Introduction to Conditional Formatting – in sheet displays

Notes:

The workshop will be carried out in a highly interactive manner, and depending on time, may have many more tips and tricks covered. We reserve the right to make modifications to the course coverage depending on participant level and time available.
Microsoft Excel for PC, Version 2010 will be used in the demonstration of techniques of this workshop. Participants may use version 2007 as well though differences in capability may exist in some modules. While participants are welcome to work with versions prior to 2007 or non-PC versions, some procedures and shortcuts vary and in the interest of clarity, the workshop demonstration may not be able to include them all.