Ready to Checkout?

shopping-cart

Quality Training Since 2001

Microsoft Office Training Course

demo-buttonbuy-now-buttonsyllabus-button

microsoft-office-training-tutorial

Course Title: Mastering Microsoft Office Made Easy
Courses Included: Access, Excel, OneNote, Outlook, PowerPoint, Publisher & Word
Versions Covered: 2013, 2010 & 2007
Hours of Content: 42
Video Lessons: 786
Manuals: 15 (Introductory, Intermediate & Advanced)
Download/DVD: $129 |   
Online: Access ALL courses. One price. | 
Multi-User: Need to train multiple people? | 
CPE Credits: CPAs (57) | Verify

Course Description

Learn Microsoft Office with this comprehensive course from TeachUcomp, Inc. Mastering Microsoft Office Made Easy features 786 video lessons with over 42 hours of introductory through advanced instruction. You get our complete courses in Access, Excel, OneNote, Outlook, PowerPoint, Publisher and Word. Watch, listen and learn as your expert instructors guide you through each lesson step-by-step. During this media-rich learning experience, you will see each function performed just as if your instructor were there with you. Reinforce your learning with the text of our fifteen printable classroom instruction manuals (Introductory, Intermediate and Advanced), additional images and practice exercises.  This complete Microsoft Office course covers the same curriculum as our classroom training and was designed to provide a solid foundation in Office.

Whether you are completely new to Microsoft Office or upgrading from an older version, this course will empower you with the knowledge and skills necessary to be a proficient user. We have incorporated years of classroom training experience and teaching techniques to develop an easy-to-use course that you can customize to meet your personal learning needs.  Simply launch the easy-to-use interface, click to start a video lesson or open one of the manuals and you’re on your way to mastering Office.

 

Access Course Syllabus & Sample Lessons

Select any of the video lessons markedfreeto view them in a new window.

To view samples of the instruction manuals in PDF, click here: Introductory Access | Intermediate Access | Advanced Access

CHAPTER 1- Getting Acquainted with Access
Lesson 1.1- Creating a New Database – 2013 free
Lesson 1.2- Creating a New Database – 2010:2007
Lesson 1.3- Overview of a Database
Lesson 1.4- The Access Interface free
Lesson 1.5- Touch Mode
Lesson 1.6- Viewing Database Objects in the Navigation Bar
Lesson 1.7- Opening and Closing Databases – 2013
Lesson 1.8- Opening and Closing Databases – 2010:2007
CHAPTER 2- Creating Relational Database Tables
Lesson 2.1- The “Flat File” Method of Data Storage
Lesson 2.2- The Relational Model of Data Storage
Lesson 2.3- Tips for Creating a Relational Database
Lesson 2.4- Creating Relational Database Tables free
Lesson 2.5- Assigning a Primary Key to a Table free
CHAPTER 3- Using Tables
Lesson 3.1- Using Datasheet View
Lesson 3.2- Navigating in Datasheet View
Lesson 3.3- Adding Records in Database View
Lesson 3.4- Editing and Deleting Records in Datasheet View
Lesson 3.5- Inserting New Fields
Lesson 3.6- Renaming Fields
Lesson 3.7- Deleting Fields
CHAPTER 4- Field Properties
Lesson 4.1- Setting Field Properties free
Lesson 4.2- The ‘Field Size’ Property free
Lesson 4.3- The ‘Format’ Property for Date/Time Fields
Lesson 4.4- The ‘Format’ Property for Logical Fields
Lesson 4.5- Setting Default Values for Fields
Lesson 4.6- Setting Input Masks
Lesson 4.7- Setting Up Validation Rules and Responses
Lesson 4.8- Requiring Field Input
Lesson 4.9- Allowing Zero Length Entries
CHAPTER 5- Joining Tables in a Database
Lesson 5.1- The Relationships Window free
Lesson 5.2- Enforcing Referential Integrity free
Lesson 5.3- Creating Lookup Fields
CHAPTER 6- Indexing Tables
Lesson 6.1- Indexes free
Lesson 6.2- Creating Indexes free
Lesson 6.3- Deleting Indexes
CHAPTER 7- Queries
Lesson 7.1- Using the Simple Query Wizard
Lesson 7.2- Designing Queries
Lesson 7.3- Joining Tables in a Query
Lesson 7.4- Adding Criteria to the QBE Grid
Lesson 7.5- Running A Query
Lesson 7.6- How is Using the QBE Grid Writing SQL Code?
Lesson 7.7- Sorting Query Results
Lesson 7.8- Hiding Fields in a Query
Lesson 7.9- Using Comparison Operators
Lesson 7.10- Using ‘AND’ and ‘OR’ Conditions
CHAPTER 8- Advanced Queries
Lesson 8.1- Using the ‘BETWEEN…AND’ Condition
Lesson 8.2- Using Wildcard Characters in Criteria
Lesson 8.3- Creating a Calculated Field
Lesson 8.4- Creating ‘Top Value’ Queries
Lesson 8.5- Function Queries
Lesson 8.6- Parameter Queries
CHAPTER 9- Advanced Query Types
Lesson 9.1- Make-Table Queries
Lesson 9.2- Update Queries
Lesson 9.3- Append Queries
Lesson 9.4- Delete Queries
Lesson 9.5- Crosstab Queries
Lesson 9.6- The ‘Find Duplicates’ Query
Lesson 9.7- The ‘Find Unmatched’ Query
CHAPTER 10- Creating Forms
Lesson 10.1- Forms Overview
Lesson 10.2- The Form Wizard
Lesson 10.3- Creating AutoForms
Lesson 10.4- Using Forms
Lesson 10.5- Form and Report Layout View
Lesson 10.6- Form and Report Design View
Lesson 10.7- Viewing the Ruler and Gridlines
Lesson 10.8- The ‘Snap to Grid’ Feature
Lesson 10.9- Creating a Form in Design View
CHAPTER 11- Form & Report Controls
Lesson 11.1- Selecting Controls
Lesson 11.2- Deleting Controls
Lesson 11.3- Moving and Resizing Controls
Lesson 11.4- Sizing Controls ‘To Fit’
Lesson 11.5- ‘Nudging’ Controls
Lesson 11.6- Aligning, Spacing and Sizing Controls
Lesson 11.7- Formatting Controls
Lesson 11.8- Viewing Control Properties
CHAPTER 12- Using Controls
Lesson 12.1- The Controls Group
Lesson 12.2- Adding Label Controls
Lesson 12.3- Adding Logos and Image Controls
Lesson 12.4- Adding Line and Rectangle Controls
Lesson 12.5- Adding Combo Box Controls
Lesson 12.6- Adding List Box Controls
Lesson 12.7- Setting Tab Order
CHAPTER 13- Subforms
Lesson 13.1- Creating Subforms
Lesson 13.2- Using the Subform/Subreport Control
CHAPTER 14- Reports
Lesson 14.1- Using the Report Wizard
Lesson 14.2- Using Basic Reports
Lesson 14.3- Creating a Report in Design View
Lesson 14.4- Sorting and Grouping Data in Reports
Lesson 14.5- Creating Calculated Fields
CHAPTER 15- Subreports
Lesson 15.1- Creating Subreports
CHAPTER 16- Charting Data
Lesson 16.1- Using Charts
CHAPTER 17- Macros in Access 2007
Lesson 17.1- Creating and Using Macros
Lesson 17.2- Macro Actions
Lesson 17.3- Assigning Macros to a Command Button
Lesson 17.4- Conditional Macros and Option Groups
Lesson 17.5- Using Group Names in Macros
Lesson 17.6- Creating Autoexec Macros
CHAPTER 18- Macros in Access 2013:2010
Lesson 18.1- Creating a Standalone Macro
Lesson 18.2- Assigning Macros to a Command Button
Lesson 18.3- Using Program Flow with Macros
Lesson 18.4- Creating Autoexec Macros
Lesson 18.5- Creating Data Macros
CHAPTER 19- Switchboard and Navigation Forms
Lesson 19.1- Creating a Switchboard Form
Lesson 19.2- Creating a Navigation Form – 2013:2010
Lesson 19.3- Controlling Startup Behavior – 2007
Lesson 19.4- Controlling Startup Behavior – 2013:2010
CHAPTER 20- Advanced Features
Lesson 20.1- Getting External Data
Lesson 20.2- Exporting Data
Lesson 20.3- Setting a Database Password – 2007
Lesson 20.4- Setting a Database Password – 2013:2010
Lesson 20.5- Using Help

