by John MacDougall | Feb 2, 2017 | Tutorials
Get The Completed Workbook What Is The Name Box? The Name Box has several functions. It displays the address of the active cell. It displays the name of the cell, range or object selected if this has been named. It can be used to name a cell, range or object...
by John MacDougall | Feb 1, 2017 | Tips
Here are 7 great keyboard shortcuts to quickly perform file menu commands. Ctrl + N Create a new blank workbook. Ctrl + O Open the menu to open a saved workbook. Ctrl + S Save the current workbook or open the Save As menu is the file has not previously been...
by John MacDougall | Feb 1, 2017 | VBA
Let’s say you have a column of data and in each cell you have a text string which is a list of items separated by a comma. Something like the below table. Download Example File How can you get the Nth item from that list? One solution would be to use text...
by John MacDougall | Feb 1, 2017 | Tips
Here are 12 great keyboard shortcuts to quickly format your data. Ctrl + Shift + ~ Apply general format. Ctrl + Shift + $ Apply currency format. Ctrl + Shift + % Apply percent format. Ctrl + Shift + ^ Apply scientific format. Ctrl + Shift + # Apply date format....