Top 100 CPA Blogs And Websites For Accounting & Tax Pros
Top 100 CPA Blogs We are honored to be included in the Top 100 CPA Blogs And Websites For Accounting & Tax Pros. Feedspot.com say that these are the “The Best CPA Blogs on the Planet”. So, if you are looking for information on some topic this may be...
RRI Function
Below is an excerpt from our Excel Time Value of Money course written by Joseph Helstrom,CPA. RRI RRI is a new function that was introduced in Excel 2013. It returns the equivalent interest rate for the growth of an investment. The inputs required are the number of...
Dashboard Design
I just finished updating my Excel Dashboards course, Drive Your Dashboard with Excel, and thought I would share an excerpt. Dashboard Design Creating a dashboard is NOT the same things as creating an Excel spreadsheet. By this, I mean that people tend to open an...
Leasing Question – Anyone have a recommendation?
Hey, I had a question and was hoping that someone could answer it for me. I have someone looking for a low-cost system to to calculate lease assets and liabilities and related accounting under the new lease standard. Any recommendations are appreciated....
Fixed Decimal Places
MACRO TIP FOR FIXED DECIMAL I have a Fixed Decimal Place tip, in my Must Know Excel Tips Tricks and Tools for the CPA Ebook. Eric Robinson read my tip and sent me his own tip on fixed decimal places. If you are unfamiliar with the Fixed Decimal feature in Excel, it...
DATEVALUE Function
Excel has a number of date functions. Unfortunately, they don’t all work if Excel treats the date as text. When working with downloaded data, sometimes the date must be converted from text to a format recognized by Excel. One method is to use the...
Quick & Dirty Charts
CREATING A CHART QUICKLY There are a couple of ways to create a chart. We are going to discuss the two quickest methods. This is an excerpt from our course “Creating Effective Charts in Excel”. Often you just want a quick and dirty chart –one that...
Searching on Google
Google Search Tips Many of us search on Google every day for research and/or fun. There are certain embedded features in Google that can make your search more specific and help return more items that are of interest to you. With the ability to use more specific...