Create Pivot Tables and use Excel to work miracles with all your data. This 1 Day Microsoft Excel 2013 intermediate training course is available to run on most days, either at your own premises or at the local Cambourne Venue.
Microsoft Excel 2013 Training Course: Intermediate
Pivot Tables and more is only the beginning to this Excel intermediate 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 course is dealing with Excel database funcionality. The functions you will learn will be related to this allowing you to cross reference data and re-organise your data.
This 1 day Microsoft Excel 2013 Intermediate training course is available either at your premises or at the local Cambourne training venue.
Using Microsoft Excel Formulas
- IF Function
- Named Ranges
- VLookup Function
- 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
- Creating a Chart
- Modifying Charts
- Formatting Charts
- Customising charts
- Creating Pivot Tables
- Re-Organising your Pivot Table
- Filtering Pivot Tables
- Using Slicers with Pivot Tables
- Pivot Charts
- 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
To see a full list of training rates are available on our website, alterntaively each course page has a course calculator for your convenience.
The course outline is available to view here and via the website.
For a taster why not check out our Excel Bitesized Online Training Videos
Computer Tutoring have a reputation for quality and engaging training. Our many training courses are available either at your own premises or at a local computer tutoring training venue.