Buying for a Team? Gift This Course
Wishlisted Wishlist

Please confirm that you want to add Excel 2016 to your Wishlist.

Add to Wishlist

Excel 2016

A step by step guide to using Excel 2016 in just few hours
4.0 (233 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
3,037 students enrolled
Last updated 1/2016
English
$25
30-Day Money-Back Guarantee
Includes:
  • 5 hours on-demand video
  • 35 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
Description

A must have lecture series for people using excel and who want improve their skill sets to maximize productivity, impress their boss or get a new job and overall the most important thing, analyse data effectively.

Lecture series is packed with information about formatting options, charts creations, pivot charts, slicers, logic formulas usage, data validation, excel 2016 new features, macros and vb coding for excel.

Teaches you the new things assuming you are very beginner to excel and helps you become expert in no time.

Learn from these lectures and save a lot of time about how you can get a particular thing done in excel. Stop researching and start implementing after going through this lecture series.

Bonus Pack: A lot of excel sheets with each lecture for download.

Who is the target audience?
  • Beginners and Basic Excel Users
  • The course is suitable for all the excel users. It shall be highly informative and useful for a naive user.
  • For an expert, this course can act as a refresher for the various commands possible in excel. The course however is more suitable for the new or intermediate excel user.
  • Since this is the latest version of the excel, the course can be useful for expert for getting to know quickly what can be done with new additions in excel 2016.
Students Who Viewed This Course Also Viewed
What Will I Learn?
Use Excel like a pro
Analyse data effectively
Plot Graphs, Visualize Data, Create custom sheets, Use functions for math calculations
Complete Understanding of the Excel UI
Use Excel to develop custom data analysis, fill forms, develop forms, pivot tables etc.
View Curriculum
Requirements
  • This course does not assume any background for working with excel.
  • However, I expect you to be a familiar with some basic computer operating skills and some basic math.
Curriculum For This Course
Expand All 81 Lectures Collapse All 81 Lectures 05:01:06
+
Introduction to Excel
16 Lectures 01:15:50

Description about various menu options in Excel.

Description about various menu options in Excel.
04:25

Adding Deleting and naming Sheets in the Workbook.

Adding Deleting and naming Sheets in the Workbook.
02:27

Understanding entering data into excel, selecting boxes, selecting rows/ columns, modifying pre entered data, adding data on new line in the same box.

Some important Data Entry Keyboard Shortcuts.

Understanding entering data into excel sheet and important keyboard shortcuts
07:31

Learn various options inside Home Tab for setting the text inside the box, making it bold,underline, italic, drwaing borders, custom borders, color borders, merging cells, copy data and paste data.

Basic Text Setting Options
16:13

You will learn:

Adding new rows and columns to excel sheet.

Deleting rows or columns from the excel sheet.

Adding and deleting Rows and Columns
01:27

Formatting a Cell in Excel sheet
10:07

Learn how to set rules for the cell based on the contents of cell.

How to Automatically Update the cell features based on the cell contents

Preview 03:18

Learn more in depth features of Conditional Formatting.

Conditional Formatting - Part 2
07:47

Adding styles to cells in sheet. Quickly adding a Heading Style to a particular Cell.

Adding Styles to Sheet Cells
01:25

Learn to hide and unhide excel sheets.

Hide and Unhide Excel Sheets
01:36

Learn to hide and unhide rows and columns.

Hide and Unhide Rows and Columns in an Excel Sheet.
02:18

Learn to copy data from one cell to other cell. Learn to copy complete sheet to other workbook and in the same workbook.

Copy Data from Excel Sheet, Copy/Move Sheet to Other Excel Sheet.
07:03

Hide All unnecessary rows and columns in excel.

Advanced Hide Rows and Columns in Excel Sheet.
04:20

Learn to size cells in one go.

Learn to zoom in and zoom out.

Sizing the Cells and Zooming In and Out in Excel.
02:35

Navigating to A1 Cell Quickly
00:46
+
Working with Data
13 Lectures 43:26
Adding Data and Create Auto Generated Series
01:13

Flash Fill
01:03

Adding Filter To Data
03:10

Data Sorting: Adding Sorting Levels
04:04

Freeze Panes to View Data Corectly
04:18

Creating Your First Excel Graph
05:25

Learn to plot stock price chart

Learn to plot Win loss data

Stock Price Chart
04:19

Pie Chart
03:17

Learn to Plot your happiness level in a bar chart using excel

Bar Chart
04:18

Editing the data for a bar chart in excel
01:16

Quick Updating the chart by adding filter to dataset


Auto Updating plot area using filters
01:30

Bing Map: Plot a geographical overview of the sales.

Bing Map
02:27

Learn to Plot Pivot Table

Pivot Table
07:06
+
Link References, Adding Shapes, Symbols and Equations
5 Lectures 18:19
Adding a link to a cell in Excel: link to some other sheet/ other file/ web
04:20

Adding Shapes to Excel Sheet

Adding Shapes to Excel Sheet.
06:24

Editing Shapes in Excel Sheet
01:36

Add various symbols like degree, micro, omega

learn character code

Inserting Symbol into cells in Excel Sheet
02:44

Insert Equation In Excel Sheet

Inserting an Equation in Excel
03:15
+
Inserting Objects into Excel Sheet
1 Lecture 04:41
Embedding Documents in Excel
04:41
+
Printing Excel Documents
3 Lectures 09:52

Adding Header and Footer to Excel Sheet.

Adding Page Numbers

Adding Header and Footer
02:50

Setting Up Print Area
04:54

Add Background to excel sheet.

More on Printing Excel Sheet
02:08
+
Review Excel Document
5 Lectures 11:25
Find Data In Excel
03:42

Adding comments to cells in excel sheet

Un-hiding, hiding, editing and deleting comments.

Add Comments
02:48

reviewing all comments.

Navigating through Comments in Excel
01:20

Correcting Spelling errors in excel.

Correcting the Spelling Errors
02:07

A new feature of Excel 2016: Inking comments / using touch feature more effectively

Inking
01:28
+
Protect Sheet/ Workbook
3 Lectures 07:31
Protect Sheet.
05:05

Protect Workbook
01:47

Remove Workbook Protection
00:39
+
Data Validation
4 Lectures 14:58

Implementing Data Validation
07:40

Use list from same or other excel sheet to validate data entry in required cells

Learn to clear data validation

Using Data Validation List from Other sheet as a reference
02:49

Extend the data validation to other cells
01:05
+
Formulas
19 Lectures 52:35
Formulas Overview and Using Equal to sign
01:58

Naming Cells
05:09

Scope of Names and Name Manager
03:25

Basic Sum Formula


Sum Formula
02:51

Addition, Subtraction, Multiplication and Division
01:54

Quiz: Finding Average
01:09

Counting number of cells in a selection
01:35

Quiz: Finding Median
00:24

Finding Today's Date
01:50

Logic Formulas
04:35

Embedded AND inside IF
02:05

SumIF
03:39

Quiz: CountIF
00:55

SumIFs
02:26

Random Number Generation
01:35

Finding Ceiling and Floor Values : Rounding up the number in Excel
03:01

Trigonometric Functions, LCM, GCD,Power and Square Root
03:39

VLOOKUP
03:58

Date Functions
06:27
+
Developer Options
11 Lectures 51:40
Recording a Macro
06:03

Viewing Macro Code
03:19

Enabling Developer Option
01:19

Message Box and Getting Started with VB coding
10:11

Range Selection and Value assigning to Cells by Vb coding
06:40

If Statement in Vb
02:40

Cells in Vb
03:24

For Loop
04:00


Forms in Excel
05:14

Summarizing the macro implementations
05:10
1 More Section
About the Instructor
4.0 Average rating
233 Reviews
3,037 Students
1 Course
Engineer and Trainer

I am S N, Electronics Hardware Design Engineer with lot of passion for writing, educating people on various technologies and learning new technologies.

During my career I learned a lot of new technologies, learned about how to train people by giving various sessions to my colleagues and understood what works best for them. I have put use of my experience in building up various lecture series at Udemy.

I am sure you will like my lecture series and find them very Useful.

Report Abuse