Excel Course Syllabus & Sample Lessons

Select any of the video lessons markedfreeto view them in a new window.

To view samples of the instruction manuals in PDF, click here: Introductory Excel | Intermediate Excel | Advanced Excel

CHAPTER 1- Getting Acquainted with Excel
Lesson 1.1- About Excel free
Lesson 1.2- The Excel Environment- 2013 free
Lesson 1.3- The Excel Environment- 2010
Lesson 1.4- The Excel Environment- 2007
Lesson 1.5- The Title Bar
Lesson 1.6- The Ribbon
Lesson 1.7- The “File” Tab and Backstage View
Lesson 1.8- The Microsoft Office Button- 2007 Only
Lesson 1.9- Scroll Bars
Lesson 1.10- The Quick Access Toolbar
Lesson 1.11- Touch Mode
Lesson 1.12- The Formula Bar
Lesson 1.13- The Workbook Window
Lesson 1.14- The Status Bar
Lesson 1.15- The Workbook View Buttons
Lesson 1.16- The Zoom Slider
Lesson 1.17- The Mini Toolbar
Lesson 1.18- Keyboard Shortcuts
CHAPTER 2- File Management
Lesson 2.1- Creating New Workbooks- 2013 free
Lesson 2.2- Creating New Workbooks- 2010
Lesson 2.3- Creating New Workbooks- 2007
Lesson 2.4- Saving Workbooks- 2013 free
Lesson 2.5- Saving Workbooks- 2010
Lesson 2.6- Saving Workbooks- 2007
Lesson 2.7- Closing Workbooks- 2013
Lesson 2.8- Closing Workbooks- 2010 and 2007
Lesson 2.9- Opening Workbooks- 2013
Lesson 2.10- Opening Workbooks- 2010
Lesson 2.11- Opening Workbooks- 2007
Lesson 2.12- Recovering Unsaved Workbooks
Lesson 2.13- Using the “Window” Command Group
Lesson 2.14- Switching to Full Screen View
Lesson 2.15- Working With Excel File Formats
CHAPTER 3- Data Entry
Lesson 3.1- Selecting Cells free
Lesson 3.2- Entering Text into Cells free
Lesson 3.3- Entering Numbers into Cells free
Lesson 3.4- AutoComplete
Lesson 3.5- Pick from Drop-Down List
Lesson 3.6- Flash Fill- 2013 Only
Lesson 3.7- Selecting Ranges
Lesson 3.8- Ranged Data Entry
Lesson 3.9- Using AutoFill
CHAPTER 4- Creating Formulas
Lesson 4.1- Ranged Formula Syntax free
Lesson 4.2- Simple Formula Syntax free
Lesson 4.3- Writing Formulas free
Lesson 4.4- Using AutoSum
Lesson 4.5- Inserting Functions
Lesson 4.6- Editing a Range
Lesson 4.7- Formula AutoCorrect
Lesson 4.8- AutoCalculate
Lesson 4.9- Function Compatibility- 2013 Only
CHAPTER 5- Copying & Pasting Formulas
Lesson 5.1- Relative References and Absolute References
Lesson 5.2- Cutting, Copying, and Pasting Data
Lesson 5.3- AutoFilling Cells
Lesson 5.4- The Undo Button
Lesson 5.5- The Redo Button
CHAPTER 6- Columns & Rows
Lesson 6.1- Selecting Columns & Rows
Lesson 6.2- Adjusting Column Width and Row Height
Lesson 6.3- Hiding and Unhiding Columns and Rows
Lesson 6.4- Inserting and Deleting Columns and Rows
CHAPTER 7- Formatting Worksheets
Lesson 7.1- Formatting Cells
Lesson 7.2- The Format Cells Dialog Box
Lesson 7.3- Clearing All Formatting from Cells
Lesson 7.4- Copying All Formatting from Cells to Another Area
CHAPTER 8- Worksheet Tools
Lesson 8.1- Inserting and Deleting Worksheets
Lesson 8.2- Selecting Multiple Worksheets
Lesson 8.3- Navigating Worksheets- 2013 Only
Lesson 8.4- Navigating Worksheets- 2010:2007
Lesson 8.5- Renaming Worksheets
Lesson 8.6- Coloring Worksheet Tabs
Lesson 8.7- Copying or Moving Worksheets
CHAPTER 9- Setting Worksheet Layout
Lesson 9.1- Using Page Break Preview
Lesson 9.2- Using Page Layout View
Lesson 9.3- The Page Setup Dialog Box
CHAPTER 10- Printing Spreadsheets
Lesson 10.1- Previewing and Printing Worksheets- 2013:2010
Lesson 10.2- Using Print Preview- 2007 Only
Lesson 10.3- Printing Worksheets- 2007 Only
CHAPTER 11- Helping Yourself
Lesson 11.1- Using Excel Help
CHAPTER 12- Creating 3D Formulas
Lesson 12.1- Creating 3D Formulas
Lesson 12.2- 3D Formula Syntax
Lesson 12.3- Creating 3D Range References
CHAPTER 13- Named Ranges
Lesson 13.1- Naming Ranges
Lesson 13.2- Creating Names from Headings
Lesson 13.3- Moving to a Named Range
Lesson 13.4- Using Named Ranges in Formulas
Lesson 13.5- Naming 3D Ranges
Lesson 13.6- Managing Named Ranges
CHAPTER 14- Conditional Formatting and Cell Styles
Lesson 14.1- Conditional Formatting
Lesson 14.2- Finding Cells with Conditional Formatting
Lesson 14.3- Clearing Conditional Formatting
Lesson 14.4- Using Table and Cell Styles
CHAPTER 15- Paste Special
Lesson 15.1- Using Paste Special
Lesson 15.2- Pasting Linked Formulas
CHAPTER 16- Sharing Workbooks
Lesson 16.1- Sharing Workbooks
Lesson 16.2- Highlighting Changes
Lesson 16.3- Reviewing Changes
Lesson 16.4- Using Comments
Lesson 16.5- Compare and Merge Workbooks
CHAPTER 17- Auditing Worksheets
Lesson 17.1- Auditing Worksheets
Lesson 17.2- Tracing Precedent and Dependent Cells
Lesson 17.3- Tracing Errors
Lesson 17.4- Error Checking
Lesson 17.5- Using the Watch Window
Lesson 17.6- Cell Validation
CHAPTER 18- Outlining Worksheets
Lesson 18.1- Using Outlines
Lesson 18.2- Applying and Removing Outlines
CHAPTER 19- Consolidating Worksheets
Lesson 19.1- Consolidating Data
CHAPTER 20- Tables
Lesson 20.1- Creating a Table
Lesson 20.2- Adding an Editing Records
Lesson 20.3- Inserting Records and Fields
Lesson 20.4- Deleting Records and Fields
CHAPTER 21- Sorting Data
Lesson 21.1- Sorting Data
Lesson 21.2- Custom Sort Orders
CHAPTER 22- Filtering Data
Lesson 22.1- Using AutoFilters
Lesson 22.2- Using the Top 10 AutoFilter
Lesson 22.3- Using a Custom AutoFilter
Lesson 22.4- Creating Advanced Filters
Lesson 22.5- Applying Multiple Criteria
Lesson 22.6- Using Complex Criteria
Lesson 22.7- Copying Filter Results to a New Location
Lesson 22.8- Using Database Functions
CHAPTER 23- Using What-If Analysis
Lesson 23.1- Using Data Tables
Lesson 23.2- Using Scenario Manager
Lesson 23.3- Using Goal Seek
CHAPTER 24- Table-Related Functions
Lesson 24.1- The Hlookup and Vlookup Functions
Lesson 24.2- Using the IF, AND, and OR Functions
CHAPTER 25- Sparklines
Lesson 25.1- Inserting and Deleting Sparklines
Lesson 25.2- Modifying Sparklines
CHAPTER 26- Creating Charts In Excel 2013
Lesson 26.1- Creating Charts
Lesson 26.2- Selecting Charts and Chart Elements
Lesson 26.3- Adding Chart Elements
Lesson 26.4- Moving and Resizing Charts
Lesson 26.5- Changing the Chart Type
Lesson 26.6- Changing the Data Range
Lesson 26.7- Switching Column and Row Data
Lesson 26.8- Choosing a Chart Layout
Lesson 26.9 Choosing a Chart Style
Lesson 26.10 Changing Color Schemes
Lesson 26.11- Printing Charts
Lesson 26.12- Deleting Charts
CHAPTER 27- Creating Charts in Excel 2010 & 2007
Lesson 27.1- Creating Charts
Lesson 27.2- Selecting Charts and Chart Elements
Lesson 27.3- Moving and Resizing Charts
Lesson 27.4- Changing the Chart Type
Lesson 27.5- Changing the Data Range
Lesson 27.6- Switching Column and Row Data
Lesson 27.7- Choosing a Chart Layout
Lesson 27.8- Choosing a Chart Style
Lesson 27.9- Printing Charts
Lesson 27.10- Deleting Charts
CHAPTER 28- Formatting Charts in Excel 2013
Lesson 28.1- Formatting Chart Objects
Lesson 28.2- Inserting Objects into a Chart
Lesson 28.3- Formatting Axes
Lesson 28.4- Formatting Axis Titles
Lesson 28.5- Formatting a Chart Title
Lesson 28.6- Formatting Data Labels
Lesson 28.7- Formatting a Data Table
Lesson 28.8- Formatting Error Bars
Lesson 28.9- Formatting Gridlines
Lesson 28.10- Formatting a Legend
Lesson 28.11- Formatting Drop and High-Low Lines
Lesson 28.12- Formatting Trendlines
Lesson 28.13- Formatting Up/Down Bars
Lesson 28.14- Formatting the Chart and Plot Areas
Lesson 28.15- Naming Charts
Lesson 28.16- Applying Shape Styles
Lesson 28.17- Applying WordArt Styles
Lesson 28.18- Saving Custom Chart Templates
CHAPTER 29- Formatting Charts in Excel 2010 & 2007
Lesson 29.1- Formatting Chart Objects
Lesson 29.2- Inserting Objects into a Chart
Lesson 29.3- Changing Chart Labels
Lesson 29.4- Changing Axes Display
Lesson 29.5- Changing the Chart Background
Lesson 29.6- Applying Chart Analysis Lines
Lesson 29.7- Naming Charts
Lesson 29.8- Applying Shape Styles to Chart Elements
Lesson 29.9- Applying WordArt Styles to Chart Elements
Lesson 29.10- Saving Custom Chart Templates
CHAPTER 30- Data Models
Lesson 30.1- Creating a Data Model from External Relational Data
Lesson 30.2- Creating a Data Model from Excel Tables
Lesson 30.3- Relating Tables in a Data Model
Lesson 30.4- Managing a Data Model
CHAPTER 31- PivotTables and PivotCharts- 2013
Lesson 31.1- Creating Recommended PivotTables
Lesson 31.2- Manually Creating a PivotTable
Lesson 31.3- Creating a PivotChart
Lesson 31.4- Manipulating a PivotTable or PivotChart
Lesson 31.5- Changing Calculated Value Fields
Lesson 31.6- Formatting PivotTables
Lesson 31.7- Formatting PivotCharts
Lesson 31.8- Setting PivotTable Options
Lesson 31.9- Sorting and Filtering Using Field Headers
CHAPTER 32- PivotTables and PivotCharts- 2010:2007
Lesson 32.1- Creating PivotTables and PivotCharts
Lesson 32.2- Manipulating a PivotTable
Lesson 32.3- Changing Calculated Value Fields
Lesson 32.4- Applying PivotTable Styles
Lesson 32.5- Creating a PivotChart
Lesson 32.6- Setting PivotTable Options
Lesson 32.7- Sorting and Filtering PivotTable Data
CHAPTER 33- PowerPivot
Lesson 33.1- Starting PowerPivot
Lesson 33.2- Managing the Data Model
Lesson 33.3- Calculated Columns and Fields
Lesson 33.4- Creating KPIs
Lesson 33.5- Creating and Managing Perspectives
Lesson 33.6- PowerPivot PivotTables and PivotCharts
CHAPTER 34- Power View
Lesson 34.1- Starting Power View
Lesson 34.2- Adding Report Visualizations
Lesson 34.3- Changing the Layout of Report Visualizations
Lesson 34.4- Using Undo and Redo in Power View
Lesson 34.5- Formatting the Power View Sheet
Lesson 34.6- Creating Multiples in a Chart
CHAPTER 35- Slicers and Timelines
Lesson 35.1- Inserting and Deleting Slicers
Lesson 35.2- Modifying Slicers
Lesson 35.3- Inserting and Deleting Timelines
Lesson 35.4- Modifying Timelines
CHAPTER 36- Security Features
Lesson 36.1- Unlocking Cells
Lesson 36.2- Worksheet Protection
Lesson 36.3- Workbook Protection
Lesson 36.4- Password Protecting Excel Files- 2013
Lesson 36.5- Password Protecting Excel Files- 2010:2007
CHAPTER 37- Making Macros
Lesson 37.1- Recording Macros
Lesson 37.2- Running and Deleting Recorded Macros
Lesson 37.3- The Personal Macro Workbook

