_Banner_Advanced_Formulas_Functions-Red.webp)
Chapter 1
Formula and Function Tips & Shortcuts
Displaying & Highlighting Formulas
Chapter 1
Formula and Function Tips & Shortcuts
Using Auditing Tools
Chapter 1
Formula and Function Tips & Shortcuts
Using Entire Row & Column References
Chapter 1
Formula and Function Tips & Shortcuts
Copying Column Formulas Instantly
Chapter 1
Formula and Function Tips & Shortcuts
Converting Formulas to Values with a Drag
Chapter 1
Formula and Function Tips & Shortcuts
Updating Values Without Formulas
Chapter 1
Formula and Function Tips & Shortcuts
Debugging Formulas with the F9 Key
Chapter 1
Formula and Function Tips & Shortcuts
Enhancing Readability with Range Names
Chapter 1
Formula and Function Tips & Shortcuts
Tabulating Data from Multiple Sheets
Chapter 2
Formula and Function Tools
Hierarchy of Operations in Formulas
Chapter 2
Formula and Function Tools
Formulas Tab for Locating Functions
Chapter 2
Formula and Function Tools
Insert Function for Learning about Unfamiliar Functions
Chapter 2
Formula and Function Tools
Extending the Capabilities of AutoSum
Chapter 2
Formula and Function Tools
Absolute and Relative References
Chapter 2
Formula and Function Tools
Using Mixed References in Formulas
Chapter 2
Formula and Function Tools
Using Autocalculate in the Status Bar
Chapter 3
IF and Related Functions
IF Logical Tests
Chapter 3
IF and Related Functions
Expanding Nested IF Statements
Chapter 3
IF and Related Functions
AND, OR, and NOT Functions with IF
Chapter 3
IF and Related Functions
Using IFS for Multiple Conditions
Chapter 4
Lookup and Reference Functions
Looking up Information with VLOOKUP & HLOOKUP
Chapter 4
Lookup and Reference Functions
Finding Approximate Matches with VLOOKUP & HLOOKUP
Chapter 4
Lookup and Reference Functions
Finding Exact Matches with VLOOKUP
Chapter 4
Lookup and Reference Functions
Nesting Lookup Functions
Chapter 4
Lookup and Reference Functions
Using VLOOKUP with Large Tables
Chapter 4
Lookup and Reference Functions
Finding Table-Like Info within a Function using CHOOSE Function
Chapter 4
Lookup and Reference Functions
Using the SWITCH Function for Formula-Embedded Selection
Chapter 4
Lookup and Reference Functions
Locating Data with the MATCH Function
Chapter 4
Lookup and Reference Functions
Retrieving Information by Location
Chapter 4
Lookup and Reference Functions
Using MATCH and INDEX Functions Together
