AND

AVERAGE

AVERAGEIF

CELL REFERENCE

COLUMNS

CONDITIONAL FORMATTING

- How to Use
- Row
- IF
- Greater Than
- Copy
- Color
- Blank
- Based on
- Text
- Copy Text
- Formula
- Google Sheets
- How to Use
- Google Sheets
- Remove file extension from filename
- Highlight top values
- Lookup entire row
- Highlight values between
- Highlight multiples of specific value
- Highlight dates in the next N days
- Highlight cells that equal
- Highlight 3 smallest values with criteria
- Highlight every other row
- Highlight dates that are weekends
- Highlight rows with blank cells
- Highlight row and column intersection exact match
- Highlight cells that begin with
- Highlight cells that end with
- Conditional formatting highlight target percentage
- Shade alternating groups of n rows
- DECIMAL
- Select all precedents
- Select all dependents
- Undo last action
- Conditional formatting dates overlap
- Highlight dates between

COUNT

- Function
- How to Count Non Blank or Non Empty Cells in Excel
- Blank/Empty
- Colored/Highlighted
- Google Sheets
- Duplicates
- Unique/Distinct Values
- Words
- Characters
- Text
- Summary count of non-blank categories
- Count cells that are blank
- Count cells not equal to a specified value
- Count cells that contain either a or b
- Count cells that contain specific text
- Count cells that do not contain
- Count cells that begin with
- Basic timesheet formula with breaks
- Count dates by day of week
- Count cells between dates
- Count cells greater than
- Count cells that are not blank
- Count cells that contain text
- Summary count with COUNTIF
- Count matches between two columns
- Count cells that contain errors
- Count cells not equal to many things
- Count sold and remaining
- Count cells over 100 characters
- Count cells that end with
- Count unique values in a range with COUNTIF
- Count rows that contain specific values
- Count items in list
- Count occurrences in entire workbook
- Count numbers by range with COUNTIFS
- Count cells between two numbers
- Count cells that contain odd numbers
- Count long numbers without COUNTIF
- Count cells that contain numbers
- Summary count with percentage breakdown
- Count if row meets multiple internal criteria
- Count cells that contain five characters

COUNTA

COUNTIF

- Formula
- Between Two Values
- Multiple Criteria
- Non-Blank
- Google Sheets
- Greater Than
- Countif Function / How to Use testing

COUNTIFS

CUMIPMT

DATA ENTRY

DATA VALIDATION

- How to allow numbers only
- How to allow uppercase text only
- How to allow weekday dates only
- Check for specific text
- How to allow text only
- How to allow dates from a certain year only
- How to only allow dates in the next 30 days
- How to only allow values that don't exceed a set sum
- Data validation must begin with
- Data validation unique values only
- Data validation must contain specific text
- Data validation date in next 30 days
- Data validation date in specific year
- Data validation exists in list
- Data validation allow numbers only
- Data validation must not contain
- Data validation allow weekday only
- Data validation allow text only

DATABASE

DATE AND TIME

- Get days between dates
- How to only allow values that don't exceed a set sum
- Dynamic date list
- Pad week numbers with zeros
- Sum race time splits
- DATE
- Get fiscal quarter from date
- Next working day
- Next business day 6 months in future
- Get first Monday before any date
- Get first day of previous month
- Display the current date and time
- Year is a leap year
- Next anniversary date
- Next biweekly payday from date
- Convert date to text
- List holidays between two dates
- Working days left in month
- Get year from date
- Get workdays between dates
- If Monday, roll back to Friday
- Last updated date stamp
- Join date and text
- Get months between dates
- Get week number from date
- TIMEVALUE
- Get work hours between dates
- DAYS360
- Get month name from date
- Get same date next year
- Get same date next month
- Dynamic calendar grid
- Calculate expiration date
- Get first day of month
- Get days before a date
- Get days between dates ignoring years
- Get age from birthday
- Get nth day of week in month
- EDATE
- Get most recent day of week
- Display the current date
- Extract date from a date and time
- Sum time over 30 minutes
- Workdays per month
- DATEVALUE
- Add decimal hours to time
- Add days to date
- Get last day of month
- EOMONTH
- Get fiscal year from date
- Get days, months, and years between dates
- Count times in a specific range
- Convert Excel time to decimal minutes
- Convert Excel time to decimal hours
- Get day name from date
- MINUTE
- SECOND
- Get date from day number
- Extract time from a date and time
- Assign points based on late time
- Add workdays to date custom weekends
- NOW
- DATEDIF
- Convert text to date
- Get next day of week
- Add months to date
- Calculate number of hours between two times
- Get next day of week
- WORKDAY
- Get month from date
- Get day from date
- DAY
- Convert decimal seconds to Excel time
- Excel WEEKDAY Function
- TIME
- Custom weekday abbreviation
- YEAR
- Convert date to month and year
- YEARFRAC
- Date is workday
- Basic overtime calculation formula
- Date is same month and year
- Days in month
- Create date range from two dates
- Count holidays between two dates
- Convert date to Julian format
- NETWORKDAYS.INTL
- Calculate years between dates
- Calculate days remaining
- Get last weekday in month
- Calculate date overlap in days
- Add workdays no weekends

