Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
16 Hour(s) 12 Minute(s)
Language
English
Taught by
Himanshu Dhar
Rating
1 views
Course Overview
Complete Practical training in MS Office 2010 to 2019 and Office 365 in MS Excel, MS Word, MS PowerPoint and MS Access.
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.
Course Content
- 4 section(s)
- 138 lecture(s)
- Section 1 MS Excel
- Section 2 MS Access
- Section 3 MS Word
- Section 4 MS PowerPoint
What You’ll Learn
- 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
Skills covered in this course
Reviews
-
AArchana kashyap
hindi mai samjhaoo
-
JJonathan Valle
The course is very informal and helpful with learning the skills I need to be a data analyst
-
ZZhiping Gao
Great!
-
UUmama Beg
The course was very helpful and very informative. It was a very good match for me.
