01. January 2019 - 11:00 till 18:00
Share it on:

Excel Intermediate 1-Day Course, Private 1-to-1, Birmingham | One Victoria Square | Tuesday, 01. January 2019

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 

Pivot-tables 

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.