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

Fully illustrated Excel tutorial + 300 examples. 100% free.

Fully illustrated Excel tutorial + 300 examples. 100% free.

Fully illustrated Excel tutorial + 300 examples. 100% free.

Pivot tables are one of Excel's most powerful features. A pivot table allows you to extract the significance from a large, detailed data set.

Fully illustrated Excel tutorial + 300 examples. 100% free.

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.

Complete this section and become an Excel pro! The examples and features on this page can also be found on the right side of each chapter.

Fully illustrated Excel tutorial + 300 examples. 100% free.

Fully illustrated Excel tutorial + 300 examples. 100% free.

Complete this section and become an Excel pro! The examples and features on this page can also be found on the right side of each chapter.

This page teaches you how to find duplicate values (or triplicates) and how to find duplicate rows in Excel. Select a range of cells. On the Home tab, in the Styles group, click Conditional Formatt...

Complete this section and become an Excel pro! The examples and features on this page can also be found on the right side of each chapter.

To delete blank rows in Excel, use Go To Special, Blanks. You can also use the COUNTA function and a filter to remove empty rows.

Discover how functions in Excel help you save time. If you are new to functions in Excel, we recommend you to read our introduction to formulas and functions first.

Fully illustrated Excel tutorial + 300 examples. 100% free.

Cell references in Excel are very important. Understand the difference between relative, absolute and mixed reference, and you are on your way to success.

A formula is an expression which calculates the value of a cell. Functions are predefined formulas and are already available in Excel.

To calculate the age of a person in Excel, use DATEDIF and TODAY. The DATEDIF function has three arguments. Enter the date of birth into cell A2.

A formula is an expression which calculates the value of a cell. Functions are predefined formulas and are already available in Excel.

A formula is an expression which calculates the value of a cell. Functions are predefined formulas and are already available in Excel.

Fully illustrated Excel tutorial + 300 examples. 100% free.

Fully illustrated Excel tutorial + 300 examples. 100% free.

Pivot tables are one of Excel's most powerful features. A pivot table allows you to extract the significance from a large, detailed data set.

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

Complete this section and become an Excel pro! The examples and features on this page can also be found on the right side of each chapter.

Pivot tables are one of Excel's most powerful features. A pivot table allows you to extract the significance from a large, detailed data set.

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.

A formula is an expression which calculates the value of a cell. Functions are predefined formulas and are already available in Excel.

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

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.

To split a cell in Excel, add a new column, change the column widths and merge cells. To split the contents of a cell into multiple cells, use the Text to Columns wizard, flash fill or formulas.

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.

Inserting a checkbox in Excel is easy. For example, use checkboxes to create a checklist or a dynamic chart. You can also insert a check mark symbol.

This example teaches you how to make a histogram in Excel. You can use the Analysis Toolpak or the Histogram chart type. First, enter the bin numbers (upper levels).

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 in Excel.

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.

Pivot tables are one of Excel's most powerful features. A pivot table allows you to extract the significance from a large, detailed data set.

To quickly remove duplicates in Excel, use the tool on the Data tab. Use the Advanced Filter if you don't want to delete duplicates permanently.

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

This example teaches you how to create a loan amortization schedule in Excel.

To calculate the age of a person in Excel, use DATEDIF and TODAY. The DATEDIF function has three arguments. Enter the date of birth into cell A2.

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.

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

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.

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

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

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

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.

Excel has two very useful functions when it comes to generating random numbers. The RAND function generates a random decimal number between 0 and 1.

This page describes how to compare two lists in Excel using conditional formatting. For example, you may have two lists of NFL teams.

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.

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

Use conditional formatting in Excel to automatically highlight cells based on their content. Apply a rule or use a formula to determine which cells to format.

This example teaches you how to make a histogram in Excel. You can use the Analysis Toolpak or the Histogram chart type. First, enter the bin numbers (upper levels).

To calculate a weighted average in Excel, simply use SUMPRODUCT and SUM.

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.

A formula is an expression which calculates the value of a cell. Functions are predefined formulas and are already available in Excel.

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

This example teaches you how to perform a single factor ANOVA (analysis of variance) in Excel. A single factor ANOVA is used to test the null hypothesis that the means of several populations are all...

If you set a print area in Excel, only that area will be printed. The print area is saved when you save the workbook.

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

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

Excel includes a tool called solver that uses techniques from the operations research to find optimal solutions for all kind of decision problems.

Excel includes a tool called solver that uses techniques from the operations research to find optimal solutions for all kind of decision problems.

Looping is one of the most powerful programming techniques. A loop in Excel VBA enables you to loop through a range of cells with just a few codes lines.

The IF function in Excel checks whether a condition is met, and returns one value if true and another value if false. This page contains many easy to follow IF examples.

The percent change formula is frequently used in Excel. First, let's understand the formula. Next, let's calculate the monthly and total percent change over a period of time.

To calculate a weighted average in Excel, simply use SUMPRODUCT and SUM.

With Excel VBA you can automate tasks in Excel by writing so called macros. In this chapter, learn how to create a simple macro which will be executed after clicking on a command button.

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.

To quickly remove duplicates in Excel, use the tool on the Data tab. Use the Advanced Filter if you don't want to delete duplicates permanently.

In most cases, you can use the minus and plus symbols in the status bar to quickly zoom the document. Use the buttons on the View tab to zoom to a specific percentage and to zoom to a selection.

This chapter teaches you how to create an Excel VBA Userform.

This example shows you how to create an array formula in Excel that sums a range with errors.

The FORECAST (or 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...

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

VBA (Visual Basic for Applications) is the programming language of Excel. If you're an Excel VBA beginner, these 16 chapters are a great way to start. Excel VBA is easy and fun! With Excel VBA you...

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).

To insert a check mark symbol in Excel, simply press SHIFT + P and use the Wingdings 2 font. You can also insert a checkbox in Excel.

This example teaches you how to create a simple timesheet calculator in Excel. Cells that contain formulas are colored light yellow.

This page teaches you how to find duplicate values (or triplicates) and how to find duplicate rows in Excel. Select a range of cells. On the Home tab, in the Styles group, click Conditional Formatt...

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.

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.

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

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.

A range in Excel is a collection of two or more cells. This chapter gives an overview of some very important range operations.

This example shows you how to create a budget in Excel. First, enter the different type of income and expenses in column A.

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

This example describes how to create dependent drop-down lists in Excel. Here's what we are trying to achieve:

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

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

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.

This example teaches you how to create a loan amortization schedule in Excel.

A volatile function will be recalculated whenever calculation occurs in any cells on the worksheet. Let's take a look at an easy example to explain this a bit more.

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.