Mastering Microsoft Office 2010 Training Tutorial

Learn Introductory through Advanced material in Access, Excel, OneNote, Outlook, PowerPoint, Publisher, Windows and Word

3.90 (10 reviews)
Udemy
platform
English
language
Microsoft
category
Mastering Microsoft Office 2010 Training Tutorial
131
students
60 hours
content
Jun 2013
last update
$19.99
regular price

What you will learn

Video Lessons

Includes 16 Classroom Instruction Manuals

Access

Excel

OneNote

Outlook

PowerPoint

Publisher

Windows

Word

Description

Learn Microsoft Office 2010 and Windows 8 with this comprehensive course from TeachUcomp, Inc. Mastering Microsoft Office Made Easy features 688 video lessons with over 60 hours of introductory through advanced instruction. You get our EIGHT complete courses in Access, Excel, OneNote, Outlook, PowerPoint, Publisher, Windows 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 16 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 trainings 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 a video lesson or open one of the manuals and you’re on your way to mastering Office. Each individual application course is listed alphabetically.

  • The ACCESS curriculum begins at Section 1
  • The EXCEL curriculum begins at Section 22
  • The ONENOTE curriculum begins at Section 53
  • The OUTLOOK curriculum begins at Section 70
  • The POWERPOINT curriculum begins at Section 87
  • The PUBLISHER curriculum begins at Section 107
  • The WINDOWS curriculum begins at Section 121
  • The WORD curriculum begins at Section 133

Each curriculum includes 1, 2 or 3 classroom instruction manuals in PDF (Introductory, Intermediate, Advanced). You will find the manuals at the END of each application curriculum.

Content

Getting Acquainted with Access

The Access Interface
Overview of a Database
Working with Database Objects
Opening and Closing Databases
Database Objects

Creating Relational Database Tables

Creating New Databases
Flow Overview of a Database
The "Flat-File" Model of Data Storage
The Relational Model of Data Storage
Tips for Creating a Relational Database
Creating Relational Database Tables
Assigning a Primary Key to a Table

Using Tables

Using Datasheet View
Navigating in Datasheet View
Adding Records in Database View
Editing and Deleting Records in Datasheet View
Inserting New Fields
Renaming Fields
Deleting Fields

Field Properties

Setting Field Properties
The 'Field Size' Property
The 'Format' Property for Date/Time Fields
The 'Format' Property for Logical Fields
Setting Default Values for Fields
Setting Input Masks
Setting Up Validation Rules and Responses
Requiring Field Input
Allowing Zero Length Entries

Joining Tables

The Relationships Window
Enforcing Referential Integrity
Creating Lookup Fields

Indexing Tables

Indexes
Creating Indexes
Deleting Indexes

Queries

Using the Simple Query Wizard
Designing Queries
Joining Tables in a Query
Adding Criteria to the QBE Grid
Running A Query
How is Using the QBE Grid Writing SQL Code?
Sorting Query Results
Hiding Fields in a Query
Using Comparison Operators
Using 'AND' and 'OR' Conditions

Advanced Queries

Using the 'BETWEEN...AND' Condition
Using Wildcard Characters in Criteria
Creating a Calculated Field
Creating 'Top Value' Queries
Function Queries
Parameter Queries

Advanced Query Types

Make-Table Queries
Update Queries
Append Queries
Delete Queries
Crosstab Queries
The 'Find Duplicates' Query
The 'Find Unmatched' Query

Creating Forms

Forms Overview
The Form Wizard
Creating Forms
Using Forms
Form and Report Layout View
Form and Report Design View
Viewing the Ruler and Grid
The "Snap to Grid" Feature
Creating a Form in Design View

Form and Report Controls

Selecting Controls
Deleting Controls
Moving and Resizing Controls
Sizing Controls 'To Fit'
'Nudging' Controls
Aligning, Spacing and Sizing Controls
Formatting Controls
Viewing Control Properties

Using Controls

The Controls Group
Adding Label Controls
Adding Logos and Image Controls
Adding Line and Rectangle Controls
Adding Combo Box Controls
Adding List Box Controls
Setting Tab Order

