You use Microsoft Word, Excel and PowerPoint on a daily basis and are still be trying to figure out where things are and how they work, using only 10% of the applications power. Below are 101 customizations and tweaks to help you harness the power of productivity, and customize MS office to work for you.
The difference between an Microsoft Office beginner and advanced user is all about knowing how to use the individual applications, and knowing how to use them well. Wondering how to use your everyday Office applications effectively?
The best way is to customize them. When you learn how to customize an application the way you want it--especially when it’s a productivity tool like an Microsoft Office program, you increase your productivity and effectiveness by leaps and bounds.
All you need is a guide on getting the best customizations out there. Read on and make the leap from Microsoft Office beginner to expert with the following list of resources, tips, tricks and tutorials.
Document Formatting – It’s
faster and easier to tweak a few things here or there to make a document truly
your own. Start tweaking your own documents with a complete document theme.
shortcut/Cheat sheets – Your
work can be full of repetitive tasks and processes. Keyboard shortcuts are designed to save the time you spend
on executing them. With these
keyboard shortcut cheat sheets it won’t be long until you’ve memorized—or
even created, your own.
– Next to content,
formatting is the biggest priority. Make the look of your document support the
meaning of your words, whether it be a numbered list, custom fonts and text or
paragraph formatting. Here are the
essentials on how to edit a few basic document formats the easy way.
Font Case in Word 2007
To start, you may want to be efficient with the basics, like changing the font
case of text you typed. This tip shows you how to do it quickly by using the
interface in Word 2007.
- Tab Key, Bulleting,
Numbering, Undo, Redo, and Printing
We all know that documents can be more than just paragraphs and sentences. Learn
how to modify the formatting defaults for common Word tasks and make your
document format diverse.
- Formatting Text
Want to create your own style? This tip shows you how by formatting text--selecting
a font typeface, choosing the font size, applying effects, adjusting colors and
more. A handy tip for any user looking to create a unique and professional
- How to
Format Paragraphs in Word 2007
Word 2007 includes many of the old Word 2003 functions you’re used to. The major difference between both
versions is how they’re accessed. The function for formatting paragraphs is one
of them. Find out how.
- Set a Table Format for Your Entire Word Document
Got an entire document full of tables? Need them all reformatted in the same style? This tip shows you how to access, customize and apply a default style to all the tables in your document.
Fonts – Nothing can change
the look and feel of your Word document better than a new font. These links
show you how and where to get them for Windows.
- How To
Install TrueType or OpenType Fonts in Windows
Whether you download fonts from the Internet or have a CD full of typefaces, in
order to use them in your word processor or other programs you’ll have to know
how to install them. Here’s a tip on how to install TrueType or OpenType fonts
for use in Windows.
- How to Install or
Remove a font in Windows
Need to install a font into Windows but not sure how? This tip shows you how to do it for Windows XP versions so
it’s available for use in Word.
- Download and Install Custom Fonts to Use with Office
When the fonts you use start to feel old and overused, try out a new one. This link directs you to useful font resources -- where to find more, how to download them and install them on your computer.
to Different Doc Types – If
you know when, where and how your readers will need the information in your
document, you can save it in a way that makes it extra easy for them to find
the Default File Format in Word 2007
Migrating to the latest version of Word? One thing you should know is that it
saves to its .docx native format by default, which most users still can’t view.
Here’s how to save documents so others can view them too.
- Save a file
With at least seven different save location options and many different versions, there’s more to keeping your document safe than clicking one button. Find out how to save your files quickly and efficiently in all types of format
DOC (MS Word Documents) to PDF Format
Convert your documents without purchasing any software. This link presents 3
quick and easy ways to do it.
Word Tips and tricks – Any
one of these tips could quickly become your favorite productivity booster.
back to top
Customizations – Make Excel
look and feel the way you want it to right from the start. Learn how to
manipulate and customize its interface, start up, toolbars and more. These
links will get you started with Excel on the right foot.
Text & Numbers in Spreadsheets -- The meaning of your data
is greatly improved when you know how to present it. With these links you can find
out how to quickly manipulate and customize the look and formatting of the numbers
and text within your spreadsheet.
– Having an Excel template
will keep you from constantly wasting time on reinventing a new look and feel for your spreadsheet.
and Calculations – Dealing
with a large amount of Excel data often requires repetitive calculations and
analysis. Macros are great
shortcuts for just this type of work. Create your own productivity shortcuts or set up different functions for
multi-step processes and use them whenever you need to.
shortcut/cheat sheets – Add these time saving shortcuts to your knowledge toolbox to get even more value from
Excel easily and effectively.
- Excel 2010 Cheat Sheet: Quick Reference Charts
All the most amazing tips and tricks in Excel available in one place.
- Keyboard Shortcuts in Excel 2010
Need to tailor your work process and increase your efficiency in Excel 2010? Here’s a detailed chart and collection of the keyboard shortcuts that’ll save you time on routine tasks.
- The Ultimate Excel Cheat
Here are the cream of the crop in Excel shortcuts. This article has it all in
one place—keyboard shortcuts, VBA code snippets, Excel functions and
formulas, command line switches and more. They come in easy-to-use cheat sheets
you can print up and keep handy.
- The Excel Formula Cheat Sheet
Formulas are important part of Excel. Learn how to use the most common Excel formulas following these instructions.
Excel Tips and Tricks – Here
are favorite tips, tricks and techniques that’ll help you customize and expand
the usability of Excel beyond the cells of its spreadsheets.
- Excel Tips
If you’re trying to learn the ins and outs of Excel 2007, here are some excellent online resources that’ll show you how
to protect cells, format text to columns, display fractions, how to freeze
formulas to their current value and more.
Microsoft Excel For Power Use
If you want to try a Power User tip, check this link out. You’ll learn how to
modify and set default .xls templates, get more formatting options and more.
- How to customize and create charts
create custom charts? It’s easy with the help of these demos that show you how
to add cool gradients and replacing graph bars with pictures.
Spreadsheet Page - Excel Tips
If you still can’t find what you’re looking for, check this list out. You’ll find tips for dealing with a
number of Excel situations you might encounter in the real world.
back to top
customizations – Don’t want
an outline of your presentation on the left? Need your favorite layout tools
grouped together for fast access? Here’s how you can make PowerPoint present
itself the way you like it.
- Customize the Quick Access Toolbar
Customizing the Quick Access Toolbar is essential for functions that are independent of the Ribbon commands. Taking a few minutes to modify this toolbar will save you hundreds more later on.
- Use the
Ribbon in PowerPoint 2007
The "Ribbon" in all Office applications introduce a context-sensitive
method for accessing commands. PowerPoint has its own special commands to deal
with graphs, and can be especially tricky to navigate. Here’s how to make it your own.
the Slide Number and Total Number of Slides on Every PowerPoint Slide
Want to show progress through a presentation? Here’s how to control that
through the master slide.
Slides In PowerPoint 2007
Presentation is everything, and you don’t want to mess up the delivery. Customize
your presentation for different audiences by hiding slides with this quick
– Presentations can be
shared in many ways including physical handouts. If you want to get more
efficient with PowerPoint, these links will help you get those handouts looking
just the way you need them.
Exporting – Want to share part of your
presentation through a different medium, or put it online where more people can
see it? These tips will help you pick it apart and put the pieces just where
- Improve PowerPoint's GIF, BMP, PNG,
JPG export resolution
Export your presentation to a file format as crisp and clear as the original
with this tutorial. You’ll get pointers on image settings for optimal
resolution using different PowerPoint versions.
Images and Sounds from PowerPoint
Sometimes you need to work with PowerPoint presentations in different ways,
especially if you need content from the .ppt file itself. This tip tells you how to quickly and
simply extract and save a single image or sound from a presentation.
- Put your PowerPoint on the Web
Learn how to make your presentation accessible to website visitors and convert
them into HTML with this tip.
PowerPoint Presentations to Video Files (with Sound)
Ever wonder how to get your PowerPoint slide onto a DVD for free? Get your
PowerPoint file exported in the format you need. AuthorStream is a PowerPoint
hosting service that’ll convert your presentation into MPEG4 video format.
shortcuts – Sometimes a few
keystrokes is all it takes to manipulate a large or complex piece of your
presentation. Here are some of those "extra" power points.
Editing – From selecting
backgrounds, to lining up animations to appear in the correct order, there’s a
lot an editor can learn from these PowerPoint tutorials.
a PowerPoint Template
Need to make quick slide changes? Modify and customize the template to freshen
up a theme and make the presentation your own with this tutorial.
a PowerPoint Presentation
If you want to be a PowerPoint power user, check out this link. Here are a few
tips on customizing your own PowerPoint presentation quickly from scratch.
These tips go beyond choosing graphics and setting text bullets.
Slides in PowerPoint
You can give your PowerPoint presentation a unique look by formatting the
slides--adding effects, changing slide texture and more.
Animation Effects in Microsoft PowerPoint
If you want to add more eye-catching content to your PowerPoint presentation,
here are a few customization tips to adding animation effects to your
- Combine Animation Techniques to Create Stunning PowerPoint Slides
For more versatility in your PowerPoint presentation, take a look at this tutorial. You'll learn how to combine motion paths with other animation effects to create dynamic and compelling presentations.
PowerPoint Tips and Tricks – Fan
favorites and tips from the trenches can help you become a power user in no
back to top
Customization – Outlook may
be "the email standard", but there’s no reason you need to settle for its
standard layout when you can make it all your own. These links show you how to
customize the email interfaces you work and the basic functions to get you
working with Outlook more efficiently.
- Outlook 2013 Quick Start Guide
Learn what is new in the latest version of Outlook. These tips can help you find your way around.
- Keyboard Shortcuts (Excel)
Need to tailor your work process and increase your efficiency in Microsoft Excel? Here’s a detailed chart and collection of the keyboard shortcuts that will save you time on routine tasks.
How you send out your emails can say a lot about you whether it’s a personal
message or a professional notification. Create custom stationery in Outlook
2003 to make your messages stand out.
Personal Folder storage in Outlook 2007
Need more custom folders and organization? Create and place Personal Folders in
the main window interface to help you sort and store your messages your way.
to Outlook 2007 – Using Desktop Alerts
If you’re too busy to check in with Outlook, let Outlook check in with you.
Desktop alerts are handy Outlook alert messages that appear on your screen. Use
them to your advantage. These
handy tips give you a run down of what they are and how to use them
Organization – Keep control
of your inbox with this tutorial set showing you how to custom organize your
Outlook email, contacts and more.
- Email Organization
If you use Outlook on a daily basis, then you know that
email organization is key. Not too
sure where to start or how to go about it? Outlook has a number of
customization settings to help you organize incoming email, outgoing email and
existing email. Here are a few tips. Use any or all of them.
E-Mailing tips in Outlook
Once you get the hang of Outlook, you’ll want more control over your email
messages. Here are a few tips on how to set reminder and expiration dates on
your messages as well as checking an email alias against your contacts.
- Create and configure an e-mail
profile in Outlook 2007 and Outlook 2003
One of the key aspects about an Outlook email account is your profile, which is
created the first time you run Outlook. If you need more than one profile for
different purposes, read this tutorial on how to create another one.
- Exporting Your Address Book from Outlook 2013
The Contacts folder is your e-mail address book and information storage for the people and businesses you want to communicate with. Learn how to export your contacts from Outlook.
- View your
Inbox Messages by Thread
You can customize your Outlook right down to the way in which you view your
messages. Check out this tip from
the Microsoft camp and learn how to read emails by thread and keep on top of
an Email Template in Outlook 2003
Saving time is a priority especially when you send out the same email over and
over again. The solution? Create a template in Outlook for those messages you
send out repeatedly.
– If you deal with a large
amount of email on a daily basis, Outlook tasks will really help you out. The following set of links lets you handle
routine daily tasks faster and more efficiently and in your own way.
and Scheduling – With these
helpful scheduling tips and tricks, you can organize more than just your inbox.
Customize your schedules, task reminders, calendar printing and even group
- Outlook Calendar Tips & Tricks
If you need better organization in your-day-to day routine, this tutorial can help you learn how to manage reminders, tasks, and deadlines.
- How to use the Group Schedules
feature in Outlook
For those that work with a number of individuals, keeping in touch can be
difficult. Try making a Group
Schedules. They enable you to view
and schedule meetings with an entire group you specify or with individual
to Create additional calendars
Nobody ever has only one schedule going. Oftentimes you need more than one calendar. With this quick tip you’ll
learn how to create separate calendars for work, personal or other uses.
2007: Print a Blank Calendar
If you need to print a calendar, but don’t want it to show your appointments, read
2003 - 24 hour clock, multiple time zones
Global work habits and hours require a global calendar to correctly schedule
appointments. Check this tip out for a guideline on how to get your calendar
working correctly wherever you are.
Tips and Tricks – Hard to
categorize, or do without, these tips will round out your skills on Outlook
Now that you’ve had a chance to scan the whole list of lessons, make sure you tuck this valuable reference sheet away. In case you read through it too quickly, review this "Save a file"
Microsoft Word tutorial for seven places and ways to make sure you can find it
when you need a fast solution to an immediate need. After all, with seven
choices, there ought to be one you can customize to fit your working needs to a
back to top
Bookmark this on Delicious