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.
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.
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.
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.
So much is in the news and so many of us have even been effected first hand by the challenged economic situation. We read and see company employees up in arms because they were just laid off and no one is hiring. We hear about companies cutting back on insurance, perks, and in some cases even doing mandatory payroll decreases. Overall, so many companies are looking to find way to “trim” excess spending.
Corporations that are feeling the burn have to find a way to retain their top talent, as well as offer new-comers an incentive that will keep everyone in the conga line.
Many feel that training and development are the first items to be cut from the budget. However, companies that are forward-thinking are not cutting spending on training but in fact offering their employees the opportunity to learn more. Speaking first hand with a training department supervisor it was said that they have raised their budget in 2009-2010 on training and learning initiatives. Whoa! Talk about value! Take your key personnel and make sure they have the skills to be successful at their job and perhaps jobs to come.
Companies see an increase in their ROI by keeping employees up to date with the latest on desktop application and soft-skill training needed in the work place. Just because our economy is fractured does not mean we have to sit on our hands and wait and see what is going to happen next. Take the time to evaluate your employees and offer them the training skill they need. Instead of that report taking two days to compile why not learn how to properly use the application and reduce a couple of days to a couple of hours so that employee can then be a resource elsewhere.
Make that time-to-technology quicker and employee retention stronger. Not only will you see the benefit of training, but seeing a smile on your employees face while knowing that they are fully confident in their task-at-hand is priceless.
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.
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.
Recently we asked certain team members to participate in a poll and answer the question “What is your favorite ice cream?” This was the first time we have asked for contributions from some of the team members to participate with an article. Thanks to everyone in the office for your participation with this.
Sometimes when we take something that we enjoy and apply that same theory to something that might be actually more important but less thought about, we begin to open up and accept the varying methods of that more important opportunity. Although I am sure some will argue that eating ice cream is just about the best opportunity on earth. Feel free to share your own story in a comment.
I will start with the response from our very own IT Administrator, Taff Morse. Taff is responsible for making sure our student and private networks are running smoothly and for making sure all of our classrooms are setup and ready for our clients come class day. Be it a proprietary software that needs to be installed or a server being set up in the room Taff is the one responsible for all these duties and more.
I would have to say that my favorite kind of ice cream is actually an ice cream cookie. The kind with two large chocolate chips cookies and a thick layer of vanilla ice cream in the middle. Now that may sound pretty normal. Many people do like them during the warm months of summer in my home town in Wisconsin. However, I myself like them the most on a nice cold winter day. The local convenience store manager would always comment on me buying them while on break from work. I think she kept them in stock just for me during the winter.
- Taff Morse, IT Administrator
Our second response is from Sarah Michael. Sarah has been with ExecuTrain Houston for over 6 years and is the “go to” gal for anything and everything within our team. Confirming dates for classroom rentals, creating public class schedules, making sure the clients stay is as pleasant and professional as possible, Sarah has it under control.
My favorite ice cream is chocolate chip cookie dough I like it because it has a variety of flavors and reminds me of spending time with my family back home. Each Sunday after church we would go out to eat and stop at Dairy Queen on our way home to get ice cream.
- Sarah Michael, Operations Manager
Our next response is from Kaylin Caulkins. Kaylin is the first voice you will hear when you call ExecuTrain Houston. When you book your classroom rental or attend a public Microsoft class at our facility Kaylin will be your liaison and help and assist you in anyway possible.
My favorite ice cream is a sundae loaded with sprinkles and chocolate syrup because in elementary school we had sundae parties for perfect attendance. I used to remember going home from school after each party that I went to cover in stains from the ice cream and toppings. The best memories that I have from that is my mother’s reactions to the relatively new clothing that would come home in ruins.
- Kaylin Caulkins, Operations Assistant
Our final response will be from Brandon Cook. Brandon is one of our Learning Advisors and is the newest team member. Brandon has been tasked with identifying new business opportunities for ExecuTrain Houston for Microsoft Office public classes as well as classroom rentals. If you haven’t already, you may be getting a call from this first-class salesmen. We have a lot of new opportunities we want to share with you while being your resource.
Favorite Ice Cream: Cheesecake
Why I Like It: Reminds of the real thing
I don’t eat ice cream very often, maybe four times a year. Those are the times that I go with my nieces. They usually get bubble gum or cotton candy. My best story about ice cream was when my niece who is 2 decided that she did not want her ice cream and wanted mine. She was just getting over a cold when she decided that she wanted me to share with her. As I began using her spoon for her, I was distracted by a conversation when my niece decided to use her hand to share by placing the ice cream on my face and then eventually over my clothes. Safe to say now I don’t let her sit in my lap anymore when we eat ice cream.
- Brandon Cook, Learning Advisor
The point to asking the team this fun question was to use it as a comparison as to how people like to learn. “What is your favorite way to learn?” could easily replace “what is your favorite ice cream?” as could any number of things.
I think just as diverse as these answers are above, how each of us learn can be just as spotted. Certain people insist that they learn best in a classroom environment by instructor-led training, while others insist that computer-based training is the best. Still others say that they have to have a big thick book to absorb the learning.
In days of yore, ice cream only came in a handful of flavors, just as learning did. Today I like to think of ExecuTrain Houston as the Marble Slab of learning. Tell us what you want to learn and how you want to learn it and we will mash it up and make it the yummiest tasting learning you have ever had! We still serve vanilla too.
I like it because it has a variety of flavors and reminds me of spending time with my family back home. Each Sunday after church we would go out to eat and stop at Dairy Queen on our way home to get ice cream.