Are you stuck on Excel or Google Sheets?

Check out our self-help content, created by our top Experts!

AND

  1. Excel AND function

AVERAGE

  1. Average Growth Rate
  2. Moving Average
  3. Ignore Zeros
  4. How To
  5. Average top 3 scores
  6. Weighted average

AVERAGEIF

  1. Google Sheets
  2. How to Use

CELL REFERENCE

  1. Multiple Sheets

COLUMNS

  1. First column number in range

CONDITIONAL FORMATTING

  1. How to Use
  2. Row
  3. IF
  4. Greater Than
  5. Copy
  6. Color
  7. Blank
  8. Based on
  9. Text
  10. Copy Text
  11. Formula
  12. Google Sheets
  13. How to Use
  14. Google Sheets
  15. Remove file extension from filename
  16. Highlight top values
  17. Lookup entire row
  18. Highlight values between
  19. Highlight multiples of specific value
  20. Highlight dates in the next N days
  21. Highlight cells that equal
  22. Highlight 3 smallest values with criteria
  23. Highlight every other row
  24. Highlight dates that are weekends
  25. Highlight rows with blank cells
  26. Highlight row and column intersection exact match
  27. Highlight cells that begin with
  28. Highlight cells that end with
  29. Conditional formatting highlight target percentage
  30. Shade alternating groups of n rows
  31. DECIMAL
  32. Select all precedents
  33. Select all dependents
  34. Undo last action
  35. Conditional formatting dates overlap

COUNT

  1. Function
  2. How to Count Non Blank or Non Empty Cells in Excel
  3. Blank/Empty
  4. Colored/Highlighted
  5. Google Sheets
  6. Duplicates
  7. Unique/Distinct Values
  8. Words
  9. Characters
  10. Text
  11. Summary count of non-blank categories
  12. Count cells that are blank
  13. Count cells not equal to a specified value
  14. Count cells that contain either a or b
  15. Count cells that contain specific text
  16. Count cells that do not contain
  17. Count cells that begin with
  18. Basic timesheet formula with breaks
  19. Count dates by day of week
  20. Count cells between dates
  21. Count cells greater than
  22. Count cells that are not blank
  23. Count cells that contain text
  24. Summary count with COUNTIF
  25. Count matches between two columns
  26. Count cells that contain errors
  27. Count cells not equal to many things
  28. Count sold and remaining
  29. Count cells over 100 characters
  30. Count cells that end with
  31. Count unique values in a range with COUNTIF
  32. Count rows that contain specific values
  33. Count items in list
  34. Count occurrences in entire workbook

COUNTA

  1. Not Blank
  2. Count vs Counta
  3. How to
  4. Google Sheets

COUNTIF

  1. Formula
  2. Between Two Values
  3. Multiple Criteria
  4. Non-Blank
  5. Google Sheets
  6. Greater Than
  7. Countif Function / How to Use testing

COUNTIFS

  1. COUNTIFS with multiple criteria and OR logic

CUMIPMT

  1. Excel CUMIPMT Function

DATA ENTRY

  1. Multiple Sheets

DATA VALIDATION

  1. How to allow numbers only
  2. How to allow uppercase text only
  3. How to allow weekday dates only
  4. Check for specific text
  5. How to allow text only
  6. How to allow dates from a certain year only
  7. How to only allow dates in the next 30 days
  8. How to only allow values that don't exceed a set sum
  9. Data validation must begin with
  10. Data validation unique values only
  11. Data validation must contain specific text
  12. Data validation date in next 30 days
  13. Data validation date in specific year
  14. Data validation exists in list
  15. Data validation allow numbers only
  16. Data validation must not contain
  17. Data validation allow weekday only

DATABASE

  1. DCOUNT
  2. Excel DSTDEVP Function
  3. DVAR
  4. DGET
  5. DSUM
  6. DAVERAGE

