Excel Entering and Editing Data
This comprehensive hands-on course covers the core concepts essential to successful use of Microsoft Excel. Taught by professionals for professionals, this course will set you on the right path to Excel productivity. The course covers all the features of Excel in a straightforward, easy to understand manner.
2h 3m 55s | 24 Lessons | All
Module: Entering, Editing And Viewing Data
Topic: Basic Data Entry
Lesson: Entering Text And Numbers
Lesson: Editing Data in Cells
Lesson: Using Autofill
Lesson: Dates And Times Part 1
Lesson: Dates And Times Part 2
Lesson: Undo And Redo
Lesson: Comments
Lesson: Save and Save As
Topic: Viewing And Selecting Data
Lesson: View Two Workbooks At Once
Lesson: Selecting A Range Of Cells
Lesson: Smart Tags
Lesson: Enter and Copy Data Across a Range
Lesson: Selecting Adjacent And Non-Adjacent Rows And Columns
Lesson: Selecting Non-Contiguous Cell Ranges
Lesson: Autoselect A Range Of Cells
Lesson: Resizing Rows And Columns
Lesson: Using The Zoom Control
Lesson: Splitting Windows
Topic: Autofill And Autosum
Lesson: Using Autosum To Calculate Totals
Lesson: Autosum And Non-Contiguous Ranges
Lesson: Autosum and Averages
Lesson: Using Autofill For Series
Lesson: Autofill Options
Lesson: Customizing Autofill
Excel Getting Started
This comprehensive hands-on course covers the core concepts essential to successful use of Microsoft Excel. Taught by professionals for professionals, this course will set you on the right path to Excel productivity. The course covers all the features of Excel in a straightforward, easy to understand manner.
1h 48m 56s | 24 Lessons | All
Module: Getting Started with Excel
Topic: Starting Excel And Basic Operations
Lesson: Starting Excel
Lesson: Basic Window Operations
Lesson: Microsoft Office User Account
Lesson: Opening A Workbook
Lesson: Navigating a Workbook
Lesson: Saving A Workbook
Lesson: Common File Formats
Lesson: Pinning Workbooks
Lesson: File Organization
Lesson: Checking Excel Version Number
Topic: Views And Navigation
Lesson: Managing And Navigating Tabs
Lesson: Navigating The Ribbon
Lesson: Ribbon Components
Lesson: Third Party Ribbon Components
Lesson: The Quick Access Toolbar
Lesson: The Mini Toolbar
Lesson: Key Tips And Keyboard Shortcuts
Lesson: The Formula Bar
Lesson: Understanding Views
Lesson: Full Screen View
Topic: Help and Versions
Lesson: Introducing the Versions Feature
Lesson: Using The Versions Feature To Recover Unsaved Files
Lesson: Recover An Earlier Version Of A Workbook
Lesson: Using The Excel Help System
Microsoft Access Core Concepts
This hands-on Microsoft Access course will take a deep dive on the core concepts of this powerful and versatile database application. 
5h 51m 24s | 67 Lessons | Intermediate
Module: Getting Started
Topic: Introduction to Microsoft Access and Databases
Lesson: Introduction Microsoft Access 1
Lesson: Introduction Microsoft Access 2
Lesson: Relational Database Concepts
Lesson: Starting Access and the Backstage Screen
Lesson: Database Files
Lesson: Microsoft Office User Account
Lesson: The Trust Center
Lesson: Navigating the Ribbon
Lesson: Ribbon Components
Lesson: Third Party Add-Ins
Lesson: The Quick Access Toolbar
Lesson: Backups
Lesson: The Access Help System
Topic: Basic Database Operations
Lesson: Quick Start with Templates
Lesson: Downloading and Installing Templates
Lesson: Creating a Blank Desktop Database
Lesson: Security Warnings
Lesson: Saving a Database
Lesson: Opening a Database
Lesson: Closing a Database
Lesson: File and Folder Structure
Topic: Database Design and Planning
Lesson: Database Planning I
Lesson: Database Planning II
Lesson: Data Sources
Lesson: One Database or Two?
Lesson: Multiple Users
Module: Tables and Fields
Topic: Table Basics
Lesson: Table Structure and Relationships
Lesson: Creating Tables
Lesson: Entering, Editng and Deleting Data
Lesson: Primary Keys
Lesson: Foreign Keys
Lesson: Importing Tables
Lesson: Exporting Tables
Lesson: Relationships and Referential Integrity
Lesson: Editing Tables in Design View
Lesson: Input Masks
Lesson: Default Values
Lesson: Validation Rules
Topic: Field Types
Lesson: Short Text Fields
Lesson: Number Fields
Lesson: Currency Fields
Lesson: Yes & No Fields
Lesson: Lookup & Relationship Fields
Lesson: Rich Text Fields
Lesson: Long Text Fields
Lesson: Attachment Fields
Lesson: Hyperlink Fields
Lesson: Calculated Fields
Lesson: Paste as Fields
Lesson: Auto ID Fields
Topic: Creating Relationships
Lesson: Viewing Relationships
Lesson: Creating Relationships
Lesson: Editing Relationships
Lesson: Deleting Relationships
Topic: Linked Tables
Lesson: Linked Table Basics
Lesson: Linking Tables from Access Databases
Lesson: Linking Tables from Excel Worksheets
Lesson: Linking Tables from Text Files
Lesson: Linking Tables from XML Files
Lesson: Linking Tables from ODBC Databases
Lesson: Linking Tables from SharePoint Lists
Lesson: Linking Tables from HTML Documents
Lesson: Linking to a Data Service
Lesson: Linking to an Outlook Folder
Lesson: Linked Table Manager
Lesson: Saved Imports
Lesson: Broken/Reconnecting Table Links
Module: Forms (Coming Soon)
Topic: Form Basics
Topic: Form Layout Tools
Topic: Property Sheets
Topic: Form Controls
Topic: More Forms and Functions
Module: Queries (Coming Soon)
Topic: Query Basics
Topic: More Query Functions
Topic: Query Criteria
Topic: Joins
Topic: Query by Form
Module: Organization and Configuration (Coming Soon)
Topic: Organizing Records
Topic: Access Options
Module: Reports (Coming Soon)
Topic: Introduction to Report Basics
Topic: The Report Designer Window
Topic: Query and Form Based Reports
Microsoft Word Graphics and Styles
In this course, users get hands-on experience with graphics and styles in Microsoft Word. You’ll learn how to insert an image into a document and understand wrapping text in relationship to images. The course covers using shapes in documents, Microsoft WordArt and inserting watermarks. You’ll also learn about inserting and editing SmartArt diagrams, adding and removing shapes and formatting SmartArt.
0h 59m 52s | 10 Lessons | All
Module: Graphics and Styles
Topic: Working with Graphics and Smartart
Lesson: Insert an Image into a Document
Lesson: Wrapping Text and Images
Lesson: Microsoft Word Clip Art
Lesson: Using Shapes in Documents
Lesson: Microsoft WordArt
Lesson: Watermarks
Topic: SmartArt
Lesson: Add a SmartArt Diagram
Lesson: Enter Text in SmartArt Diagrams
Lesson: Add, Remove and Change Shapes
Lesson: Format SmartArt
Microsoft Word Macros
This hands-on course teaches the user how to work with macros in Microsoft Word. You’ll learn how to create and edit macros. You’ll learn how to run macros and add macro shortcuts to the ribbon and quick access toolbar (QAT). You’ll also learn how to backup and export macros, and how to import macros.
0h 48m 34s | 7 Lessons | All
Module: Macros
Topic: Creating and Using Macros
Lesson: Macros Explained
Lesson: Recording a Macro
Lesson: Running a Macro I
Lesson: Running a Macro II
Lesson: Create Macro Shortcuts on QAT and Ribbon
Lesson: Backing Up and Exporting Macros
Lesson: Importing Macros
Microsoft Reference Tools
In this course, users get hands-on experience with references in Microsoft Word. You’ll learn how to create and edit a table of contents (TOC) and work with footnotes and endnotes. You’ll get an understanding of working with citations and a bibliography; using captions; creating an index; using bookmarks and cross references; and working with master documents.
1h 4m 10s | 9 Lessons | All
Module: References
Topic: Using the References Ribbon
Lesson: Understanding the Table of Contents
Lesson: Creating a TOC
Lesson: Updating the TOC
Lesson: Footnotes and Endnotes
Lesson: Citations and Bibliography
Lesson: Using Captions
Lesson: Creating an Index
Lesson: Bookmarks and Cross References
Lesson: Master Documents
Microsoft Forms and Fields
This hands-on course introduces the user to forms and fields in Microsoft Word. You’ll get experience creating forms and protecting forms in Word. You’ll also learn how to create and insert fields into Word document; how to link and unlink fields and how to insert a video a form.
1h 24m 2s | 12 Lessons | All
Module: Forms and Fields
Topic: Creating Forms in Word
Lesson: Forms and the Developer Tab
Lesson: Creating Forms in Word I
Lesson: Creating Forms in Word II
Lesson: Creating Forms in Word III
Lesson: Protecting Forms
Lesson: Legacy Controls
Topic: About Fields
Lesson: Insert Document Property Fields
Lesson: View Field Codes
Lesson: Link Fields
Lesson: Unlink Fields
Lesson: Insert a Video Into a Form I
Lesson: Insert a Video Into a Form II
Document Reviewing Tools in Microsoft Word
In this course, users get hands-on experience reviewing documents in Microsoft Word. You’ll learn proofing for spelling and grammar; working with language and translation; adding comments; tracking changes; and comparing documents.
0h 42m 15s | 6 Lessons | All
Module: The Review Ribbon
Topic: Review Tools
Lesson: Proofing and Grammar I
Lesson: Proofing and Grammar II
Lesson: Language and Translation
Lesson: Comments
Lesson: Track Changes
Lesson: Compare Documents
Microsoft Word Mail Merge
In this course, users get hands-on experience with mail merge in Microsoft Word. You’ll learn how to mail merge labels, envelopes, form letters, and Outlook email.
0h 28m 31s | 4 Lessons | All
Module: Mailings
Topic: Mail Merges
Lesson: Mail Merge to Labels
Lesson: Mail Merge to Envelopes
Lesson: Mail Merge to Form Letters
Lesson: Mail Merge to Outlook Email
Working with Excel in Microsoft Word
In this hands-on course users will learn how to work with Microsoft Excel in conjunction with Microsoft Word.  You'll get a solid understanding of linking and embedding Excel objects; inserting an Excel spreadsheet into a Word document; editing linked and embedded objects; using formulas in Word tables; and importing Excel charts into Word.
1h 3m 33s | 8 Lessons | All
Module: Working With Excel
Topic: Working With Excel Data
Lesson: Understanding Linking and Embedding
Lesson: Embedding Excel Objects in Word
Lesson: Linking to Excel Objects in Word
Lesson: Insert New Excel Worksheet in a Word Document
Lesson: Change Linked or Embedded Excel Objects
Lesson: Prevent Updates to a Linked Excel Object
Lesson: Use Formulas in Word Tables
Lesson: Importing Excel Charts
Microsoft Word Document Sections
In this hands-on course users will learn the various components of a Word document. You’ll get hands on experience with creating text, inserting page breaks and sections breaks; and varying formatting across section breaks. The course covers creating cover pages; creating headers; and creating footers. You’ll also learn to create, edit and modify tables and how to work with columns.
1h 30m 2s | 16 Lessons | All
Module: Document Sections
Topic: Working with Document Sections
Lesson: Inserting Random Text into a Document
Lesson: Page and Section Breaks
Lesson: Vary Formatting Across Section Breaks
Lesson: Create a Cover Page
Lesson: Headers and Footers I
Lesson: Headers and Footers II
Lesson: Page Numbering I
Lesson: Page Numbering II
Topic: Tables
Lesson: Adding Tables
Lesson: Merge or Split a Cell in a Table
Lesson: Create a Nested Table
Lesson: Resize a Table
Lesson: Table Styles
Lesson: Table Borders and Shading
Topic: Columns
Lesson: Adding Columns
Lesson: Mix Column Formats in a Document
Microsoft Word 2013 Core Concepts
This comprehensive hands-on course covers the core concepts essential to successful use of Microsoft Word. Taught by professionals for professionals, this course will set you on the right path to word processing productivity with Microsoft Word. The course covers all the features of Word in a straightforward, easy to understand manner. 
5h 57m 39s | 64 Lessons | All
Module: Getting Started with Word
Topic: File and Operation Basics
Lesson: Introduction to Word and WYSIWYG Word Processing
Lesson: Starting Microsoft Word
Lesson: Basic Window Operations
Lesson: Using Word with a Windows Live Account
Lesson: Opening a Word Document
Lesson: Opening Other File Types
Lesson: Creating a Word Document
Lesson: Saving a Word Document
Lesson: Closing a Word Document
Lesson: The Word Status Bar
Lesson: Common File Formats
Lesson: File Organization
Lesson: Checking Word Version Number
Topic: The Backstage View and File Menu
Lesson: Introduction to the Back Stage View
Lesson: Opening a New Document
Lesson: New Document from Template
Lesson: Built-In Templates
Lesson: Online Templates
Lesson: Open Other Files
Lesson: Pinning Documents
Lesson: Introduction to the File Menu
Lesson: File Menu - New
Lesson: File Menu - Open
Lesson: File Menu - Close
Lesson: File Menu - Save and Save As
Lesson: File Menu - Print
Lesson: File Menu - Share
Lesson: File Menu - Export
Lesson: File Menu - Account
Lesson: File Menu - Info
Topic: Word Options and Settings
Lesson: Introduction to Word Options and Settings
Lesson: General Word Options
Lesson: Proofing Options
Lesson: Save Options
Lesson: Display Options
Lesson: Language Options
Lesson: Advanced Options I
Lesson: Advanced Options II
Lesson: Add-Ins
Lesson: Trust Center
Topic: The Ribbon Bar
Lesson: Introduction to the Word Ribbon Bar
Lesson: Ribbon Components
Lesson: Third-Party Ribbon Components
Lesson: The Home Tab
Lesson: The Insert Tab
Lesson: The Design Tab
Lesson: The Page Layout Tab
Lesson: The References Tab
Lesson: The Mailings Tab
Lesson: The Review Tab
Lesson: The View Tab
Lesson: The Developer Tab
Lesson: The Format Tab
Lesson: Customizing the Ribbon
Lesson: Resetting the Ribbon
Topic: The Quick Access Toolbar
Lesson: Quick Access Toolbar (QAT) Basics
Lesson: Adding Commands to the QAT
Lesson: Customizing the QAT
Lesson: Reset the QAT
Topic: Help and Versions
Lesson: Introducing the Versions Feature
Lesson: Using The Versions Feature To Recover Unsaved Files
Lesson: Recover An Earlier Version Of A Document
Lesson: Change Unsaved Files Folder Location
Lesson: Introduction to Word Help System
Module: Formatting Word Documents (Coming Soon)
Module: Editing Documents (Coming Soon)
Module: Working with Tables (Coming Soon)
Module: Working with Images (Coming Soon)
Module: Page Layout (Coming Soon)
Excel 2013 Core Concepts
This comprehensive hands-on course covers the core concepts essential to successful use of Microsoft Excel. Taught by professionals for professionals, this course will set you on the right path to Excel productivity. The course covers all the features of Excel in a straightforward, easy to understand manner.
3h 52m 51s | 48 Lessons | All
Module: Getting Started with Excel
Topic: Starting Excel And Basic Operations
Lesson: Starting Excel
Lesson: Basic Window Operations
Lesson: Microsoft Office User Account
Lesson: Opening A Workbook
Lesson: Navigating a Workbook
Lesson: Saving A Workbook
Lesson: Common File Formats
Lesson: Pinning Workbooks
Lesson: File Organization
Lesson: Checking Excel Version Number
Topic: Views And Navigation
Lesson: Managing And Navigating Tabs
Lesson: Navigating The Ribbon
Lesson: Ribbon Components
Lesson: Third Party Ribbon Components
Lesson: The Quick Access Toolbar
Lesson: The Mini Toolbar
Lesson: Key Tips And Keyboard Shortcuts
Lesson: The Formula Bar
Lesson: Understanding Views
Lesson: Full Screen View
Topic: Help and Versions
Lesson: Introducing the Versions Feature
Lesson: Using The Versions Feature To Recover Unsaved Files
Lesson: Recover An Earlier Version Of A Workbook
Lesson: Using The Excel Help System
Module: Entering, Editing And Viewing Data
Topic: Basic Data Entry
Lesson: Entering Text And Numbers
Lesson: Editing Data in Cells
Lesson: Using Autofill
Lesson: Dates And Times Part 1
Lesson: Dates And Times Part 2
Lesson: Undo And Redo
Lesson: Comments
Lesson: Save and Save As
Topic: Viewing And Selecting Data
Lesson: View Two Workbooks At Once
Lesson: Selecting A Range Of Cells
Lesson: Smart Tags
Lesson: Enter and Copy Data Across a Range
Lesson: Selecting Adjacent And Non-Adjacent Rows And Columns
Lesson: Selecting Non-Contiguous Cell Ranges
Lesson: Autoselect A Range Of Cells
Lesson: Resizing Rows And Columns
Lesson: Using The Zoom Control
Lesson: Splitting Windows
Topic: Autofill And Autosum
Lesson: Using Autosum To Calculate Totals
Lesson: Autosum And Non-Contiguous Ranges
Lesson: Autosum and Averages
Lesson: Using Autofill For Series
Lesson: Autofill Options
Lesson: Customizing Autofill
Microsoft Access Core Concepts
This hands-on Microsoft Access course will take a deep dive on the core concepts of this powerful and versatile database application. 
5h 51m 24s | 67 Lessons | Intermediate
Module: Getting Started
Topic: Introduction to Microsoft Access and Databases
Lesson: Introduction Microsoft Access 1
Lesson: Introduction Microsoft Access 2
Lesson: Relational Database Concepts
Lesson: Starting Access and the Backstage Screen
Lesson: Database Files
Lesson: Microsoft Office User Account
Lesson: The Trust Center
Lesson: Navigating the Ribbon
Lesson: Ribbon Components
Lesson: Third Party Add-Ins
Lesson: The Quick Access Toolbar
Lesson: Backups
Lesson: The Access Help System
Topic: Basic Database Operations
Lesson: Quick Start with Templates
Lesson: Downloading and Installing Templates
Lesson: Creating a Blank Desktop Database
Lesson: Security Warnings
Lesson: Saving a Database
Lesson: Opening a Database
Lesson: Closing a Database
Lesson: File and Folder Structure
Topic: Database Design and Planning
Lesson: Database Planning I
Lesson: Database Planning II
Lesson: Data Sources
Lesson: One Database or Two?
Lesson: Multiple Users
Module: Tables and Fields
Topic: Table Basics
Lesson: Table Structure and Relationships
Lesson: Creating Tables
Lesson: Entering, Editng and Deleting Data
Lesson: Primary Keys
Lesson: Foreign Keys
Lesson: Importing Tables
Lesson: Exporting Tables
Lesson: Relationships and Referential Integrity
Lesson: Editing Tables in Design View
Lesson: Input Masks
Lesson: Default Values
Lesson: Validation Rules
Topic: Field Types
Lesson: Short Text Fields
Lesson: Number Fields
Lesson: Currency Fields
Lesson: Yes & No Fields
Lesson: Lookup & Relationship Fields
Lesson: Rich Text Fields
Lesson: Long Text Fields
Lesson: Attachment Fields
Lesson: Hyperlink Fields
Lesson: Calculated Fields
Lesson: Paste as Fields
Lesson: Auto ID Fields
Topic: Creating Relationships
Lesson: Viewing Relationships
Lesson: Creating Relationships
Lesson: Editing Relationships
Lesson: Deleting Relationships
Topic: Linked Tables
Lesson: Linked Table Basics
Lesson: Linking Tables from Access Databases
Lesson: Linking Tables from Excel Worksheets
Lesson: Linking Tables from Text Files
Lesson: Linking Tables from XML Files
Lesson: Linking Tables from ODBC Databases
Lesson: Linking Tables from SharePoint Lists
Lesson: Linking Tables from HTML Documents
Lesson: Linking to a Data Service
Lesson: Linking to an Outlook Folder
Lesson: Linked Table Manager
Lesson: Saved Imports
Lesson: Broken/Reconnecting Table Links
Module: Forms (Coming Soon)
Topic: Form Basics
Topic: Form Layout Tools
Topic: Property Sheets
Topic: Form Controls
Topic: More Forms and Functions
Module: Queries (Coming Soon)
Topic: Query Basics
Topic: More Query Functions
Topic: Query Criteria
Topic: Joins
Topic: Query by Form
Module: Organization and Configuration (Coming Soon)
Topic: Organizing Records
Topic: Access Options
Module: Reports (Coming Soon)
Topic: Introduction to Report Basics
Topic: The Report Designer Window
Topic: Query and Form Based Reports