| Date | yes | |
| Add (Subtract) Days to a Date | |  |
| Concatenate Dates | | |
| Convert Date to Number | | |
| Convert Date to Text | | |
| Month Name to Number | | |
| Create Date Range from Dates | | |
| Day Number of Year | | |
| Month Name from Date | | |
| First Day of Month | | |
| Add (Subtract) Weeks to a Date | | |
| If Functions with Dates | | |
| Max Date | | |
| Number of Days Between Dates | | |
| Number of Days in a Month | | |
| Number of Weeks Between Dates | | |
| Number of Years Between Dates | | |
| Split Date & Time into Separate Cells | | |
| Countdown Remaining Days | | |
| Insert Dates | | |
| Random Date Generator | | |
| Using Dynamic Ranges - Year to Date Values | | |
| Add (Subtract) Years to a Date | | |
| Date Formula Examples | | |
| | |
| Get Day Name from Date | | |
| Count Days Left in Month / Year | | |
| Count Workdays Left in Month / Year | | |
| Get Last Day of Month | | |
| Last Business Day of Month / Year | | |
| Number of Work / Business Days in Month | | |
| Weekday Abbreviations | | |
| Auto Populate Dates | | |
| Number of Months Between Dates | | |
| Quarter from a Date | | |
| Years of Service | | |
| Change Date Format | | |
| Compare Dates | | |
| Time | yes | |
| Add (Subtract) Hours to Time | | |
| Add (Subtract) Minutes to Time | | |
| Add (Subtract) Seconds to Time | | |
| Add Up time (Total Time) | | |
| Time Differences | | |
| Change Time Format | | |
| Convert Minutes to Hours | | |
| Convert Time to Decimal | | |
| Convert Time to Hours | | |
| Convert Time to Minutes | | |
| Convert Time to Seconds | | |
| Military Time | | |
| Round Time to Nearest 15 Minutes | | |
| Overtime Calculator | | |
| Number of Hours Between Times | | |
| Convert Seconds to Minutes, Hours, or Time | | |
| Count Hours Worked | | |
| Time Differences | | |
| Time Format - Show Minutes Seconds | | |
| Text | yes | |
| Add Commas to Cells | | |
| Get First Word from Text | | |
| Capitalize First Letter | | |
| Clean & Format Phone #s | | |
| | |
| Add Spaces to Cell | | |
| Assign Number Value to Text | | |
| Combine Cells with Comma | | |
| Combine First and Last Names | | |
| Convert Text String to Date | | |
| Convert Text to Number | | |
| | |
| | |
| Remove Unwated Characters | | |
| | |
| How to Split Text String by Space, Comma, & More | | |
| Remove Special Characters | | |
| Remove First Characters from Left | | |
| Substitute Multiple Values | | |
| Switch First & Last Names w/ Commas | | |
| Remove Specific Text from a Cell | | |
| | |
| Add Leading Zeros to a Number | | |
| Remove Line Breaks from Text | | |
| Remove all Numbers from Text | | |
| Reverse Text | | |
| Remove Non-Numeric Characters | | |
| Remove Last Character(s) From Right | | |
| Separate First and Last Names | | |
| Separate Text & Numbers | | |
| Round | yes | |
| Round Formulas | | |
| Round Price to Nearest Dollar or Cent | | |
| Round to Nearest 10, 100, or 1000 | | |
| Round to Nearest 5 or .5 | | |
| Round Percentages | | |
| Round to Significant Figures | | |
| Count | yes | |
| Count Blank and Non-blank Cells | | |
| Count Cells Between Two Numbers | | |
| Count Cells not Equal to | | |
| Count if Cells are in Range | | |
| Count Times Word Appears in Cell | | |
| Count Words in Cell | | |
| | |
| Count Specific Characters in Column | | |
| Count Total Number of Characters in Column | | |
| Count Cells that Equal one of two Results | | |
| Count Cells that do not Contain | | |
| Count Cells that Contain Specific Text | | |
| Count Unique Values in Range | | |
| Countif - Multiple Criteria | | |
| Count Total Number of Cells in Range | | |
| Count Cells with Any Text | | |
| Count Total Cells in a Table | | |
| Lookup | yes | |
| Two Dimensional VLOOKUP | | |
| VLOOKUP Simple Example | | |
| Vlookup - Multiple Matches | | |
| Case Sensitive Lookup | | |
| Case Sensitive VLOOKUP | | |
| Sum if - VLOOKUP | | |
| Case Sensitive Lookup | | |
| Case Sensitive VLOOKUP | | |
| Find Duplicates w/ VLOOKUP or MATCH | | |
| | |
| INDEX MATCH MATCH | | |
| Lookup - Return Cell Address (Not Value) | | |
| Lookup Last Value in Column or Row | | |
| Reverse VLOOKUP (Right to Left) | | |
| Risk Score Bucket with VLOOKUP | | |
| Sum with a VLOOKUP Function | | |
| VLOOKUP & INDIRECT | | |
| VLOOKUP Concatenate | | |
| VLOOKUP Contains (Partial Match) | | |
| 17 Reasons Why Your XLOOKUP is Not Working | | |
| Double (Nested) XLOOKUP - Dynamic Columns | | |
| IFERROR (& IFNA) XLOOKUP | | |
| Lookup Min / Max Value | | |
| Nested VLOOKUP | | |
| Top 11 Alternatives to VLOOKUP (Updated 2022!) | | |
| VLOOKUP – Dynamic Column Reference | | |
| VLOOKUP – Fix #N/A Error | | |
| VLOOKUP – Multiple Sheets at Once | | |
| VLOOKUP & HLOOKUP Combined | | |
| VLOOKUP & MATCH Combined | | |
| VLOOKUP Between Worksheets or Spreadsheets | | |
| VLOOKUP Duplicate Values | | |
| VLOOKUP Letter Grades | | |
| VLOOKUP Return Multiple Columns | | |
| VLOOKUP Returns 0? Return Blank Instead | | |
| VLOOKUP w/o #N/A Error | | |
| XLOOKUP Multiple Sheets at Once | | |
| XLOOKUP Between Worksheets or Spreadsheets | | |
| XLOOKUP by Date | | |
| XLOOKUP Duplicate Values | | |
| XLOOKUP Multiple Criteria | | |
| XLOOKUP Return Multiple Columns | | |
| XLOOKUP Returns 0? Return Blank Instead | | |
| XLOOKUP Text | | |
| XLOOKUP with IF | | |
| XLOOKUP With If Statement | | |
| Misc. | yes | |
| Sort Multiple Columns | | |
| Use Cell Value in Formula | | |
| Percentage Change Between Numbers | | |
| Percentage Breakdown | | |
| Rank Values | | |
| Add Spaces to Cell | | |
| CAGR Formula | | |
| Average Time | | |
| Decimal Part of Number | | |
| Integer Part of a Number | | |
| Compare Items in a List | | |
| Dealing with NA() Errors | | |
| Get Worksheet Name | | |
| Wildcard Characters | | |
| Hyperlink to Current Folder | | |
| Compound Interest Formula | | |
| Percentage Increase | | |
| Create Random Groups | | |
| Sort with the Small and Large Functions | | |
| Non-volatile Function Alternatives | | |
| Decrease a Number by a Percentage | | |
| Calculate Percent Variance | | |
| Profit Margin Calculator | | |
| Convert Column Number to Letter | | |
| Get Full Address of Named Range | | |
| Insert File Name | | |
| Insert Path | | |
| Latitute / Longitude Functions | | |
| Replace Negative Values | | |
| Reverse List Range | | |
| | |
| Convert State Name to Abbreviation | | |
| Create Dynamic Hyperlinks | | |
| Custom Sort List with Formula | | |
| Data Validation - Custom Formulas | | |
| Dynamic Sheet Reference (INDIRECT) | | |
| Reference Cell in Another Sheet or Workbook | | |
| Get Cell Value by Address | | |
| Get Worksheet Name | | |
| Increment Cell Reference | | |
| List Sheet Names | | |
| List Skipped Numbers in Sequence | | |
| Return Address of Max Value in Range | | |
| Search by Keywords | | |
| Select Every Other (or Every nth) Row | | |
| Basics | yes | |
| Cell Reference Basics - A1, R1C1, 3d, etc. | | |
| Add Up (Sum) Entire Column or Row | | |
| Into to Dynamic Array Formulas | | |
| Conversions | yes | |
| Convert Time Zones | | |
| Convert Celsius to Fahrenheit | | |
| Convert Pounds to Kilograms | | |
| Convert Time to Unix Time | | |
| Convert Feet to Meters | | |
| Convert Centimeters to Inches | | |
| Convert Kilometers to Miles | | |
| Convert Inches to Feet | | |
| Convert Date to Julian Format | | |
| Convert Column Letter to Number | | |
| Tests | yes | |
| Test if a Range Contains any Text | | |
| Test if any Cell in Range is Number | | |
| Test if a Cell Contains a Specific Value | | |
| | |
| | |
| Test if Cell Contains Any Number | | |
| Test if Cell Contains Specific Number | | |
| Test if Cell is Number or Text | | |
| If | yes | |
| Percentile If | | |
| Subtotal If | | |
| Sumproduct If | | |
| Large If and Small If | | |
| Median If | | |
| Concatentate If | | |
| Max If | | |
| Rank If | | |
| TEXTJOIN If | | |
| Sum | yes | |
| Sum if - Begins With / Ends With | | |
| Sum if - Month or Year to Date | | |
| Sum if - By Year | | |
| Sum if - Blank / Non-Blank | | |
| Sum if - Horizontal Sum | | |
| Count / Sum If - Cell Color | | |
| INDIRECT Sum | | |
| Sum If - Across Multiple Sheets | | |
| Sum If - By Month | | |
| Sum If - Cells Not Equal To | | |
| Sum If - Not Blank | | |
| Sum if - Between Values | | |
| Sum If - Week Number | | |
| Sum Text | | |
| Sum if - By Category or Group | | |
| Sum if - Cell Contains Specific Text (Wildcards) | | |
| Sum if - Date Rnage | | |
| Sum if - Dates Equal | | |
| Sum if - Day of Week | | |
| Sum if - Greater Than | | |
| Sum if - Less Than | | |
| Average | yes | |
| Average Non-Zero Values | | |
| Average If - Not Blank | | |
| Average - Ignore 0 | | |
| Average - Ignore Errors | | |
| Math | yes | |
| Multiplication Table | | |
| Cube Roots | | |
| nth Roots | | |
| Square Numbers | | |
| Square Roots | | |
| Calculations | yes | |
| Calculate a Ratio | | |
| Calculate Age | | |
| Calculate Loan Payments | | |
| GPA Formula | | |
| Calculate VAT Tax | | |
| How to Grade Formulas | | |
| Find | yes | |
| Find a Number in a Column / Workbook | | |
| Find Most Frequent Numbers | | |
| Find Smallest n Values | | |
| Find nth Occurance of Character in Text | | |
| | |
| Find Earliest or Latest Date Based on Criteria | | |
| Find First Cell with Any Value | | |
| Find Last Row | | |
| Find Last Row with Data | | |
| Find Missing Values | | |
| Find Largest n Values | | |
| Most Frequent Number | | |
| Conditional Formatting | yes | |
| Conditional Format - Dates & Times | | |
| Conditional Format - Highlight Blank Cells | | |
