There are times text needs to be converted to lower case, proper case, or upper case for consistency sake. Excel provides functions to easily convert text in these cases. However, Excel does not convert text to sentence case — the first letter only is capitalized. Using a combination of functions will easily convert text to …
Category Archives: Excel
Shortcut to type times
Here is a new tip for me. If you type 10 space a, Excel will return 10:00 AM. Similarly, if you type p rather than a, it will return 10:00 PM. Unfortunately, to get 9:39 AM, you still have to enter 9:39 space a, which isn’t as much of a timesaver.
Excel Tip – Show formulas
Your colleague just handed you a complex spreadsheet for you to maintain. The first thing you need to know is which cells contain formulas. The easiest way to display all formulas is to press CTRL + ~ (tilde). The tilde is on the key to the left of ‘1’. Display Formulas – CTRL + ~
Slicers — Making Pivot Tables Easier
You have perfected your data analysis with a pivot table and you are about to share with other users. Slicers make Pivot Tables easier for other users to filter data in the table. Slicers are a pop-up dialog box which allow the user to click on button to quickly filter the data. To insert: Click …
Vlookup — True or False?
Vlookup is one of the functions I use the most. It can locate data within a table and return a value. One of the most confusing things about the function is whether or not to include the True or False at the end. When using the Excel Function wizard, it argument in the function is …
I Teach Accounting Information Systems 