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
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
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.
IIT Kanpur Frequently Asked Questions (FAQ's)
Candidates can access the course content for Complete Microsoft Office 2016 at any given time.
Individuals willing to kick-start their careers again and want to upskill can opt for the Complete Microsoft Office 2016 certification course.
Yes, there are highly trained faculty to help guide the students through the Complete Microsoft Office 2016 training.
The total fee for the Complete Microsoft Office 2016 course is Rs 4,237 with 18% additional GST.
Yes, the Complete Microsoft Office 2016 training allows the candidate to learn about various templates in Microsoft Office and tricks to design them.