More on Single User, Multi User & Network Licences
More on Online Training
Limited Time Offer:
SAVE 30%
PACKAGE INCLUDES
MS Access 2010 Set of 3 Training DVDs
MS Excel 2010 Set of 3 Training DVDs
MS Outlook 2010 Set of 3 Training DVDs
MS PowerPoint 2010 Set of 2 Training DVDs
MS Word 2010 Set of 3 Training DVDs
• 14 Training DVDs (or 12 Month Online Subscription) featuring Beginner to Advanced Training for Word, Excel, Access, PowerPoint and Outlook with live instructor-led classroom sessions with full audio, video and demonstration components
• Hands-on Lab Simulations & Demonstrations with detailed instructions
• Testing Modules to insure that you fully understand the subject matter.
• Printable Workbooks
• Certificates of Completion for Each Course
Click on the Links below for complete course outlines or to purchase individual courses.
MS Access 2010 Training
This comprehensive Microsoft Access 2010 Training Course course covers all of the functions and features of Access 2010 for students of any skill level. The course begins with basic concepts and gradually progresses to more advanced topics. 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.
Students will also learn how to normalize data, manage table relationships, and enforce referential integrity; work with Lookup fields and subdatasheets; create join queries, calculated fields, and summary values; add objects to forms and create advanced form types; print reports and labels; create and modify charts; and use PivotTables and PivotCharts.
Finally, students will learn how to query with SQL; create crosstab, parameter, and action queries; create macros; import, export, and link database objects; interact with XML documents; create hyperlink fields; optimize, split, and back up databases; password-protect and encrypt databases; and set Access options and properties.
MS Excel 2010 Training
This is a comprehensive course covering all of the functions and features of Excel 2010 for students of any skill level. The course begins with basic concepts and gradually progresses to more advanced topics. 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. Students will also create and modify charts, and learn how to manage large workbooks.
Next, students 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 work with advanced formulas, as well as lookup functions such as VLOOKUP, MATCH, and INDEX. In addition, students will learn about data validation and database functions such as DSUM. They will learn how to work with PivotTables and PivotCharts, how to import and export data, and how to query external databases. Students will also learn about the analytical features of Excel (such as Goal Seek and Solver), running and recording macros, SmartArt graphics, and conditional formatting with graphics.
MS Outlook 2010 Training
This comprehensive Outlook 2010 Training Course covers all of the functions and features of Outlook 2010 for students of any skill level. The course begins with basic concepts and gradually progresses to more advanced topics. After an introduction to Outlook's window components and the Help system, students will read and send e-mail messages using several techniques. Then they will learn how to manage e-mail messages and attachments, configure message options, and use search folders.
Students will also learn to manage contacts and use the People Pane, work with tasks, and create appointments. Students will learn how to customize Outlook and work with address books. They will search and filter mail folders, and apply and customize categories. Students will also work with personal, public, and offline folders. They will learn advanced techniques for managing and maintaining their mailboxes. Students will create and work with notes and Journal entries, share Outlook calendars and contacts, create customized e-mail templates, and use mail merge to send personalized messages to groups of contacts.
MS PowerPoint 2010 Training
This comprehensive Microsoft PowerPoint 2010 Training Course covers all of the functions and features of PowerPoint 2010 for students of any skill level. The course begins with basic concepts and gradually progresses to more advanced topics. 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.
Finally, students will customize PowerPoint by modifying the Ribbon and changing application settings. They will also apply themes and templates, and they will work with SmartArt graphics and tables. Students will add multimedia content and interactive elements to slides, and they will learn about presentation distribution options including PDF, HTML, and online broadcasts. Students will also integrate PowerPoint with Word and Excel.
MS Word 2010 Training
This is a comprehensive course covering all of the functions and features of Word 2010 for students of any skill level. The course begins with basic concepts and gradually progresses to more advanced topics. 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.
Additionally, students will work with styles, sections, and columns and will use the Navigation pane to work with outlines. They will format tables, print labels and envelopes, and work with graphics. They will also use document templates, manage document revisions, and work with Web features.
SPECIAL FEATURES OF OUR TRAINING COURSES
 |
Comprehensive Menu Structure
Move through hours of in-depth content - quickly and easily with the time saving Main Menu and Sub-Menu structure. Search for a specific topic or go through the course step by step. The choice is yours.
|
 |
Player Controls
Move forward or back, repeat entire topics or just a section. A progress bar illuminates as you advance through the video tutorials and exercises. Play, pause rewind, fast forward or stop at any time
|
 |
Continue Where You Left Off
All courses are resumed to where you left off last session allowing you to learn when it is convenient for you without the hassle of remembering where you were.
|
 |
Full Motion Video and Audio
All courses feature full-motion videos of instructors teaching the information as if they are speaking directly to you. Our unique delivery simulates a one-on-one classroom environment creating a more personal lesson and learning experience.
|
 |
Review Exercises
Each section has a review quiz to aid in the learning process by validating the comprehension of the material covered before moving on to a new section.
|
 |
Live Demonstrations
Demonstrations are a way for the instructor to show and tell the user how to perform a task by actually doing it on screen in front of them. In this format it gives the user the power to see things done by a professional in the intended environment as many times as they would like.
|
 |
Interactive Labs
This course features cutting-edge, interactive labs, which provide a hands-on learning experience. This environment allows you to interact with the software without the need for purchasing it or having it installed on your computer.
|
 |
PowerPoint Presentations
Utilizing PowerPoint presentations enhances the delivery by displaying a variety of visual information to the user. This type of representation allows the user to better interpret the material through charts, definitions, graphs, and more...
|
 |
Multi-User Licencing
All of our courses can be purchased with a standard Single User Licence, Multi User Library Licence or a Network Licence. Please contact us for more information and prices.
|
 |
Certificate of Completion
Our Training Courses are recognized worldwide for their technology-based IT training curriculums. Upon successful completion of our program, you will be receiving a CareerVision Distance Education Certificate of Completion.
|