Excel & Sheets Mastery with AI

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

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.

The SWITCH function in Excel looks up a specified value in a list of values and returns the result corresponding to the first match found.

You can use Excel to sort data in a custom order. In the example below we would like to sort by Priority (High Normal Low).

When creating Userforms in Excel VBA you can use the Controls collection to easily loop through controls and set a property of each control to a specific value.

Learn how to check the spelling of text in Excel add words to your custom dictionary (or AutoCorrect list) and learn how to change spell checking options.

A combination chart is a chart that combines two or more chart types in a single chart. To create a combination chart in Excel execute the following steps.

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.

Counting with Or criteria in Excel can be tricky. This article shows several easy to follow examples.

As a beginner to Excel VBA you might find it difficult to decide where to put your VBA code. The Create a Macro chapter illustrates how to run code by clicking on a command button. This example teaches you how to run code from a module.