MS Office 2013, 2016, 2019 and Office 365 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 13 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.
Download the practice file
Relative Reference
Absolute Reference
Mixed Reference
How to use Operation in Excel to do equation
BODMAS in EXCEL
How to apply functions
SUM()
AVERAGE()
COUNT, COUNTA, COUNTBLANK
MAX, MIN
LARGE, SMALL
Nested Function
Data Validation Types
Input Message
Error Alert Customization
Introduction to Text Function
UPPER()
LOWER()
PROPER()
TRIM()
Nesting TRIM with other Function
LEFT()
RIGHT()
FIND()
Advance FIND()
Nesting FIND with RIGHT() & LEFT()
MID Function
Nested MID
CONCATENATE()
Nesting CONCATENATE with other Text Function.
REPLACE()
Nested REPLACE()
How to use Text to Column
Delimited & Fixed Width
Date Format through Text to Column
Date Filter
Filter by Color
How to naming Ranges
Advantages of it
Types of Hyperlink
How to Apply it
Logical Test
Introduction to If Function
Nested If Examples
AND() Function
OR() Function
Nested IF() with AND() & OR()
Advance Examples
How to create EMI Calculator
Apply PMT() Function
How to create data table
How to format data table
How to apply Goal seek
Get the desired output from complicated equation through Goal Seek
How to Apply Scenario Manager
How to merge Scenario
How to get summary
MATCH()
INDEX()
Nesting both to get desired result
How to use VLOOKUP() TRUE option
Start with Excel Chart
Understanding Layout options
Chart Format
Chart Design
Handling Axis and Series
Handling Data Series and Legends
Customize options
Practice files available in Resources.
How to set and customize margin
page orientation and paper size
Print Area & Page Break
Set Image as a background
How to Repeat heading on each page
print pattern
customize header and footer
How to apply image like a watermark in Excel
How to protect workbook
how and when you may use this option
How to Protect sheet
how to allow cells for changes
How to enable share workbook option
how and when to use it
What are the common date entry mistakes?
How to overcome?
System Date format impact
Date Format
Time Format
Adding Date and Time
DAY(), MONTH(), YEAR()
HOUR(), MINUTE(), SECOND()
DATE(), TIME()
Nesting Methodology
Google 
Facebook