MS Office 2010 Complete Training – Beginner to Expert Level

  • Course level: All Levels


Most of us are aware of MS Word, Excel, PowerPoint & Access but are not efficient, as we dont give so much importance to it and got stuck in workplace because of the lack of knowledge. So become more productive with our online Microsoft Office training courses. Designed to help you become more efficient in the workplace. Our training classes will teach you everything you need to know about creating worksheets, documents, powerpoints, and more.

What Will I Learn?

  • Data management in Excel
  • Documentation expertise in word
  • Creating powerful presentation
  • Database in Access
  • Good understanding of Excel at MIS level
  • Expertise in Text Function
  • Expertise in Logical Function
  • Expertise in Math Function
  • Expertise in Lookup and Reference Function
  • Expertise in Date and Time Function
  • Mastery in Pivot Table and Chart Preparation
  • Mastery in 'What if Analysis' tools
  • Print Option in Excel
  • Data Validation, Filter and Conditional Formatting
  • Mastery in Data organizing Tools in Excel
  • Mastery in Data creation and Data Manipulation in Excel
  • Managing data protection and data sharing in Excel
  • Work with Macro Recording
  • Begin with the basics of creating Microsoft Word documents
  • You will learn how to take full advantage of Microsoft Word
  • Format documents effectively using Microsoft Word Styles
  • Create and Manage Table Layouts
  • Perform Mail Merges to create Mailing Labels and Form Letters
  • Preparing documents for printing and exporting
  • Control page formatting and flow with sections and page breaks
  • Insert Media and Images
  • Working efficiently with quick parts, hyperlink, bookmarking and Cross Reference
  • Using header, footer, page no and table of content
  • Creating hierarchy structure using Smart Art
  • Track and Accept/Reject Changes to a Document
  • At the end of this course, you will be able to create a simple DATABASE in Access from scratch
  • You will know how to create and modify TABLES in Access
  • You will know how to create QUERIES to ask questions of your Access database
  • You will know how to create FORMS for enter data into your tables
  • You will know how to create REPORTS for sharing and presenting your data in a clear, professional way
  • Work confidently with Microsoft PowerPoint
  • Create sophisticated and well-organized PowerPoint presentations

Topics for this course

116 Lessons10h 29m 07s


Excel Structure00:08:14
Cell Properties00:02:48
Autofill Value and Text00:04:51
Autofill Date00:02:28
Autofill Advance Tools00:04:42
Cell Reference00:04:29
Operators Based Equation00:09:01
Math Function00:12:37
Advance Math Function00:07:15
Advance Math Function 200:06:38
Using of Wild Card in Math Function00:02:44
Text Function – Upper, Lower, Proper, Trim00:05:47
Text Function – Right, Left00:03:54
Text Function – Find and Task00:06:13
Text Function – Solution and Nested Left00:05:32
Text Function – Find and Left Nesting00:02:51
Text Function – Mid Function00:03:15
Text Function – Mid Task and Solution00:06:05
Text Function – Concatenate00:03:23
Text Function – Concatenate Task and Solution00:02:08
Text Function – Replace Function00:04:48
Text Function – Replace Task and Solution00:05:05
Text Function – Substitute Function00:04:36
Text Function – Len, Rept, Exact and Search Function00:02:40
Text To Column00:09:00
Workbook Protect00:04:03
Protect Sheet00:07:29
Hide Formulas and Unlocked Cell00:04:14
Protect File with password00:02:31
Share Book00:02:30
If Function – Logical Test00:08:44
If Function – with Equation and task00:03:06
Nested IF Function00:03:53
If Function Advance Example – 100:04:45
If Function Advance Example – 200:04:55
AND , OR Function00:06:42
AND, OR, IF Nested00:05:09
AND, OR Advance Example00:02:19
Pivot Table – Intro00:05:20
Pivot Table – Manage Field Area00:07:18
Pivot Table – Value Field, Report and More00:05:20
Pivot Table – Slicer and Duplicate Pivot00:06:53
Pivot Table – Group To Mange Date and Values00:05:09
Pivot Table – Insert Calculated Field00:03:23
Goal Seek00:07:07
Scenario Manager00:06:29
PMT function – EMI calculator00:04:40
Data Table – Create Loan Table00:07:52
Print Option in Excel – Part 100:11:50
Print Option in Excel – Part 200:08:22
Chart Preparation in Excel00:14:32
Chart Preparation – Advance00:05:23
Chart Preparation – Customize00:03:56
Conditional Formatting in Excel00:05:24
Conditional Formatting – Types Of Rules00:11:32
Conditional Formatting – Mange Rules00:04:12
Conditional Formatting – New Rules 100:03:11
Conditional Formatting – New Rules 200:04:37
Data Validation00:10:48
Data Validation – Input Message and Error Alert00:04:58
Vlookup Function00:08:12
Vlookup with Iferror Function00:05:09
Vlookup Nesting with If Function00:02:23
Hlookup Function00:02:45
Match Function00:03:43
Index and Match Nested00:08:20
Vlookup Array00:04:37
Vlookup Column Trick00:04:36
Vlookup TRUE00:03:49
Advance Vlookup Trick00:06:23
Macro Recording Part 100:15:19
Macro Recording Part 200:05:21
Macro Recording Part 300:03:12
Types Of Ways To Run Macros00:06:01




About the instructor

5.00 (47 ratings)

6 Courses

3890 students

Student Feedback


Total 4 Ratings

4 ratings
0 rating
0 rating
0 rating
0 rating

It's a really very important and perfect course for me, and on the other hand, the examples are also so intelligent and experienced so that is why I should accept that, it helps me to solve my daily problems.

I learned so much I never knew! I have been so used to only learning and needing the basics and I think knowing all that I know now I can take advantage of all that Microsoft Office has to offer. Thank you.

Excellent course very happy so far.

Very good platform for learn to excel, PowerPoint, word and access.


Material Includes

  • 10.5 hours on-demand video
  • 116 Lesson Videos
  • 11 downloadable resource
  • Full lifetime access


  • Basic Computer Knowledge

Target Audience

  • Anyone want to expertise MS Office
  • For career as Back Office