Microsoft Excel 2007 (Advance)

This course provides delegates with a comprehensive review of Microsoft Excel 2007 at advanced level. The course is therefore designed for those who want to become proficient in performing advanced tasks such as creating nested functions, working with data tables, exporting and importing data performing what-if analyses, and recording macros.

This Microsoft Excel 2007 Advanced course is the last of a 3-Level program, designed to enable delegates to acquire sufficient skills and knowledge in Excel at advanced level.  

Packed with exercises, this course engages delegates in activities associated with advanced analysis tools including PivotTables, Solver, Outlining and Summarising as well as some key automation features such as Macros.    

Upon completion of this course, delegates will know how to:

• Use a Range of Lookup and Reference Functions
• Modify Excel Options.
• Create and Use Labels and Names in a Workbook.
• Protect Data in  Worksheets and Workbooks.
• Summarise Data using Subtotals and Relative Range Naming
• Use Data Linking to Create more Efficient Workbooks
• Combine data from several workbooks into one
• Understand and Create PivotTables
• Construct and Operate PivotTables using some of the ore advanced techniques
• Use Goal Seeking to determine the Values Required to Reach a Desired Result
• Group Cells and Manipulate Worksheets
• Use Solver to Solve More Complex and Intricate Problems
• Create Recorded Macros
• Use the Macro Recorder to Create a Variety of Macros