Advanced Microsoft Excel tutorials

SUMIFS Function in Excel

The SUMIFS function will sum numbers based on one or more criteria. It is superior to the SUMIF function.

Find the lowest / highest values for rows or columns with conditional formatting in Excel

You can find the lowest or highest values for rows or columns in Excel using Conditional Formatting with the MIN and MAX Functions.

Break-even in Accounting - Cost Volume Profit Analysis

In Accounting, Cost Volume Profit (CVP) is used to find a company's Break-even point. Revenues cover expenses and there is zero net profit.

Getting Started with IF functions in Excel

The IF function is one of the most useful and popular functions in Excel. We will use IF with absolute cell reference in this exercise.

The Rule of 72 answers "When will my investment double?"

The rule of 72 is an easy way to determine when will my investment will double at a given interest rate. Divide 72 by the annual rate of return.

Covert date to fiscal quarter in Excel

In Excel, to calculate the fiscal quarter that starts with a month other than January, use the CHOOSE function. We will look at fiscal years starting in July, October, and then April in this exercise.

Be careful when averaging percentages

When averaging percentages, use caution. It is a common mistake to in data analysis.

Use What-If Analysis with Data Tables in Excel

Calculate multiple results by using a data table in Excel.

How to get and transform data in Microsoft Excel

One of Excel 2016's best features is Get and Transform data using the Power Query Editor on the Data tab. It changes crosstab data to flat data.

Sunburst Chart in Microsoft Excel

The sunburst chart or multi-level pie chart is ideal for displaying hierarchical data. This short tutorial shows you how to create one.

Group Numbers in Excel and IFS and FormulaText functions

Need to group numbers in Excel? Shown are three methods for grouping numbers.