OpenCourser brand icon
Sign in
We may earn an affiliate commission when you visit our partners.

MS Office Complete Training - Beginner to Expert Level

Himanshu Dhar

MS Office 2019 and Office 365 additional features has been updated.

Most of us are aware of MS Word, Excel and PowerPoint but are not efficient, as we don’t 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 course, 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, presentation and more.

Read more

MS Office 2019 and Office 365 additional features has been updated.

Most of us are aware of MS Word, Excel and PowerPoint but are not efficient, as we don’t 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 course, 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, presentation and more.

This course is intended for individuals and office workers who need to master the features of the most demanding office utility software that is Microsoft Office. In more than 14 hours of video presentations, you'll learn everything you need to know to make your office work more efficiently.

  • Excel Beginner / Intermediate: Create basic spreadsheets and use expense tracking formulas.

  • Excel Advanced: Use complex formulas and data analysis about your company's revenue and expense models.

  • Word: Create documents, embed videos, and set up online collaboration for shared work or school projects.

  • PowerPoint: Create an elegant presentation for your next business meeting with animation, audio / video, and collaboration tools.

  • Access: Learn database management system that combines the relational Access Database Engine with a graphical user interface.

When you complete this course, you will become a work efficiency expert using the tools available in Microsoft Office.

Enroll now

What's inside

Learning objectives

  • Data management in ms excel
  • Documentation expertise in ms word
  • Creating powerful presentation in powerpoint
  • Learn database in ms access
  • Good understanding of excel at mis level
  • Updated features of ms office 2013, 2016 & 2019 like power tools, quick analysis, textjoin, xor, ifs, draw tab and many more
  • Expertise in text function
  • Expertise in logical function
  • Expertise in math function
  • Expertise in lookup and reference function with latest xlookup 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
  • Working with power pivot and power map
  • 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
  • Show more
  • Show less

Syllabus

MS Excel
Excel Intro - New File and Title Bar
Customize Ribbons and Quick Access Toolbar

Follow the lecture in a sequence for better understanding. Download the practice file from the resource and practice side by side.

Read more

Quiz Time

Text Function - Left, Right and Find Function Nesting
Data Entry and Formatting
Autofill in Excel
Flash Fill in Excel

Quiz time

Cell reference
Operators based Equation
Math Function
Advance Math Function
Database Math Function
Text Function - Upper, Lower, Proper, Trim
Text Function - Right, Left and Find Function
Text Function - Find Related Task Solution
Text Function - MID Function
Text Function - Concatenate Function
Text Function - Concatenate Task Solution
Concat and Textjoin Function
Text Function - Replace Function
Text Function - Replace Task Solution
Text Function - Substitute Function
Text Function - Rept, Len and Task
Task Solution - Substitute and Len Nesting
Numbervalue Function in Excel
Text to Column
Workbook Protect
Protect Sheet
Hide Formulas and unlocked Cell
Protect File with Password
If Function - Logical Test
If Function - Nested IF Function
IF Function Task Solution
IF Function - Advance Level Task
IF Function - Advance Level Task Solution
IFS in Excel
AND , OR Function
XOR Function
Pivot Table in Excel

Practice File available in Resources

Goal Seek - What if Analysis
Solver in Excel
Scenario Manager - What if Analysis
PMT function - EMI Calculator
Data Table - Create Loan Table
Pduration Function
Print Option in Excel - Part 1
Print Option in Excel - Part 2
Draw Tab in Excel
Chart Preparation
Chart Preparation - Designing and Format
Chart Customization Part 1
Chart Customization Part 2
Pie Chart in Excel
Power Map in Excel
Quick Analysis and Chart Recommendation
Filter Option in Excel
Date and Color Filter
Advanced Filter Option
Sorting and Custom Sort
Group, Ungroup and Subtotal
Conditional Formatting - Apply
Conditional Formatting - Types of Rules
Conditional Formatting - Mange Rules
Data Validation
Data Validation - Input message and Error Alert
Define Name Feature
Hyperlink in Excel
Vlookup Function
Vlookup with Iferror
Array Vlookup Function
Hlookup Function in Excel
Match and Index Function
Match and Index Nesting
Vlookup TRUE
Lookup and Reference Function Trick

Microsoft recently announced the upcoming release of a new function called XLOOKUP (Available in Office 365 only). This function will be replacing the widely used VLOOKUP, HLOOKUP and INDEX/MATCH functions to run searches in a table of Excel data. Although it may have taken many years to get to this point, Excel users now have a new function that is more user-friendly, more flexible and avoids some frustrating VLOOKUP mistakes.