Subforms

Creating Subforms
Using the Subform/Subreport Control

Reports

Using the Report Wizards
Using Basic Reports
Creating a Report in Design View
Sorting and Grouping Data in Reports
Creating Calculated Fields

Subreports

Creating Subreports

Charting Data

Using Charts

Macros

Creating a Standalone Macro
Macro Actions
Using Program Flow with Macros
Creating Autoexec Macros
Creating Data Macros

Switchboard and Navigation Forms

Creating a Switchboard Form
Creating a Navigation Form
Controling Startup Behavior

Advanced Features

Getting External Data
Exporting Data
Setting a Database Password
Using Help

Instruction Manuals

Introductory Access Manual
Intermediate Access Manual
Advanced Access Manual

Getting Acquainted with Excel

About Excel
The Excel Environment
The Title Bar
The Ribbon
The "File" Tab and Backstage View
Scroll Bars
The Quick Access Toolbar
The Formula Bar
The Workbook Window
The Status Bar
The Workbook View Buttons
The Zoom Slider
The Mini Toolbar
Keyboard Shortcuts

Creating Basic Workbooks

Creating New Workbooks
Saving Workbooks
Closing Workbooks
Opening Workbooks
Selecting Cells
Entering Text Into Cells
Entering Numbers Into Cells
AutoComplete
Pick From Drop-Down List
Using the "Window" Command Group
Switching to Full Screen View
Working with Excel File Formats

Using Ranges

Selecting Ranges
Ranged Data Entry
Using AutoFill

Creating Formulas

Ranged Formula Syntax
Simple Formual Syntax
Writing Formulas
Using AutoSum
Inserting Functions
Editing a Range
Formula and AutoCorrect
AutoCalculate

Copying and Pasting Formulas

Absolute References and Relative References
Cutting, Copying and Pasting
AutoFilling Cells
The Undo Button
The Redo Button

Columns and Rows

Selecting Columns and Rows
Adjusting Column Width and Row Height
Hiding/Unhiding Columns and Rows
Inserting and Deleting Columns and Rows

Formatting Worksheets

Formatting Cells
The Format Cells Dialog Box
Clearing All Formatting from Cells
Copying All Formatting from Cells to Another Area

Worksheet Tools

Moving Between Worksheets
Selecting Multiple Worksheets
Inserting and Deleting Worksheets
Renaming Worksheets
Coloring Worksheet Tabs
Copying or Moving Worksheets

Setting Worksheet Layout

Using Page Break Preview
Using the Page Layout View
The Page Setup Dialog Box

Printing Worksheets

Previewing and Printing Worksheets - 2010

Helping Yourself

Using Excel Help

3D Formulas

Creating 3D Formulas
3D Formula Syntax
Creating 3D Range Preferences

Named Ranges

Naming Ranges
Creating Names from Headings
Moving to a Named Range
Using Named Ranges in Formulas
Naming 3D Ranges
Managing Named Ranges

Conditional Formatting and Cell Styles

Conditional Formatting
Finding Cells with Conditional Formatting
Clearing Conditional Formatting
Using Table and Cell Styles

Paste Special

Using Paste Special
Pasting Linked Formulas

Sharing Workbooks

Sharing Workbooks
Highlighting Changes
Reviewing Changes
Using Comments
Compare and Merge Workbooks

Auditing Worksheets

Auditing Worksheets
Tracing Precedent and Dependent Cells
Tracing Errors
Error Checking
Using the Watch Window
Cell Validation

Outlining Worksheets

Using Outlines
Applying and Removing Outlines

Consolidating Worksheets

Consolidating Data

Creating Worksheet Charts

Creating Charts
Selecting Charts and Chart Elements
Moving and Resizing Charts
Changing the Chart Type
Changing the Data Range
Switching Column and Row Data
Choosing a Chart Layout
Choosing a Chart Style
Printing Charts
Deleting Charts

Editing and Formatting Charts

