Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

Excel 2016 Essential Training

Learning Excel Step by Step

Created bySam Parulekar

Last updated 10/2021

English

What you'll learn

Excel Introduction
Goal Seek
Scenario Manager
Data Table
Autofill Series and Flash Fill
Data Validation
Pivot Tables
Mail Merging with Excel Data

Course content

10 sections • 52 lectures • 4h 48m total length

WIIFM - What's in it for me?2:10

Understanding the Excel Interface5:12
Understanding the Menu System6:23
Understanding the Quick Access Toolbar4:58
Learn to customize the Excel quick access toolbar by adding commands like underline and sort, removing items, and using more commands to adjust its position.
Understanding Workbooks and Worksheets7:36
Understanding the Formula Bar4:28
Understanding the Status Bar4:37
Explore the Excel 2016 status bar, showing macro status and quick stats—average, count, and sum for highlighted data—and customize options while switching views with zoom.
Understanding the Navigation System of Excel3:17
Learn to navigate Excel 2016 with mouse or keyboard arrows, understand cursor changes for selecting, copying, and resizing cells, and switch sheets via tabs or Ctrl+Page Up/Down.
Using shortcut menus and the Mini toolbar4:34
Learn to use the shortcut menu and mini toolbar to insert and delete rows, columns, and worksheets in Excel 2016, plus quick formatting through the mini toolbar.
Creating new workbooks3:20
Using Excel Help3:36
Learn how Excel 2016 help guides you through the ribbon with hover descriptions and shortcuts, and how the Tell Me and light bulb help work.
Quiz on Getting Started with Excel

Creating Simple Formulas8:01
Learn to create formulas and simple functions in Excel 2016 to compute profit as income minus expenses, and use sum and average to total and average monthly data.
Copying Formulas to Adjacent Cells4:31
Calculating Year to Date Totals4:36
Calculate year-to-date totals in Excel by building a dynamic YTD formula that sums current and prior months' profits, with relative references to auto-update as expenses change across columns.
Calculating Percentage6:41
Master how to compute monthly percentage growth in excel 2016 by building a correct formula with parentheses, understanding operator precedence, and handling scenarios where expenses exceed income.
Working with Relative, Absolute and Mixed Referencing6:41
Using Sum and Average7:23
Using other common functions7:36

Exploring Font Styles and Effects5:08
Adjusting Row Heights and Column Widths6:34
Working with alignment and Wrap Text5:48
Working with Borders5:30
Learn how to apply and customize borders in Excel 2016, including outside borders, line color, thickness, and border styles. Master drawing, erasing, and removing borders across cells to highlight data.
Formatting numbers and dates9:37
Using conditional formatting8:43
Creating and using tables7:56

Understanding Data Validation11:18
Learn to implement data validation in Excel 2016 by restricting entries to whole numbers, text length, and dates, using dropdown lists, and customizing input and error messages for specific ranges.
Understanding Text to Columns7:45
Financial Function PMT3:37
Learn to use Excel's pmt function to calculate monthly loan installments, based on rate per period, total payments, and loan amount, shown with a 50 lakh loan over 10 years.
Data Table4:16
Scenario Manager6:16
Goal Seek3:15
Explore how to use Excel 2016's goal seek to find the loan amount that yields a target emi, and how changing the interest rate affects the result via what-if analysis.

Understanding the data and creating Branch wise Pivot6:50
Creating a Branch wise and opened by Pivot4:04
Creating a Date wise Pivot2:51
Creating a Count of Account Types Pivot2:30
Creating a Bucketing Pivot4:04
Creating a Conditional Formatting Pivot3:08
Create a pivot table in an existing worksheet, add data fields to count and show percentages, then apply conditional formatting to color-code higher values.
Creating a Graph out of Pivot Data5:35

Requirements

Basic Computer Fundamentals and Terminologies
A Computer with Windows or MAC OS and Excel 2016 installed
Minimum 4 GB RAM
Internet Connection

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!

Who this course is for:

Beginners to Excel
Students
Working Professionals
Data Analysts
Teachers

Excel 2016 Essential Training

What you'll learn

Explore related topics

Course content

Introduction1 lecture • 2min

Getting Started with Excel10 lectures • 48min

Entering Data5 lectures • 24min

Working with Formulas and Functions7 lectures • 45min

Formatting7 lectures • 49min

Data Tools6 lectures • 36min

Searching and Filling Data5 lectures • 26min

Organizing Data and Subtotaling3 lectures • 24min

Pivot Tables7 lectures • 29min

Mail merge1 lecture • 5min

Requirements

Description

Who this course is for: