Excel formula examples
This webpage contains a list of formula examples sorted in categories, the left sidebar shows the category names.
#, hashtag
2D, two-dimensional, two-way
3D, multiple worksheets, multiple sheets
365
Address
Advanced Filter
Alternative
And logic
Autofilter
Average
Blank, space
Calendar
Case
Character
Column
Combination, combin
Complex, imaginary
Concatenate, combine, merge, join, append
Conditional formatting, cf, highlight
Count
Countif
Countifs
Criteria, multiple conditions, conditions
Date
Day
Decimal
Delete, remove
Digit
Duplicates
Dynamic
Empty
Equal, condition, criterion
Error, problem
Extend, expand
Extract, list, filter, get
Finance, stock, expense
First, last
Group, category
Hour
Hyperlink, link
If
Ifs
Ignore, avoid, prevent, exclude, hide
Image, picture
Index
Index match, index and match
Intersection
Lambda
Large, larger, highest, greater
Letter
Lookup, find, identify
Match
Max
Min
Minute
Month
Multiply, multiplication, product
Negative, minus, subtract
New line
Not equal
Or logic
Overlapping
Partial, wildcard, contain
Permut
Random
Rearrange, distribute
Record, row
Recursive
Reference
Relation, related
Reverse
Right, left
Running total
Schedule
Second
Sequence, consecutive
Shared, common, exist, occur
Small, smaller, less
Solver
Sort, A to Z, z to a, ascending, descending
Split
String
Substitute, replace
Subtotal
Sum, total
Sumif
Sumifs
Sumproduct
Tab
Table, excel table
Team, tournament
Text
Time
Unique
Vlookup
Week
Year
Categories
100% stacked column chart
ABS function
1. Count cells containing text from list
2. Find numbers closest to sum
3. Find the most recent date that meets a particular condition
4. How to create date ranges in Excel
5. How to use the ABS function
6. How to use the asterisk character
7. Identify numbers in sum using Excel solver
8. INDEX MATCH – multiple results
ACCRINT function
ACCRINTM function
ACOS function
1. How to use the ACOS function
ACOT function
1. How to use the ACOT function
Add-in
1. Split data across multiple sheets – VBA
ADDRESS function
1. How to use the ADDRESS function
Advanced filter
AGGREGATE function
1. Count cells containing text from list
2. Extract unique distinct values from a multi-column cell range
3. How to use the AGGREGATE function
AMORLINC function
AND function
1. Count cells containing text from list
3. How to use the AND function
4. Search for a text string in a data set and return multiple records
5. Working with Relational Tables in Excel
Animate
1. How to animate an Excel chart
Area chart
AREAS function
1. How to use the AREAS function
ARRAY function
Arrays
1. A beginners guide to Excel array formulas
2. Working with ARRAY VARIABLES (VBA)
ARRAYTOTEXT Function
1. How to use the ARRAYTOTEXT function
ASIN function
1. How to use the ASIN function
ATAN function
1. Complex Calculations: A Guide to Excel’s IM Functions
2. Engineering functions – D to IMC
3. How to use the ATAN function
ATAN2 function
1. How to use the ATAN2 function
AVEDEV function
1. How to use the AVEDEV function
AVERAGE function
1. Follow stock market trends – Moving Average
2. How to use the AVERAGE function
AVERAGEA function
1. How to use the AVERAGEA function
AVERAGEIF function
1. How to use the AVERAGEIF function
AVERAGEIFS function
1. How to use the AVERAGEIFS function
Bar chart
BASE function
1. Engineering functions – D to IMC
2. How to use the BASE function
Basic formulas
1. Count cells containing text from list
3. Extract specific word based on position in cell value
4. Find the most recent date that meets a particular condition
5. Formula for matching a date within a date range
6. How to create date ranges in Excel
7. How to do tiered calculations in one formula
8. How to extract numbers from a cell value
9. How to perform a two-dimensional lookup
10. If cell contains text from list
11. INDEX MATCH – multiple results
12. Lookup multiple values across columns and return a single value
13. Lookup with any number of criteria
14. Working with running totals
BETA.DIST function
1. How to use the BETA.DIST function
BETA.INV function
1. How to use the BETA.INV function
BETADIST function
BETAINV function
BIN2DEC function
1. How to use the BIN2DEC function
2. Working with classic ciphers in Excel
BIN2HEX function
1. How to use the BIN2HEX function
BIN2OCT function
1. How to use the BIN2OCT function
BINOM.DIST function
2. How to use the BINOM.DIST function
BINOM.INV function
1. How to use the BINOM.INV function
BINOMDIST function
BITAND function
1. How to use the BITAND function
BITLSHIFT function
1. How to use the BITLSHIFT function
BITOR function
1. How to use the BITOR function
BITRSHIFT function
1. How to use the BITRSHIFT function
BITXOR function
1. How to use the BITXOR function
2. Working with classic ciphers in Excel
Blank cells
1. Cleaning Up Excel Worksheets: Eliminating Blank Cells, Rows, and Errors
Box and whisker chart
Bubble chart
BYCOL function
1. How to use the BYCOL function
BYROW function
1. 5 easy ways to VLOOKUP and return multiple values
2. Calculate machine utilization
3. Count cells containing text from list
4. Filter unique distinct records case sensitive
6. How to do tiered calculations in one formula
7. How to use the BYROW function
8. Rearrange values using formulas
9. Search for a text string in a data set and return multiple records
Calendar
3. Plot date ranges in a calendar
Candlestick chart
Case sensitive
1. Count unique distinct values
CEILING function
1. How to use the CEILING function
CELL function
1. How to use the CELL function
2. INDEX MATCH – multiple results
CF-basic-formulas
1. Working with Conditional Formatting formulas
CF-built-in
CF-compare
1. How to highlight differences and common values in lists
CF-dates
1. Advanced Date Highlighting Techniques in Excel
CF-duplicates
1. How to highlight duplicate values
CF-min-max
CF-misc
1. Advanced Techniques for Conditional Formatting
CF-search
CF-unique-distinct
1. Highlight unique values in a filtered Excel table
CHAR function
2. How to use the CHAR function
3. Search for a text string in a data set and return multiple records
4. Working with classic ciphers in Excel
Chart basics
1. Excel charts tips and tricks
Chart elements
Charts
1. Advanced Excel Chart Techniques
3. Excel charts tips and tricks
4. Highlight a data series in a chart
6. How to add horizontal line to chart
7. How to animate an Excel chart
8. How to create an interactive Excel chart
9. How to create charts in Excel
10. How to improve your Excel Chart
Check-boxes
1. Add checkboxes and copy values – VBA
CHIDIST function
CHIINV function
CHISQ.DIST function
2. How to use the CHISQ.DIST function
CHISQ.DIST.RT function
1. How to use the CHISQ.DIST.RT function
CHISQ.INV function
1. How to use the CHISQ.INV function
CHISQ.INV.RT function
1. How to use the CHISQ.INV.RT function
CHISQ.TEST function
1. How to use the CHISQ.TEST function
CHITEST function
CHOOSE function
1. How to perform a two-dimensional lookup
2. How to use the CHOOSE function
3. Split data across multiple sheets – VBA
CHOOSECOLS function
1. How to use the CHOOSECOLS function
CHOOSEROWS function
1. How to use the CHOOSEROWS function
CLEAN function
1. How to use the CLEAN function
CODE function
1. Cleaning Up Excel Worksheets: Eliminating Blank Cells, Rows, and Errors
2. How to use the CODE function
3. Search for a text string in a data set and return multiple records
4. Working with classic ciphers in Excel
Column
Column chart
1. How to add horizontal line to chart
2. How to animate an Excel chart
3. How to create charts in Excel
COLUMN function
1. 5 easy ways to VLOOKUP and return multiple values
2. A Comprehensive Guide to Splitting Text in Excel
3. Cleaning Up Excel Worksheets: Eliminating Blank Cells, Rows, and Errors
4. Compare tables: Filter records occurring only in one table
5. Compare two columns in different worksheets
6. Count cells containing text from list
7. Count unique distinct values
10. Extract a list of duplicates from a column
11. Extract duplicates from a multi-column cell range
12. Extract records between two dates
13. Extract unique distinct values from a multi-column cell range
14. Filter unique distinct records
15. Filter unique distinct records case sensitive
16. Fuzzy VLOOKUP
17. Get date ranges from a schedule
18. How to compare two data sets
19. How to create date ranges in Excel
20. How to generate a round-robin tournament
21. How to list unique distinct values sorted by frequency
22. How to perform a two-dimensional lookup
23. How to return a value if lookup value is in a range
24. How to sort a data set using three different approaches, built-in tools, array formulas, and VBA
26. How to use Pivot Tables – Excel’s most powerful feature and also least known
27. How to use the COLUMN function
29. INDEX MATCH – multiple results
30. Lookup with any number of criteria
31. Match two criteria and return multiple records
32. Merge cell ranges into one list
33. Merge tables based on a condition
34. Partial match for multiple strings – AND logic
35. Search for a text string in a data set and return multiple records
36. Sort a column alphabetically
37. Split data across multiple sheets – VBA
39. Unique distinct records sorted based on count or frequency
40. VLOOKUP – Return multiple unique distinct values
41. Wildcard lookups and include or exclude criteria
42. Working with COMBO BOXES [Form Controls]
43. Working with Relational Tables in Excel
44. Working with unique values
COLUMNS function
1. 5 easy ways to VLOOKUP and return multiple values
2. Count cells containing text from list
4. Extract all rows from a range that meet criteria in one column
5. Filter unique distinct records
6. Filter unique distinct records case sensitive
7. How to compare two data sets
8. How to copy non contiguous cell ranges
9. How to create date ranges in Excel
10. How to return a value if lookup value is in a range
11. How to use the COLUMNS function
12. How to use the MAKEARRAY function
13. How to use VLOOKUP/XLOOKUP with multiple conditions
14. Identify rows of overlapping records
15. If cell contains text from list
16. Match two criteria and return multiple records
17. Populate drop down list with unique distinct values sorted from A to Z
18. Rearrange values using formulas
19. Search for a text string in a data set and return multiple records
20. Sort a column alphabetically
21. Split data across multiple sheets – VBA
22. Use a drop down list to search and return multiple values
23. Working with Relational Tables in Excel
COMBIN function
1. How to generate a round-robin tournament
2. How to use the COMBIN function
COMBINA function
1. How to use the COMBINA function
Combination chart
Combinations
1. Identify numbers in sum using Excel solver
Combine Merge
1. Merge cell ranges into one list
2. Merge tables based on a condition
Combobox
1. Working with COMBO BOXES [Form Controls]
Compare
1. Compare tables: Filter records occurring only in one table
2. Compare two columns and extract differences
3. Compare two columns in different worksheets
4. How to highlight differences and common values in lists
COMPLEX function
1. Complex Calculations: A Guide to Excel’s IM Functions
Complex numbers
CONCAT function
1. How to extract numbers from a cell value
2. How to use the CONCAT function
Concatenate
1. Lookup and return multiple values concatenated into one cell
CONCATENATE function
1. How to use the CONCATENATE function
Conditional formatting
1. Advanced Date Highlighting Techniques in Excel
2. Advanced Techniques for Conditional Formatting
4. Highlight unique values in a filtered Excel table
5. How to highlight differences and common values in lists
6. How to highlight duplicate values
7. Working with Conditional Formatting formulas
CONFIDENCE
CONFIDENCE.NORM
1. How to use the CONFIDENCE.NORM function
CONFIDENCE.T function
1. How to use the CONFIDENCE.T function
CONVERT function
1. How to use the CONVERT function
CORREL function
1. How to use the CORREL function
COS function
1. Complex Calculations: A Guide to Excel’s IM Functions
2. Engineering functions – D to IMC
3. How to use the COS function
COT function
1. How to use the COT function
Count
1. Count cells containing text from list
COUNT function
1. Count unique distinct values
2. Create a dynamic named range
3. Create dependent drop down lists containing unique distinct values
4. Extract specific word based on position in cell value
6. How to create date ranges in Excel
7. How to use the COUNT function
8. If cell contains text from list
9. Search for a text string in a data set and return multiple records
Count text values
Count unique distinct records
1. Count unique distinct records
Count unique distinct values
1. Count unique distinct values
Count values
2. Count cells containing text from list
3. Count unique distinct values
COUNTA function
1. Add values to a regular drop-down list programmatically
2. Automate net asset value (NAV) calculation on your stock portfolio
3. Compare the performance of your stock portfolio to S&P 500 using Excel
4. Count unique distinct values
5. Create a dynamic named range
6. Create dependent drop down lists containing unique distinct values
8. How to compare two data sets
9. How to generate a round-robin tournament
10. How to use Pivot Tables – Excel’s most powerful feature and also least known
11. How to use the COUNTA function
12. Lookup with any number of criteria
13. Match two criteria and return multiple records
14. Team Generator
15. Wildcard lookups and include or exclude criteria
COUNTBLANK function
1. How to use the COUNTBLANK function
COUNTIF
COUNTIF function
1. 5 easy ways to extract Unique Distinct Values
2. 5 easy ways to VLOOKUP and return multiple values
3. A beginners guide to Excel array formulas
4. Automate net asset value (NAV) calculation on your stock portfolio
5. Cleaning Up Excel Worksheets: Eliminating Blank Cells, Rows, and Errors
6. Compare tables: Filter records occurring only in one table
7. Compare the performance of your stock portfolio to S&P 500 using Excel
8. Compare two columns and extract differences
9. Compare two columns in different worksheets
11. Count unique distinct records
12. Count unique distinct values
13. Create dependent drop down lists containing unique distinct values
16. Extract a list of duplicates from a column
17. Extract a unique distinct list from multiple non adjacent cell ranges
18. Extract a unique distinct list sorted from A to Z
19. Extract all rows from a range that meet criteria in one column
20. Extract duplicates from a multi-column cell range
21. Extract unique distinct values from a multi-column cell range
22. Extract unique distinct values from an Excel Table filtered list
23. Filter duplicate values based on criteria
24. Filter unique distinct records
25. Find all sequences of consecutive dates
27. Find the most recent date that meets a particular condition
28. Get date ranges from a schedule
29. Highlight unique values in a filtered Excel table
30. How to compare two data sets
31. How to generate a round-robin tournament
32. How to highlight duplicate values
33. How to list unique distinct values sorted by frequency
34. How to perform a two-dimensional lookup
35. How to return a value if lookup value is in a range
36. How to sort a data set using three different approaches, built-in tools, array formulas, and VBA
37. How to use the COUNTIF function
38. How to use VLOOKUP/XLOOKUP with multiple conditions
39. If cell contains text from list
40. INDEX MATCH – multiple results
41. Lookup with any number of criteria
42. Match two criteria and return multiple records
43. Merge cell ranges into one list
44. Partial match and return multiple adjacent values
45. Partial match for multiple strings – AND logic
46. Plot date ranges in a calendar
47. Populate drop down list with unique distinct values sorted from A to Z
48. Repeat values across cells
49. Rotating unique groups with no repeat
50. Sort a column alphabetically
52. Team Generator
54. Use a drop down list to search and return multiple values
55. VLOOKUP – Return multiple unique distinct values
56. Working with COMBO BOXES [Form Controls]
57. Working with unique values
COUNTIFS function
1. Calculate machine utilization
2. Compare tables: Filter records occurring only in one table
3. Count cells containing text from list
4. Count unique distinct records
5. Count unique distinct values
6. Extract a list of duplicates from a column
7. Extract dates from overlapping date ranges
8. Extract unique distinct values from an Excel Table filtered list
9. Filter unique distinct records
10. Get date ranges from a schedule
11. How to compare two data sets
12. How to create date ranges in Excel
13. How to highlight differences and common values in lists
14. How to return a value if lookup value is in a range
16. How to use Pivot Tables – Excel’s most powerful feature and also least known
17. How to use the COUNTIFS function
18. How to use VLOOKUP/XLOOKUP with multiple conditions
19. Identify rows of overlapping records
20. INDEX MATCH – multiple results
21. Lookup multiple values across columns and return a single value
22. Match two criteria and return multiple records
23. Merge tables based on a condition
24. Prevent duplicate records in a worksheet
25. Search for a sequence of values
26. Split data across multiple sheets – VBA
27. Unique distinct records sorted based on count or frequency
28. Working with Conditional Formatting formulas
29. Working with overlapping date ranges
30. Working with Relational Tables in Excel
COVAR function
COVARIANCE.P function
1. How to use the COVARIANCE.P function
COVARIANCE.S function
1. How to use the COVARIANCE.S function
CRITBINOM function
CSC function
1. How to use the CSC function
CUMIPMT function
CUMPRINC function
Custom charts
1. Advanced Excel Chart Techniques
Data labels
Data validation
2. Prevent duplicate records in a worksheet
Date and Time
DATE function
1. Count unique distinct values
3. Filter unique distinct records
4. Get date ranges from a schedule
5. How to create date ranges in Excel
6. How to track sector performance in the stock market – Excel template
7. How to use the DATE function
9. Plot date ranges in a calendar
10. Populate drop down list with unique distinct values sorted from A to Z
11. Split data across multiple sheets – VBA
13. Yet another Excel Calendar
DATEDIF function
1. How to use the DATEDIF function
Dates
1. Calculate machine utilization
2. Extract dates from overlapping date ranges
3. Find all sequences of consecutive dates
4. Find the most recent date that meets a particular condition
5. Formula for matching a date within a date range
6. Get date ranges from a schedule
7. How to create date ranges in Excel
8. Identify rows of overlapping records
10. Working with overlapping date ranges
Dates
1. Calculate machine utilization
2. Extract dates from overlapping date ranges
3. Find all sequences of consecutive dates
4. Find the most recent date that meets a particular condition
5. Formula for matching a date within a date range
6. Get date ranges from a schedule
7. How to create date ranges in Excel
DATEVALUE function
1. Formula for matching a date within a date range
2. How to use the DATEVALUE function
DAVERAGE function
DAY function
1. Automate net asset value (NAV) calculation on your stock portfolio
2. Follow stock market trends – Moving Average
3. Get date ranges from a schedule
4. How to track sector performance in the stock market – Excel template
5. How to use the DAY function
7. Populate drop down list with unique distinct values sorted from A to Z
DAYS function
1. How to use the DAYS function
DB function
DCOUNT function
DDB function
DEC2BIN function
1. Engineering functions – D to IMC
2. Working with classic ciphers in Excel
DEC2HEX function
1. Engineering functions – D to IMC
2. Working with classic ciphers in Excel
DEC2OCT function
1. Engineering functions – D to IMC
DECIMAL function
1. How to use the DECIMAL function
DEGREES function
1. Complex Calculations: A Guide to Excel’s IM Functions
2. Engineering functions – D to IMC
3. How to use the DEGREES function
DELTA function
1. Engineering functions – D to IMC
Dependent drop down lists
1. Create dependent drop down lists containing unique distinct values
DGET function
Dialog boxes
DMAX function
DMIN function
DO LOOP statement
Doughnut chart
DOUNTA function
DPRODUCT function
Drop down lists
1. Advanced Techniques for Conditional Formatting
3. Populate drop down list with unique distinct values sorted from A to Z
4. Run a Macro from a Drop Down list [VBA]
5. Use a drop down list to search and return multiple values
DROP function
1. Calculate machine utilization
2. Filter unique distinct records case sensitive
3. How to create date ranges in Excel
4. How to use the DROP function
5. Merge cell ranges into one list
6. Search for a text string in a data set and return multiple records
7. Working with classic ciphers in Excel
DSTDEV function
DSTDEVP function
DSUM function
Duplicate records
Duplicate values
1. Extract a list of duplicates from a column
2. Extract duplicates from a multi-column cell range
3. Filter duplicate values based on criteria
DVARP function
EDATE function
2. How to use the EDATE function
EFFECT function
ENCODEURL function
1. How to use the ENCODEURL function
EOMONTH function
1. How to use the EOMONTH function
ERROR.TYPE function
1. How to use the ERROR.TYPE function
Evaluate method
EVEN function
1. How to use the EVEN function
EXACT function
1. 5 easy ways to extract Unique Distinct Values
2. 5 easy ways to VLOOKUP and return multiple values
3. Count unique distinct values
4. How to compare two data sets
5. How to use the EXACT function
6. If cell contains text from list
7. INDEX MATCH – multiple results
Excel Basics
Excel table
EXP function
1. How to use the EXP function
EXPAND function
1. Filter unique distinct records case sensitive
2. How to use the EXPAND function
EXPON.DIST function
1. How to use the EXPON.DIST function
EXPONDIST function
Extract
1. Extract specific word based on position in cell value
2. How to extract numbers from a cell value
F.DIST function
1. How to use the F.DIST function
F.DIST.RT
1. How to use the F.DIST.RT function
F.TEST function
1. How to use the F.TEST function
FACT function
2. How to use the FACT function
FALSE function
1. Advanced Excel Chart Techniques
2. Automate net asset value (NAV) calculation on your stock portfolio
3. Extract a list of duplicates from a column
4. Get date ranges from a schedule
5. How to generate a round-robin tournament
6. How to use the asterisk character
7. How to use VLOOKUP/XLOOKUP with multiple conditions
8. If cell contains text from list
9. INDEX MATCH – multiple results
10. Match two criteria and return multiple records
11. Merge tables based on a condition
12. Plot date ranges in a calendar
13. Populate drop down list with unique distinct values sorted from A to Z
14. Rearrange values using formulas
15. Repeat values across cells
16. Search for a text string in a data set and return multiple records
17. Unique distinct records sorted based on count or frequency
18. VLOOKUP – Return multiple unique distinct values
19. Working with classic ciphers in Excel
20. Working with Relational Tables in Excel
21. Working with unique values
FDIST function
Features
1. 5 easy ways to extract Unique Distinct Values
2. Advanced Techniques for Conditional Formatting
3. Create a dynamic named range
4. Create dependent drop down lists containing unique distinct values
6. Extract unique distinct values from an Excel Table filtered list
7. How to compare two data sets
8. How to solve simultaneous linear equations in Excel
9. How to sort a data set using three different approaches, built-in tools, array formulas, and VBA
12. How to use Pivot Tables – Excel’s most powerful feature and also least known
13. How to use the COMBIN function
15. How to use the Subtotal tool
16. Identify numbers in sum using Excel solver
17. Lookup with any number of criteria
18. Populate drop down list with unique distinct values sorted from A to Z
19. Prevent duplicate records in a worksheet
20. Run a Macro from a Drop Down list [VBA]
21. Use a drop down list to search and return multiple values
22. Working with Excel tables programmatically
Files and folders
1. Copy data from workbooks in folder and subfolders
2. Search all workbooks in a folder
3. Search for a file in folder and subfolders – UDF
Filter emails
FILTER function
1. 5 easy ways to extract Unique Distinct Values
2. 5 easy ways to VLOOKUP and return multiple values
3. Cleaning Up Excel Worksheets: Eliminating Blank Cells, Rows, and Errors
4. Compare tables: Filter records occurring only in one table
5. Compare two columns and extract differences
6. Compare two columns in different worksheets
8. Count unique distinct records
9. Count unique distinct values
10. Create dependent drop down lists containing unique distinct values
11. Extract a list of duplicates from a column
12. Extract a unique distinct list sorted from A to Z
13. Extract all rows from a range that meet criteria in one column
14. Extract dates from overlapping date ranges
15. Extract duplicates from a multi-column cell range
16. Extract records between two dates
17. Extract unique distinct values from a multi-column cell range
18. Extract unique distinct values from an Excel Table filtered list
19. Filter duplicate values based on criteria
20. Filter unique distinct records
21. Filter unique distinct records case sensitive
22. Find all sequences of consecutive dates
24. Find the most recent date that meets a particular condition
25. Get date ranges from a schedule
26. How to compare two data sets
27. How to create date ranges in Excel
28. How to extract numbers from a cell value
29. How to list unique distinct values sorted by frequency
30. How to return a value if lookup value is in a range
31. How to use the FILTER function
32. How to use VLOOKUP/XLOOKUP with multiple conditions
33. Identify rows of overlapping records
34. If cell contains text from list
35. INDEX MATCH – multiple results
36. Lookup and return multiple values concatenated into one cell
37. Lookup multiple values across columns and return a single value
38. Lookup with any number of criteria
39. Match two criteria and return multiple records
40. Merge cell ranges into one list
42. Partial match and return multiple adjacent values
43. Partial match for multiple strings – AND logic
44. Search for a sequence of values
45. Search for a text string in a data set and return multiple records
46. Sort a column alphabetically
48. VLOOKUP – Return multiple unique distinct values
49. Wildcard lookups and include or exclude criteria
51. Working with overlapping date ranges
52. Working with Relational Tables in Excel
53. Working with unique values
Filter records
1. Extract all rows from a range that meet criteria in one column
2. Extract records between two dates
3. Match two criteria and return multiple records
4. Search for a text string in a data set and return multiple records
FILTERXML function
1. A Comprehensive Guide to Splitting Text in Excel
2. How to use the FILTERXML function
3. How to use the LIKE OPERATOR
4. Rearrange values using formulas
Finance
1. Automate net asset value (NAV) calculation on your stock portfolio
2. Compare the performance of your stock portfolio to S&P 500 using Excel
3. Follow stock market trends – Moving Average
4. How to track sector performance in the stock market – Excel template
FIND function
1. Count cells containing text from list
2. Formula for matching a date within a date range
3. How to use the FIND function
4. INDEX MATCH – multiple results
5. Search for a sequence of values
6. Search for a text string in a data set and return multiple records
7. Working with classic ciphers in Excel
Find numbers in sum
1. Find numbers closest to sum
2. How to do tiered calculations in one formula
3. Identify numbers in sum using Excel solver
Fix Function
FIXED function
1. How to use the FIXED function
FLOOR function
FLOOR.MATH function
1. How to use the FLOOR.MATH function
FLOOR.PRECISE function
1. How to use the FLOOR.PRECISE function
FOR NEXT statement
1. Finding the shortest path – A * pathfinding
2. Working with comments – VBA
FORECAST function
FORECAST.LINEAR function
1. How to use the FORECAST.LINEAR function
Form Controls
1. Create a Print button – macro
3. Working with COMBO BOXES [Form Controls]
4. Working with LIST BOXES (Form Controls)
5. Working with TEXT BOXES [Form Controls]
Formula characters
1. How to use the asterisk character
FORMULATEXT function
1. How to use the FORMULATEXT function
FREQUENCY function
Frequency table
1. How to list unique distinct values sorted by frequency
FTEST function
Functions
1. How to copy non contiguous cell ranges
2. Working with COMBO BOXES [Form Controls]
Funnel chart
Fuzzy lookup
FV function
GAMMA.DIST function
1. How to use the GAMMA.DIST function
GAMMADIST function
Gantt
GCD function
1. How to use the GCD function
GDC function
1. How to use the GCD function
GEOMEAN function
1. How to use the GEOMEAN function
GoTo statement
GROUPBY function
1. How to do tiered calculations in one formula
2. How to use the GROUPBY function
GROWTH function
1. How to use the GROWTH function
HARMEAN function
1. How to use the HARMEAN function
HEX2BIN function
1. Engineering functions – D to IMC
HEX2DEC function
1. Engineering functions – D to IMC
2. Working with classic ciphers in Excel
HEX2OCT function
1. Engineering functions – D to IMC
Highlight
1. Highlight a data series in a chart
Highlight Cells Rules
1. Conditional Formatting Basics
Highlight duplicates
Histogram chart
HLOOKUP function
1. How to use the HLOOKUP function
HOUR function
1. How to use the HOUR function
HSTACK function
1. Calculate machine utilization
2. Filter unique distinct records
4. Get date ranges from a schedule
5. How to create date ranges in Excel
6. How to use the HSTACK function
7. Merge cell ranges into one list
9. Working with classic ciphers in Excel
HYPERLINK function
1. How to perform a two-dimensional lookup
2. How to use the HYPERLINK function
3. INDEX MATCH – multiple results