Microsoft Excel Blog: Tutorials and How-Tos

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.

COUNTIF Function in Excel

One of the most powerful functions in Excel is the COUNTIF function. It counts the cells that meet a certain criteria.

Excel Loan Amortization for new car, new house, or refinance

Use Excel to create a loan amortization schedule. This is table to that shows each periodic payment on an amortizing loan (typically a mortgage or car loan).

Webinar on Excel Functions on 12/04/2018

Webinar on Excel function on Tuesday, December 4, 2018. Functions covered will include trim, count, average, median, large, countblank, and many other functions.

Merge and Center

Merge & Center in Excel is evil. I recommend you never use it. Merge & Center causes issues with sorting, removing duplicates, and selecting.

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.

Webinar of Insights in Excel – Recording of live webinar

Insights in Excel: Insights will analyze your data and return interesting visuals about it in a task pane.