Buying for a Team? Gift This Course
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
$19 $20 5% off
30-Day Money-Back Guarantee
  • 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
  • Download and install Microsoft Excel 2016

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

What are Ribbons in Excel and how do we use them

Excel Ribbons Explained

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

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

How to enter data in the Table and Cells

Drag, Drop, Cut n Paste functionality

Number Formats, insert/ delete columns and rows
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

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

Overview of formulas

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

Arithmetic Operators in Excel

Lecture will describe comparison operators with working examples in Excel worksheet

Comparison Operations in Excel

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

Concatenation and Reference Operator

Learn about operator precedence and how parenthesis affects formulas in excel

Operator precedence and parentheses in formulas
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

Why are functions used in excel and what are the applications

Why we need to understand functions in excel

Overview of functions in Excel

Overview of functions

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

Commonly used functions in Excel

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

Text functions in Functions in Excel

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

Mathematical Functions  in Excel
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

Common types of charts and graphs explained

Overview of charts and graphs

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

Formatting the charts, titles and axis data
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

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

How to plan and map a template

Creating the different data entries necessary to calculate the budget

Creating data columns and entry

Defining formulas and functions necessary for the budget template

Develop formulas and functions for the template

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

Create graphs and charts for the template

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

Final data entry and project check
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

Planning the task tracker template for project 2

How to map and plan a template

Project 2: Continued

Task data table entry and calculation

Creating a priority and status intersection matrix

Calculating percentage of the tasks

Weighted Matrix Score Table

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

Creating Time Line Graphs and Template Completion
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

Working through examples of data validation in the excel worksheet

Applying data validation to the table

Project 3 introduction and downloadable project template

PROJECT 3: Car Price Check Template Introduction

Planning the layout for project 3

PROJECT3: Plan and Map the Template

Adding data and applying data validation concepts for project 3

PROJECT 3: Adding the price sheet to the template

Completing project 3 

PROJECT 3: Applying VLOOKUP to the table with data validation
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

How to hide data and worksheets in Excel

How to hide and unhide sheets and data

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

Null Error in Excel

Null Error

Format Error in Excel

Format Error

Value Error in Excel 

Value Error

Name Error in Excel

Name Error

N/A error in Excel

N/A Error

Reference Error in Excel

Reference Error

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

Num Error
1 More Section
About the Instructor
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.

Report Abuse