Archive for April, 2009
The Sort dialog box allows you to select different criteria for sorting a list. Using the dialog box allows you to sort by multiple columns and select from several sort methods.
1.) Click a cell in the list.
2.) Click the Data tab, in the Sort & Filter gallery, click the Sort button.
3.) In the Sort dialog box, select the appropriate Column, Sort on and Order options.
4.) Click the Add Level button to add additional criteria, if neccessary.
5.) In the Then by row, select the appropriate options.
6.) Click the OK button.
This Tip of the Week was brought to you by the learning professionals at ExecuTrain Houston. To learn more, sign up for one of our Microsoft Excel 2007 public classes or ask about our Private Consults or Client-Site learning events.
To get the complete Quick Refrence Card for Excel 2007 contact an adivisor for pricing and delivery.
Posted in Monthly Tip | Comments Off
Mapping Texas Communities Workshop:
An Introduction to GIS and Community Analysis
Audience: Beginners, anyone interested in mapping their community
Participants will learn to use ArcGIS 9.3 to do the following:
Creating thematic maps
Participants will learn to create thematic maps of their own data, and display spatial trends in information.
Address mapping (geocoding)
Participants will learn to map addresses of their clients, their projects or incidents.
Download and map Census & American Community Survey data
Participants will learn to extract and map current Census data such as poverty, race, language, population,
transportation, education and workforce characteristics.
Materials
- Comprehensive workbook (75 pages), which includes the presentation, exercises and reference worksheets,
- ArcGIS (ArcView 9.3) software 60-day trial CD set
–
Workshop Agenda
Lesson 1
Learn the basic functions of ArcGIS
Setting up ArcMap
Adding data and geography layers
Working with Layouts
Lesson 2
Introduction to American Factfinder
Downloading Census and American Community Survey data to map
Downloading free geography files including tracts, zip codes, blocks and several others
Preparing Census tract data in Excel to import into ArcGIS
Lesson 3
Joining data and geography files
Creating thematic (color shaded) maps to display data
Working with legends and interval breaks
Lesson 4
How to do common spatial queries
Lesson 5
Where to download free business addresses
Geocoding (address mapping)
Lesson 6
Elements of good maps including colors, fonts and map must haves
Critique of several maps
–
New Urban Research, Inc.
2301 NW Thurman Suite S
Portland, OR 97210
877.241.6576 | www.urban-research.info
Houston: May 21st, 2009
ExecuTrain of Houston
4801 Woodway Drive, Suite 100 West
Houston, TX, 77056
713.402.1900
*Note: This workshop is customized for each city in which it is taught.
More Info/Registration: www.urban-research.info
Posted in Company Blog | Comments Off
Creating a New Contact
1.) In the Navigation pane, click the Contact button.
2.) In Contact window, click the New button
3.) In the Untitled-Contact dialog box, complete the appropriate contact information.
4.) Click the Save and Close button.
Assigning a Contact to a Category
1.) Open a contact form.
2.) On the Contact tab, in the Options gallery, click the Categories button. The Categories dialog box displays.
3.) In the drop-down list, click the appropriate option.
4.) Click the Save and Close button.
Searching for a Contact
1.) On the Standard toolbar, in the Search box, enter the contact name.
2.) Press the Enter key, in the Choose Contact dialog box. click the appropriate name, and then click the OK button.
Sending a Message to a Contact
1.) In the Contact window, right-click the appropriate contact entry.
2.) On the shortcut menu, point to the Create option, and then click the New Message to Contact option.
3.) In the Untitled-Message dialog box, complete the message, and then click the Send button.
This Tip of the Week was brought to you by the learning professionals at ExecuTrain Houston. To learn more, sign up for one of our Microsoft Outlook 2007 public classes or ask about our Private Consults or Client-Site learning events.
To get the complete Quick Refrence Card for Outlook contact an adivisor for pricing and delivery.
Posted in Monthly Tip | Comments Off
Tables enable you to organize and format groups of related information. You can also perform calculations in a table, just as you can with a spreadsheet.
1.) Click the Insert tab, in the Tables gallery, click the Table button.
2.) In the drop-down grid, click and drag to select the number of columns and rows to be included.
3.) Release the mouse button.
Entering Information in a Table
1.) Click the desired cell and type the information.
2.) Press the Tab key to move to the next cell and continue entering information.
NOTE: Press the Shift+Tab key to move back one cell.
This Tip of the Week was brought to you by the learning professionals at ExecuTrain Houston. To learn more, sign up for one of our Microsoft Office Word 2003 or 2007 public classes or ask about our Private Consults or Client-Site learning events.
To get the complete Quick Refrence Card for Outlook contact an adivisor for pricing and delivery.
Posted in Monthly Tip | Comments Off
SharePoint® allows users to create new documents directly from a document library using the document type associated with the library.
1.) In the Quick Launch bar, click the appropriate library link.
2.) On the library page, on the toolbar, click the New button.
3.) In the Warning dialog box, click the OK button.
4.) Enter the necessary information for the document.
5.) Click the Office Button, and then click the Save button.
6.) In the Save As dialog box, in the Name text box, key the document name.
7.) Click the Save button.
8.) In the document window, click the Close button.
This Tip of the Week was brought to you by the learning professionals at ExecuTrain Houston. To learn more, sign up for one of our Microsoft Office SharePoint 2007 public classes or ask about our Private Consults or Client-Site learning events.
To get the complete Quick Reference Card for Microsoft Office 2007, contact an adivisor for pricing and delivery.
Posted in Monthly Tip | Comments Off
Tim Shell, President and CEO of ExecuTrain Houston and Solo Learning talks with Elliott Massie about changes and new strategies in the world of learning.
[audio:ls08.mp3]
Posted in Company Blog | Comments Off
Microsoft, Windows, Access, Aero, Excel, Outlook, PowerPoint, and Visio are registered trademarks or trademarks of Microsoft Corporation in the United States and/or other countries.
