300 Examples

You can find related examples and features on the right side of each chapter. Below you can find 140
popular examples.

1 Find Duplicates: This example teaches you how to find duplicate values (or triplicates) and how to find
duplicate rows in Excel.

2 Drop-down List: Drop-down lists in Excel are helpful if you want to be sure that users select an item
from a list, instead of typing their own values.

3 Vlookup: The VLOOKUP function is one of the most popular functions in Excel. This page contains many
easy to follow VLOOKUP examples.

4 Histogram: This example teaches you how to make a histogram in Excel.

5 Regression: This example teaches you how to run a linear regression analysis in Excel and how to
interpret the Summary Output.

6 Percent Change: The percent change formula is used very often in Excel. For example, to calculate the
Monthly Change and Total Change.

7 Pareto Chart: A Pareto chart combines a column chart and a line graph. The Pareto principle states
that, for many events, roughly 80% of the effects come from 20% of the causes.

8 Loan Amortization Schedule: This example teaches you how to create a loan amortization schedule in
Excel.
9 Random Numbers: Excel has two very useful functions when it comes to generating random numbers.
RAND and RANDBETWEEN.

10 Remove Duplicates: This example teaches you how to remove duplicates in Excel.

11 If: The IF function is one of the most used functions in Excel. This page contains many easy to follow IF
examples.

12 Lock Cells: You can lock cells in Excel if you want to protect cells from being edited.

13 Standard Deviation: This page explains how to calculate the standard deviation based on the entire
population using the STDEV.P function in Excel and how to estimate the standard deviation based on a
sample using the STDEV.S function in Excel.

14 Count Unique Values: This example shows you how to create an array formula that counts unique
values.

15 Gantt Chart: Excel does not offer Gantt as chart type, but it's easy to create a Gantt chart by
customizing the stacked bar chart type.

16 Countif: The powerful COUNTIF function in Excel counts cells based on one criteria. This page contains
many easy to follow COUNTIF examples.

17 Budget: This example shows you how to create a budget in Excel.

18 Line Chart: Line charts are used to display trends over time. Use a line chart if you have text labels,
dates or a few numeric labels on the horizontal axis.
19 Transpose: Use the 'Paste Special Transpose' option to switch rows to columns or columns to rows in
Excel. You can also use the TRANSPOSE function.

20 Correlation: We can use the CORREL function or the Analysis Toolpak add-in in Excel to find the
correlation coefficient between two variables.

21 Time Sheet: This example teaches you how to create a simple timesheet calculator in Excel.

22 Offset: The OFFSET function in Excel returns a cell or range of cells that is a specified number of rows
and columns from a cell or range of cells.

23 Pie Chart: Pie charts are used to display the contribution of each value (slice) to a total (pie). Pie
charts always use one data series.

24 Data Tables: Instead of creating different scenarios, you can create a data table to quickly try out
different values for formulas. You can create a one variable data table or a two variable data table.

25 t-Test: This example teaches you how to perform a t-Test in Excel. The t-Test is used to test the null
hypothesis that the means of two populations are equal.

26 Advanced Filter: This example teaches you how to apply an advanced filter in Excel to only display
records that meet complex criteria.

27 Frequency Distribution: Did you know that you can use pivot tables to easily create a frequency
distribution in Excel? You can also use the Analysis Toolpak to create a histogram.

28 Scatter Plot: Use a scatter plot (XY chart) to show scientific XY data. Scatter plots are often used to
find out if there's a relationship between variable X and Y.
29 Anova: This example teaches you how to perform a single factor ANOVA (analysis of variance) in
Excel.

30 Compare Two Columns: To compare two columns, use IF, ISERROR and MATCH in Excel. You can
display the duplicates or the unique values.

31 Compound Interest: What's compound interest and what's the formula for compound interest in
Excel? This example gives you the answers to these questions.

32 Sumif: The powerful SUMIF function in Excel sums cells based on one criteria. This page contains
many easy to follow SUMIF examples.

33 Bar Chart: A bar chart is the horizontal version of a column chart. Use a bar chart if you have large
text labels.

34 Concatenate: Use CONCATENATE, CONCAT, TEXTJOIN or the & operator in Excel to concatenate (join)
two or more text strings.

35 Freeze Panes: If you have a large table of data in Excel, it can be useful to freeze rows or columns. This
way you can keep rows or columns visible while scrolling through the rest of the worksheet.

36 Weighted Average: To calculate a weighted average in Excel, simply use SUMPRODUCT and SUM.