Formatting Chart Objects
Inserting Objects into a Chart
Changing Chart Labels
Changing Axes Display
Changing the Chart Background
Applying Chart Analysis Lines
Naming Charts
Applying Shape Styles to Chart Elements
Applying WordArt Styles to Chart Elements
Saving Custom Chart Templates

PivotTables

Creating PivotTables and PivotCharts
Manipulating a PivotTable
Changing Calculated Value Fields
Applying PivotTable Styles
Creating a PivotChart
Setting PivotTable Options
Sorting and Filtering PivotTable Data

Tables

Creating a Table
Adding and Editing Records
Inserting Records and Fields
Deleting Records and Fields

Sorting Data

Sorting Data
Custom Sort Orders

Filtering Data

Using AutoFilters
Using the Top 10 AutoFilter
Applying a Custom AutoFilter
Creating Advanced Filters
Applying Multiple Criteria
Using Complex Criteria
Copying Filtered Results to a New Location
Using Database Functions

Using What-If Analysis

Using Data Tables
Using Scenario Manager
Using Goal Seek

Table-Related Functions

The Hlookup and Vlookup Functions
Using the IF, AND, and OR Functions

Security Features

Unlocking Cells
Worksheet Protection
Workbook Protection
Password Protecting Excel Files

Making Macros

Recording Macros
Running and Deleting Recorded Macros
The Personal Macro Workbook

Instruction Manuals

Introductory Excel Manual
Intermediate Excel Manual
Advanced Excel Manual

Getting Acquainted with OneNote

The OneNote Environment
The Title Bar
The Ribbon
The "File" Tab and Backstage View
The Quick Access Toolbar
The Scroll Bars
The Mini Toolbar
The Default "Personal" Notebook

Getting Started

Opening, Saving and Closing Notebooks
Creating New Notebooks
Creating, Moving and Deleting Sections and Pages
Creating, Moving and Deleting Subpages

Notes

Creating a Basic Note
Unfiled Notes
Copying and Pasting Content
Screen Clippings
Adding Pictures
Adding Audio and Video Files
Recording Audio and Video Files
Adding Other Types of Files
Adding Mathematical Equations
Quick Filing - Sending Information to OneNote

Formatting Notes

Basic Text Formatting
Bullets and Numbering
Checking Spelling
Setting Default Proofing Options

Working with Microsoft Outlook

Inserting Outlook Meetings
Sending Notebook Pages via Microsoft Outlook
Working with Microsoft Outlook Tasks

Tables

Creating a Table
Working with Columns and Rows
Formatting Tables and Table Data
Moving Tables and Table Data

Writing Tools

Pen Mode
Formatting Written Notes and Drawings
Converting Handwriting to Type

Viewing and Organizing Information

Organizing the OneNote Interface
Creating New Windows
Searching Content in a Notebook
Wiki Linking
Tagging Notes
Working with Sections
Section Groups

Stationery and Templates

Applying Templates and Stationery
Custom Templates
Choosing a Default Template

Formatting Pages

Defining Paper Size and Margins
Formatting Page Backgrounds
Adding a Background Graphic

Printing

Previewing and Printing

Sharing Notebooks and Collaborating

Saving Notebooks to Share
Creating a Shared Notebook
Inviting Others to Share
Synching Notebooks
Sending Pages in Various Formats
Sharing Notebooks with SkyDrive
Author Indicators
Finding Newly Added Content with Highlighting
Page Versions

Researching with OneNote

Linked Notes
The Research Pane
Translating Text with the Mini Translator

Changing OneNote Options

Changing Display Options
Changing Other Options

Helping Yourself

Using OneNote Help

Instruction Manual

Introductory OneNote Manual

Getting Acquainted with Outlook

The Outlook Environment
The Title Bar
The Ribbon
The Quick Access Toolbar
The Navigation Pane, Reading Pane and To-Do Bar

Making Contacts

The Contacts Folder
Customizing the Contacts Folder View
Creating Contacts
Basic Contact Management
Printing Contacts
Creating Distribution Lists
Categorizing Contacts
Searching for Contacts
Calling Contacts
Mapping a Contact's Address