Date and Time setting
Date and Time Format
Date and Time Functions
DATEDIF Function
NETWORKDAYS Function
Macro Recording in Excel
Macro Recording Example in Excel
Ways to Run Macros in Excel
MS Access
Access Introduction
Create Table in MS Access
Create Form from Table
Create Blank Form in Access
Creating Report in Access
How to Import and Export in Access
Query in Access
SQL Queries part 1
SQL Queries part 2

Good to know

Know what's good
, what to watch for
, and possible dealbreakers
Covers MS Office 2013, 2016, and 2019, which provides learners with a comprehensive understanding of the software's evolution and features across different versions
Teaches skills in Excel, Word, PowerPoint, and Access, which are essential for creating documents, presentations, and managing data efficiently in a professional setting
Includes hands-on practice files and quizzes, which allows learners to reinforce their understanding and apply their knowledge in practical scenarios
Explores 'What-If Analysis' tools in Excel, which enables learners to make informed decisions based on data-driven scenarios and predictions
Features coverage of the XLOOKUP function, which is only available in Office 365, so learners without a subscription may not be able to practice this skill
Uses MS Office 2019, which may not reflect the most up-to-date features available in the latest versions of Microsoft 365

Save this course

Save MS Office Complete Training - Beginner to Expert Level to your list so you can find it easily later:
Save

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in MS Office Complete Training - Beginner to Expert Level with these activities:
Review Basic Excel Functions
Strengthen your understanding of fundamental Excel functions before diving into more advanced topics. This will provide a solid foundation for the course.
Browse courses on SUM
Show steps
  • Identify the most common Excel functions.
  • Practice using these functions with sample data.
  • Review online resources for function syntax and examples.
Read 'Microsoft Excel 2019 Bible'
Supplement your learning with a comprehensive guide to Excel. This book provides detailed explanations and examples for all Excel features.
View Putting Knowledge to Work on Amazon
Show steps
  • Obtain a copy of 'Microsoft Excel 2019 Bible'.
  • Read chapters relevant to the course syllabus.
  • Practice the examples provided in the book.
Excel Formula Challenge
Sharpen your Excel skills by completing a series of formula-based challenges. This will reinforce your understanding of functions and data manipulation.
Show steps
  • Find online resources with Excel formula challenges.
  • Attempt to solve each challenge using appropriate formulas.
  • Compare your solutions with the provided answers.
Four other activities
Expand to see all activities and additional details
Show all seven activities
Create a Personal Budgeting Spreadsheet
Apply your Excel knowledge by creating a practical budgeting tool. This will help you solidify your understanding of formulas, data validation, and chart creation.
Show steps
  • Define categories for income and expenses.
  • Create formulas to calculate totals and track spending.
  • Use charts to visualize your budget data.
PowerPoint Presentation on a Topic of Interest
Practice your PowerPoint skills by creating a presentation on a topic you are passionate about. This will help you master slide design, animation, and multimedia integration.
Show steps
  • Choose a topic that interests you.
  • Create an outline for your presentation.
  • Design visually appealing slides with relevant content.
  • Incorporate animations and transitions to enhance engagement.
