Cancelled: Excel 2007/2010 Advanced Part 1: Functions, Pivot Tables and Tips (133142-13)
Description
Professionals who work with Excel every day will benefit from these
advanced topics. This fast-paced program covers range naming,
decision-making IF and VLOOKUP functions, financial functions, Pivot
Table reporting, controlling calculation inputs, securing files, formula
auditing, external formula linking, many multiple worksheet tips and
time-saving usage of the macro recorder. (Format: “hands-on,
instructor-led training”)
Learning Objectives
Learn to use advanced functions for IF testing and Lookup
Understand how to use the Excel Pivot Table feature to report data summaries in seconds Incorporate a variety of multiple worksheet tips and external formulas linking
Understand range naming, formula auditing, conditional formatting and protecting features
Learn how the macro recorder can save time with repetitive tasks
Major Topics
Learn to use advanced functions for IF testing and Lookup
Understand how to use the Excel Pivot Table feature to report data summaries in seconds Incorporate a variety of multiple worksheet tips and external formulas linking
Understand range naming, formula auditing, conditional formatting and protecting features
Learn how the macro recorder can save time with repetitive tasks
Provider
SCG Training & Consulting
Course Level
Advanced
CPE Field of Study
Computer Science*
8
Prerequisites
Intermediate/Advanced knowledge of Microsoft Excel
