Microsoft Excel Intermediate

Course Introduction

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.

There will be 3 x 45 minute sessions with practical exercises and breaks in-between. There will be a 30 minute Q&A at the end of the webinar.

Course Objectives

• Refresh and consolidate existing knowledge
• Understand use of IFs, Nested IFs and SUMIF
• Apply Conditional Formatting

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 in Detail 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