|Microsoft Office - Tips and Tricks - Keyword Shortcuts|
|Microsoft Office - Advanced Tips and Tricks|
|Microsoft Office Toolbars|
|Avoid ordering off the menu, if possible. use Microsoft Office Toolbars|
|Toolbars in software applications give you point and click access to the most common functions in a particular program. Without Microsoft Office toolbar buttons, youd still be able to get the job done through menus, but youd end up doing a lot more work than you needed to.|
|Microsoft Office Toolbars Rule! - The Toolbars in Microsoft Office applications save time, mouse clicks and keystrokes. Yet, Im always shocked how many small business PC users are missing out on this huge productivity booster.|
In fact, not using Microsoft Office Toolbars can be a major barrier standing in your way of using Microsoft Word and Microsoft Excel more productively. Most of what youre about to learn also applies to other Microsoft Office applications, including Microsoft Outlook and Microsoft Publisher. -
Pull-Down Menus: More Time Consuming
|Menus include virtually every available command, but you are probably visiting menus a lot more than you need to. For most of us, the great majority of whats needed is in the Standard and the Formatting Toolbars. Table 3-4 lists popular toolbar buttons. - Youll notice a few repeats in Table 3-4, such as Format Painter and Undo/Redo. Again, one of the big benefits of using multiple applications in Microsoft Office is the idea of learn once, apply many places. As youre gaining proficiency in one application, youre already learning small pieces of all the other Microsoft Office programs and toolbars. - |
ScreenTips: What Does That Microsoft Office Toolbar Button Do Again?
|Microsoft helps you to easily and quickly recall the function of each Toolbar button with something called ScreenTips. To use the ScreenTip for a particular Toolbar button, simply move your mouse pointer on top of the Toolbar button and leave it hovering there without clicking the mouse button. - |
Toolbar buttons save you lots of time in Microsoft Office -
Word - -
Format Painter -
Increase/Decrease Indent -
Insert Table -
Chart Wizard -
Fill Color -
Format Painter -
Merge and Center -
Paste Function -
Sort Ascending/Descending -
Undo/Redo - -
|Common buttons on the Standard and Formatting Toolbars in Microsoft Word and Microsoft Excel. - Within a moment, a little yellow box pops up to give you a very concise explanation of the Toolbar buttons functionality. For example, if I hover on top of the little yellow file folder button on the Standard toolbar in Microsoft Word or Microsoft Excel, a ScreenTip called Open pops up to remind me that this button is used to open a file. - |
Customizing your Microsoft Office Toolbars
|If there are a few missing wish list buttons that still have you trekking to the pull-down menus, you easily can customize Toolbars in Microsoft Office applications without any programming or even anything remotely technical. Just make a note of the menu command you want on your Toolbar. - |
Next, go to the Tools menu, Customize command, click on the Commands tab, and find the desired command and icon. Then, drag and drop the command icon up to the appropriate Toolbar with your mouse and release. Voila! If you want to save great amounts of time and make your employees more productive, invest a few minutes and place your most commonly used Microsoft Office commands on various Toolbars.
Microsoft Office Toolbars Action Items -
|- ||- ||- ||Learn how to recover a lost MS Office toolbar.
||MS Office Toolbar Dependence Syndrome
||Once a new Microsoft Office user gets comfortable with Toolbar buttons, the user is likely to virtually abandon use of more complex menu commands. So, panic can rapidly set in a when one of the Toolbars vanishes without a trace. This is one of the most common tech support and training requests I see with Microsoft Office users. - |
Easily Remedied with a Few Minutes of Training
||Include some simple training in your employee computer orientation to show how to get back a Toolbar that may have wandered off the screen. You control which Toolbars are displayed through the View menu, Toolbars command. By default, Microsoft Word and Microsoft Excel display the Standard and Formatting Toolbars. You can turn the display of various Toolbars on and off by toggling displayed checkmarks (Figure 3-3). - |
Lost MS Office Toolbars Action Items -
|- ||- |
Microsoft Word Templates
|Build a Microsoft Word templates library to slash your offset printing bills.
||Are you still paying outside companies to print small quantities of envelopes, letterhead, memo pads, vacation request forms, employment applications, employee annual evaluations and potentially dozens of other office forms and stationery? - |
Eliminating Some Outside Printing Costs with Microsoft Word Templates
Although some unusual circumstances still may justify these old-fashioned practices, most small businesses can save a bundle by setting up various templates in Microsoft Word to eliminate some of your outside printing costs.
|Four-Step Plan of Attack with Microsoft Word Templates
1) Get your companys logo digitized in a format that can be inserted readily into Microsoft Word documents and templates. If its not already in an accessible electronic format such as .TIF or .BMP, get your logo scanned in and touched up for clarity. -
2) Pull out your offset printing bills for the past year or so and see where youre spending the most. This will help you prioritize your cost-saving potential. Then determine whether some of these outside printing jobs could be handled internally if your company, for example, purchased a special grade of paper for your laser printer or invested in a high-speed color laser printer. As a fellow small business owner, I know Im constantly evaluating these cost-saving possibilities. -
3) Assemble a team of Microsoft Word savvy staff members to begin drafting some templates. For the sake of consistency and branding, your staff should agree on a common set of formatting styles (fonts, sizes and so forth). If your documents look bland, vaguely resembling as much flair and pizzazz as something coming off an electric typewriter, get familiar with some of the included Microsoft Word templates and styles. Using these pre-fabricated design elements is not difficult, but is often the key difference between an amateurish and professional document appearance. -
4) Dont format text by hand in Microsoft Word. Templates always include a set of preformatted styles, which you can easily modify or add to. As seen in Figure 3-4, you can find the Style drop-down list on the left side of the Formatting toolbar. Be sure to use styles in your Microsoft Word documents to ease your initial formatting and document maintenance. - Professionally designed styles give your documents a sense of flair and consistency, while easing maintenance burdens. -
Keeping Employees on the Same Page with Microsoft Word Templates
|To ensure consistency within your company, place newly customized and created Microsoft Word templates (.dot files) in a folder on your file server that all employees have access to. - Then, under the Tools menu, Options command, File Locations tab, select Workgroup Templates. Then Modify and select the shared template folder location (Figure 3-5). - |
To maintain greater centralized control, you may want to give read-write permissions to these files only to designated managers. Everyone else could get read-only permissions. -
|By pointing all employees Microsoft Word configurations to the same Workgroup Templates folder on your server, you can ensure that everyone has the same version of Microsoft Word templates available when choosing the File, New command.
Microsoft Word Templates Action Items -
|- ||- ||- ||- ||- ||- ||- Do you have a centralized folder on your file server where you can access, store and manage the company library of Microsoft Word templates?
File Naming Conventions
|Appoint one person in charge of server folder structure and file-naming conventions.
||Implementing a local area network (LAN) is one of the easiest ways to scale up from personal productivity to workgroup or companywide productivity. - However, once employees begin sharing file folders on a centralized file server, chaos can follow rapidly . - |
Avoid Productivity-Sapping Chaos with Well-Planned File Naming Conventions
If youre looking for an analogy in the offline world, consider what would happen if you bought a new lateral file cabinet and told everyone they could put whatever they wanted in it, without any underlying structure (no drawer labels, no hanging folders, no nothing). -
Four Steps to Organizational Success with File Naming Conventions
|As a result, its very important to appoint an owner of each shared-file folder. This person gets four key responsibilities. - |
1) Design and maintain an orderly set of folders and subfolders -
2) Monitor storage space use (checking the MBs and GBs) -
3) Purge and archive obsolete folders and files -
4) Set up and enforce file-naming conventions everyone can follow easily - This job is usually a good fit for a department manager, supervisor or team leader. The folder captain doesnt necessarily need to be that computer-literate, but does need to be very well-organized and detail-oriented. - Many small businesses assume that the internal guru or computer consultant can handle these tasks. However, by the time storage space is running low or folders have become an out-of-control mess, its usually an unwelcome emergency task that easily can be avoided by taking the above proactive steps.
File Naming Conventions Action Items -
|- ||- ||- ||- Who is responsible for archiving and purging obsolete folders and files?
Computer Virus Protection
|Treat all unexpected Microsoft Office files e-mailed to you as virus suspects (i.e computer virus protection 101).
||Microsoft Office viruses, mainly those that attack Microsoft Outlook (and to a lesser extent Microsoft Word and Microsoft Excel) are prolifically prevalent and destructive. - Worse yet, a virus will strike when you least expect it to. - So you need some basic computer virus protection techniques. - -
||Innocent until proven guilty? (when it comes to computer virus protection)
||This is not a good approach to dealing with Microsoft Office documents that appear in your e-mail Inbox. - |
Instead, unless you specifically know that the file is coming, you should handle every unsolicited Microsoft Word and Microsoft Excel file you receive in your e-mail Inbox as suspicious, even if the file comes from someone you know.
|Computer viruses can be very expensive to clean up once theyve infiltrated your company. Well look at antivirus software and best practices in more detail in Chapter 8. - But for now you should at least know that any Microsoft Word or Microsoft Excel file thats e-mailed to you that you werent expecting, no matter who its from (even from a boss, spouse or computer consultant), should be looked at with a strong degree of virus containment skepticism. - |
Third-Party Assistance with Computer Virus Protection
|In addition to keeping your third-party antivirus software up to date daily or weekly, Microsoft provides many Microsoft Office-specific security patches that, among other things, help to protect you from viruses. - |
Microsoft Assistance with Computer Virus Protection
|The Microsoft Office Product Updates Web page offers an easy way to keep up with the latest Microsoft Office patches, enhancements and service releases.
Computer Virus Protection Action Items -
|- ||- Does every desktop PC, notebook and server in your office have regularly updated third-party antivirus software installed and properly configured?
||Repair Access Databases
||Get familiar with the built-in maintenance and repair tool for Microsoft Access.
||Mention the buzzwords, relational database, and many small business managers eyes glaze over at the prospect of maintaining and repairing their Microsoft Access database. Dont let the thought of these tasks intimidate you. Maintaining and repairing a Microsoft Access database isnt much more difficult than those things you already know about other Microsoft Office applications. - |
Crucial Backups vs. Having to Repair Access Databases
|Before I introduce you to this key utility that can prevent an emergency technical support or computer consultant call, you need to do a nightly verified and regularly tested backup of any Microsoft Access databases at your company. If you have a very low tolerance for data loss, you even may want to back up more than once a day. - In Part III, well look at all kinds of data protection measures you can take to prevent expensive, devastating database corruption. But, for the time being, backing up a Microsoft Access database regularly should be a top priority. - |
Maintenance 101: Compacting and Repairing a Microsoft Access Database
|Relational databases run best when all the tables are indexed properly, the way you can look up information in a book quickly by referring to a properly designed index in the back. - Microsoft Access does a decent job of keeping these indexes up to date on its own. This alone is a huge improvement over previous generations of relational database programs. However, as various items in a database (tables, queries, reports, forms, fields and records) are added and removed, space builds up between data that makes using the database less efficient. - This dilemma is very similar in concept to the way a hard drive becomes fragmented. To eliminate disk fragmentation, youd run a defragmentation utility. In Microsoft Access, the process is called compacting. - |
Before running this utility program on a Microsoft Access database, make sure all users are out of the database, and that you have a current verified and tested backup copy. -
|To run the Compact and Repair operation on a Microsoft Access 2000 database, go to the Tools menu, choose the Database Utilities command, followed by the Compact and Repair Database command on the submenu (Figure 3-9). In most cases, Microsoft Access takes care of the rest, without complications. The Compact and Repair Database command in Microsoft Access can be used to optimize and repair a database. - |
If you want to see what kind of impact compacting has on the size of your Microsoft Access database, open Windows Explorer and look at the size of the .mdb file before and after you run the utility program.
If your Microsoft Access database application is split between two .mdb files, where one contains the data tables and the other contains the front-end, youll need to run the Compact and Repair process on each .mdb file separately.
Repair Access Databases Action Items -
|- ||- ||- ||- ||- Are any of your Microsoft Access databases split up between a front-end and back-end .mdb file?
||Outlook PST : Next >>
Outlook PST Repairs
|Learn to use two simple maintenance and repair tools for Microsoft Outlook.
||Just as with Microsoft Access databases, Microsoft Outlook Personal Folders (.pst files) can become bloated and inefficient, as well as corrupted or damaged. - |
Crucial Microsoft Outlook .pst File Backups
|As with Microsoft Access, be sure your Personal Folders File is backed up and verified every night. Again, if you have a very low tolerance for data loss, consider backing up more often than once a day. -
||The Corporate or Workgroup version of Microsoft Outlook has a very straightforward utility for compacting your Personal Folders File (.pst). And, just as when you compacted Microsoft Access .mdb files, you can get an idea of the impact of this operation by inspecting the .pst file size, both before and after compacting. Once again, you can find file size information through Windows Explorer. - |
To learn whether youre running the Corporate or Workgroup version of Microsoft Outlook 2000, go to the Help menu and choose the About command. -
|Compacting a Microsoft Outlook .pst Personal Folders File
||To compact your Personal Folders File, first exit out of Microsoft Outlook. Then, from your Start menu, go to Settings, and then Control Panel. - Within the Control Panel, open the Mail applet. Then, select the Personal Folders entry and click the Properties button, as youll see in Figure 3-10. Finally, in the Properties dialog box, click the Compact Now button. Microsoft Outlook will take over from there. Do not interrupt this operation while the file is being compacted. Although a Microsoft Outlook Personal Folders File (.pst) can become bloated, the Compact Now button allows you to remedy this problem easily. - While youre in this dialog box, for future reference record the file name and path of the Personal Folders File in Table 3-5. -
||Microsoft Outlook .pst File Maintenance Planner |
Inbox Repair Tool -
Personal Folders -
|To run the Inbox Repair Tool, youll need to know the file path location of both the Inbox Repair Tool and the Personal Folders File. Use Table 3-5 to record these file path locations. - When compacting is complete, click OK and then another OK to close the Mail applet. Then close the Control Panel. - |
Inbox Repair Tool for Microsoft Outlook .pst Files
|Sometimes, instead of just compacting for the sake of proactive maintenance, you may get an error message that prevents you from opening your Personal Folders when you launch Microsoft Outlook. If youve already tried obvious troubleshooting steps (rebooting your PC and making sure youre logged on properly), try the Inbox Repair Tool. - Because the Inbox Repair Tool utility program and Personal Folders File often end up in various locations on different PCs, the first step is to find the Inbox Repair Tool. So lets first open Windows Explorer, also known as Exploring Windows or Windows NT Explorer. - Right click on My Computer and choose the Search or Find File command. To find the Inbox Repair Tool, well search for the file named scanpst.exe, as youll see in Figure 3-11. Then record the folder path of scanpst.exe in Table 3-5 earlier in this section. The full path and file name of your Personal Folders File (.pst) already was recorded in Table 3-5 when you compacted the Personal Folders File earlier in this section. - Before you can run the Inbox Repair Tool for Microsoft Outlook, first determine where its scanpst.exe file is on your hard drive. - To launch the Inbox Repair Tool, double click on the scanpst.exe file that you found a few moments ago. Then, as you see in Figure 3-12, click the Browse button to select the location of your Personal Folders File (.pst) we identified earlier. - Before you can click Start, first enter the name and path of the Personal Folders File you want to scan. - Next, click the Start button and allow the Inbox Repair Tool to do its magic. Take great pains to make sure this process doesnt get interrupted midstream, as this may result in severe data corruption. After the Inbox Repair Tool scans through your Personal Folders File (eight steps), youll get a progress report (Figure 3-13) and an opportunity to back up your Personal Folders File before proceeding. - When youre ready to continue, click the Repair button to complete the process. Once finished, you will be asked to click OK to acknowledge that the repair process is complete. - Before the Inbox Repair Tool goes into Repair mode, youll get a brief summary of results and the opportunity to view Details of findings.
Microsoft Outlook PST Repairs Action Items - How often does your company backup users' Microsoft Outlook Personal Folders files (.pst files)?
|- ||- ||- ||- Do you know how to use the Inbox Repair Tool (scanpst.exe) to repair a damaged Microsoft Outlook .pst Personal Folders File? -