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
  7. Average response time per month
  8. Average and ignore errors
  9. Average number
  10. Average last 5 values in columns

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. Apply Conditional Formatting to Blank Cells
  8. Based on
  9. Text
  10. Copy Text
  11. Formula
  12. Google Sheets
  13. How to Use
  14. SUMIFS in 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
  36. Highlight dates between
  37. Highlight duplicate values
  38. Highlight duplicate columns
  39. Find duplicate values in two columns
  40. Conditional formatting based on another cell
  41. Highlight approximate match lookup conditional formatting
  42. Most frequently occurring text
  43. Normalize text
  44. Excel SUMPRODUCT Function

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. count words in Excel
  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
  35. Count numbers by range with COUNTIFS
  36. Count cells between two numbers
  37. Count cells that contain odd numbers
  38. Count long numbers without COUNTIF
  39. Count cells that contain numbers
  40. Summary count with percentage breakdown
  41. Count if row meets multiple internal criteria
  42. Count cells that contain five characters
  43. Count visible rows only with criteria
  44. Count unique numeric values with criteria
  45. Count unique text values in a range
  46. Count cells that contain negative numbers
  47. Count cells that do not contain errors
  48. Running count of occurrence in list
  49. Two-way summary count with COUNTIFS
  50. Count cells equal to
  51. Count numbers third digit equals 3

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. COUNTIF in Google Sheets
  6. Greater Than
  7. Countif Function / How to Use testing

COUNTIFS

  1. How to Use 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
  18. Data validation allow text only

DATABASE

  1. DCOUNT
  2. Excel DSTDEVP Function
  3. DVAR
  4. DGET
  5. DSUM
  6. DAVERAGE
  7. DCOUNTA
  8. DMIN
  9. DMAX
  10. DVARP

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. Next working day
  8. Next business day 6 months in future
  9. Get first Monday before any date
  10. Get first day of previous month
  11. Display the current date and time
  12. Year is a leap year
  13. Next anniversary date
  14. Next biweekly payday from date
  15. Convert date to text
  16. List holidays between two dates
  17. Working days left in month
  18. Get year from date
  19. Get workdays between dates
  20. If Monday, roll back to Friday
  21. Last updated date stamp
  22. Join date and text
  23. Get months between dates
  24. Get week number from date
  25. TIMEVALUE
  26. Get work hours between dates
  27. DAYS360
  28. Get month name from date
  29. Get same date next year
  30. Get same date next month
  31. Dynamic calendar grid
  32. Calculate expiration date
  33. Get first day of month
  34. Get days before a date
  35. Get days between dates ignoring years
  36. Get age from birthday
  37. Get nth day of week in month
  38. EDATE
  39. Get most recent day of week
  40. Display the current date
  41. Extract date from a date and time
  42. Sum time over 30 minutes
  43. Workdays per month
  44. DATEVALUE
  45. Add decimal hours to time
  46. Add days to date
  47. Get last day of month
  48. EOMONTH
  49. Get fiscal year from date
  50. Get days, months, and years between dates
  51. Count times in a specific range
  52. Convert Excel time to decimal minutes
  53. Convert Excel time to decimal hours
  54. Get day name from date
  55. MINUTE
  56. SECOND
  57. Get date from day number
  58. Extract time from a date and time
  59. Assign points based on late time
  60. Add workdays to date custom weekends
  61. NOW
  62. DATEDIF
  63. Convert text to date
  64. Get next day of week
  65. Add months to date
  66. Calculate number of hours between two times
  67. Get next day of week
  68. WORKDAY
  69. Get month from date
  70. Get day from date
  71. DAY
  72. Convert decimal seconds to Excel time
  73. Excel WEEKDAY Function
  74. TIME
  75. Custom weekday abbreviation
  76. YEAR
  77. Convert date to month and year
  78. Excel YEARFRAC Function
  79. Date is workday
  80. Basic overtime calculation formula
  81. Date is same month and year
  82. Days in month
  83. Create date range from two dates
  84. Count holidays between two dates
  85. Convert date to Julian format
  86. NETWORKDAYS.INTL
  87. Calculate years between dates
  88. Calculate days remaining
  89. Get last weekday in month
  90. Calculate date overlap in days
  91. Add workdays no weekends
  92. WEEKNUM
  93. How to calculate a retirement date
  94. Count day of week between dates
  95. Count dates in current month
  96. WORKDAY.INTL
  97. Get quarter from date
  98. Get percent of year complete
  99. Get project end date
  100. Get project midpoint
  101. Get project start date
  102. Date is same month

DATE SERIES

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

ENGINEERING

  1. HEX2DEC
  2. DEC2HEX
  3. CONVERT
  4. BIN2HEX
  5. HEX2BIN
  6. BITOR
  7. BITAND function
  8. BITRSHIFT
  9. BIN2DEC

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
  19. NPER
  20. RATE

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
  4. Group numbers at uneven intervals
  5. Group numbers with VLOOKUP

IF

  1. How to
  2. IF AND
  3. Nested IF statements
  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
  19. If a cell is not blank
  20. If cell contains

INDEX

  1. How to Use Excel INDEX function

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
  13. CELL
  14. ISODD
  15. ISERROR
  16. INFO
  17. INFO

INTERNET

  1. Remove trailing slash from url
  2. Create email address from name
  3. Get top level domain (TLD)
  4. Strip protocol and trailing slash from URL
  5. Get page from URL

