Featured
How to Enable Developer Mode in Excel
Developer mode allows you to create Macros and run the Visual Basic Editor. Hit ALT + T then press the o key to bring up the Excel options box or go the long way as shown below. To enable it click on File at the top left. Go to Options. Go to Customize Ribbon. Next…
How to Use Excel Macros (Creating Your First Macro)
Excel macros make repetitive tasks easier. It’s similar to having a “speed dial” on your phone. With the press of a button you can call a friend vs having to manually punch in the number. Macros work the same way. With macros you can record actions and even have Excel do formulas. Like the speed…
Continue Reading How to Use Excel Macros (Creating Your First Macro)
Excel Macros How to Use Relative References
“Relative references” sounds complicated but it’s really not. If you’re new to Macros then check out the beginner tutorial here. The best way to explain Relative references is to create a sample data set like the one below in Excel. Simply click and drag your mouse over the spreadsheet below and copy and paste it…
Continue Reading Excel Macros How to Use Relative References
Spotlight
How to Use Excel Macros (Creating Your First Macro)
Excel macros make repetitive tasks easier. It’s similar to having a “speed dial” on your phone. With the press of a button you can call a friend vs…
Continue Reading How to Use Excel Macros (Creating Your First Macro)