25,000+ Courses Nationwide
0345 4506120

Excel Intermediate - One-to-One Training

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.

Select specific date to see price, venue and full details.

Course Content

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

Related Courses

Privacy Notice

In order to provide you with the service requested we will need to retain and use your contact information in accordance with our Privacy Notice. If you choose to provide us with this information you explicitly consent to us using the information as necessary to provide the requested service to you. If you do not agree please do not proceed to request the service from us.

Marketing Permissions

Would you like to receive our newsletter and other information on products and services which we think will be of interest to you by email. We will always treat your information with care and in accordance with our Privacy Notice. You are free to withdraw this permission at any time.

 

We work with the best