| February 2012 |
| |
| Microsoft Excel 2010 Level II |
| Date/Time: | 02/06/2012 9:00AM - 12:30PM
02/07/2012 9:00AM - 12:30PM
| Purchase Order Signups Click Here
|
| Parts: | 2 |
| Length: | 7 hours |
| Cost: | $149.00 |
| Students in this 7-hour course will learn how to use multiple worksheets and workbooks efficiently, and they will start working with more advanced formatting options including styles, themes, and backgrounds. They will also learn how to create outlines and subtotals, how to create and apply cell names, and how to work with tables. Students will save workbooks as Web pages, insert and edit hyperlinks, and learn to share workbooks by email. This course also covers advanced charting techniques, use of trendlines and sparklines, worksheet auditing and protection, file sharing and merging, and workbook templates. Finally, students will learn to work with PivotTables and PivotCharts. |
IMPORTANT: If you are unable to keep the class you have reserved, please call with more than 24 hours notice to avoid being charged. |
| Focused Seminar: Edit photos with PowerPoint |
| Date/Time: | 02/06/2012 2:00PM - 4:00PM
| Purchase Order Signups Click Here
|
| Parts: | 1 |
| Length: | 2 hours |
| Cost: | $49.95 |
| This 2 hour seminar includes inserting a photo into PowerPoint, editing the photo, saving the photo to be used outside of PowerPoint, and creating a photo album/slide show in PowerPoint. Perfect for users who don’t wish to buy an expensive graphics program, save some money if you already have PowerPoint. |
IMPORTANT: If you are unable to keep the class you have reserved, please call with more than 24 hours notice to avoid being charged. |
| Focused Seminar: Google Docs |
| Date/Time: | 02/07/2012 2:00PM - 4:30PM
| Purchase Order Signups Click Here
|
| Parts: | 1 |
| Length: | 2 to 3 hours |
| Cost: | $59.95 |
| This 3 hour focused seminar includes information on navigating Google Docs, creating, editing, saving, and sharing Google Docs. The course also contains a brief section on using Google Docs in conjunction with Microsoft Office. |
IMPORTANT: If you are unable to keep the class you have reserved, please call with more than 24 hours notice to avoid being charged. |
| Microsoft Project 2010 Level I |
| Date/Time: | 02/08/2012 9:00AM - 12:00PM
02/09/2012 9:00AM - 12:00PM
| Purchase Order Signups Click Here
|
| Parts: | 2 |
| Length: | 6 hours |
| Cost: | $149.00 |
| This 6-hour course teaches the basic commands and features of Microsoft Project 2010. Students will learn how to create and modify task lists, establish a project schedule, create calendars, assign resources to tasks, track costs, and work with different views and tables. Students will also apply filters and groups, and sort task and resource data. Finally, they will learn how to resolve resource conflicts. |
IMPORTANT: If you are unable to keep the class you have reserved, please call with more than 24 hours notice to avoid being charged. |
| Focused Seminar: Dynamic Data - Presenting Pivot Tables |
| Date/Time: | 02/08/2012 1:00PM - 4:00PM
| Purchase Order Signups Click Here
|
| Parts: | 1 |
| Length: | 3 to 4 hours |
| Cost: | $69.95 |
| This 3 to 4 hour focused course includes techniques on creating pivot tables and pivot charts, creating custom calculations, formatting, restructuring, and customizing pivot tables, and using slicers. |
IMPORTANT: If you are unable to keep the class you have reserved, please call with more than 24 hours notice to avoid being charged. |
| Focused Seminar: Mail Merging-Outlook & Word |
| Date/Time: | 02/09/2012 1:00PM - 4:00PM
| Purchase Order Signups Click Here
|
| Parts: | 1 |
| Length: | 3 hours |
| Cost: | $59.95 |
| This 3 hour seminar will demonstrate how to use the mail merge feature in Word and in Outlook 2010. Printing labels will also be discussed. |
IMPORTANT: If you are unable to keep the class you have reserved, please call with more than 24 hours notice to avoid being charged. |
| Focused Seminar: Automating Tasks (Using Macros) |
| Date/Time: | 02/10/2012 9:00AM - 12:00PM
| Purchase Order Signups Click Here
|
| Parts: | 1 |
| Length: | 3 to 4 hours |
| Cost: | $69.95 |
| This 3 hour focused course will introduce the learner to running, creating, and editing macros in Excel, Word 2010. (Macros are a set of commands that can be triggered by clicking a button or using a keyboard shortcut instead of multiple clicks for repetitive tasks). |
IMPORTANT: If you are unable to keep the class you have reserved, please call with more than 24 hours notice to avoid being charged. |
| Focused Seminar: Excel Power Functions |
| Date/Time: | 02/10/2012 1:00PM - 4:00PM
| Purchase Order Signups Click Here
|
| Parts: | 1 |
| Length: | 4 hours |
| Cost: | $69.95 |
This 4 hour hands-on seminar includes creation and use of logical, statistical, financial, text, and date functions.
Learners will also create data tables and array functions.
|
IMPORTANT: If you are unable to keep the class you have reserved, please call with more than 24 hours notice to avoid being charged. |
| Microsoft Excel 2007 Level I |
| Date/Time: | 02/13/2012 9:00AM - 4:00PM
| Purchase Order Signups Click Here
|
| Parts: | 1 |
| Length: | 6 hours |
| Cost: | $149.00 |
| This 6-hour teaches the basic functions and features of Excel 2007. After an introduction to spreadsheet terminology and Excel's window components, students will learn how to use the Help system and navigate worksheets and workbooks. Then they will enter and edit text, values, formulas, and pictures, and they will save workbooks in various formats. Students will also move and copy data, learn about absolute and relative references, and work with ranges, rows, and columns. This course also covers simple functions, basic formatting techniques, and printing. Finally, students will create and modify charts, and learn how to manage large workbooks. |
IMPORTANT: If you are unable to keep the class you have reserved, please call with more than 24 hours notice to avoid being charged. |
| Microsoft Powerpoint 2010 Level I |
| Date/Time: | 02/14/2012 9:00AM - 12:00PM
02/15/2012 9:00AM - 12:00PM
| Purchase Order Signups Click Here
|
| Parts: | 2 |
| Length: | 6 hours |
| Cost: | $149.00 |
| This 6-hour course covers the basic functions and features of PowerPoint 2010. After an introduction to PowerPoint's window components and Help system, students will learn to create, save, and rearrange presentations. Then they will format text, use drawing objects, work with graphics, and insert tables and charts. They will then learn to use templates and themes, slide masters, and transition effects. Finally, students will learn to proof, run, and print presentations. |
IMPORTANT: If you are unable to keep the class you have reserved, please call with more than 24 hours notice to avoid being charged. |
| QuickBooks Pro 2011 for Windows |
| Date/Time: | 02/14/2012 1:00PM - 4:30PM
02/15/2012 1:00PM - 4:30PM
| Purchase Order Signups Click Here
|
| Parts: | 2 |
| Length: | 7 hours |
| Cost: | $179 |
| This 7- hour course covers the basics of Quickbooks Pro 2011. Students will explore the QuickBooks interface and access the centers available in QuickBooks 2011, set up a company and update the chart of accounts, build and manage lists, create product and service invoices, prepare billing statements, process payments, work with bank accounts, pay bills, prepare payroll, track and pay sales taxes, and create reports. If time allows, learners will also customize forms, work with other QuickBooks accounts, use memorized transactions, and create estimates. |
IMPORTANT: If you are unable to keep the class you have reserved, please call with more than 24 hours notice to avoid being charged. |
| Microsoft Access 2010 Level I |
| Date/Time: | 02/16/2012 9:00AM - 12:00PM
02/17/2012 9:00AM - 12:00PM
| Purchase Order Signups Click Here
|
| Parts: | 2 |
| Length: | 6 hours |
| Cost: | $149.00 |
| This 6-hour course covers the basic functions and features of Access 2010. After an introduction to database concepts and the Access environment and Help systems, students will learn how to design and create databases. Then they will work with tables, fields, and records; sort and filter data; and set field properties and data entry rules. Students will then learn to create queries, forms, and reports. |
IMPORTANT: If you are unable to keep the class you have reserved, please call with more than 24 hours notice to avoid being charged. |
| Microsoft Windows 7 - Basic |
| Date/Time: | 02/16/2012 1:00PM - 4:00PM
| Purchase Order Signups Click Here
|
| Parts: | 1 |
| Length: | 3 hours |
| Cost: | $89.00 |
| Students in this 3* hour course will learn how to use the Start menu and taskbar; move and resize windows; create and manage files, folders, and libraries; edit file metadata; and search for content on their computers; create shortcuts; use gadgets; change system settings; and use Internet Explorer to add sites to their Favorites. (*Times may vary depending on the previous experience of the learners) |
IMPORTANT: If you are unable to keep the class you have reserved, please call with more than 24 hours notice to avoid being charged. |
| Focused Seminar: Budgeting in Excel |
| Date/Time: | 02/17/2012 1:00PM - 3:00PM
| Purchase Order Signups Click Here
|
| Parts: | 1 |
| Length: | 2 hours |
| Cost: | $49.95 |
| This 2 hour focused seminar includes creating a budget in Excel 2010, inserting formulas and calculations, including charts, then saving the workbook as a template. |
IMPORTANT: If you are unable to keep the class you have reserved, please call with more than 24 hours notice to avoid being charged. |
| Microsoft Excel 2010 Level I |
| Date/Time: | 02/20/2012 9:00AM - 12:00PM
02/21/2012 9:00AM - 12:00PM
| Purchase Order Signups Click Here
|
| Parts: | 2 |
| Length: | 6 hours |
| Cost: | $149.00 |
| This 6-hour course teaches the basic functions and features of Excel 2010. After an introduction to spreadsheet terminology and Excel's window components, students will learn how to use the Help system and navigate worksheets and workbooks. Then they will enter and edit text, values, formulas, and pictures, and they will save workbooks in various formats. Students will also move and copy data, learn about absolute and relative references, and work with ranges, rows, and columns. This course also covers simple functions, basic formatting techniques, and printing. Finally, students will create and modify charts, and learn how to manage large workbooks. |
IMPORTANT: If you are unable to keep the class you have reserved, please call with more than 24 hours notice to avoid being charged. |
| Microsoft Word 2010 Level I |
| Date/Time: | 02/20/2012 1:00PM - 4:00PM
02/21/2012 1:00PM - 4:00PM
| Purchase Order Signups Click Here
|
| Parts: | 2 |
| Length: | 6 hours |
| Cost: | $149.00 |
| This 6-hour course covers the basic functions and features of Word 2010. After an introduction to Word's window components, students will learn how to use the Help system and navigate documents. Then they will enter and edit text, create and save documents, and learn how to enhance the appearance of a document by using various formatting options. They will also create tables, insert headers and footers, proof and print documents, and insert graphics. |
IMPORTANT: If you are unable to keep the class you have reserved, please call with more than 24 hours notice to avoid being charged. |
| Microsoft SharePoint Designer 2007 Level I |
| Date/Time: | 02/22/2012 9:00AM - 12:00PM
02/23/2012 9:00AM - 12:00PM
| Purchase Order Signups Click Here
|
| Parts: | 2 |
| Length: | 6 hours |
| Cost: | $149.00 |
| This 6-hour course teaches the core features and functions of SharePoint Designer 2007. Students will learn how to create and apply templates, control layout and spacing, create and apply style sheets, and apply IDs and classes. They will also insert, modify, and arrange images, create links and navigation bars, and insert and format tables. Finally, they will learn how to prepare a Web site for publishing. |
IMPORTANT: If you are unable to keep the class you have reserved, please call with more than 24 hours notice to avoid being charged. |
| HTML 5 |
| Date/Time: | 02/24/2012 9:00AM - 4:00PM
| Purchase Order Signups Click Here
|
| Parts: | 1 |
| Length: | 6 hours |
| Cost: | $149 |
| Learners will get the most from this class if they are new to Web development and want to learn how to use HTML and CSS to create web pages. The 6-hour course will help students create an HTML document from scratch, identify HTML syntax, use new HTML 5 elements, write basic CSS rules to format HTML content, create and modify tables, links, and images, and apply background images from a style sheet. |
IMPORTANT: If you are unable to keep the class you have reserved, please call with more than 24 hours notice to avoid being charged. |
| Focused Seminar: Taming Your Email |
| Date/Time: | 02/27/2012 9:00AM - 12:00PM
| Purchase Order Signups Click Here
|
| Parts: | 1 |
| Length: | 3 to 4 hours |
| Cost: | $69.95 |
| This 3 to 4 hour focused course includes creating folders in email, creating and using rules and alerts, categorizing, searching, and flagging emails, reducing the amount of unwanted mail using your Junk filters, and tips on using email more efficiently. |
IMPORTANT: If you are unable to keep the class you have reserved, please call with more than 24 hours notice to avoid being charged. |
| Microsoft Windows 7 - Basic |
| Date/Time: | 02/27/2012 1:00PM - 4:00PM
| Purchase Order Signups Click Here
|
| Parts: | 1 |
| Length: | 3 hours |
| Cost: | $89.00 |
| Students in this 3* hour course will learn how to use the Start menu and taskbar; move and resize windows; create and manage files, folders, and libraries; edit file metadata; and search for content on their computers; create shortcuts; use gadgets; change system settings; and use Internet Explorer to add sites to their Favorites. (*Times may vary depending on the previous experience of the learners) |
IMPORTANT: If you are unable to keep the class you have reserved, please call with more than 24 hours notice to avoid being charged. |
| Microsoft Excel 2010 Level II |
| Date/Time: | 02/28/2012 9:00AM - 5:00PM
| Purchase Order Signups Click Here
|
| Parts: | 1 |
| Length: | 7 hours |
| Cost: | $149.00 |
| Students in this 7-hour course will learn how to use multiple worksheets and workbooks efficiently, and they will start working with more advanced formatting options including styles, themes, and backgrounds. They will also learn how to create outlines and subtotals, how to create and apply cell names, and how to work with tables. Students will save workbooks as Web pages, insert and edit hyperlinks, and learn to share workbooks by email. This course also covers advanced charting techniques, use of trendlines and sparklines, worksheet auditing and protection, file sharing and merging, and workbook templates. Finally, students will learn to work with PivotTables and PivotCharts. |
IMPORTANT: If you are unable to keep the class you have reserved, please call with more than 24 hours notice to avoid being charged. |
| Focused Seminar: Excel Formulas and Functions Basics |
| Date/Time: | 02/29/2012 9:00AM - 12:00PM
| Purchase Order Signups Click Here
|
| Parts: | 1 |
| Length: | 3.5 hours |
| Cost: | $69.95 |
| This 3.5 hour hand-on seminar includes copy, cut, and paste techniques (as a refresher), creating and using basic formulas, creating and using functions. Learners will use Excel’s insert function wizard as well as the auto sum feature. Auto-calculate will also be discussed. |
IMPORTANT: If you are unable to keep the class you have reserved, please call with more than 24 hours notice to avoid being charged. |
| Focused Seminar: Taming Your Email |
| Date/Time: | 02/29/2012 1:00PM - 4:00PM
| Purchase Order Signups Click Here
|
| Parts: | 1 |
| Length: | 3 to 4 hours |
| Cost: | $69.95 |
| This 3 to 4 hour focused course includes creating folders in email, creating and using rules and alerts, categorizing, searching, and flagging emails, reducing the amount of unwanted mail using your Junk filters, and tips on using email more efficiently. |
IMPORTANT: If you are unable to keep the class you have reserved, please call with more than 24 hours notice to avoid being charged. |
