Product Description
Formula and Function Tips and Shortcuts 37m 48s
- Displaying and highlighting formulas 5m 10s
- Auditing tools 4m 38s
- Using entire row/column references 3m 43s
- Copying column formulas instantly 3m 11s
- Converting formulas to values with a simple drag 3m 32s
- Updating values without formulas 2m 55s
- Simplifying debugging formulas 3m 51s
- Enhancing readability with range names 5m 50s
- Creating 3D formulas to gather data from multiple sheets 4m 58s
2. Formula and Function Tools 24m 12s
- Understanding the hierarchy of operations in Excel formulas 3m 19s
- Using the Formulas tab on the Ribbon for locating functions 3m 14s
- Using the Insert Function button for guidance with unfamiliar functions 4m 36s
- Using and extending AutoSum button capabilities 5m 6s
- Using absolute and relative references in formulas 3m 30s
- Using mixed references in formulas 4m 27s
3. IF and Related Functions 15m 42s
- Exploring IF logical tests and using relational operators 3m 33s
- Creating and expanding the use of nested IF statements 4m 22s
- Using the AND and OR functions with IF to create compound logical tests 7m 47s
4. Lookup and Reference Functions 41m 58s
- Looking up information with VLOOKUP and HLOOKUP 3m 57s
- Finding approximate matches with VLOOKUP 7m 27s
- Finding exact matches with VLOOKUP 4m 47s
- Nesting lookup functions 4m 11s
- Using VLOOKUP with large tables 3m 23s
- Finding table-like information within a function with CHOOSE 3m 34s
- Locating data with MATCH 4m 35s
- Retrieving information by location with INDEX 2m 46s
- Using MATCH and INDEX together 7m 18s
5. Power Functions 10m 22s
- Tabulating information using a single criterion with COUNTIF, SUMIF, and AVERAGEIF 5m 9s
- Tabulating information using multiple criteria with COUNTIFS, SUMIFS, and AVERAGEIFS 5m 13s
No comments:
Post a Comment