The Ultimate Microsoft Office 2010 Training Bundle 48 Hours
4.8 (88 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
4,414 students enrolled
Wishlisted Wishlist

Please confirm that you want to add The Ultimate Microsoft Office 2010 Training Bundle 48 Hours to your Wishlist.

Add to Wishlist

The Ultimate Microsoft Office 2010 Training Bundle 48 Hours

The Most Convenient Way to Boost Your Confidence And Learn MS Office 2010 Inside And Out—Quickly, No Travel or Classes.
4.8 (88 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
4,414 students enrolled
Created by Simon Sez IT
Last updated 1/2017
English
Current price: $12 Original price: $200 Discount: 94% off
4 days left at this price!
30-Day Money-Back Guarantee
Includes:
  • 48 hours on-demand video
  • 7 Articles
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion

Training 5 or more people?

Get your team access to Udemy's top 2,000 courses anytime, anywhere.

Try Udemy for Business
What Will I 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
View Curriculum
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 is the target audience?
  • Anyone new to Microsoft Office or upgrading from an older version
Compare to Other Microsoft Office Courses
Curriculum For This Course
275 Lectures
47:56:30
+
Learn Microsoft Excel 2010 Beginner Course
72 Lectures 07:08:28

Essential Information for a Successful Training Experience
01:17




Entering Text and Numbers
05:39

Creating Basic Formulas
06:55

Relative References
01:54

Order of Operations
04:33

Working withe Ranges
05:03

Working with Save and Save As Commands
05:22

File Extensions
03:48

Opening a File
04:37

Working with Larger Files
06:27

Freeze Panes Options
02:20

Split Screen Option
03:43

Page Setup Options
05:11

Headers and Footers
07:37

Print Titles
02:29

Comments
04:22

Fit to Print on One Page
05:11

Printing Workbooks
02:21

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

Changing Column and Row Widths
04:40

Cut, Copy and Paste
06:22

Copying Formulas
04:13

Overview of Formulas
03:01


Create Formulas using Functions - Part 2
06:55

Absolute Values
05:44

Adding, Deleting and Renaming Sheets
06:25

Additional Sheet Tab Options
05:09

3-D Formulas
07:13

Cell Formatting
12:17

Number Formatting
10:00

Borders and Shading
09:32

Format as Table
06:56

Using Styles
09:14

Using Format Painter
04:40

Protecting Sheets
11:27

Fill Handle and Custom Lists
07:11

Creating Charts
11:12

Types of Charts
04:27

Editing Charts
10:20

Using Graphics to Enhance Charts
05:41

Creating Range Names
10:21

Managing Names
02:36

Using Names in Formulas
05:29

Removing Duplicates
08:56

Sort Data
11:11

Filter Data
11:31

Advanced Filters
04:00

Creating an Outline - Part 1
08:11

Creating an Outline - Part 2
05:09

Subtotals
09:41

New Window Option
03:08

Arrange File Options
02:40

Creating a Workspace
04:16

Custom Views
06:10

Scenarios
06:32

Creating Formulas Between Files
07:59

Working with Links
04:36

IF Statement
09:23

VLookups
07:05

Consolidating Data
04:39

Data Validation
09:39

Formula Auditing
04:01

Comments
06:08

Goal Seeker
02:05

Text to Columns Option
02:28

Watch Window
02:58

Closing Video
00:28

Excel 2010 Quiz
40 questions
+
Learn Microsoft Excel 2010 Advanced Course
31 Lectures 07:02:48

Essential Information for a Successful Training Experience
01:17




Detailed Formatting for Charts/Graphs
13:03

Formatting Legends within Charts/Graphs
14:48

Formatting Axes and Gridlines within Charts/Graphs
15:47

Trends within Charts and Graphs
11:24

Complex Trends within Charts and Graphs
14:41

Trends over Time within Charts and Graphs
15:28


Showing Differences Using Pie Charts
15:30

Limitations with Pie Charts & How to Correct
16:20

Alternative Ways to Show Differences
13:28

Using Charts & Graphs to Show Relationships
15:23

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


Charting & Graphing Financial Information Part 2
11:06

Specific Charts for Finance Information
14:36

Setting Up Live Charts
14:38

Using Sparklines for Data Visualization
14:26

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

Setting Up Pivot Tables/Charts
14:32

Setting Up Pivot Tables/Charts Part 2
14:30

Filtering Pivot Tables/Charts
13:04

New Features for Pivot Tables/Charts
13:20

Graphics Tools
15:07

Graphics Tools Part 2
13:32

Exporting Charts and Graphs
15:09

Exporting Charts and Graphs Part 2
14:59

Excel 2010 Advanced Quiz
35 questions
+
Learn Microsoft Word 2010
45 Lectures 06:51:37

Essential Information for a Successful Training Experience
01:17




Converting and Saving Documents
09:15

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

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

Hyphenation, Auto-Correct, and Redo
06:41

Text Formatting
10:07

Paragraph Formatting Options
10:34

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

Creating/Saving New Template; Changing Styles
09:41

Managing, Modifying and Deleting New Styles
08:28


Inserting/Formatting ClipArt, Pictures
09:34

Using Picture Tools & New Features
08:52

Inserting Screenshots, Using WordArt
08:10

Using SmartArt, SmartArt Tools
07:35

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

Formatting Tables; Table Tools
10:38

Inserting Charts; Chart Tools
08:31

Creating Charts with Pre-existing Data
09:44

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

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

Inserting/Resizing Shapes
09:03

Stacking, Grouping Objects
08:39

Creating Outline, Sub-Documents
09:43

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

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

Line-numbering, Adding Bibliography & Index
10:19

Understanding Formatting Marks; Sections Features
10:25

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

Inserting Footnotes, Bookmarks, Cross-references
08:16

Setting up Mail Merge Using Wizard
09:20

Manual Mail Merge Set-up
08:47

Spelling/Grammar Check
10:01

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

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

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

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

Customizing Word Customizing with Word Options
09:41

Expanding Word Functionality; Using Macros
09:14

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

Check for Updates, Safe Mode
08:55

Word 2010 Quiz
34 questions
+
Learn Microsoft Outlook 2010
28 Lectures 05:12:54

Essential Information for a Successful Training Experience
01:17


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

Adding New Accounts, Removing Accounts
12:28

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

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

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

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

Create, Edit, Forward Notes
10:06

Options, Create, Send Journal Entries
12:12

Customize Quick Access Toolbar & the Ribbon
11:02

Customizing Workspace Views Part 1
11:13

Customizing Workspace Views Part 2
11:27

Managing Data File Folders
12:51

Outlook Connector; Customizing Mail
12:25

Creating Rules for Sent/Incoming Emails
13:09


General Mail Options
12:41

Assigning/Completing Tasks
09:24

Forward/Edit/Group Contacts
11:59

Setting Up Meeting Requests; Calendar Options
12:58

Setup RSS Feeds
11:19

Organize RSS Feeds, New Social Connection
12:26

Junk Mail Options, Dealing with Junk Mail
13:36

Filtering Through & Searching for Specific Emails
12:19

Auto Archive Options & Manual Archive
12:11

Email Security & Maintenance
11:48

Outlook 2010 Quiz
25 questions
+
Learn Microsoft PowerPoint 2010
34 Lectures 06:21:58
Introduction
03:11

Essential Information for a Successful Training Experience
01:17

Introduction to PowerPoint 2010 Basics
00:35


PowerPoint 2010 Window
05:15

The Ribbon
05:55

The Backstage: Open, Save, Close
04:19

Options
08:24

Different Views
08:12

Introduction to Working with Slides
00:29

Manage Slide Appearance
14:47

Working with Text
32:03

Outlining a Presentation
10:16

Slide Management
08:43

Working with Shapes
28:06

Working with Tables
25:17

Using SmartArt
24:15

Using Templates
12:52

Working with Themes
16:06

Introduction to Beyond Basics
01:16

Using Hyperlinks
25:42

Working with Clips, Pictures, & Screenshots
25:58

Multimedia: Audio & Video
08:20

Animation
22:34

Transitions
09:18

Compare & Merge Presentations
14:25

Sharing with Other Office 2010 Applications
14:16

Introduction to Presenting Your Presentations
00:34

Using Notes
14:53

Creating Handouts
05:53

Printing Presentations and Notes/Handouts
06:37

Automated Self-Running Slide Shows
11:46

Annotating While Presenting
05:50

Concluding the Course
02:04

PowerPoint 2010 Quiz
35 questions
+
Learn Microsoft Access 2010 Beginner Course
29 Lectures 07:09:40

Essential Information for a Successful Training Experience
01:17

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

Understanding Database Components
15:14



Creating Tables & Basic Setup of Relationships
15:25

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

Entering Data Types into Tables
15:18

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

Table Structures
15:15

Table and Field Properties
15:55

Auto-Create Forms, Filtering & Searching
15:13

Types of Different Forms & Creating New
14:56

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


Understanding and Setting Up the Expression Builder
14:58

Format Control on Forms/Reports
14:58

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

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

Understanding Reports & Structure
15:24

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

Advanced Reporting; Formatting Reports
15:23

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

Select Queries; Sorting; Defined Criteria
15:00

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

Update Queries; Append Queries; Delete Queries
15:56

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

Securing Database and Views; New Features
14:01

Access 2010 Quiz
35 questions
+
Learn Microsoft Access 2010 Advanced Training Course
36 Lectures 08:09:28

Essential Information for a Successful Training Experience
01:17


AutoExec Macro
15:42

Database Options
11:40

More Database Options
15:35

Renaming Database Objects
11:13


Table and Field Properties
14:22

Validation Rules & Text
13:31

Understanding & Using Keys and Indexes
15:47

Data Normalization
15:38

Types of Relationships
12:39

Maintaining Relationships
07:29

Using & Understanding Queries
11:47

Complex Queries
16:04

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

Datasheet View
15:30


Using Forms to Maintain Data
16:04

Command Buttons
14:10

Command Buttons Part 2
14:45

Form Features that Need VBA Code
09:39

Understanding When & How to Use VBA
16:01

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

VBA Language Structure & Making a Switchboard
15:19

Error Handling
16:24

Cleaning Up Before Distribution16
16:48

Security Techniques
15:59

External Data & Importng/Exporting Data
16:39

Linking to Excel & Linking to Another Database
09:25

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

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

Advanced Features for Reports
12:35

Advanced Features for Reports Part 2
12:50

Distributing Application
15:00

Access 2010 Advanced Quiz
40 questions
About the Instructor
Simon Sez IT
4.4 Average rating
12,393 Reviews
308,046 Students
117 Courses
300,000+ Students | Wordwide Use 180 Countries |120+ Courses

Since 2008, individuals, small businesses, and Fortune 500 companies with thousands of employees have benefited from the easy and hands-on software training offered by Simon Sez IT. With 80+ courses and 4,500+ video tutorials on a range of software programs, Simon Sez IT ensures stress-free eLearning and enhanced employee productivity - no matter whether you are implementing new software or a technological upgrade for your workplace. With over 300,000 Udemy students in over 180 countries, Simon Sez IT is the preferred eLearning choice for individuals and businesses everywhere.