Intermediate Microsoft Excel tutorials

Snap a picture of an Excel table with your smart phone and edit the spreadsheet

Excel on Android has a new feature where you can take a picture of a table and edit it 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).

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.

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.

Ten reasons to use Tables in Excel

There are over 10 reasons to use Tables in Excel instead of a data range. Here are five reasons along with a training video. There is part of the free course I created for the GSCPAs.

Excel Functions for HR Professionals

HR Professionals have a lot going on. Recruitment, benefits, compensation, and retention just to name a few. Here are Excel functions you should know. SHRM

Vertical analysis of an Income Statement in Excel

To perform vertical analysis of an income statement in Excel, take all line items and divide by the Sales. One of my MBA students asked this question.

Five examples of using named ranges in Excel

You can use named ranges in formulas in Excel, to create a bookmark to a worksheet, and use for data validation in Excel. Chris Menard shows five examples.

Import Contacts from Excel into Outlook / People

Need to import your Excel file into Outlook People / Contacts? First, make your Excel file a CSV file. Next, make sure your data is correct.

Fix missing Excel data using Go To and Ctrl + Enter by Chris Menard

If you download Excel data from a database or a csv file, occasionally critical missing data will be missing. You can fix it with Go To and Ctrl + Enter.