OneNote Course Syllabus & Sample Lessons

Select any of the video lessons markedfreeto view them in a new window.

To view a sample of the instruction manual in PDF, click here: Introductory OneNote

CHAPTER 1- Getting Acquainted with OneNote
Lesson 1.1- The OneNote Environment free
Lesson 1.2- The Title Bar
Lesson 1.3- The Ribbon
Lesson 1.4- The “File” Tab and Backstage View
Lesson 1.5- The Quick Access Toolbar
Lesson 1.6- The Scroll Bars
Lesson 1.7- The Mini Toolbar
Lesson 1.8- The Default “Personal” Notebook
CHAPTER 2- Getting Started
Lesson 2.1- Opening, Saving and Closing Notebooks free
Lesson 2.2- Creating New Notebooks
Lesson 2.3- Creating, Moving and Deleting Sections and Pages
Lesson 2.4- Creating, Moving and Deleting Subpages
CHAPTER 3- Notes
Lesson 3.1- Creating a Basic Note free
Lesson 3.2- Quick (Unfiled) Notes
Lesson 3.3- Copying and Pasting Content free
Lesson 3.4- Screen Clippings
Lesson 3.5- Adding Pictures
Lesson 3.6- Adding Audio & Video Files
Lesson 3.7- Recording Audio & Video Files
Lesson 3.8- Adding Other Types of Files
Lesson 3.9- Embedding an Excel Spreadsheet or Visio Diagram
Lesson 3.10- Adding Mathematical Equations
Lesson 3.11- Quick Filing – Sending Information to OneNote
CHAPTER 4- Formatting Notes
Lesson 4.1- Basic Text Formatting free
Lesson 4.2- Bullets and Numbering free
Lesson 4.3- Checking Spelling
Lesson 4.4- Setting Default Proofing Options
CHAPTER 5- Working with Microsoft Outlook
Lesson 5.1- Inserting Outlook Meetings free
Lesson 5.2- Sending Notebook Pages via Microsoft Outlook free
Lesson 5.3- Working with Microsoft Outlook Tasks
CHAPTER 6- Tables
Lesson 6.1- Creating a Table free
Lesson 6.2- Working with Columns and Rows free
Lesson 6.3- Formatting Tables and Table Data
Lesson 6.4- Moving Tables and Table Data
CHAPTER 7- Writing Tools
Lesson 7.1- Pen Mode
Lesson 7.2- Formatting Written Notes & Drawings
Lesson 7.3- Converting Handwriting to Type
CHAPTER 8- Viewing and Organizing Information
Lesson 8.1- Organizing the OneNote Interface
Lesson 8.2- Creating New Windows
Lesson 8.3 Searching Content in a Notebook
Lesson 8.4- Wiki Linking
Lesson 8.5- Tagging Notes
Lesson 8.6- Working with Sections
Lesson 8.7- Section Groups
CHAPTER 9- Stationery and Templates
Lesson 9.1- Applying Templates and Stationery
Lesson 9.2- Custom Templates
Lesson 9.3- Choosing a Default Template
CHAPTER 10- Formatting Pages
Lesson 10.1- Defining Paper Size and Margins
Lesson 10.2- Formatting Page Backgrounds
Lesson 10.3- Adding a Background Graphic
CHAPTER 11- Printing
Lesson 11.1- Previewing and Printing
CHAPTER 12- Sharing Notebooks & Collaborating
Lesson 12.1- Saving Notebooks to Share
Lesson 12.2- Creating a Shared Notebook
Lesson 12.3- Inviting Others to Share
Lesson 12.4- Sharing Notes in an Outlook Meeting Invitation
Lesson 12.5- Synching Notebooks
Lesson 12.6- Sending Pages in Various Formats
Lesson 12.7- Sharing Notebooks with SkyDrive
Lesson 12.8- Author Indicators
Lesson 12.9- Finding Newly Added Content with Highlighting
Lesson 12.10- Page Versions
CHAPTER 13- Researching with OneNote
Lesson 13.1- Linked Notes
Lesson 13.2- The Research Pane
Lesson 13.3- Translating Text with the Mini Translator
CHAPTER 14- Changing OneNote Options
Lesson 14.1- Changing Display Options
Lesson 14.2- Changing Other Options
CHAPTER 15- Helping Yourself
Lesson 15.1- Using OneNote Help

