|
Available Services:
Establishing Your Staff Training Needs
Associate Programs
Tip of the Month Archive
Establishing Your Staff Training Needs
At M J H we offer free skill assessments and consultant support to help establish your Staff Training Needs.
We understand that, as an Employer, it isn't always easy to know what skill level your Employees are at. Our "easy to fill out" questionaire provides a listing of various Office Application skills. The Employee simply checks off the skills they are comfortable with and this information is used to determine what level of training your Employee requires. By working closely with you we can then move towards establishing a training schedule that minimizes work disruption while increasing productivity and your bottom line.
Available Skills Assessments:
- Access
- Excel
- Outlook
- Power Point
- Word
Please contact us for more info.
Return to Top of Page
Associate Program
Database and Website Development/Maintenance
This offering provides for a range of Database and Web Development Services for Companies who require support in this area.
Please contact us for more info.
Return to Top of Page
Tip Of The Month Archive
January/08
How to open a file in any application you want without first opening that application:
Click once on the file you want to open to select it, then hold down the Shift key as you right-click that file. In the resulting menu, you'll see a brand new menu command, Open With. (Now why couldn't Microsoft have placed that command in the regular right-mouse menu?) Select this new command, and up pops the Open With dialog box. Select the application you'd like to use to open the file and click OK. (This feature may already exist depending on the version of operating system that you are using)
Myra rates the "Tip of the Month" as Beginner.
Return to Top of Page
February/08
Using a little gem called Format Painter. This Paintbrush icon should appear by default on the standard toolbar. To add it to the toolbar, go to Tools | Commands, navigate to Format, and drag the Paintbrush icon to a toolbar. When you click on this icon, Format Painter copies the formatting of the area where the cursor is located. If you select a cell or a range of cells or text box and then click on the icon, Format Painter will copy the cell formatting. You can then "paint" the copied formatting into other parts of the document by simply highlighting the cell or textbox. By double-clicking on the Format Painter icon, you can apply the copied formatting repeatedly until you press Esc.
Myra rates the "Tip of the Month" as Introductory.
Return to Top of Page
March/08
Adding a stylish drop cap to your Microsoft Word 2003 documents
A drop cap, basically the first letter of the first word of a paragraph displayed in a large font, can add a touch of style or class to a document. Used sparingly, this feature can spice up a series of boring, plain paragraphs.
To add a drop cap to a Word 2003 document:
1. Position your cursor at the beginning of a paragraph where you would like to see a drop cap.
2. Choose "Format" - "Drop Cap".
3. A "Drop Cap" dialog box should appear. Select whether you would like a "Dropped" or "In margin" drop cap, or you can remove a previously existent cap.
4. Select the font you wish to use for the cap.
5. If desired, select a different Distance From Text to make the Drop Cap letter more or less removed from the paragraph.
6, Increase or decrease the Lines to Drop to increase or decrease the size of the Drop Cap letter.
7. Press "OK" to apply your desired changes.
Myra rates the "Tip of the Month" as Intermediate.
Return to Top of Page
April/08
Easy Table Creation
If you wish to display text in your Microsoft Word 2003 document in a table, you can go through and first create the table using the "Table -> Insert Table" menu, then selecting how tall and wide you want the table, then clicking on each individual table cell and entering data. However, there's a MUCH easier way.
Enter your table data in your Microsoft Word 2003 document in a comma-delimited format. What does this mean? Perhaps you want a table of student names next to their grades. Enter the data like so:
Sarah,95
Brian,86
Joe,93
Laura,89
John,80
Tiffany,82
Now, highlight the text and choose "Table -> Insert Table". Voila! A 2x6 table is automatically created for you. If you don't like how it looks, choose "Table -> Table Autoformat" to apply one of various designs, or go through the "Table" menu and manually edit the table's display properties.
Myra rates the "Tip of the Month" as Intermediate.
Return to Top of Page
May/08
Send One Email Inside Another
There may be situations when sending e-mail in Outlook 2003 where you need to attach copies of previous e-mail messages. Perhaps you need to write a report of a conversation between several colleagues, or you may need to provide a new employee information previously found in earlier e-mails. To do this:
1. Start composing an e-mail message.
2. Choose "Insert" - "Item".
3. The "Insert Item" dialog box will appear. Choose the radio button to insert the items - such as e-mail attachments, journal entries, or meeting requests - as attachments or just to insert the text contained in the items ("Text Only").
4. Browse through your folders and select the item(s) to insert.
5. Click "OK".
Myra rates the "Tip of the Month" as Advanced.
Return to Top of Page
June/08
Repeat Rows or Columns on Each Printed Page
Make large printed Excel 2003 spreadsheets easier to read by repeating row and/or column descriptions on each page.
1. Click "File" - "Page Setup".
2. When the "Page Setup" multi-tabbed dialog box appears, click the "Sheet" tab.
3. To repeat rows at the top of each page, click on the miniature spreadsheet button next to "Rows to repeat at top".
A floating toolbar, "Page Setup - Rows to repeat at top" will appear.
4. Select the row(s) that you want repeated and their numbers will display in the dialog box.
5. Click the button at the end of the toolbar once you have made your selection. The row(s) will then appear in the "Page Setup" dialog box.
6. Likewise, to repeat columns, click on the miniature spreadsheet button next to "Columns to repeat at left". The instructions for selecting columns are similar.
7. When you are done, click "OK" to close the dialog box.
Note that you can choose to repeat just rows, just columns, or both. Myra rates the "Tip of the Month" as Introductory.
Return to Top of Page
July/08
Learn Word 2003 shortcut keys for virtually any operation.
You may know about keyboard shortcut keys in Word 2003, the special keystrokes that let you perform
operations without having to click on toolbar buttons or menu items. For example:
Ctrl-A Select All
Ctrl-S Save the current document
Ctrl-C Copy current selection
Ctrl-V Paste your selection
Ctrl-X Cut current selection.
These will not only work in Microsoft Office but will work in many other programs as well.
Myra rates the "Tip of the Month" as Introductory
Return to Top of Page
August/08
How should cells containing logical or mathematical errors be printed?
Microsoft Excel 2003 spreadsheets containing functions may show errors, such as:
- Columns don’t appear wide enough to hold cell values
- Formulas look for cells containing only numbers, if text is used in those cells formulas will not function.
- A division by zero error may occur
Depending on your needs, cells containing errors may print as shown on the spreadsheet, you can blank out error values, or you can convert all cell errors to "#N/A" or a couple of dashes.
1. Click "File" - "Page Setup".
2. When the "Page Setup" multi-tabbed dialog box appears, click the "Sheet" tab.
3. Underneath "Print" click the "Cell errors as" pull-down. Your choices:
* displayed - print cells with errors as they appear
* <blank> - print a blank cell
* -- - print two dashes
* #N/A - prints "#N/A"
5. Click "OK" to close the dialog box.
Myra rates the "Tip of the Month" as Intermediate
Return to Top of Page
September/08
Center Small Spreadsheets on Printouts
If you need to print small Microsoft Excel 2003 spreadsheets - those containing less than a page of data - instead of having the cells start at the top-left of the page you may wish to center the printed spreadsheet. Some may find the information easier to read if it is centered on a page, and others may just like the looks of the centered information.
1. Click "File" - "Page Setup".
2. When the "Page Setup" multi-tabbed dialog box appears, click the "Margins" tab.
3. Underneath "Center on page" check the "Horizontally" and "Vertically" buttons.
4. Click "OK" to close the dialog box.
Myra rates the "Tip of the Month" as Introductory
Return to Top of Page
October/08
Configure How Cells Containing Errors are Printed
In a Microsoft Excel 2003 spreadsheet, how should cells containing logical or mathematical errors be printed?
Microsoft Excel 2003 spreadsheets containing functions may show errors, such as:
* Columns may not appear wide enough to hold cell values
* Formulas may look for cells containing only numbers, so if text is instead placed in those cells the formulas will not function.
* A division by zero error may occur
Depending on your needs, cells containing errors may print as shown on the spreadsheet, you can blank out error values, or you can convert all cell errors to "#N/A" or a couple of dashes.
1. Click "File" - "Page Setup".
2. When the "Page Setup" multi-tabbed dialog box appears, click the "Sheet" tab.
3. Underneath "Print" click the "Cell errors as" pull-down. Your choices:
* displayed - print cells with errors as they appear
* <blank> - print a blank cell
* -- - print two dashes
* #N/A - prints "#N/A"
4. Click "OK" to close the dialog box.
Myra rates the "Tip of the Month" as Intermediate
Return to Top of Page
|
