Enquiry Form

Duration: 1 Day

MICROSOFT EXCEL 2007 ADVANCED

Objectives

Upon successful completion of the course, delegates will have an understanding of and be able to use Excel for charting, and utilise essential features to enable them to create more complex worksheets and workbooks and advanced formatting.

Designed for

Existing users of Microsoft Excel 2007.

MODULE 1: CONDITIONAL FORMATTING AND DATA ANALYSIS

• Conditional Formatting
• Subtotals
• Consolidating Data
• Group And Outline

MODULE 2: PIVOT TABLE ANALYSIS

• Pivot Tables
• Displaying, Grouping And Moving Fields
• Refreshing Data In A Pivot Table
• Formatting A Pivot Table
• Pivot Table Report Filter Pages
• Pivot Charts

MODULE 3: INTRODUCTION TO MACROS

• Introduction To Macros
• The Excel Macro Recorder
• Using Macros
• Recording A Macro
• Running A Macro

MODULE 4: LOOKUP AND ANALYSING DATA

• Lookup Formulas
• Data Tables
• Data Analysis Toolpak

MODULE 5: MORE ABOUT CHARTING

• Combination Charts
• Plotting Missing Data
• Create, Apply, Or Remove A Chart Template

MODULE 6: WHAT IF ANALYSIS

• Goal Seek
• What Is Solver?
• Using Solver
• Scenarios