This practical instructor-led online course is designed to give you excellent techniques to improve your already good Excel spreadsheet.
About this Event
EXCEL INTERMEDIATE COURSE PRIVATE 1-TO-1
COURSE SUMMARY
This Excel course is offered one-to-one or in a 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.
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 formulas in Excel general calculations
- The Function Wizard
- Using Functions in Excel: The 5 Popular functions
- If-function
- Working with Names and Ranges
- Copying formulas
- VLOOKUP
- HLOOKUP
- Index Match
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
- Using Excel as a Database: Advanced filter
Charts and Sparklines
- Adding and Editing Charts
- Adding and Editing Sparklines
WHAT IS INCLUDED:
- Certificate on completion
- Course notes
- Practical Class exercises Homework / Revision work
- To assist after the course
Event Venue
Online
Tickets
USD 150.00
