Microsoft Excel 2013 Intermediate

Duration: 1 Day
Costs: Open courses: From £245 + VAT
In-house: Price on application - request a quote >>
Aims: This course is aimed at regular users of Excel who are familiar with the basics and who need to broaden their knowledge of Excel.
Objectives: On completion of this course, attendees will be able to: create and apply formulas that include statistical, logical, lookup and date functions; apply formatting based on conditions; work across multiple sheets; write formulas to link sheets and workbooks; use a variety of tools to manage and extract data from lists; create a basic PivotTable to summarise data; create and modify charts.
Pre-requisites: Attendees should have attended our Excel Foundation course or have equivalent knowledge. Before attending this course, attendees must be confident with creating basic formulas (+-/*), use of AUTOSUM, copying formulas and an awareness of $ within formulas.

Course Outline

Introduction of Named Ranges

  • Recap Absolute cell references (the use of the $ sign in formulas)
  • Define Named Cell Ranges
  • Edit and Deleting Named Ranges
  • Use Named Ranges in Formulae

Further Formulae and Functions

  • Introduction to the IF function
  • Use SUMIF, COUNTIF, COUNTBLANK & AVERAGEIF functions
  • Introduction to the VLOOKUP function
  • Calculate dates with NOW and TODAY functions

Work with Multiple Sheets and Workbooks

  • Group and ungrouping worksheets
  • Organise Windows
  • Link formulas across Worksheets and Workbooks
  • Edit links

Work with Data Lists

  • Multi Criteria Sort and Filter
  • Use Find and Replace
  • Work with the "format as a table" feature
  • Create automatic Subtotals

Introduction to Conditional Formatting

  • Cell Rules
  • Apply Top-Bottom Rules
  • Apply Data bars, Gradient fills, Icon sets

Introduction to PivotTables

  • Create a PivotTable from an Excel data list
  • Add/remove/reorganise data fields
  • View data in more detail
  • Change how values are summarised
  • Refresh data/change data source
  • Filter PivotTable with Slicers/Timelines
  • Create and modify a PivotChart

Charts

  • Create and modify charts such as Pie, Column & Line
  • Format charts to enhance their presentation
  • Print charts

Work with Sparklines

  • Create, format and delete Sparklines

 

In-House Training

If you have a number of people in your organisation with the same training need, in-house training programmes are an ideal solution.

We pride ourselves on delivering training that is relevant to your business – ensuring staff see the benefits and how they can save time and work more efficiently.

We can deliver both tailored training sessions or the more traditional Foundation, Intermediate and Advanced levels.

Delivery Methods

Training can be delivered at your offices or we can help to select a suitable venue. We can deliver training in various different ways with the more popular being:

  • Group classroom training
  • 1-to-1 training sessions to address individual needs
  • Webinars/Online training

Laptop Hire

Laptop hire is available for most of our courses. We provide PC laptops with the appropriate software pre-loaded as well as projectors, mice and power extension leads.

Pre-Course Skills Assessments

Our focus is always on providing the most relevant training for each client. Before any course we offer pre-course assessments in order for us to ascertain your exact requirements, so you don't waste any time or money on training that isn't right for you and your business.

Course Materials

We provide electronic step by step training reference manuals and issue attendance certificates on completion of the training. That way once we finish, you'll still have everything you've learned at your fingertips.

Post Training Support

In order to make sure you get the best service and expertise from TrainingU, we offer unlimited lifetime post training support giving you peace of mind, should you need help with anything.

Open Course Dates

Dates Venue Offer Prices  
11 January 2018 St Albans   £245 Book
Now
28 March 2018 St Albans   £245 Book
Now
15 May 2018 St Albans   £245 Book
Now
5 July 2018 St Albans   £245 Book
Now
19 September 2018 St Albans  £195 £245 Book
Now
13 November 2018 St Albans  £195 £245 Book
Now

We offer with all our public scheduled courses:

  • Free pre-course skills assessment
  • Lunch and refreshments
  • Course reference guide
  • Attendance certificate
  • Lifetime post training support
  • Small groups of up to 8 people

Courses start at 9:30am and finish at 4:30pm