Read 'Microsoft Access 2019 Step by Step'
Enhance your Access skills with a step-by-step guide. This book provides practical examples and exercises to reinforce your understanding of database concepts.
View Microsoft Excel Step by Step (Office 2021 and... on Amazon
Show steps
  • Obtain a copy of 'Microsoft Access 2019 Step by Step'.
  • Work through the exercises in the book.
  • Experiment with different database designs.
Automate a Task with Excel Macros
Extend your Excel skills by learning to automate repetitive tasks with macros. This will help you understand VBA programming and improve your efficiency.
Show steps
  • Identify a repetitive task in Excel.
  • Record a macro to automate the task.
  • Modify the macro code to customize its functionality.
  • Test the macro to ensure it works correctly.

Career center

Learners who complete MS Office Complete Training - Beginner to Expert Level will develop knowledge and skills that may be useful to these careers:
Executive Assistant
An executive assistant needs to be highly proficient in office software which is what this course provides. Executive assistants are frequently responsible for preparing documents, managing data, and creating presentations, so the training in Microsoft Word, Excel, and PowerPoint is directly relevant. Moreover, skills in data management and reporting, provided by lessons on MS Access and Excel, assist with the executive assistant's daily responsibilities. This course's focus on data manipulation and presentation will help an executive assistant become highly effective.
See salaries and explore the career path for Executive Assistant
Office Manager
An office manager needs to be highly competent with office software and this course helps build that competence. Office managers often handle multiple administrative tasks including documentation, data analysis, and presentation creation. Skills in Microsoft Word, Excel, and PowerPoint, all covered in this course, are crucial for this role. Furthermore, an office manager is often tasked with setting up systems for data management, so the course's MS Access lessons are especially useful. The content on data validation, manipulation, and protection in Excel directly translates to improving workflow in an office setting. An office manager would greatly benefit.
See salaries and explore the career path for Office Manager
Administrative Assistant
An administrative assistant relies heavily on proficiency in office software, making this course highly relevant. Administrative assistants regularly create documents, manage data, and prepare presentations. This course, with its focus on Microsoft Word, Excel, and PowerPoint, directly equips individuals with the necessary skills. The course teaches how to create documents, manage spreadsheets, and design presentations, all of which are daily tasks for an administrative assistant. Furthermore, this course also teaches database management with MS Access, a skill that may be useful for certain administrative roles.
See salaries and explore the career path for Administrative Assistant
Human Resources Assistant
A human resources assistant needs proficiency in office software for managing employee data and creating reports, so this course is highly applicable. The course's lessons in Microsoft Word, Excel, and PowerPoint are beneficial for creating documents, managing data, and preparing presentations. This course also provides instruction in data management with MS Access, which can be used in HR databases. Furthermore, the course's focus on data validation and protection in Excel is useful for handling sensitive employee data. A human resources assistant will find this training essential.
See salaries and explore the career path for Human Resources Assistant
Accountant
An accountant will find this course extremely useful, especially its training in MS Excel. Accountants use Excel for financial data management and report generation. The course's deep dive into Excel formulas, data analysis, and pivot tables directly aligns with the daily tasks of an accountant. The training in data protection, manipulation, validation, and organization in Excel are also very important. An accountant can become very efficient with these vital skills. This course is strongly applicable.
See salaries and explore the career path for Accountant
Training Coordinator
A training coordinator needs proficiency in office software for creating training materials, presentation and course management so this course is highly relevant. This course covers the most demanded applications for this work including Microsoft Word, Excel, and PowerPoint. A training coordinator can use skills learned in this course to create training documents, presentations, and materials. Further, this course also offers training in data management, which helps with managing course enrollments and tracking. A training coordinator can become extremely productive with the training offered in this course.
See salaries and explore the career path for Training Coordinator
Data Entry Clerk
A data entry clerk will find this course extremely beneficial since it is focused on mastering Microsoft Office, especially Excel. A data entry clerk spends significant time working with spreadsheets and databases. This course includes extensive training on Excel, covering topics like data manipulation, formulas, and data analysis. The lessons in MS Access will also help a data entry clerk understand and manage databases. The course's focus on data validation, organization, and protection is directly applicable to the daily tasks of a data entry clerk. Those who want to be highly productive in this role would do well to complete this course.
See salaries and explore the career path for Data Entry Clerk
Research Assistant
A research assistant uses the tools covered in this course on a daily basis, so this course is highly beneficial. Research assistants need knowledge of data management, documentation and creating presentations, so skills in MS Excel, MS Word and MS PowerPoint are needed. This course teaches data management in Excel and MS Access, report creation in Excel, documentation in Word, and presentation design in PowerPoint. Such skills are essential for organizing and presenting research data. This course is strongly recommended for a role in research.
See salaries and explore the career path for Research Assistant
Project Coordinator
A project coordinator often uses Microsoft Office applications to manage project documentation and track progress, so this course is very applicable. Knowledge of Microsoft Word, Excel, and PowerPoint, as taught in this course, is essential for project documentation, data analysis and creating reports. Furthermore, this course's training in data management and reporting using Excel, including pivot tables and 'What if Analysis,' will assist with project tracking and reporting. The course material on creating and managing documents is vital. A project coordinator will greatly benefit.
See salaries and explore the career path for Project Coordinator
Sales Support Specialist
A sales support specialist uses Microsoft Office applications to generate sales reports and presentations, so this course is very relevant. The course provides training in Microsoft Word, Excel, and PowerPoint, which are essential tools for a sales support specialist. Skills in managing spreadsheets, creating sales presentations, and documenting sales processes, are all skills that will be honed in this training. This course helps with data analysis using Excel, which allows a sales support specialist to track sales performance. A sales support specialist will benefit from this training.
See salaries and explore the career path for Sales Support Specialist
Financial Analyst
A financial analyst will find the training in Microsoft Excel exceptionally useful. Financial analysts heavily rely on Excel for data analysis, financial modeling, and reporting. The course's expertise in complex formulas, data analysis tools, pivot tables, and what-if analysis using Excel is directly applicable to their tasks. Furthermore, the course covers data organization and manipulation which will help a financial analyst with financial data. While this role often requires an advanced degree, this course may be useful to building Excel skills.
See salaries and explore the career path for Financial Analyst
Report Analyst
A report analyst creates reports derived from data, making this course helpful. Report analysts need strong skills in Microsoft Excel, including proficiency in formulas, data analysis, and chart creation, all covered in this course. Furthermore, the course's lessons on pivot tables, 'What If Analysis,' and report preparation in Excel directly align with the daily tasks of a report analyst. The training in data validation, organization, and manipulation using Excel, will improve a report analyst's accuracy and efficiency. While this role may require advanced training, this course may be useful.
See salaries and explore the career path for Report Analyst
Business Analyst
A business analyst often relies on data analysis and reporting skills, making this course helpful. Business analysts use Excel extensively for data manipulation, analysis, and visualization, all of which are taught in this course. The lessons on using complex formulas, data analysis tools including pivot tables, and 'What If Analysis' are particularly relevant. Furthermore, the training in creating professional reports and presentations in Excel and PowerPoint will enable a business analyst to present findings clearly and effectively. While this role may require advanced training, this course may be useful.
See salaries and explore the career path for Business Analyst
Technical Writer
A technical writer creates documentation, and this course provides relevant skills. The course provides expertise in formatting and creating documents with Microsoft Word. The course's focus on inserting media, using headers and footers, and creating tables and tables of contents are directly beneficial. As a technical writer often needs to collaborate, the course's instruction in online collaboration is also valuable. A technical writer can improve their efficiency with this training. This course may be useful to a technical writer.
See salaries and explore the career path for Technical Writer
Marketing Assistant
A marketing assistant often needs skills in creating documents and presentations, making this course useful. The course's focus on Microsoft Word and PowerPoint is highly relevant. A marketing assistant can use these skills to create marketing materials, reports, and presentations. The course also covers data management in Excel, which can help with tracking campaign results. A marketing assistant can enhance their productivity with this course. This course may be useful to a marketing assistant.
See salaries and explore the career path for Marketing Assistant

Featured in The Course Notes

This course is mentioned in our blog, The Course Notes. Read one article that features MS Office Complete Training - Beginner to Expert Level:
Microsoft Office Essentials: Online Courses
20 minute read

Reading list

We've selected two books that we think will supplement your learning. Use these to develop background knowledge, enrich your coursework, and gain a deeper understanding of the topics covered in MS Office Complete Training - Beginner to Expert Level.
Cover image
Putting Knowledge to Work
Save
Comprehensive guide to Excel 2019, covering everything from basic to advanced features. It serves as an excellent reference for users of all skill levels. It provides in-depth explanations and practical examples that complement the course material. This book is commonly used as a reference by industry professionals.
Putting Knowledge to Work
Paperback
Check
Putting Knowledge to Work
Kindle Edition
Check
Cover image
Microsoft Office Step by Step (Office 2021 and...
Save
Provides a hands-on approach to learning Microsoft Access 2019. It guides you through the process of creating and managing databases with clear instructions and practical examples. It is particularly useful for beginners who want to learn the fundamentals of Access. This book adds more depth to the Access portion of the course.
Microsoft Excel Step by Step (Office 2021 and...
Paperback
$$
Microsoft Office Step by Step (Office 2021 and...
Paperback
$$
Microsoft Excel Step by Step (Office 2021 and...
Kindle Edition
$$
Microsoft Office Step by Step (Office 2021 and...
Kindle Edition
$$

Share

Help others find this course page by sharing it with your friends and followers:
Facebook
LinkedIn
Reddit
X
Link
Email

Similar courses

Similar courses are unavailable at this time. Please try again later.
Effort
16 total hours
Via
Udemy
Instructor
Himanshu Dhar
Language
English
Good to know
Covers MS Office 2013, 2016, and 2019, which provides learners with a comprehensive understanding of the software's evolution and features across different versions
Teaches skills in Excel, Word, PowerPoint, and Access, which are essential for creating documents, presentations, and managing data efficiently in a professional setting
Includes hands-on practice files and quizzes, which allows learners to reinforce their understanding and apply their knowledge in practical scenarios
Explores 'What-If Analysis' tools in Excel, which enables learners to make informed decisions based on data-driven scenarios and predictions
Features coverage of the XLOOKUP function, which is only available in Office 365, so learners without a subscription may not be able to practice this skill
Uses MS Office 2019, which may not reflect the most up-to-date features available in the latest versions of Microsoft 365
Featured in The Course Notes
Read one article that features this course, MS Office Complete Training - Beginner to Expert Level from our blog, The Course Notes:
Microsoft Office Essentials: Online Courses
20 minute read
Share and help others discover this course.
Facebook LinkedIn X Reddit Link Email
Don't miss out
Enroll today to gain access to this course
Enroll in this course
Our mission

OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.

Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.

Find this site helpful? Tell a friend about us.

Affiliate disclosure

We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.

Your purchases help us maintain our catalog and keep our servers humming without ads.

Thank you for supporting OpenCourser.

© 2016 - 2025 OpenCourser