Excel 2016

A step by step guide to using Excel 2016 in just few hours
4.2 (226 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,029 students enrolled
Instructed by S N Office Productivity / Microsoft
$30
Take This Course
  • Lectures 81
  • Length 5 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 1/2016 English

Course 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.

What are the 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.

What am I going to get from this course?

  • 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.

What 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.

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction to Excel
Downloading and Buying Office 2016.
02:32
04:25

Description about various menu options in Excel.

02:27

Adding Deleting and naming Sheets in the Workbook.

07:31

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.

16:13

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.

01:27

You will learn:

Adding new rows and columns to excel sheet.

Deleting rows or columns from the excel sheet.

Formatting a Cell in Excel sheet
10:07
03:18

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

07:47

Learn more in depth features of Conditional Formatting.

01:25

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

01:36

Learn to hide and unhide excel sheets.

02:18

Learn to hide and unhide rows and columns.

07:03

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

04:20

Hide All unnecessary rows and columns in excel.

02:35

Learn to size cells in one go.

Learn to zoom in and zoom out.

Navigating to A1 Cell Quickly
00:46
Section 2: Working with Data
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
04:19

Learn to plot stock price chart

Learn to plot Win loss data

Pie Chart
03:17
04:18

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

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

Quick Updating the chart by adding filter to dataset


02:27

Bing Map: Plot a geographical overview of the sales.

07:06

Learn to Plot Pivot Table

Section 3: Link References, Adding Shapes, Symbols and Equations
Adding a link to a cell in Excel: link to some other sheet/ other file/ web
04:20
06:24

Adding Shapes to Excel Sheet

Editing Shapes in Excel Sheet
01:36
02:44

Add various symbols like degree, micro, omega

learn character code

03:15

Insert Equation In Excel Sheet

Section 4: Inserting Objects into Excel Sheet
Embedding Documents in Excel
04:41
Section 5: Printing Excel Documents
02:50

Adding Header and Footer to Excel Sheet.

Adding Page Numbers

Setting Up Print Area
04:54
02:08

Add Background to excel sheet.

Section 6: Review Excel Document
Find Data In Excel
03:42
02:48

Adding comments to cells in excel sheet

Un-hiding, hiding, editing and deleting comments.

01:20

reviewing all comments.

02:07

Correcting Spelling errors in excel.

01:28

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

Section 7: Protect Sheet/ Workbook
Protect Sheet.
05:05
Protect Workbook
01:47
Remove Workbook Protection
00:39
Section 8: Data Validation
Data Validation Overview
Preview
03:24
Implementing Data Validation
07:40
02:49

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

Learn to clear data validation

Extend the data validation to other cells
01:05
Section 9: Formulas
Formulas Overview and Using Equal to sign
01:58
Naming Cells
05:09
Scope of Names and Name Manager
03:25
02:51

Basic Sum Formula


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
Section 10: Developer Options
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
Timer _ And a small Animation
Preview
03:40
Forms in Excel
05:14
Summarizing the macro implementations
05:10
Section 11: Doing Something Amazing with Excel
Pivot Table and Slicers
10:49

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

S N, 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.

Ready to start learning?
Take This Course