by Nate Moore | Apr 7, 2014 | Macros and VBA
There are two ways to record a macro in Excel Video 404. Absolute reference is the default. An absolute reference always goes to the same cells to perform the macro. A relative reference records the macro in relation to the cell you’re in. If the macro goes three...
by Nate Moore | Mar 31, 2014 | Macros and VBA
Excel’s Macro Recorder is a great place to start learning about macros, and we’ll do that in Excel Video 403. Watch how to start recording a macro from the Developer tab we added in Excel Video 402. You’ll see how to name the macro (make sure there are no spaces) and...
by Nate Moore | Mar 24, 2014 | Macros and VBA
We’re starting a new topic in Excel Video 402, macros and Visual Basic for Applications (VBA). Macros and VBA are helpful ways to automate repeating processes in Excel. Given how much data is in the cloud lately and how much cleanup is required to work with some of...
by Nate Moore | Mar 3, 2014 | Excel 2013, Tables
My friend John O’Connor in Missoula, Montana taught me the formatting trick I’ll show you in Excel Video 401. Last time we added a Table Style that made our data look better. If you want to customize that Table Style, here’s how to do it. Notice in the video that you...
by Nate Moore | Feb 24, 2014 | Uncategorized
Wow! We’ve made it to 400 Excel Videos. Thanks to each of you for watching and promoting these Excel Videos. Excel Video 400 starts with some simple tricks to add polish and professionalism to your Tables. If you’ve ever suffered manually shading every other row or...