Microsoft Excel

Features

• 16 hours of business focused Excel
• Practice spreadsheets   Taught through a trainer led class

Outlines

Section 1: Foundation

• Excel Introduction
• The Excel Interface
• Basic Navigation and Editing
• Getting Going

Section 2: Orientation and Efficiency

• Editing
• Viewing
• Spreadsheet Structure
• Cell References
• Named Ranges
• Basic Macros
• Design

Section 3: Administration

• Customizing Excel
• Housekeeping
• Connecting Workbooks
• Documentation
• Protecting and Sharing
• Google Docs
• Excel Troubleshooting

Section 4: Data Handling

• Sorting and Filtering
• Controlling User Input
• Working with Dates and Times
• Working with Text
• Lookup and Reference
• Logical Functions

Section 5: Data Analysis

• Working with Numbers
• Summarizing Data
• PivotTables 1 - Simple Summaries
• PivotTables 2 - Manipulating Data
• PivotTables 3 - Interpreting Data
• PowerPivot: Handling Big Data
• Formula Auditing
• Advanced Macros and VBA
• Modelling

Section 6: Presentation

• Cell Formatting
• Number Formatting
• Conditional Formatting
• Graphs and Charts
• Page and Print Setup

Certificate:

Log In Certificate of Completion will be provided to delegates who attend and complete the course.