Call us on FREEPHONE

Breaking News "CHECK OUT OUR LAST MINUTE DEALS BUTTON FOR FANTASTIC SAVINGS" NOT TO BE MISSED! How to increase your profits - 1 day Email Marketing Course - Call 0800 0234407

Main Menu

Microsoft Excel 2010 Training: Intermediate

Enrolment Form

Click to Download

For a No Obligation Quote Simply Fill-in the Form at the bottom of the page.

Course Overview

“I came on the Microsoft Excel course to learn how to use Excel in a quicker, more efficient way. The course exceeded my expectations, I came away with lots of tips and shortcuts which will help me back at work. Very good value for money” – Sue – Africa & Beyond Ltd

Skill Level: 2 Intermediate

Duration: 1 Day

Description: This intermediate Microsoft Excel Course is meant for those desiring to gain advanced skill sets necessary for calculating data using functions and formulas, sorting and filtering data, using PivotTables and PivotCharts for analyzing data, and customizing workbooks.

Topic 1: Calculating Data with Advanced Formulas

Topic 1A: Apply Cell and Range Names
Topic 1B: Calculate Data Across Worksheets
Topic 1C: Use Specialized Functions
Topic 1D: Analyze Data with Logical and Lookup Functions

Topic 2: Organizing Worksheet and Table Data

Topic 2A: Create and Modify Tables
Topic 2B: Format Tables
Topic 2C: Sort or Filter Data
Topic 2D: Use Functions to Calculate Data

Topic 3: Presenting Data Using Charts

Topic 3A: Create a Chart
Topic 3B: Modify Charts
Topic 3C: Format Charts

Topic 4: Analyzing Data Using PivotTables, Slicers, and PivotCharts

Topic 4A: Create a PivotTable Report
Topic 4B: Filter Data Using Slicers
Topic 4C: Analyze Data Using PivotCharts

Topic 5: Inserting Graphic Objects

Topic 5A: Insert and Modify Pictures and ClipArt
Topic 5B: Draw and Modify Shapes
Topic 5C: Illustrate Workflow Using SmartArt Graphics
Topic 5D: Layer and Group Graphic Objects

Topic 6: Customizing and Enhancing the Excel Environment

Topic 6A: Customize the Excel Environment
Topic 6B: Customize Workbooks
Topic 6C: Manage Themes
Topic 6D: Create and Use Templates