DATE AND TIME

  1. Get days between dates
  2. How to only allow values that don't exceed a set sum
  3. Dynamic date list
  4. Pad week numbers with zeros
  5. Sum race time splits
  6. DATE
  7. Get fiscal quarter from date
  8. Next working day
  9. Next business day 6 months in future
  10. Get first Monday before any date
  11. Get first day of previous month
  12. Display the current date and time
  13. Year is a leap year
  14. Next anniversary date
  15. Next biweekly payday from date
  16. Convert date to text
  17. List holidays between two dates
  18. Working days left in month
  19. Get year from date
  20. Get workdays between dates
  21. If Monday, roll back to Friday
  22. Last updated date stamp
  23. Join date and text
  24. Get months between dates
  25. Get week number from date
  26. TIMEVALUE
  27. Get work hours between dates
  28. DAYS360
  29. Get month name from date
  30. Get same date next year
  31. Get same date next month
  32. Dynamic calendar grid
  33. Calculate expiration date
  34. Get first day of month
  35. Get days before a date
  36. Get days between dates ignoring years
  37. Get age from birthday
  38. Get nth day of week in month
  39. EDATE
  40. Get most recent day of week
  41. Display the current date
  42. Extract date from a date and time
  43. Sum time over 30 minutes
  44. Workdays per month
  45. DATEVALUE
  46. Add decimal hours to time
  47. Add days to date
  48. Get last day of month
  49. EOMONTH
  50. Get fiscal year from date
  51. Get days, months, and years between dates
  52. Count times in a specific range
  53. Convert Excel time to decimal minutes
  54. Convert Excel time to decimal hours
  55. Get day name from date
  56. MINUTE
  57. SECOND
  58. Get date from day number
  59. Extract time from a date and time
  60. Assign points based on late time
  61. Add workdays to date custom weekends
  62. NOW
  63. DATEDIF
  64. Convert text to date
  65. Get next day of week
  66. Add months to date
  67. Calculate number of hours between two times
  68. Get next day of week
  69. WORKDAY
  70. Get month from date
  71. Get day from date
  72. DAY
  73. Convert decimal seconds to Excel time
  74. Excel WEEKDAY Function
  75. TIME
  76. Custom weekday abbreviation

DATE SERIES

  1. Series of dates by workdays
  2. Series of dates by day

ENGINEERING

  1. HEX2DEC
  2. DEC2HEX
  3. CONVERT
  4. BIN2HEX

FINANCIAL

  1. Calculate interest for given period
  2. Calculate simple interest
  3. PPMT
  4. Calculate payment for a loan
  5. Calculate interest rate for loan
  6. CUMPRINC
  7. Calculate original loan amount
  8. Financial
  9. Annual compound interest schedule
  10. Microsoft Excel IRR function
  11. FV
  12. Calculate cumulative loan interest
  13. Calculate cumulative loan interest
  14. Calculate principal for given period
  15. NPV
  16. PV
  17. XIRR
  18. Calculate cumulative loan principal payments

FIND

  1. How to
  2. FIND

GENERAL

  1. Redo last action

GRID OPERATIONS

  1. Delete rows

GROUPING

  1. Map text to numbers
  2. Group times into 3 hour buckets
  3. Group arbitrary text values

IF

  1. How to
  2. IF AND
  3. Nested IF
  4. Blank / Not Blank
  5. IF OR
  6. IFERROR Function in Excel
  7. If this AND that OR that
  8. Tax rate calculation with fixed base
  9. Force negative numbers to zero
  10. If cell contains this or that
  11. Nested IF function example
  12. If else
  13. If this AND that OR that
  14. If cell is greater than
  15. If cell is x or y and z
  16. If cell is this OR that
  17. If this AND that
  18. If cell equals

INDEX

  1. How to Use

INDEX MATCH

  1. Formula
  2. INDEX MATCH

INFORMATION

  1. ISTEXT
  2. TYPE
  3. N
  4. ISNUMBER
  5. ISFORMULA
  6. NA
  7. ISNONTEXT
  8. ERROR.TYPE
  9. ISBLANK
  10. SHEETS
  11. ISEVEN
  12. ISNA

INTERNET

  1. Remove trailing slash from url
  2. Get domain name from URL
  3. Create email address from name

LEN

  1. Count total characters in a cell

LOGICAL

  1. TRUE
  2. IFNA
  3. Extract data with helper column
  4. IFERROR
  5. IFS
  6. SWITCH
  7. OR

LOOKUP

  1. First match in range with wildcard
  2. Lookup and retrieve an entire column
  3. Get location of value in 2D array
  4. Max if criteria match
  5. Partial match against numbers with wildcard
  6. Self-contained VLOOKUP
  7. Sum range with INDEX
  8. VLOOKUP with multiple critiera
  9. Exact match lookup with SUMPRODUCT
  10. Get first non-blank value in a list
  11. Get first text value with HLOOKUP
  12. Get address of lookup result
  13. Two-way lookup with VLOOKUP
  14. VLOOKUP without #N/A error
  15. Calculate grades with VLOOKUP
  16. Position of first partial match
  17. Extract all partial matches
  18. Two-way lookup with INDEX and MATCH
  19. VLOOKUP with 2 lookup tables
  20. Lookup lowest value
  21. Basic INDEX MATCH approximate
  22. Basic INDEX MATCH exact
  23. Match next highest value
  24. Find missing values
  25. Break ties with helper column and COUNTIF
  26. Next largest match with the MATCH function
  27. Lookup with variable sheet name
  28. Match first error
  29. Position of max value in list

