Find & Select Constants

by CPA Self Study | Jan 16, 2019 | Copying and Moving, Excel, Formatting, Miscellaneous Excel Tips

I just discovered this little timesaver and thought I would share it with you. Okay, to be honest, my husband told me about it. Suppose you have an Excel spreadsheet and you have a number of product codes all in one row and need to break them out. You can do text to...

Fixed Decimal Places

by CPA Self Study | Dec 2, 2016 | Excel, Formatting

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

Formatting Alternate Rows

by CPA Self Study | Aug 20, 2015 | Formatting, General, Worksheet Design

Formatting alternate Rows Thanks to Diana Lawless for sending in this Excel tip. Using the Shift key and the Format Painter icon together allows you to format an entire worksheet quickly. If you are formatting alternate rows or columns quickly and do want not mess...

Conditional Formatting-Icons

by CPA Self Study | Mar 27, 2015 | Formatting

Using ICONS- Conditional Formatting When I started writing my Excel Driven Dashboard course a couple of years ago I really started appreciating a more visual approach to Excel. Now I am always incorporating color and images into spreadsheets wherever possible. So, to...