The Complete Microsoft Office 2016
offered by IIT Kanpur

4.5 /5

(2 Reviews)

Public/Government Institute
Estd. 1959

The Complete Microsoft Office 2016
at
IIT Kanpur
Overview

Covers some of the important topics like the creation of business account ledger along with forecast function and data manipulation in time format

Duration	6 weeks
Total fee	₹4,237
Mode of learning	Online
Credential	Certificate

The Complete Microsoft Office 2016
at
IIT Kanpur
Highlights

Earn a certificate of completion from E & ICT Academy, IIT Kanpur
Learn from online lectures with high-quality videos
Hands on training for practical exposure

The Complete Microsoft Office 2016
at
IIT Kanpur
Course details

Skills you will learn

Excel Conditional Formatting Operations MS Office Macros Accounting Statistics Inventory management

Who should do this course?

For students who use Word regularly in their studies and wish to learn advanced techniques to get the most out of this versatile program
For teachers/faculties who wish to acquire new skills or improve their efficiency in the use of Word
For working professionals who wish to acquire new skills or improve their efficiency in the use of Word, can take this course

What are the course deliverables?

Learn to use different functions like Pivot, Conditional formatting, Excel charts, etc
Efficiently use the various basic, intermediate and advanced level features of Microsoft Excel
Automate repetitive tasks using Macros
To convert PDF files to word documents without using any software
Create Microsoft word documents containing images, tables, etc
Design flyers create invitation cards, and letterheads, etc
Create animated Slides, Graphics, Rotating Objects
Create Photo Albums, attractive and professional presentations
Create videos from PowerPoint Slide and voice narration
Boost your hireability through innovative and independent learning

More about this course

The course begins with an overview, important things, tricks, and basic instructions for MS-Excel 2016 along with the most used formulae and functions in it
After that, it provides an introduction to spreadsheet functions and the use of Pivot tables
It also covers some of the Basic formulae and functions, the creation of data collection forms, and summarisation reports using MS Excel 2016, Gantt chart, if-then statement, copy and extend functions
The course also covers topics such as basic operations, inventory management, charts, application of statistics function, budget creation using spreadsheets, payment sheets for employees, creation of blank form, and cash flow forecast
Then it covers some of the important topics like the creation of business account ledger along with forecast function and data manipulation in time format

The Complete Microsoft Office 2016
at
IIT Kanpur
Curriculum

Microsoft Excel 2016 Overview for Beginners

3-Important things of MS Excel 2016

MS Excel 2016- Tricks for Beginners

MS Excel 2016- Basics Instructions

5 Most used formulas in MS Excel 2016

Introduction of Spread Sheets - Functions

MS Excel 2016 - Use of Pivot Table

Beginning with MS Excel 2016 Part 1- Introduction

Beginning with MS Excel 2016 - Calculations

Beginning with MS Excel 2016 - Functions

Applications of Mail Merge - Create Labels

9 Regularly used Functions of MS Excel 2016

Other courses offered by IIT Kanpur

B.Tech. in Aerospace Engineering

4.64 years#4 NIRF

Seats Offered

Exams Accepted

Median Salary

– / –

Total Tuition Fees

₹8 L

Get Fee Details

B.Tech. in Electrical Engineering

4.84 years#4 NIRF

Seats Offered

192

Exams Accepted

Median Salary

– / –

Total Tuition Fees

₹8 L

Get Fee Details

B.Sc. in Economics

4.74 years

Seats Offered

Exams Accepted

– / –

Median Salary

– / –

Total Tuition Fees

₹8 L

Get Fee Details

B.Sc. in Mathematics and Scientific Computing

4.64 years

Seats Offered

Exams Accepted

– / –

Median Salary

– / –

Total Tuition Fees

₹8 L

Get Fee Details

View Other 161 Courses

The Complete Microsoft Office 2016
at
IIT Kanpur
Students Ratings & Reviews

4.5/5

2 Ratings

4-5
1
3-4
1

Rishabh Pahuja

The Complete Microsoft Office 2016

Offered by IIT Kanpur - Indian Institute of Technology

Learning Experience: Experience was Great. Excel was taught in a basic manner which helped to understand it in a better manner

Faculty: Facults way of teaching was excellent, helped me learn a lot by practical training Course Curriculum include Basic Excel, Advance Excel and short tricks in excel. Assigment was taken at the end of the course which consist of MCQs

Reviewed on 4 Feb 2023Read More