Lookup and reference

  1. LOOKUP
  2. OFFSET
  3. INDIRECT
  4. ROW
  5. COLUMNS
  6. How to use the Excel CHOOSE function
  7. HLOOKUP
  8. INDEX
  9. TRANSPOSE
  10. MATCH
  11. ADDRESS
  12. COLUMN

MATCH

  1. Formula
  2. List
  3. How to Use

MATH

  1. SUM
  2. SUMPRODUCT
  3. TAN
  4. GCD
  5. ABS
  6. Excel LOG Function
  7. SUMIFS
  8. EVEN
  9. SIGN
  10. RAND
  11. COS
  12. EXP
  13. SIN
  14. QUOTIENT
  15. LN
  16. SUMIF
  17. RANDBETWEEN
  18. ROMAN
  19. ROMAN
  20. ARABIC
  21. DECIMAL
  22. MOD
  23. POWER
  24. FLOOR

MIN AND MAX

  1. Smaller of two values
  2. Large with criteria
  3. Larger of two values
  4. Maximum value
  5. nth smallest value with criteria
  6. Max value ignore all errors

Miscellaneous

  1. Value is within tolerance
  2. Validate input with check mark
  3. Value is between two numbers
  4. Course completion summary with criteria
  5. Course completion status summary
  6. Transpose table without zeros
  7. Sum text values like numbers
  8. Copy value from every nth row
  9. Sum every 3 cells
  10. Square root of number
  11. Split payment across months
  12. Sort text and numbers with formula
  13. Sort numbers ascending or descending
  14. Pad a number with zeros
  15. nth root of number
  16. Convert column number to letter
  17. Reverse a list or range
  18. Random sort formula
  19. Return array with INDEX function
  20. Range contains one of many substrings
  21. Range contains one of many values
  22. Basic text sort formula
  23. Student class enrollment with table
  24. Search entire worksheet for value
  25. Risk Matrix Example
  26. Range contains specific text
  27. Excel formula: One or the other not both
  28. How to Search Multiple Worksheets for Value
  29. Simple currency conversion
  30. Check register balance
  31. Build hyperlink with VLOOKUP
  32. Fixed value every N months
  33. Calculate a ratio from two numbers
  34. List most frequently occuring numbers
  35. Multiplication table formula
  36. Normalize size units to Gigabytes
  37. Abbreviate state names
  38. List contains duplicates
  39. Basic numeric sort formula
  40. Get value of last non-empty cell
  41. Hyperlink to first match
  42. Flip table rows to columns
  43. Conditional mode with criteria
  44. Get first entry by month and year
  45. Get pivot table subtotal grouped date
  46. Cube root of number
  47. Get date associated with last entry
  48. Get last entry by month and year
  49. Display sorted values with helper column
  50. Filter values in array formula
  51. Change negative numbers to positive

MOD

  1. How to Use

NAMES

  1. Join first and last name
  2. Get last name from name
  3. Get first name from name
  4. Put names into proper case
  5. Get first name from name with comma

OTHER

  1. GETPIVOTDATA

PERCENTAGE

  1. Project complete percentage
  2. Get original price from percentage discount
  3. Percent Of Goal
  4. Get profit margin percentage
  5. Percent sold
  6. Get total from percentage
  7. Decrease by percentage
  8. Get amount with percentage

PIVOT TABLE

  1. Calculated Fields
  2. Sort
  3. Transpose Data
  4. Conditional Formatting
  5. Percentage
  6. Distinct
  7. Google Sheets
  8. Refresh/Update
  9. How to Create/Make
  10. Calculated Field

RANDOM

  1. Random times at specific intervals
  2. Random value from list or table
  3. Random number weighted probability
  4. Random text values
  5. Random number from fixed set of options
  6. Random number between two numbers
  7. Random date between two dates

RANGE

  1. All values in a range are at least
  2. All values in a range are at least
  3. Get relative column numbers in range
  4. Total cells in a range
  5. Range contains a value not in another range
  6. Last row in mixed data with blanks
  7. Range contains numbers
  8. First match between two ranges
  9. Last row in mixed data with no blanks
  10. Last row in text data
  11. Last row number in range

