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.45 (860 reviews)
Udemy
platform
English
language
Microsoft
category
instructor
The Ultimate Microsoft Office 2010 Training Bundle  48 Hours
8,024
students
50 hours
content
Mar 2023
last update
$129.99
regular price

What you will 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

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.

Content

Learn Microsoft Excel 2010 Beginner Course

Introduction and Overview of Excel 2010 Course
Essential Information for a Successful Training Experience
Overview of the Excel Window
Working with the Mouse
Excel Options
Entering Text and Numbers
Creating Basic Formulas
Relative References
Order of Operations
Working withe Ranges
Working with Save and Save As Commands
File Extensions
Opening a File
Working with Larger Files
Freeze Panes Options
Split Screen Option
Page Setup Options
Headers and Footers
Print Titles
Comments
Fit to Print on One Page
Printing Workbooks
Adding and Deleting Rows, Columns, and Cells
Changing Column and Row Widths
Cut, Copy and Paste
Copying Formulas
Overview of Formulas
Create Formulas using Functions - Part 1
Create Formulas using Functions - Part 2
Absolute Values
Adding, Deleting and Renaming Sheets
Additional Sheet Tab Options
3-D Formulas
Cell Formatting
Number Formatting
Borders and Shading
Format as Table
Using Styles
Using Format Painter
Protecting Sheets
Fill Handle and Custom Lists
Creating Charts
Types of Charts
Editing Charts
Using Graphics to Enhance Charts
Creating Range Names
Managing Names
Using Names in Formulas
Removing Duplicates
Sort Data
Filter Data
Advanced Filters
Creating an Outline - Part 1
Creating an Outline - Part 2
Subtotals
New Window Option
Arrange File Options
Creating a Workspace
Custom Views
Scenarios
Creating Formulas Between Files
Working with Links
IF Statement
VLookups
Consolidating Data
Data Validation
Formula Auditing
Comments
Goal Seeker
Text to Columns Option
Watch Window
Closing Video
Excel 2010 Quiz

Learn Microsoft Excel 2010 Advanced Course

Introduction to Advanced Excel 2010
Essential Information for a Successful Training Experience
Four Basic Steps When Creating Charts/Graphs
Additional Features to Help Create Charts/Graphs
Additional Features to Help Create Charts/Graphs Part 2
Detailed Formatting for Charts/Graphs
Formatting Legends within Charts/Graphs
Formatting Axes and Gridlines within Charts/Graphs
Trends within Charts and Graphs
Complex Trends within Charts and Graphs
Trends over Time within Charts and Graphs
Showing Differences Using Bar Charts
Showing Differences Using Pie Charts
Limitations with Pie Charts & How to Correct
Alternative Ways to Show Differences
Using Charts & Graphs to Show Relationships
Using Charts & Graphs to Show Relationships Part 2
Charting & Graphing Financial Information
Charting & Graphing Financial Information Part 2
Specific Charts for Finance Information
Setting Up Live Charts
Using Sparklines for Data Visualization
Using and Formatting Data Bars, Color Scales & Icon Sets
Setting Up Pivot Tables/Charts
Setting Up Pivot Tables/Charts Part 2
Filtering Pivot Tables/Charts
New Features for Pivot Tables/Charts
Graphics Tools
Graphics Tools Part 2
Exporting Charts and Graphs
Exporting Charts and Graphs Part 2
Excel 2010 Advanced Quiz

Learn Microsoft Word 2010

