Technology TechnologyData Science Data ScienceManagement ManagementDegree Programs Degree ProgramsMoreMore
    Courses
Blog Blog
    Trending Articles
    Course Recommendations
Search Icon
LoginSign Up
IIT Kanpur
IIT Kanpur Logo

Most Powerful Excel Tricks & Shortcuts 
offered by IIT Kanpur

  • Public/Government Institute
  • Estd. 1959

Most Powerful Excel Tricks & Shortcuts
 at 
IIT Kanpur 
Overview

Gain a comprehensive overview of the Excel Tricks & Shortcuts principles and concepts

Duration

6 weeks

Total fee

₹4,237

Mode of learning

Online

Credential

Certificate

Most Powerful Excel Tricks & Shortcuts
 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
Details Icon

Most Powerful Excel Tricks & Shortcuts
 at 
IIT Kanpur 
Course details

Skills you will learn
ExcelConditional FormattingOperationsMacrosAccountingStatisticsInventory management
Who should do this course?
  • For students who use Excel 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 Excel
  • For working professionals who wish to acquire new skills or improve their efficiency in the use of Excel
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
  • Create all types of charts and graphs
  • Boost your hireability through innovative and independent learning
More about this course
  • This course helps you to dive deeper into the nitty-gritty of Microsoft Excel version 2016
  • The course begins with an overview, important things, tricks and basic instructions for MS-Excel 2016 along with most used formulae and functions in it
  • It provides an introduction to spreadsheets functions, and use of Pivot tables. In addition, it also covers some of the Basic formulae and functions, creation of data collection form and summarize report 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 spreadsheet, payment sheet for employees, creation of blank form, and cash flow forecast
  • The course concludes with some of the important topics like creation of business account ledger along with forecast function and data manipulation in time format
Read more

Most Powerful Excel Tricks & Shortcuts
 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 Computer Science and Engineering

Star Icon4.64 years#4 NIRF
129
– / –
₹8 L

Master of Business Administration (MBA)

Star Icon4.72 years#28 Business TodayOffered by IIT Kanpur - Department of Industrial and Management Engineering
78
– / –
₹2.8 L

M.Tech. in Industrial and Management Engineering

Star Icon4.42 yearsOffered by IIT Kanpur - Department of Industrial and Management Engineering
– / –
– / –
₹20 K

Post Graduate Program in Manufacturing for Executives for Visionary Leadership

1 year#28 Business TodayOffered by IIT Kanpur - Department of Industrial and Management Engineering
35
    – / –
– / –
₹13.5 L
View Other 161 CoursesRight Arrow Icon
qna

Most Powerful Excel Tricks & Shortcuts
 at 
IIT Kanpur 

Student Forum

chatAnything you would want to ask experts?
Write here...
Home Icon/Colleges in Kanpur/IIT Kanpur/Courses/Most Powerful Excel Tricks & Shortcuts

Most Powerful Excel Tricks & Shortcuts
 at 
IIT Kanpur 
Contact Information

Google Maps
View On Map
Address

Indian Institute of Technology, Kalyanpur
Kanpur ( Uttar Pradesh)

Phone
05122597200

(For general query)

05122590151

(For admission query)

Email
jee@iitk.ac.in

(For general query)

registrar@iitk.ac.in

(For admission query)

Go to College Website ->