Training Overview
This training is designed for power users or those who typically would produce spreadsheets of a more complicated nature and who wish to further develop their skills. Also for those wishing to analyses data using Excel as a database.
What you need to know beforehand:
You should have already attended Excel Intermediate training prior to this course and/or know how to create a basic IF Function and Vlookup.
Course Objectives
By attending this training workshop, you will learn –
- How to utilise the Add-ins in order to produce sophisticated reports containing relevant information.
- The power and adaptability of macros.
- Time efficient and effective creation, manipulation and reporting of data to support business decisions.
Course Content
- Using Excel as a Database
- Formatting as a Table
- Quick Analysis
- Nested IF Statements
- Combined Functions i.e. IF, Vlookup, And, Offset, Match, Choose
- XLOOKUP
- Sorting
- Filtering
- Data Validation
- Pivot Tables
- Slicers
- Forecast Sheets
- Using Views and Creating Reports
- Goal Seek
- Scenarios
- Data Tables
Have a question?
Let’s get this conversation started. Tell us a bit about your requirements and we’ll be in touch.
What you need to bring for these courses when delivered as a virtual classroom.
For virtual classroom courses, you will need:
- Computer with Internet Access
- Microphone and Headset
- Webcam
- Microsoft Teams
- A dual monitor setup is recommended for IT training