Understanding Macro Code

This gallery contains 5 photos.

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 … Continue reading

More Galleries | Leave a comment

Working with Dates in Excel 2010

This gallery contains 2 photos.

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 … Continue reading

More Galleries | Leave a comment

5 steps for creating macros

This gallery contains 5 photos.

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 … Continue reading

More Galleries | Leave a comment

Discover How You Can Save Time with the PowerPoint Outline View

This gallery contains 4 photos.

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 … Continue reading

More Galleries | Leave a comment

How to run a macro

This gallery contains 2 photos.

This blog post begins a series of articles about Microsoft Office macros.  Today’s article discusses what a macro is and how to run a macro. What is a macro? The following definition and description of macros comes from our “Excel … Continue reading

More Galleries | Leave a comment

Word 2010 The Secret to Working with Pictures

This gallery contains 2 photos.

Have you ever wondered why pictures (or graphic objects) don’t go where you want them when moving them around in a Word document? Do they really have a mind of their own? To no avail, you try to click and … Continue reading

More Galleries | Leave a comment

Transforming a PowerPoint 2010 Bulleted List with SmartArt

This gallery contains 4 photos.

Would you like to liven up your bulleted lists in PowerPoint 2010 so they are visually more representative of the concept being presented by your narrative? Transforming a PowerPoint 2010 Bulleted List with SmartArt is your answer! SmartArt offers so … Continue reading

More Galleries | Leave a comment

Understanding VLookup

This gallery contains 9 photos.

Vlookup is a powerful function that can help you lookup information from a table or list of data. Suppose you have a list of 5000+ movies like the one shown below. The VLookup function will allow Excel to lookup an … Continue reading

More Galleries | Leave a comment

Save time with AutoCorrect – Automatically Inserting Text – Like Magic!

This gallery contains 7 photos.

Have you ever wondered if there was a shortcut way to typing a long company name, a long-winded department name or a long technical term? Yes you can — and you can type it in a flash using your own … Continue reading

More Galleries | Leave a comment

Starting Outlook in Safe Mode

This gallery contains 6 photos.

Every so often, for no apparent reason, Microsoft Outlook doesn’t quite start the way it should. Or worse maybe it doesn’t start at all. This may be caused by an Outlook add-in that for some reason isn’t working. Thankfully there … Continue reading

More Galleries | Leave a comment