Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
The Ultimate Microsoft Office 2010 Training Bundle 48 Hours
Rating: 4.5 out of 5(913 ratings)
8,187 students

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.
Created bySimon Sez IT
Last updated 4/2026
English

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

Course content

10 sections285 lectures50h 58m total length
  • Introduction and Overview of Excel 2010 Course0:57
  • READ ME: Essential Information for a Successful Training Experience0:55
  • Overview of the Excel Window11:52
  • Working with the Mouse4:05
  • Excel Options2:44
  • Entering Text and Numbers5:39
  • Creating Basic Formulas6:55
  • Relative References1:54
  • Order of Operations4:33
  • Working withe Ranges5:03
  • Working with Save and Save As Commands5:22
  • File Extensions3:48
  • Opening a File4:37
  • Working with Larger Files6:27
  • Freeze Panes Options2:20
  • Split Screen Option3:43
  • Page Setup Options5:11
  • Headers and Footers7:37
  • Print Titles2:29
  • Comments4:22
  • Fit to Print on One Page5:11
  • Printing Workbooks2:21
  • Adding and Deleting Rows, Columns, and Cells5:41
  • Changing Column and Row Widths4:40
  • Cut, Copy and Paste6:22
  • Copying Formulas4:13
  • Overview of Formulas3:01
  • Create Formulas using Functions - Part 110:21
  • Create Formulas using Functions - Part 26:55
  • Absolute Values5:44
  • Adding, Deleting and Renaming Sheets6:25
  • Additional Sheet Tab Options5:09
  • 3-D Formulas7:13
  • Cell Formatting12:17
  • Number Formatting10:00
  • Borders and Shading9:32
  • Format as Table6:56
  • Using Styles9:14
  • Using Format Painter4:40
  • Protecting Sheets11:27
  • Fill Handle and Custom Lists7:11
  • Creating Charts11:12
  • Types of Charts4:27
  • Editing Charts10:20
  • Using Graphics to Enhance Charts5:41
  • Creating Range Names10:21
  • Managing Names2:36
  • Using Names in Formulas5:29
  • Removing Duplicates8:56
  • Sort Data11:11
  • Filter Data11:31
  • Advanced Filters4:00
  • Creating an Outline - Part 18:11
  • Creating an Outline - Part 25:09
  • Subtotals9:41
  • New Window Option3:08
  • Arrange File Options2:40
  • Creating a Workspace4:16
  • Custom Views6:10
  • Scenarios6:32
  • Creating Formulas Between Files7:59
  • Working with Links4:36
  • IF Statement9:23
  • VLookups7:05
  • Consolidating Data4:39
  • Data Validation9:39
  • Formula Auditing4:01
  • Comments6:08
  • Goal Seeker2:05
  • Text to Columns Option2:28
  • Watch Window2:58
  • Closing Video0:28
  • Excel 2010 Quiz

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