Excel Intermediate Course, Private 1-1

5.0
45 reviews
  • I truly enjoyed the class and the format it was present in, full of practical exercises, tips and ideas. Thank you, Sarah, for being such a great teacher.
    |
  • Mary from PC workshops ran a very comprehensive and interesting 1-1 workshop for Excel skills. The modules were organised well and could be adapted to my needs in work. All the staff I talked to were incredibly helpful and communications were always fast and friendly
    |
  • I had a fantastic day, lots of great information were provided. Would recommend.
    |

Vocational qualification

Online

Save 10%
£ 260 VAT exempt

Description

  • Type

    Vocational qualification Level 3

  • Methodology

    Online

  • Duration

    1 Day

Course summary

This Excel course is offered one-to-one, because we understand that profesionals have varying skill levels and varying applications. You already have the basic Excel skills but have many questions daily and want to be more proficient.

Important: If booking within 7 days of the date of the course, we will confirm availability within 24hours

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now closed

About this course

This course is lead by experienced professionals who concentrate on delivering quality training. The course content is organized into clear, well-structured and well-paced lessons with practical examples and exercises.

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
  • I truly enjoyed the class and the format it was present in, full of practical exercises, tips and ideas. Thank you, Sarah, for being such a great teacher.
    |
  • Mary from PC workshops ran a very comprehensive and interesting 1-1 workshop for Excel skills. The modules were organised well and could be adapted to my needs in work. All the staff I talked to were incredibly helpful and communications were always fast and friendly
    |
  • I had a fantastic day, lots of great information were provided. Would recommend.
    |
100%
5.0
excellent

Course rating

Recommended

Centre rating

Karen Keller

5.0
15/04/2021
About the course: I truly enjoyed the class and the format it was present in, full of practical exercises, tips and ideas. Thank you, Sarah, for being such a great teacher.
Would you recommend this course?: Yes

Benjamin Jewel

5.0
31/03/2021
About the course: Mary from PC workshops ran a very comprehensive and interesting 1-1 workshop for Excel skills. The modules were organised well and could be adapted to my needs in work. All the staff I talked to were incredibly helpful and communications were always fast and friendly
Would you recommend this course?: Yes

Lisa Northeast

5.0
14/06/2018
What I would highlight: I had a fantastic day, lots of great information were provided. Would recommend.
What could be improved: Nothing.
Would you recommend this course?: Yes

Steven Beddow

5.0
18/04/2018
What I would highlight: I would recommend this to anyone because this course turned out to be very useful for me and I'm sure it will be very useful for other people who need to extend their excel skills.
What could be improved: -
Would you recommend this course?: Yes

Maria Bosch

5.0
13/01/2018
What I would highlight: The fact that it was 1-1. The trainer is really excellent!
What could be improved: Nothing.
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

  • Bookkeeping
  • Excel
    2

    2 students say they acquired this skill

  • Accounting
  • Microsoft excel training
    2

    2 students say they acquired this skill

  • MS Excel
    1

    1 students say they acquired this skill

  • Pivot tables
    2

    2 students say they acquired this skill

  • Excel Tables
    2

    2 students say they acquired this skill

  • Excel Functions and Formulas
    2

    2 students say they acquired this skill

  • Excel Charts and Sparklines
    2

    2 students say they acquired this skill

  • Excel Graphics
  • Excel for Data Management
    2

    2 students say they acquired this skill

Teachers and trainers (1)

Mary  Smith

Mary Smith

Tutor

How Mary Smith teaches: I am consultative, flexible and understanding. I appreciate the trust given to me. What Mary Smith teaches: Databases, MS SQL Server, Oracle 11g, MySQL, Access Database, Excel, MS Power BI, Tableau, SSRS, MS SQL Server Report Builder. Java Coding Basics.

Course programme

Excel Intermediate Course Outline

Working with Functions and Formulas

  • Creating Formulae in Excel, general calculations
  • The Function Wizard
  • Using Functions in Excel: The 5 Popular functions
  • If- function
  • Working with Names and Ranges
  • Copying formulae
  • Lookups - Vlookup, Hlookup, Index, Match

Managing Tables

  • Working with Tables
  • Working with Records and Fields
  • Filters and Sorting, Freeze panes, split, protecting and unprotecting
  • Using Excel as a Database- Advanced filter
  • Pivot-tables

Adding the Finishing Touches

  • Adding Comments
  • Using Themes
  • Adding Text Boxes

Charts and Sparklines

  • Adding and Editing Charts
  • Adding and Editing Sparklines

Adding Graphics

  • Inserting SmartArt, Formatting SmartArt, Adding Symbols, Equations, and Shapes

Excel Intermediate Course, Private 1-1

£ 260 VAT exempt