Excel Advanced Course, Private 1-1

PCWorkshops
5.0
19 reviews
  • Excellent day especially when you get taught one on one. It allows you to go at your own pace and don't have to worry about other people being faster than you.
    ← | →
  • Excel is a course that everyone just knows a little of but not a master of. Learning with Sarah makes it easy to learn the things that you know other people won't know.
    ← | →
  • I love it how it was a private 1 to 1 lesson. I was able to get full attention and learned a lot from that. Thank you for providing 1 to 1 lesson.
    ← | →

Short course

Online

£ 290 VAT exempt

The best Excel courses

See all

See all

Description

  • Type

    Short course

  • Level

    Advanced

  • Methodology

    Online

  • Duration

    1 Day

Excel Advanced features and functions

This Excel Advanced Course is for professionals who would like to use Excel to an advanced level. You work daily demands an intensive use of Excel spreadsheets and Excel databases. We offer this Excel course on a one-to-one basis, to tailor the training style and pace to your own requirements.

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now closed

About this course

To leave you with excellent, professional and in-depth Excel Skills

People who use spreadsheets daily for advanced calculations.

You need to have basic working knowledge of Excel.

Questions & Answers

Add your question

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

Fill in your details to get a reply

We will only publish your name and question

Reviews

5.0
excellent
  • Excellent day especially when you get taught one on one. It allows you to go at your own pace and don't have to worry about other people being faster than you.
    ← | →
  • Excel is a course that everyone just knows a little of but not a master of. Learning with Sarah makes it easy to learn the things that you know other people won't know.
    ← | →
  • I love it how it was a private 1 to 1 lesson. I was able to get full attention and learned a lot from that. Thank you for providing 1 to 1 lesson.
    ← | →
100%
5.0
excellent

Course rating

Recommended

Centre rating

Stuart Rose

5.0
11/06/2018
What I would highlight: Excellent day especially when you get taught one on one. It allows you to go at your own pace and don't have to worry about other people being faster than you.
What could be improved: -
Would you recommend this course?: Yes

Phil Mayles

5.0
20/04/2018
What I would highlight: Excel is a course that everyone just knows a little of but not a master of. Learning with Sarah makes it easy to learn the things that you know other people won't know.
What could be improved: .
Would you recommend this course?: Yes

Avril Adams

5.0
19/02/2018
What I would highlight: I love it how it was a private 1 to 1 lesson. I was able to get full attention and learned a lot from that. Thank you for providing 1 to 1 lesson.
What could be improved: .
Would you recommend this course?: Yes

Amanda Connor

5.0
18/12/2017
What I would highlight: I took Sarah's classes before and I still believe that is an amazing teacher. People who take her classes will know that she is worth coming back to.
What could be improved: nothing
Would you recommend this course?: Yes

Patricia Palmer

5.0
10/12/2017
What I would highlight: Sarah never fails to impress. She is an excellent teacher and I would love to learn with her again.
What could be improved: .
Would you recommend this course?: Yes
See all
*All reviews collected by Emagister & iAgora have been verified

This centre's achievements

2018

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 7 years

Subjects

  • Excel
  • Budgeting
  • Finance
  • Private
  • How to use Excel
  • MS Excel
  • Graphic representation
  • Spreadsheets
  • Charts
  • Data Analytics
  • Mathematical formulae

Teachers and trainers (1)

Sarah Barnard

Sarah Barnard

Coder, Instructor

Java Coding, Beginner - Advanced, JDBA, Hibernate, Spring. OO Programming. Android Studio. Excel VBA. Cobol. Databases, MS SQL Server, Oracle 11g, MySQL, Access Database, Excel, MS Power BI, Tableau, SSRS, MS SQL Server Report Builder.

Course programme

Excel Course Outline

General
Editing Standard Formatting Rules
Input Validate rules
Using Formulas in Conditional Formatting
Group and Outline
Filter and Sorting
Excel Tables and Advanced Filter
Working with Excel tables
Copy specific datasets from sheets, workbooks or external data
Consilidate
Goal seek, consolidate and scenarios
Using Form Templates
Creating Templates
Advanced Excel Lookup Functions
VLookup Function
Hlookup Function
Using the Index Function, Using the Match Function, Index and Match Together
Using the Indirect Function
Excel Advanced Functions
Using Error, Logical, Array, Rounding Functions
Advanced Excel Pivot Table Tools
Importing Pivot Table Data,
Calculated Fields in Pivot Tables,
Showing Pivot Data as a Percentage,
Creating Custom Pivot Tables Styles
Pivot Charts
Excel Macros
Creating, amending and deleting macros
Running macros
Macro menus, toolbars and shortcuts


What is included:

Excel Course Certificate on completion (assessment based)
Excel Course notes
Practical Excel Class exercises, Excel Course Homework / Excel Course Revision work
Tea, coffees, but no lunch
To assist after the course, 1 free session for questions online via Skype or Teamviewer.

Additional information

Excel

See related categories

Excel Advanced Course, Private 1-1

£ 290 VAT exempt

The best Excel courses

See all

See all