Key features:
- Important data fundamentals and useful shortcuts
- Quick overview of Sorting and Filtering spreadsheet data
- Quick re-cap of writing basic formulas for calculations – percentages, averages, SUM, etc…
- Techniques for applying formula calculations to datasets
- Arranging data & creating tables from scratch – best practices
- Working with Dates & Time
- Writing LOGICAL formulas to check and make decisions on what to calculate/ display – IF, SUMIFs, COUNTIFs
- Finding & copying data with XLOOKUP
- Understanding Dynamic Arrays.
