Tutorials and training articles on Microsoft Excel - Microsoft: Chris Menard Training

Ten reasons to use Tables in Excel

Posted by Chris Menard on 01/10/2018

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.

Deselect with the CTRL key in Excel

Posted by Chris Menard on 12/27/2017

The CTRL key is used to select non-adjacent ranges which is a handy feature for charts and summing ranges. You can now deselect with the CTRL key. Huge improvement in Excel.

Excel Functions for HR Professionals

Posted by Chris Menard on 10/31/2017

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

Break-even analysis in Excel with multiple products

Posted by Chris Menard on 09/13/2017

Create a break-even analysis with multiple products in Excel. Create a contribution margin income statement using a product mix.

Use array functions in Excel to perform multiple calculations in one cell

Posted by Chris Menard on 08/28/2017

To master Microsoft Excel, you must know how to use array formulas. Array formulas can perform calculations that you can't do by using non-array formulas.

Vlookup vs Index and Match in Excel

Posted by Chris Menard on 08/26/2017

Vlookup is a powerful function but even better but less frequently used is Index and Match. Explained are two reasons to use Index and Match over Vlookup.

Calculate weekly revenue using PivotTables or Vlookup

Posted by Chris Menard on 08/20/2017

Need to calculate weekly revenue or orders in Excel? You either Vlookup or PivotTables. PivotTables have a grouping features that will calculate it.

Use the subtotal function in Excel to get totals of totals

Posted by Chris Menard on 08/18/2017

Vertical analysis of an Income Statement in Excel

Posted by Chris Menard on 08/11/2017

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.

Correct data imported into Excel from a database

Posted by Chris Menard on 08/09/2017

When you import data into Excel from a database, often dates and numbers will import as text. The issue is you can't analyze the data.

Five examples of using named ranges in Excel

Posted by Chris Menard on 07/08/2017

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.

Create a break even analysis chart in Excel by Chris Menard

Posted by Chris Menard on 05/31/2017

Break Even is when you making neither a profit nor a loss. This was a question from one of my MBA students. We will use the contribution margin

Microsoft Excel Blog: Tutorials and How-Tos