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.5 (43 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,202 students enrolled
$19
$200
90% off
Take This Course
  • Lectures 269
  • Length 48 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 11/2013 English

Course 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.

What are the requirements?

  • Microsoft Office 2010

What am I going to get from this course?

  • 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

What is the target audience?

  • Anyone new to Microsoft Office or upgrading from an older version

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Learn Microsoft Excel 2010 Beginner Course
Introduction and Overview of Excel 2010 Course
Preview
00:57
IMPORTANT - Read this to ensure the best video quality!
Article
Overview of the Excel Window
Preview
11:52
Working with the Mouse
Preview
04:05
Excel Options
Preview
02:44
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 1
Preview
10:21
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
Section 2: Learn Microsoft Excel 2010 Advanced Course
Introduction to Advanced Excel 2010
Preview
03:10
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
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 Bar Charts
Preview
15:11
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
Preview
15:15
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

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Simon Sez IT, Over 270,000 Students, Used in 180 Countries, 115 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,000+ 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 250,000 Udemy students in over 180 countries, Simon Sez IT is the preferred eLearning choice for individuals and businesses everywhere.

Ready to start learning?
Take This Course