LEN

  1. Count total characters in a cell

LOGICAL

  1. Excel TRUE function
  2. IFNA
  3. Extract data with helper column
  4. IFERROR
  5. IFS
  6. SWITCH
  7. OR
  8. FALSE
  9. XOR
  10. Excel IF Function

LOOKUP

  1. How to Find the First Match in a Range with a 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. Exact match lookup with SUMPRODUCT
  9. Get first non-blank value in a list
  10. Get first text value with HLOOKUP
  11. Two-way lookup with VLOOKUP
  12. VLOOKUP without #N/A error
  13. Calculate grades with VLOOKUP
  14. Position of first partial match
  15. Calculate grades with VLOOKUP
  16. Extract all partial matches
  17. Two-way lookup with INDEX and MATCH
  18. VLOOKUP with 2 lookup tables
  19. Lookup lowest value
  20. Basic INDEX MATCH approximate
  21. Basic INDEX MATCH exact
  22. Match next highest value
  23. Find missing values
  24. Break ties with helper column and COUNTIF
  25. Next largest match with the MATCH function
  26. Match first error
  27. Find the position of the max value in a list
  28. Join tables with INDEX and MATCH
  29. Lookup last file version
  30. Partial match with VLOOKUP
  31. Get information corresponding to max value
  32. Dynamic lookup table with INDIRECT
  33. VLOOKUP with numbers and text
  34. Get nth match
  35. Basic Tax Rate calculation with VLOOKUP
  36. Count missing values
  37. Approximate match with multiple criteria
  38. Find longest string in column
  39. INDEX and MATCH with multiple criteria

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
  13. ROWS
  14. Excel HYPERLINK Function

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
  25. LOG10
  26. SQRT
  27. MROUND
  28. ODD
  29. RADIANS
  30. SUBTOTAL

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
  7. Minimum value if
  8. Minimum if multiple criteria
  9. Maximum if multiple criteria
  10. nth smallest value
  11. nth largest value with criteria
  12. Minimum value
  13. nth largest value
  14. nth largest value with duplicates

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
  52. Leave a comment in a formula
  53. Create array of numbers
  54. Most frequently occurring number
  55. Flag first duplicate in a list
  56. Get last entry by month and year
  57. Issue response time calculation

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
  6. Get middle name from full name

OTHER

  1. GETPIVOTDATA

PERCENTAGE

  1. Project complete percentage
  2. Get original price from percentage discount
  3. Percent of goal in Excel
  4. Get profit margin percentage
  5. Percent sold
  6. Get total from percentage
  7. Decrease by percentage
  8. Get amount with percentage
  9. Calculate percent variance

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
  11. Indirect named range different sheet
  12. Get domain name from URL
  13. VLOOKUP from another sheet
  14. Sum if cells contain specific text

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. Randomly assign people to groups

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
  12. All cells in range are blank

RANK

  1. How to use rank function
  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
  8. Get integer part of a number
  9. Get number at place value
  10. ROUND
  11. Round a number down

ROW

SELECT SPECIAL

  1. Display 'Go To' dialog box

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
  37. PERMUT
  38. PERCENTILE.INC
  39. MAX
  40. PERCENTRANK.EXC

SUM

  1. How to
  2. Autosum in Excel
  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 cell contains text in another cell
  11. Sum if cells are equal to
  12. Sum entire column
  13. Sum if by year
  14. Sum if not blank
  15. Sum if greater than
  16. Subtotal by color
  17. Sum every nth column
  18. Sum by group
  19. Sum if ends with
  20. Sum columns based on adjacent criteria
  21. Sum if begins with
  22. Sum if cells contain both x and y
  23. Sum if one criteria multiple columns
  24. Sum visible rows in a filtered list
  25. Sum if equal to either x or y
  26. Sum by weekday
  27. Sum by week
  28. Sum if between
  29. Sum top n values with criteria
  30. Sum if cells contain an asterisk
  31. Subtotal invoices by age
  32. Sum every n rows

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
  5. Get column index in Excel 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 in Excel
  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
  32. Excel PROPER Function
  33. Double quotes inside a formula
  34. Excel REPT Function
  35. Count specific words in a range
  36. EXACT
  37. Count specific words in a cell
  38. Remove characters from left side of a cell
  39. LOWER
  40. Count specific characters in a range
  41. Excel REPT Function
  42. Count total characters in a range
  43. Cell contains some words but not others
  44. DOLLAR
  45. Count line breaks in cell
  46. Count total words in a range

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 VLOOKUP function
  11. Not Working
  12. INDEX MATCH versus VLOOKUP
  13. IF
  14. Multiple Workbooks
  15. Fuzzy Lookup
  16. Random date between two dates
  17. VLOOKUP with two client rates
  18. Lookup value between two numbers
  19. Get nth match with VLOOKUP
  20. VLOOKUP from another workbook
  21. VLOOKUP by date
  22. Get address of lookup result
  23. Calculate shipping cost with VLOOKUP
  24. Lookup up cost for product or service

WORKBOOK

  1. List sheet index numbers
  2. Get sheet name only
  3. Dynamic workbook reference
  4. Worksheet name exists
  5. Dynamic worksheet reference
  6. Get workbook name only
  7. Get workbook name and path without sheet