The Ultimate Microsoft Office 2010 Training Bundle

The Most Convenient Way to Boost Your Confidence And Learn MS Office 2010 Inside And Out—Quickly, No Travel or Classes.

Last updated 2022-01-10 | 4.6

- Introductory tutorials for Microsoft Excel 2010
- Introductory tutorials for Microsoft Word 2010
- Introductory tutorials for Microsoft Outlook 2010

What you'll learn

Introductory tutorials for Microsoft Excel 2010

Introductory tutorials for Microsoft Word 2010

Introductory tutorials for Microsoft Outlook 2010

Introductory tutorials for Microsoft PowerPoint 2010

Introductory tutorials for Microsoft Access 2010

Advanced training for Excel 2010

Advanced training for Access 2010

* Requirements

* Microsoft Office 2010

Description

Master Microsoft Office 2010 with this training bundle consisting of 7 courses, 48 hours, and over 280 videos.

Microsoft Office 2010 is a widespread edition of the famous workplace software, but it’s also one of the more difficult versions for some users to get to grips with, featuring the introduction of Microsoft’s now ubiquitous ‘Ribbon’ interface. During this 48-hour course, with over 260 videos, you’ll start from the basics, covering everything that you need to use Excel, Word, Outlook, PowerPoint, and Access 2010, including advanced courses for Excel & Access that will help you achieve real mastery.

So go ahead and impress your colleagues and wow your boss by taking your Office skills to the next level, making yourself capable of tackling almost any task with ease.

This bundle includes:

48 hours of video tutorials
Over 260 individual video lectures
7 quizzes with over 200 test questions
Certificate of completion

Courses included with this bundle:

Learn Excel 2010

In this 7-hour Microsoft Excel 2010 Beginners course, you’ll go from shunning sums to cheerily calculating, and by the end of the course you’ll be comfortable with creating and editing spreadsheets, formatting your data, working with formulas, and more.

Learn Excel 2010 – Advanced

Ideal for those seeking to enhance their Excel 2010 knowledge, the Learn Excel 2010 – Advanced course is a 7-hour training course that covers charts and graphs, data manipulation and analysis tools, pivot tables, and all the complex tools that Excel 2010 puts at your disposal.

Learn Word 2010

Learn Word 2010 is a 6.75-hour course ideal for those new to Microsoft Word or anyone looking to enhance their Word 2010 skills. Starting with document creation, you’ll cover the Ribbon, formatting, templates, and including charts and pictures, along with much more.

Learn Outlook 2010

Learn Outlook 2010 is a 5-hour course that starts with Outlook basics such as contacts, tasks, and appointments, before covering advanced options such as email formatting, inbox management, security, delegating tasks, and everything else you need to master Outlook 2010.

Learn PowerPoint 2010

Learn PowerPoint 2010 covers everything that you need to know to get to grips with Microsoft PowerPoint 2010, leaving you capable of making and editing slick, impressive presentations that will be sure to wow your colleagues. Get started with opening and editing existing PowerPoint files, configuring visuals and animations, including additional images, and even sound effects.

Learn Access 2010

Learn Microsoft Access 2010 is a 7-hour course filled with all the information you need to create, design, and customize high-performing databases. Covering tables, forms, data analysis, and practical design and organization tips, the course will help you make powerful and reliable databases with ease.

Learn Access 2010 - Advanced

Learn Microsoft Access 2010 - Advanced builds on your existing Access skills, teaching you best practice tips to avoid potential pitfalls and headaches, along with the skills you need to create switchboards, autoexec functions, macros, creative reports, custom buttons, and deep custom queries for detailed data analysis.

What people are saying:

"Simon Sez IT is one of the best resources if you are looking for Microsoft Office tutorials."

- TopTenReviews.com

"Thank you very much for an extraordinaire online tutorial of Access, it has helped me a lot and even enabled me to get a job. Now I work for an asset management bureau in Paris programming and updating databases from Bloomberg on a daily basis!"

- Lisa R., France.