Getting Started in Word 2010
Essential Information for a Successful Training Experience
Learning the Workspace
Learning the Workspace Part 2
Create New Document, Using Templates, and Page Setup
Converting and Saving Documents
Selecting Text; Cut, Copy, Paste; Drag & Drop
Insert/Overtype; Navigation Pane; Find & Replace
Hyphenation, Auto-Correct, and Redo
Text Formatting
Paragraph Formatting Options
Formatting with Bullets, Indents, Borders, Shading
Creating/Saving New Template; Changing Styles
Managing, Modifying and Deleting New Styles
Working with/Using Themes
Inserting/Formatting ClipArt, Pictures
Using Picture Tools & New Features
Inserting Screenshots, Using WordArt
Using SmartArt, SmartArt Tools
Inserting Tables; Adding Text; Selecting Parts of Tables
Formatting Tables; Table Tools
Inserting Charts; Chart Tools
Creating Charts with Pre-existing Data
Desktop Publishing Adding Drop Caps, Watermarks, Borders, Page Colors
Using/Formatting Multi-Columns; Text Boxes
Inserting/Resizing Shapes
Stacking, Grouping Objects
Creating Outline, Sub-Documents
Expand/Collapse Sections; Document Properties; Cover Pages
Add Table of Contents: Header & Footer Tools; Quick Parts
Line-numbering, Adding Bibliography & Index
Understanding Formatting Marks; Sections Features
Inserting Symbols, Equations, Auto-Text, Building Blocks
Inserting Footnotes, Bookmarks, Cross-references
Setting up Mail Merge Using Wizard
Manual Mail Merge Set-up
Spelling/Grammar Check
Using Thesaurus, Research Option, Translate; Printing Document
Publishing to Web Publishing & Accessing Word Documents on Web
Using Document Inspector, Password Protect, Editing Restrictions
Reviewing & Sharing Reviewing, Sharing and Leaving/Adding Comments
Customizing Word Customizing with Word Options
Expanding Word Functionality; Using Macros
Importing/Exporting, Embedding Document to Other Programs
Check for Updates, Safe Mode
Word 2010 Quiz

Learn Microsoft Outlook 2010

Getting Started
Essential Information for a Successful Training Experience
Course Review
Overview of Calendar, Appointments, Contacts, Tasks, Notes
Adding New Accounts, Removing Accounts
Add Items, To-Do Options and Customization
Creating New Task, Modifying Details, Recurring Tasks
Calendar Displays, Set Up/Edit/Delete Appointments
Using Help Options; Add/Edit/Delete Contacts
Create, Edit, Forward Notes
Options, Create, Send Journal Entries
Customize Quick Access Toolbar & the Ribbon
Customizing Workspace Views Part 1
Customizing Workspace Views Part 2
Managing Data File Folders
Outlook Connector; Customizing Mail
Creating Rules for Sent/Incoming Emails
Formatting Email Messages
General Mail Options
Assigning/Completing Tasks
Forward/Edit/Group Contacts
Setting Up Meeting Requests; Calendar Options
Setup RSS Feeds
Organize RSS Feeds, New Social Connection
Junk Mail Options, Dealing with Junk Mail
Filtering Through & Searching for Specific Emails
Auto Archive Options & Manual Archive
Email Security & Maintenance
Outlook 2010 Quiz

Learn Microsoft PowerPoint 2010

Introduction
Essential Information for a Successful Training Experience
Introduction to PowerPoint 2010 Basics
Start and Exit
PowerPoint 2010 Window
The Ribbon
The Backstage: Open, Save, Close
Options
Different Views
Introduction to Working with Slides
Manage Slide Appearance
Working with Text
Outlining a Presentation
Slide Management
Working with Shapes
Working with Tables
Using SmartArt
Using Templates
Working with Themes
Introduction to Beyond Basics
Using Hyperlinks
Working with Clips, Pictures, & Screenshots
Multimedia: Audio & Video
Animation
Transitions
Compare & Merge Presentations
Sharing with Other Office 2010 Applications
Introduction to Presenting Your Presentations
Using Notes
Creating Handouts
Printing Presentations and Notes/Handouts
Automated Self-Running Slide Shows
Annotating While Presenting
Concluding the Course
PowerPoint 2010 Quiz

Learn Microsoft Access 2010 Beginner Course

Intro to Backstage View, Ribbon, Quick Access Toolbar & Options
Essential Information for a Successful Training Experience
Start/Exit, Help Features, Shortcuts, Views, Templates
Understanding Database Components
Introduction to Design of a Database
Introduction to Building a Database
Creating Tables & Basic Setup of Relationships
Using Quick Parts to Setup New Table, Importing Spreadsheet
Entering Data Types into Tables
Changing Table Attributes, Copy, Rename, Delete Records
Table Structures
Table and Field Properties
Auto-Create Forms, Filtering & Searching
Types of Different Forms & Creating New
Improve Look, Style, & Feel of Forms
Adding Fields to Existing Form
Understanding and Setting Up the Expression Builder
Format Control on Forms/Reports
Sorting Single & Multiple Columns; Filter One Field Data Records
Sorting & Filtering Data in Form View; Find & Replace in Forms
Understanding Reports & Structure
Creating Reports; Using Print Preview to Check Report Outcome
Advanced Reporting; Formatting Reports
How to Improve Report Design, Add Existing Fields; Group/Sort
Select Queries; Sorting; Defined Criteria
Change Fields wthin Query; Specifying Criteria for Numbers/Text
Update Queries; Append Queries; Delete Queries
Inner/Outer Joins; Make Table Queries; Mail Merge
Securing Database and Views; New Features
Access 2010 Quiz