Outlook Course Syllabus & Sample Lessons

Select any of the video lessons markedfreeto view them in a new window.

To view a sample of the instruction manual in PDF, click here: Introductory Outlook | Advanced Outlook

CHAPTER 1- Getting Acquainted with Outlook
Lesson 1.1- The Outlook Environment- 2013 free
Lesson 1.2- The Outlook Environment- 2010
Lesson 1.3- The Outlook Environment- 2007
Lesson 1.4- The Title Bar
Lesson 1.5- The Menu Bar
Lesson 1.6- Using Toolbars
Lesson 1.7- The Standard Toolbar
Lesson 1.8- The Ribbon
Lesson 1.9- The Microsoft Office Button
Lesson 1.10- The Quick Access Toolbar
Lesson 1.11- Touch Mode
Lesson 1.12- The Navigation Bar, Reading Pane, and To-Do Bar
CHAPTER 2- Making Contacts
Lesson 2.1- The Contacts Folder free
Lesson 2.2- Customizing the Contacts Folder View free
Lesson 2.3- Creating Contacts
Lesson 2.4- Basic Contact Management
Lesson 2.5- Printing Contacts
Lesson 2.6- Creating Contact Groups
Lesson 2.7- Categorizing Contacts
Lesson 2.8- Searching for Contacts
Lesson 2.9- Calling Contacts
Lesson 2.10- Mapping a Contact’s Address
CHAPTER 3- E-Mail
Lesson 3.1- Using the Inbox free
Lesson 3.2- Changing the Inbox View free
Lesson 3.3- Message Flags
Lesson 3.4- Searching for Messages
Lesson 3.5- Creating, Addressing, and Sending Messages
Lesson 3.6- Checking Message Spelling
Lesson 3.7- Setting Message Options
Lesson 3.8- Formatting Messages
Lesson 3.9- Using Signatures
Lesson 3.10- Replying to Messages
Lesson 3.11- Forwarding Messages
Lesson 3.12- Sending Attachments
Lesson 3.13- Opening Attachments
CHAPTER 4- The Sent Items Folder
Lesson 4.1- The Sent Items Folder
Lesson 4.2- Resending Messages
Lesson 4.3- Recalling Messages
CHAPTER 5- The Outbox Folder
Lesson 5.1- Using the Outbox
CHAPTER 6- Using the Calendar
Lesson 6.1- The Calendar Window free
Lesson 6.2- Switching the Calendar View
Lesson 6.3- Navigating the Calendar
Lesson 6.4- Appointments, Meetings and Events
Lesson 6.5- Manipulating Calendar Objects
Lesson 6.6- Setting an Appointment
Lesson 6.7- Scheduling a Meeting- 2013:2010 free
Lesson 6.8- Scheduling a Meeting- 2007
Lesson 6.9- Checking Meeting Attendance Status
Lesson 6.10- Responding to Meeting Requests
Lesson 6.11- Scheduling an Event
Lesson 6.12- Setting Recurrence
Lesson 6.13- Printing the Calendar
CHAPTER 7- Tasks
Lesson 7.1- Using Tasks free
Lesson 7.2- Printing the Tasks
Lesson 7.3- Creating a Task free
Lesson 7.4- Setting Task Recurrence
Lesson 7.5- Creating a Task Request
Lesson 7.6- Responding to Task Requests
Lesson 7.7- Sending Status Reports
Lesson 7.8- Deleting Tasks
CHAPTER 8- Deleted Items
Lesson 8.1- The Deleted Items Folder
Lesson 8.2- Permanently Deleting Items
Lesson 8.3- Recovering Deleted Items
CHAPTER 9- Using the Journal
Lesson 9.1- The Journal Folder
Lesson 9.2- Switching the Journal View
Lesson 9.3- Recording Journal Items Automatically
Lesson 9.4- Recording Journal Items Manually
Lesson 9.5- Opening Journal Entries and Documents
Lesson 9.6- Deleting Journal Items
CHAPTER 10- Public Folders
Lesson 10.1- Creating Public Folders free
Lesson 10.2- Setting Permissions
Lesson 10.3- Folder Rules
Lesson 10.4- Copying Public Folders
CHAPTER 11- Personal and Private Folders
Lesson 11.1- Creating a Personal Folder
Lesson 11.2- Setting AutoArchiving for Folders
Lesson 11.3- Creating Private Folders
Lesson 11.4- Creating Search Folders
CHAPTER 12- Notes
Lesson 12.1- Creating and Using Notes
CHAPTER 13- Advanced Mailbox Options
Lesson 13.1- Creating Mailbox Rules
Lesson 13.2- Creating Custom Mailbox Views
Lesson 13.3- Handling Junk Mail
Lesson 13.4- Color Categorizing
Lesson 13.5- Advanced Find
CHAPTER 14- Odds and Ends
Lesson 14.1- Using Shortcuts
Lesson 14.2- Adding Additional Profiles
Lesson 14.3- Adding Additional Services
Lesson 14.4- Outlook Options
Lesson 14.5- Using Outlook Help
CHAPTER 15- Delegates
Lesson 15.1- Creating a Delegate
Lesson 15.2- Acting as a Delegate
Lesson 15.3- Deleting a Delegate