37 Index and Match: Use INDEX and MATCH in Excel and impress your boss. Instead of using VLOOKUP,
use INDEX and MATCH. To perform advanced lookups, you'll need INDEX and MATCH.

38 Delete Blank Rows: This example teaches you how to delete blank rows or rows that contain blank
cells.
39 Sumproduct: To calculate the sum of the products of corresponding numbers in one or more ranges,
use Excel's powerful SUMPRODUCT function.

40 Subtract: There's no SUBTRACT function in Excel. However, there are several ways to subtract
numbers in Excel. Are you ready to improve your Excel skills?

41 Percentage: Calculating percentages in Excel is easy. Percentage simply means 'out of 100', so 72% is
'72 out of 100' and 4% is '4 out of 100', etc.

42 Contains Specific Text: To check if a cell contains specific text, use ISNUMBER and SEARCH in Excel.
There's no CONTAINS function in Excel.

43 Pmt: The PMT function in Excel calculates the payment for a loan based on constant payments and a
constant interest rate. This page contains many easy to follow PMT examples.

44 Calculate Age: To calculate the age of a person in Excel, use DATEDIF and TODAY. The DATEDIF
function has three arguments.

45 Indirect: Use the INDIRECT function in Excel to convert a text string into a valid reference. You can use
the & operator to create text strings.

46 Multiply: To multiply numbers in Excel, use the asterisk symbol (*) or the PRODUCT function. Learn
how to multiply columns and how to multiply a column by a constant.

47 Goal Seek: If you know the result you want from a formula, use Goal Seek in Excel to find the input
value that produces this formula result.

48 CAGR: There's no CAGR function in Excel. However, simply use the RRI function in Excel to calculate
the compound annual growth rate (CAGR) of an investment over a period of years.
49 If Cell is Blank: Use the IF function and an empty string in Excel to check if a cell is blank. Use IF and
ISBLANK to produce the exact same result.

50 AverageIf: The AVERAGEIF function in Excel calculates the average of cells that meet one criteria.
AVERAGEIFS calculates the average of cells that meet multiple criteria.

51 Substring: There's no SUBSTRING function in Excel. Use MID, LEFT, RIGHT, FIND, LEN, SUBSTITUTE,
REPT, TRIM and MAX in Excel to extract substrings.

52 Sum: Use the SUM function in Excel to sum a range of cells, an entire column or non-contiguous cells.

53 Divide: There's no DIVIDE function in Excel. Simply use the forward slash (/) to divide numbers in
Excel.

54 Remove Spaces: The TRIM function in Excel removes leading spaces, extra spaces and trailing spaces.
Use the SUBSTITUTE function to remove all spaces or non-breaking spaces.

55 Move Columns: To move columns in Excel, use the shift key or use Insert Cut Cells. You can also
change the order of all columns in one magic move.

56 Check Mark: To insert a check mark symbol in Excel, simply press SHIFT + P and use the Wingdings 2
font.

57 Comparison Operators: Use comparison operators in Excel to check if two values are equal to each
other, if one value is greater than another value, etc.

58 Sparklines: Sparklines in Excel are graphs that fit in one cell. Sparklines are great for displaying trends.
Excel offers three sparkline types: Line, Column and Win/Loss.
59 Split Cells: To split the contents of a cell into multiple cells, use the Text to Columns wizard, flash fill or
formulas.

60 Calendar: This example describes how to create a calendar in Excel (2022 calendar, 2023 calendar,
etc). If you are in a hurry, simply download the Excel file.

61 Hide Columns or Rows: Sometimes it can be useful to hide columns or rows in Excel.

62 Box and Whisker Plot: A box and whisker plot shows the minimum value, first quartile, median, third
quartile and maximum value of a data set.

63 Wrap Text: Wrap text in Excel if you want to display long text on multiple lines in a single cell.

64 NPV: The correct NPV formula in Excel uses the NPV function to calculate the present value of a series
of future cash flows and subtracts the initial investment.

65 Strikethrough: This example teaches you how to apply strikethrough formatting in Excel.

66 Hyperlinks: Use the 'Insert Hyperlink' dialog box in Excel to create a hyperlink to an existing file, a web
page or a place in this document. You can also use the HYPERLINK function.

67 Checkbox: Inserting a checkbox in Excel is easy. For example, use checkboxes to create a checklist or a
dynamic chart.

68 Forecast: The FORECAST.LINEAR function in Excel predicts a future value along a linear trend. The
FORECAST.ETS function in Excel predicts a future value using Exponential Triple Smoothing, which takes
into account seasonality.
69 Bullet Points: This page illustrates three ways to insert bullet points in Excel.

