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
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: copy only specified rows and columns from a large data set, auto mate this selective copy
Pivot-tables
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 Java Courses, Database courses and MS Project Courses.