Microsoft Excel 2016 Master Class: Beginner to Advanced

Quickly learn how use Excel 2016 the right way and make your life easier and more productive in our complete course!
4.7 (285 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.
12,652 students enrolled
$10
$195
95% off
Take This Course
  • Lectures 103
  • Length 8 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 8/2016 English

Course Description

Welcome To Microsoft Excel 2016 Master Class: Beginner To Advanced

⇉ Watch the promo video to see How You Can Begin Mastering Microsoft Excel 2016!

⇉ This Course is MASSIVE! You receive over 7+ hours of video content & 80+ lectures!

⇉ Join Over 100,000+ Students Who Have Enrolled In My Udemy Courses This Year!

⇉ 3000+ Five Star Reviews Shows Students Who Enrolling Are Getting Real Results!

__________________________________________________________________________

In today's workplace, knowing how to use Excel has got to be the NUMBER ONE skill that everyone needs to have.  Excel is easy to get started with and most people are just self taught, but do they really KNOW Excel?  Are they using it the right way?  Usually the answer is no and there is a lot of time being wasted.

This course can change all of that.

By learning Excel from the ground up, and learning the BEST, quickest way to do any given task, this is your opportunity to jump ahead of most people and become not just good with Excel, but AWESOME!  

If you are willing to take the time to go through this course and do the exercises, you could easily be more proficient than most in just a few days from now!

This course is "hands on" and has exercise files for every lecture.  This is not a course you just watch - you learn new techniques by doing them. 

There is a HUGE need in the marketplace for people who REALLY know how to use Excel. This is your opportunity to break away from the pack of people who struggle to get their work done using Excel.  Stop being like everyone else and and learn how to use Excel MUCH more effectively than just about anyone else!

This could be your shortest path to increasing your income!

__________________________________________________________________________

With the right mindset, understanding, and application of the teachings in this course, you will instantly begin to move towards mastering Microsoft Excel 2016 

When we learn something new, I add it to the course - at no additional cost to you! This is a course that will continue to add more and more to every aspect of your life.

In addition to the Udemy 30-day money back guarantee, you have my personal guarantee that you will love what you learn in this course. If you ever have any questions please feel free to message us directly and we will do our best to get back to you as soon as possible!

__________________________________________________________________________

What I can't do in this Course..

I can't guarantee your success – this course does take work on your part. But You Can Do It!

I am also not responsible for your actions. You are responsible for 100% of the decisions and actions you make while using this course.

__________________________________________________________________________

This course will not remain this price forever! It's time to take action!

Click the "take this course" button at the top right now!

...every hour you delay is costing you money...

See you in the course!

Sincerely,

Bruce Myron & Joe Parys 

What are the requirements?

  • Students just need to have a general knowledge of working with Windows and have Microsoft Office 2010 or later installed.

What am I going to get from this course?

  • Understand how Excel works and the most efficient way to do most tasks.

Who is the target audience?

  • This course is for anyone wanting to learn how to use Excel effectively.

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: Welcome To Our Microsoft Excel 2016 Master Class Course: Beginner To Adanved
Welcome To Our Course! Learn All of The Benefits Using Microsoft Excel Today!
Preview
01:42
Getting Started: How To Use This Course To Gain The Maximum For Our Teachings!
03:47
Bruce's Introduction
Preview
03:04
Section 2: Worksheet Basics
The Parts of the Excel Screen
Preview
05:48
The Worksheet - What Is It?
06:53
Navigating Worksheets with Ctrl+Arrow Keys
Preview
04:40
Multiple Worksheets
Preview
06:46
The Ribbon - How Does It Work?
Preview
07:21
Saving and Opening Files
06:30
Worksheet Basics Quiz
11 questions
Section 3: Manipulating Columns and Rows
Resizing Columns and Rows
07:28
Inserting, Deleting, Hiding and Unhiding Columns and Rows
06:19
Columns and Rows Quiz
4 questions
Section 4: Entering Data
Entering Text
06:33
Editing Data
05:24
Undoing Changes
02:35
Excel Data Entry Helps
04:01
Entering Numbers
05:15
Entering Dates
05:08
Entering Symbols
04:57
Entering and Editing Data Quiz
8 questions
Section 5: Selecting Cells and Ranges
Basic Selecting With The Mouse
02:48
Basic Selecting With The Keyboard
04:34
The Extend Key
03:00
Selecting Cells and Ranges Quiz
4 questions
Section 6: Formulas
Basic Formulas
07:30
Rule of Order
02:42
Formulas on Dates
03:50
Formulas with Text
04:55
Multi-Sheet Formulas
03:31
6 questions

Section 7: Copying and Moving
Copy Cells or Ranges
05:45
Move Cells or Ranges
03:08
Copy or Move Columns and Rows
04:35
Copying Formulas and Absolute References
07:59
Using the Clipboard Task Pane
04:14
Move or Copy Sheets
04:30
Copying and Moving Quiz
9 questions
Section 8: The Fill Handle
Fill Handle Basics
04:46
How to Use Fill Series
05:03
Custom Fill Series
04:30
The Fill Handle Quiz
7 questions
Section 9: Naming Ranges
Overview of Naming Ranges
03:36
Multi-Sheet Range Names
06:40
Using Range Names Like Bookmarks
02:43
Naming Ranges Quiz
4 questions
Section 10: Functions
SUM - The Most Popular Function
07:22
Intro to the Quick Analysis Tool
05:09
The IF Function
10:27
Multiple Criteria in an If Statement
03:00
VLookup 1 - Simple Example
07:20
VLookup 2 - Match Within a Range
02:22
Vlookup 3 - Intro to Data Validation Lists
06:34
Vlookup 3 - Multiple VLookups Using the Validation List
04:56
More Functions
07:27
Proper, Round and Other Functions
05:36
Functions Quiz
10 questions
Section 11: Formatting Worksheet Contents
Basic Formatting
05:19
Background Fill, Patterns and Effects
04:30
Aligning of Cell Contents
05:38
Borders
02:40
Formatting Numbers
03:37
Custom Number Formats
05:00
Custom Number Format Exercise
06:18
Date Formats
04:28
Time Formats
04:15
Conditional Formatting 1
04:46
Conditional Formatting 2
06:22
Formatting Quiz
6 questions
Section 12: Table Filters and KEYBOARD SHORTCUTS
Format a Table and Use Filters
06:20
Using Data Slicers
04:09
Table Filters Quiz
4 questions
Section 13: Bringing It All Together PRINT Exercise
Looking at the Task and Getting Started
06:04
Use Quick Analysis and Angle Alignment on Titles
04:44
Create Combined Name Column and Change Margins
04:40
Create 6 Month Totals and Adjust Column Widths
03:46
Modify Print Titles and add Header and Footer
06:16
Final Adjustments and Print Preview
02:31
Print Exercise Quiz
4 questions
Section 14: Payment Function and What If Analysis
Using the PMT Function
03:14
Using GOAL SEEK
03:32
Using the SCENARIO MANAGER
05:35
Using 1 and 2 Variable Data Tables
05:01
What If Quiz
5 questions
Section 15: Finding and Fixing Errors
Using Error Checking
06:00

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Bruce Myron, Productivity Specialist

Hello, my name is Bruce Myron. I am a self employed Access programmer and general computer consultant to small and medium sized businesses. I got into programming because I was tired of all the jargon most programmers use and how they don't seem to care about business.

"Technology is great but I've always been more interested in how it can be used to make companies more profitable." - Bruce

I live in Portland, Oregon and have many long term relationships with local businesses. Many of the systems I have built for these companies are critical to the success of the business. My specialty is taking the needs of the business and translating them into a system that facilitates, rather than obstructs, what they are trying to do.

I have also spent time as a full time trainer providing group classes on the Microsoft Office programs.

In my opinion the computer industry as a whole is a colossal failure in helping businesses solve their problems. I listen carefully to the needs expressed by my clients and then deliver the simplest, most flexible solution possible.

Over the years I have found that many of the techniques I have used enabled me to survive and thrive when many others have tried the computer programming business and failed.

My goal is to show my students how to create systems that business will value and that will create long term income.

Instructor Biography

Joe Parys Academy, Best-Selling Instructor & Founder of the Joe Parys Academy

Why are 200,000+ students enrolled in our Udemy courses?

1) Purpose: We teach with passion and purpose! Every course is delivered with our students in mind.