PowerPoint Course Syllabus & Sample Lessons

Select any of the video lessons markedfreeto view them in a new window.

To view a sample of the instruction manual in PDF, click here: Introductory PowerPoint | Advanced PowerPoint

CHAPTER 1- Getting Acquainted with PowerPoint
Lesson 1.1- The PowerPoint Environment- 2013 free
Lesson 1.2- The PowerPoint Environment- 2010
Lesson 1.3- The PowerPoint Environment- 2007
Lesson 1.4- The Title Bar free
Lesson 1.5- The Ribbon free
Lesson 1.6- The “File” Tab and Backstage View
Lesson 1.7- The Microsoft Office Button- 2007 Only
Lesson 1.8- The Quick Access Toolbar
Lesson 1.9- Touch Mode
Lesson 1.10- The Scroll Bars
Lesson 1.11- The Presentation View Buttons
Lesson 1.12- The Zoom Slider
Lesson 1.13- The Status Bar
Lesson 1.14- The Mini Toolbar
Lesson 1.15- Keyboard Shortcuts
CHAPTER 2- Creating Basic Presentations
Lesson 2.1- Opening Presentations- 2013 Only free
Lesson 2.2- Opening Presentations- 2010 Only
Lesson 2.3- Opening Presentations- 2007 Only
Lesson 2.4- Closing Presentations
Lesson 2.5- Creating New Presentations- 2013:2010
Lesson 2.6- Creating New Presentations- 2007 Only
Lesson 2.7- Saving Presentations- 2013 Only
Lesson 2.8- Saving Presentations- 2010 Only
Lesson 2.9- Saving Presentations- 2007 Only
Lesson 2.10- Recovering Unsaved Presentations- 2013
Lesson 2.11- Inserting New Slides
Lesson 2.12- Applying Slide Layouts
Lesson 2.13- Sharing Presentations- 2013
Lesson 2.14- Using the “Save & Send” Features- 2010
Lesson 2.15- Working with PowerPoint File Formats
CHAPTER 3- Using Presentation Views
Lesson 3.1- Normal View free
Lesson 3.2- Slide Sorter View free
Lesson 3.3- Notes Page View
Lesson 3.4- Slide Show View
Lesson 3.5- Reading View- 2013:2010
CHAPTER 4- Using Text
Lesson 4.1- Adding Text to Slides free
Lesson 4.2- Basic Object Manipulation free
Lesson 4.3- Font Formatting
Lesson 4.4- Paragraph Formatting
Lesson 4.5- Applying Custom Bullets and Numbering
Lesson 4.6- Using Tabs
Lesson 4.7- Setting Text Options- 2013 Only
Lesson 4.8- Setting Text Box Options- 2010:2007
Lesson 4.9- Checking Spelling
CHAPTER 5- Using Pictures
Lesson 5.1- Inserting Pictures- 2013 Only free
Lesson 5.2- Inserting Online Pictures- 2013 Only free
Lesson 5.3- Inserting Clip Art and Pictures- 2010:2007
Lesson 5.4- Basic Graphic Manipulation
Lesson 5.5- Using Picture Tools- 2013:2010
Lesson 5.6- Using Picture Tools- 2007 Only
Lesson 5.7- Using the Format Picture Task Pane- 2013
Lesson 5.8- Fill & Line Settings- 2013
Lesson 5.9- Effects Settings- 2013
Lesson 5.10- Size & Properties Settings- 2013
Lesson 5.11- Picture Settings- 2013
Lesson 5.12- The Format Picture Dialog Box- 2010
Lesson 5.13- The Format Picture Dialog Box- 2007
CHAPTER 6- Using SmartArt
Lesson 6.1- Inserting and Manipulating SmartArt
Lesson 6.2- Formatting SmartArt
CHAPTER 7- Using Slide Show View
Lesson 7.1- Running a Slide Show
Lesson 7.2- Using Custom Shows
CHAPTER 8- Printing Your Presentation
Lesson 8.1- Changing Slide Size- 2013
Lesson 8.2- Using Page Setup- 2010:2007
Lesson 8.3- Setting the Slide Header and Footer
Lesson 8.4- Using Print Preview- 2007
Lesson 8.5- Printing- 2007
Lesson 8.6- Previewing and Printing- 2013:2010
CHAPTER 9- Helping Yourself
Lesson 9.1- Using PowerPoint Help
CHAPTER 10- Applying Animation
Lesson 10.1- Adding Slide Transition Animation- 2013:2010
Lesson 10.2- Adding Object Animation- 2013:2010
Lesson 10.3- Adding Slide Transition Animation- 2007
Lesson 10.4- Adding Custom Animation- 2007
CHAPTER 11- Drawing Objects
Lesson 11.1- Inserting Shapes
Lesson 11.2- Formatting Shapes- 2013:2010
Lesson 11.3- Formatting Shapes- 2007
Lesson 11.4- Inserting WordArt- 2013:2010
Lesson 11.5- Inserting WordArt- 2007
CHAPTER 12- Inserting Video and Sound
Lesson 12.1- Inserting Videos- 2013
Lesson 12.2- Inserting Videos- 2010:2007
Lesson 12.3- Inserting Audio- 2013
Lesson 12.4- Inserting Audio- 2010:2007
Lesson 12.5- Animating Multimedia Playback
Lesson 12.6- Recording a Sound
CHAPTER 13- Using Themes
Lesson 13.1- Applying Themes
Lesson 13.2- Creating Custom Color Schemes
Lesson 13.3- Creating Custom Font Schemes
Lesson 13.4- Customizing the Slide Background
CHAPTER 14- Using Presentation Masters
Lesson 14.1- Using Slide Masters and Slide Layouts
Lesson 14.2- Using the Notes Master
Lesson 14.3- Using the Handout Master
Lesson 14.4- Saving a Presentation Template
CHAPTER 15- Setting Up the Presentation
Lesson 15.1- Setting Up the Slide Show
Lesson 15.2- Recording Narration- 2013:2010
Lesson 15.3- Recording Narration- 2007
Lesson 15.4- Rehearsing Timings
CHAPTER 16- Applying Actions
Lesson 16.1- Inserting Actions
Lesson 16.2- Inserting Hyperlinks
CHAPTER 17- Inserting Charts, Tables, and Objects
Lesson 17.1- Inserting Charts
Lesson 17.2- Inserting Tables
Lesson 17.3- Inserting Objects
CHAPTER 18- Setting PowerPoint Options
Lesson 18.1- Setting PowerPoint Options

