Course Objectives
After completing this course, students will be able to:
- Using multiple worksheets, workbooks and workspaces
- Working with Financial functions
- Use advanced formatting techniques
- Using the Auditing Tools to track information
- Using charts to display financial data
- Use Templates
Who Should Attend?
This course takes users to a high level of knowledge using financial topics available in Excel such as Financial functions, auditing and Charts.
Pre-requisite
- Delegates should understand any of the following operating systems: Windows 2000 or above
- Delegates should have a good understanding of Microsoft Excel or alternatively should have attended our Essentials course.
Course Outlines
- Creating Sparklines
- Inserting Charts
- Inserting PivotTables
- Inserting PivotCharts
- Using Slicers
- Creating Timelines
- Inserting SmartArt
- Inserting Text Boxes
- Inserting Pictures
- Inserting Equations
- Drawing Shapes
- Understanding Relative and Absolute Cell References
- Using Multiple Cell References
- Using 3D References
- Using Array Formulas
- Using the PMT Function
- Using the FV Function
- Using VLOOKUP and HLOOKUP Functions
- Using IF, AND, OR Functions
- Outlining Data
- Showing and Hiding Outline Details
- Grouping Data
- Creating Subtotals
- Removing Outlining and Grouping