Intermediate Level Excel

Description

The goal of this course is to consolidate existing knowledge and to add to it with technical and useful functions and procedures.

What you will learn

Objectives

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

Contents

• 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
• The COUNTIF Function
• VLOOKUP in Detail for Range and Non-Range Lookups
• Using IFNA and ISNA with lookups
• External Cell Referencing and Linked Documents
• Paste Special
• Charts in Detail
• Standard Data Filters
• Questions, Answers and Requests