Excel Tips
Replace 12 VLOOKUP with 1 MATCH »
September 15, 2017
This is another formula speed example. Say that you have to do 12 columns of VLOOKUP. You can make it faster by using one MATCH and 12 INDEX functions.
September 14, 2017
Excel Array Formulas are super powerful. You can replace thousands of formulas with a single formula once you learn the Ctrl+Shift+Enter trick. Today, a single array formula does 86,000 calculations.
September 13, 2017
Handling multiple conditions in an IF formula. This article compares the three different methods.
September 12, 2017
Build a work place calendar in Excel, even if you have an odd schedule such as Monday, Thursday, Friday, Saturday.
September 11, 2017
How many workdays between a start date and an end date? The old functions work for Monday-Friday workweeks, but there are new options for odd work weeks, even Monday, Thursday, Friday, Saturday.
Insert Functions & Loan Payments »
September 8, 2017
How to discover new calculation functions in Excel. Say you need to calculate a loan payment in Excel. This article will show you how to learn which formula to use and how Excel will walk you through the steps.
Excel Shortcut - Ctrl+T Tables Expand »
September 8, 2017
Using Ctrl+T to create a Table in Excel. If you have a chart or a pivot table or a VLOOKUP based on a range of data that might expand, using Ctrl+T is a great way to make sure the new rows are included in the chart or pivot table.
September 7, 2017
Excel - how to mark or highlight all of the formula cells in a spreadsheet. This isn't Show Formulas. It is about finding all of the formula cells and marking them in red or orange.
September 7, 2017
Today's Excel shortcut: Create a new workbook with Ctrl+N