If you’ve ever worked with a lot of objects on a PowerPoint slide, you know that selecting individual objects can sometimes be quite a challenge. Starting with PowerPoint 2007, Microsoft introduced a tool that can make your life a lot easier. It’s called the Selection and Visibility pane.
PowerPoint 2010 is a great program for developing presentations, but staring at that first big blank title slide might not be very conducive to being creative (kind of like looking at that blank Word document when you’re trying to start writing a blog post). Fortunately, PowerPoint has a speedy way of getting you past the [...]
When declaring variables in VBA, you also assign a data type. But there is a trick to it: you want to choose a data type that uses the least amount of memory. In the VB Editor, which is found in the VBA help menu, I found a great chart of the data types, including what [...]
During a recent Microsoft PowerPoint 2010 training session, I was demonstrating a feature. It was how to add an action to text in order to link to a different slide in the presentation, and then adding a button to return to the original slide. One of my participants noted that his slides already had a [...]
A vertical Lookup or most commonly known as a VLOOKUP is one of the most popular Lookup functions. It will search vertically across row headings and return the information from that row that is being searched. Your lookup value MUST be in the leftmost column but it doesn’t necessarily have to be in Column A; [...]
Are you getting tired on always grabbing the mouse when you are working in Excel? Especially, when the mouse just isn’t behaving – you know, sometimes you are just having a “bad mouse” day! Well, even though Microsoft Excel 2010 seems very mouse driven, you can still use the keyboard to perform some of the [...]
To continue with the Edit Relationships Dialog box, the next area for discussion is the Cascade Updates section.
In one of my earlier blog posts about creating Relationships between tables, you saw the Edit Relationship Dialog Box. I want to take a moment to discuss this Edit Relationship Dialog Box in a little more detail. It did look like this.
I really like using tables in Microsoft Word. You can use tables to create some pretty nifty layouts that would otherwise be difficult in Word. In a recent training session, I was asked about a table behavior that I don’t particularly like. By default, if your table breaks across pages, Word allows the table row [...]
The most recent versions of PowerPoint (2007 and 2010) have this really cool feature where you can click in any bullet list and convert that dull old list into a SmartArt graphic. This Convert to SmartArt function is not available in Word, but it’s not too hard to achieve. Let’s take a look.
