Intermediate Excel 2007
(ZCMP-049)
Topics for experienced Excel users include using sophisticated formulas and functions, outlining, customizing the toolbar, data protection, sorting, finding and extracting using data functions, graphics features, drawing tools, advanced printing techniques, and defining and using macros to automate. Topics include:
- Managing workbook data
- Setting print areas
- Using advanced formulas
- Analyzing table data
- Working with macros
- Enhancing charts
Prerequisite: How to Use Microsoft Excel
Prepare for Microsoft Certified Application Specialist (MCAS)
