Description:
This six-hour course is developed for both self-taught users and those looking to expand their knowledge and comfort using Excel®. Advanced users will learn to link formulas and functions across multiple worksheets and workbooks. Using the tools built into Excel®, you’ll find how to control data entry using Data Validation. Expect to dig deeper into nesting functions, learning how to break down and understanding how to write them. Using PivotTables, you’ll view large amounts of data for understandable reports. Drill down to just the data you need by filtering out the unimportant data, and learn how to display the data in PivotCharts.
Primary Topics Covered:
- 3-D Linking
- Advanced List Tools
- Advanced Sort and Filter Options
- Nesting Functions
- PivotTables and PivotCharts
Pre-requisites: A general knowledge of Excel® that includes:
- Excel Intermediate prerequisites
- Ability to create formulas including those that use functions such as IF and VLOOKUP
- Familiarity with data management tools such as sort and filter
- Basic understanding of charts