Tutorialspoint

Excel 2016 Essential Training

person icon Sam Parulekar

Excel 2016 Essential Training

Learning Excel Step by Step

updated on icon Updated on Oct, 2023

language icon Language - English

person icon Sam Parulekar

architecture icon Excel,Office Productivity

Lectures -53

Resources -37

Duration -4.5 hours

price-loader

30-days Money-Back Guarantee

Training 5 or more people ?

Get your team access to 19,000+ top Tutorialspoint courses anytime, anywhere.

Course Description

Start mastering Excel, the world's most popular and powerful spreadsheet program, with Excel expert Sam Parulekar. Learn how to best enter and organize data, perform calculations with simple functions, work with multiple worksheets, format the appearance of your data and cells, and build charts and PivotTables. Other lessons cover the powerful IF, VLOOKUP, and COUNTIF family of functions; the Goal Seek, Solver, and other data analysis tools; and automating tasks with macros.

This is a very easy to learn course as it is taught in a simple step by step manner.
Example files have been provided for practice.

WIIFM (What's in it for me?)

By the end of this course you would be able to comfortably work in excel, do data analysis and be able to present your data in a presentable format.

Background or Experience requirements.

This course does not expect any previous background of Excel. It starts from scratch and makes you comfortable with Excel.

Who should do this course?

This course is ideal for Data Entry Operators, MIS Executives, MIS Analyst, Data Analyst, Business Analyst any person who wants to enter and maintain his data.

Ideal for Students, Home Makers and Teachers as well.

Contains advance options like Introduction to Macros and Mail merge as well.

How can this course help you?

This course can help you to organize data and perform financial analysis. 

It can be used across all business functions and at companies from small to large.

The main areas where this course can help you would include:

  • Data entry

  • Data management

  • Accounting

  • Financial analysis

  • Charting and graphing

  • Introduction to programming

  • Time management

  • Task management

  • Financial modeling

  • Customer relationship management (CRM)

  • Almost anything that needs to be organized!

Goals

What will you learn in this course:

  • Excel Introduction
  • Understanding the Excel Interface
  • Goal Seek
  • Scenario Manager
  • Data Table
  • Autofill Series and Flash Fill
  • Data Validation
  • Pivot Tables
  • Introduction to Macros
  • Mail Merging with Excel Data

Prerequisites

What are the prerequisites for this course?

  • Basic Computer Fundamentals and Terminologies
  • A Computer with Windows or MAC OS and Excel 2016 installed
  • Minimum 8 GB RAM
  • Internet Connection
Excel 2016 Essential Training

Curriculum

Check out the detailed breakdown of what’s inside the course

Introduction
1 Lectures
  • play icon WIIFM - What's in it for me? 02:10 02:10
Getting Started with Excel
10 Lectures
Tutorialspoint
Entering Data
5 Lectures
Tutorialspoint
Working with Formulas and Functions
7 Lectures
Tutorialspoint
Formatting
7 Lectures
Tutorialspoint
Data Tools
6 Lectures
Tutorialspoint
Filling and Searching Data
5 Lectures
Tutorialspoint
Organizing Data and Subtotaling
3 Lectures
Tutorialspoint
Pivot Tables
7 Lectures
Tutorialspoint
Mail Merge
2 Lectures
Tutorialspoint

Instructor Details

Sam Parulekar

Sam Parulekar

Sam Parulekar is the founder and CEO of I-MIND Training Solutions and Consultancy. He is a graduate from Mumbai University. After gaining sufficient applauds on the training front, he identified that he is destined for training and there was no looking back from that point on wards. In 1992, he started his own training institute which ran successfully for 13 years, making its mark as pioneers in Computer Training. Later he took a brief sabbatical and worked as a Training Manager in Wipro. He resigned in 2012 when he decided that it is better to build his own dream. He strongly believes in the maxim that “If you are not busy building your own dream, you would be busy building others dream”. During his two decades of experience he has trained many corporate and individuals in Computer and Behavioral programs. He has also helped many small scale companies set up and establish their brands. He feels that it is time to redeem and wants to share his experience and help others build their dreams. He is also a certified Yoga Teacher and strives to implement yoga principles in his training programs so that the participants become more receptive and better healthy individuals. He has written more than 20 books on management and behavioral topics which are available on internet sites. He is an ardent lover of music and reads voraciously. In his spare time he is either writing books or composing music on his piano, guitar and flute. He lives in Mumbai with his wife Harshada and his mother.

Course Certificate

User your certification to make a career change or to advance in your current career. Salaries are among the highest in the world.

sample Tutorialspoint certificate

Our students work
with the Best

Related Video Courses

View More

Annual Membership

Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses

Subscribe now
People having fun around a laptop

Online Certifications

Master prominent technologies at full length and become a valued certified professional.

Explore Now
People having fun around a laptop

Talk to us

1800-202-0515