State ID: IAA34
-- OR --
Select at least one option to generate PDF.
Develop skills in advanced analysis and automation tools using Microsoft Excel.
This course teaches participants how to successfully produce spread sheets for their business management and information analysis needs.
- Lookup and reference functions
- Modifying Excel options
- Customised formatting of charts
- Labels and names in a workbook
- Data protection
- Summaries using subtotals
- Data linking and consolidation
- Pivot tables, group cells and outlines
- Using the solver tool
- Using macro recorder