DATE SERIES

ENGINEERING

FINANCIAL

- Calculate interest for given period
- Calculate simple interest
- PPMT
- Calculate payment for a loan
- Calculate interest rate for loan
- CUMPRINC
- Calculate original loan amount
- Financial
- Annual compound interest schedule
- Microsoft Excel IRR function
- FV
- Calculate cumulative loan interest
- Calculate cumulative loan interest
- Calculate principal for given period
- NPV
- PV
- XIRR
- Calculate cumulative loan principal payments

FIND

GENERAL

GRID OPERATIONS

GROUPING

- Map text to numbers
- Group times into 3 hour buckets
- Group arbitrary text values
- Group numbers at uneven intervals

IF

- How to
- IF AND
- Nested IF
- Blank / Not Blank
- IF OR
- IFERROR Function in Excel
- If this AND that OR that
- Tax rate calculation with fixed base
- Force negative numbers to zero
- If cell contains this or that
- Nested IF function example
- If else
- If this AND that OR that
- If cell is greater than
- If cell is x or y and z
- If cell is this OR that
- If this AND that
- If cell equals

INDEX

INDEX MATCH

INFORMATION

INTERNET

- Remove trailing slash from url
- Get domain name from URL
- Create email address from name
- Get top level domain (TLD)

LEN

LOGICAL

LOOKUP

- First match in range with wildcard
- Lookup and retrieve an entire column
- Get location of value in 2D array
- Max if criteria match
- Partial match against numbers with wildcard
- Self-contained VLOOKUP
- Sum range with INDEX
- VLOOKUP with multiple critiera
- Exact match lookup with SUMPRODUCT
- Get first non-blank value in a list
- Get first text value with HLOOKUP
- Get address of lookup result
- Two-way lookup with VLOOKUP
- VLOOKUP without #N/A error
- Calculate grades with VLOOKUP
- Position of first partial match
- Extract all partial matches
- Two-way lookup with INDEX and MATCH
- VLOOKUP with 2 lookup tables
- Lookup lowest value
- Basic INDEX MATCH approximate
- Basic INDEX MATCH exact
- Match next highest value
- Find missing values
- Break ties with helper column and COUNTIF
- Next largest match with the MATCH function
- Lookup with variable sheet name
- Match first error
- Position of max value in list
- Join tables with INDEX and MATCH
- Lookup last file version
- Partial match with VLOOKUP
- Get information corresponding to max value
- Dynamic lookup table with INDIRECT
- VLOOKUP with numbers and text

Lookup and reference

- LOOKUP
- OFFSET
- INDIRECT
- ROW
- COLUMNS
- How to use the Excel CHOOSE function
- HLOOKUP
- INDEX
- TRANSPOSE
- MATCH
- ADDRESS
- COLUMN
- ROWS

MATCH

MATH

- SUM
- SUMPRODUCT
- TAN
- GCD
- ABS
- Excel LOG Function
- SUMIFS
- EVEN
- SIGN
- RAND
- COS
- EXP
- SIN
- QUOTIENT
- LN
- SUMIF
- RANDBETWEEN
- ROMAN
- ROMAN
- ARABIC
- DECIMAL
- MOD
- POWER
- FLOOR
- LOG10

MIN AND MAX

- Smaller of two values
- Large with criteria
- Larger of two values
- Maximum value
- nth smallest value with criteria
- Max value ignore all errors
- Minimum value if
- Minimum if multiple criteria
- Maximum if multiple criteria

Miscellaneous

- Value is within tolerance
- Validate input with check mark
- Value is between two numbers
- Course completion summary with criteria
- Course completion status summary
- Transpose table without zeros
- Sum text values like numbers
- Copy value from every nth row
- Sum every 3 cells
- Square root of number
- Split payment across months
- Sort text and numbers with formula
- Sort numbers ascending or descending
- Pad a number with zeros
- nth root of number
- Convert column number to letter
- Reverse a list or range
- Random sort formula
- Return array with INDEX function
- Range contains one of many substrings
- Range contains one of many values
- Basic text sort formula
- Student class enrollment with table
- Search entire worksheet for value
- Risk Matrix Example
- Range contains specific text
- Excel formula: One or the other not both
- How to Search Multiple Worksheets for Value
- Simple currency conversion
- Check register balance
- Build hyperlink with VLOOKUP
- Fixed value every N months
- Calculate a ratio from two numbers
- List most frequently occuring numbers
- Multiplication table formula
- Normalize size units to Gigabytes
- Abbreviate state names
- List contains duplicates
- Basic numeric sort formula
- Get value of last non-empty cell
- Hyperlink to first match
- Flip table rows to columns
- Conditional mode with criteria
- Get first entry by month and year
- Get pivot table subtotal grouped date
- Cube root of number
- Get date associated with last entry
- Get last entry by month and year
- Display sorted values with helper column
- Filter values in array formula
- Change negative numbers to positive
- Leave a comment in a formula

