Current Expected Credit Loss (CECL) Standard
Summary of the Current Expected Credit Loss (CECL) Standard On June 16, 2016, the Financial Accounting Standards Board issued Accounting Standards Update 2016-13, Financial Instruments – Credit Losses (Topic 326) Measurement of Credit Losses on Financial Instruments. ...
SUBTOTAL() and AGGREGATE() -TimeSavers
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...DockDogs at Fair
We went to the Indiana State Fair this weekend and had a blast as usual. It is a family tradition. So much to see and do and eat. Ducks, Goats, Cows, 4H Exhibits, Scavenger Hunts, Gardens, Soybeans, Corn hole, Giant Pumpkins, Tractors, Train Dairy barn milk shakes,...
Sort Left to Right
Who knew how many different ways there are to sort? Let’s talk about changing the Sort Option Orientation. Typically you don’t have to change the orientation of sorting as the default works just fine. However, everyone in awhile, you have that one...
VLOOKUP vs INDEX MATCH
Vlookup vs Index Match -Which is Better? Chris Chau asked 27 Excel MVPs and community experts their preference and why. Check out the results. Which do you prefer? If you want more information after reading Chris’ blog, check out my course Become a Lookup...
Using TRUNC()
This is an excerpt from our Excel CPE course – Must Know Excel tips Tricks and Tools for CPAs. TRUNC() No Decimals If you don’t want the pennies in your calculation you can use =TRUNC(), short for TRUNCATE, or =INT(), short for INTEGER, to turn your data into...
Understanding Excel Time Value of Money Functions
Understanding Excel Time Value of Money Functions Below is an excerpt from our Excel Time Value of Money Functions for CPAs course. There are certain terms and conventions in Excel that are extremely important to understand prior to working with Excel time value of...
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...