Excel Intermediate 1-Day Course, Private 1-to-1, Webinar Virtual Classroom
Location
Online event
Refund policy
No Refunds
This practical, instructor-led, online course is designed to give you excellent techniques to improve your good already Excel Spreadsheet.
About this event
EXCEL INTERMEDIATE COURSE, PRIVATE 1-TO-1
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
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
Group and Outline, Range names,
Sub Totals
Functions: Commonly used Functions from the Function wizard and Formula Ribbon
Lookup Functions: Vlookup, Hlookup, Index, Match
Conditional Formatting
Filter and Advanced filter: Using Excel as a Database- Advanced filter , Auto filter, Sort
Pivot-tables
Create Pivot Table, Amend, Filter, Sort, Group Data, Format Pivot Tables, Add additional formulas, Refresh Data. Pivot Charts
Managing Tables
Working with Tables , Working with Records and Fields ,
Filters and Sorting,
Freeze panes, split,
Protecting and unprotecting
Charts and Spark Lines: Adding and Editing Charts , Adding and Editing Spark Lines
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