Chat with us, powered by LiveChat
Plotting Empty Cells

Plotting Empty Cells

I received a call from my daughter yesterday. She was totally frustrated as she was trying to plot data for a class project that contained a lot of empty cells. I told her how to fix it and then learned that these suggestions would not work on a MAC. As I helped her...

Fill & Sign Forms-Adobe Acrobat DC

Fill and Sign PDF Forms Open the PDF that you want to fill in and sign using Adobe Acrobat DC. Click the Fill & Sign tool located in the right hand pane. Click in a field and start typing.Adobe may suggest responses based upon previously entered data or stored...

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

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