E-Mail

Using the Inbox
Changing the Inbox View
Message Flags
Searching for Messages
Creating, Addressing, and Sending Messages
Checking Message Spelling
Setting Message Options
Formatting Messages
Using Signatures
Replying to Messages
Forwarding Messages
Sending Attachments
Opening Attachments

The Sent Items Folder

The Sent Items Folder
Resending Messages
Recalling Messages

The Outbox Folder

Using the Outbox

Using the Calendar

The Calendar Window
Switching the Calendar View
Navigating the Calendar
Appointments, Meetings and Events
Manipulating Calendar Objects
Setting an Appointment
Scheduling a Meeting
Checking Meeting Attendance Status
Responding to Meeting Requests
Scheduling an Event
Setting Recurrence
Printing the Calendar

Tasks

Using Tasks
Printing the Tasks
Creating a Task
Setting Task Recurrence
Creating a Task Request
Responding To Task Requests
Sending Status Reports
Deleting Tasks

Deleted Items

The Deleted Items Folder
Permanently Deleting Items
Recovering Deleted Items

The Journal Folder

The Journal Folder
Switching the Journal View
Recording Journal Items Automatically
Recording Journal Items Manually
Opening a Journal Entry
Opening the Journal Entry Document
Deleting Journal Entries

Public Folders

Creating Public Folders
Setting Permissions
Administering Public Folders
Folder Rules
Copying Public Folders

Personal and Private Folders

Creating a Personal Folder
Setting AutoArchiving for Folders
Creating Private Folders

Notes

Creating and Using Notes

Advanced Mailbox Options

Creating Mailbox Rules
Creating Custom Mailbox Views
Handling Junk Mail
Color Categorizing
Advanced Find

Outlook Options

Using Shortcuts
Adding Additional Profiles
Adding Additional Services
Outlook Options
Using Outlook Help

Delegates

Creating a Delegate
Acting as a Delegate
Deleting Delegates

Instruction Manuals

Introductory Outlook Manual
Advanced Outlook Manual

Getting Acquainted with PowerPoint

The PowerPoint Environment
The Title Bar
The Ribbon
The “File” Tab and Backstage View
The Quick Access Toolbar
The Scroll Bars
The Presentation View Buttons
The Zoom Slider
The Status Bar
The Mini Toolbar
Keyboard Shortcuts

Creating Basic Presentations

Opening Presentations
Closing Presentations
Creating New Presentations
Saving Presentations
Inserting New Slides
Applying Slide Layouts
Using the “Save and Send” Features
Working with PowerPoint File Formats

Using Presentation Views

Normal View
Slide Sorter View
Notes Page View
Slide Show View
Reading View

Using Text

Adding Text to Slides
Basic Object Manipulation
Font Formatting
Paragraph Formatting
Applying Custom Bullets and Numbering
Using Tabs
Setting Text Box Options
Checking Spelling

Using Clip Art

Inserting Clip Art and Pictures
Basic Graphic Manipulation
Using Picture Tools
The Format Picture Dialog Box

Using SmartArt

Inserting and Manipulating SmartArt
Formatting SmartArt

Using Slide Show View

Running a Slide Show
Using Custom Shows

Printing Your Presentation

Using Page Setup
Setting the Slide Header and Footer
Previewing and Printing Presentations

Helping Yourself

Using PowerPoint Help

Applying Animation

Adding Slide Transition Animation
Adding Object Animation

Drawing Objects

Inserting Shapes
Formatting Shapes
Inserting WordArt

Inserting Video and Sound

Inserting Videos
Inserting Audio
Animating Multimedia Playback
Recording a Sound

Using Themes

Applying Themes
Customizing Themes
Formatting the Slide Background

Using Presentation Masters

Using Slide Masters and Slide Layouts
Using the Notes Master
Using the Handout Master
Saving a Presentation Template

Setting Up the Presentation

Setting Up the Slide Show
Recording Narration
Rehearsing Timings

Applying Actions

Inserting Actions
Inserting Hyperlinks

