Excel 2016 Essential Training
Learning Excel Step by Step
Lectures -53
Resources -37
Duration -4.5 hours
30-days Money-Back Guarantee
Get your team access to 10000+ top Tutorials Point 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
- 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
- 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 Excel 2016 Essential Training](https://d3mxt5v3yxgcsr.cloudfront.net/courses/5204/course_5204_image.png)
Curriculum
Check out the detailed breakdown of what’s inside the course
Introduction
1 Lectures
-
WIIFM - What's in it for me? 02:10 02:10
Getting Started with Excel
10 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Entering Data
5 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Working with Formulas and Functions
7 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Formatting
7 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Data Tools
6 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Filling and Searching Data
5 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Organizing Data and Subtotaling
3 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Pivot Tables
7 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Mail Merge
2 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Instructor Details
![Sam Parulekar](https://www.tutorialspoint.com/assets/profiles/377787/profile/200_3004087-1632148971.jpg)
Sam Parulekar
Course Certificate
Use your certificate to make a career change or to advance in your current career.
![sample Tutorialspoint certificate](/market/public/assets/newDesign/img/primePacks/V-certificate.png)
Our students work
with the Best
![adobe logo](/market/public/assets/newDesign/img/adobe.png)
![adp logo](/market/public/assets/newDesign/img/adp.png)
![apple logo](/market/public/assets/newDesign/img/apple.png)
![armani logo](/market/public/assets/newDesign/img/armani.jpg)
![bosch logo](/market/public/assets/newDesign/img/bosch.png)
![capegemini logo](/market/public/assets/newDesign/img/capegemini.png)
![cisco logo](/market/public/assets/newDesign/img/cisco.png)
![hdfc bank logo](/market/public/assets/newDesign/img/hdfcbank.png)
![ibm logo](/market/public/assets/newDesign/img/ibm.png)
![intel logo](/market/public/assets/newDesign/img/intel.png)
![mastercard logo](/market/public/assets/newDesign/img/mastercard.png)
![netflix logo](/market/public/assets/newDesign/img/netflix.png)
![qualcomm logo](/market/public/assets/newDesign/img/qualcomm.png)
![samsung logo](/market/public/assets/newDesign/img/samsung.png)
![sony logo](/market/public/assets/newDesign/img/sony.png)
![unilever logo](/market/public/assets/newDesign/img/unilever.png)
![walmart logo](/market/public/assets/newDesign/img/walmart.png)
![adobe logo](/market/public/assets/newDesign/img/adobe.png)
![adp logo](/market/public/assets/newDesign/img/adp.png)
![apple logo](/market/public/assets/newDesign/img/apple.png)
![armani logo](/market/public/assets/newDesign/img/armani.jpg)
![bosch logo](/market/public/assets/newDesign/img/bosch.png)
![capegemini logo](/market/public/assets/newDesign/img/capegemini.png)
![cisco logo](/market/public/assets/newDesign/img/cisco.png)
![hdfcbank logo](/market/public/assets/newDesign/img/hdfcbank.png)
![ibm logo](/market/public/assets/newDesign/img/ibm.png)
![intel logo](/market/public/assets/newDesign/img/intel.png)
![mastercard logo](/market/public/assets/newDesign/img/mastercard.png)
![netflix logo](/market/public/assets/newDesign/img/netflix.png)
![qualcomm logo](/market/public/assets/newDesign/img/qualcomm.png)
![samsung logo](/market/public/assets/newDesign/img/samsung.png)
![sony logo](/market/public/assets/newDesign/img/sony.png)
![unilever logo](/market/public/assets/newDesign/img/unilever.png)
![walmart logo](/market/public/assets/newDesign/img/walmart.png)
Related Video Courses
View MoreAnnual Membership
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Subscribe now![Annual Membership Annual Membership](/market/public/assets/newDesign/img/membership-large-small.jpg)
Online Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now![Online Certifications Online Certifications](/market/public/assets/newDesign/img/traning-for-a-team.png)