Inflation Adjusted Limits and Thresholds

Apr 25, 2018 | Tax Topics

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...

Using TextJoin

Jan 25, 2018 | Excel, Functions, Text Functions

          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

Jan 18, 2018 | General

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....

SUBTOTAL() and AGGREGATE() -TimeSavers

Sep 7, 2017 | Functions, Misc Functions, Miscellaneous Excel Tips

Many people are only aware of the Subtotal icon and have never looked at the Subtotal function itself. After all, the icon, lets you add, average and count a list so who needs more? Well if you are one of the people who subtotal data a lot then you may want to look at...

X Axis Units in Excel Charts

Jun 16, 2016 | Charts, Excel, Miscellaneous Excel Tips

X Axis Units- Excel Charts I thought I would share this problem I ran into charting so that you don’t start banging your head against the wall as I considered doing. I have used this same data in a many different versions of Excel and never had a problem until...