2) Quality: Our courses are life changing and help you achieve real results!

3) Commitment: My dedication to Udemy and teaching online. Udemy has named me one of its top instructors!

► Try enrolling in any of our courses today and experiecne us firsthand! ◄

 __________________________________________________________________________

Joe Parys Academy is a Leader in Online Education with more than 30+ Co-Authored Courses

The Founder of Joe Parys Academy, Joe Parys, is a Bestselling Udemy instructor with more than 200,000+ students from more than 200 countries around the world! 

Mission Statement:

Our Mission at Joe Parys Academy is to create the highest quality online courses available anywhere in the world. We are focused on producing competent professionals and supplying them with the knowledge and skills they need. 

Vision Statement: 

Our Vision at Joe Parys Academy is for our students to have the opportunity to learn about the subjects of their choosing, taught by our highly qualified teachers. 

 __________________________________________________________________________

Want to learn how to become A Professional Web Developer?

Do You Desire To Create Your Own Mobile Applications? 

Or Maybe Learn How To Run Your Own Microsoft Access Business? 

Then Enroll in our Co-Authored Udemy Courses Today! 

You Too Can Be Doing All of This and So Much More!  __________________________________________________________________________

About The Founder of Joe Parys Academy:

Joe Parys is a Bestselling Udemy instructor, certified life coach, professional motivational speaker, entrepreneur, licensed psychology teacher and head basketball coach! His main areas of expertise are teaching, coaching, public speaking, personal development, personal transformation, the human mind, maximizing human potential, motivation and goal setting.