Note: All videos are high-definition and are therefore best viewed enlarged and with the HD setting on.

Who this course is for:

Anyone new to Microsoft Office or upgrading from an older version

Course content

8 sections • 287 lectures

Learn Microsoft Excel 2010 Beginner Course 73 lectures

Introduction and Overview of Excel 2010 Course Preview 00:57

READ ME: Essential Information for a Successful Training Experience Preview 01:01

Overview of the Excel Window Preview 11:52

Working with the Mouse Preview 04:05

Excel Options Preview 02:44

Entering Text and Numbers Preview 05:39

Creating Basic Formulas Preview 06:55

Relative References Preview 01:54

Order of Operations Preview 04:33

Working withe Ranges Preview 05:03

Working with Save and Save As Commands Preview 05:22

File Extensions Preview 03:48

Opening a File Preview 04:37

Working with Larger Files Preview 06:27

Freeze Panes Options Preview 02:20

Split Screen Option Preview 03:43

Page Setup Options Preview 05:11

Headers and Footers Preview 07:37

Print Titles Preview 02:29

Comments Preview 04:22

Fit to Print on One Page Preview 05:11

Printing Workbooks Preview 02:21

Adding and Deleting Rows, Columns, and Cells Preview 05:41

Changing Column and Row Widths Preview 04:40

Cut, Copy and Paste Preview 06:22

Copying Formulas Preview 04:13

Overview of Formulas Preview 03:01

Create Formulas using Functions - Part 1 Preview 10:21

Create Formulas using Functions - Part 2 Preview 06:55

Absolute Values Preview 05:44

Adding, Deleting and Renaming Sheets Preview 06:25

Additional Sheet Tab Options Preview 05:09

3-D Formulas Preview 07:13

Cell Formatting Preview 12:17

Number Formatting Preview 10:00

Borders and Shading Preview 09:32

Format as Table Preview 06:56

Using Styles Preview 09:14

Using Format Painter Preview 04:40

Protecting Sheets Preview 11:27

Fill Handle and Custom Lists Preview 07:11

Creating Charts Preview 11:12

Types of Charts Preview 04:27

Editing Charts Preview 10:20

Using Graphics to Enhance Charts Preview 05:41

Creating Range Names Preview 10:21

Managing Names Preview 02:36

Using Names in Formulas Preview 05:29

Removing Duplicates Preview 08:56

Sort Data Preview 11:11

Filter Data Preview 11:31

Advanced Filters Preview 04:00

Creating an Outline - Part 1 Preview 08:11

Creating an Outline - Part 2 Preview 05:09

Subtotals Preview 09:41

New Window Option Preview 03:08

Arrange File Options Preview 02:40

Creating a Workspace Preview 04:16

Custom Views Preview 06:10

Scenarios Preview 06:32

Creating Formulas Between Files Preview 07:59

Working with Links Preview 04:36

IF Statement Preview 09:23

VLookups Preview 07:05

Consolidating Data Preview 04:39

Data Validation Preview 09:39

Formula Auditing Preview 04:01

Comments Preview 06:08

Goal Seeker Preview 02:05

Text to Columns Option Preview 02:28

Watch Window Preview 02:58

Closing Video Preview 00:28

Excel 2010 Quiz

Learn Microsoft Excel 2010 Advanced Course 32 lectures

Introduction to Advanced Excel 2010 Preview 03:10

READ ME: Essential Information for a Successful Training Experience Preview 01:01

Four Basic Steps When Creating Charts/Graphs Preview 10:58

Additional Features to Help Create Charts/Graphs Preview 14:56

Additional Features to Help Create Charts/Graphs Part 2 Preview 14:28

Detailed Formatting for Charts/Graphs Preview 13:03

Formatting Legends within Charts/Graphs Preview 14:48

Formatting Axes and Gridlines within Charts/Graphs Preview 15:47

Trends within Charts and Graphs Preview 11:24

Complex Trends within Charts and Graphs Preview 14:41

