Excel Easy

Master Functions

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

Strikethrough in

Strikethrough in Excel This example teaches you how to apply strikethrough formatting in Excel. You can still read text with a strikethrough effect.

Range Object in

Range Object in Excel VBA The Range object, which is the representation of a cell (or cells) on your worksheet, is the most important object of Excel VBA. This chapter gives an overview of the properties and methods of the Range object.

TEXTSPLIT function in

TEXTSPLIT function in Excel Use the TEXTSPLIT function in Excel 365 to split text into rows or columns using delimiters. This guide teaches you how to use the TEXTSPLIT function, starting with simple text splits and moving on to more advanced formulas.

Regression Analysis in

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

Create a Macro in

Create a Macro in Excel 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.

DATEDIF function in

DATEDIF function in Excel The DATEDIF function in Excel calculates the number of days, months or years between two dates. The DATEDIF function has 3 arguments.

Goal Seek in

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

Frequency Distribution in

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

Move Columns in

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

Quick Analysis in

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

Calculate Age in

Calculate Age 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.

Scatter Plot in

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

Slicers in

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

Time Difference in

Time Difference in Excel Calculating the difference between two times in Excel can be tricky. Times are handled internally as numbers between 0 and 1.

Anova in

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

FORECAST function in

FORECAST function in Excel 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 takes into account seasonality.

Find Duplicates in

Find Duplicates in Excel 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 Formatting, Highlight Cells Rules, Duplicate Values.

Add or Subtract Time in

Add or Subtract Time in Excel 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.

Contains Specific Text

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

Freeze Panes in

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

INDEX and MATCH in

INDEX and MATCH in Excel 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.

Gantt Chart in

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

Percent Change Formula in

Percent Change Formula in Excel 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.

Loop in

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

Analysis ToolPak in

Analysis ToolPak in Excel The Analysis ToolPak is an Excel add-in program that provides data analysis tools for financial, statistical and engineering data analysis.

SUM formulas in

SUM formulas in Excel Use the SUM function in Excel to sum a range of cells, an entire column or non-contiguous cells. To create awesome SUM formulas, combine the SUM function with other Excel functions.

Histogram in

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

Compound Interest Formula in

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

COUNTIF function in

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