Comprehensive Microsoft Excel 2016 – Master The Concepts
0.0 (0 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.
0 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Comprehensive Microsoft Excel 2016 – Master The Concepts to your Wishlist.

Add to Wishlist

Comprehensive Microsoft Excel 2016 – Master The Concepts

Learn the fundamentals of Microsoft Excel 2016
0.0 (0 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.
0 students enrolled
Last updated 7/2016
English
Price: $20
30-Day Money-Back Guarantee
Includes:
  • 4.5 hours on-demand video
  • 7 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
What Will I Learn?
At the end of the course, student would have created 3 different excel templates applying the main concepts in Excel and master the core concepts in Excel 2016
View Curriculum
Requirements
  • Download and install Microsoft Excel 2016
Description

Microsoft Excel 2016 is used by nearly every company out there (be it a small startup or a Fortune 500 company). Many existing jobs in the market such as Marketing specialist, data entry analyst, management consultant and sales specialist includes Excel as a needed job prerequisite.  Are you interested in learning Excel 2016 or in improving your Excel skill set. Then you have found the right course.

Welcome to the course, "Comprehensive Microsoft Excel 2016 - Master The Concepts", where I will walk you through important concepts in Excel 2016 such as formulas, functions, graphing, data validation, password protection and debugging errors. 

You also will be working on 3 DIFFERENT PROJECTS including creating a budget template, project task tracker dashboard and a car sales price data sheet. By the end of this course, you should have a good grasp on different Excel concepts and would be able to create your own projects or templates in Excel.

Thanks for your interest in this course -- I hope you’re as excited as I am!  If you’re ready to learn more and sign up for the course, go ahead and hit that Enroll button, or take a test drive by using the Free Preview feature.  See you in the course!”

Who is the target audience?
  • This Excel 2016 course is meant for newbies and intermediates who want to understand and improve their Excel skillset. This course is probably not for you if you are looking for advanced concepts or VBA programming
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 62 Lectures Collapse All 62 Lectures 04:38:05
+
Section1: Introduction to the course
5 Lectures 20:56

What will you get from this course, introduction to the instructor and pre-requisites.

Preview 02:02

What is Excel, what are the opportunities out there for people with Excel skill-set 

Preview 03:10

How to open a workbook in excel and what are the different options to save a file in Excel

Opening a workbook and save options
07:43

What are Ribbons in Excel and how do we use them

Excel Ribbons Explained
04:35

What are templates in Excel and how do we use prebuilt templates

Introduction to Templates
03:26
+
Section 2: Data Entry
4 Lectures 12:25

How to enter data in the Table and Cells
02:15

Drag, Drop, Cut n Paste functionality
05:41

Number Formats, insert/ delete columns and rows
03:35
+
Section3: Master the formulas in Excel
7 Lectures 28:17

Introduction to formulas in Excel 2016

Preview 01:51

Why do we need to apply formulas in excel and learn about built in formulas

Why we need to understand formulas in excel
02:01

Walk through a formula in Excel and understand different components in a formula and how to apply them

Overview of formulas
03:23

Lecture will delve into the arithmetic operators with working examples in Excel worksheet

Arithmetic Operators in Excel
04:27

Lecture will describe comparison operators with working examples in Excel worksheet

Comparison Operations in Excel
04:44

Lecture will delve into the comparison operators with working examples in Excel worksheet

Concatenation and Reference Operator
07:42

Learn about operator precedence and how parenthesis affects formulas in excel

Operator precedence and parentheses in formulas
04:09
+
Section 4: Master functions in Excel
6 Lectures 34:45

Introduction to functions in Excel and how to apply functions in Excel workbook. Learn about the commonly used functions in excel and work through the example functions.

Section 4 Intro
01:29

Why are functions used in excel and what are the applications

Why we need to understand functions in excel
01:47

Overview of functions in Excel

Overview of functions
02:29

Definition and explanation of commonly used functions in Excel with examples shown in the Excel workbook

Commonly used functions in Excel
14:38

Definition and explanation of text functions in Excel with examples shown in the Excel workbook

Text functions in Functions in Excel
04:28

Definition and explanation of mathematical functions in Excel with examples shown in the Excel workbook

Mathematical Functions  in Excel
09:54
+
Section 5: Creating graphs and charts in excel
4 Lectures 12:55

Introduction to charts and graphs in excel

Preview 01:05

Why charts and graphing are important in excel

Why we need to learn about graphing and chart creation
01:13

Common types of charts and graphs explained

Overview of charts and graphs
07:29

Lecture describes the different ways to edit graphs and change titles, axis data and legend

Formatting the charts, titles and axis data
03:08
+
Section 6: Creating a Personal Budget Template
7 Lectures 51:07

Introduction to project 1: Budget Tracker Template

Preview 02:18

Definition and walkthrough of the project template

Project description and acceptance criteria
09:36

Lecture describes the different steps to plan the template and map out the data

How to plan and map a template
12:41

Creating the different data entries necessary to calculate the budget

Creating data columns and entry
03:40

Defining formulas and functions necessary for the budget template

Develop formulas and functions for the template
12:45

Create the pie chart and bar charts necessary to show the budget data

Create graphs and charts for the template
06:02

Enter data to check if the budget template works as defined. Good job on finishing project 1

Final data entry and project check
04:05
+
Section 7: Creating a project tracker dashboard
8 Lectures 49:14

Introduction to project 2: Project Task Tracker Template

Preview 01:28

Definition and walkthrough of the project template

Project description and acceptance criteria
07:15

Planning the task tracker template for project 2

How to map and plan a template
08:08

Project 2: Continued

Task data table entry and calculation
07:29

Creating a priority and status intersection matrix
07:58

Calculating percentage of the tasks
02:23

Weighted Matrix Score Table
08:31

Creating the time line graphs that automatically tracks the project status with the current date

Creating Time Line Graphs and Template Completion
06:02
+
Section 8: Data validation in Excel
7 Lectures 33:27

Introduction to data validation concepts in Excel 2016

Preview 01:49

Overview of data validation 

Overview of data validation
02:16

Working through examples of data validation in the excel worksheet

Applying data validation to the table
10:35

Project 3 introduction and downloadable project template

PROJECT 3: Car Price Check Template Introduction
03:32

Planning the layout for project 3

PROJECT3: Plan and Map the Template
04:07

Adding data and applying data validation concepts for project 3

PROJECT 3: Adding the price sheet to the template
03:25

Completing project 3 

PROJECT 3: Applying VLOOKUP to the table with data validation
07:43
+
Section 9: Password protection in Excel
4 Lectures 11:49

Introduction to password protection concept in Excel 2016

Preview 00:59

Understand the need for passwords in Excel and why we need to protect data

Why use password protection in Excel
01:15

How to hide data and worksheets in Excel

How to hide and unhide sheets and data
03:51

How to use passwords to protect data and downloadable excel file with working example used in the lecture

How to use passwords to protect data
05:44
+
Section 10: Common problems and errors in Excel
9 Lectures 19:50

Explanation of errors or issues in Excel 

Preview 00:41

Division Error in Excel and debug

Division Error
01:59

Null Error in Excel

Null Error
02:26

Format Error in Excel

Format Error
02:11

Value Error in Excel 

Value Error
01:51

Name Error in Excel

Name Error
02:01

N/A error in Excel

N/A Error
03:35

Reference Error in Excel

Reference Error
02:44

Num Error in Excel. Downloadable worksheet with the different errors we have seen in this course.

Num Error
02:22
1 More Section
About the Instructor
Dr. Rajesh Krishnan
0.0 Average rating
0 Reviews
489 Students
2 Courses
PhD, Software Engineer

Professionally a product manager with PhD in computer engineering. Wide experience across software programming, product development, and management. Have a passion for helping people through teaching technology, product development and money management. My goal is to effectively deliver course content that my students can practically adapt in their day to day life and start seeing results right away.