Trends over Time within Charts and Graphs Preview 15:28

Showing Differences Using Bar Charts Preview 15:11

Showing Differences Using Pie Charts Preview 15:30

Limitations with Pie Charts & How to Correct Preview 16:20

Alternative Ways to Show Differences Preview 13:28

Using Charts & Graphs to Show Relationships Preview 15:23

Using Charts & Graphs to Show Relationships Part 2 Preview 15:34

Charting & Graphing Financial Information Preview 15:15

Charting & Graphing Financial Information Part 2 Preview 11:06

Specific Charts for Finance Information Preview 14:36

Setting Up Live Charts Preview 14:38

Using Sparklines for Data Visualization Preview 14:26

Using and Formatting Data Bars, Color Scales & Icon Sets Preview 17:08

Setting Up Pivot Tables/Charts Preview 14:32

Setting Up Pivot Tables/Charts Part 2 Preview 14:30

Filtering Pivot Tables/Charts Preview 13:04

New Features for Pivot Tables/Charts Preview 13:20

Graphics Tools Preview 15:07

Graphics Tools Part 2 Preview 13:32

Exporting Charts and Graphs Preview 15:09

Exporting Charts and Graphs Part 2 Preview 14:59

Excel 2010 Advanced Quiz

Learn Microsoft Word 2010 46 lectures

Getting Started in Word 2010 Preview 08:16

READ ME: Essential Information for a Successful Training Experience Preview 01:01

Learning the Workspace Preview 09:19

Learning the Workspace Part 2 Preview 08:26

Create New Document, Using Templates, and Page Setup Preview 08:50

Converting and Saving Documents Preview 09:15

Selecting Text; Cut, Copy, Paste; Drag & Drop Preview 10:22

Insert/Overtype; Navigation Pane; Find & Replace Preview 07:47

Hyphenation, Auto-Correct, and Redo Preview 06:41

Text Formatting Preview 10:07

Paragraph Formatting Options Preview 10:34

Formatting with Bullets, Indents, Borders, Shading Preview 07:11

Creating/Saving New Template; Changing Styles Preview 09:41

Managing, Modifying and Deleting New Styles Preview 08:28

Working with/Using Themes Preview 08:41

Inserting/Formatting ClipArt, Pictures Preview 09:34

Using Picture Tools & New Features Preview 08:52

Inserting Screenshots, Using WordArt Preview 08:10

Using SmartArt, SmartArt Tools Preview 07:35

Inserting Tables; Adding Text; Selecting Parts of Tables Preview 10:09

Formatting Tables; Table Tools Preview 10:38

Inserting Charts; Chart Tools Preview 08:31

Creating Charts with Pre-existing Data Preview 09:44

Desktop Publishing Adding Drop Caps, Watermarks, Borders, Page Colors Preview 10:38

Using/Formatting Multi-Columns; Text Boxes Preview 08:25

Inserting/Resizing Shapes Preview 09:03

Stacking, Grouping Objects Preview 08:39

Creating Outline, Sub-Documents Preview 09:43

Expand/Collapse Sections; Document Properties; Cover Pages Preview 10:45

Add Table of Contents: Header & Footer Tools; Quick Parts Preview 10:17

Line-numbering, Adding Bibliography & Index Preview 10:19

Understanding Formatting Marks; Sections Features Preview 10:25

Inserting Symbols, Equations, Auto-Text, Building Blocks Preview 09:56

Inserting Footnotes, Bookmarks, Cross-references Preview 08:16

Setting up Mail Merge Using Wizard Preview 09:20

Manual Mail Merge Set-up Preview 08:47

Spelling/Grammar Check Preview 10:01

Using Thesaurus, Research Option, Translate; Printing Document Preview 09:38

Publishing to Web Publishing & Accessing Word Documents on Web Preview 10:00

Using Document Inspector, Password Protect, Editing Restrictions Preview 10:00

Reviewing & Sharing Reviewing, Sharing and Leaving/Adding Comments Preview 10:16