70 Slicers: Use slicers in Excel to quickly and easily filter pivot tables. Connect multiple slicers to multiple
pivot tables to create awesome reports.

71 Xlookup: If you have Excel 365 or Excel 2021, use XLOOKUP instead of VLOOKUP. The XLOOKUP
function is easier to use and has some additional advantages.

72 Add or Subtract Time: Use the TIME function in Excel to add or subtract hours, minutes and seconds.
To add up times in Excel, simply use the SUM function.

73 Insert Row: To quickly insert a row in Excel, select a row and use the shortcut CTRL SHIFT +.

74 Shade Alternate Rows: To shade alternate rows in Excel, use conditional formatting or apply a table
style.

75 Subtotal: Use the SUBTOTAL function in Excel (instead of SUM, COUNT, MAX, etc.) to ignore rows
hidden by a filter or to ignore manually hidden rows.

76 Quick Analysis: Use the Quick Analysis tool in Excel to quickly analyze your data. Quickly calculate
totals, quickly insert tables, quickly apply conditional formatting and more.

77 Copy a Formula: Simply use CTRL + c and CTRL + v to copy and paste a formula in Excel. Use the fill
handle in Excel to quickly copy a formula to other cells.

78 Compare Two Lists: This example describes how to compare two lists using conditional formatting.

79 AutoFit: You probably know how to change the width of a column in Excel, but do you also know how
to automatically fit the widest entry in a column?
80 Time Difference: Calculating the difference between two times in Excel can be tricky. Times are
handled internally as numbers between 0 and 1.

81 IRR: Use the IRR function in Excel to calculate a project's internal rate of return. The internal rate of
return is the discount rate that makes the net present value equal to zero.

82 Not Equal To: In Excel, <> means not equal to. The <> operator in Excel checks if two values are not
equal to each other. Let's take a look at a few examples.

83 Entire Rows and Columns: This example teaches you how to select entire rows and columns in Excel
VBA. Are you ready?

84 Average: The AVERAGE function in Excel calculates the average (arithmetic mean) of a group of
numbers.

85 AutoFill: Use AutoFill in Excel to automatically fill a series of cells. This page contains many easy to
follow AutoFill examples.

86 Square Root: The square root of a number is a value that, when multiplied by itself, gives the number.
The SQRT function in Excel returns the square root of a number.

87 Today's date: To enter today's date in Excel, use the TODAY function. To enter the current date and
time, use the NOW function.

88 Absolute Reference: An absolute reference in Excel refers to a fixed location on a worksheet. When
you copy a formula, an absolute reference never changes.

