Excel Intermediate Course

Excel Intermediate Courses

From £290 - FAQ's - Included - Course outline - Bespoke Course

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

Course summary

This Excel course is offered one-to-one You already have the basic Excel skills but have many questions daily and want to be more proficients.

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
- 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: copy only specified rows and columns from a large data set, auto mate this selective copy
Create Pivot Table, Amend, Filter, Sort, Format Pivot Tables, Add additional folmulas, Refresh Data.
Pivot Charts
Charts and Sparklines
Brief Overview of Charts and Sparklines

Other Excel Courses

What is included in this Excel Intermediate Course:

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
Tea, coffees, but no lunch
To assist after the course, 1 free session for questions online Excel Intermediate Course via Skype or Teamviewer.

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

PCWorkshops specialises in Coding Courses, Database Courses and MS Project Courses.