MOD

NAMES

- Join first and last name
- Get last name from name
- Get first name from name
- Put names into proper case
- Get first name from name with comma
- Get middle name from full name

OTHER

PERCENTAGE

- Project complete percentage
- Get original price from percentage discount
- Percent Of Goal
- Get profit margin percentage
- Percent sold
- Get total from percentage
- Decrease by percentage
- Get amount with percentage

PIVOT TABLE

- Calculated Fields
- Sort
- Transpose Data
- Conditional Formatting
- Percentage
- Distinct
- Google Sheets
- Refresh/Update
- How to Create/Make
- Calculated Field

RANDOM

- Random times at specific intervals
- Random value from list or table
- Random number weighted probability
- Random text values
- Random number from fixed set of options
- Random number between two numbers
- Random date between two dates

RANGE

- All values in a range are at least
- All values in a range are at least
- Get relative column numbers in range
- Total cells in a range
- Range contains a value not in another range
- Last row in mixed data with blanks
- Range contains numbers
- First match between two ranges
- Last row in mixed data with no blanks
- Last row in text data
- Last row number in range
- All cells in range are blank

RANK

- How to
- How to RANK from lowest to highest
- How to RANK using COUNTIFS
- How to use RANK with suffix
- Rank with criteria
- Rank function example
- Rank with ordinal suffix

ROUND

- Round to nearest 1000
- Round a number up
- Excel ROUNDUP function
- Round a number
- Round a number down to nearest multiple
- Round a price to end in .99
- Round a number to nearest multiple
- Get integer part of a number
- Get number at place value

STATISTICAL

- QUARTILE.EXC
- QUARTILE.INC
- VARPA
- VARA
- VARP
- VAR.S
- VAR.P
- VAR
- TRIMMEAN
- STDEVPA
- STDEVP
- STDEVA
- STDEV.S
- STDEV
- STDEV.P
- AVERAGE
- LARGE
- PERCENTILE.EXC
- PERCENTRANK
- COUNTBLANK
- AVEDEV
- COUNTIF
- COUNTA
- COUNT
- DEVSQ
- MINA
- AVERAGEIF
- FREQUENCY
- AVERAGEIFS
- MODE.MULT
- MEDIAN
- GEOMEAN
- PERCENTILE
- QUARTILE
- MIN
- Excel MODE Function
- PERMUT

SUM

- How to
- Autosum
- 3D sum multiple worksheets
- Sum last n columns
- Sum if multiple criteria
- Sum sales in last 30 days by ID
- Sum by week number
- Sum if equal to one of many things
- Sum bottom n values with criteria
- Sum if cells contain specific text
- Sum if cell contains text in another cell
- Sum if cells are equal to
- Sum entire column
- Sum if by year
- Sum if not blank
- Sum if greater than
- Subtotal by color
- Sum every nth column
- Sum by group
- Sum if ends with
- Sum columns based on adjacent criteria
- Sum if begins with
- Sum if cells contain both x and y
- Sum if one criteria multiple columns
- Sum visible rows in a filtered list
- Sum if equal to either x or y
- Sum by weekday
- Sum by week
- Sum if between
- Sum top n values with criteria

SUMIF

- Google Sheets
- Multiple Criteria
- Blank / Not Blank
- How to Use SUMIF to Sum Values Between Two Dates
- Sum visible rows in a filtered list

TABLES

- Count table columns
- Basic inventory formula example
- Dynamic reference Table name
- Two-way lookup VLOOKUP in a Table
- Get column index in Excel Table

TEXT

- Join text together
- TEXTJOIN
- UPPER
- VALUE
- Replace one character with another
- CHAR
- Remove unwanted characters
- Remove characters from right
- Remove text by variable position
- Remove leading and trailing spaces from text
- Remove text by position
- Remove text by matching
- Remove line breaks
- Remove file extension from filename
- Split text string at specific character
- Split text and numbers
- Cell equals one of many things
- REPLACE
- LEFT
- Strip non-numeric characters
- Split dimensions into two parts
- Count keywords cell contains
- RIGHT
- CODE
- Count total words in a cell
- Cell contains number
- MID
- TRIM
- Add a line break with a formula
- Cell contains all of many things
- Clean and reformat telephone numbers
- PROPER
- Double quotes inside a formula
- Excel REPT Function

VLOOKUP

- Calculation
- Formula
- Compare
- Conditional Formatting
- Error
- Multiple Columns
- Multiple Sheets
- Check
- How to
- Google Sheets
- Not Working
- Multiple Criteria
- INDEX MATCH versus VLOOKUP
- IF
- Multiple Workbooks
- Fuzzy Lookup
- VLOOKUP with two client rates
- Lookup value between two numbers
- Get nth match with VLOOKUP
- VLOOKUP from another sheet
- VLOOKUP from another workbook
- VLOOKUP by date
- Calculate shipping cost with VLOOKUP
- Lookup with variable sheet name
- Lookup up cost for product or service

WORKBOOK