0 Items
Select Page

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

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

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

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