Inserting Charts, Tables, and Objects

Inserting Charts
Inserting Tables
Inserting Objects

Setting PowerPoint Options

Setting PowerPoint Options

Instruction Manuals

Introductory PowerPoint Manual
Advanced PowerPoint Manual

Getting Acquainted With Publisher

The Publisher Environment
The Title Bar
The Ribbon
The "File" Tab and Backstage View
The Quick Access Toolbar
The Scroll Bars
The Page Layout View Buttons
The Zoom Slider and Zoom Button Group
The Status Bar
The Mini Toolbar
Keyboard Shortcuts

Creating Basic Publications

Creating New Publications
Using Business Information
Saving Publications
Closing Publications
Opening Publications
Inserting New Pages
Deleting Pages
Moving Pages

Basic Skills

Inserting Text Boxes
Inserting Shapes
Adding Text to Shapes
Inserting Clip Art and Pictures
Moving, Resizing and Rotating Objects
Deleting Objects
Using Find and Replace
Using AutoCorrect
Inserting WordArt

Formatting Objects

Formatting Text
Formatting Shapes
Formatting Clip Art and Pictures

Using Building Blocks

Using Building Blocks

Master Pages

Using Master Pages

Customizing Schemes

Creating a Color Scheme
Creating a Custom Font Scheme
Customizing Page Backgrounds

Using Tables

Creating and Deleting Tables
Selecting Table Elements
Inserting and Deleting Columns and Rows
Merging and Splitting Cells
Modifying Text in Table Cells
Formatting Tables

Page Setup and Layouts

Using Page Setup
Using Layout Guides
Using the Rulers

Mailings

Mail Merge
The Step By Step Mail Merge Wizard
Creating a Data Source
Selecting Recipients
Inserting and Deleting Merge Fields
Previewing a Merge
Detaching the Data Source
Finishing a Mail Merge
Merging a Catalog

Printing

Previewing and Printing
Commercial Printing
Save and Send

Helping Yourself

Using Publisher Help

Instruction Manual

Introductory Publisher Manual

Introduction to Windows

About Windows
The Start Screen in Windows 8
Customizing the Start Screen
Using the Charm Bar in Windows 8
The Windows Desktop
The Mouse
Touch Gestures in Windows 8
App Snapping in Windows 8
Using a Microsoft User Account
Starting a Program in Windows 7 & Vista
Resizing a Desktop Window
Scrolling a Window
Shutting Down Windows

Windows Explorer

Windows Explorer in Windows 8
Navigating Folders
Changing Folder Views
Sorting Folder Contents
Selecting Files
Opening a File
Opening a Recently Accessed File or Folder
Creating a New Folder
Renaming Files and Folders
Cutting, Copying and Pasting Files and Folders
Burning a CD or DVD
Deleting Files
Managing Libraries in Windows 8
Managing the Computer and Disks in Windows 8

Windows 8 Settings

Accessing Settings
Personalizing Windows
Managing Users
Notifications
Managing Search Settings
Managing Sharing Settings
General Settings
Privacy Settings
Managing Devices
Wireless Options
Ease of Access Settings
Sync Settings
HomeGroup Settings
Windows Updates
File History

Control Panel Settings

The Control Panel
Personalizing the Desktop
Changing Screen Resolution
Backup and Restore in Windows 7
System Restore
Creating Users in Windows 7 & Vista
Audio Adjustment
Adding Devices and Printers
Installing and Uninstalling New Software

Windows Management

Searching for a File or Folder in Windows 7 and Vista
The Recycle Bin
Creating Desktop Shortcuts
Pinning Items to the Taskbar or the Quick Launch Toolbar
Windows Help
Moving and Resizing the Windows Taskbar
Setting the Date and Time Display
Windows Updates

Using Apps in Windows 8

Downloading Apps from the Windows Store
Managing App Files
Using SkyDrive

Creating Documents

Starting WordPad
Editing Text
Formatting Text
Saving a Document
Opening a Document
Printing a Document
Closing a Document

Drawing Pictures

