Advanced Microsoft Excel 2013 Training Courses

Short course

In Twickenham

£ 295 + VAT

Description

  • Type

    Short course

  • Location

    Twickenham

  • Duration

    1 Day

  • Start date

    Different dates available

This course aims to give delegates an in-depth knowledge of Excel 2013 features.

                              

Facilities

Location

Start date

Twickenham (Middlesex)
12 Northcote Road, TW1 1PA

Start date

Different dates availableEnrolment now open

About this course

On completion of the course delegates will have advanced skills in using Microsoft Excel 2013. They will be able to:

Link multiple workbooks
Print workbooks
Use one and two-way data tables
Audit a worksheet
Create and use PivotTables and reports
Use Solver, Scenario Manager and Goal Seek tools
Use Excel workgroup features
Create and use macros

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

This centre's achievements

2016

All courses are up to date

The average rating is higher than 3.7

More than 50 reviews in the last 12 months

This centre has featured on Emagister for 14 years

Subjects

  • MS Excel
  • Excel
  • Microsoft excel training
  • Microsoft Excel
  • Data Analysis Tools
  • Goal seek
  • <br /> Solver
  • Scenario manager
  • SmartArt graphics
  • PivotTables
  • Tracing errors

Course programme

Using multiple workbooks

Using a workspace
Printing workbooks

Printing and previewing multiple worksheets
Custom views
Display

Using one-input or two-input data tables
Protection

Protecting and unprotecting a worksheet with a password
Protecting and unprotecting designated cells in a worksheet with a password
Security

Adding password protection to a workbook
Removing password protection from a workbook
Creating a shared workbook

Tracking changes

Highlighting
Accepting
Rejecting
Sorting

Sorting data by multiple columns
Performing custom sorts
Querying/filtering

Creating a single or multiple criteria query using available options
Using advanced query/filter options
Templates

Using a template
Editing a template
Auditing a worksheet

Tracing errors
Tracing dependents
Tracing precedents
Adding, removing and editing worksheet comments
PivotTables and Reports

Creating a PivotTable report
Creating a PivotChart report
Resetting a summary function in a PivotTable report
Creating a PivotTable report for the World Wide Web
Data Analysis Tools

Goal Seek
Solver
Scenario manager
SmartArt graphics

Creating a SmartArt graphic
Formatting SmartArt
Changing SmartArt graphic layout
Changing SmartArt graphic colours
Macros

Recording macros
Running macros
Editing macros

Additional information

Course Type Cost per day
1 to 1 training £295
2 to 4 delegates £455
5 to 8 delegates £595
Prices are PER DAY, and NOT per-person! E.g. if there’s 5 people on the course, you pay £595. All prices exclude VAT

Advanced Microsoft Excel 2013 Training Courses

£ 295 + VAT