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.
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
Recent reviews
Interactive learning, close support. Would recommend others to take the course
Abby G24 Apr 23