Description:
Primary Topics Covered:
- Using Excel Advanced Tools
- Advanced Functions
- Advanced Sort and Filter Options
- Using Pivot Tables and Charts
Excel Advanced builds on what you learned in Intermediate. This class is for those already comfortable with formulas, the basics of charting, and managing data lists. We’ll spend six hours digging deeper into the possibilities of Excel. You’ll learn to link cells, sheets and workbooks using both 3-D formulas and Functions, as well as built in tools for consolidating data. The course will provide the opportunity to view large amounts of data using PivotTables and Charts for understandable reports. You’ll see how easy it is to drill down to just the data you need, filtering out the unimportant data.
Knowledge, skills and experience required for this course:
- 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