Customizing Word Customizing with Word Options Preview 09:41

Expanding Word Functionality; Using Macros Preview 09:14

Importing/Exporting, Embedding Document to Other Programs Preview 11:11

Check for Updates, Safe Mode Preview 08:55

Word 2010 Quiz

Learn Microsoft Outlook 2010 29 lectures

Getting Started Preview 11:13

READ ME: Essential Information for a Successful Training Experience Preview 01:01

Course Review Preview 00:43

Overview of Calendar, Appointments, Contacts, Tasks, Notes Preview 12:16

Adding New Accounts, Removing Accounts Preview 12:28

Add Items, To-Do Options and Customization Preview 10:56

Creating New Task, Modifying Details, Recurring Tasks Preview 12:51

Calendar Displays, Set Up/Edit/Delete Appointments Preview 12:06

Using Help Options; Add/Edit/Delete Contacts Preview 11:52

Create, Edit, Forward Notes Preview 10:06

Options, Create, Send Journal Entries Preview 12:12

Customize Quick Access Toolbar & the Ribbon Preview 11:02

Customizing Workspace Views Part 1 Preview 11:13

Customizing Workspace Views Part 2 Preview 11:27

Managing Data File Folders Preview 12:51

Outlook Connector; Customizing Mail Preview 12:25

Creating Rules for Sent/Incoming Emails Preview 13:09

Formatting Email Messages Preview 12:06

General Mail Options Preview 12:41

Assigning/Completing Tasks Preview 09:24

Forward/Edit/Group Contacts Preview 11:59

Setting Up Meeting Requests; Calendar Options Preview 12:58

Setup RSS Feeds Preview 11:19

Organize RSS Feeds, New Social Connection Preview 12:26

Junk Mail Options, Dealing with Junk Mail Preview 13:36

Filtering Through & Searching for Specific Emails Preview 12:19

Auto Archive Options & Manual Archive Preview 12:11

Email Security & Maintenance Preview 11:48

Outlook 2010 Quiz

Learn Microsoft PowerPoint 2010 35 lectures

Introduction Preview 03:11

READ ME: Essential Information for a Successful Training Experience Preview 01:01

Introduction to PowerPoint 2010 Basics Preview 00:35

Start and Exit Preview 02:30

PowerPoint 2010 Window Preview 05:15

The Ribbon Preview 05:55

The Backstage: Open, Save, Close Preview 04:19

Options Preview 08:24

Different Views Preview 08:12

Introduction to Working with Slides Preview 00:29

Manage Slide Appearance Preview 14:47

Working with Text Preview 32:03

Outlining a Presentation Preview 10:16

Slide Management Preview 08:43

Working with Shapes Preview 28:06

Working with Tables Preview 25:17

Using SmartArt Preview 24:15

Using Templates Preview 12:52

Working with Themes Preview 16:06

Introduction to Beyond Basics Preview 01:16

Using Hyperlinks Preview 25:42

Working with Clips, Pictures, & Screenshots Preview 25:58

Multimedia: Audio & Video Preview 08:20

Animation Preview 22:34

Transitions Preview 09:18

Compare & Merge Presentations Preview 14:25

Sharing with Other Office 2010 Applications Preview 14:16

Introduction to Presenting Your Presentations Preview 00:34

Using Notes Preview 14:53

Creating Handouts Preview 05:53

Printing Presentations and Notes/Handouts Preview 06:37

Automated Self-Running Slide Shows Preview 11:46

Annotating While Presenting Preview 05:50

Concluding the Course Preview 02:04

PowerPoint 2010 Quiz

Learn Microsoft Access 2010 Beginner Course 30 lectures

Intro to Backstage View, Ribbon, Quick Access Toolbar & Options Preview 15:38

READ ME: Essential Information for a Successful Training Experience Preview 01:01

Start/Exit, Help Features, Shortcuts, Views, Templates Preview 15:32

Understanding Database Components Preview 15:14

Introduction to Design of a Database Preview 14:19

