Office 2010 Training Course
Learning at home
Summary
- Tutor is available to students
Overview
The Office 2010 training course series is packed with information covering the Office 2010 new features. This training series is ideal for professionals who are looking to improve their proficiency with Office or for any individuals who are looking to enhance their skill set with the MOS certifications offered by Microsoft. Create your competitive edge with the knowledge of Microsoft Office 2010. This training series provides three sessions each of Outlook 2010, PowerPoint 2010, and Word 2010, and five sessions each of Access 2010 and Excel 2010.
Description
Syllabus
Session 1
Section A: Introduction
Section B: Access 2010 Tour
Section C: Working with Tables and Forms
Section D: Working with Queries and Reports
Section E: Database Organization Techniques
Section F: Customizing Access
Section G: Understanding Relational Databases
Section H: Planning a Database
Session 2
Section A: Building a Database
Section B: Building Tables
Section C: Table Design Basics
Section D: Adjusting Table Design
Section E: Data Validation and Input Masks
Section F: Lookups
Section G: Table Relationships
Section H: Importing Data
Session 3
Section A: Building Forms Automatically
Section B: Building Forms Manually
Section C: Customizing and Personalizing Forms
Section D: Working with Form Layout
Section E: Working with Form Design
Section F: Adding Controls to Forms
Section G: Filtering Data with Forms
Section H: Building Navigation Forms
Session 4
Section A: Building a Query with a Wizard
Section B: Building a Query from Scratch
Section C: Basic Criteria
Section D: Comparison Criteria
Section E: Performing Calculations
Section F: Working with Calculated Totals
Section G: Advanced Select Queries
Section H: Action Queries
Session 5
Section A: Reports
Section B: Report Formatting
Excel 2010Session 1
Section A: Introduction
Section B: Navigating Excel
Section C: Excel 2010 Shortcuts
Section D: Creating and Manipulating Data
Section E: Managing Worksheets
Section F: Data Validation
Section G: Modifying Cell Content
Section H: Changing Views
Session 2
Section A: Formatting Data
Section B: Formatting Numbers
Section C: Formatting Text and Tables
Section D: Understanding Formulas
Session 3
Section A: Referencing Formulas
Section B: Ranges and Dates
Section C: Subtotals
Section D: Using VLOOKUP
Section E: Using Nested Formulas
Section F: Conditional Logic
Section G: More Conditional Logic
Session 4
Section A: Financial Formulas
Section B: What-If Functions
Section C: Working with Text Formulas
Section D: Paste Special
Section E: Introduction to Charts
Section F: Formatting Charts
Section G: Conditional Formatting
Section H: Adding Graphics to Spreadsheets
Session 5
Section A: Outlining, Sorting, and Filtering
Section B: PivotTables and PivotCharts
Section C: Protecting Data
Section D: Introduction to Backstage
Section E: Collaboration
Section F: Saving Workbooks
Section G: Printing Workbooks
Section H: Macros with VB for Applications
Outlook 2010Session 1
Section A: Getting Started
Section B: Manipulate Outlook Options
Section C: Managing Outlook Views
Section D: E-mail Organization Techniques
Section E: Search and Filter Tools
Section F: Create and Format E-mails
Section G: Insert Content and Graphical Elements
Section H: Message Send Options
Session 2
Section A: Managing E-mails and Mailboxes
Section B: Managing Conversations
Section C: Managing Rules
Section D: Quick Steps
Section E: Managing Junk Mail
Section F: RSS Feeds and Social Networking
Session 3
Section A: Working with Contacts
Section B: Business Cards and Contact Groups
Section C: Working with the Calendar Pane
Section D: Managing Appointments and Events
Section E: Meeting Requests
Section F: Managing Tasks
Section G: Working with Notes
Section H: Working with Journals
Section I: Spelling and Printing
Powerpoint 2010Session 1
Section A: Building Effective Presentations
Section B: PowerPoint 2010 Overview
Section C: Creating Presentations
Section D: Creating Initial Content
Section E: Design Themes
Section F: Slide Masters
Section G: Working with Text
Section H: Working with Lists
Session 2
Section A: Using Existing Content
Section B: Embedded Charts
Section C: Excel Charts
Section D: Working with Tables
Section E: Shapes and Effects
Section F: Clip Art and Images
Section G: Moving, Arranging, and Distributing
Section H: SmartArt Diagrams
Section I: Backgrounds, Watermarks, and Photo Album
Session 3
Section A: Multimedia
Section B: Animations
Section C: Customizing Slide Shows
Section D: Delivery Formats
Section E: Proofing and Reviewing
Section F: Prepare and Protect
Section G: Delivering the Presentation
Word 2010Session 1
Section A: Introduction
Section B: Navigating Documents
Section C: Using Backstage
Section D: Managing Document Design
Section E: Preparing Documents for Printing
Section F: Printing
Session 2
Section A: Working with Templates
Section B: Formatting Text
Section C: Formatting Paragraphs
Section D: Organizing Data
Section E: Bulleted and Numbered Lists
Section F: Manipulating Page Layout
Section G: Manipulating Page Backgrounds
Section H: Headers and Footers
Session 3
Section A: Working with Visual Content
Section B: Shapes, SmartArt, and Charts
Section C: Customizing Document Styles
Section D: Citing References
Section E: Mail Merge
Section F: Document Collaboration
Assessments
The Office 2010 Training course prepares you for the MOS Exams.
Please note that the course fee does not include any software or exam costs.
Further Info
- 95 hours training on 19 packed CDs
- Level - Beginner to Advanced and then onto Expert
- Tests and exercises included
- MOS Exam coverage
What's Included
The course pack includes, guidance on relevant study skills and full tutor support comprising:
- Instructor-Led Video Training
- Demos and Lab Learning
- Support via forums
- Multi-Media Presentations
- Practice Exams and Lab Simulators
- Self-Paced Navigation
Requirements
Entry Requirements
Our Office 2010 Training course is openly available to anyone wishing to learn more about Office 2010 and has a keen interest in the subject, plus an intention to progress a career.
- Learners will need sufficient numeracy and literacy
- Students should have access to a computer and the Internet throughout your study period.
- Learners should have networking skills in order to progress throughout the course.
- You should be fully committed to your studies.
Please note there are some hardware & operating systems and software requirements, please enquire now for more information.
Questions and answers
Reviews
Currently there are no reviews for this course. Be the first to leave a review.
Legal information
This course is advertised on reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.