Microsoft Excel 2016 Master Class: Beginner to Advanced

  • Course provided by Udemy
  • Study type: Online
  • Starts: Anytime
  • Price: See latest price on Udemy
Udemy

Course Description

Have you always wanted to learn Microsoft Excel but you just don't know where to start?

Or maybe you have started, but you just don't know how to use some of the more advanced features of Excel.

Then the our complete Microsoft Excel 2016 Master Class: Beginner to Advanced is for You!

_________________________________________________________________________

Welcome To Microsoft Excel 2016 Master Class: Beginner to Advanced

⇉ Join 800,000+ Students Who Have Enrolled in our Udemy Courses!

⇉ 10,000+ Five Star Reviews Show Students Who Enroll in our Courses get Results!

⇉ You Get Over 103 Lectures and 8+ hours of premium content

⇉ Watch the Promo Video to see how you can Get Started Today!

_________________________________________________________________________

What do you get with this course?

  • Hours of easy-to-watch video lessons

  • Downloadable Resources

  • Practical activities

  • Instructor support if you have any questions

  • Community of students ready to help

What will you learn in this Microsoft Excel 2016 Master Class: Beginner to Advanced.

In short, you'll learn it all! Seriously, our goal is to make the most comprehensive Microsoft Excel course out there - not filled with fluff, but filled with only the most actionable and latest tips and strategies. We'll be updating this course periodically to make sure we're covering any change with Microsoft Excel.

You'll start with an overview of the course and how to get started with Microsoft Excel.

You'll then learn the worksheet basics and some beginner excel strategies.

Once you understand the basics, you will learn about manipulating columns and rows, entering data, selecting cells and ranges, formulas, copying and moving, the fill handle, naming ranges, functions, formatting worksheet contents, table filters and keyboard shortcuts, and how to bring it all together. You will also learn about payment function and what if analysis, finding and fixing errors, more on working with tables, protecting your work, pivot tables, viewing large worksheets and multiple workbooks, and working with charts.

By the end of our course you will:

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

  • Understand worksheet basics and learn keyboard shortcuts

  • Learn how to manipulate columns and rows.

  • Learn how to enter and edit different kinds of data: text, numbers, dates and symbols

  • Learn how to select cells and ranges and discover basic formulas

  • Save time copying and moving, and know how to use the fill handle

  • Create names for ranges or individual cells and work with SUM and many other functions

  • Format Excel worksheet content like a pro

  • Learn how to modify a large Excel file to prepare it for printing

  • Use Payment Function and What If Analysis

  • Work with tables, pivot tables, charts and protect your work

  • Find and fix errors easily

Ready to get started?

Once you enroll, we recommend students install Microsoft Excel on their computers to follow along.

_____

See What Current Students Are Saying About Our Course:

I really enjoyed the course! I feel that I've learned a lot more than I expected. The lectures were well-organized and clearly presented and with a lot of practice activities (quizzes, exercises). Time well spent, money well spent!”
-Veronica Caratanase

Great course :) Short videos on every topic make u feel focused on eat, easy language to understand and a lot of knowledge i recommend it :)”
-Tomasz Krugowiec

Course is excellent for those new to excel. I have picked up quite a few new tricks and learned some new things.”
-Jamie Shaw

_____

Who are your instructors?

We are Joe Parys and Bruce Myron, creatives who have taught over 800,000+ students around the world with our online courses, tutorials and other content. Bruce Myron is the lead instructor for this course, bringing his wealth of knowledge in working with Microsoft Excel. Joe Parys is the Bestselling Online Instructor, Digital Marketing Expert and Leader in the eLearning industry. He is the CEO of the Joe Parys Academy serving more than 1,000,000+ students in more than 100+ co-authored courses from 190 countries all around the world.

Our goal is to show you the real world and practical ways to start working with Microsoft Excel today!

_________________________________________________________________________

With the right mindset, understanding, and application, you will instantly begin learning how to work with spreadsheets in Microsoft Excel.

When I 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.

What I can't do in this Course..

I can't guarantee your success – this course does take work on your part. But it can be done!

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

_________________________________________________________________________

It's time to take action!

Our happiness guarantee

This course includes a money back guarantee, so there is no risk to try it out. Sign up today, see if it's the right one for you.

Enroll now.

Sincerely,

Joe Parys and Bruce Myron.

Who this course is for:

  • Anyone wanting to learn how to use Excel effectively
  • Anyone using Excel, but wanting to improve their knowlege
  • Entrepreneurs, office workers, teachers and students wanting to work with spreadsheets

