Live Webinar - Microsoft Excel Intermediate (2 Days)

Description

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