Introduction to Building a Database Preview 13:27

Creating Tables & Basic Setup of Relationships Preview 15:25

Using Quick Parts to Setup New Table, Importing Spreadsheet Preview 16:18

Entering Data Types into Tables Preview 15:18

Changing Table Attributes, Copy, Rename, Delete Records Preview 16:21

Table Structures Preview 15:15

Table and Field Properties Preview 15:55

Auto-Create Forms, Filtering & Searching Preview 15:13

Types of Different Forms & Creating New Preview 14:56

Improve Look, Style, & Feel of Forms Preview 15:13

Adding Fields to Existing Form Preview 15:58

Understanding and Setting Up the Expression Builder Preview 14:58

Format Control on Forms/Reports Preview 14:58

Sorting Single & Multiple Columns; Filter One Field Data Records Preview 15:33

Sorting & Filtering Data in Form View; Find & Replace in Forms Preview 15:10

Understanding Reports & Structure Preview 15:24

Creating Reports; Using Print Preview to Check Report Outcome Preview 15:35

Advanced Reporting; Formatting Reports Preview 15:23

How to Improve Report Design, Add Existing Fields; Group/Sort Preview 14:25

Select Queries; Sorting; Defined Criteria Preview 15:00

Change Fields wthin Query; Specifying Criteria for Numbers/Text Preview 15:31

Update Queries; Append Queries; Delete Queries Preview 15:56

Inner/Outer Joins; Make Table Queries; Mail Merge Preview 16:27

Securing Database and Views; New Features Preview 14:01

Access 2010 Quiz

Learn Microsoft Access 2010 Advanced Training Course 37 lectures

Introduction to Advanced Access 2010 Preview 10:50

READ ME: Essential Information for a Successful Training Experience Preview 01:01

Working with Macros Preview 15:57

AutoExec Macro Preview 15:42

Database Options Preview 11:40

More Database Options Preview 15:35

Renaming Database Objects Preview 11:13

Basics & Understanding Data Types Preview 13:34

Table and Field Properties Preview 14:22

Validation Rules & Text Preview 13:31

Understanding & Using Keys and Indexes Preview 15:47

Data Normalization Preview 15:38

Types of Relationships Preview 12:39

Maintaining Relationships Preview 07:29

Using & Understanding Queries Preview 11:47

Complex Queries Preview 16:04

Creating Queries and Using Join & Sub-Queries Preview 16:00

Datasheet View Preview 15:30

Creating & Working with Forms Preview 13:56

Using Forms to Maintain Data Preview 16:04

Command Buttons Preview 14:10

Command Buttons Part 2 Preview 14:45

Form Features that Need VBA Code Preview 09:39

Understanding When & How to Use VBA Preview 16:01

More about VBA and Using It to Improve Database Preview 14:46

VBA Language Structure & Making a Switchboard Preview 15:19

Error Handling Preview 16:24

Cleaning Up Before Distribution16 Preview 16:48

Security Techniques Preview 15:59

External Data & Importng/Exporting Data Preview 16:39

Linking to Excel & Linking to Another Database Preview 09:25

Separating/Splitting Up Forms, Reports, etc from Database Preview 09:37

Options for Making Changes When Database is Multi-User Preview 14:56

Advanced Features for Reports Preview 12:35

Advanced Features for Reports Part 2 Preview 12:50

Distributing Application Preview 15:00

Access 2010 Advanced Quiz

Extras 5 lectures

EXTRA RESOURCE: The Most Frequently Used Excel Shortcuts - Infographic Preview 00:00

EXTRA RESOURCE: The Most Frequently Used PowerPoint Shortcuts - Infographic Preview 00:00

EXTRA RESOURCE: The Most Frequently Used Access Shortcuts - Infographic Preview 00:01

EXTRA RESOURCE: The Most Frequently Used Word Shortcuts - Infographic Preview 00:00

EXTRA RESOURCE: The Most Frequently Used Outlook Shortcuts - Infographic Preview 00:01