Dustin Wheeler

Dustin Wheeler
Dustin is a technology-driven CPA in Orem, Utah.

Social Media

Follow me on Twitter

Using the Excel SUMIF function to find that out-of-balance journal entry

One of the most underrated Excel functions that I use often is the SUMIF function.  On my Excel function tournament bracket, SUMIF ranks slightly behind the SUM, AVERAGE, IF, COUNT, PMT, and RATE functions.  Still, it has a shot at upsetting one of the higher seeds on any given day.

The SUMIF function adds the values in cells specified by a given condition or criteria.  Tim Gavin, a fellow CPA blogger, wrote a great blog post last week for the Sikich …

Continue reading Using the Excel SUMIF function to find that out-of-balance journal entry

Reversing the page order in Adobe Acrobat

A coworker stopped by my office seeking a solution to a dilemma.  She had received a large PDF document in reverse order (page 1 of the document was page 100 of the PDF, page 2 was page 99, and so on).  Since backwards workpapers are the type of thing that can drive an accountant to the brink of insanity, there was a lot at stake here.

We brainstormed a few possible ways to reverse the page order.  In the past, I …

Continue reading Reversing the page order in Adobe Acrobat