Starting Paint
Drawing Shapes and Lines
Adding Text
Erasing Parts of a Picture
Saving a Picture
Opening a Picture

Using the Internet

About the Internet
Using the Desktop Internet Explorer 10
Using the Internet Explorer 10 App
Connecting to the Internet
Windows Defender in Windows 8

Printing Information

Selecting a Printer
General Printing Options
Managing Print Jobs

Instruction Manual

Introductory Windows Manual

Getting Acquainted with Word

About Word
The Word Environment
The Title Bar
The Ribbon
The “File” Tab and Backstage View
The Quick Access Toolbar
The Ruler
The Scroll Bars
The Document View Buttons
The Zoom Slider
The Status Bar
The Mini Toolbar
Keyboard Shortcuts

Creating Basic Documents

Opening Documents
Closing Documents
Creating New Documents
Saving Documents
Entering Text
Moving through Text
Selecting Text
Non-Printing Characters
Managing Multiple Documents
Working with Word File Formats

Basic Editing Skills

Deleting Text
Cutting, Copying, and Pasting
Undoing and Redoing Actions
Finding and Replacing Text

Basic Proofing Tools

The Spelling and Grammar Tool
Setting Default Proofing Options

Font Formatting

Formatting Fonts
The Font Dialog Box
The Format Painter

Formatting Paragraphs

Aligning Paragraphs
Indenting Paragraphs
Line Spacing and Paragraph Spacing

Setting Page Layout

Setting Page and Section Breaks
Using Headers and Footers
Using Page Setup

Using Templates

Using Templates

Printing Documents

Previewing and Printing Documents

Helping Yourself

Using Word Help

Working with Tabs

Using Tab Stops
Using the Tabs Dialog Box

Using Clip Art

Using Clip Art
Inserting Your Own Pictures
Using Picture Tools
The Format Picture Dialog Box

Drawing Objects

Inserting Shapes
Inserting WordArt
Inserting Text Boxes
Formatting Shapes
The Format Shape Dialog Box

Using Building Blocks

Using Building Blocks

Bullets and Numbering

Applying Bullets and Numbering
Formatting Bullets and Numbering

Tables

Using Tables
Creating Tables
Selecting Table Objects
Inserting and Deleting Columns and Rows
Deleting Cells and Tables
Merging and Splitting Cells
Adjusting Cell Size
Aligning Text in Table Cells
Converting a Table into Text
Sorting Tables
Formatting Tables

Table Formulas

Inserting Table Formulas
Recalculating Word Formulas
Viewing Formulas Vs. Formula Results

Mailings

Mail Merge
The Step by Step Mail Merge Wizard
Creating a Data Source
Selecting Recipients
Inserting and Deleting Merge Fields
Error Checking
Detaching the Data Source
Finishing a Mail Merge

Creating a Table of Contents

Creating a Table of Contents
Customizing a Table of Contents
Updating a Table of Contents

Creating an Index

Creating an Index
Customizing an Index
Updating an Index

Creating Forms

Displaying the Developer Tab
Creating a Form
Inserting Controls
Adding Instructional Text
Protecting a Form

Making Macros

Recording Macros
Running and Deleting Recorded Macros
Assigning Macros

Word Options

Setting Word Options

Instruction Manuals

Introductory Word Manual
Intermediate Word Manual
Advanced Word Manual

Reviews

David
May 17, 2016
Missing at least 25% of course... Stops at PowerPoint... The Maker has not shown any sign of fixing it. I did contact Udemy...
Mark
February 21, 2016
Good basic coverage of the Office programs however if you leave partway through, finding where you were at can be difficult. Also if your priorities are to do One program out of order from that set it is difficult to find each separate program start point.

Charts

Price

Mastering Microsoft Office 2010 Training Tutorial - Price chart

Rating

Mastering Microsoft Office 2010 Training Tutorial - Ratings chart

Enrollment distribution

Mastering Microsoft Office 2010 Training Tutorial - Distribution chart
37715
udemy ID
1/23/2013
course created date
11/7/2020
course indexed date
Bot
course submited by