Please ensure Javascript is enabled for purposes of website accessibility

Excel Is Finally Keeping Up With the Joneses

Posted on by Megan Lewczyk
Accounting Excel 2019

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 reality as of April 1, 2018. It’s about time. The CPA Exam is hard enough without dealing with a subpar off-brand spreadsheet tool. Accountants should be brand snobs about something as important as the CPA Exam.

And later this year, we’re gearing up for a new edition of Microsoft Office; announced in September 2017 and scheduled to be released some time in mid-2018.

We’ve got some exciting features to look forward to, according to Thurrott:

The new data types, powered by Microsoft’s Knowledge Graph, allows users to embed rich geographic and financial data within their spreadsheets. For example, the new Geography data type allows users to get key information about a country, city, state, postcode, area, or continent. They can easily get access to information such as the population, political leaders, location, time zones, etc. without having to manually search them on the web. This data can be then used to take things to the next level with Excel’s existing filtering systems and rich charts.

I guess some of these features are not that revolutionary since the ticker symbol lookups have been available on Google Sheets for a few years. Excel wasn’t keeping up until now.

Another new feature includes the ability for smart data to auto-refresh, auto-identify, and detect if newly entered data might be a country or a stock symbol, just like it does with dates. For accountants, this feature has the most realistic applications for keeping spreadsheets consistent and up-to-date without relying on any other type of database software or VBA add-in.

Other features that look interesting, as reported by Abacus blog after the announcement of Office 2019, are:

  • A fancy new “Insight” tool that auto-generates interesting graphs and charts that can be used for decision making and don’t require much skill to create.
  • Import for machine learning algorithms that could aid in detecting anomalies in large datasets. I anticipate accounting firms will be excited about the idea of making use of Excel automation to find exceptions and high-risk transactions. I also see this being the start of the trend toward 100% audit sampling and transaction testing. Accountants are less scared to learn new features in Excel so it makes sense that buy-in will be easier. I agree with the Abacus blogger that “Excel 2019 might ultimately mark the moment when AI fully democratized for the business world.” PwC’s Assurance Transformation Leader Bill Brennan was talking about 100% transaction testing as result of artificial intelligence two years ago.
  • Custom data types that go beyond established categories like those we discussed above. “Microsoft offered an example: if you tag a column ‘Company Names,’ Excel will recognize the dataset to be a series of companies for which it can search Bing to find additional data.”

It’s all a big step forward for Excel and makes some of the more robust software solutions I mentioned two years ago less of a necessity going forward. The one huge drawback is that Office 2019 will only work on Windows 10 — that is unless you subscribe to Microsoft Office 365. But, most people are on Windows 10 by now, aren’t they?

Image: iStock/Rawpixel

Related Posts

CPA Exam Memory Aids, Do You Need Them?

For some, lease accounting comes easy and you don’t need a catchy tune to help you remember title-transfer, bargain purchase and 75% of its useful life. But for most of us, retaining the information critical to getting through a multiple choice question every minute or minute and a half requires either divine intervention or a really excellent collection of memory aids. Since some of you may be atheists, let’s talk memory aids. Pay attention, especially those of you taking FAR who need help getting through such a huge mess of information.


Post its are your friend! Are you having trouble remembering present value tables or the three necessary components of an audit opinion? Not to worry, just grab a pack (or 20) of sticky notes and start writing down mnemonics or calculations and sticking them everywhere you might see them; your fridge, the bathroom mirror, your car’s rearview mirror (don’t forget to take it down before you drive), your desk, and especially on top of the PlayStation. Swap out your old notes for new ones every couple of days as you add new information and be sure to read them every time you pass the note. If you’re one of those folks who has this stuff down but just needs a little encouragement, you can also use this trick to get a much-needed boost of confidence by writing your name, CPA and slapping them all over the house. Talk about motivation!

You have a few minutes and some scratch paper at the exam, so use it! While the Powers That Be may discourage using the 10 minutes before you actually get into the exam as a brain dump, there is no reason you can’t use 2 or 3 of those minutes to scratch out everything you can on the scratch paper you are given at Prometric. Mnemonics, keywords, formulas, FASBs, whatever, just start writing everything down before you actually launch the exam. You can help yourself out by bringing your review book with you to the test center (but not inside!) and reviewing it one last time in the car before you go in. But be careful, if you use the whole 10 minutes and don’t get through the screens, you’ll blow the whole exam and have to reschedule! 5 minutes tops!

Flashcards are your friend! No, I’m not talking about overpriced CPA review materials that your firm is nice enough to pay for, I am talking about a good old pack of 3x5s that you mark up yourself. I once had a student who claimed his homemade flashcards were what helped him through FAR even though his handwriting was so atrocious that even he couldn’t read it. Just the very act of writing down key topics helped him remember those areas when crunch time came and he was struggling at the exam. Of course this works best if you can actually read your own handwriting but don’t let that keep you from using this important tool to help in your retention of key areas. You can use them to quiz your study buddy or simply make a stack of hard-to-remember topics for your own review. Again, slip these in the car the night before you head to Prometric and flip through quickly before you walk in to take your exam.