Learn Microsoft Access 2010 Advanced Training Course

Introduction to Advanced Access 2010
Essential Information for a Successful Training Experience
Working with Macros
AutoExec Macro
Database Options
More Database Options
Renaming Database Objects
Basics & Understanding Data Types
Table and Field Properties
Validation Rules & Text
Understanding & Using Keys and Indexes
Data Normalization
Types of Relationships
Maintaining Relationships
Using & Understanding Queries
Complex Queries
Creating Queries and Using Join & Sub-Queries
Datasheet View
Creating & Working with Forms
Using Forms to Maintain Data
Command Buttons
Command Buttons Part 2
Form Features that Need VBA Code
Understanding When & How to Use VBA
More about VBA and Using It to Improve Database
VBA Language Structure & Making a Switchboard
Error Handling
Cleaning Up Before Distribution16
Security Techniques
External Data & Importng/Exporting Data
Linking to Excel & Linking to Another Database
Separating/Splitting Up Forms, Reports, etc from Database
Options for Making Changes When Database is Multi-User
Advanced Features for Reports
Advanced Features for Reports Part 2
Distributing Application
Access 2010 Advanced Quiz

Reviews

Katrina
February 27, 2023
A lot of times I learn something by "hit or miss". This is a great way to get in on the ground floor and really learn.
Mahalakshmi
July 18, 2022
The instructions given by the trainer are very clear and concise. Absolutely love this course so far. :)
Alfred
July 10, 2022
Course content was good. The instructor could have shown cursor movement little slowly. Have to watch few times to follow the cursor movement.
Willie
February 8, 2022
Excellent, it gave me basic knowledge and the confidence to use options I had never tried or been unaware of previously. Thank you so much.
Rachel
January 21, 2022
i like it so far! I am a beginner with basic knowledge but there are definitely some basic things i didnt know.
Sandra
September 13, 2021
yes very good. I can update myself with the course. very insightful and shows me commands that I have not used before. Very good way to upgrade my skills.
Prashant
July 26, 2021
It is easy to understand, explained everything( from start to end ) with lots of examples and best thing of this course is that it covers Excel , Power Point , Word ,Outlook and Access so if you have a little bit knowledge of everything then you can go for it .
Audrey
July 12, 2021
Still having trouble with 164 and 166 - can't seem to get them to finish or come back. They videos won't advance or play again. I've even flushed my DNS on my machine in case something was cached.
Maria
April 25, 2021
It is a fantastic experience, I'm learning to use Microsoft Word much better. I will be able to create better presentable documents now.
John
April 14, 2021
She can articulate issues about the course so I think I will get what I expected just because I am just beginning the course
Delilah
March 12, 2021
I would say that the narrator does a good job of explaining everything. I just wonder if I'm going to get the opportunity to practice what I've been taught during this course.
Christie
February 2, 2021
Clear, easy to follow, and just enough information covered to absorb and practice before moving on to more.
Joanne
August 29, 2017
I'm really enjoying learning so much but i think it'd be good to have little assessments along the way to practice what i've learnt but on the whole its just what i was looking for.
Ronald
December 11, 2016
The constant OK is driving me nuts. It should also have some exercises where I am doing it myself, not just watching someone do it. Would be more beneficial.
Tore
December 4, 2016
Because there is no exercise files to the course such as that of Bruce Myron and we pay for a video course. And you are selling course on world basis and only correct way to learn is practice files so that we can follow under way

Charts

Price

The Ultimate Microsoft Office 2010 Training Bundle  48 Hours - Price chart

Rating

The Ultimate Microsoft Office 2010 Training Bundle  48 Hours - Ratings chart

Enrollment distribution

The Ultimate Microsoft Office 2010 Training Bundle  48 Hours - Distribution chart
109518
udemy ID
10/23/2013
course created date
11/20/2019
course indexed date
Bot
course submited by