89 Trendline: This example teaches you how to add a trendline to a chart in Excel.
90 Show Formulas: By default, Excel shows the results of formulas. To show the formulas instead of their
results, press CTRL + ` (you can find this key above the tab key).

91 Running Total: This example teaches you how to create a running total (cumulative sum) in Excel. A
running total changes each time new data is added to a list.

92 Rank: The RANK function in Excel returns the rank of a number in a list of numbers.

93 Combination Chart: A combination chart is a chart that combines two or more chart types in a single
chart.

94 Randomize List: This article teaches you how to randomize (shuffle) a list in Excel.

95 DateDif: To get the number of days, weeks or years between two dates in Excel, use the DATEDIF
function. The DATEDIF function has three arguments.

96 PDF: This page teaches you how to convert an Excel file to a PDF file.

97 Weekdays: Use WEEKDAY, NETWORKDAYS and WORKDAY to create cool weekday formulas in Excel.
Are you ready to improve your Excel skills?

98 Read-only Workbook: This example shows you how to make your Excel workbook read-only.

99 Frequency: The FREQUENCY function in Excel calculates how often values occur within the ranges you
specify in a bin table.

100 Circular Reference: A circular reference in Excel occurs when a formula directly or indirectly refers to
its own cell. This is not possible.

101 Dependent Drop-down Lists: This example describes how to create dependent drop-down lists in
Excel.

102 Add a Column: To add a column in Excel, right-click the column letter and click Insert. When you
insert a column or row, cell references update automatically.

103 Superscript and Subscript: It's easy to format a character as superscript (slightly above the baseline)
or subscript (slightly below the baseline) in Excel.

104 Pivot Chart: A pivot chart is the visual representation of a pivot table in Excel. Pivot charts and pivot
tables are connected with each other.

105 Count Cells with Text: This page illustrates multiple ways to count cells with text in Excel. Visit our
page about the COUNTIF function to count cells that contain specific text.

106 Unique Values: To find unique values in Excel, use the Advanced Filter. You can extract unique values
or filter for unique values.

107 Absolute Value: The ABS function in Excel returns the absolute value of a number.

108 InputBox Function: You can use the InputBox function in Excel VBA to prompt the user to enter a
value.

109 Named Range: Create a named range or a named constant and use these names in your Excel
formulas. This way you can make your formulas easier to understand.

110 Consolidate: You can use Excel's Consolidate feature to consolidate your worksheets (located in one
workbook or multiple workbooks) into one worksheet.

111 Error Bars: This example teaches you how to add error bars to a chart in Excel.

112 Scroll Lock: When Scroll Lock is turned on, you can use the arrow keys to scroll through the
worksheet without changing the active cell.

113 Count Words: Use TRIM, LEN, SUBSTITUTE and SUMPRODUCT in Excel to count words. First, let's
count the total number of words in a cell or range of cells.

114 Icon Sets: Icon Sets in Excel make it very easy to visualize values in a range of cells. Each icon
represents a range of values.

115 Delete Row: To quickly delete a row in Excel, select a row and use the shortcut CTRL - (minus sign).
To quickly delete multiple rows, select multiple rows and use the same shortcut.

116 XML: You can convert your Excel file to an XML data file, or vice versa. This enables you to exchange
data between different applications.

117 GetPivotData: To quickly enter a GETPIVOTDATA function in Excel, type an equal sign (=) and click a
cell in a pivot table. The GETPIVOTDATA function can be quite useful.

118 Moving Average: This example teaches you how to calculate the moving average of a time series in
Excel. A moving average is used to smooth out irregularities (peaks and valleys) to easily recognize
trends.

119 IfError: Use the IFERROR function in Excel to return an alternative result, such as text, when a
formula evaluates to an error.
120 Axes: Most chart types have two axes: a horizontal axis (or x-axis) and a vertical axis (or y-axis). This
example teaches you how to change the axis type, add axis titles and how to change the scale of the
vertical axis.

121 Page Breaks: Insert a page break in Excel to specify where a new page will begin in the printed copy.

122 Count Characters: Use the LEN function to count characters in Excel. Use LEN and SUBSTITUTE to
count specific characters in Excel.

123 AutoRecover: Excel periodically saves a copy of your Excel file. Learn how to recover a file that was
never saved and how to recover a file that has been saved at least once.

124 Text to Columns: To separate the contents of one Excel cell into separate columns, you can use the
'Convert Text to Columns Wizard'.

125 Percentiles and Quartiles: This example teaches you how to use PERCENTILE and QUARTILE in Excel.

126 Column Chart: Column charts are used to compare values across categories by using vertical bars. To
create a column chart in Excel, execute the following steps.

127 Function Keys: Function keys in Excel allow you to do things with your keyboard instead of your
mouse to increase your speed.

128 Count Blank/Nonblank Cells: Use the COUNTBLANK function in Excel to count blank cells and the
COUNTA function in Excel to count nonblank cells.

129 Protect Sheet: When you share an Excel file with other users, you may want to protect a worksheet
to help prevent it from being changed.
130 Last Day of the Month: To get the date of the last day of the month in Excel, use the EOMONTH (End
of Month) function.

131 Heat Map: To create a heat map in Excel, simply use conditional formatting. A heat map is a
graphical representation of data where individual values are represented as colors.

132 Headers and Footers: This example teaches you how to add information to the header (top of each
printed page) or footer (bottom of each printed page) in Excel.

133 Most Used Functions: Let's check out the 10 most used Excel functions. Visit our section about
functions for detailed explanations and more awesome functions.

134 Format Painter: The Format Painter is one of the most underused features of Excel. The Format
Painter copies formatting from one place and applies it to another.

135 Get Sheet Name: To return the sheet name in a cell, use CELL, FIND and MID in Excel. There's no
built-in function in Excel that can get the sheet name.

136 Loop through Defined Range: Use Excel VBA to loop through a defined range. For example, when we
want to square the numbers in the range A1:A3.

137 Calculated Field/Item: This example teaches you how to insert a calculated field or calculated item in
a pivot table.

138 Ifs: Use the IFS function in Excel 2016 or later when you have multiple conditions to meet. The IFS
function returns a value corresponding to the first TRUE condition.

139 Page Numbers: This example teaches you how to insert page numbers in Excel.
140 Flash Fill: Use flash fill in Excel to automatically extract or to automatically combine data. Flash fill is
a great Excel tool.