Publisher Course Syllabus & Sample Lessons

Select any of the video lessons markedfreeto view them in a new window.

To view a sample of the instruction manual in PDF, click here: Introductory Publisher

CHAPTER 1- Getting Acquainted with Publisher
Lesson 1.1- The Publisher Environment free
Lesson 1.2- The Title Bar
Lesson 1.3- The Ribbon
Lesson 1.4- The File Tab and Backstage View free
Lesson 1.5- The Quick Access Toolbar
Lesson 1.6- Touch Mode
Lesson 1.7- The Scroll Bars
Lesson 1.8- The Page Layout View Buttons
Lesson 1.9- The Zoom Slider and Zoom Button
Lesson 1.10- The Status Bar
Lesson 1.11- The Mini Toolbar
Lesson 1.12- Keyboard Shortcuts
CHAPTER 2- Creating Basic Publications
Lesson 2.1- Creating New Publications free
Lesson 2.2- Changing the Publication Template free
Lesson 2.3- Using Business Information
Lesson 2.4- Saving Publications- 2013 Only
Lesson 2.5- Saving Publications- 2010 Only
Lesson 2.6- Closing Publications
Lesson 2.7- Opening Publications- 2013 Only
Lesson 2.8- Opening Publications- 2010 Only
Lesson 2.9- Inserting New Pages
Lesson 2.10- Deleting Pages
Lesson 2.11- Moving Pages
CHAPTER 3- Basic Skills
Lesson 3.1- Inserting Text Boxes free
Lesson 3.2- Inserting Shapes
Lesson 3.3- Adding Text to Shapes
Lesson 3.4- Inserting Your Own Pictures
Lesson 3.5- Inserting Online Pictures
Lesson 3.6- Inserting Picture Placeholders
Lesson 3.7- Using the Scratch Area
Lesson 3.8- Inserting Clip Art and Pictures
Lesson 3.9- Moving, Resizing, and Rotating Objects
Lesson 3.10- Deleting Objects
Lesson 3.11- Using Find and Replace
Lesson 3.12- Using AutoCorrect
Lesson 3.13- Inserting WordArt
CHAPTER 4- Formatting Objects
Lesson 4.1- Formatting Text free
Lesson 4.2- Formatting Shapes
Lesson 4.3- Formatting Clip Art and Pictures
CHAPTER 5- Using Building Blocks
Lesson 5.1- Creating Basic Building Blocks free
Lesson 5.2- Using Building Blocks
CHAPTER 6- Master Pages
Lesson 6.1- Using Master Pages free
CHAPTER 7- Customizing Schemes
Lesson 7.1- Creating a Custom Color Scheme free
Lesson 7.2- Creating a Custom Font Scheme
Lesson 7.3- Customizing Page Backgrounds- 2013 free
Lesson 7.4- Customizing Page Backgrounds- 2010
CHAPTER 8- Using Tables
Lesson 8.1- Creating and Deleting Tables
Lesson 8.2- Selecting Table Elements
Lesson 8.3- Inserting and Deleting Columns and Rows
Lesson 8.4- Merging Text in Table Cells
Lesson 8.5- Modifying Text in Table Cells
Lesson 8.6- Formatting Tables
CHAPTER 9- Page Setup and Layouts
Lesson 9.1- Using Page Setup
Lesson 9.2- Using Layout Guides
Lesson 9.3- Using the Rulers
CHAPTER 10- Mailings
Lesson 10.1- Mail Merge
Lesson 10.2- The Step by Step Mail Merge Wizard
Lesson 10.3- Creating a Data Source
Lesson 10.4- Selecting Recipients
Lesson 10.5- Inserting and Deleting Merge Fields
Lesson 10.6- Previewing a Merge
Lesson 10.7- Detaching the Data Source
Lesson 10.8- Finishing a Mail Merge
Lesson 10.9- Merging a Catalog
CHAPTER 11- Printing
Lesson 11.1- Previewing and Printing
Lesson 11.2- Using the Pack and Go Feature
Lesson 11.3- Sharing and Exporting Publications- 2013
Lesson 11.4- Save & Send- 2010
CHAPTER 12- Helping Yourself
Lesson 12.1- Using Publisher Help

