Excel Intermediate Course

Excel Intermediate Courses

Course FAQ's - Contact Us for your Bespoke Excel Course - What's Included

Book now

From £250

Choose your date for London and book here
Choose your date for Milton Keynes and book here
Choose your date for Southend-on-Sea and book here
Choose your date for Portsmouth and book here
Choose your date for Manchester and book here

Excel Intermediate Course, Private 1-to-1, PC and Mac Versions 2007 upwards

Course summary

This Excel course is offered one-to-one or in small group of up to 4, because we understand that profesionals have varying skill levels and varying applications. You already have the basic Excel skills but habe 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 24hours

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
Create Pivot Table, Amend, Filter, Sort, Format Pivot Tables, Add additional folmulas, 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

What is included:

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

Other Excel Courses

Is this the course for you? Book today and start preparing for the course

PCWorkshops specialises in Java Courses, Database courses and MS Project Courses.