Datrix Training offers Office Excel is a powerful tool you can use to create and format spreadsheets, and analyze and share information to make more informed decisions. With the Microsoft Office Fluent user interface, rich data visualization, and PivotTable views, professional-looking charts are easier to create and use. Microsoft Excel 2007 also offers more room for you to work in and delivers faster performance.
Print this course outline
MS EXCEL 2007 ADVANCED – 1 DAY COURSE
Module 1 – Conditional Formatting & Data Analysis in Excel 2007
Conditional Formatting
Applying Conditional Formatting Based on Top/Bottom Rules
Applying Specialized Conditional Formatting
Creating your own Formatting Rules
Managing Conditional Formatting
Clearing Conditional Formatting
Subtotals
How subtotal and grand total values are calculated
Summary functions for subtotalled lists
Consolidating Data
Selecting source areas for a consolidation table
Consolidate data by position
Consolidate data by category
Editing a data consolidation table
Group and Outline
Summarise data by outlining a worksheet
Module 2 – Pivot Table Analysisin Excel 2007
Pivot Tables
How a PivotTable calculates data
Using custom calculations in a PivotTable
How to create a Pivot Table
Formatting And Grouping
Hide a PivotTable Field
Show or Hide Items in a PivotTable Field
Add, Remove or Move a field in a PivotTable
Change the number format for the data area of a PivotTable
Group and Ungroup Data in a PivotTable
Pivot Table Pages
Pivot Charting
Module 3 – Introduction to Macrosin Excel 2007
The Excel Macro Recorder
Recording a Macro
Macro Tips
Use Relative Recording to make a Macro more flexible
