Let’s Get Rid of =GetPivotData
=GetPivotData If you use pivot tables a lot, then you have run into the GetPivotData formula. The other day, I was trying to create a formula referencing some pivot table cells and the GetPivotData formula popped up when I did not want it to. Today, I read Debra...
Qualified Business Income
Need Info on Qualified Business Income? A lot of people have been asking about Qualified Business Income recently and one of our authors, Paul Winn CLU ChFc has nicely offered us an excerpt from his course Tax Cuts and Jobs Act -Individual Tax Preparation. Qualified...
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....