Word Course Syllabus & Sample Lessons

Select any of the video lessons markedfreeto view them in a new window.

To view samples of the instruction manuals in PDF, click here: Introductory Word | Intermediate Word| Advanced Word

CHAPTER 1- Getting Acquainted with Word
Lesson 1.1- About Word
Lesson 1.2- The Word Environment – 2013:2010 free
Lesson 1.3- The Word Environment – 2007
Lesson 1.4- The Title Bar
Lesson 1.5- The Ribbon
Lesson 1.6- The “File” Tab and Backstage View – 2013:2010
Lesson 1.7- The Microsoft Office Button – 2007
Lesson 1.8- The Quick Access Toolbar
Lesson 1.9- Touch Mode – 2013
Lesson 1.10- The Ruler
Lesson 1.11- The Scroll Bars
Lesson 1.12- The Document View Buttons
Lesson 1.13- The Zoom Slider
Lesson 1.14- The Status Bar
Lesson 1.15- The Mini Toolbar
Lesson 1.16- Keyboard Shortcuts
CHAPTER 2- Creating Basic Documents
Lesson 2.1- Opening Documents – 2013 free
Lesson 2.2- Opening Documents – 2010
Lesson 2.3- Opening Documents – 2007
Lesson 2.4- Closing Documents
Lesson 2.5- Creating New Documents – 20013:2010
Lesson 2.6- Creating New Documents – 2007
Lesson 2.7- Saving Documents – 2013
Lesson 2.8- Saving Documents – 2010
Lesson 2.9- Saving Documents – 2007
Lesson 2.10- Recovering Unsaved Documents – 2013
Lesson 2.11- Entering Text
Lesson 2.12- Moving through Text
Lesson 2.13- Selecting Text
Lesson 2.14- Non-Printing Characters
Lesson 2.15- Managing Multiple Documents
Lesson 2.16- Working with Word File Formats
CHAPTER 3- Basic Editing Skills
Lesson 3.1- Deleting Text
Lesson 3.2- Cutting, Copying and Pasting
Lesson 3.3- Undoing and Redoing Actions
Lesson 3.4- Finding and Replacing Text
CHAPTER 4- Basic Proofing Skills
Lesson 4.1- The Spelling and Grammar Tool free
Lesson 4.2- Setting Default Proofing Options
CHAPTER 5- Font Formatting
Lesson 5.1- Formatting Fonts free
Lesson 5.2- The Font Dialog Box
Lesson 5.3- The Format Painter free
CHAPTER 6- Formatting Paragraphs
Lesson 6.1- Aligning Paragraphs free
Lesson 6.2- Indenting Paragraphs
Lesson 6.3- Line Spacing and Paragraph Spacing
CHAPTER 7- Setting Page Layout
Lesson 7.1- Setting Page and Section Breaks
Lesson 7.2- Using Headers and Footers
Lesson 7.3- Using Page Setup
CHAPTER 8- Using Templates
Lesson 8.1- Using Templates – 2013:2010
Lesson 8.2- Using Templates – 2007
CHAPTER 9- Printing Documents
Lesson 9.1- Previewing and Printing Documents – 2013:2010
Lesson 9.2- Using Print Preview – 2007
Lesson 9.3- Printing Documents – 2007
CHAPTER 10- Helping Yourself
Lesson 10.1- Using Word Help
CHAPTER 11- Working With Tabs
Lesson 11.1- Using Tab Stops
Lesson 11.2- Using the Tabs Dialog Box
CHAPTER 12- Using Clip Art
Lesson 12.1- Inserting Online Pictures – 2013 free
Lesson 12.2- Using Clip Art – 2010:2007
Lesson 12.3- Inserting Your Own Pictures
Lesson 12.4- Using Picture Tools – 2013:2010
Lesson 12.5- Using Picture Tools – 2007
Lesson 12.6- Using the Format Picture Task Pane – 2013
Lesson 12.7- Fill & Line Settings – 2013
Lesson 12.8- Effects Settings – 2013
Lesson 12.9- Layout and Properties Settings – 2013
Lesson 12.10- Picture Settings – 2013
Lesson 12.11- The Format Picture Dialog Box – 2010
Lesson 12.12- The Format Picture Dialog Box – 2007
CHAPTER 13- Drawing Objects
Lesson 13.1- Inserting Shapes
Lesson 13.2- Inserting WordArt – 2013:2010
Lesson 13.3- Inserting WordArt – 2007
Lesson 13.4- Inserting Text Boxes
Lesson 13.5- Formatting Shapes – 2013:2010
Lesson 13.6- Formatting Shapes – 2007
Lesson 13.7- The Format Shape Task Pane – 2013
Lesson 13.8- The Format Shape Dialog Box – 2010
Lesson 13.9- The Format AutoShapes Dialog Box – 2007
CHAPTER 14- Using Building Blocks
Lesson 14.1- Using Buildings Blocks
CHAPTER 15- Bullets and Numbering
Lesson 15.1- Applying Bullets and Numbering
Lesson 15.2- Formatting Bullets and Numbering
Lesson 15.3- Applying a Multilevel List
Lesson 15.4- Modifying a Multilevel List
CHAPTER 16- Tables
Lesson 16.1- Using Tables
Lesson 16.2- Creating Tables
Lesson 16.3- Selecting Table Objects
Lesson 16.4- Inserting and Deleting Columns and Rows
Lesson 16.5- Deleting Cells and Tables
Lesson 16.6- Merging and Splitting Cells
Lesson 16.7- Adjusting Cell Size
Lesson 16.8- Aligning Text in Table Cells
Lesson 16.9- Converting a Table into Text
Lesson 16.10- Sorting Tables
Lesson 16.11- Formatting Tables
Lesson 16.12- Inserting Quick Tables
CHAPTER 17- Table Formulas
Lesson 17.1- Inserting Table Formulas
Lesson 17.2- Recalculating Word Formulas
Lesson 17.3- Viewing Formulas vs. Formula Results
Lesson 17.4- Inserting a Microsoft Excel Worksheet
CHAPTER 18- Mail Merge
Lesson 18.1- Mail Merge
Lesson 18.2- The Step by Step Mail Merge Wizard free
Lesson 18.3- Creating a Data Source
Lesson 18.4- Selecting Recipients
Lesson 18.5- Inserting and Deleting Merge Fields
Lesson 18.6- Error Checking
Lesson 18.7- Detaching a Data Source
Lesson 18.8- Finishing a Mail Merge
CHAPTER 19- Creating and Table of Contents
Lesson 19.1- Creating a Table of Contents free
Lesson 19.2- Customizing a Table of Contents free
Lesson 19.3- Updating a Table of Contents
Lesson 19.4- Deleting a Table of Contents
CHAPTER 20- Creating an Index
Lesson 20.1- Creating an Index
Lesson 20.2- Customizing an Index
Lesson 20.3- Updating an Index
CHAPTER 21- Creating Forms
Lesson 21.1- Displaying the Developer Tab – 2013:2010
Lesson 21.2- Displaying the Developer Tab – 2007
Lesson 21.3- Creating a Form
Lesson 21.4- Inserting Controls
Lesson 21.5- Repeating Section Content Control – 2013
Lesson 21.6- Adding Instructional Text
Lesson 21.7- Protecting a Form
CHAPTER 22- Making Macros
Lesson 22.1- Recording Macros
Lesson 22.2- Running and Deleting Recorded Macros
Lesson 22.3- Assigning Macros – 2013:2010
Lesson 22.4- Assigning Macros – 2007
CHAPTER 23- Word Options
Lesson 23.1- Setting Word Options – 2013:2010
Lesson 23.2- Setting Word Options – 2007

