Excel Intermediate Course, One-to-One

Excel Intermediate Course summary

Excel Intermediate Course Description

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 the Excel Courses:
  • Excel Course Certificate on completion
  • Excel Course notes
  • Practical Excel Course exercises, Excel Course Homework / Excel Revision work
  • After the course, 1 free session for questions online Excel Course via Gotomeeting.com.
  • Max group size on this Excel Course is 4.
Special Offers
PCWorkshops London
Special Offer on the 'Visual Data with Power BI' Webinar
Read More
PCWorkshops Manchester
Special Offer: Python 3-weeks online Boot Camp
Read More
PCWorkshops Birmingham
Special Offer on the 'SQL Queries in 1-Day' webinar
Read More
PCWorkshops Southend-on-Sea
Special Offer on the 'Java Cross-Over for Coders' Webinar
Read More

Request a Free Webinar Demo

Try a 30 minutes webinar free. Choose you own topic from our course list.