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 VBA Macro Programming” book. A macro is a series of commands that can be executed […]
Archive | July, 2013
Word 2010 The Secret to Working with Pictures
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 drag them to a new position and the picture just jumps around to unlikely places. […]
Transforming a PowerPoint 2010 Bulleted List with SmartArt
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 many cool shapes and diagrams that you can use to enhance your presentation. Today, you […]
Understanding VLookup
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 ID number and return the corresponding title, year, category, rating, etc. The following slides, used […]
Save time with AutoCorrect – Automatically Inserting Text – Like Magic!
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 acronym! AutoCorrect is programmable! Many of us are pretty quick typists, but some things can […]
Starting Outlook in Safe Mode
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 is a way to fix this. It’s called “Safe Mode”. To start Outlook in Safe […]
How to plan your Access or FileMaker Pro database – Part 3
Before creating a database you should have some blueprints that will guide its creation. In part one of this series we talked about having sketches of input forms and reports. Part two was about creating a list of fields in a “Field List Worksheet” document. Now we are going to talk about creating an ER […]