This is the third blog in a series about creating macros in Excel, Word and other applications within the Microsoft Office. This article is about Understanding Macro Code. Understanding Macro Code VBA is a Language Many people, after learning how to record a macro, take a look at the code and then they panic. “How […]
Archive | August, 2013
Working with Dates in Excel 2010
Recently, I was asked by one of my Excel students if there was a way to insert a date on their spreadsheet that doesn’t automatically update. The answer is “yes”. They were already familiar with the date function =TODAY(). Here is a short lesson on how to enter both types of dates and times into […]
5 steps for Creating Macros
This is the second blog post in a series about creating Excel macros, Word macros, and other macros for applications in the Microsoft Office. The big lie: Many people have been told that creating a macro is easy. They are told just turn on the recorder, do your actions, and stop the recording. While those […]
Discover How You Can Save Time with the PowerPoint Outline View
Would you like to reduce the time it takes you to create a presentation in PowerPoint 2010? The solution is to use the PowerPoint Outline feature. One of my friends travels extensively giving presentations across the country. She feels as if she is always in presentation creation mode. To help her save time during her […]