Microsoft Office Training Course Overview

Microsoft Office is a powerful suite of desktop applications used by individuals and businesses the world over. Mastering Microsoft Office Made Easy brings together 7 of our most popular application tutorials. You will receive our complete training with introductory through advanced material in Microsoft Access, Excel, OneNote, Outlook, PowerPoint, Publisher, and Word. Included in this amazing package are over 42 hours of expert video training, 15 classroom instruction manuals in PDF (Introductory, Intermediate and Advanced), practice exercises and much more. This complete Microsoft Office tutorial covers the same curriculum as our classroom training and was designed to provide a solid foundation in Office.

Courses includes video lessons, printable instruction manuals, a practice exam with evaluative feedback (find out why your answers are right or wrong), your final exam submission, and a course certificate of completion- for each of the seven courses. The Microsoft Office training course also qualifies for continuing education credit for CPAs (Certified Public Accountants) in certain states.

At TeachUcomp, Inc., you choose how you want your Microsoft Office training delivered.

Online subscriptions offer the most flexibility and value. With online training, you can access your courses anytime and anywhere you have an internet connection (including all new releases and updates). Your subscription grants you instant access to ALL of our courses for one low price. There are no contracts and you can cancel at any time. You may choose between a monthly or annual plan.

Courses are also available individually via digital download or DVD-ROM for a one-time charge.

 

 

TOP