EXCEL at Work - Complete MS Excel Mastery Beginner to Pro

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

Course Description

"Your Excel skills could land your next job."

- Fortune Magazine

A study reported in the Wall Street Journal found that 78% of middle-skill jobs require digital skills like Excel and Word. And jobs that require digital skills also pay 13% more than those that don't.

Are you ready to land your next job and increase your pay by 13%?

This course is designed to teach you the basics of Microsoft Excel all the way to Excel mastery. It's perfect for you if you are a beginner or intermediate Excel user who needs to drastically increase your Excel skills to impress your boss, get a raise or even land a new job. Everything in the course is taught step-by-step in an easy, stress-free way.

Note: This course is specifically designed for learning on a PC. If you are learning on a Mac, the shortcut keystrokes may be different on your machine.

You'll start at the very beginning by opening and saving your first Excel document. Then you'll move on to:

  1. Create a basic Kitchen Remodel Costs worksheet.

  2. Learn to use the 7 most popular functions in Excel, including IF functions and VLOOKUP.

  3. Create professional looking pie charts, bar charts, column charts and more.

  4. Create a table and a range and sort your data.

  5. Create pivot charts and tables to do lightening fast analysis of your data.

  6. Learn to use new features of Excel including 1-click forecasting and 3D maps.

  7. Take your Excel skills to a whole new level to impress your boss and (although it's ultimately up to you) position yourself for the raise or promotion you deserve.

Excel can be challenging to learn. The hardest part is knowing what to learn. This course is designed to teach you the most popular functions and features of Excel that most people wish they knew how to do. This includes the 7 most popular functions, which you'll learn in this course:

  1. VLOOKUP

  2. COUNT & COUNTA

  3. COUNTIF & COUNTIFS

  4. AVERAGE & AVERAGEA

  5. SUM, SUMIF & SUMIFS

  6. IF

  7. LEFT, RIGHT & MID

Here are more of the most sought after skills in Excel that are included in this course:

  1. Spreadsheets

  2. Tables

  3. Ranges

  4. Pie, Column, Bar and Line charts

  5. Pivot tables

  6. Pivot charts

  7. Tons of tips and tricks to make using Excel easier every day.

So if you're ready to take your Excel skills to the next level and want to learn in an easy-to-follow way, click the Buy now button or check out one of the free preview lectures and I'll see you in the course.

100% Satisfaction Guaranteed

Did you know that Udemy has a 100% 30-day money back guarantee on all courses? I know that you'll love this course, but Udemy's guarantee means that you can watch this entire course and if it doesn't meet your expectations for mastering Excel, we'll refund your money and all your new Excel knowledge is free.

So if you're even considering learning more about Excel for that new job, raise or promotion, sign up for the course and see what is possible with the right knowledge.

Who this course is for:

  • This course is perfect for a first time beginner who needs to learn much more than just the basics.
  • This course would also be helpful for an intermediate Excel user who needs to improve their skills in areas such as using functions; creating charts, graphs and tables; creating pivot tables and charts; formatting spreadsheets; navigating efficiently within an Excel worksheet and more.
  • This course is helpful for increasing personal productivity, efficiency at work or even develeping skills to obtain a better job.
  • This course would not be useful for an Excel user who has already reached the advanced or expert stage.

Expected Outcomes

  1. In this course, you'll quickly become comfortable using the entire Excel dashboard including its tabs, ribbon and tools. You'll learn all the basics of opening an Excel document, creating a spreadsheet from scratch, writing formulas and saving your document to your computer. I'll also walk you through how to create professional charts and graphs to visualize your data, and you'll create pivot tables for lightening fast calculations. Use the most commonly used Excel functions to make powerful calculations. Learn to use several of the new Excel features such as 1-click forecasting, 3D maps and the Tell Me What You Want to Do feature. Tons of helpful tips, tricks and shortcuts along the way to help you master the fundamentals of Excel 2016 and beyond. Great for beginners to intermediate Excel users. Curated for the Udemy Business collection Requirements All you need is a copy of Excel on your computer. The course teaches you how to use Excel starting at the very beginning. Description " Your Excel skills could land your next job." - Fortune Magazine A study reported in the Wall Street Journal found that 78% of middle-skill jobs require digital skills like Excel and Word. And jobs that require digital skills also pay 13% more than those that don't. Are you ready to land your next job and increase your pay by 13% ? This course is designed to teach you the basics of Microsoft Excel all the way to Excel mastery. It's perfect for you if you are a beginner or intermediate Excel user who needs to drastically increase your Excel skills to impress your boss, get a raise or even land a new job. Everything in the course is taught step-by-step in an easy, stress-free way. Note: This course is specifically designed for learning on a PC. If you are learning on a Mac, the shortcut keystrokes may be different on your machine. You'll start at the very beginning by opening and saving your first Excel document. Then you'll move on to: Create a basic Kitchen Remodel Costs worksheet . Learn to use the 7 most popular functions in Excel , including IF functions and VLOOKUP. Create professional looking pie charts, bar charts, column charts and more. Create a table and a range and sort your data. Create pivot charts and tables to do lightening fast analysis of your data. Learn to use new features of Excel including 1-click forecasting and 3D maps . Take your Excel skills to a whole new level to impress your boss and (although it's ultimately up to you) position yourself for the raise or promotion you deserve. Excel can be challenging to learn. The hardest part is knowing what to learn. This course is designed to teach you the most popular functions and features of Excel that most people wish they knew how to do . This includes the 7 most popular functions, which you'll learn in this course: VLOOKUP COUNT & COUNTA COUNTIF & COUNTIFS AVERAGE & AVERAGEA SUM, SUMIF & SUMIFS IF LEFT, RIGHT & MID Here are more of the most sought after skills in Excel that are included in this course: Spreadsheets Tables Ranges Pie, Column, Bar and Line charts Pivot tables Pivot charts Tons of tips and tricks to make using Excel easier every day. So if you're ready to take your Excel skills to the next level and want to learn in an easy-to-follow way, click the Buy now button or check out one of the free preview lectures and I'll see you in the course. 100% Satisfaction Guaranteed Did you know that Udemy has a 100% 30-day money back guarantee on all courses? I know that you'll love this course, but Udemy's guarantee means that you can watch this entire course and if it doesn't meet your expectations for mastering Excel, we'll refund your money and all your new Excel knowledge is free. So if you're even considering learning more about Excel for that new job, raise or promotion, sign up for the course and see what is possible with the right knowledge. Who this course is for: This course is perfect for a first time beginner who needs to learn much more than just the basics. This course would also be helpful for an intermediate Excel user who needs to improve their skills in areas such as using functions; creating charts, graphs and tables; creating pivot tables and charts; formatting spreadsheets; navigating efficiently within an Excel worksheet and more. This course is helpful for increasing personal productivity, efficiency at work or even develeping skills to obtain a better job. This course would not be useful for an Excel user who has already reached the advanced or expert stage. Show more Show less Course content 13 sections • 66 lectures • 6h 52m total length Expand all sections Introduction to Microsoft Excel 4 lectures • 28min Introduction Preview 02:21 How to Get the Most Out of This Course Preview 07:22 Take a Tour of the Excel Dashboard - How to Use the Tabs and Ribbon 09:47 Using Excel Templates to Save Time and Effort 08:56 Creating Your First Excel Document 5 lectures • 22min Saving Your Document Where You Can Find It Preview 02:42 Entering Data and Navagating Around the Cells Preview 02:52 Creating Simple Formulas to Do Powerful Calculations 07:03 Working with Workbooks and Worksheets 08:42 Put Your Knowledge to Work - Create Your First Excel Document 00:23 Create a Kitchen Remodel Cost Worksheet 5 lectures • 19min Introduction - Creating and Formatting Your Heading Preview 03:24 Formatting Subheadings and Columns and Alphabetizings Lists 03:28 Entering and Formatting Numbers 02:55 Create Formulas to Quickly Calculate Your Costs 06:08 Formatting - Grids and Spacing 03:25 Introduction to Excel Formulas and Functions 3 lectures • 15min Introduction to Excel Formulas and Functions Preview 04:00 What is a Formula and What Can It DO for You? 02:00 What is a Function and What Does IT Do? 08:32 3 Things to Know Before You Start Using Functions 4 lectures • 18min The Anatomy of a Formula Preview 06:35 Quickly Select Cells to Use in Your Formula Preview 03:46 Absolute vs. Relative Cell References 06:52 Excel Shortcuts for Mac 00:21 How to Use the 7 Most Popular Excel Functions 8 lectures • 53min How to Use the Downloads to Learn Functions Faster 04:14 AVERAGE and AVERAGEA Functions Preview 03:04 COUNT, COUNTA and COUNTBLANK Functions 04:05 IF Functions 09:36 SUMIF and SUMIFS Functions 06:22 COUNTIF and COUNTIFS Functions 04:26 VLOOKUP Function 12:35 LEFT, RIGHT and MID Functions 08:54 Other Popular Excel Functions 11 lectures • 1hr 5min CONCATENATE - Combining Text 04:36 LEN - Length of Text 03:04 FIND and SEARCH 03:52 MIN and MAX 04:54 AND and OR 06:10 ROUND, CEILING and FLOOR 13:24 TODAY and NOW 02:30 CONDITIONAL FORMATTING 08:46 ALT Shortcut Keys for INDEX/MATCH Lecture 04:17 INDEX and MATCH 09:37 UPPER, LOWER, and PROPER 04:13 Creating Charts From Your Spreadsheet 6 lectures • 37min Charts Download 00:09 Introduction - How to Create a Chart Preview 07:14 Format Your Chart 07:13 Create a Bar Chart 05:54 Create a Pie Chart 11:36 Create a Line Chart 05:14 Pivot Tables and Pivot Charts 6 lectures • 44min Pivot Tables Download 00:04 Introduction to Pivot Tables - Preparing Your Data 11:07 How to Create a Pivot Table 12:13 Put Your Pivot Table to Work 13:37 Pivot Charts Download 00:07 Pivot Charts 06:57 Importing Data from Other Sources 1 lecture • 8min Import from Web, Copy/Paste, and Cleaning Up Data 07:30 3 more sections Instructor Steve McDonald Dedicated Instructor Will Help You Excel | 300K+ Students 4.5 Instructor Rating 30,531 Reviews 399,857 Students 21 Courses Learning is easier with the right tools and instruction. In every one of my courses I take you step-by-step through the tools and knowledge you need to accomplish your goals. My talent is taking complex subjects (like Excel, Access and Photoshop) and making them simple to learn. I wasn't always good at technology . There was a time when I didn't even know how to correctly turn a computer on and off. But over the past 20 years I've dedicated myself to mastering technology. Now I'm proud to call myself a self-taught tech geek. I'm a geek who still speaks the language of normal human beings. I don't use a lot of jargon and fancy words that the average person doesn't understand. I understand how frustrating it can be when the instructor goes too fast or leaves out critical steps in the learning process. That's why I make sure to clearly demonstrate each step for you visually, so you can follow along starting from the very beginning and going along until you've reached mastery. I am here to guide you on your way to success . You can contact me at any step of the way for assistance. Let me know when you're struggling with a concept and I'll get right back to you to keep you moving in the right direction. I'm always happy to help. I believe in you , and I'm here to support you in your learning process. Are you ready to take your skills to the next level? It all starts with knowledge, and my courses make that part easy. Sign up for a course today and I'll help you reach the level of success you deserve . I'll see you in there! 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:'6780f8f53b51bc4e',m:'b8e6b3b464e6d464c526abc3ba9009228113b22f-1627840895-1800-AQAuqooT7Yi2zcF0pt5uz8DVvgHXA+AuwOi0AwNVgvlLhYtcxfFbGq262ytOmrGgLM6HC3xywQ2Rfn++7OIkKiFf9ah5I31OU+pVWhZMlQdPeI6zgcviznafzTmDcmJowWGP1OLRonJdTAUUCs9NHkzV5gyzN6hkVAP1s8kcXDPb7RX4raNb2jdOocTskXOgsfDrh7FwLgOtRQLpgsvUa+M=',s:[0x6586d68bed,0xd70c49261c],}})();
  2. You'll learn all the basics of opening an Excel document, creating a spreadsheet from scratch, writing formulas and saving your document to your computer. I'll also walk you through how to create professional charts and graphs to visualize your data, and you'll create pivot tables for lightening fast calculations. Use the most commonly used Excel functions to make powerful calculations. Learn to use several of the new Excel features such as 1-click forecasting, 3D maps and the Tell Me What You Want to Do feature. Tons of helpful tips, tricks and shortcuts along the way to help you master the fundamentals of Excel 2016 and beyond. Great for beginners to intermediate Excel users. Curated for the Udemy Business collection Requirements All you need is a copy of Excel on your computer. The course teaches you how to use Excel starting at the very beginning. Description " Your Excel skills could land your next job." - Fortune Magazine A study reported in the Wall Street Journal found that 78% of middle-skill jobs require digital skills like Excel and Word. And jobs that require digital skills also pay 13% more than those that don't. Are you ready to land your next job and increase your pay by 13% ? This course is designed to teach you the basics of Microsoft Excel all the way to Excel mastery. It's perfect for you if you are a beginner or intermediate Excel user who needs to drastically increase your Excel skills to impress your boss, get a raise or even land a new job. Everything in the course is taught step-by-step in an easy, stress-free way. Note: This course is specifically designed for learning on a PC. If you are learning on a Mac, the shortcut keystrokes may be different on your machine. You'll start at the very beginning by opening and saving your first Excel document. Then you'll move on to: Create a basic Kitchen Remodel Costs worksheet . Learn to use the 7 most popular functions in Excel , including IF functions and VLOOKUP. Create professional looking pie charts, bar charts, column charts and more. Create a table and a range and sort your data. Create pivot charts and tables to do lightening fast analysis of your data. Learn to use new features of Excel including 1-click forecasting and 3D maps . Take your Excel skills to a whole new level to impress your boss and (although it's ultimately up to you) position yourself for the raise or promotion you deserve. Excel can be challenging to learn. The hardest part is knowing what to learn. This course is designed to teach you the most popular functions and features of Excel that most people wish they knew how to do . This includes the 7 most popular functions, which you'll learn in this course: VLOOKUP COUNT & COUNTA COUNTIF & COUNTIFS AVERAGE & AVERAGEA SUM, SUMIF & SUMIFS IF LEFT, RIGHT & MID Here are more of the most sought after skills in Excel that are included in this course: Spreadsheets Tables Ranges Pie, Column, Bar and Line charts Pivot tables Pivot charts Tons of tips and tricks to make using Excel easier every day. So if you're ready to take your Excel skills to the next level and want to learn in an easy-to-follow way, click the Buy now button or check out one of the free preview lectures and I'll see you in the course. 100% Satisfaction Guaranteed Did you know that Udemy has a 100% 30-day money back guarantee on all courses? I know that you'll love this course, but Udemy's guarantee means that you can watch this entire course and if it doesn't meet your expectations for mastering Excel, we'll refund your money and all your new Excel knowledge is free. So if you're even considering learning more about Excel for that new job, raise or promotion, sign up for the course and see what is possible with the right knowledge. Who this course is for: This course is perfect for a first time beginner who needs to learn much more than just the basics. This course would also be helpful for an intermediate Excel user who needs to improve their skills in areas such as using functions; creating charts, graphs and tables; creating pivot tables and charts; formatting spreadsheets; navigating efficiently within an Excel worksheet and more. This course is helpful for increasing personal productivity, efficiency at work or even develeping skills to obtain a better job. This course would not be useful for an Excel user who has already reached the advanced or expert stage. Show more Show less Course content 13 sections • 66 lectures • 6h 52m total length Expand all sections Introduction to Microsoft Excel 4 lectures • 28min Introduction Preview 02:21 How to Get the Most Out of This Course Preview 07:22 Take a Tour of the Excel Dashboard - How to Use the Tabs and Ribbon 09:47 Using Excel Templates to Save Time and Effort 08:56 Creating Your First Excel Document 5 lectures • 22min Saving Your Document Where You Can Find It Preview 02:42 Entering Data and Navagating Around the Cells Preview 02:52 Creating Simple Formulas to Do Powerful Calculations 07:03 Working with Workbooks and Worksheets 08:42 Put Your Knowledge to Work - Create Your First Excel Document 00:23 Create a Kitchen Remodel Cost Worksheet 5 lectures • 19min Introduction - Creating and Formatting Your Heading Preview 03:24 Formatting Subheadings and Columns and Alphabetizings Lists 03:28 Entering and Formatting Numbers 02:55 Create Formulas to Quickly Calculate Your Costs 06:08 Formatting - Grids and Spacing 03:25 Introduction to Excel Formulas and Functions 3 lectures • 15min Introduction to Excel Formulas and Functions Preview 04:00 What is a Formula and What Can It DO for You? 02:00 What is a Function and What Does IT Do? 08:32 3 Things to Know Before You Start Using Functions 4 lectures • 18min The Anatomy of a Formula Preview 06:35 Quickly Select Cells to Use in Your Formula Preview 03:46 Absolute vs. Relative Cell References 06:52 Excel Shortcuts for Mac 00:21 How to Use the 7 Most Popular Excel Functions 8 lectures • 53min How to Use the Downloads to Learn Functions Faster 04:14 AVERAGE and AVERAGEA Functions Preview 03:04 COUNT, COUNTA and COUNTBLANK Functions 04:05 IF Functions 09:36 SUMIF and SUMIFS Functions 06:22 COUNTIF and COUNTIFS Functions 04:26 VLOOKUP Function 12:35 LEFT, RIGHT and MID Functions 08:54 Other Popular Excel Functions 11 lectures • 1hr 5min CONCATENATE - Combining Text 04:36 LEN - Length of Text 03:04 FIND and SEARCH 03:52 MIN and MAX 04:54 AND and OR 06:10 ROUND, CEILING and FLOOR 13:24 TODAY and NOW 02:30 CONDITIONAL FORMATTING 08:46 ALT Shortcut Keys for INDEX/MATCH Lecture 04:17 INDEX and MATCH 09:37 UPPER, LOWER, and PROPER 04:13 Creating Charts From Your Spreadsheet 6 lectures • 37min Charts Download 00:09 Introduction - How to Create a Chart Preview 07:14 Format Your Chart 07:13 Create a Bar Chart 05:54 Create a Pie Chart 11:36 Create a Line Chart 05:14 Pivot Tables and Pivot Charts 6 lectures • 44min Pivot Tables Download 00:04 Introduction to Pivot Tables - Preparing Your Data 11:07 How to Create a Pivot Table 12:13 Put Your Pivot Table to Work 13:37 Pivot Charts Download 00:07 Pivot Charts 06:57 Importing Data from Other Sources 1 lecture • 8min Import from Web, Copy/Paste, and Cleaning Up Data 07:30 3 more sections Instructor Steve McDonald Dedicated Instructor Will Help You Excel | 300K+ Students 4.5 Instructor Rating 30,531 Reviews 399,857 Students 21 Courses Learning is easier with the right tools and instruction. In every one of my courses I take you step-by-step through the tools and knowledge you need to accomplish your goals. My talent is taking complex subjects (like Excel, Access and Photoshop) and making them simple to learn. I wasn't always good at technology . There was a time when I didn't even know how to correctly turn a computer on and off. But over the past 20 years I've dedicated myself to mastering technology. Now I'm proud to call myself a self-taught tech geek. I'm a geek who still speaks the language of normal human beings. I don't use a lot of jargon and fancy words that the average person doesn't understand. I understand how frustrating it can be when the instructor goes too fast or leaves out critical steps in the learning process. That's why I make sure to clearly demonstrate each step for you visually, so you can follow along starting from the very beginning and going along until you've reached mastery. I am here to guide you on your way to success . You can contact me at any step of the way for assistance. Let me know when you're struggling with a concept and I'll get right back to you to keep you moving in the right direction. I'm always happy to help. I believe in you , and I'm here to support you in your learning process. Are you ready to take your skills to the next level? It all starts with knowledge, and my courses make that part easy. Sign up for a course today and I'll help you reach the level of success you deserve . I'll see you in there! 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:'6780f8f53b51bc4e',m:'b8e6b3b464e6d464c526abc3ba9009228113b22f-1627840895-1800-AQAuqooT7Yi2zcF0pt5uz8DVvgHXA+AuwOi0AwNVgvlLhYtcxfFbGq262ytOmrGgLM6HC3xywQ2Rfn++7OIkKiFf9ah5I31OU+pVWhZMlQdPeI6zgcviznafzTmDcmJowWGP1OLRonJdTAUUCs9NHkzV5gyzN6hkVAP1s8kcXDPb7RX4raNb2jdOocTskXOgsfDrh7FwLgOtRQLpgsvUa+M=',s:[0x6586d68bed,0xd70c49261c],}})();
  3. I'll also walk you through how to create professional charts and graphs to visualize your data, and you'll create pivot tables for lightening fast calculations. Use the most commonly used Excel functions to make powerful calculations. Learn to use several of the new Excel features such as 1-click forecasting, 3D maps and the Tell Me What You Want to Do feature. Tons of helpful tips, tricks and shortcuts along the way to help you master the fundamentals of Excel 2016 and beyond. Great for beginners to intermediate Excel users. Curated for the Udemy Business collection Requirements All you need is a copy of Excel on your computer. The course teaches you how to use Excel starting at the very beginning. Description " Your Excel skills could land your next job." - Fortune Magazine A study reported in the Wall Street Journal found that 78% of middle-skill jobs require digital skills like Excel and Word. And jobs that require digital skills also pay 13% more than those that don't. Are you ready to land your next job and increase your pay by 13% ? This course is designed to teach you the basics of Microsoft Excel all the way to Excel mastery. It's perfect for you if you are a beginner or intermediate Excel user who needs to drastically increase your Excel skills to impress your boss, get a raise or even land a new job. Everything in the course is taught step-by-step in an easy, stress-free way. Note: This course is specifically designed for learning on a PC. If you are learning on a Mac, the shortcut keystrokes may be different on your machine. You'll start at the very beginning by opening and saving your first Excel document. Then you'll move on to: Create a basic Kitchen Remodel Costs worksheet . Learn to use the 7 most popular functions in Excel , including IF functions and VLOOKUP. Create professional looking pie charts, bar charts, column charts and more. Create a table and a range and sort your data. Create pivot charts and tables to do lightening fast analysis of your data. Learn to use new features of Excel including 1-click forecasting and 3D maps . Take your Excel skills to a whole new level to impress your boss and (although it's ultimately up to you) position yourself for the raise or promotion you deserve. Excel can be challenging to learn. The hardest part is knowing what to learn. This course is designed to teach you the most popular functions and features of Excel that most people wish they knew how to do . This includes the 7 most popular functions, which you'll learn in this course: VLOOKUP COUNT & COUNTA COUNTIF & COUNTIFS AVERAGE & AVERAGEA SUM, SUMIF & SUMIFS IF LEFT, RIGHT & MID Here are more of the most sought after skills in Excel that are included in this course: Spreadsheets Tables Ranges Pie, Column, Bar and Line charts Pivot tables Pivot charts Tons of tips and tricks to make using Excel easier every day. So if you're ready to take your Excel skills to the next level and want to learn in an easy-to-follow way, click the Buy now button or check out one of the free preview lectures and I'll see you in the course. 100% Satisfaction Guaranteed Did you know that Udemy has a 100% 30-day money back guarantee on all courses? I know that you'll love this course, but Udemy's guarantee means that you can watch this entire course and if it doesn't meet your expectations for mastering Excel, we'll refund your money and all your new Excel knowledge is free. So if you're even considering learning more about Excel for that new job, raise or promotion, sign up for the course and see what is possible with the right knowledge. Who this course is for: This course is perfect for a first time beginner who needs to learn much more than just the basics. This course would also be helpful for an intermediate Excel user who needs to improve their skills in areas such as using functions; creating charts, graphs and tables; creating pivot tables and charts; formatting spreadsheets; navigating efficiently within an Excel worksheet and more. This course is helpful for increasing personal productivity, efficiency at work or even develeping skills to obtain a better job. This course would not be useful for an Excel user who has already reached the advanced or expert stage. Show more Show less Course content 13 sections • 66 lectures • 6h 52m total length Expand all sections Introduction to Microsoft Excel 4 lectures • 28min Introduction Preview 02:21 How to Get the Most Out of This Course Preview 07:22 Take a Tour of the Excel Dashboard - How to Use the Tabs and Ribbon 09:47 Using Excel Templates to Save Time and Effort 08:56 Creating Your First Excel Document 5 lectures • 22min Saving Your Document Where You Can Find It Preview 02:42 Entering Data and Navagating Around the Cells Preview 02:52 Creating Simple Formulas to Do Powerful Calculations 07:03 Working with Workbooks and Worksheets 08:42 Put Your Knowledge to Work - Create Your First Excel Document 00:23 Create a Kitchen Remodel Cost Worksheet 5 lectures • 19min Introduction - Creating and Formatting Your Heading Preview 03:24 Formatting Subheadings and Columns and Alphabetizings Lists 03:28 Entering and Formatting Numbers 02:55 Create Formulas to Quickly Calculate Your Costs 06:08 Formatting - Grids and Spacing 03:25 Introduction to Excel Formulas and Functions 3 lectures • 15min Introduction to Excel Formulas and Functions Preview 04:00 What is a Formula and What Can It DO for You? 02:00 What is a Function and What Does IT Do? 08:32 3 Things to Know Before You Start Using Functions 4 lectures • 18min The Anatomy of a Formula Preview 06:35 Quickly Select Cells to Use in Your Formula Preview 03:46 Absolute vs. Relative Cell References 06:52 Excel Shortcuts for Mac 00:21 How to Use the 7 Most Popular Excel Functions 8 lectures • 53min How to Use the Downloads to Learn Functions Faster 04:14 AVERAGE and AVERAGEA Functions Preview 03:04 COUNT, COUNTA and COUNTBLANK Functions 04:05 IF Functions 09:36 SUMIF and SUMIFS Functions 06:22 COUNTIF and COUNTIFS Functions 04:26 VLOOKUP Function 12:35 LEFT, RIGHT and MID Functions 08:54 Other Popular Excel Functions 11 lectures • 1hr 5min CONCATENATE - Combining Text 04:36 LEN - Length of Text 03:04 FIND and SEARCH 03:52 MIN and MAX 04:54 AND and OR 06:10 ROUND, CEILING and FLOOR 13:24 TODAY and NOW 02:30 CONDITIONAL FORMATTING 08:46 ALT Shortcut Keys for INDEX/MATCH Lecture 04:17 INDEX and MATCH 09:37 UPPER, LOWER, and PROPER 04:13 Creating Charts From Your Spreadsheet 6 lectures • 37min Charts Download 00:09 Introduction - How to Create a Chart Preview 07:14 Format Your Chart 07:13 Create a Bar Chart 05:54 Create a Pie Chart 11:36 Create a Line Chart 05:14 Pivot Tables and Pivot Charts 6 lectures • 44min Pivot Tables Download 00:04 Introduction to Pivot Tables - Preparing Your Data 11:07 How to Create a Pivot Table 12:13 Put Your Pivot Table to Work 13:37 Pivot Charts Download 00:07 Pivot Charts 06:57 Importing Data from Other Sources 1 lecture • 8min Import from Web, Copy/Paste, and Cleaning Up Data 07:30 3 more sections Instructor Steve McDonald Dedicated Instructor Will Help You Excel | 300K+ Students 4.5 Instructor Rating 30,531 Reviews 399,857 Students 21 Courses Learning is easier with the right tools and instruction. In every one of my courses I take you step-by-step through the tools and knowledge you need to accomplish your goals. My talent is taking complex subjects (like Excel, Access and Photoshop) and making them simple to learn. I wasn't always good at technology . There was a time when I didn't even know how to correctly turn a computer on and off. But over the past 20 years I've dedicated myself to mastering technology. Now I'm proud to call myself a self-taught tech geek. I'm a geek who still speaks the language of normal human beings. I don't use a lot of jargon and fancy words that the average person doesn't understand. I understand how frustrating it can be when the instructor goes too fast or leaves out critical steps in the learning process. That's why I make sure to clearly demonstrate each step for you visually, so you can follow along starting from the very beginning and going along until you've reached mastery. I am here to guide you on your way to success . You can contact me at any step of the way for assistance. Let me know when you're struggling with a concept and I'll get right back to you to keep you moving in the right direction. I'm always happy to help. I believe in you , and I'm here to support you in your learning process. Are you ready to take your skills to the next level? It all starts with knowledge, and my courses make that part easy. Sign up for a course today and I'll help you reach the level of success you deserve . I'll see you in there! 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:'6780f8f53b51bc4e',m:'b8e6b3b464e6d464c526abc3ba9009228113b22f-1627840895-1800-AQAuqooT7Yi2zcF0pt5uz8DVvgHXA+AuwOi0AwNVgvlLhYtcxfFbGq262ytOmrGgLM6HC3xywQ2Rfn++7OIkKiFf9ah5I31OU+pVWhZMlQdPeI6zgcviznafzTmDcmJowWGP1OLRonJdTAUUCs9NHkzV5gyzN6hkVAP1s8kcXDPb7RX4raNb2jdOocTskXOgsfDrh7FwLgOtRQLpgsvUa+M=',s:[0x6586d68bed,0xd70c49261c],}})();
  4. Use the most commonly used Excel functions to make powerful calculations. Learn to use several of the new Excel features such as 1-click forecasting, 3D maps and the Tell Me What You Want to Do feature. Tons of helpful tips, tricks and shortcuts along the way to help you master the fundamentals of Excel 2016 and beyond. Great for beginners to intermediate Excel users. Curated for the Udemy Business collection Requirements All you need is a copy of Excel on your computer. The course teaches you how to use Excel starting at the very beginning. Description " Your Excel skills could land your next job." - Fortune Magazine A study reported in the Wall Street Journal found that 78% of middle-skill jobs require digital skills like Excel and Word. And jobs that require digital skills also pay 13% more than those that don't. Are you ready to land your next job and increase your pay by 13% ? This course is designed to teach you the basics of Microsoft Excel all the way to Excel mastery. It's perfect for you if you are a beginner or intermediate Excel user who needs to drastically increase your Excel skills to impress your boss, get a raise or even land a new job. Everything in the course is taught step-by-step in an easy, stress-free way. Note: This course is specifically designed for learning on a PC. If you are learning on a Mac, the shortcut keystrokes may be different on your machine. You'll start at the very beginning by opening and saving your first Excel document. Then you'll move on to: Create a basic Kitchen Remodel Costs worksheet . Learn to use the 7 most popular functions in Excel , including IF functions and VLOOKUP. Create professional looking pie charts, bar charts, column charts and more. Create a table and a range and sort your data. Create pivot charts and tables to do lightening fast analysis of your data. Learn to use new features of Excel including 1-click forecasting and 3D maps . Take your Excel skills to a whole new level to impress your boss and (although it's ultimately up to you) position yourself for the raise or promotion you deserve. Excel can be challenging to learn. The hardest part is knowing what to learn. This course is designed to teach you the most popular functions and features of Excel that most people wish they knew how to do . This includes the 7 most popular functions, which you'll learn in this course: VLOOKUP COUNT & COUNTA COUNTIF & COUNTIFS AVERAGE & AVERAGEA SUM, SUMIF & SUMIFS IF LEFT, RIGHT & MID Here are more of the most sought after skills in Excel that are included in this course: Spreadsheets Tables Ranges Pie, Column, Bar and Line charts Pivot tables Pivot charts Tons of tips and tricks to make using Excel easier every day. So if you're ready to take your Excel skills to the next level and want to learn in an easy-to-follow way, click the Buy now button or check out one of the free preview lectures and I'll see you in the course. 100% Satisfaction Guaranteed Did you know that Udemy has a 100% 30-day money back guarantee on all courses? I know that you'll love this course, but Udemy's guarantee means that you can watch this entire course and if it doesn't meet your expectations for mastering Excel, we'll refund your money and all your new Excel knowledge is free. So if you're even considering learning more about Excel for that new job, raise or promotion, sign up for the course and see what is possible with the right knowledge. Who this course is for: This course is perfect for a first time beginner who needs to learn much more than just the basics. This course would also be helpful for an intermediate Excel user who needs to improve their skills in areas such as using functions; creating charts, graphs and tables; creating pivot tables and charts; formatting spreadsheets; navigating efficiently within an Excel worksheet and more. This course is helpful for increasing personal productivity, efficiency at work or even develeping skills to obtain a better job. This course would not be useful for an Excel user who has already reached the advanced or expert stage. Show more Show less Course content 13 sections • 66 lectures • 6h 52m total length Expand all sections Introduction to Microsoft Excel 4 lectures • 28min Introduction Preview 02:21 How to Get the Most Out of This Course Preview 07:22 Take a Tour of the Excel Dashboard - How to Use the Tabs and Ribbon 09:47 Using Excel Templates to Save Time and Effort 08:56 Creating Your First Excel Document 5 lectures • 22min Saving Your Document Where You Can Find It Preview 02:42 Entering Data and Navagating Around the Cells Preview 02:52 Creating Simple Formulas to Do Powerful Calculations 07:03 Working with Workbooks and Worksheets 08:42 Put Your Knowledge to Work - Create Your First Excel Document 00:23 Create a Kitchen Remodel Cost Worksheet 5 lectures • 19min Introduction - Creating and Formatting Your Heading Preview 03:24 Formatting Subheadings and Columns and Alphabetizings Lists 03:28 Entering and Formatting Numbers 02:55 Create Formulas to Quickly Calculate Your Costs 06:08 Formatting - Grids and Spacing 03:25 Introduction to Excel Formulas and Functions 3 lectures • 15min Introduction to Excel Formulas and Functions Preview 04:00 What is a Formula and What Can It DO for You? 02:00 What is a Function and What Does IT Do? 08:32 3 Things to Know Before You Start Using Functions 4 lectures • 18min The Anatomy of a Formula Preview 06:35 Quickly Select Cells to Use in Your Formula Preview 03:46 Absolute vs. Relative Cell References 06:52 Excel Shortcuts for Mac 00:21 How to Use the 7 Most Popular Excel Functions 8 lectures • 53min How to Use the Downloads to Learn Functions Faster 04:14 AVERAGE and AVERAGEA Functions Preview 03:04 COUNT, COUNTA and COUNTBLANK Functions 04:05 IF Functions 09:36 SUMIF and SUMIFS Functions 06:22 COUNTIF and COUNTIFS Functions 04:26 VLOOKUP Function 12:35 LEFT, RIGHT and MID Functions 08:54 Other Popular Excel Functions 11 lectures • 1hr 5min CONCATENATE - Combining Text 04:36 LEN - Length of Text 03:04 FIND and SEARCH 03:52 MIN and MAX 04:54 AND and OR 06:10 ROUND, CEILING and FLOOR 13:24 TODAY and NOW 02:30 CONDITIONAL FORMATTING 08:46 ALT Shortcut Keys for INDEX/MATCH Lecture 04:17 INDEX and MATCH 09:37 UPPER, LOWER, and PROPER 04:13 Creating Charts From Your Spreadsheet 6 lectures • 37min Charts Download 00:09 Introduction - How to Create a Chart Preview 07:14 Format Your Chart 07:13 Create a Bar Chart 05:54 Create a Pie Chart 11:36 Create a Line Chart 05:14 Pivot Tables and Pivot Charts 6 lectures • 44min Pivot Tables Download 00:04 Introduction to Pivot Tables - Preparing Your Data 11:07 How to Create a Pivot Table 12:13 Put Your Pivot Table to Work 13:37 Pivot Charts Download 00:07 Pivot Charts 06:57 Importing Data from Other Sources 1 lecture • 8min Import from Web, Copy/Paste, and Cleaning Up Data 07:30 3 more sections Instructor Steve McDonald Dedicated Instructor Will Help You Excel | 300K+ Students 4.5 Instructor Rating 30,531 Reviews 399,857 Students 21 Courses Learning is easier with the right tools and instruction. In every one of my courses I take you step-by-step through the tools and knowledge you need to accomplish your goals. My talent is taking complex subjects (like Excel, Access and Photoshop) and making them simple to learn. I wasn't always good at technology . There was a time when I didn't even know how to correctly turn a computer on and off. But over the past 20 years I've dedicated myself to mastering technology. Now I'm proud to call myself a self-taught tech geek. I'm a geek who still speaks the language of normal human beings. I don't use a lot of jargon and fancy words that the average person doesn't understand. I understand how frustrating it can be when the instructor goes too fast or leaves out critical steps in the learning process. That's why I make sure to clearly demonstrate each step for you visually, so you can follow along starting from the very beginning and going along until you've reached mastery. I am here to guide you on your way to success . You can contact me at any step of the way for assistance. Let me know when you're struggling with a concept and I'll get right back to you to keep you moving in the right direction. I'm always happy to help. I believe in you , and I'm here to support you in your learning process. Are you ready to take your skills to the next level? It all starts with knowledge, and my courses make that part easy. Sign up for a course today and I'll help you reach the level of success you deserve . I'll see you in there! 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:'6780f8f53b51bc4e',m:'b8e6b3b464e6d464c526abc3ba9009228113b22f-1627840895-1800-AQAuqooT7Yi2zcF0pt5uz8DVvgHXA+AuwOi0AwNVgvlLhYtcxfFbGq262ytOmrGgLM6HC3xywQ2Rfn++7OIkKiFf9ah5I31OU+pVWhZMlQdPeI6zgcviznafzTmDcmJowWGP1OLRonJdTAUUCs9NHkzV5gyzN6hkVAP1s8kcXDPb7RX4raNb2jdOocTskXOgsfDrh7FwLgOtRQLpgsvUa+M=',s:[0x6586d68bed,0xd70c49261c],}})();
  5. Learn to use several of the new Excel features such as 1-click forecasting, 3D maps and the Tell Me What You Want to Do feature. Tons of helpful tips, tricks and shortcuts along the way to help you master the fundamentals of Excel 2016 and beyond. Great for beginners to intermediate Excel users. Curated for the Udemy Business collection Requirements All you need is a copy of Excel on your computer. The course teaches you how to use Excel starting at the very beginning. Description " Your Excel skills could land your next job." - Fortune Magazine A study reported in the Wall Street Journal found that 78% of middle-skill jobs require digital skills like Excel and Word. And jobs that require digital skills also pay 13% more than those that don't. Are you ready to land your next job and increase your pay by 13% ? This course is designed to teach you the basics of Microsoft Excel all the way to Excel mastery. It's perfect for you if you are a beginner or intermediate Excel user who needs to drastically increase your Excel skills to impress your boss, get a raise or even land a new job. Everything in the course is taught step-by-step in an easy, stress-free way. Note: This course is specifically designed for learning on a PC. If you are learning on a Mac, the shortcut keystrokes may be different on your machine. You'll start at the very beginning by opening and saving your first Excel document. Then you'll move on to: Create a basic Kitchen Remodel Costs worksheet . Learn to use the 7 most popular functions in Excel , including IF functions and VLOOKUP. Create professional looking pie charts, bar charts, column charts and more. Create a table and a range and sort your data. Create pivot charts and tables to do lightening fast analysis of your data. Learn to use new features of Excel including 1-click forecasting and 3D maps . Take your Excel skills to a whole new level to impress your boss and (although it's ultimately up to you) position yourself for the raise or promotion you deserve. Excel can be challenging to learn. The hardest part is knowing what to learn. This course is designed to teach you the most popular functions and features of Excel that most people wish they knew how to do . This includes the 7 most popular functions, which you'll learn in this course: VLOOKUP COUNT & COUNTA COUNTIF & COUNTIFS AVERAGE & AVERAGEA SUM, SUMIF & SUMIFS IF LEFT, RIGHT & MID Here are more of the most sought after skills in Excel that are included in this course: Spreadsheets Tables Ranges Pie, Column, Bar and Line charts Pivot tables Pivot charts Tons of tips and tricks to make using Excel easier every day. So if you're ready to take your Excel skills to the next level and want to learn in an easy-to-follow way, click the Buy now button or check out one of the free preview lectures and I'll see you in the course. 100% Satisfaction Guaranteed Did you know that Udemy has a 100% 30-day money back guarantee on all courses? I know that you'll love this course, but Udemy's guarantee means that you can watch this entire course and if it doesn't meet your expectations for mastering Excel, we'll refund your money and all your new Excel knowledge is free. So if you're even considering learning more about Excel for that new job, raise or promotion, sign up for the course and see what is possible with the right knowledge. Who this course is for: This course is perfect for a first time beginner who needs to learn much more than just the basics. This course would also be helpful for an intermediate Excel user who needs to improve their skills in areas such as using functions; creating charts, graphs and tables; creating pivot tables and charts; formatting spreadsheets; navigating efficiently within an Excel worksheet and more. This course is helpful for increasing personal productivity, efficiency at work or even develeping skills to obtain a better job. This course would not be useful for an Excel user who has already reached the advanced or expert stage. Show more Show less Course content 13 sections • 66 lectures • 6h 52m total length Expand all sections Introduction to Microsoft Excel 4 lectures • 28min Introduction Preview 02:21 How to Get the Most Out of This Course Preview 07:22 Take a Tour of the Excel Dashboard - How to Use the Tabs and Ribbon 09:47 Using Excel Templates to Save Time and Effort 08:56 Creating Your First Excel Document 5 lectures • 22min Saving Your Document Where You Can Find It Preview 02:42 Entering Data and Navagating Around the Cells Preview 02:52 Creating Simple Formulas to Do Powerful Calculations 07:03 Working with Workbooks and Worksheets 08:42 Put Your Knowledge to Work - Create Your First Excel Document 00:23 Create a Kitchen Remodel Cost Worksheet 5 lectures • 19min Introduction - Creating and Formatting Your Heading Preview 03:24 Formatting Subheadings and Columns and Alphabetizings Lists 03:28 Entering and Formatting Numbers 02:55 Create Formulas to Quickly Calculate Your Costs 06:08 Formatting - Grids and Spacing 03:25 Introduction to Excel Formulas and Functions 3 lectures • 15min Introduction to Excel Formulas and Functions Preview 04:00 What is a Formula and What Can It DO for You? 02:00 What is a Function and What Does IT Do? 08:32 3 Things to Know Before You Start Using Functions 4 lectures • 18min The Anatomy of a Formula Preview 06:35 Quickly Select Cells to Use in Your Formula Preview 03:46 Absolute vs. Relative Cell References 06:52 Excel Shortcuts for Mac 00:21 How to Use the 7 Most Popular Excel Functions 8 lectures • 53min How to Use the Downloads to Learn Functions Faster 04:14 AVERAGE and AVERAGEA Functions Preview 03:04 COUNT, COUNTA and COUNTBLANK Functions 04:05 IF Functions 09:36 SUMIF and SUMIFS Functions 06:22 COUNTIF and COUNTIFS Functions 04:26 VLOOKUP Function 12:35 LEFT, RIGHT and MID Functions 08:54 Other Popular Excel Functions 11 lectures • 1hr 5min CONCATENATE - Combining Text 04:36 LEN - Length of Text 03:04 FIND and SEARCH 03:52 MIN and MAX 04:54 AND and OR 06:10 ROUND, CEILING and FLOOR 13:24 TODAY and NOW 02:30 CONDITIONAL FORMATTING 08:46 ALT Shortcut Keys for INDEX/MATCH Lecture 04:17 INDEX and MATCH 09:37 UPPER, LOWER, and PROPER 04:13 Creating Charts From Your Spreadsheet 6 lectures • 37min Charts Download 00:09 Introduction - How to Create a Chart Preview 07:14 Format Your Chart 07:13 Create a Bar Chart 05:54 Create a Pie Chart 11:36 Create a Line Chart 05:14 Pivot Tables and Pivot Charts 6 lectures • 44min Pivot Tables Download 00:04 Introduction to Pivot Tables - Preparing Your Data 11:07 How to Create a Pivot Table 12:13 Put Your Pivot Table to Work 13:37 Pivot Charts Download 00:07 Pivot Charts 06:57 Importing Data from Other Sources 1 lecture • 8min Import from Web, Copy/Paste, and Cleaning Up Data 07:30 3 more sections Instructor Steve McDonald Dedicated Instructor Will Help You Excel | 300K+ Students 4.5 Instructor Rating 30,531 Reviews 399,857 Students 21 Courses Learning is easier with the right tools and instruction. In every one of my courses I take you step-by-step through the tools and knowledge you need to accomplish your goals. My talent is taking complex subjects (like Excel, Access and Photoshop) and making them simple to learn. I wasn't always good at technology . There was a time when I didn't even know how to correctly turn a computer on and off. But over the past 20 years I've dedicated myself to mastering technology. Now I'm proud to call myself a self-taught tech geek. I'm a geek who still speaks the language of normal human beings. I don't use a lot of jargon and fancy words that the average person doesn't understand. I understand how frustrating it can be when the instructor goes too fast or leaves out critical steps in the learning process. That's why I make sure to clearly demonstrate each step for you visually, so you can follow along starting from the very beginning and going along until you've reached mastery. I am here to guide you on your way to success . You can contact me at any step of the way for assistance. Let me know when you're struggling with a concept and I'll get right back to you to keep you moving in the right direction. I'm always happy to help. I believe in you , and I'm here to support you in your learning process. Are you ready to take your skills to the next level? It all starts with knowledge, and my courses make that part easy. Sign up for a course today and I'll help you reach the level of success you deserve . I'll see you in there! 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:'6780f8f53b51bc4e',m:'b8e6b3b464e6d464c526abc3ba9009228113b22f-1627840895-1800-AQAuqooT7Yi2zcF0pt5uz8DVvgHXA+AuwOi0AwNVgvlLhYtcxfFbGq262ytOmrGgLM6HC3xywQ2Rfn++7OIkKiFf9ah5I31OU+pVWhZMlQdPeI6zgcviznafzTmDcmJowWGP1OLRonJdTAUUCs9NHkzV5gyzN6hkVAP1s8kcXDPb7RX4raNb2jdOocTskXOgsfDrh7FwLgOtRQLpgsvUa+M=',s:[0x6586d68bed,0xd70c49261c],}})();
  6. Tons of helpful tips, tricks and shortcuts along the way to help you master the fundamentals of Excel 2016 and beyond. Great for beginners to intermediate Excel users. Curated for the Udemy Business collection Requirements All you need is a copy of Excel on your computer. The course teaches you how to use Excel starting at the very beginning. Description " Your Excel skills could land your next job." - Fortune Magazine A study reported in the Wall Street Journal found that 78% of middle-skill jobs require digital skills like Excel and Word. And jobs that require digital skills also pay 13% more than those that don't. Are you ready to land your next job and increase your pay by 13% ? This course is designed to teach you the basics of Microsoft Excel all the way to Excel mastery. It's perfect for you if you are a beginner or intermediate Excel user who needs to drastically increase your Excel skills to impress your boss, get a raise or even land a new job. Everything in the course is taught step-by-step in an easy, stress-free way. Note: This course is specifically designed for learning on a PC. If you are learning on a Mac, the shortcut keystrokes may be different on your machine. You'll start at the very beginning by opening and saving your first Excel document. Then you'll move on to: Create a basic Kitchen Remodel Costs worksheet . Learn to use the 7 most popular functions in Excel , including IF functions and VLOOKUP. Create professional looking pie charts, bar charts, column charts and more. Create a table and a range and sort your data. Create pivot charts and tables to do lightening fast analysis of your data. Learn to use new features of Excel including 1-click forecasting and 3D maps . Take your Excel skills to a whole new level to impress your boss and (although it's ultimately up to you) position yourself for the raise or promotion you deserve. Excel can be challenging to learn. The hardest part is knowing what to learn. This course is designed to teach you the most popular functions and features of Excel that most people wish they knew how to do . This includes the 7 most popular functions, which you'll learn in this course: VLOOKUP COUNT & COUNTA COUNTIF & COUNTIFS AVERAGE & AVERAGEA SUM, SUMIF & SUMIFS IF LEFT, RIGHT & MID Here are more of the most sought after skills in Excel that are included in this course: Spreadsheets Tables Ranges Pie, Column, Bar and Line charts Pivot tables Pivot charts Tons of tips and tricks to make using Excel easier every day. So if you're ready to take your Excel skills to the next level and want to learn in an easy-to-follow way, click the Buy now button or check out one of the free preview lectures and I'll see you in the course. 100% Satisfaction Guaranteed Did you know that Udemy has a 100% 30-day money back guarantee on all courses? I know that you'll love this course, but Udemy's guarantee means that you can watch this entire course and if it doesn't meet your expectations for mastering Excel, we'll refund your money and all your new Excel knowledge is free. So if you're even considering learning more about Excel for that new job, raise or promotion, sign up for the course and see what is possible with the right knowledge. Who this course is for: This course is perfect for a first time beginner who needs to learn much more than just the basics. This course would also be helpful for an intermediate Excel user who needs to improve their skills in areas such as using functions; creating charts, graphs and tables; creating pivot tables and charts; formatting spreadsheets; navigating efficiently within an Excel worksheet and more. This course is helpful for increasing personal productivity, efficiency at work or even develeping skills to obtain a better job. This course would not be useful for an Excel user who has already reached the advanced or expert stage. Show more Show less Course content 13 sections • 66 lectures • 6h 52m total length Expand all sections Introduction to Microsoft Excel 4 lectures • 28min Introduction Preview 02:21 How to Get the Most Out of This Course Preview 07:22 Take a Tour of the Excel Dashboard - How to Use the Tabs and Ribbon 09:47 Using Excel Templates to Save Time and Effort 08:56 Creating Your First Excel Document 5 lectures • 22min Saving Your Document Where You Can Find It Preview 02:42 Entering Data and Navagating Around the Cells Preview 02:52 Creating Simple Formulas to Do Powerful Calculations 07:03 Working with Workbooks and Worksheets 08:42 Put Your Knowledge to Work - Create Your First Excel Document 00:23 Create a Kitchen Remodel Cost Worksheet 5 lectures • 19min Introduction - Creating and Formatting Your Heading Preview 03:24 Formatting Subheadings and Columns and Alphabetizings Lists 03:28 Entering and Formatting Numbers 02:55 Create Formulas to Quickly Calculate Your Costs 06:08 Formatting - Grids and Spacing 03:25 Introduction to Excel Formulas and Functions 3 lectures • 15min Introduction to Excel Formulas and Functions Preview 04:00 What is a Formula and What Can It DO for You? 02:00 What is a Function and What Does IT Do? 08:32 3 Things to Know Before You Start Using Functions 4 lectures • 18min The Anatomy of a Formula Preview 06:35 Quickly Select Cells to Use in Your Formula Preview 03:46 Absolute vs. Relative Cell References 06:52 Excel Shortcuts for Mac 00:21 How to Use the 7 Most Popular Excel Functions 8 lectures • 53min How to Use the Downloads to Learn Functions Faster 04:14 AVERAGE and AVERAGEA Functions Preview 03:04 COUNT, COUNTA and COUNTBLANK Functions 04:05 IF Functions 09:36 SUMIF and SUMIFS Functions 06:22 COUNTIF and COUNTIFS Functions 04:26 VLOOKUP Function 12:35 LEFT, RIGHT and MID Functions 08:54 Other Popular Excel Functions 11 lectures • 1hr 5min CONCATENATE - Combining Text 04:36 LEN - Length of Text 03:04 FIND and SEARCH 03:52 MIN and MAX 04:54 AND and OR 06:10 ROUND, CEILING and FLOOR 13:24 TODAY and NOW 02:30 CONDITIONAL FORMATTING 08:46 ALT Shortcut Keys for INDEX/MATCH Lecture 04:17 INDEX and MATCH 09:37 UPPER, LOWER, and PROPER 04:13 Creating Charts From Your Spreadsheet 6 lectures • 37min Charts Download 00:09 Introduction - How to Create a Chart Preview 07:14 Format Your Chart 07:13 Create a Bar Chart 05:54 Create a Pie Chart 11:36 Create a Line Chart 05:14 Pivot Tables and Pivot Charts 6 lectures • 44min Pivot Tables Download 00:04 Introduction to Pivot Tables - Preparing Your Data 11:07 How to Create a Pivot Table 12:13 Put Your Pivot Table to Work 13:37 Pivot Charts Download 00:07 Pivot Charts 06:57 Importing Data from Other Sources 1 lecture • 8min Import from Web, Copy/Paste, and Cleaning Up Data 07:30 3 more sections Instructor Steve McDonald Dedicated Instructor Will Help You Excel | 300K+ Students 4.5 Instructor Rating 30,531 Reviews 399,857 Students 21 Courses Learning is easier with the right tools and instruction. In every one of my courses I take you step-by-step through the tools and knowledge you need to accomplish your goals. My talent is taking complex subjects (like Excel, Access and Photoshop) and making them simple to learn. I wasn't always good at technology . There was a time when I didn't even know how to correctly turn a computer on and off. But over the past 20 years I've dedicated myself to mastering technology. Now I'm proud to call myself a self-taught tech geek. I'm a geek who still speaks the language of normal human beings. I don't use a lot of jargon and fancy words that the average person doesn't understand. I understand how frustrating it can be when the instructor goes too fast or leaves out critical steps in the learning process. That's why I make sure to clearly demonstrate each step for you visually, so you can follow along starting from the very beginning and going along until you've reached mastery. I am here to guide you on your way to success . You can contact me at any step of the way for assistance. Let me know when you're struggling with a concept and I'll get right back to you to keep you moving in the right direction. I'm always happy to help. I believe in you , and I'm here to support you in your learning process. Are you ready to take your skills to the next level? It all starts with knowledge, and my courses make that part easy. Sign up for a course today and I'll help you reach the level of success you deserve . I'll see you in there! 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:'6780f8f53b51bc4e',m:'b8e6b3b464e6d464c526abc3ba9009228113b22f-1627840895-1800-AQAuqooT7Yi2zcF0pt5uz8DVvgHXA+AuwOi0AwNVgvlLhYtcxfFbGq262ytOmrGgLM6HC3xywQ2Rfn++7OIkKiFf9ah5I31OU+pVWhZMlQdPeI6zgcviznafzTmDcmJowWGP1OLRonJdTAUUCs9NHkzV5gyzN6hkVAP1s8kcXDPb7RX4raNb2jdOocTskXOgsfDrh7FwLgOtRQLpgsvUa+M=',s:[0x6586d68bed,0xd70c49261c],}})();
  7. Great for beginners to intermediate Excel users. Curated for the Udemy Business collection Requirements All you need is a copy of Excel on your computer. The course teaches you how to use Excel starting at the very beginning. Description " Your Excel skills could land your next job." - Fortune Magazine A study reported in the Wall Street Journal found that 78% of middle-skill jobs require digital skills like Excel and Word. And jobs that require digital skills also pay 13% more than those that don't. Are you ready to land your next job and increase your pay by 13% ? This course is designed to teach you the basics of Microsoft Excel all the way to Excel mastery. It's perfect for you if you are a beginner or intermediate Excel user who needs to drastically increase your Excel skills to impress your boss, get a raise or even land a new job. Everything in the course is taught step-by-step in an easy, stress-free way. Note: This course is specifically designed for learning on a PC. If you are learning on a Mac, the shortcut keystrokes may be different on your machine. You'll start at the very beginning by opening and saving your first Excel document. Then you'll move on to: Create a basic Kitchen Remodel Costs worksheet . Learn to use the 7 most popular functions in Excel , including IF functions and VLOOKUP. Create professional looking pie charts, bar charts, column charts and more. Create a table and a range and sort your data. Create pivot charts and tables to do lightening fast analysis of your data. Learn to use new features of Excel including 1-click forecasting and 3D maps . Take your Excel skills to a whole new level to impress your boss and (although it's ultimately up to you) position yourself for the raise or promotion you deserve. Excel can be challenging to learn. The hardest part is knowing what to learn. This course is designed to teach you the most popular functions and features of Excel that most people wish they knew how to do . This includes the 7 most popular functions, which you'll learn in this course: VLOOKUP COUNT & COUNTA COUNTIF & COUNTIFS AVERAGE & AVERAGEA SUM, SUMIF & SUMIFS IF LEFT, RIGHT & MID Here are more of the most sought after skills in Excel that are included in this course: Spreadsheets Tables Ranges Pie, Column, Bar and Line charts Pivot tables Pivot charts Tons of tips and tricks to make using Excel easier every day. So if you're ready to take your Excel skills to the next level and want to learn in an easy-to-follow way, click the Buy now button or check out one of the free preview lectures and I'll see you in the course. 100% Satisfaction Guaranteed Did you know that Udemy has a 100% 30-day money back guarantee on all courses? I know that you'll love this course, but Udemy's guarantee means that you can watch this entire course and if it doesn't meet your expectations for mastering Excel, we'll refund your money and all your new Excel knowledge is free. So if you're even considering learning more about Excel for that new job, raise or promotion, sign up for the course and see what is possible with the right knowledge. Who this course is for: This course is perfect for a first time beginner who needs to learn much more than just the basics. This course would also be helpful for an intermediate Excel user who needs to improve their skills in areas such as using functions; creating charts, graphs and tables; creating pivot tables and charts; formatting spreadsheets; navigating efficiently within an Excel worksheet and more. This course is helpful for increasing personal productivity, efficiency at work or even develeping skills to obtain a better job. This course would not be useful for an Excel user who has already reached the advanced or expert stage. Show more Show less Course content 13 sections • 66 lectures • 6h 52m total length Expand all sections Introduction to Microsoft Excel 4 lectures • 28min Introduction Preview 02:21 How to Get the Most Out of This Course Preview 07:22 Take a Tour of the Excel Dashboard - How to Use the Tabs and Ribbon 09:47 Using Excel Templates to Save Time and Effort 08:56 Creating Your First Excel Document 5 lectures • 22min Saving Your Document Where You Can Find It Preview 02:42 Entering Data and Navagating Around the Cells Preview 02:52 Creating Simple Formulas to Do Powerful Calc