
The Ultimate Microsoft Office 2010 Training Bundle
Master Microsoft Office 2010 with this training bundle consisting of 7 courses, 50 hours, and 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. Over 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
- Optional quizzes with 244 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.
Your Instructor

The “IT” in Simon Sez IT stands for “Information Technology.” We offer instruction to help learners win when it comes to computer and software technology. Learning software skills in an easy, self-paced way for an affordable price is what Simon Sez IT is all about.
The company was founded in 2008 by Chris “Simon” Calder, Director of IT operations for one of Los Angeles’ most prestigious institutions. In this role, Simon saw the need for low-stress software training for hundreds of employees in his company who were facing technological upgrades at work. That’s how the idea of Simon Sez IT was born.
Since then, Simon Sez IT has built a rapid and loyal following. At a time when many companies were struggling to survive, Simon Sez IT thrived—providing accessible, low-cost computer and software training to people of all ages, regardless of their computer experience. In our first four years alone, we serviced tens of thousands of satisfied customers in over 100 countries.
Course Curriculum
-
PreviewIntro to Backstage View, Ribbon, Quick Access Toolbar & Options (15:38)
-
PreviewStart/Exit, Help Features, Shortcuts, Views, Templates (15:32)
-
PreviewUnderstanding Database Components (15:14)
-
PreviewIntroduction to Design of a Database (14:19)
-
StartIntroduction to Building a Database (13:27)
-
StartCreating Tables & Basic Setup of Relationships (15:25)
-
StartUsing Quick Parts to Setup New Table, Importing Spreadsheet (16:18)
-
StartEntering Data Types into Tables (15:18)
-
StartChanging Table Attributes, Copy, Rename, Delete Records (16:21)
-
StartTable Structures (15:15)
-
StartTable and Field Properties (15:55)
-
StartAuto-Create Forms, Filtering & Searching (15:13)
-
StartTypes of Different Forms & Creating New (14:56)
-
StartImprove Look, Style, & Feel of Forms (15:13)
-
StartAdding Fields to Existing Form (15:58)
-
StartUnderstanding and Setting Up the Expression Builder (14:58)
-
StartFormat Control on Forms/Reports (14:58)
-
StartSorting Single & Multiple Columns; Filter One Field Data Records (15:33)
-
StartSorting & Filtering Data in Form View; Find & Replace in Forms (15:10)
-
StartUnderstanding Reports & Structure (15:24)
-
StartCreating Reports; Using Print Preview to Check Report Outcome (15:35)
-
StartAdvanced Reporting; Formatting Reports (15:23)
-
StartHow to Improve Report Design, Add Existing Fields; Group/Sort (14:25)
-
StartSelect Queries; Sorting; Defined Criteria (15:00)
-
StartChange Fields wthin Query; Specifying Criteria for Numbers/Text (15:31)
-
StartUpdate Queries; Append Queries; Delete Queries (15:56)
-
StartInner/Outer Joins; Make Table Queries; Mail Merge (16:27)
-
StartSecuring Database and Views; New Features (14:01)
-
StartQuiz - Microsoft Access 2010 Beginner/Intermediate Course
-
PreviewIntroduction to Advanced Access 2010 (10:50)
-
PreviewWorking with Macros (15:57)
-
PreviewAutoExec Macro (15:42)
-
PreviewDatabase Options (11:40)
-
StartMore Database Options (15:35)
-
StartRenaming Database Objects (11:13)
-
StartBasics & Understanding Data Types (13:34)
-
StartTable Field Properties (14:22)
-
StartValidation Rules & Tex (13:31)
-
StartUnderstanding & Using Keys and Indexes (15:47)
-
StartData Normalization (15:38)
-
StartTypes of Relationships (12:39)
-
StartMaintaining Relationships (7:29)
-
StartUsing & Understanding Queries (11:47)
-
StartComplex Queries (16:04)
-
StartCreating Queries and Using Join & Sub-Queries (16:00)
-
StartDatasheet View (15:30)
-
StartCreating & Working with Forms (13:56)
-
StartUsing Forms to Maintain Data (13:56)
-
StartCommand Buttons (14:10)
-
StartCommand Buttons Part 2 (14:45)
-
StartForm Features that Need VBA Code (9:39)
-
StartUnderstanding When & How to Use VBA (16:01)
-
StartMore about VBA and Using It to Improve Database (14:46)
-
StartVBA Language Structure & Making a Switchboard (15:19)
-
StartError Handling (16:24)
-
StartCleaning Up Before Distribution16 (16:48)
-
StartSecurity Techniques (15:59)
-
StartExternal Data & Importng/Exporting Data (16:39)
-
StartLinking to Excel & Linking to Another Database (9:25)
-
StartSeparating/Splitting Up Forms, Reports, etc from Database (9:37)
-
StartOptions for Making Changes When Database is Multi-User (14:56)
-
StartAdvanced Features for Reports (12:35)
-
StartAdvanced Features for Reports part 2 (12:50)
-
StartDistributing Application (15:00)
-
StartQuiz - Microsoft Access 2010 Advanced Course
-
PreviewIntroduction and Overview of Excel 2010 Course (0:56)
-
PreviewOverview of the Excel Window (11:52)
-
PreviewWorking with the Mouse (4:05)
-
PreviewExcel Options (2:44)
-
StartEntering Text and Numbers (5:39)
-
StartCreating Basic Formulas (6:55)
-
StartRelative References (1:54)
-
StartOrder of Operations (4:33)
-
StartWorking withe Ranges (5:03)
-
StartWorking with Save and Save As Commands (5:22)
-
StartFile Extensions (3:48)
-
StartOpening a File (4:36)
-
StartWorking with Larger Files (6:26)
-
StartFreeze Panes Options (2:19)
-
StartSplit Screen Option (3:43)
-
StartPage Setup Options (5:11)
-
StartHeaders and Footers (7:37)
-
StartPrint Titles (2:29)
-
StartComments (4:22)
-
StartFit to print on one page (5:11)
-
StartPrinting Workbooks (2:21)
-
StartAdding and Deleting Rows, Columns, and Cells (5:41)
-
StartChanging Column and Row Widths (4:39)
-
StartCut, Copy and Paste (6:22)
-
StartCopying Formulas (4:13)
-
StartOverview of Formulas (3:00)
-
StartCreate Formulas using Functions - Part 1 (10:21)
-
StartCreate Formulas using Functions - Part 2 (6:55)
-
StartAbsolute Values (5:44)
-
StartAdding, Deleting and Renaming Sheets (6:25)
-
StartAdditional Sheet Tab Options (5:09)
-
Start3-D Formulas (7:13)
-
StartCell Formatting (12:16)
-
StartNumber Formatting (10:00)
-
StartBorders and Shading (9:32)
-
StartFormat as Table (6:56)
-
StartUsing Styles (9:14)
-
StartUsing Format Painter (4:40)
-
StartProtecting Sheets (11:27)
-
StartFill Handle and Custom Lists (7:11)
-
StartCreating Charts (11:12)
-
StartTypes of Charts (4:27)
-
StartEditing Charts (10:20)
-
StartUsing Graphics to Enhance Charts (5:41)
-
StartCreating Range Names (10:21)
-
StartManaging Names (2:36)
-
StartUsing Names in Formulas (5:29)
-
StartRemoving Duplicates (8:56)
-
StartSort Data (11:11)
-
StartFilter Data (11:31)
-
StartAdvanced Filters (3:59)
-
StartCreating an Outline - Part 1 (8:11)
-
StartCreating an Outline - Part 2 (5:09)
-
StartSubtotals (9:41)
-
StartNew Window Option (3:08)
-
StartArrange File Options (2:40)
-
StartCreating a Workspace (4:16)
-
StartCustom Views (6:10)
-
StartScenarios (6:32)
-
StartCreating Formulas between Files (7:58)
-
StartWorking with Links (4:36)
-
StartIF Statement (9:23)
-
StartVLookups (7:05)
-
StartConsolidating Data (4:39)
-
StartData Validation (9:39)
-
StartFormula Auditing (4:01)
-
StartComments (6:08)
-
StartGoal Seeker (2:05)
-
StartText to Columns Option (2:28)
-
StartWatch Window (2:58)
-
StartClosing Video (0:28)
-
StartQuiz - Microsoft Excel 2010 Beginner/Intermediate Course