Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ AWS Certified Developer - Associate
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Mindfulness Personal Development Meditation Personal Transformation Life Purpose Emotional Intelligence Neuroscience
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Google Analytics
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Modeling Data Analysis Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee
Office Productivity Microsoft Microsoft Office

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.
Rating: 4.5 out of 54.5 (483 ratings)
5,919 students
Created by Simon Sez IT
Last updated 12/2020
English
English [Auto], Italian [Auto]
30-Day Money-Back Guarantee

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
Curated for the Udemy for Business collection

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

Course content

8 sections • 280 lectures • 47h 55m total length

  • Preview00:57
  • READ ME: Essential Information for a Successful Training Experience
    01:01
  • Preview11:52
  • Preview04:05
  • Preview02: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
  • Preview10: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

  • Preview03:10
  • READ ME: Essential Information for a Successful Training Experience
    01:01
  • Four Basic Steps When Creating Charts/Graphs
    Preview10:58
  • Additional Features to Help Create Charts/Graphs
    Preview14:56
  • Preview14: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
    Preview15: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
    Preview15: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
  • New Features for Pivot Tables/Charts
    13:20
  • Graphics Tools
    15:07
  • Graphics Tools Part 2
    13:32
  • Exporting Charts and Graphs
    15:09
  • Exporting Charts and Graphs Part 2
    14:59
  • Excel 2010 Advanced Quiz
    35 questions

  • Preview08:16
  • READ ME: Essential Information for a Successful Training Experience
    01:01
  • Learning the Workspace
    Preview09:19
  • Preview08:26
  • Preview08:50
  • Converting and Saving Documents
    09:15
  • Selecting Text; Cut, Copy, Paste; Drag & Drop
    10:22
  • Insert/Overtype; Navigation Pane; Find & Replace
    07:47
  • Hyphenation, Auto-Correct, and Redo
    06:41
  • Text Formatting
    10:07
  • Paragraph Formatting Options
    10:34
  • Formatting with Bullets, Indents, Borders, Shading
    07:11
  • Creating/Saving New Template; Changing Styles
    09:41
  • Managing, Modifying and Deleting New Styles
    08:28
  • Working with/Using Themes
    Preview08:41
  • Inserting/Formatting ClipArt, Pictures
    09:34
  • Using Picture Tools & New Features
    08:52
  • Inserting Screenshots, Using WordArt
    08:10
  • Using SmartArt, SmartArt Tools
    07:35
  • Inserting Tables; Adding Text; Selecting Parts of Tables
    10:09
  • Formatting Tables; Table Tools
    10:38
  • Inserting Charts; Chart Tools
    08:31
  • Creating Charts with Pre-existing Data
    09:44
  • Desktop Publishing Adding Drop Caps, Watermarks, Borders, Page Colors
    10:38
  • Using/Formatting Multi-Columns; Text Boxes
    08:25
  • Inserting/Resizing Shapes
    09:03
  • Stacking, Grouping Objects
    08:39
  • Creating Outline, Sub-Documents
    09:43
  • Expand/Collapse Sections; Document Properties; Cover Pages
    10:45
  • Add Table of Contents: Header & Footer Tools; Quick Parts
    10:17
  • Line-numbering, Adding Bibliography & Index
    10:19
  • Understanding Formatting Marks; Sections Features
    10:25
  • Inserting Symbols, Equations, Auto-Text, Building Blocks
    09:56
  • Inserting Footnotes, Bookmarks, Cross-references
    08:16
  • Setting up Mail Merge Using Wizard
    09:20
  • Manual Mail Merge Set-up
    08:47
  • Spelling/Grammar Check
    10:01
  • Using Thesaurus, Research Option, Translate; Printing Document
    09:38
  • Publishing to Web Publishing & Accessing Word Documents on Web
    10:00
  • Using Document Inspector, Password Protect, Editing Restrictions
    10:00
  • Reviewing & Sharing Reviewing, Sharing and Leaving/Adding Comments
    10:16
  • Customizing Word Customizing with Word Options
    09:41
  • Expanding Word Functionality; Using Macros
    09:14
  • Importing/Exporting, Embedding Document to Other Programs
    11:11
  • Check for Updates, Safe Mode
    08:55
  • Word 2010 Quiz
    34 questions

  • Preview11:13
  • READ ME: Essential Information for a Successful Training Experience
    01:01
  • Preview00:43
  • Overview of Calendar, Appointments, Contacts, Tasks, Notes
    12:16
  • Adding New Accounts, Removing Accounts
    12:28
  • Add Items, To-Do Options and Customization
    10:56
  • Creating New Task, Modifying Details, Recurring Tasks
    12:51
  • Calendar Displays, Set Up/Edit/Delete Appointments
    12:06
  • Using Help Options; Add/Edit/Delete Contacts
    11:52
  • Create, Edit, Forward Notes
    10:06
  • Options, Create, Send Journal Entries
    12:12
  • Customize Quick Access Toolbar & the Ribbon
    11:02
  • Customizing Workspace Views Part 1
    11:13
  • Customizing Workspace Views Part 2
    11:27
  • Managing Data File Folders
    12:51
  • Outlook Connector; Customizing Mail
    12:25
  • Creating Rules for Sent/Incoming Emails
    13:09
  • Formatting Email Messages
    Preview12:06
  • General Mail Options
    12:41
  • Assigning/Completing Tasks
    09:24
  • Forward/Edit/Group Contacts
    11:59
  • Setting Up Meeting Requests; Calendar Options
    12:58
  • Setup RSS Feeds
    11:19
  • Organize RSS Feeds, New Social Connection
    12:26
  • Junk Mail Options, Dealing with Junk Mail
    13:36
  • Filtering Through & Searching for Specific Emails
    12:19
  • Auto Archive Options & Manual Archive
    12:11
  • Email Security & Maintenance
    11:48
  • Outlook 2010 Quiz
    25 questions

  • Introduction
    03:11
  • READ ME: Essential Information for a Successful Training Experience
    01:01
  • Introduction to PowerPoint 2010 Basics
    00:35
  • Preview02:30
  • PowerPoint 2010 Window
    05:15
  • The Ribbon
    05:55
  • The Backstage: Open, Save, Close
    04:19
  • Options
    08:24
  • Different Views
    08:12
  • Introduction to Working with Slides
    00:29
  • Manage Slide Appearance
    14:47
  • Working with Text
    32:03
  • Outlining a Presentation
    10:16
  • Slide Management
    08:43
  • Working with Shapes
    28:06
  • Working with Tables
    25:17
  • Using SmartArt
    24:15
  • Using Templates
    12:52
  • Working with Themes
    16:06
  • Introduction to Beyond Basics
    01:16
  • Using Hyperlinks
    25:42
  • Working with Clips, Pictures, & Screenshots
    25:58
  • Multimedia: Audio & Video
    08:20
  • Animation
    22:34
  • Transitions
    09:18
  • Compare & Merge Presentations
    14:25
  • Sharing with Other Office 2010 Applications
    14:16
  • Introduction to Presenting Your Presentations
    00:34
  • Using Notes
    14:53
  • Creating Handouts
    05:53
  • Printing Presentations and Notes/Handouts
    06:37
  • Automated Self-Running Slide Shows
    11:46
  • Annotating While Presenting
    05:50
  • Concluding the Course
    02:04
  • PowerPoint 2010 Quiz
    35 questions

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

  • Preview10:50
  • READ ME: Essential Information for a Successful Training Experience
    01:01
  • Working with Macros
    Preview15:57
  • AutoExec Macro
    15:42
  • Database Options
    11:40
  • More Database Options
    15:35
  • Renaming Database Objects
    11:13
  • Preview13:34
  • Table and Field Properties
    14:22
  • Validation Rules & Text
    13:31
  • Understanding & Using Keys and Indexes
    15:47
  • Data Normalization
    15:38
  • Types of Relationships
    12:39
  • Maintaining Relationships
    07:29
  • Using & Understanding Queries
    11:47
  • Complex Queries
    16:04
  • Creating Queries and Using Join & Sub-Queries
    16:00
  • Datasheet View
    15:30
  • Preview13:56
  • Using Forms to Maintain Data
    16:04
  • Command Buttons
    14:10
  • Command Buttons Part 2
    14:45
  • Form Features that Need VBA Code
    09:39
  • Understanding When & How to Use VBA
    16:01
  • More about VBA and Using It to Improve Database
    14:46
  • VBA Language Structure & Making a Switchboard
    15:19
  • Error Handling
    16:24
  • Cleaning Up Before Distribution16
    16:48
  • Security Techniques
    15:59
  • External Data & Importng/Exporting Data
    16:39
  • Linking to Excel & Linking to Another Database
    09:25
  • Separating/Splitting Up Forms, Reports, etc from Database
    09:37
  • Options for Making Changes When Database is Multi-User
    14:56
  • Advanced Features for Reports
    12:35
  • Advanced Features for Reports Part 2
    12:50
  • Distributing Application
    15:00
  • Access 2010 Advanced Quiz
    40 questions

  • EXTRA RESOURCE: The Most Frequently Used Excel Shortcuts - Infographic
    00:00
  • EXTRA RESOURCE: The Most Frequently Used PowerPoint Shortcuts - Infographic
    00:00
  • EXTRA RESOURCE: The Most Frequently Used Access Shortcuts - Infographic
    00:01
  • EXTRA RESOURCE: The Most Frequently Used Word Shortcuts - Infographic
    00:00
  • EXTRA RESOURCE: The Most Frequently Used Outlook Shortcuts - Infographic
    00:01

Instructor

Simon Sez IT
460,000+ Students | Wordwide Use 180 Countries |150+ Courses
Simon Sez IT
  • 4.4 Instructor Rating
  • 47,520 Reviews
  • 483,670 Students
  • 166 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 over 5,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 430,000 Udemy students in over 180 countries, Simon Sez IT is the preferred online learning choice for individuals and businesses everywhere. 

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.