Microsoft Excel Blog: Tutorials and How-Tos

Excel - using the Scenario Manager to track house payments with skyrocketing mortgage rates

For potential homeowners, 1 year makes a HUGE difference. In 2021, we saw some of the lowest mortgage rates in the last 30 years. In July 2021, the average rate on 30-Year Fixed-Rate Mortgages was 2.87% (source FreddieMac). Today, July 2022, we are looking at rates around 5.8%.

Excel Images - Two New Features - IMAGE function and Data from Image

Excel has two new image-related features coming out. In this video, a preview of my teaching session at ASAP (American Society of Administrative Professionals) Virtual Event in November, I walk you through these two new Excel functions.

Excel Image Function

The new Excel IMAGE function enables you to insert images into cells with a formula. This great function allows you to sort, filter, and rearrange images.

Excel Highlight Every Nth Row with Conditional Formatting - Every 3rd, 4th, or 5th row.

Conditional Formatting in Excel allows you to highlight every 2nd, 3rd, 4th, or 5th row. Writing a formula using the MOD function and ROW function together allows us to do this.

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

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

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

Liquidity Ratio using Excel

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

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

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

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

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

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.