Excel Magic 2: Tame Those Columns!

MICROSOFT EXCEL 2003, 2007 and 2010:
Column Formatting Top 5

1. Insert Or Delete a Column:
Select column title next to location.
Right click - Select Insert

2. Adjust Column Width:
Manual: Click and drag column title border.
AutoFit: Double click column title border.

3. Turn Column Titles On or Off
2007 and 2010 only: View, Headings.
2003 - Tools, Options, Window Options -
uncheck Row and Column Headings.

4. Hide or Unhide Columns:
Hide: Select Column. Right Click - Select Hide.
Unhide: Select Columns Next To Hidden Column.
Right click - select Unhide.

5. Group Columns to Hide/Unhide Data:
2003: Select columns - Data, Group and Outline, Group
2007-2010: Select columns - Data, Outline, Group

Note: Click the outline, plus or minus symbols to toggle the columns.


The Microsoft certified professionals at Brandpointe can help you conquer FOE (Fear of Excel).

Quick guides, AdobeConnect sessions, Flash videos or Skype sessions with an instructor, we can provide successful tools.

Register to become a member of our online community. We provide a seamless learning experience anytime you need it, with our Topyx learning site. www.brandpointeonline.com

Excel Magic: Tame Those Cells!

Microsoft Excel 2003 and 2007:
Cell Formatting Top 10

Entering Data in Excel:
Cells have a limit of 32,767 characters. Although all data will show on the Formula Bar, only 1,024 characters will display or print.

1. Insert a blank line in a cell.
Alt and Enter Keys

2. Insert a tab in a cell.
Ctrl and Tab Keys

3. Wrap or Autofit text.
Wrap - Ctrl 1, Alignment Tab, Text Control
AutoFit - Double click row or column border.

4. Copy data in the cell above.
Ctrl "

5. Set vertical or horizontal alignment.
Ctrl 1, Alignment Tab, Text Alignment

6. Remove red or green triangles in a cell.
Red Triangle (Comments) - Right click, Delete Comment
Green Triangle (Error Checking) - Right click, Ignore Error

7. Add or Remove a border.
Ctrl 1 - Border Tab

8. Lock a cell.
Select Cell - Ctrl 1, Protection, Locked
2007 - Right click Sheet tab, select Protect Sheet
2003 - Tools, Protection, Protect Sheet

9. Display only certain cells.
(Select cells)
2007 - View, Workbook Views, Custom View
2003 - View, Custom View

10. AutoFill multiple cells (for months, days or number series)
(Select cells)
Click and drag the small black box at the end of the selection.



Contact the Microsoft certified professionals at Brandpointe for technical support, configuration options or training for Microsoft Excel. Test drive our new web-based learning community. Learn Microsoft Excel at your own pace from any computer. www.brandpointeonline.com

Fabulous Font Menu in Word 2010

New Word Version Takes Font Capability Higher:
Along with other software, Brandpointe uses Microsoft Word to create a variety of training and marketing materials. We're excited about the enhancements and font flexibility added to Word 2010.

1. Added Text Effects: Glow/Soft Edges, Gradient Fill, Reflection, More 3-D and Outline options.

2. OpenType Settings: Provides a crossover between TrueType and Type 1 - for ligatures and really impressive font formatting.

3. Bonus Option: Create great looking documents and save them as PDF files. Word 2010 includes the format in Save As options.




Contact the Word certified professionals at Brandpointe for technical support, configuration options or training for Microsoft Word. Test drive our new web-based learning site. Learn Microsoft Word at your own pace from any computer. www.brandpointeonline.com

Keep a Permanent List of Recent Documents

Word 2007

1. Click the Office Button.
2. In the list of recent documents, click the pin icon on the right side of the file name to save or unsave it.

Modify the Number of Recent Documents Displayed:
Office Button, Word Options, Advanced, Display - the maximum is 50 documents.

Remove a File From the List:
To clear the entire list, set the display option to "0".
To clear a single entry, edit the registry -
HK_Current_User - Software - Microsoft - Office - 12 - Word - FileMRU

Word 2003

1. Add the Work Menu to the Menu Bar.
2. Select Tools, Customize from the top menu.
3. Click the Commands Tab.
4. In the left column, scroll down to the option - Build-in Menus.
5. In the right column, scroll down and locate the Work option.
6. Click and drag it to the Menu Bar.
7. When you close Word, click "Yes" to save the Normal template.

Add a Document:
Open the document.
Click the Work Menu and select - Add to Work Menu.

Remove a Document:
Click the Alt Ctrl - (minus) buttons.
The cursor displays a large hyphen symbol.
Click the document in the Work Menu to remove it.

*Word 2003 holds a maximum of nine (9) documents on the Work Menu.


Contact the Word certified professionals at Brandpointe for technical support, configuration options or training for Microsoft Word. Test drive our new web-based learning site. Learn Microsoft Word at your own pace from any computer. www.brandpointeonline.com