Here’s the deal, the CPA exam isn’t meant to be easy and you aren’t supposed to be an expert on dozens if not hundreds of topics. You need to know a little bit about a lot so with the help of some simple tricks to train your brain to work in exam mode, you’ll be breezing through exam parts like no one’s business. Good luck!

CPA Exam Debuts Internationally in August

For those of you interested in taking the CPA exam in wild locales such as Bahrain or Kuwait, wait no longer, the CPA exam is officially international beginning August of 2011.

Initially announced along with CBT-e, international testing appeared to be slated to begin in January but security issues and further testing necessitated the delay.

So far Bahrain, Kuwait, Japan, Lebanon, and the United Arab Emirates (UAE) are the only countries in which the exam will be administered. After a long two year analysis, NASBA, AICPA and Prometric determined those areas to meet their stringent safety and security guidelines.


We know what you’re thinking. Bahrain?! According to the three agencies, candidate volume demand as demonstrated by candidates from those countries taking the exam in the United States was a huge factor in deciding where to administrate the exam. Sure, Japan seems like a no-brainer but up until now, international candidates have been forced to obtain a visa to physically appear in the United States for their exams, often for marathon sessions of more than one test in a two or three day period.

Other factors in deciding which countries included:

• The ability to deliver the Exam without legal obstacles.
• Security threat to the Exam (both physical security at test center and intellectual property security of Exam content) assessed at levels equivalent to those presented domestically.
• Existence of established Prometric test centers.

Other countries were analyzed ahead of this announcement but I know of at least a handful that were determined unfit for test administration based solely on security issues in those countries. Being proprietary and more heavily guarded than Colonel Sanders’ 11 herbs and spices, protecting CPA exam content was likely one of the largest concerns involved in taking the exam international.

While candidate volume and interest in the exam is also high in countries like India and Korea, security concerns are equally as high (if not higher), therefore excluding these areas for the time being. My understanding is that the AICPA is open to expanding international testing in the future and just with CBT-e, will be monitoring the situation closely after launch, ready to adjust based on results. International candidates will still have to apply with the state board of their choice and are invited to use NASBA’s Accounting Licensing Library to search for a jurisdiction in which to apply.

Can You Tattoo a CPA Exam Cheat Sheet On Your Arm?

Listen, this may seem like a ridiculous question and knowing our tax-obsessed friend Joe Kristan, chances are he was kidding when he asked it but I couldn’t help but indulge him since this is actually one I have thought about more than once.

Being pretty well-covered from head to toe in ink myself, if it were allowed (and were I completely bankrupt of ethical fortitude), tattoos #34 – 47 co be mnemonic cheat sheets. But is it allowed?

Joe asks not so subtly via Twitter:

@adrigonzo Can you tatoo [sic] cheat sheets on your arms? If so, what parts do you recommend?

Valid question (if ridiculous), no? Let’s look at the rules.


You cannot bring paper, pencil, notes, your cell phone, a calculator watch (who even USES one of those?!), or even a hat into Prometric and if you choose to bring a jacket (I hear those rooms get chilly), you’ve got to wear it all 3 – 4 hours of the exam or else risk running out of time to take a break and put it in your locker. But as far as I can tell, there is absolutely no requirement that would otherwise bar someone from writing down the “answers” in fancy script on the absorbent epidermis of their inner forearms. After all, it’s not like you can remove your skin, right?

Here’s the problem (or four):

The first is that the AICPA Board of Examiners guard their proprietary CPA exam questions with their lives. If it came down to someone being able to bypass the rules by slipping past Prometric with answers tattooed on them, chances are they’d not only skin the offender but sue the shit out of them to find out where they got those answers. Review courses may have practice questions that are similar to actual exam content and the AICPA may retire 50 questions from each section a year but NO ONE except for the AICPA Board of Examiners has an actual answer key.

That being said, if by some fluke someone were able to get their hands on real exam content (unlikely since you aren’t allowed to take scratch paper out of the room and trust me, every sheet is accounted for), the CPA exam that you get is actually pulled from a test bank of thousands if not tens or hundreds of thousands of questions. So even if you illegally smuggle out exam content and hand it to a tattoo artist, the odds that you would get the same questions on an exam are slim to none. Sure there are likely repeats (as anyone who has taken an exam section two or – God forbid – three or more times can tell you) but not so many that getting an entire random exam tattooed on you would do you any good.

So, let’s just say somehow someone gets their hands on an exact exam and somehow someone else just so happens to get that same exact exam (after tattooing the answers on their forearm). Exam content, as many of you should already know, changes twice a year. So even if the first two somehow work out, the tattoo will be obsolete in 6 months. Then what? Scrawl FAS 141(r) underneath the other rules like a cover-up? Tacky!

Lastly, let’s all keep in mind here that this is the CPA exam, a professional licensure examination that tests not only your knowledge but your personal ethics and ability to protect the public interest. Times may be changing and the public may be OK with being served by a CPA with a visible butterfly tattooed on their ankle (or, we can only hope one day, a full sleeve tattoo) but there is no way you are protecting the public if you’re starting off your career looking for ways to cheat the system.

So is it allowed? Technically yes from what I can gather. Morally that’s a big fat hell no and I shouldn’t have to explain why. We look forward to an announcement from the AICPA that all candidate tattoos must be biometrically logged before admission to the exam is granted.