Expected Outcomes

  1. Understand how Excel works and the most efficient way to do most tasks. Understand worksheet basics and learn keyboard shortcuts Learn how to manipulate columns and rows Learn how to enter and edit different kinds of data: text, numbers, dates and symbols Learn how to select cells and ranges and discover basic formulas Save time copying and moving, and know how to use the fill handle Create names for ranges or individual cells and work with SUM and many other functions Work with SUM and many other functions Format Excel worksheet content like a pro Learn how to modify a large Excel file to prepare it for printing Use Payment Function and What If Analysis Work with tables, pivot tables, charts and protect your work Find and fix errors easily Show more Show less Requirements Have Microsoft Office 2010 or later installed General knowledge of working with Windows You DO NOT need prior knowledge of Microsoft Excel Description Have you always wanted to learn Microsoft Excel but you just don't know where to start? Or maybe you have started, but you just don't know how to use some of the more advanced features of Excel. Then the our complete Microsoft Excel 2016 Master Class: Beginner to Advanced is for You! _________________________________________________________________________ Welcome To Microsoft Excel 2016 Master Class: Beginner to Advanced ⇉ Join 800,000+ Students Who Have Enrolled in our Udemy Courses! ⇉ 10,000+ Five Star Reviews Show Students Who Enroll in our Courses get Results! ⇉ You Get Over 103 Lectures and 8+ hours of premium content ⇉ Watch the Promo Video to see how you can Get Started Today! _________________________________________________________________________ What do you get with this course? Hours of easy-to-watch video lessons Downloadable Resources Practical activities Instructor support if you have any questions Community of students ready to help What will you learn in this Microsoft Excel 2016 Master Class: Beginner to Advanced. In short, you'll learn it all! Seriously, our goal is to make the most comprehensive Microsoft Excel course out there - not filled with fluff, but filled with only the most actionable and latest tips and strategies. We'll be updating this course periodically to make sure we're covering any change with Microsoft Excel. You'll start with an overview of the course and how to get started with Microsoft Excel. You'll then learn the worksheet basics and some beginner excel strategies. Once you understand the basics, you will learn about manipulating columns and rows, entering data, selecting cells and ranges, formulas, copying and moving, the fill handle, naming ranges, functions, formatting worksheet contents, table filters and keyboard shortcuts, and how to bring it all together. You will also learn about payment function and what if analysis, finding and fixing errors, more on working with tables, protecting your work, pivot tables, viewing large worksheets and multiple workbooks, and working with charts. By the end of our course you will: Understand how Excel works and the most efficient way to do most tasks. Understand worksheet basics and learn keyboard shortcuts Learn how to manipulate columns and rows. Learn how to enter and edit different kinds of data: text, numbers, dates and symbols Learn how to select cells and ranges and discover basic formulas Save time copying and moving, and know how to use the fill handle Create names for ranges or individual cells and work with SUM and many other functions Format Excel worksheet content like a pro Learn how to modify a large Excel file to prepare it for printing Use Payment Function and What If Analysis Work with tables, pivot tables, charts and protect your work Find and fix errors easily Ready to get started? Once you enroll, we recommend students install Microsoft Excel on their computers to follow along. _____ See What Current Students Are Saying About Our Course: “ I really enjoyed the course! I feel that I've learned a lot more than I expected. The lectures were well-organized and clearly presented and with a lot of practice activities (quizzes, exercises). Time well spent, money well spent!” -Veronica Caratanase “ Great course :) Short videos on every topic make u feel focused on eat, easy language to understand and a lot of knowledge i recommend it :)” -Tomasz Krugowiec “ Course is excellent for those new to excel. I have picked up quite a few new tricks and learned some new things.” -Jamie Shaw _____ Who are your instructors? We are Joe Parys and Bruce Myron, creatives who have taught over 800,000+ students around the world with our online courses, tutorials and other content. Bruce Myron is the lead instructor for this course, bringing his wealth of knowledge in working with Microsoft Excel. Joe Parys is the Bestselling Online Instructor, Digital Marketing Expert and Leader in the eLearning industry. He is the CEO of the Joe Parys Academy serving more than 1,000,000+ students in more than 100+ co-authored courses from 190 countries all around the world. Our goal is to show you the real world and practical ways to start working with Microsoft Excel today! _________________________________________________________________________ With the right mindset, understanding, and application, you will instantly begin learning how to work with spreadsheets in Microsoft Excel. When I 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. What I can't do in this Course.. I can't guarantee your success – this course does take work on your part. But it can be done! I am also not responsible for your actions. You are responsible for 100% of the decisions and actions you make while using this course. _________________________________________________________________________ It's time to take action! Our happiness guarantee This course includes a money back guarantee, so there is no risk to try it out. Sign up today, see if it's the right one for you. Enroll now. Sincerely, Joe Parys and Bruce Myron. Who this course is for: Anyone wanting to learn how to use Excel effectively Anyone using Excel, but wanting to improve their knowlege Entrepreneurs, office workers, teachers and students wanting to work with spreadsheets Show more Show less Course content 21 sections • 103 lectures • 8h 5m total length Expand all sections Welcome To Our Microsoft Excel 2016 Master Class Course: Beginner To Advanced 3 lectures • 5min Welcome To Our Course! Learn All of The Benefits Using Microsoft Excel Today! Preview 00:24 Getting Started: How To Use This Course To Gain The Maximum For Our Teachings! 01:11 Bruce's Introduction: Getting Started with Microsoft Excel Preview 03:04 Worksheet Basics 6 lectures • 38min 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 Manipulating Columns and Rows 2 lectures • 14min Resizing Columns and Rows 07:28 Inserting, Deleting, Hiding and Unhiding Columns and Rows 06:19 Columns and Rows Quiz 4 questions Entering Data 7 lectures • 34min 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 Selecting Cells and Ranges 3 lectures • 10min 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 Formulas 5 lectures • 22min Basic Formulas 07:30 Rule of Order 02:42 Formulas on Dates 03:50 Formulas with Text 04:55 Multi-Sheet Formulas 03:31 Formulas Quiz 6 questions Copying and Moving 6 lectures • 30min 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 Panel 04:14 Move or Copy Sheets 04:30 Copying and Moving Quiz 9 questions The Fill Handle 3 lectures • 14min Fill Handle Basics 04:46 How to Use Fill Series 05:03 Custom Fill Series 04:30 The Fill Handle Quiz 7 questions Naming Ranges 3 lectures • 13min Overview of Naming Ranges 03:36 Multi-Sheet Range Names 06:40 Using Range Names Like Bookmarks 02:43 Naming Ranges Quiz 4 questions Functions 10 lectures • 1hr 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 4 - Multiple VLookups Using the Validation List 04:56 More Functions 07:27 Proper, Round and Other Functions 05:36 Functions Quiz 10 questions 11 more sections Instructors Bruce Myron Productivity Specialist 4.6 Instructor Rating 23,165 Reviews 112,526 Students 19 Courses 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. Show more Show less Joe Parys Support Best-Selling Instructor Proudly Serving 500,000+ Students 4.4 Instructor Rating 59,960 Reviews 877,289 Students 86 Courses Why are 500,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 experience us firsthand ◄ __________________________________________________________________________ Joe and the 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 the Bestselling Udemy instructor with more than 350,000+ students from more than 195 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. Show more Show less Joe Parys Top-Rated Instructor, 800,000+ Students 4.4 Instructor Rating 61,860 Reviews 888,131 Students 92 Courses Why are 800,000+ students enrolled in my online 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 teaching online. I have been named a top instructor on Udemy ► Try enrolling in a course with me and see for yourself ◄ __________________________________________________________________ About Joe Parys: Joe Parys is a bestselling online instructor, entrepreneur, and international speaker whose eLearning courses have been featured on Udemy, Buzzfeed, CBS News, and many other professional platforms. Business: The Joe Parys Academy is a Leader in the E-Learning Industry with more than 97+ Co-Authored Courses . The Founder of The Joe Parys Academy, Joe Parys, is a Bestselling Online Instructor with more than 800,000+ students from around the world. My 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 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. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'678105b0387b008d',m:'7012bf19901bcec4c25fd30366c5bd9199a006b4-1627841417-1800-Afs01pjhLa71BUhKXa54Nfx3S13pL8lBpBCIGC2bME4UgriECye3HGdHQ9mgTnYoZSlxC2W8IYjfBz6kGoSD8c1LA3sGpWDZUDNICykX4cjR6aa/V3X70aj/EgLPD7mrJqd06eMNB/hFZrmC/IwPZLY=',s:[0xcb97af41b2,0x6a7a8ff083],}})();
  2. Understand worksheet basics and learn keyboard shortcuts Learn how to manipulate columns and rows Learn how to enter and edit different kinds of data: text, numbers, dates and symbols Learn how to select cells and ranges and discover basic formulas Save time copying and moving, and know how to use the fill handle Create names for ranges or individual cells and work with SUM and many other functions Work with SUM and many other functions Format Excel worksheet content like a pro Learn how to modify a large Excel file to prepare it for printing Use Payment Function and What If Analysis Work with tables, pivot tables, charts and protect your work Find and fix errors easily Show more Show less Requirements Have Microsoft Office 2010 or later installed General knowledge of working with Windows You DO NOT need prior knowledge of Microsoft Excel Description Have you always wanted to learn Microsoft Excel but you just don't know where to start? Or maybe you have started, but you just don't know how to use some of the more advanced features of Excel. Then the our complete Microsoft Excel 2016 Master Class: Beginner to Advanced is for You! _________________________________________________________________________ Welcome To Microsoft Excel 2016 Master Class: Beginner to Advanced ⇉ Join 800,000+ Students Who Have Enrolled in our Udemy Courses! ⇉ 10,000+ Five Star Reviews Show Students Who Enroll in our Courses get Results! ⇉ You Get Over 103 Lectures and 8+ hours of premium content ⇉ Watch the Promo Video to see how you can Get Started Today! _________________________________________________________________________ What do you get with this course? Hours of easy-to-watch video lessons Downloadable Resources Practical activities Instructor support if you have any questions Community of students ready to help What will you learn in this Microsoft Excel 2016 Master Class: Beginner to Advanced. In short, you'll learn it all! Seriously, our goal is to make the most comprehensive Microsoft Excel course out there - not filled with fluff, but filled with only the most actionable and latest tips and strategies. We'll be updating this course periodically to make sure we're covering any change with Microsoft Excel. You'll start with an overview of the course and how to get started with Microsoft Excel. You'll then learn the worksheet basics and some beginner excel strategies. Once you understand the basics, you will learn about manipulating columns and rows, entering data, selecting cells and ranges, formulas, copying and moving, the fill handle, naming ranges, functions, formatting worksheet contents, table filters and keyboard shortcuts, and how to bring it all together. You will also learn about payment function and what if analysis, finding and fixing errors, more on working with tables, protecting your work, pivot tables, viewing large worksheets and multiple workbooks, and working with charts. By the end of our course you will: Understand how Excel works and the most efficient way to do most tasks. Understand worksheet basics and learn keyboard shortcuts Learn how to manipulate columns and rows. Learn how to enter and edit different kinds of data: text, numbers, dates and symbols Learn how to select cells and ranges and discover basic formulas Save time copying and moving, and know how to use the fill handle Create names for ranges or individual cells and work with SUM and many other functions Format Excel worksheet content like a pro Learn how to modify a large Excel file to prepare it for printing Use Payment Function and What If Analysis Work with tables, pivot tables, charts and protect your work Find and fix errors easily Ready to get started? Once you enroll, we recommend students install Microsoft Excel on their computers to follow along. _____ See What Current Students Are Saying About Our Course: “ I really enjoyed the course! I feel that I've learned a lot more than I expected. The lectures were well-organized and clearly presented and with a lot of practice activities (quizzes, exercises). Time well spent, money well spent!” -Veronica Caratanase “ Great course :) Short videos on every topic make u feel focused on eat, easy language to understand and a lot of knowledge i recommend it :)” -Tomasz Krugowiec “ Course is excellent for those new to excel. I have picked up quite a few new tricks and learned some new things.” -Jamie Shaw _____ Who are your instructors? We are Joe Parys and Bruce Myron, creatives who have taught over 800,000+ students around the world with our online courses, tutorials and other content. Bruce Myron is the lead instructor for this course, bringing his wealth of knowledge in working with Microsoft Excel. Joe Parys is the Bestselling Online Instructor, Digital Marketing Expert and Leader in the eLearning industry. He is the CEO of the Joe Parys Academy serving more than 1,000,000+ students in more than 100+ co-authored courses from 190 countries all around the world. Our goal is to show you the real world and practical ways to start working with Microsoft Excel today! _________________________________________________________________________ With the right mindset, understanding, and application, you will instantly begin learning how to work with spreadsheets in Microsoft Excel. When I 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. What I can't do in this Course.. I can't guarantee your success – this course does take work on your part. But it can be done! I am also not responsible for your actions. You are responsible for 100% of the decisions and actions you make while using this course. _________________________________________________________________________ It's time to take action! Our happiness guarantee This course includes a money back guarantee, so there is no risk to try it out. Sign up today, see if it's the right one for you. Enroll now. Sincerely, Joe Parys and Bruce Myron. Who this course is for: Anyone wanting to learn how to use Excel effectively Anyone using Excel, but wanting to improve their knowlege Entrepreneurs, office workers, teachers and students wanting to work with spreadsheets Show more Show less Course content 21 sections • 103 lectures • 8h 5m total length Expand all sections Welcome To Our Microsoft Excel 2016 Master Class Course: Beginner To Advanced 3 lectures • 5min Welcome To Our Course! Learn All of The Benefits Using Microsoft Excel Today! Preview 00:24 Getting Started: How To Use This Course To Gain The Maximum For Our Teachings! 01:11 Bruce's Introduction: Getting Started with Microsoft Excel Preview 03:04 Worksheet Basics 6 lectures • 38min 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 Manipulating Columns and Rows 2 lectures • 14min Resizing Columns and Rows 07:28 Inserting, Deleting, Hiding and Unhiding Columns and Rows 06:19 Columns and Rows Quiz 4 questions Entering Data 7 lectures • 34min 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 Selecting Cells and Ranges 3 lectures • 10min 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 Formulas 5 lectures • 22min Basic Formulas 07:30 Rule of Order 02:42 Formulas on Dates 03:50 Formulas with Text 04:55 Multi-Sheet Formulas 03:31 Formulas Quiz 6 questions Copying and Moving 6 lectures • 30min 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 Panel 04:14 Move or Copy Sheets 04:30 Copying and Moving Quiz 9 questions The Fill Handle 3 lectures • 14min Fill Handle Basics 04:46 How to Use Fill Series 05:03 Custom Fill Series 04:30 The Fill Handle Quiz 7 questions Naming Ranges 3 lectures • 13min Overview of Naming Ranges 03:36 Multi-Sheet Range Names 06:40 Using Range Names Like Bookmarks 02:43 Naming Ranges Quiz 4 questions Functions 10 lectures • 1hr 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 4 - Multiple VLookups Using the Validation List 04:56 More Functions 07:27 Proper, Round and Other Functions 05:36 Functions Quiz 10 questions 11 more sections Instructors Bruce Myron Productivity Specialist 4.6 Instructor Rating 23,165 Reviews 112,526 Students 19 Courses 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. Show more Show less Joe Parys Support Best-Selling Instructor Proudly Serving 500,000+ Students 4.4 Instructor Rating 59,960 Reviews 877,289 Students 86 Courses Why are 500,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 experience us firsthand ◄ __________________________________________________________________________ Joe and the 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 the Bestselling Udemy instructor with more than 350,000+ students from more than 195 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. Show more Show less Joe Parys Top-Rated Instructor, 800,000+ Students 4.4 Instructor Rating 61,860 Reviews 888,131 Students 92 Courses Why are 800,000+ students enrolled in my online 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 teaching online. I have been named a top instructor on Udemy ► Try enrolling in a course with me and see for yourself ◄ __________________________________________________________________ About Joe Parys: Joe Parys is a bestselling online instructor, entrepreneur, and international speaker whose eLearning courses have been featured on Udemy, Buzzfeed, CBS News, and many other professional platforms. Business: The Joe Parys Academy is a Leader in the E-Learning Industry with more than 97+ Co-Authored Courses . The Founder of The Joe Parys Academy, Joe Parys, is a Bestselling Online Instructor with more than 800,000+ students from around the world. My 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 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. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'678105b0387b008d',m:'7012bf19901bcec4c25fd30366c5bd9199a006b4-1627841417-1800-Afs01pjhLa71BUhKXa54Nfx3S13pL8lBpBCIGC2bME4UgriECye3HGdHQ9mgTnYoZSlxC2W8IYjfBz6kGoSD8c1LA3sGpWDZUDNICykX4cjR6aa/V3X70aj/EgLPD7mrJqd06eMNB/hFZrmC/IwPZLY=',s:[0xcb97af41b2,0x6a7a8ff083],}})();
  3. Learn how to manipulate columns and rows Learn how to enter and edit different kinds of data: text, numbers, dates and symbols Learn how to select cells and ranges and discover basic formulas Save time copying and moving, and know how to use the fill handle Create names for ranges or individual cells and work with SUM and many other functions Work with SUM and many other functions Format Excel worksheet content like a pro Learn how to modify a large Excel file to prepare it for printing Use Payment Function and What If Analysis Work with tables, pivot tables, charts and protect your work Find and fix errors easily Show more Show less Requirements Have Microsoft Office 2010 or later installed General knowledge of working with Windows You DO NOT need prior knowledge of Microsoft Excel Description Have you always wanted to learn Microsoft Excel but you just don't know where to start? Or maybe you have started, but you just don't know how to use some of the more advanced features of Excel. Then the our complete Microsoft Excel 2016 Master Class: Beginner to Advanced is for You! _________________________________________________________________________ Welcome To Microsoft Excel 2016 Master Class: Beginner to Advanced ⇉ Join 800,000+ Students Who Have Enrolled in our Udemy Courses! ⇉ 10,000+ Five Star Reviews Show Students Who Enroll in our Courses get Results! ⇉ You Get Over 103 Lectures and 8+ hours of premium content ⇉ Watch the Promo Video to see how you can Get Started Today! _________________________________________________________________________ What do you get with this course? Hours of easy-to-watch video lessons Downloadable Resources Practical activities Instructor support if you have any questions Community of students ready to help What will you learn in this Microsoft Excel 2016 Master Class: Beginner to Advanced. In short, you'll learn it all! Seriously, our goal is to make the most comprehensive Microsoft Excel course out there - not filled with fluff, but filled with only the most actionable and latest tips and strategies. We'll be updating this course periodically to make sure we're covering any change with Microsoft Excel. You'll start with an overview of the course and how to get started with Microsoft Excel. You'll then learn the worksheet basics and some beginner excel strategies. Once you understand the basics, you will learn about manipulating columns and rows, entering data, selecting cells and ranges, formulas, copying and moving, the fill handle, naming ranges, functions, formatting worksheet contents, table filters and keyboard shortcuts, and how to bring it all together. You will also learn about payment function and what if analysis, finding and fixing errors, more on working with tables, protecting your work, pivot tables, viewing large worksheets and multiple workbooks, and working with charts. By the end of our course you will: Understand how Excel works and the most efficient way to do most tasks. Understand worksheet basics and learn keyboard shortcuts Learn how to manipulate columns and rows. Learn how to enter and edit different kinds of data: text, numbers, dates and symbols Learn how to select cells and ranges and discover basic formulas Save time copying and moving, and know how to use the fill handle Create names for ranges or individual cells and work with SUM and many other functions Format Excel worksheet content like a pro Learn how to modify a large Excel file to prepare it for printing Use Payment Function and What If Analysis Work with tables, pivot tables, charts and protect your work Find and fix errors easily Ready to get started? Once you enroll, we recommend students install Microsoft Excel on their computers to follow along. _____ See What Current Students Are Saying About Our Course: “ I really enjoyed the course! I feel that I've learned a lot more than I expected. The lectures were well-organized and clearly presented and with a lot of practice activities (quizzes, exercises). Time well spent, money well spent!” -Veronica Caratanase “ Great course :) Short videos on every topic make u feel focused on eat, easy language to understand and a lot of knowledge i recommend it :)” -Tomasz Krugowiec “ Course is excellent for those new to excel. I have picked up quite a few new tricks and learned some new things.” -Jamie Shaw _____ Who are your instructors? We are Joe Parys and Bruce Myron, creatives who have taught over 800,000+ students around the world with our online courses, tutorials and other content. Bruce Myron is the lead instructor for this course, bringing his wealth of knowledge in working with Microsoft Excel. Joe Parys is the Bestselling Online Instructor, Digital Marketing Expert and Leader in the eLearning industry. He is the CEO of the Joe Parys Academy serving more than 1,000,000+ students in more than 100+ co-authored courses from 190 countries all around the world. Our goal is to show you the real world and practical ways to start working with Microsoft Excel today! _________________________________________________________________________ With the right mindset, understanding, and application, you will instantly begin learning how to work with spreadsheets in Microsoft Excel. When I 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. What I can't do in this Course.. I can't guarantee your success – this course does take work on your part. But it can be done! I am also not responsible for your actions. You are responsible for 100% of the decisions and actions you make while using this course. _________________________________________________________________________ It's time to take action! Our happiness guarantee This course includes a money back guarantee, so there is no risk to try it out. Sign up today, see if it's the right one for you. Enroll now. Sincerely, Joe Parys and Bruce Myron. Who this course is for: Anyone wanting to learn how to use Excel effectively Anyone using Excel, but wanting to improve their knowlege Entrepreneurs, office workers, teachers and students wanting to work with spreadsheets Show more Show less Course content 21 sections • 103 lectures • 8h 5m total length Expand all sections Welcome To Our Microsoft Excel 2016 Master Class Course: Beginner To Advanced 3 lectures • 5min Welcome To Our Course! Learn All of The Benefits Using Microsoft Excel Today! Preview 00:24 Getting Started: How To Use This Course To Gain The Maximum For Our Teachings! 01:11 Bruce's Introduction: Getting Started with Microsoft Excel Preview 03:04 Worksheet Basics 6 lectures • 38min 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 Manipulating Columns and Rows 2 lectures • 14min Resizing Columns and Rows 07:28 Inserting, Deleting, Hiding and Unhiding Columns and Rows 06:19 Columns and Rows Quiz 4 questions Entering Data 7 lectures • 34min 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 Selecting Cells and Ranges 3 lectures • 10min 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 Formulas 5 lectures • 22min Basic Formulas 07:30 Rule of Order 02:42 Formulas on Dates 03:50 Formulas with Text 04:55 Multi-Sheet Formulas 03:31 Formulas Quiz 6 questions Copying and Moving 6 lectures • 30min 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 Panel 04:14 Move or Copy Sheets 04:30 Copying and Moving Quiz 9 questions The Fill Handle 3 lectures • 14min Fill Handle Basics 04:46 How to Use Fill Series 05:03 Custom Fill Series 04:30 The Fill Handle Quiz 7 questions Naming Ranges 3 lectures • 13min Overview of Naming Ranges 03:36 Multi-Sheet Range Names 06:40 Using Range Names Like Bookmarks 02:43 Naming Ranges Quiz 4 questions Functions 10 lectures • 1hr 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 4 - Multiple VLookups Using the Validation List 04:56 More Functions 07:27 Proper, Round and Other Functions 05:36 Functions Quiz 10 questions 11 more sections Instructors Bruce Myron Productivity Specialist 4.6 Instructor Rating 23,165 Reviews 112,526 Students 19 Courses 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. Show more Show less Joe Parys Support Best-Selling Instructor Proudly Serving 500,000+ Students 4.4 Instructor Rating 59,960 Reviews 877,289 Students 86 Courses Why are 500,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 experience us firsthand ◄ __________________________________________________________________________ Joe and the 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 the Bestselling Udemy instructor with more than 350,000+ students from more than 195 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. Show more Show less Joe Parys Top-Rated Instructor, 800,000+ Students 4.4 Instructor Rating 61,860 Reviews 888,131 Students 92 Courses Why are 800,000+ students enrolled in my online 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 teaching online. I have been named a top instructor on Udemy ► Try enrolling in a course with me and see for yourself ◄ __________________________________________________________________ About Joe Parys: Joe Parys is a bestselling online instructor, entrepreneur, and international speaker whose eLearning courses have been featured on Udemy, Buzzfeed, CBS News, and many other professional platforms. Business: The Joe Parys Academy is a Leader in the E-Learning Industry with more than 97+ Co-Authored Courses . The Founder of The Joe Parys Academy, Joe Parys, is a Bestselling Online Instructor with more than 800,000+ students from around the world. My 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 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. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'678105b0387b008d',m:'7012bf19901bcec4c25fd30366c5bd9199a006b4-1627841417-1800-Afs01pjhLa71BUhKXa54Nfx3S13pL8lBpBCIGC2bME4UgriECye3HGdHQ9mgTnYoZSlxC2W8IYjfBz6kGoSD8c1LA3sGpWDZUDNICykX4cjR6aa/V3X70aj/EgLPD7mrJqd06eMNB/hFZrmC/IwPZLY=',s:[0xcb97af41b2,0x6a7a8ff083],}})();
  4. Learn how to enter and edit different kinds of data: text, numbers, dates and symbols Learn how to select cells and ranges and discover basic formulas Save time copying and moving, and know how to use the fill handle Create names for ranges or individual cells and work with SUM and many other functions Work with SUM and many other functions Format Excel worksheet content like a pro Learn how to modify a large Excel file to prepare it for printing Use Payment Function and What If Analysis Work with tables, pivot tables, charts and protect your work Find and fix errors easily Show more Show less Requirements Have Microsoft Office 2010 or later installed General knowledge of working with Windows You DO NOT need prior knowledge of Microsoft Excel Description Have you always wanted to learn Microsoft Excel but you just don't know where to start? Or maybe you have started, but you just don't know how to use some of the more advanced features of Excel. Then the our complete Microsoft Excel 2016 Master Class: Beginner to Advanced is for You! _________________________________________________________________________ Welcome To Microsoft Excel 2016 Master Class: Beginner to Advanced ⇉ Join 800,000+ Students Who Have Enrolled in our Udemy Courses! ⇉ 10,000+ Five Star Reviews Show Students Who Enroll in our Courses get Results! ⇉ You Get Over 103 Lectures and 8+ hours of premium content ⇉ Watch the Promo Video to see how you can Get Started Today! _________________________________________________________________________ What do you get with this course? Hours of easy-to-watch video lessons Downloadable Resources Practical activities Instructor support if you have any questions Community of students ready to help What will you learn in this Microsoft Excel 2016 Master Class: Beginner to Advanced. In short, you'll learn it all! Seriously, our goal is to make the most comprehensive Microsoft Excel course out there - not filled with fluff, but filled with only the most actionable and latest tips and strategies. We'll be updating this course periodically to make sure we're covering any change with Microsoft Excel. You'll start with an overview of the course and how to get started with Microsoft Excel. You'll then learn the worksheet basics and some beginner excel strategies. Once you understand the basics, you will learn about manipulating columns and rows, entering data, selecting cells and ranges, formulas, copying and moving, the fill handle, naming ranges, functions, formatting worksheet contents, table filters and keyboard shortcuts, and how to bring it all together. You will also learn about payment function and what if analysis, finding and fixing errors, more on working with tables, protecting your work, pivot tables, viewing large worksheets and multiple workbooks, and working with charts. By the end of our course you will: Understand how Excel works and the most efficient way to do most tasks. Understand worksheet basics and learn keyboard shortcuts Learn how to manipulate columns and rows. Learn how to enter and edit different kinds of data: text, numbers, dates and symbols Learn how to select cells and ranges and discover basic formulas Save time copying and moving, and know how to use the fill handle Create names for ranges or individual cells and work with SUM and many other functions Format Excel worksheet content like a pro Learn how to modify a large Excel file to prepare it for printing Use Payment Function and What If Analysis Work with tables, pivot tables, charts and protect your work Find and fix errors easily Ready to get started? Once you enroll, we recommend students install Microsoft Excel on their computers to follow along. _____ See What Current Students Are Saying About Our Course: “ I really enjoyed the course! I feel that I've learned a lot more than I expected. The lectures were well-organized and clearly presented and with a lot of practice activities (quizzes, exercises). Time well spent, money well spent!” -Veronica Caratanase “ Great course :) Short videos on every topic make u feel focused on eat, easy language to understand and a lot of knowledge i recommend it :)” -Tomasz Krugowiec “ Course is excellent for those new to excel. I have picked up quite a few new tricks and learned some new things.” -Jamie Shaw _____ Who are your instructors? We are Joe Parys and Bruce Myron, creatives who have taught over 800,000+ students around the world with our online courses, tutorials and other content. Bruce Myron is the lead instructor for this course, bringing his wealth of knowledge in working with Microsoft Excel. Joe Parys is the Bestselling Online Instructor, Digital Marketing Expert and Leader in the eLearning industry. He is the CEO of the Joe Parys Academy serving more than 1,000,000+ students in more than 100+ co-authored courses from 190 countries all around the world. Our goal is to show you the real world and practical ways to start working with Microsoft Excel today! _________________________________________________________________________ With the right mindset, understanding, and application, you will instantly begin learning how to work with spreadsheets in Microsoft Excel. When I 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. What I can't do in this Course.. I can't guarantee your success – this course does take work on your part. But it can be done! I am also not responsible for your actions. You are responsible for 100% of the decisions and actions you make while using this course. _________________________________________________________________________ It's time to take action! Our happiness guarantee This course includes a money back guarantee, so there is no risk to try it out. Sign up today, see if it's the right one for you. Enroll now. Sincerely, Joe Parys and Bruce Myron. Who this course is for: Anyone wanting to learn how to use Excel effectively Anyone using Excel, but wanting to improve their knowlege Entrepreneurs, office workers, teachers and students wanting to work with spreadsheets Show more Show less Course content 21 sections • 103 lectures • 8h 5m total length Expand all sections Welcome To Our Microsoft Excel 2016 Master Class Course: Beginner To Advanced 3 lectures • 5min Welcome To Our Course! Learn All of The Benefits Using Microsoft Excel Today! Preview 00:24 Getting Started: How To Use This Course To Gain The Maximum For Our Teachings! 01:11 Bruce's Introduction: Getting Started with Microsoft Excel Preview 03:04 Worksheet Basics 6 lectures • 38min 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 Manipulating Columns and Rows 2 lectures • 14min Resizing Columns and Rows 07:28 Inserting, Deleting, Hiding and Unhiding Columns and Rows 06:19 Columns and Rows Quiz 4 questions Entering Data 7 lectures • 34min 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 Selecting Cells and Ranges 3 lectures • 10min 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 Formulas 5 lectures • 22min Basic Formulas 07:30 Rule of Order 02:42 Formulas on Dates 03:50 Formulas with Text 04:55 Multi-Sheet Formulas 03:31 Formulas Quiz 6 questions Copying and Moving 6 lectures • 30min 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 Panel 04:14 Move or Copy Sheets 04:30 Copying and Moving Quiz 9 questions The Fill Handle 3 lectures • 14min Fill Handle Basics 04:46 How to Use Fill Series 05:03 Custom Fill Series 04:30 The Fill Handle Quiz 7 questions Naming Ranges 3 lectures • 13min Overview of Naming Ranges 03:36 Multi-Sheet Range Names 06:40 Using Range Names Like Bookmarks 02:43 Naming Ranges Quiz 4 questions Functions 10 lectures • 1hr 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 4 - Multiple VLookups Using the Validation List 04:56 More Functions 07:27 Proper, Round and Other Functions 05:36 Functions Quiz 10 questions 11 more sections Instructors Bruce Myron Productivity Specialist 4.6 Instructor Rating 23,165 Reviews 112,526 Students 19 Courses 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. Show more Show less Joe Parys Support Best-Selling Instructor Proudly Serving 500,000+ Students 4.4 Instructor Rating 59,960 Reviews 877,289 Students 86 Courses Why are 500,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 experience us firsthand ◄ __________________________________________________________________________ Joe and the 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 the Bestselling Udemy instructor with more than 350,000+ students from more than 195 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. Show more Show less Joe Parys Top-Rated Instructor, 800,000+ Students 4.4 Instructor Rating 61,860 Reviews 888,131 Students 92 Courses Why are 800,000+ students enrolled in my online 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 teaching online. I have been named a top instructor on Udemy ► Try enrolling in a course with me and see for yourself ◄ __________________________________________________________________ About Joe Parys: Joe Parys is a bestselling online instructor, entrepreneur, and international speaker whose eLearning courses have been featured on Udemy, Buzzfeed, CBS News, and many other professional platforms. Business: The Joe Parys Academy is a Leader in the E-Learning Industry with more than 97+ Co-Authored Courses . The Founder of The Joe Parys Academy, Joe Parys, is a Bestselling Online Instructor with more than 800,000+ students from around the world. My 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 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. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'678105b0387b008d',m:'7012bf19901bcec4c25fd30366c5bd9199a006b4-1627841417-1800-Afs01pjhLa71BUhKXa54Nfx3S13pL8lBpBCIGC2bME4UgriECye3HGdHQ9mgTnYoZSlxC2W8IYjfBz6kGoSD8c1LA3sGpWDZUDNICykX4cjR6aa/V3X70aj/EgLPD7mrJqd06eMNB/hFZrmC/IwPZLY=',s:[0xcb97af41b2,0x6a7a8ff083],}})();
  5. Learn how to select cells and ranges and discover basic formulas Save time copying and moving, and know how to use the fill handle Create names for ranges or individual cells and work with SUM and many other functions Work with SUM and many other functions Format Excel worksheet content like a pro Learn how to modify a large Excel file to prepare it for printing Use Payment Function and What If Analysis Work with tables, pivot tables, charts and protect your work Find and fix errors easily Show more Show less Requirements Have Microsoft Office 2010 or later installed General knowledge of working with Windows You DO NOT need prior knowledge of Microsoft Excel Description Have you always wanted to learn Microsoft Excel but you just don't know where to start? Or maybe you have started, but you just don't know how to