The Productivity Hub
Presentations with pizzazz: Using movie clips in PowerPoint
Today, we have a guest blogger. Elyssa is an editor and project manager at Brainstorm, a leading...
Author: Suzanne100 Date: 01/29/2010
Ensuring the right data goes into Access
A Microsoft Access database is a great place to store and organize information since it gives you an...
Author: Suzanne100 Date: 01/27/2010
Setting up your Access database for success
I recently shared some guidance on when to use Microsoft Access vs. Excel for storing your data....
Author: Suzanne100 Date: 01/26/2010
Create PowerPoint handouts in Word
As I suggested last week in 4 ways to make your point in PowerPoint, handouts are a great technique...
Author: Suzanne100 Date: 01/25/2010
Boost your PowerPoint undos
By default, PowerPoint lets you take back your last 20 actions using the Undo button on the Quick...
Author: Suzanne100 Date: 01/22/2010
Quickly access hidden PowerPoint slide show options
You probably already know that you can start a PowerPoint slide show anywhere in your deck by...
Author: Suzanne100 Date: 01/21/2010
Outlook Rules That Rule - Forward mails based on keywords
I keep a lookout for useful Outlook rules (and anything else that keeps my Inbox manageable) and...
Author: Suzanne100 Date: 01/19/2010
Where should I put my data, Excel or Access?
When you have a lot of data and it needs to be organized, do you use Excel or Access?I get this...
Author: Suzanne100 Date: 01/15/2010
Excelling at Excel - Exposing hidden chart ranges
Just the other day, I was updating a chart and became vexed when a range of values that I added did...
Author: Suzanne100 Date: 01/14/2010
Excelling at Excel - Hidden cells and subtotals
When you're working in complex Excel workbooks, you may feel like you're getting lost in the...
Author: Suzanne100 Date: 01/13/2010
Excelling at Excel - Save time with the multi-functional status bar
If you're not using the Excel status bar, you're missing out on a number of time-saving tricks. The...
Author: Suzanne100 Date: 01/12/2010
Excelling at Excel: Save chart designs for easy re-use
Once you get a chart designed the way you like it (say, the Gantt chart layout we explored last...
Author: Suzanne100 Date: 01/11/2010
Project Management with Excel: Your first Gantt chart
Once you've built a basic schedule, you can greatly improve its usefulness by adding a Gantt chart....
Author: Suzanne100 Date: 01/08/2010
Project Management with Excel - Building a schedule
Are you ready for an intermediate Excel project? This one is fun, very useful, and will teach you a...
Author: Suzanne100 Date: 01/06/2010
Working with images in OneNote
As you know if you read this blog regularly, OneNote is one of my favorite programs. It's great for...
Author: Suzanne100 Date: 01/06/2010
Resolve to clean up your Outlook for the New Year
It's that time of year when people make resolutions to do things better, and one promise that I hear...
Author: Suzanne100 Date: 01/04/2010
Preparing and optimizing screenshots and photos for Office and the Web
If you're not using the Microsoft Office Picture Manager, you're leaving a powerful image editing...
Author: Suzanne100 Date: 12/30/2009
Prepare Office documents for download with the Document Inspector
Before you publicly share a Microsoft Office document (e.g., a Word file offered for download on...
Author: Suzanne100 Date: 12/29/2009
Excelling at Excel - Importing from Word documents
If you have a Word document that you want to import into Excel, first save your Word document as...
Author: Suzanne100 Date: 12/28/2009
Use custom styles to make formatting changes swiftly
When you're creating complex structured documents, you may need to alter a specific style during or...
Author: Suzanne100 Date: 12/23/2009
Fix up a Word document quickly
Yesterday we looked at hidden formatting and shared a quick tip to search and replace double spaces...
Author: Suzanne100 Date: 12/22/2009
Reveal what's really going on in Word
If you've ever grappled with a formatting issue in Microsoft Word - say, a bullet that just won't...
Author: Suzanne100 Date: 12/21/2009
Macros Made Easy - Removing hyperlinks in Excel
Macros Made Easy - Removing hyperlinks in Excel Ever wanted to quickly get rid of all hyperlinks in...
Author: Suzanne100 Date: 12/18/2009
Macros Made Easy - Assigning shortcuts after the fact
To add a shortcut key combination or toolbar button later if you didn't assign one when you created...
Author: Suzanne100 Date: 12/17/2009
Excelling at Excel - Importing Web pages into spreadsheets
You've probably noticed that if you copy Web pages into Excel spreadsheets, the program tries to...
Author: Suzanne100 Date: 12/16/2009
Excelling at Excel - Storing numbers that are longer than Excel allows
Have you ever pasted a number into Excel and watched it turn into something like this: That's not...
Author: Suzanne100 Date: 12/15/2009
Excelling at Excel - Pulling apart long lists quickly using text functions
Have you ever spent time pulling apart elements from one text field in Excel to break them into...
Author: Suzanne100 Date: 12/14/2009
Macros Made Easy - Your first macro
No, wait, don't run away! Even though they're based on Visual Basic for Applications (VBA), there's...
Author: Suzanne100 Date: 12/11/2009
Technical presentations from A to Zzz
Some presentation topics are naturally more interesting than others. For example, it’s much...
Author: Suzanne100 Date: 12/10/2009
Making effective PowerPoint slides
PowerPoint is a great tool. But like any tool, it can be misused. Ever hit your thumb with a hammer?...
Author: Suzanne100 Date: 12/08/2009
Favorite OneNote tips
I meet people who’ve seen the OneNote icon and have never clicked on it. After they see what...
Author: Suzanne100 Date: 12/07/2009
Track changes in Word without the mess
If you've ever reviewed a Word document for someone, you know how those track changes revision marks...
Author: Suzanne100 Date: 12/04/2009
Use OneNote as a calculator
In an old-fashioned notebook or its ad hoc after work alternative, the napkin, if you want to work...
Author: Suzanne100 Date: 12/03/2009
Browsing through OneNote
If you've written large team or personal notebooks in OneNote, there are times you want to move...
Author: Suzanne100 Date: 12/02/2009
Using OneNote during meetings
I once had a manager who carried around a steno pad. He wrote frequently in that steno pad in a...
Author: Suzanne100 Date: 12/01/2009
Sharing notebooks with colleagues
Sharing notebooks is a great way to keep accurate meeting notes, track information needed for...
Author: Suzanne100 Date: 11/30/2009
Productivity Hub Content Ready!
The November content package is ready to be downloaded! It contains SharePoint videos and some...
Author: Suzanne100 Date: 11/30/2009
Use OneNote when mobile
Note: There won’t be any blog posts on Thursday and Friday this week (as I imagine everyone in...
Author: Suzanne100 Date: 11/25/2009
What is OneNote and why should I use it?
Over the next few days, I’m going to introduce you to OneNote. As the name suggests,...
Author: Suzanne100 Date: 11/23/2009
Excelling at Excel: Using data bars to illustrate number ranges
Once you understand the basics of conditional formatting, you'll be ready for a slightly more...
Author: Suzanne100 Date: 11/23/2009
Excelling at Excel: An introduction to conditional formatting
If you're new to conditional formatting in Excel, it's basically just what it sounds like: cell and...
Author: Suzanne100 Date: 11/20/2009
Excelling at Excel: Working with the same data in multiple views
Have you ever wanted to look at two tabs in an Excel 2007 workbook at the same time? It's easy to...
Author: Suzanne100 Date: 11/19/2009
Outlook Rules: Custom actions - what they are and how to use them
If you're like me - the curious sort - and you've plumbed the depths of Outlook rules, you may have...
Author: Suzanne100 Date: 11/17/2009
Read your Hotmail in Outlook
If you thought you were locked into checking your Windows Live Hotmail messages on the Web, there's...
Author: Suzanne100 Date: 11/16/2009
Outlook Rules: Forward mails to a mobile device or alternative e-mail address
If you don't have remote access to your Outlook mail account or if you like to monitor a different...
Author: Suzanne100 Date: 11/13/2009