Excel Tips
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.
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.
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.
September 7, 2017
Today's Excel shortcut: Create a new workbook with Ctrl+N
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 6, 2017
Some of the most-used keys in Excel are the Ctrl keys that you know from other Windows programs. Today, we take a look at the top keys.