Microsoft Excel Blog: Tutorials and How-Tos

Post covering sorting, filters, getting started with Excel, Excel functions, subtotals, PivotTables, and other Excel features.

Excel - Share a PivotTable without the Source Data or Underlying Data

Excel - Share a PivotTable without the Source Data or Underlying Data
Posted by Chris Menard on 09/06/2022

When you share a PivotTable in Excel, even if you delete the data source worksheet, the data source is still attached to the PivotTable.

Excel - How to find the Greater Common Divisor (GCD Function) and show as Ratios

Excel - How to find the Greater Common Divisor (GCD Function) and show as Ratios
Posted by Chris Menard on 08/30/2022

The GCD Function in Excel finds the Greatest Common Divisor. We will use GCD to show Ratios in Excel.

Liquidity Ratio using Excel

Liquidity Ratio using Excel
Posted by Chris Menard on 08/21/2022

Liquidity ratios determine how quickly a company can covert assets to use them to pay short-term obligations.

Excel COUNTIF Function With Wildcard Search and Cell Reference

Excel COUNTIF Function With Wildcard Search and Cell Reference
Posted by Chris Menard on 08/18/2022

The COUNTIF function in Excel allows you to only count the number of cells that meet certain criteria. For example, the number of cells that the HR department appears in. With COUNTIF, you can do a wildcard search by using * (asterisk).

Excel Status Bar - Tips Every User Should Know

Excel Status Bar - Tips Every User Should Know
Posted by Chris Menard on 08/06/2022

The Status Bar in Excel is the area at the bottom of the windows that shows your zoom control in the right corner and Ready in the left corner.

How to SORT Data in Excel | 7 Tips

How to SORT Data in Excel | 7 Tips
Posted by Chris Menard on 08/03/2022

Excel has a powerful SORTING engine. SORT is the most popular function in Excel, and it can sort by many types of data, many attributes, and even custom sorting configurations.

Excel - Data from Picture - Microsoft 365 New Feature

Excel - Data from Picture - Microsoft 365 New Feature
Posted by Chris Menard on 07/15/2022

Have you ever had a printed page and needed to put the data in Excel? Typing the data in can be a pain. Excel now allows you to put the data in Excel using Data from Picture.

Excel - 3 Methods to Shade Every Other Row

Excel - 3 Methods to Shade Every Other Row
Posted by Chris Menard on 07/05/2022

Highlighting or shading every other row in Excel is a great way to make your data easier to read. I'll show three methods for applying color to alternate rows.

Excel - Get and Transform Data | Unpivot Columns with Two Header Rows

Excel - Get and Transform Data | Unpivot Columns with Two Header Rows
Posted by Chris Menard on 06/29/2022

Excel's Unpivot Columns, part of Power Query, is an awesome feature. It is the easier way to fix data that isn't in a tabular format.

Excel Conditional Formatting with the TODAY function | Duplicate Rule

Excel Conditional Formatting with the TODAY function | Duplicate Rule
Posted by Chris Menard on 05/16/2022

The TODAY function is one of my favorite Date & Time functions in Excel. It returns the current date and will automatically update. We will use the TODAY function with Conditional Formatting and create three rules on a date field.

Excel Accounts Payable / Accounts Receivable Exercise - Watch Chris Work

Excel Accounts Payable / Accounts Receivable Exercise - Watch Chris Work
Posted by Chris Menard on 05/12/2022

Accountants use Excel all the time. In this video, which is great for Accounting students, we look at the Accounts Receivable (AR) or Accounts Payable (AP) exercise.

Excel Recommend PivotTables - Improved Experience

Excel Recommend PivotTables - Improved Experience
Posted by Chris Menard on 05/11/2022

Recommended PivotTables in Excel is getting a great update. To use Recommended PivotTables, click the Insert Tab, and click Recommended PivotTables.