What is a Pivot Table?
I have had a couple of people ask me what a pivot table is so I made a short video that walks you through the basics. One key bit of information that I left out of the video is that if your underlying data changes, all you have to do is right-click the pivot table and...New Excel Functions Coming!
New Functions in Excel I just read a tweet from David Ringstrom and Joe McDaid about dynamic arrays and new Excel functions that are coming soon. Truly amazing and a huge time saver for many. Check out this article which shows how each of the formulas works:...Inflation Adjusted Limits and Thresholds
One of our authors, Paul Winn, recently sent me tax information. The IRS recently sent notification of modified revisions of inflation-adjusted limits and thresholds to reflect the change in calculating inflation from the previous method to the Chained Consumer Price...
Adding VLookup as a Control for Your Month-End Workpapers
VLOOKUP As a CONTROL When closing for the month, many use an Excel workbook to reconcile balances to the general ledger. As the general ledger changes, do you have a process in place to easily determine that balances previously reconciled still tie to the general...
Using TextJoin
TextJoin() TEXTJOIN is a text function that was introduced in Excel 2016 to join text in cells together. Initially, you may think that the function is not that worthwhile. After all, we already have the ampersand (& ) as well as...
Economic Nexus – South Dakota Supreme Court Case
Economic Nexus Update: Looks like many states are now moving forward with out-of-state sales tax. My guess is that many states are going to set minimum revenue amounts so the small entrepreneurs and small EBay sellers won’t be impacted. Let’s hope....
Find Files Easily
Are you an organized person? Is everything at your fingertips? If so, good for you. I, unfortunately, am a bit more unorganized and can spend quite a bit of time looking for a specific Excel file. I have found that adding keywords to a file when I create it, can help...
Passwords & Lucy the Retriever
Tips for Strong Passwords Do you use strong passwords? Are you sure? They are the key to keeping your information safe and secure. Since strong passwords are so important, a basic understanding of what constitutes a difficult to hack, strong password is essential....