Summary
The goal of this course is to consolidate existing knowledge and to add to it with technical and useful functions and procedures.
What we will cover
- 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
- COUNTIF for further Analysis
- VLOOKUP in Detail for Range and Non-Range Lookups
- External Cell Referencing and Linked Documents
- Paste Special
- Questions, Answers and Requests
By the end of this course you will:
Refresh and consolidate existing knowledge
Apply Conditional Formatting
Understand use of IFs, Nested IFs and SUMIF
