Excel 3-D Formulas

With Excel 3D formulas you get to combine data from multiple worksheets into one summary sheet. This article includes a bonus Excel hack which shows you how to use wildcards in 3D reference formulas.

Cash vs Accrual Accounting

There are 2 different accounting methods: Cash Accounting and Accrual Accounting. Check out this article which explains the difference with a story. This makes it really easy to understand the difference between cash basis and accrual method of accounting.

Excel DGET Function

Quickly learn how to use Excel's DGET Function to lookup one or more criteria. DGET can also do a left lookup (unlike VLOOKUP). It's a forgotten Excel database function. Can you apply DGET to a range of cells? Find out in this article.

Excel FILTER Function

Excel's New Dynamic Array FILTER Function The FILTER function can be thought of as the new power lookup function; in many cases replacing the traditional VLOOKUP and INDEX/MATCH functions when searching for data in a table. Situations you will benefit from when

Excel Printing Repeat Header Rows

As explored in a previous post (Your Excel Printing Problems, Solved!), we outlined the reasons why printing in Excel is a bit trickier than printing in Word.

Excel Calendar with Holidays and Appointments

Excel Calendar with Holidays and Appointments This week’s post is a special post because it comes directly from the super-brain of one of our XelPlus community members, Adam Weaver. Adam holds both a PMP certification (Project Management Professional) and an RMP certification

Balance Sheet Secrets REVEALED with a Fun Demo

Balance Sheet Secrets REVEALED with a Fun Demo In this post, we're going to cover the basics of the balance sheet.  It's also called the statement of financial position. This is where many people get confused. I'm going to be honest with

Printing Tips

Your Excel Printing Problems, Solved! “Why is printing such an issue in Excel? This is one of the most common statements made by new, and veteran, Excel users. We write a document in Word, we hit “Print”, and the document comes out

Import Data from Web to Excel

Easily Import Data from Web to Excel (2 Practical Examples) This post will demonstrate how to import data from the Web into Excel.  There are many techniques available for this task; some are better than others, depending on the dynamic/changing nature of

Practical Excel Dashboard (Excel Hash 2019)

A Dashboard with 4 Strange Features (Excel Hash 2019) Welcome back to another edition of Excel Hash! Last year (that’s right, I said “last year”), myself and several other prominent Excel MVP online personalities participated in a challenge where we are given