Free Bonus Excel Shortcuts

Free Bonus Excel Shortcuts

Blog Downloads: Youtube Video    Excel Spreadsheet       Macrostarter

Instructions for downloading your free shortcuts:

• download and copy the Macrostarter.xlsm to your desktop
• go to the windows button in the bottom left hand corner of your computer screen
• search for the folder XLSTART
• drag and drop or copy and paste the Macrostarter.xlsm file from your desktop into the XLSTART folder

Now you're ready. Open up a blank Excel sheet, then open the file you want to work with. Your Macrostarter.xlsm file is hidden in the background. 

Cool Free Excel Shortcuts

So what is contained in the Macrostarter.xlsm file???? Well to give you a clue, we think that these are two of the coolest Excel shortcuts around....

Ok, so maybe you won't be able to guess. 

Well they are....

Number formatting - puts a comma to separate thousands and also puts dashes for zeros - simply push CTRL+SHIFT+C on any number to apply

Date formatting - puts any numbers which are meant to be dates into the following format dd-mmm-yy. i.e. 31-Jan-11 - simply push CTRL+SHIFT+D

These two shortcuts are sure to save you plenty of time formatting your Excel spreadsheet or financial model. 

Do you want to become a Excel shortcut pro? If yes, then check out our Excel Shortcuts training course.

Want other great Excel and financial modelling tutorials for free? Check out the Video Financial Modelling home page.