My Accounting Information Systems students are preparing to take the Microsoft Excel Expert certification exam in a few weeks. To help them review, I have created several videos that cover topics on the exam. I am sharing the playlist of Excel videos with you, in hopes you find something useful. Some topics that are covered …
Category Archives: Excel
Best Excel Reference Book
Over the years, I have used many Excel reference books to continually try to find new tips and tricks. There have been several that have been pretty good. Some were too basic, others just not helpful. This book is aimed at the intermediate level users. This feature made the book attractive as I don’t need …
INDEX/MATCH or VLOOKUP?
The VLOOKUP function is widely used to retrieve information from a range of data. Although that function works great, most of the time, it does have some limitations. This article gives a great summary of when to use INDEX/MATCH vs the VLOOKUP function. https://excelzoom.com/3109-2/ Of course, soon in Office 365, this will all go away …
Match/Index – Best functions ever!
OK — there is a lot of competitions for the best Excel functions. However, Match and Index have to be near the top of any accountant’s list. There are times that a VLOOKUP, just won’t cut it. Remember, a VLOOKUP requires the lookup value is in the first column of the table array. Sometimes, that …
Forensic Auditing with Excel
The role of a forensic auditor may be to identify suspicious transactions which may be fraudulent. Excel can be a useful tool to review a smaller dataset. This Excel Zoom article shows users how to perform 5 simple forensic tests, including: Identify Duplicate TransactionsIdentify Rounded TransactionsFind above average paymentsIdentify a gap in transactionsCompare highest to …
I Teach Accounting Information Systems 