About this course
About the course
The goal of this live interactive practical webinar is to consolidate existing knowledge of Microsoft Excel and to add to it with technical and useful functions and procedures.
Course Objectives
- Refresh and consolidate existing knowledge
- Understand use of IFs, Nested IFs and SUMIF
- Apply Conditional Formatting
What you will learn
Course Content
- Existing Knowledge Refresh
- Calculations and Percentages
- Advanced Absolute Referencing
- Conditional Formatting / Sparklines
- The IF Function
- Using Nested IFs
- The SUMIF function for Analysis and Reconciliation
- VLOOKUP and XLOOKUP for Range and Non-Range Lookups
- External Cell Referencing and Linked Documents
- Paste Special
- Questions, Answers and Requests
Schedule
- Session One – 45 min
- Practical Exercises and break – 15 min
- Session Two – 45 min
- Practical Exercises and break – 15 min
- Session Three – 45 min
- Practical Exercises and break – 15 min
- Q&A – 30 min
Recent reviews
Glyn was very engaging and explained all the relevant tools in detail. He made the content feel less daunting and answered any queries i had straight away. Would definitely recommend.
Excellent course. It was presented in a way that was very easy to follow. I thought the format of the instructor performing tasks and explaining them and then giving the attendees a chance to replicate the tasks and ask questions was very effective. I also enjoyed how it progressed from basic tasks that were used as a foundation to build upon with more complex skills later on. I really took away a lot that I will be able to use in the future.
Pivot Tables was my main learning objective from the session, and this was suitably covered.