4.59 out of 5
4.59
244 reviews on Udemy

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.
Instructor:
Simon Sez IT
4,997 students enrolled
English [Auto-generated] More
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

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.

Learn Microsoft Excel 2010 Beginner Course

1
Introduction and Overview of Excel 2010 Course
2
Essential Information for a Successful Training Experience
3
Overview of the Excel Window
4
Working with the Mouse
5
Excel Options
6
Entering Text and Numbers
7
Creating Basic Formulas
8
Relative References
9
Order of Operations
10
Working withe Ranges
11
Working with Save and Save As Commands
12
File Extensions
13
Opening a File
14
Working with Larger Files
15
Freeze Panes Options
16
Split Screen Option
17
Page Setup Options
18
Headers and Footers
19
Print Titles
20
Comments
21
Fit to Print on One Page
22
Printing Workbooks
23
Adding and Deleting Rows, Columns, and Cells
24
Changing Column and Row Widths
25
Cut, Copy and Paste
26
Copying Formulas
27
Overview of Formulas
28
Create Formulas using Functions - Part 1
29
Create Formulas using Functions - Part 2
30
Absolute Values
31
Adding, Deleting and Renaming Sheets
32
Additional Sheet Tab Options
33
3-D Formulas
34
Cell Formatting
35
Number Formatting
36
Borders and Shading
37
Format as Table
38
Using Styles
39
Using Format Painter
40
Protecting Sheets
41
Fill Handle and Custom Lists
42
Creating Charts
43
Types of Charts
44
Editing Charts
45
Using Graphics to Enhance Charts
46
Creating Range Names
47
Managing Names
48
Using Names in Formulas
49
Removing Duplicates
50
Sort Data
51
Filter Data
52
Advanced Filters
53
Creating an Outline - Part 1
54
Creating an Outline - Part 2
55
Subtotals
56
New Window Option
57
Arrange File Options
58
Creating a Workspace
59
Custom Views
60
Scenarios
61
Creating Formulas Between Files
62
Working with Links
63
IF Statement
64
VLookups
65
Consolidating Data
66
Data Validation
67
Formula Auditing
68
Comments
69
Goal Seeker
70
Text to Columns Option
71
Watch Window
72
Closing Video
73
Excel 2010 Quiz

Learn Microsoft Excel 2010 Advanced Course

1
Introduction to Advanced Excel 2010
2
Essential Information for a Successful Training Experience
3
Four Basic Steps When Creating Charts/Graphs
4
Additional Features to Help Create Charts/Graphs
5
Additional Features to Help Create Charts/Graphs Part 2
6
Detailed Formatting for Charts/Graphs
7
Formatting Legends within Charts/Graphs
8
Formatting Axes and Gridlines within Charts/Graphs
9
Trends within Charts and Graphs
10
Complex Trends within Charts and Graphs
11
Trends over Time within Charts and Graphs
12
Showing Differences Using Bar Charts
13
Showing Differences Using Pie Charts
14
Limitations with Pie Charts & How to Correct
15
Alternative Ways to Show Differences
16
Using Charts & Graphs to Show Relationships
17
Using Charts & Graphs to Show Relationships Part 2
18
Charting & Graphing Financial Information
19
Charting & Graphing Financial Information Part 2
20
Specific Charts for Finance Information
21
Setting Up Live Charts
22
Using Sparklines for Data Visualization
23
Using and Formatting Data Bars, Color Scales & Icon Sets
24
Setting Up Pivot Tables/Charts
25
Setting Up Pivot Tables/Charts Part 2
You can view and review the lecture materials indefinitely, like an on-demand channel.
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
4.6
4.6 out of 5
244 Ratings

Detailed Rating

Stars 5
134
Stars 4
77
Stars 3
27
Stars 2
1
Stars 1
5
efd0723d43d8abb12cee585ab8e62432
30-Day Money-Back Guarantee

Includes

48 hours on-demand video
7 articles
Full lifetime access
Access on mobile and TV
Certificate of Completion