Excel Intermediate

by PCWorkshops

Discover powerful Excel techniques in an interactive, instructor-led, live Virtual Classroom.

$185

Contact the Institutes

Fill this form

Advertisement

PCWorkshops Logo

img Duration

1 Day

Course Details

This course covers the essential Excel Intermediate, in our interactive, instructor led Live Virtual Classroom. You already know your way around Excel e.g. you understand some of the functionality on the Home Ribbons, can move around and format cells. etc.

In the Excel intermediate course we cover in-depth functions and Formulae so that you will be able to create fantastic spreadsheets like budgets, forecasts, and more. You will be able to understand and unravel the complicated formulae created by your colleagues.
During the course you will excellent spreadsheets so that you have examples to take away.

 

  • Location: Instructor-led, Online.

  • Our Style: Hands-on, Practical Course.

  • Group Size: Max 4 people per group.

  • Qualification: PCWorkshops Excel Intermediate Certification

  • Hours: 1 Day, 10am-5pm

 

 

Outline:

  • Working with Functions and Formulas

  • The Function Wizard

  • Using Functions in Excel: The 5 Popular functions

  • If-else function

  • Working with Names and Ranges

  • Copying formulae

  • Creating Formulae in Excel, general calculations.

 

Lookups:

  • Vlookup,

  • Hlookup,

  • Index,

  • Match.


Formatting a Range as a Table:

  • Properties and behaviour of a table.


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: copy only specified rows and columns from a large data set, auto mate this selective copy.


Pivot-tables:

  • Create Pivot Table, Refresh Data.

  • Amend, Filter, Sort,

  • Format Pivot Tables,

  • Add additional Pivot formulae.


Pivot Charts:

  • Excel Pivot Charts and Sparklines.

  • Examples and exercises with Pivot Charts and Sparklines.

 

Other Excel Courses

Included with the Excel Intermediate Courses

  • PCWorkshops Excel Intermediate Certificate on completion

  • Excel Intermediate Notes

  • Excel Code Examples

  • Practical Excel Intermediate exercises

  • Personal attention in a small group of up to 4 delegates

  • WC2N Branch

    Golden Cross House, 8 Duncannon Street, WC2N, London
  • M2 Branch

    53 Fountain Street, M2, Manchester
  • MK9 Branch

    Exchange House, 494 Midsummer Boulevard, MK9 , Milton Keynes
  • City Centre Branch

    One Victoria Square, City Centre, Birmingham
  • Cosham Branch

    Ground Floor, Building 1000, Lakeside North Harbour, Western Road, Cosham, Portsmouth
  • Teacher's Name
  • Sarah Barnard
  • Teacher's Experience
  • 10 Years
  • Gender
  • N/A
  • Teacher's Nationality
  • British

© 2025 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy