About this course
The goal of this course is to consolidate existing knowledge and to add to it with technical and useful functions and procedures.
There will be 2 x 3.5-hour sessions with practical exercises and breaks in-between.
What you will learn
Course Objectives
- Refresh and consolidate existing knowledge
- Understand use of IFs, Nested IFs and SUMIF
- Apply Conditional Formatting
Course Contents
- Day 1
- Existing Knowledge Refresh
- Calculations and Percentages
- Advanced Absolute Referencing
- Conditional Formatting / Sparklines
- The IF Function
- Day 2
- Day 1 Recap
- Using Nested IFs
- The SUMIF function for Analysis and Reconciliation
- VLOOKUP in Detail for Range and Non-Range Lookups
- External Cell Referencing and Linked Documents
- Paste Special
- Questions, Answers and Requests
Recent reviews
A good course with a very patient trainer! Just need time to put what I learned to the test in the working environment.
Helen W15 Oct 21
Overall good webinar.
Deepak K15 Oct 21