Microsoft Outlook Productivity
Use Ctrl K for Recipient Names

Type Ctrl K on the To: line, and Outlook autocompletes names from the list of recently sent recipients. If there are duplicates or name conflicts with your Contacts, a dialog box displays for you to select the correct name.

How are Names Added To The List?
Each time you send a new message, Outlook adds the recipients to a temporary file with a nk2 file extension. *If you send to an incorrect address, it is also added to the list.

Delete Names From the AutoComplete Drop Down List
Type the first few characters of a recipient name on the To: line. When the name displays, use the up or down arrows on the keyboard to select it. When the name is highlighted, press the Delete key.

How Do I Turn AutoComplete Off?
Tools, Options, Preferences
E-mail Options Button
Advanced E-mail Options
Uncheck - Suggest Names When Completing To:, cc: or bcc: fields.

Can I Edit The Temp File Directly?
There are add-ons that will do that, however, there is no option in Outlook. NirSoft has a freeware utility to edit the file.

Can I Delete The Entire File?
Rename the file instead of deleting it. This maintains the list if you ever need it again. Run a Windows search for the file. Type *.nk2 as the file to search for. Select the file and press the F2 key. Rename the .nk2 to .bak.

Brandpointe is your single source solution for learning programs and technical support. Register for December or January productivity boot camps for Microsoft and Adobe programs. www.brandpointeonline.com

Copy Pages Between Acrobat Files

Acrobat Workflow Solutions - Part 1
Pagination

Task: You need to copy pages between opened Acrobat files.

Here's how to do it:

1. In Acrobat, tile the open files vertically.

2. Top Menu: Windows - Tile Vertically

3. In the left pane, click the Pages tab for each file. Pages display as thumbnails.

4. To select a page, click its thumbnail. A border around the thumbnail indicates the selection.

5. Note: To select multiple pages, hold the Shift Key and click each individual thumbnail. To select all pages, press Ctrl A.

6. Click in a selected thumbnail, and drag to the target file. All selected pages will copy to the target file, but remain in their original location.

7. Use File, Save As to save the newly added pages.

8. To delete pages in the original file, go to the Pages tab for that file. Right click the page thumbnail and select - Delete Pages.

Contact Brandpointe for solutions, quick reference guides, courseware and technical support for Adobe Acrobat.

www.brandpointeonline.com

Save Multimedia Files From Web Pages

You like the flash file you've just viewed, and want to save a copy. There may be related security or design issues that prevent downloading, otherwise, these steps may help you save the file to your own computer.

*Internet Explorer
Open the page containing the multimedia you want to save.
Multimedia files are cached to a Temp Folder.

Access: In IE, select Tools, Internet Options, Settings, View Files.
Scroll through the file list to locate the file(s). Copy to a different folder, such as the Desktop or My Documents.

*Firefox
Open the page containing the multimedia you want to save.

Access: Right click in a blank area on the web page.
Select - View Page Info. Click the Media icon in the top box.
Scroll through the list in the Address Box.
Click the file and select - Save As.

*Safari (MAC or Windows)
This link details the steps: http://tinyurl.com/6efa5o

View November's course calendar, or get info about job performance training and services: www.brandpointeonline.com

How Do You Create and Manage Electronic Content?

Discover tools and efficient ways to create, organize and locate electronic data.

Brandpointe has the learning tools for paperless productivity.

In November, explore options for using Adobe Acrobat to maximize your information.

- Electronic Forms
- The Total Paperless Process
- Acrobat for Architects, Engineers and the Construction Industry

Ready for Distance Learning?

You've decided to implement e-learning, so what's the next step?

Brandpointe can take you there, and ensure you design the right system with relevant, effective content.

Request our e-learning toolkit and view sample course materials.

elearning@brandpointe.com

Microsoft Excel Productivity

Set Custom Views for easier navigation.
Saved views display the information plus the zoom default setting.

1. Select the view area.
2. Excel 2003: Select View, Custom View, Add from the top menu.
3. Excel 2007: In the top menu, select View, Custom View (in Workbook Views) and Add.

For easy access, add the Custom Views box to a toolbar in 2003, or to the Quick Access toolbar in 2007.

To fix Custom View errors, disable autofilters, worksheet protection and the caps lock key.

Contact the Brandpointe HD services team for help with Microsoft Excel setup, configuration and training - www.brandpointeonline.com.

Microsoft Access Productivity:

Load a Data Entry Form Automatically When Access Opens

Version 2007
1. Click the Office Button (left corner), Access Options (bottom right)
2. Click Database Category.
3. Under Applications Options, choose Display Form. Select Entry Form.

Version 2003
1. Select Tools, Startup from the top menu.
2. Click in the Display Form/Page box. Click Arrow and Select Form.