Microsoft Excel 2013 Training Course Intermediate

Pivot Tables and more is only the beginning to this Excel intermediate training course. You will use Excel as a database being able to sort filter add generally work miracles with Data.

The large part of this intermediate training is dealing with Excel database functionality. The functions you will learn will be related to this allowing you to cross reference data and re-organise your data.

Other Excel training courses

Course Duration: 1 Day

Course Outline

Using Microsoft Excel Formulas

• IF Function
• Named Ranges
• VLookup Function

Conditional Formatting

• Creating the condition
• Data Bars
• Using Icons

Tables a new feature improved

• Creating a Table
• Formatting a Table
• Sorting & Filtering
• Using Table Functions in Excel 2013

Using Charts

• Creating a Chart
• Modifying Charts
• Formatting Charts
• Customising charts

Pivot Tables

• Creating Pivot Tables
• Re-Organising your Pivot Table
• Filtering Pivot Tables
• Using Slicers with Pivot Tables
• Pivot Charts

Incorporating Graphics

• Inserting Images from the Web
• Creating a Flowchart
• Using Smart Art graphics
• Grouping and Layering Graphics Objects

Templates what are they and how to use them?

• Using a Template
• Creating a Template
• Editing a Template

Intermediate Excel Prices from:

If you are interested in this course but want to know the price beforehand then use the the following form to calculate how much.

Skills learned: Pivot Tables

If you have a mountain of data to deal with. So long as it's it the correct format you can very quickly summarise and re-structure the data into appetising bite size chunks. Too many times do people spend many hours re-formatting their information so that it looks pretty when pivot tables are the solution.

You may also be interested in:

Microsoft Excel 2016 training course beginners

Microsoft Excel 2016 training course intermediate

Microsoft Excel 2016 training course advanced

Microsoft Excel Pivot Tables training course beginners

Microsoft Excel PowerPivot training course intermediate

Microsoft Excel 2013 Training Course - Beginners

Microsoft Excel 2013 Training Course - Advanced

Microsoft Excel 2010 Training Course - Beginners