Are there documents that you work with ALL the time? This tip will definitely help you out with current documents that you are working on and would like to quickly grab the next day or later in the week.
This tip only works with the 2007 version of Access, Excel, Powerpoint, and Word.
- To keep a file in your Recent Documents list, click on the Microsoft Office Button
and then click on the little pin 
(as you hover over the pin, it will say “Pin this document to the Recent Documents list”). - When the document is pinned to your Recent Documents list, the pin changes to view from the top of the push pin
.
Short, simple, easy.
We covered Word 2007 menu and toolbar cheat sheet, so it’s only fair to give you the Excel menu and toolbar cheat sheet. Yup, Excel has one too. Very nicely done by the way, both the Excel and Word.
This workbook is comprised of 41 tabs and that doesn’t include the Introduction. Once again, some functions have been removed from Excel 2007.
“So where can I now find the Excel workbook?” you ask. Easy.
Step 1. Click on the Microsoft Office Excel Help icon or press F1. This will execute Excel Help.
Step 2. In the Search box located on the top left-hand side type in “Reference: Locations of Excel 2003 commands in Excel 2007.” A results list will display. Click on the very first result called, “Reference: Locations of Excel 2003 commands in Excel 2007.” This will display interesting information regarding the 2007 interface and where you will find commands and toolbars that you used to find in 2003.
Step 3. Scroll down about mid-way to a heading called, “Menus, toolbars and other familiar elements.” There is a brief paragraph and within that paragraph is a hyperlink called Excel Ribbon mapping workbook. Click on that hyperlink to execute the Excel spreadsheet.
Here is a quick outline of the 41 tabs of menus and toolbars that show where to navigate Excel 2007 to find the function you are looking for:
Standard
Formatting
Pivot Table
Chart Toolbar
Reviewing
Forms
Stop Recording
External Data
Formula Auditing
Full Screen
Circular Reference
Visual Basic
Web
Control Toolbox
Exit Design Mode
Watch Window
Borders
Protection
Text to Speech
List
Compare Side by Side
Drawing
WordArt
Pictures
Drawing Canvas
Organization Chart
Diagram
Ink Drawing and Writing
Ink Annotations
Shadow Setting
3-D Settings
File
Edit
View
Insert
Format
Tools
Data
Chart Menu
Window
Help
Looks like we’ve got our hands full with some pretty interesting stuff we could be doing with Excel. So let’s see what kind of “How Tos” we can put together in Administrative Sparkle. I hope you will join and participate.
I learned about a new tutorial program thanks to Administrative Arts and, because I love to share new information that I am fortunate enough to come across to my readers, this is a great new add-on feature to learn Office 2007. Programs are continually evolving and changing to some degree or another. Amazingly, Office is coming out with a 2010. I just can’t keep up!
Ribbon Hero. What makes this tutorial program different is it is downloaded and incorporated into your Office suite. You collect learning skill points as you progress through the different features in Word, Excel, and Powerpoint directly from your program.
You will love how Microsoft has brought learning their programs to a whole nother level. Check it out here.
What websites or tutorials do you know and use, provide great information, and keep you abreast of technology? Would love to hear from you!
![Reblog this post [with Zemanta]](http://img.zemanta.com/reblog_e.png?x-id=e5aa4ba8-6ec9-4f7a-8317-e8373ed13aac)
I don’t like to reinvent the wheel. Besides, it is time consuming and unnecessary. Take letters, reports, memos, legal documents, invoices, specifications, etc., any document that is used on a regular basis for your business, both internal and external. Your company should be using a standard look that represents the image they want to portray to their customers and the public. This is where templates come in. You want your documents to have a consistency that identifies the professionalism of your company.
Some people will take a report, memo, or letter that already exists and use that. This works, but there is that possibility that you will save over it and no longer have electronic documentation of the former document. If you are good about backing up your data, then you have no problem. However, in a large company, that is a hassle to request from IT to retrieve.
What a template will do is house the formatting specifications, any graphics (some companies use them on their letterhead without having to order stationery), and some of the standard language (such as used in memos). It will also prompt you to Save As, alleviating the possibility of saving over the document. There is no other choice.
To Create a Template
- Create the document just as you would any other document.
- Save As.
- Save as type, select Word Template.
- It will automatically go into a specified directory according to your Word Options. You can change the directory of your stored templates by making that change in your Word Options.
To Retrieve and Use a Template
- In the menu bar, select New. In Microsoft Office Word 2007, I have an Office Button in the top left corner of the Word Program that takes me to printing, saving, and opening documents.
- From this menu, you can select Blank Document and templates.
It’s that easy! You will love it once you get the hang of it. You will also find that you are preparing your documents much more quickly and easily than before. No more searching for the document you want to replicate, all your documents will retain consistency, and you will now be the forms and templates guru of your office.
![Reblog this post [with Zemanta]](http://img.zemanta.com/reblog_e.png?x-id=b3714c49-423d-4237-9f55-dc8c117e5a46)
