EXCEL INTERMEDIATE COURSE, 1-TO-1, ONLINE
COURSE SUMMARY
This Excel course is offered one-to-one or in small group of up to 4, because we understand that professionals have varying skill levels and varying applications.
We run the class in our Virtual Online Classroom, Instructor-led, Practical, Interactive.
You already have the basic Excel skills but have many questions daily and want to be more proficient.
COURSE OUTLINE
Hour 1: Working with Functions and Formulas
· Creating Formulae in Excel, general calculations
· The Function Wizard
· Using Functions in Excel: The 5 Popular functions
· Working with Names and Ranges
· Copying formulae
· Remove duplicates, data validations, drop lists
S ubtotals:
· Group and Outline, Range names,
· Sub Totals
Hour 2: Functions
· CountBlanks, Count Non numeric cells, Count numeric cells
· If Function, Nested if
· And and Or functions
Hour 3:
· Vlookup, Hlookup, Index, Match
· Sumifs, averageifs, countifs, maxifs, minifs
Hour 4: Sheet linking and file linking
· Working with multiple files and sheets,
· Linking files and sheets with formulae.
· Updating files
Consolidate:
· Create functions using labels and not cell references
Templates:
· Create and save a template file with formulae,
· Protecting and unprotecting formula cells
Hour 5: Pivot-tables
· Create Pivot Table, Amend, Filter, Sort, Group Data, Format Pivot Tables, Add additional formulas, Refresh Data. Pivot Charts
Hour 6: Finding Trends
· Conditional Formatting
· Add, remove, format Spark Lines
Managing Tables
· Working with Tables , Working with Records and Fields ,
WHAT IS INCLUDED:
- Certificate on completion
- Course notes
- Practical Class exercises, Homework / Revision work
- To assist after the course, 1 free session for questions online