RANK

  1. How to
  2. How to RANK from lowest to highest
  3. How to RANK using COUNTIFS
  4. How to use RANK with suffix
  5. Rank with criteria
  6. Rank function example
  7. Rank with ordinal suffix

ROUND

  1. Round to nearest 1000
  2. Round a number up
  3. Excel ROUNDUP function
  4. Round a number
  5. Round a number down to nearest multiple
  6. Round a price to end in .99
  7. Round a number to nearest multiple

STATISTICAL

  1. QUARTILE.EXC
  2. QUARTILE.INC
  3. VARPA
  4. VARA
  5. VARP
  6. VAR.S
  7. VAR.P
  8. VAR
  9. TRIMMEAN
  10. STDEVPA
  11. STDEVP
  12. STDEVA
  13. STDEV.S
  14. STDEV
  15. STDEV.P
  16. AVERAGE
  17. LARGE
  18. PERCENTILE.EXC
  19. PERCENTRANK
  20. COUNTBLANK
  21. AVEDEV
  22. COUNTIF
  23. COUNTA
  24. COUNT
  25. DEVSQ
  26. MINA
  27. AVERAGEIF
  28. FREQUENCY
  29. AVERAGEIFS
  30. MODE.MULT
  31. MEDIAN
  32. GEOMEAN
  33. PERCENTILE
  34. QUARTILE
  35. MIN
  36. Excel MODE Function

SUM

  1. How to
  2. Autosum
  3. 3D sum multiple worksheets
  4. Sum last n columns
  5. Sum if multiple criteria
  6. Sum sales in last 30 days by ID
  7. Sum by week number
  8. Sum if equal to one of many things
  9. Sum bottom n values with criteria
  10. Sum if cells contain specific text
  11. Sum if cell contains text in another cell
  12. Sum if cells are equal to
  13. Sum entire column
  14. Sum if by year
  15. Sum if not blank
  16. Sum if greater than
  17. Subtotal by color
  18. Sum every nth column
  19. Sum by group
  20. Sum if ends with
  21. Sum columns based on adjacent criteria
  22. Sum if begins with
  23. Sum if cells contain both x and y
  24. Sum if one criteria multiple columns
  25. Sum visible rows in a filtered list
  26. Sum if equal to either x or y

SUMIF

  1. Google Sheets
  2. Multiple Criteria
  3. Blank / Not Blank
  4. How to Use SUMIF to Sum Values Between Two Dates
  5. Sum visible rows in a filtered list

TABLES

  1. Count table columns
  2. Basic inventory formula example
  3. Dynamic reference Table name
  4. Two-way lookup VLOOKUP in a Table

TEXT

  1. Join text together
  2. TEXTJOIN
  3. UPPER
  4. VALUE
  5. Replace one character with another
  6. CHAR
  7. Remove unwanted characters
  8. Remove characters from right
  9. Remove text by variable position
  10. Remove leading and trailing spaces from text
  11. Remove text by position
  12. Remove text by matching
  13. Remove line breaks
  14. Remove file extension from filename
  15. Split text string at specific character
  16. Split text and numbers
  17. Cell equals one of many things
  18. REPLACE
  19. LEFT
  20. Strip non-numeric characters
  21. Split dimensions into two parts
  22. Count keywords cell contains
  23. RIGHT
  24. CODE
  25. Count total words in a cell
  26. Cell contains number
  27. MID
  28. TRIM
  29. Add a line break with a formula
  30. Cell contains all of many things
  31. Clean and reformat telephone numbers

VLOOKUP

  1. Calculation
  2. Formula
  3. Compare
  4. Conditional Formatting
  5. Error
  6. Multiple Columns
  7. Multiple Sheets
  8. Check
  9. How to
  10. Google Sheets
  11. Not Working
  12. Multiple Criteria
  13. INDEX MATCH versus VLOOKUP
  14. IF
  15. Multiple Workbooks
  16. Fuzzy Lookup
  17. VLOOKUP with two client rates
  18. Lookup value between two numbers
  19. Get nth match with VLOOKUP
  20. VLOOKUP from another sheet
  21. VLOOKUP from another workbook
  22. VLOOKUP by date
  23. Calculate shipping cost with VLOOKUP
  24. Lookup with variable sheet name
  25. Lookup up cost for product or service

WORKBOOK

  1. Indirect named range different sheet
  2. List sheet index numbers
  3. Get sheet name only
  4. Dynamic workbook reference
  5. Worksheet name exists
  6. Dynamic worksheet reference