Learn Microsoft Excel 2010 Beginner Course
Introduction and Overview of Excel 2010 Course
Essential Information for a Successful Training Experience
Overview of the Excel Window
Working with the Mouse
Excel Options
Entering Text and Numbers
Creating Basic Formulas
Relative References
Order of Operations
Working withe Ranges
Working with Save and Save As Commands
File Extensions
Opening a File
Working with Larger Files
Freeze Panes Options
Split Screen Option
Page Setup Options
Headers and Footers
Print Titles
Comments
Fit to Print on One Page
Printing Workbooks
Adding and Deleting Rows, Columns, and Cells
Changing Column and Row Widths
Cut, Copy and Paste
Copying Formulas
Overview of Formulas
Create Formulas using Functions - Part 1
Create Formulas using Functions - Part 2
Absolute Values
Adding, Deleting and Renaming Sheets
Additional Sheet Tab Options
3-D Formulas
Cell Formatting
Number Formatting
Borders and Shading
Format as Table
Using Styles
Using Format Painter
Protecting Sheets
Fill Handle and Custom Lists
Creating Charts
Types of Charts
Editing Charts
Using Graphics to Enhance Charts
Creating Range Names
Managing Names
Using Names in Formulas
Removing Duplicates
Sort Data
Filter Data
Advanced Filters
Creating an Outline - Part 1
Creating an Outline - Part 2
Subtotals
New Window Option
Arrange File Options
Creating a Workspace
Custom Views
Scenarios
Creating Formulas Between Files
Working with Links
IF Statement
VLookups
Consolidating Data
Data Validation
Formula Auditing
Comments
Goal Seeker
Text to Columns Option
Watch Window
Closing Video
Excel 2010 Quiz
Learn Microsoft Excel 2010 Advanced Course
Introduction to Advanced Excel 2010
Essential Information for a Successful Training Experience
Four Basic Steps When Creating Charts/Graphs
Additional Features to Help Create Charts/Graphs
Additional Features to Help Create Charts/Graphs Part 2
Detailed Formatting for Charts/Graphs
Formatting Legends within Charts/Graphs
Formatting Axes and Gridlines within Charts/Graphs
Trends within Charts and Graphs
Complex Trends within Charts and Graphs
Trends over Time within Charts and Graphs
Showing Differences Using Bar Charts
Showing Differences Using Pie Charts
Limitations with Pie Charts & How to Correct
Alternative Ways to Show Differences
Using Charts & Graphs to Show Relationships
Using Charts & Graphs to Show Relationships Part 2
Charting & Graphing Financial Information
Charting & Graphing Financial Information Part 2
Specific Charts for Finance Information
Setting Up Live Charts
Using Sparklines for Data Visualization
Using and Formatting Data Bars, Color Scales & Icon Sets
Setting Up Pivot Tables/Charts
Setting Up Pivot Tables/Charts Part 2
Filtering Pivot Tables/Charts
New Features for Pivot Tables/Charts
Graphics Tools
Graphics Tools Part 2
Exporting Charts and Graphs
Exporting Charts and Graphs Part 2
Excel 2010 Advanced Quiz
Learn Microsoft Word 2010
Getting Started in Word 2010
Essential Information for a Successful Training Experience
Learning the Workspace
Learning the Workspace Part 2
Create New Document, Using Templates, and Page Setup
Converting and Saving Documents
Selecting Text; Cut, Copy, Paste; Drag & Drop
Insert/Overtype; Navigation Pane; Find & Replace
Hyphenation, Auto-Correct, and Redo
Text Formatting
Paragraph Formatting Options
Formatting with Bullets, Indents, Borders, Shading
Creating/Saving New Template; Changing Styles
Managing, Modifying and Deleting New Styles
Working with/Using Themes
Inserting/Formatting ClipArt, Pictures
Using Picture Tools & New Features
Inserting Screenshots, Using WordArt
Using SmartArt, SmartArt Tools
Inserting Tables; Adding Text; Selecting Parts of Tables
Formatting Tables; Table Tools
Inserting Charts; Chart Tools
Creating Charts with Pre-existing Data
Desktop Publishing Adding Drop Caps, Watermarks, Borders, Page Colors
Using/Formatting Multi-Columns; Text Boxes
Inserting/Resizing Shapes
Stacking, Grouping Objects
Creating Outline, Sub-Documents
Expand/Collapse Sections; Document Properties; Cover Pages
Add Table of Contents: Header & Footer Tools; Quick Parts
Line-numbering, Adding Bibliography & Index
Understanding Formatting Marks; Sections Features
Inserting Symbols, Equations, Auto-Text, Building Blocks
Inserting Footnotes, Bookmarks, Cross-references
Setting up Mail Merge Using Wizard
Manual Mail Merge Set-up
Spelling/Grammar Check
Using Thesaurus, Research Option, Translate; Printing Document
Publishing to Web Publishing & Accessing Word Documents on Web
Using Document Inspector, Password Protect, Editing Restrictions
Reviewing & Sharing Reviewing, Sharing and Leaving/Adding Comments
Customizing Word Customizing with Word Options
Expanding Word Functionality; Using Macros
Importing/Exporting, Embedding Document to Other Programs
Check for Updates, Safe Mode
Word 2010 Quiz
Learn Microsoft Outlook 2010
Getting Started
Essential Information for a Successful Training Experience
Course Review
Overview of Calendar, Appointments, Contacts, Tasks, Notes
Adding New Accounts, Removing Accounts
Add Items, To-Do Options and Customization
Creating New Task, Modifying Details, Recurring Tasks
Calendar Displays, Set Up/Edit/Delete Appointments
Using Help Options; Add/Edit/Delete Contacts
Create, Edit, Forward Notes
Options, Create, Send Journal Entries
Customize Quick Access Toolbar & the Ribbon
Customizing Workspace Views Part 1
Customizing Workspace Views Part 2
Managing Data File Folders
Outlook Connector; Customizing Mail
Creating Rules for Sent/Incoming Emails
Formatting Email Messages
General Mail Options
Assigning/Completing Tasks
Forward/Edit/Group Contacts
Setting Up Meeting Requests; Calendar Options
Setup RSS Feeds
Organize RSS Feeds, New Social Connection
Junk Mail Options, Dealing with Junk Mail
Filtering Through & Searching for Specific Emails
Auto Archive Options & Manual Archive
Email Security & Maintenance
Outlook 2010 Quiz
Learn Microsoft PowerPoint 2010
Introduction
Essential Information for a Successful Training Experience
Introduction to PowerPoint 2010 Basics
Start and Exit
PowerPoint 2010 Window
The Ribbon
The Backstage: Open, Save, Close
Options
Different Views
Introduction to Working with Slides
Manage Slide Appearance
Working with Text
Outlining a Presentation
Slide Management
Working with Shapes
Working with Tables
Using SmartArt
Using Templates
Working with Themes
Introduction to Beyond Basics
Using Hyperlinks
Working with Clips, Pictures, & Screenshots
Multimedia: Audio & Video
Animation
Transitions
Compare & Merge Presentations
Sharing with Other Office 2010 Applications
Introduction to Presenting Your Presentations
Using Notes
Creating Handouts
Printing Presentations and Notes/Handouts
Automated Self-Running Slide Shows
Annotating While Presenting
Concluding the Course
PowerPoint 2010 Quiz
Learn Microsoft Access 2010 Beginner Course
Intro to Backstage View, Ribbon, Quick Access Toolbar & Options
Essential Information for a Successful Training Experience
Start/Exit, Help Features, Shortcuts, Views, Templates
Understanding Database Components
Introduction to Design of a Database
Introduction to Building a Database
Creating Tables & Basic Setup of Relationships
Using Quick Parts to Setup New Table, Importing Spreadsheet
Entering Data Types into Tables
Changing Table Attributes, Copy, Rename, Delete Records
Table Structures
Table and Field Properties
Auto-Create Forms, Filtering & Searching
Types of Different Forms & Creating New
Improve Look, Style, & Feel of Forms
Adding Fields to Existing Form
Understanding and Setting Up the Expression Builder
Format Control on Forms/Reports
Sorting Single & Multiple Columns; Filter One Field Data Records
Sorting & Filtering Data in Form View; Find & Replace in Forms
Understanding Reports & Structure
Creating Reports; Using Print Preview to Check Report Outcome
Advanced Reporting; Formatting Reports
How to Improve Report Design, Add Existing Fields; Group/Sort
Select Queries; Sorting; Defined Criteria
Change Fields wthin Query; Specifying Criteria for Numbers/Text
Update Queries; Append Queries; Delete Queries
Inner/Outer Joins; Make Table Queries; Mail Merge
Securing Database and Views; New Features
Access 2010 Quiz
Learn Microsoft Access 2010 Advanced Training Course
Introduction to Advanced Access 2010
Essential Information for a Successful Training Experience
Working with Macros
AutoExec Macro
Database Options
More Database Options
Renaming Database Objects
Basics & Understanding Data Types
Table and Field Properties
Validation Rules & Text
Understanding & Using Keys and Indexes
Data Normalization
Types of Relationships
Maintaining Relationships
Using & Understanding Queries
Complex Queries
Creating Queries and Using Join & Sub-Queries
Datasheet View
Creating & Working with Forms
Using Forms to Maintain Data
Command Buttons
Command Buttons Part 2
Form Features that Need VBA Code
Understanding When & How to Use VBA
More about VBA and Using It to Improve Database
VBA Language Structure & Making a Switchboard
Error Handling
Cleaning Up Before Distribution16
Security Techniques
External Data & Importng/Exporting Data
Linking to Excel & Linking to Another Database
Separating/Splitting Up Forms, Reports, etc from Database
Options for Making Changes When Database is Multi-User
Advanced Features for Reports
Advanced Features for Reports Part 2
Distributing Application
Access 2010 Advanced Quiz