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
$19
$20
5% off
Take This Course
  • Lectures 62
  • Length 4.5 hours
  • Skill Level Intermediate Level
  • 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 7/2016 English

Course 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!”

What are the requirements?

  • Download and install Microsoft Excel 2016

What am I going to get from this course?

  • 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

What 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

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: Section1: Introduction to the course
02:02

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

03:10

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

07:43

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

04:35

What are Ribbons in Excel and how do we use them

03:26

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

Section 2: Section 2: Data Entry
Section 2: Overview
Preview
00:54
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
Section 3: Section3: Master the formulas in Excel
01:51

Introduction to formulas in Excel 2016

02:01

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

03:23

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

04:27

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

04:44

Lecture will describe comparison operators with working examples in Excel worksheet

07:42

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

04:09

Learn about operator precedence and how parenthesis affects formulas in excel

Section 4: Section 4: Master functions in Excel
01:29

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.

01:47

Why are functions used in excel and what are the applications

02:29

Overview of functions in Excel

14:38

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

04:28

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

09:54

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

Section 5: Section 5: Creating graphs and charts in excel
01:05

Introduction to charts and graphs in excel

01:13

Why charts and graphing are important in excel

07:29

Common types of charts and graphs explained

03:08

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

Section 6: Section 6: Creating a Personal Budget Template
02:18

Introduction to project 1: Budget Tracker Template

09:36

Definition and walkthrough of the project template

12:41

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

03:40

Creating the different data entries necessary to calculate the budget

12:45

Defining formulas and functions necessary for the budget template

06:02

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

04:05

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

Section 7: Section 7: Creating a project tracker dashboard
01:28

Introduction to project 2: Project Task Tracker Template

07:15

Definition and walkthrough of the project template

08:08

Planning the task tracker template for project 2

07:29

Project 2: Continued

Creating a priority and status intersection matrix
07:58
Calculating percentage of the tasks
02:23
Weighted Matrix Score Table
08:31
06:02

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

Section 8: Section 8: Data validation in Excel
01:49

Introduction to data validation concepts in Excel 2016

02:16

Overview of data validation 

10:35

Working through examples of data validation in the excel worksheet

03:32

Project 3 introduction and downloadable project template

04:07

Planning the layout for project 3

03:25

Adding data and applying data validation concepts for project 3

07:43

Completing project 3 

Section 9: Section 9: Password protection in Excel
00:59

Introduction to password protection concept in Excel 2016

01:15

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

03:51

How to hide data and worksheets in Excel

05:44

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

Section 10: Section 10: Common problems and errors in Excel
00:41

Explanation of errors or issues in Excel 

01:59

Division Error in Excel and debug

02:26

Null Error in Excel

02:11

Format Error in Excel

01:51

Value Error in Excel 

02:01

Name Error in Excel

03:35

N/A error in Excel

02:44

Reference Error in Excel

02:22

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

Section 11: Section 11: Course Wrap Up
03:20

Conclusion and review of the Excel 2016 features covered in this course.

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Dr. Rajesh Krishnan, 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.

Ready to start learning?
Take This Course