Joe Parys' CV:

Joe has his bachelors degree from Coe College in Cedar Rapids, IA. He was a four year varsity letter winning college athlete in the sport of men's basketball. He is also a coach for USA basketballs pilot program.

He has been teaching Psychology, History and American Government for grades 5-12 the past three years. 

Joe is also a licensed and certified professional life coach and motivational speaker from the Fowler Institute of Life Coaching. 

Business:

Joe Parys is an entrepreneur running his own life coaching and motivational speaking business. Joe has spoken and taught his courses in numerous high schools in the United States and continues to travel around the country inspiring students of all ages.

Instructor Biography

Joe Parys, Bestselling Instructor, 60 Courses, Serving 200,000 Students

Why are 200,000+ students enrolled in my Udemy courses?

1) I teach with passion and purpose! Every course is delivered with my students in mind.

2) My courses will help you achieve real results and change your life today!

3) My dedication to Udemy and teaching online. Udemy has named me one of its top instructors.

► Try enrolling in a course with me and see for yourself! ◄

__________________________________________________________________________

Want to learn how to become A Professional Web Developer?

Would you like to Transform Your Confidence and Self-Esteem?

Or maybe how to earn thousands Teaching Online Video Courses Full Time?

Then Enroll in my Udemy Courses Today! You too can be doing this - and so much more!

__________________________________________________________________________

About Joe Parys: 

Joe is a certified life coach, professional motivational speaker, entrepreneur, licensed psychology teacher and head basketball coach for USA Basketballs Pilot Program. His main areas of expertise are teaching, coaching, public speaking, personal development, personal transformation, the human mind, maximizing human potential, motivation and goal setting.

My CV:

Joe has his bachelor’s degree from Coe College in Cedar Rapids, IA. He was a four-year varsity letter winning college athlete in the sport of men's basketball. He is also a coach for USA basketball.

He is a Licensed Psychology, History and Government teacher for grades 5-12. He has been teaching High School for the past three years.

Joe is also a licensed and certified professional life coach and motivational speaker from the Fowler Institute.

Business:

Joe Parys is an entrepreneur running his own online academy, Joe Parys Academy. Joe has spoken and taught his courses in numerous high schools in the United States and continues to travel around the country inspiring students of all ages.

Mission Statement- Joe Parys Academy is committed to superior life coaching. Our products and services are created and marketed with the purpose of helping others worldwide prosper and improve their lives.

Vision Statement- Our vision at Joe Parys Academy is to help each client find their purpose in life, reach their goals and fulfill their lifelong dreams.

Ready to start learning?
Take This Course