Interested in this College?
Get updates on Eligibility, Admission, Placements Fees Structure

Quick Facts

Medium Of Instructions	Mode Of Learning	Mode Of Delivery
English	Self Study, Virtual Classroom	Video and Text Based

Course Overview

Over the years, Microsoft Office has become one of the essential tools used in everyday functions. The Complete Microsoft Office 2016 training is one of the most popular and in-demand courses to master its fundamentals. The curriculum allows the learners to understand the software and its complete application from scratch.

IIT Kanpur’s Complete Microsoft Office 2016 certification course is an online programme, offered through their E&ICT Academy. The extensive curriculum teaches the candidates about the entire tool in six weeks. The institute’s top faculty deliver this programme through high-quality videos with updated content to match the current industry trends and applications. Candidates who enrol for the course also get 24-hour access to the 22 hours of total study material for this curriculum.

While undertaking the Complete Microsoft Office 2016 certification syllabus, the candidates will learn about the tricks and tools for using the software efficiently, along with a thorough and detailed understanding of additional Office tools. On completing the course, the students are rewarded with a payable certificate to recognize their achievement.

The Highlights

Six-week access to study material
Online classes
IIT Kanpur and MeitY’s joint initiative
Expert faculty
24×7 access to course material
Certificate course
High-quality videos
Updated content
No prerequisites for admission
22 hours of curriculum content

Programme Offerings

Online Classes
Six-Week Access
Expert Faculty
24×7 Access
High-Quality Videos
Certificate Course
22 Hours of Content
Updated Content

Courses and Certificate Fees

Certificate Availability	Certificate Providing Authority
yes	IIT Kanpur

The Complete Microsoft Office 2016 Online Course’s total fee is Rs 4237 + 18% GST.
The candidate can make an online payment using a credit card or debit card, the payment can also be processed through net banking.

Complete Microsoft Office 2016 fee structure

Course Name	Fee in INR
Complete Microsoft Office 2016	Rs 4,237 + 18% GST

Eligibility Criteria

Certification qualifying details

Course-takers must submit all programme assignments and pass the MCQ assessment to gain the Complete Microsoft Office 2016 certification.

What you will learn

Knowledge of ExcelMS Office skills

On completing the Complete Microsoft Office 2016 Online Course, you will have a concrete understanding of the following topics:

Using Excel charts, Pivot, Conditional formatting, and other functions
Using Macros to automate repetitive tasks
Using the advanced, basic, and intermediate-level MS Excel features
Converting PDFs to Word documents without any software
Designing flyers
Creating MS Word documents containing tables, images, etc.
Creating letterheads, invitation cards, etc.
Creating Photo albums, graphics, slides, rotating objects, and attractive presentations
Voice narration
Using Powerpoint Slide for creating videos

Who it is for

Teacher

The Complete Microsoft Office 2016 training can be taken up by anyone willing to upskill and learn the Microsoft applications. It is best suited for students, teachers, professionals from various sectors.

Admission Details

Step 1: For enrolling in the Complete Microsoft Office 2016 Online Course, locate the enroll button on the website - https://ict.iitk.ac.in/product/tips-to-using-ms-office-2016/.

Step 2: Proceed to fill out all the required information about yourself. You must either register for a new account or use a pre-existing one to sign in.

Step 3: Complete the registration by securing the course payment through the ‘cart’ portal.

Application Details

Learners don’t need to fill out any form. They can enroll on the Complete Microsoft Office 2016 course to proceed with their training. For this, they can either sign up via their educational qualification, full name, contact information, department, and other vital information. Alternatively, if they have an existing IIT Kanpur ID, they can use it to log in and enroll.

The Syllabus

Three Important things
Beginner’s overview
Learn Moderate Skills
Beginner’s tricks and Basics Instructions
Spread Sheets – Functions
Five Most used formulas
Use of Pivot Table
Calculations
Introduction
Functions
Nine Regularly used Functions
Mail Merge - Create Labels
Important Shortcuts
Basic Functions and Formulas
Create Data Collection Forms
Job Interviews questions
Effective Use
18 Tips, Techniques, and Basic Operations
Creating Summarize Report
Inventory Management
Function’s Keyboard Shortcuts
Data Manipulation, Function, and Chart part 1, 2, 3, 4
Charts
Statistics Function and its application
Using the Gantt Chart
Copying and Extending Functions
"If-Then" Statement
Excel Assignment Solution
Spreadsheet - Creating Budgets
Creating and Designing Blank Form
Creating Employees’ Payment Sheet
Creating Cash Flow Forecasts
Time Format - Manipulation of Data
Forecast Functions
Making Business Account Ledgers

Converting PDFs to Word files without the software
Adding fonts in MS Word 2016
Using Tables in MS Word 2016
Inserting images in other images using MS Word 2016
Using tab stops to align text in MS Word 2016
Inserting images in Table using MS Word 2016
Creating fillable forms in MS Word 2016
Writing text on images in MS Word 2016
Making letterheads in MS Word 2016
Aligning texts in left and right of the same line in MS Word 2016
Advanced and basic tricks of MS Word 2016
Creating long lines through MS Word 2016
Inserting page numbers from specific pages in MS Word 2016
Inserting Tick Symbol in MS Word 2016
Flipping and reversing text content in MS Word 2016
Using multiple columns in Word document
Creating tables using MS Word 2016
Designing Flyers using MS Word 2016
Eliminating Unwanted Pages in MS Word 2016
MS Word 2016 Interface
Heading, Table of Contents, and Heading Numbering in MS Word 2016
Creating forms in MS Word 2016
Creating flowcharts using MS Word 2016
MS Word 2016 Mail Merge
Creating Animated Slides
Making invitation cards in MS Word 2016
Creating Attractive, Professional, Beautiful Presentations
Creating Hyperlinks
Creating Photo Album
Using PowerPoint Slide to create Videos
Creating Basic Presentations
Creating Animated Slides Using Graphics and Images
Creating Voice Narration
Creating Rotating Objects

Evaluation process

The exam for Complete Microsoft Office 2016 programme has an MCQ format and entails qualification marks of 60%. Successful candidates receive accreditation.