top of page
Tools and Concepts:
1. Range
2. Rearranging data using PIVOT TABLE
3. Transforming data using POWER QUERY
4. Parsing text from one cell into many using TEXT TO COLUMN
5. Error Handling
6. Adding dates
8. Conditional Formatting
Formulas:
1. Looking up values using VLOOKUP
2. Looking up values using INDEX/MATCH
3. Looking up values using XLOOKUP
4. Adding only the rows I want using SUM/SUMIFS
5. Counting stuff that I want using COUNTIFS
6. Getting low/high or average value using MIN/MAX/AVERAGE
7. Multiply and add at once using SUMPRODUCT
8. Using formula typed in an another cell via INDIRECT
9. If cell value is this do this, if that do that using IF/ IFS
10. Extracting unique values using UNIQUE
Main
All Lessons
Cold Calling Lessons
Bookkeeping Lessons
Excel Lessons
Excel Virtual Classes
More...
Use tab to navigate through the menu items.
bottom of page
