MS Excel 2007 Advanced
Our Advanced Excel course enhances users' knowledge by delving deeper into Excel's powerful data modeling and tools.
Designed for those already familiar with basic Excel concepts and spreadsheet use
Course Fees: Rs.1500/-
Duration: 8 Hours
Course Outline…
Data manipulation
Ø Automatic outlining
Ø Group and ungroup
Ø Filtering data
Ø Advanced filtering
Ø Sorting data
Ø Inserting Subtotals
Ø Creating an Advanced Filter
Ø Single input data tables
Ø Double input data tables
Formulas and functions
Ø Complex If statements
Ø Using nested functions
Ø Using named regions
Ø Using lookup functions
Ø Using database functions
Pivot Tables
Ø Overview of PivotTables
Ø The PivotTable Wizard
Ø Formatting PivotTables
Ø Rearranging PivotTables
Ø Sorting data
Ø Grouping data
Ø Using AutoShow
Ø Overview of PivotCharts
Ø The PivotChart Wizard
Collaboration
Ø Working with Shared Workbooks
Ø Reviewing Workbooks
Ø Sending Workbooks
Ø Tracking changes
Ø Resolving conflicts
Ø Merging Workbooks
Macros
Ø Recording a Macro
Ø Running a Macro
Ø Macro buttons
