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.
Microsoft Excel provides an excellent blend of power and flexibility to the advanced spreadsheet user. It is however the ability to creatively combine its various features, functions and formulas, that distinguishes the Power user and makes short work of a variety of organizational data-related tasks. This workshop is aimed at giving participants a deep understanding of how to use advanced features in combination to be able to perform a variety of highly complex reporting and analytical tasks with ease.
Participants must have a good working knowledge of Microsoft Excel with higher intermediate proficiency. This includes knowing how to build formulas with nested functions including functions such as IF, COUNTIF, SUMIF, Absolute and Mixed references, spreadsheet productivity shortcuts, basic Pivot Table creation, and other intermediate spreadsheet development, formatting and printing tasks. If you don’t feel this level is for you, the Intermediate Excel or Excel fundamentals courses might be more suitable
This is a HANDS-ON workshop. Participants are expected to bring their own laptop computers. A mouse is good to have but not essential. Please note the software requirements mentioned under Notes above.
7 hours of hands-on instruction which will familiarize you with focused techniques on advanced level computing and reporting using Microsoft Excel, including many of the newer features introduced since version 2007.
Any regular business user or student who is proficient in Microsoft Excel and wishes to take their skills to an Advanced level and learn new features as well as new ways to use known features.
Our Partners
