Microsoft Excel 2013 Training Course: Intermediate


Cambridge Cambourne Training Venue

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. 

Dates Thursday, September 12, 2019 - Download as vCalendar
Event Times: 06:00
Venue This 1 day course can either be held at your premises or at the local Cambridgeshire venue in Cambourne on a date suitable for you.
Contact Name Cindy
Email info@computertutoring.co.uk
Contact Phone 0800 158 3588
Website Event website

Event details:

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. 

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

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.