June 21, 2018

Excel

excel reconciliations

Webinar: 5 Strategies for Streamlining Reconciliations in Excel

Hey there, accounting brethren. If you’ve emerged from your version of busy season unscathed and would like to squeeze in a little personal development, we recommend this free on demand webinar from our friends at FloQast: “5 Strategies for Streamlining Reconciliations in Excel.” It’s amazing how much time is wasted within accounting teams due to […]

Excel

More Than 30 Years After Its Debut, Many Controllers Still Head Over Heels for Excel

When Microsoft Corp. released its spreadsheet program, Excel for Windows (Excel 2.0), in late 1987, Lotus 1-2-3 was all the rage. “Among numbers-crunching accountants, corporate planners and business school students, the program has developed the kind of loyal following usually reserved for Madonna and the Boston Red Sox,” the New York Times wrote on Oct. […]

Accounting Excel 2019

Excel Is Finally Keeping Up With the Joneses

Two years have passed since I wrote a controversial post about ditching Excel. And as fate would have it, no one listened. We are as attached to Excel as ever. Maybe we like dealing with unruly and unresponsive files? But, those rumors about the AICPA integrating Excel into the CPA Exam have finally become a […]

excel championship

FYI, Aspiring Accountants: There’s a World Excel Championship

Finally, someone who will give you a trophy (and a sizable cash prize) for your unhealthy obsession with Excel. Certiport hosts an annual international Microsoft Excel championship. Accountants, everywhere, rejoice! Since, while generally, we are not the most athletically inclined (after all, we do spend a lot of time behind a desk), many of us […]

Accountants Should Dump Microsoft Excel for Database Software

Rumor has it that the AICPA is finally integrating Microsoft Excel into the CPA exam starting in 2018. I’ll admit my initial reaction is “it’s about time” since the generic spreadsheet I used was archaic. Apparently, almost 70% of the CPAs surveyed by the AICPA agreed. Go figure — we are all Excel-aholics who can’t get through the day without busting out a spreadsheet.

Now That The Cloud Is Mainstream, Where Do Hipster Accountants Go From Here?

Five years ago, hipster accountants were all over the cloud. We were working on clients’ books from coffee shops and Xero was this sketchy startup from New Zealand that no one had heard of. There were meetups and secret forums filled with the cloud elitists and, almost everyone in the scene had beards (except me, […]

ICYMI: AICPA Will Squeeze Excel Into the CPA Exam This Decade

The AICPA reports that Excel's ubiquity in the accounting profession caused a bunch of people to suggest, "use of Excel in the CPA Exam to create an authentic user experience." Accordingly, "The AICPA plans to launch a new testing interface utilizing Excel in 2018." If anyone has further concerns or feedback, send a raven. [AICPA]

Use Excel to Keep an Eye on Your BMI This Busy Season

Let’s assume that you’ve bought into the quantified-self craze. Your wearable technology measures every breath you take and every move you make, so now it's time for new frontiers, as in something other than the fast food drive-thru lane. It’s always easiest to start with low-hanging fruit, such as your co-workers. Body Mass Index is […]

How to Add a Nice Steaming Pile of Poo to Any Excel Spreadsheet

As the old saying goes, a picture is worth 1,000 words. There may just be instances where nothing else will do in a set of audit work papers than a steaming brown pile of excrement. This is easy to add in the mobile versions of Excel, but you can also add emoji in the desktop […]

How to Convert Spreadsheets to PDF With the Push of Button

So you regularly create spreadsheet masterworks, but the thought of sharing the details of your genius makes you break out in hives. One way to separate the outputs from your inputs is to save spreadsheets as a PDF file. It’s not hard to do so by way of the File menu, if you don’t mind […]