Menu
  1. Home
  2. Microsoft
  3. Excel
  4. Certified
  5. Excel Intermediate Course, Private 1-to-1, Live Virtual Classroom
Enquire Now

Excel Intermediate Course, Private 1-to-1, Live Virtual Classroom

Study Method
Online
Institution
PCWorkshops
Start Date
Enrol anytime

Course overview

This Excel course is offered one-to-one or in a small group of up to 4, because we understand that professionals have varying skill levels and varying applications. You already have the basic Excel skills but have many questions daily and want to be more proficients.

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

Expand all and read more

Study method

  • Online
  • Blended
  • In-class
xo-logo

coursesonline.co.uk customers are now eligible to apply for an XO Student Discount Card.

Enrol in a course today to unlock exclusive deals.

Duration study load

  • 1 Day

Course features

  • Excel Intermediate course certificate on completion (assessment based)
  • Excel Intermediate course notes
  • Practical Excel Intermediate course exercises, Excel Intermediate course homework/Excel Intermediate course revision work
  • To assist after the course, 1 free session for questions online Excel Intermediate course via Skype/Teamviewer

Subjects

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
  • Create a Pivot Table, Amend, Filter, Sort, Format Pivot Tables, Add Additional Formulas, Refresh Data.
  • Pivot Charts
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
Want more information about the subjects for this course?
Get the course guide

Payment options

Course fees – £220

  • No government funding available for this course
Find out more about the payment options for this course
Get the course guide

About PCWorkshops

PCWorkshops mission is to be an integral partner to companies who up-skill and cross-skill their software and data staff.

We are based in London, Milton Keynes, Southend-On-Sea, Birmingham, Portsmouth and Manchester.

Our clients are in a variety of industries, e.g. e-commerce companies,
finance companies, insurance companies, software and technology companies and more.