Chat with us, powered by LiveChat

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

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

LEN Function

LEN Function – Counting Characters in a Cell   LEN() is one of those functions that you wonder about. LEN is a text function and depending upon what you are doing it is so useful. It counts the number of characters in a cell.  I use it all the time if I...