Microsoft Excel 2016 Beginners & Intermediate Excel Training

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

Course Description

Do you want to learn how to work with Excel 2016?

Even if you don’t have any prior experience?

If so, then this is the right course for you!

A Verifiable Certificate of Completion is presented to all students who complete this course.

Microsoft Excel 2016 is here, and it promises to be one of the greatest versions that we’ve seen so far.

However, it’s essential that you learn how to work with it effectively.

If you want to become any of the following…

  • Executive Assistant

  • Office Clerk

  • Auditor

  • Accountant

  • Business Analyst

  • Financial Analyst

  • Credit Counselor

  • Sales Representative

  • Sales Manager

  • Financial Manager

  • Investment Banker

  • Real Estate Agent

  • Market Research Analyst

  • Financial Advisor

  • Business Operations Manager

  • Entrepreneur

  • Someone who is involved with a business and would like to be successful

Then you simply have to learn Microsoft Excel 2016. There is no way around it.

But how can you do that if you have very limited time and no prior training? And how can you be certain that you are not missing an important piece of the puzzle?

Microsoft Excel 2016 Beginners & Intermediate Excel Training is here for you. One of the best Excel courses available on Udemy, it includes everything you’ll need. We will start from the very basics and then gradually build a solid foundation that will serve you well throughout your career.

What makes this course different from the rest of the Excel courses out there?

  • High quality of production – HD video and animated slides (this isn’t a collection of boring lectures!)

  • Knowledgeable instructor (experience in Big 4 Accounting + Commercial Finance)

  • Downloadable materials: The course comes with a complete set of downloadable materials (handouts, Excel files, etc.)

  • Extensive Case Studies that will help you reinforce everything that you’ve learned

  • Excellent support: If you don’t understand a concept or you simply want to drop us a line, you’ll receive an answer within 24 hours

  • Dynamic: We don’t want to waste your time! The instructor maintains a very good pace throughout the whole course

How come Microsoft Excel is so important?

Every large company uses it, right? So if you want to learn a new skill that is highly valued by all employers, you should start here.

Here are 5 more reasons why you should take this course and learn Excel:

  • Jobs. A solid understanding of Excel opens the door for a number of career paths

  • Promotions. Top Excel users are promoted very easily inside large corporations

  • Bill Gates knows how to work with Excel

  • Secure Future. Excel skills remain with you and provide extra security. You won’t ever have to fear unemployment

  • Girls dig guys who are proficient in Excel! Guys who can use VLOOKUP are proven to be the most popular with women J

This course is suitable for people without any previous experience in Excel. We will start from the very basics and will gradually move on to some of the more advanced features, such as lookup functions, functions with conditions, goal seek, pivot tables, custom formatting, Excel 2016 charts, and other tools that are often used for the purposes of Financial Modeling.

Additionally, the course includes practical case studies that will reinforce everything that you learn. One of the exercises that we will see in the course consists of building a complete Profit & Loss statement from scratch.

This course is perfect for University students, Entry-level Finance, Business and Marketing professionals who would like to grow faster than their peers.

Please don’t forget that the course comes with Udemy’s 30-day unconditional money-back-in-full guarantee. And why not give such a guarantee, when we are convinced that it will provide a ton of value for you?

Enrol today and let's start this journey together!

Who this course is for:

  • Beginner, Intermediate and Advanced users who want to be proficient in Excel

Expected Outcomes

  1. Work comfortably with Microsoft Excel 2016 and many of its advanced features Learn what is new in Excel 2016 Be much quicker at carrying out regular tasks Become your team's go-to-guy when it comes to Excel Use sophisticated functions that will improve the quality of your work Curated for the Udemy Business collection Requirements Install Microsoft 2016, 2013 or 2010 No previous knowledge is required! Great for students who want to learn at their own pace Description Do you want to learn how to work with Excel 2016? Even if you don’t have any prior experience? If so, then this is the right course for you! A Verifiable Certificate of Completion is presented to all students who complete this course. Microsoft Excel 2016 is here, and it promises to be one of the greatest versions that we’ve seen so far. However, it’s essential that you learn how to work with it effectively. If you want to become any of the following… Executive Assistant Office Clerk Auditor Accountant Business Analyst Financial Analyst Credit Counselor Sales Representative Sales Manager Financial Manager Investment Banker Real Estate Agent Market Research Analyst Financial Advisor Business Operations Manager Entrepreneur Someone who is involved with a business and would like to be successful Then you simply have to learn Microsoft Excel 2016. There is no way around it. But how can you do that if you have very limited time and no prior training? And how can you be certain that you are not missing an important piece of the puzzle? Microsoft Excel 2016 Beginners & Intermediate Excel Training is here for you . One of the best Excel courses available on Udemy, it includes everything you’ll need. We will start from the very basics and then gradually build a solid foundation that will serve you well throughout your career. What makes this course different from the rest of the Excel courses out there? High quality of production – HD video and animated slides (this isn’t a collection of boring lectures!) Knowledgeable instructor (experience in Big 4 Accounting + Commercial Finance) Downloadable materials: The course comes with a complete set of downloadable materials (handouts, Excel files, etc.) Extensive Case Studies that will help you reinforce everything that you’ve learned Excellent support: If you don’t understand a concept or you simply want to drop us a line, you’ll receive an answer within 24 hours Dynamic: We don’t want to waste your time! The instructor maintains a very good pace throughout the whole course How come Microsoft Excel is so important? Every large company uses it, right? So if you want to learn a new skill that is highly valued by all employers, you should start here. Here are 5 more reasons why you should take this course and learn Excel: Jobs. A solid understanding of Excel opens the door for a number of career paths Promotions. Top Excel users are promoted very easily inside large corporations Bill Gates knows how to work with Excel Secure Future. Excel skills remain with you and provide extra security. You won’t ever have to fear unemployment Girls dig guys who are proficient in Excel! Guys who can use VLOOKUP are proven to be the most popular with women J This course is suitable for people without any previous experience in Excel. We will start from the very basics and will gradually move on to some of the more advanced features, such as lookup functions, functions with conditions, goal seek, pivot tables, custom formatting, Excel 2016 charts, and other tools that are often used for the purposes of Financial Modeling. Additionally, the course includes practical case studies that will reinforce everything that you learn. One of the exercises that we will see in the course consists of building a complete Profit & Loss statement from scratch. This course is perfect for University students, Entry-level Finance, Business and Marketing professionals who would like to grow faster than their peers. Please don’t forget that the course comes with Udemy’s 30-day unconditional money-back-in-full guarantee. And why not give such a guarantee, when we are convinced that it will provide a ton of value for you? Enrol today and let's start this journey together! Who this course is for: Beginner, Intermediate and Advanced users who want to be proficient in Excel Show more Show less Featured review Kiran Sankar 24 courses 2 reviews Rating: 5.0 out of 5 a year ago It is a clear viewed course which helps me to learn EXCEL as earlier as possible. I loved the way of explanation. Only one suggestion I wanted to share is the certificate is not so great, Kindly change the certificate content if possible. Show more Show less Course content 8 sections • 72 lectures • 3h 11m total length Expand all sections Welcome! Course Introduction 3 lectures • 6min What Does the Course Cover? Preview 05:30 Bonus Gift Number 1 1 page Bonus Gift Number 2 1 page Quiz Number 1 1 question A Quick Introduction to the Basics of Excel 10 lectures • 33min Overview of Excel 2016 Preview 03:34 The Excel 2016 Ribbon 02:43 Working with Rows & Columns 01:49 Data Entry in Excel 03:00 Introduction to Formatting 05:52 Creating Formulas in Excel 03:01 Microsoft Excel at Its Best - Functions Preview 03:50 Work Efficiently By Using Cut, Copy & Paste 02:15 Format Cells 05:24 Pasting Values, Formulas and Formats with Paste Special 01:16 Quiz Number 2 5 questions Excel Best Practices: Useful Tips & Tools 19 lectures • 35min This Is How You Can Start Formatting Your Sheets in a Professional Way 02:05 Fast Scrolling That Would Allow You to Be 3x Faster 01:40 Fixing Cell References Properly 02:20 Using the Alt plus Enter combination 00:54 Learn How to Organize Your Excel Data with Text to Columns Preview 02:05 Wrapping Text in Excel 00:47 Create Easily Printable Documents by Using Set Print Area 01:17 Find and Select Special Types of Cells with Select Special (F5) 01:45 Learn How to Assign Dynamic Names within a Model 01:27 Excel Formulas that Make Sense - Named Ranges 01:39 Completing 33% of the course 00:32 Introduction to Custom Formatting 06:14 Assigning Custom Formats to Specific Cells (Ex. Multiples) 01:42 Execute 50 Commands with a Single Click - Excel Macros 03:04 Create a Drop-Down List by Using Data Validation 01:58 Using Custom Sort in Order to Sort Multiple Columns within a Table 01:28 Create a Great Index Page at the Beginning of Your Financial Models 02:05 Freeze the Title Row of Your Table - Freeze Panes 01:16 Excel's "Tell Me" Search Bar 00:46 Quiz Number 1 5 questions Keyboard Shortcuts in Excel 1 lecture • 5min Keyboard Shortcuts Save LOTS of time in Excel 04:38 Excel 2016 Functions 15 lectures • 46min A helpful consideration 00:37 Key Functions in Excel: COUNT, COUNTA, COUNTIF, COUNTIFS 04:06 Key Functions in Excel: SUM, SUMIF, SUMIFS 04:24 Key Excel Functions: AVERAGE & AVERAGEIF 01:59 Completing 50% of the course 00:38 Working with Text in Excel: LEFT, RIGHT, MID, UPPER, LOWER, PROPER, CONCATENATE 04:29 Find the Highest and the Lowest Values in a Range: MAX & MIN 00:52 Include ROUND in Your Financial Models 01:01 Transferring Data Efficiently: VLOOKUP & HLOOKUP Preview 07:47 Use INDEX & MATCH as a Substitute of VLOOKUP 07:27 IFERROR Allows You to Deal Easily with Error Mesages 01:43 Excel's Dynamic & Interactive Tables: Pivot Tables 02:17 Create Flexible Financial Models with the CHOOSE Function 02:24 Find the Result that You Are Looking For with Goal Seek 02:17 Include Sensitivity Analysis In Your Model Through Data Tables 04:10 Quiz Number 2 5 questions Create Professional Charts in Microsoft Excel 2016 7 lectures • 16min Introduction to Charts in Excel 2016 01:11 Inserting Charts in Excel & Learning About the Various Chart Types 02:10 Formatting of Excel Charts (1/2) 02:29 Formatting of Excel Charts (2/2) 03:09 Creating a Bridge Chart in Excel 2016 - As Easy As It Gets 01:42 An Easy Way to Create a Treemap 01:31 Use Sparklines to Show Data Trends 03:52 Build a Complete P&L from Scratch 15 lectures • 40min Introduction to the Case Study 00:51 This Is the data that we will use for our Exercise 02:42 Let's Reorder our Excel sheet and create a clear structure 02:16 Introducing a Code: The best way to work with large amounts of data 01:59 Finishing Touches of our Database 01:58 Using Vlookup in Order to Transfer Data Preview 05:29 Applying Sumif in Order to Populate the Database with Numbers 04:06 Demonstrating How Index & Match Can Successfully Replace Vlookup 03:51 Mapping the Items Within Our Database - A Key Exercise For Financial Analysts 02:16 Creating the Structure of the P&L Statement 02:21 Time for Some Formatting! The Secret of Creating Awesome Looking Excel Sheets Preview 03:17 Populating the P&L sheet with figures 02:47 How do We Find Mistakes in the easiest way possible? 02:14 Finishing Touches: Calculating Year-on-Year Growth and Percentage Incidence 03:08 Quiz Number 3 3 questions Course Challenge - Apply Your Skills in Practice 01:09 Practical Exercise - SUMIFS 2 lectures • 9min Practical Exercise - SUMIFS 08:05 Completing 100% of the course 00:29 Instructor 365 Careers Creating opportunities for Business & Finance students 4.5 Instructor Rating 446,048 Reviews 1,509,773 Students 74 Courses 365 Careers is the #1 best-selling provider of business, finance, and data science courses on Udemy. The company’s courses have been taken by more than 1,500,000 students in 210 countries. People working at world-class firms like Apple, PayPal, and Citibank have completed 365 Careers trainings. Currently, the 365 focuses on the following topics on Udemy: 1) Finance – Finance fundamentals, Financial modeling in Excel, Valuation, Accounting, Capital budgeting, Financial statement analysis (FSA), Investment banking (IB), Leveraged buyout (LBO), Financial planning and analysis (FP&A), Corporate budgeting, applying Python for Finance, Tesla valuation case study, CFA, ACCA, and CPA 2) Data science – Statistics, Mathematics, Probability, SQL, Python programming, Python for Finance, Business Intelligence, R, Machine Learning, TensorFlow, Tableau, the integration of SQL and Tableau, the integration of SQL, Python, Tableau, Power BI, Credit Risk Modeling, and Credit Analytics, Data literacy, Product Management, Pandas, Numpy, Python Programming, Data Strategy 3) Entrepreneurship – Business Strategy, Management and HR Management, Marketing, Decision Making, Negotiation, and Persuasion, Tesla's Strategy and Marketing 4) Office productivity – Microsoft Excel, PowerPoint, Microsoft Word, and Microsoft Outlook 5) Blockchain for Business All of our courses are: - Pre-scripted - Hands-on - Laser-focused - Engaging - Real-life tested By choosing 365 Careers, you make sure you will learn from proven experts, who have a passion for teaching, and can take you from beginner to pro in the shortest possible amount of time. If you want to become a financial analyst, a data scientist, a business analyst, a data analyst, a business intelligence analyst, a business executive, a finance manager, an FP&A analyst, an investment banker, or an entrepreneur 365 Careers’ courses are the perfect place to start. 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:'6780f8460b0053f1',m:'e36817e7e9837cc36af69a60788da7464f57ca35-1627840869-1800-AZOOzKOCTFnfUcOD92fQxkr3vA1/Y8+xHODuf10XpZc0gMjXGXJ9sgo57ITAqKjO+xkMtUpycePbZPMaqYPFsOWHOZQfoEiUkvARWaAM1BUWOyTPV5f8eRFLVMNZUUKBC3DY+bt4B1L18UN4hMn/3+ihe0T5RQC9jVktvaZGi9/rZokMF4rNwk1rfLlOQZYxYZ3isELOWZ1Cbx9YjxXqrNM=',s:[0xd658f5bf0f,0xd70c49261c],}})();
  2. Learn what is new in Excel 2016 Be much quicker at carrying out regular tasks Become your team's go-to-guy when it comes to Excel Use sophisticated functions that will improve the quality of your work Curated for the Udemy Business collection Requirements Install Microsoft 2016, 2013 or 2010 No previous knowledge is required! Great for students who want to learn at their own pace Description Do you want to learn how to work with Excel 2016? Even if you don’t have any prior experience? If so, then this is the right course for you! A Verifiable Certificate of Completion is presented to all students who complete this course. Microsoft Excel 2016 is here, and it promises to be one of the greatest versions that we’ve seen so far. However, it’s essential that you learn how to work with it effectively. If you want to become any of the following… Executive Assistant Office Clerk Auditor Accountant Business Analyst Financial Analyst Credit Counselor Sales Representative Sales Manager Financial Manager Investment Banker Real Estate Agent Market Research Analyst Financial Advisor Business Operations Manager Entrepreneur Someone who is involved with a business and would like to be successful Then you simply have to learn Microsoft Excel 2016. There is no way around it. But how can you do that if you have very limited time and no prior training? And how can you be certain that you are not missing an important piece of the puzzle? Microsoft Excel 2016 Beginners & Intermediate Excel Training is here for you . One of the best Excel courses available on Udemy, it includes everything you’ll need. We will start from the very basics and then gradually build a solid foundation that will serve you well throughout your career. What makes this course different from the rest of the Excel courses out there? High quality of production – HD video and animated slides (this isn’t a collection of boring lectures!) Knowledgeable instructor (experience in Big 4 Accounting + Commercial Finance) Downloadable materials: The course comes with a complete set of downloadable materials (handouts, Excel files, etc.) Extensive Case Studies that will help you reinforce everything that you’ve learned Excellent support: If you don’t understand a concept or you simply want to drop us a line, you’ll receive an answer within 24 hours Dynamic: We don’t want to waste your time! The instructor maintains a very good pace throughout the whole course How come Microsoft Excel is so important? Every large company uses it, right? So if you want to learn a new skill that is highly valued by all employers, you should start here. Here are 5 more reasons why you should take this course and learn Excel: Jobs. A solid understanding of Excel opens the door for a number of career paths Promotions. Top Excel users are promoted very easily inside large corporations Bill Gates knows how to work with Excel Secure Future. Excel skills remain with you and provide extra security. You won’t ever have to fear unemployment Girls dig guys who are proficient in Excel! Guys who can use VLOOKUP are proven to be the most popular with women J This course is suitable for people without any previous experience in Excel. We will start from the very basics and will gradually move on to some of the more advanced features, such as lookup functions, functions with conditions, goal seek, pivot tables, custom formatting, Excel 2016 charts, and other tools that are often used for the purposes of Financial Modeling. Additionally, the course includes practical case studies that will reinforce everything that you learn. One of the exercises that we will see in the course consists of building a complete Profit & Loss statement from scratch. This course is perfect for University students, Entry-level Finance, Business and Marketing professionals who would like to grow faster than their peers. Please don’t forget that the course comes with Udemy’s 30-day unconditional money-back-in-full guarantee. And why not give such a guarantee, when we are convinced that it will provide a ton of value for you? Enrol today and let's start this journey together! Who this course is for: Beginner, Intermediate and Advanced users who want to be proficient in Excel Show more Show less Featured review Kiran Sankar 24 courses 2 reviews Rating: 5.0 out of 5 a year ago It is a clear viewed course which helps me to learn EXCEL as earlier as possible. I loved the way of explanation. Only one suggestion I wanted to share is the certificate is not so great, Kindly change the certificate content if possible. Show more Show less Course content 8 sections • 72 lectures • 3h 11m total length Expand all sections Welcome! Course Introduction 3 lectures • 6min What Does the Course Cover? Preview 05:30 Bonus Gift Number 1 1 page Bonus Gift Number 2 1 page Quiz Number 1 1 question A Quick Introduction to the Basics of Excel 10 lectures • 33min Overview of Excel 2016 Preview 03:34 The Excel 2016 Ribbon 02:43 Working with Rows & Columns 01:49 Data Entry in Excel 03:00 Introduction to Formatting 05:52 Creating Formulas in Excel 03:01 Microsoft Excel at Its Best - Functions Preview 03:50 Work Efficiently By Using Cut, Copy & Paste 02:15 Format Cells 05:24 Pasting Values, Formulas and Formats with Paste Special 01:16 Quiz Number 2 5 questions Excel Best Practices: Useful Tips & Tools 19 lectures • 35min This Is How You Can Start Formatting Your Sheets in a Professional Way 02:05 Fast Scrolling That Would Allow You to Be 3x Faster 01:40 Fixing Cell References Properly 02:20 Using the Alt plus Enter combination 00:54 Learn How to Organize Your Excel Data with Text to Columns Preview 02:05 Wrapping Text in Excel 00:47 Create Easily Printable Documents by Using Set Print Area 01:17 Find and Select Special Types of Cells with Select Special (F5) 01:45 Learn How to Assign Dynamic Names within a Model 01:27 Excel Formulas that Make Sense - Named Ranges 01:39 Completing 33% of the course 00:32 Introduction to Custom Formatting 06:14 Assigning Custom Formats to Specific Cells (Ex. Multiples) 01:42 Execute 50 Commands with a Single Click - Excel Macros 03:04 Create a Drop-Down List by Using Data Validation 01:58 Using Custom Sort in Order to Sort Multiple Columns within a Table 01:28 Create a Great Index Page at the Beginning of Your Financial Models 02:05 Freeze the Title Row of Your Table - Freeze Panes 01:16 Excel's "Tell Me" Search Bar 00:46 Quiz Number 1 5 questions Keyboard Shortcuts in Excel 1 lecture • 5min Keyboard Shortcuts Save LOTS of time in Excel 04:38 Excel 2016 Functions 15 lectures • 46min A helpful consideration 00:37 Key Functions in Excel: COUNT, COUNTA, COUNTIF, COUNTIFS 04:06 Key Functions in Excel: SUM, SUMIF, SUMIFS 04:24 Key Excel Functions: AVERAGE & AVERAGEIF 01:59 Completing 50% of the course 00:38 Working with Text in Excel: LEFT, RIGHT, MID, UPPER, LOWER, PROPER, CONCATENATE 04:29 Find the Highest and the Lowest Values in a Range: MAX & MIN 00:52 Include ROUND in Your Financial Models 01:01 Transferring Data Efficiently: VLOOKUP & HLOOKUP Preview 07:47 Use INDEX & MATCH as a Substitute of VLOOKUP 07:27 IFERROR Allows You to Deal Easily with Error Mesages 01:43 Excel's Dynamic & Interactive Tables: Pivot Tables 02:17 Create Flexible Financial Models with the CHOOSE Function 02:24 Find the Result that You Are Looking For with Goal Seek 02:17 Include Sensitivity Analysis In Your Model Through Data Tables 04:10 Quiz Number 2 5 questions Create Professional Charts in Microsoft Excel 2016 7 lectures • 16min Introduction to Charts in Excel 2016 01:11 Inserting Charts in Excel & Learning About the Various Chart Types 02:10 Formatting of Excel Charts (1/2) 02:29 Formatting of Excel Charts (2/2) 03:09 Creating a Bridge Chart in Excel 2016 - As Easy As It Gets 01:42 An Easy Way to Create a Treemap 01:31 Use Sparklines to Show Data Trends 03:52 Build a Complete P&L from Scratch 15 lectures • 40min Introduction to the Case Study 00:51 This Is the data that we will use for our Exercise 02:42 Let's Reorder our Excel sheet and create a clear structure 02:16 Introducing a Code: The best way to work with large amounts of data 01:59 Finishing Touches of our Database 01:58 Using Vlookup in Order to Transfer Data Preview 05:29 Applying Sumif in Order to Populate the Database with Numbers 04:06 Demonstrating How Index & Match Can Successfully Replace Vlookup 03:51 Mapping the Items Within Our Database - A Key Exercise For Financial Analysts 02:16 Creating the Structure of the P&L Statement 02:21 Time for Some Formatting! The Secret of Creating Awesome Looking Excel Sheets Preview 03:17 Populating the P&L sheet with figures 02:47 How do We Find Mistakes in the easiest way possible? 02:14 Finishing Touches: Calculating Year-on-Year Growth and Percentage Incidence 03:08 Quiz Number 3 3 questions Course Challenge - Apply Your Skills in Practice 01:09 Practical Exercise - SUMIFS 2 lectures • 9min Practical Exercise - SUMIFS 08:05 Completing 100% of the course 00:29 Instructor 365 Careers Creating opportunities for Business & Finance students 4.5 Instructor Rating 446,048 Reviews 1,509,773 Students 74 Courses 365 Careers is the #1 best-selling provider of business, finance, and data science courses on Udemy. The company’s courses have been taken by more than 1,500,000 students in 210 countries. People working at world-class firms like Apple, PayPal, and Citibank have completed 365 Careers trainings. Currently, the 365 focuses on the following topics on Udemy: 1) Finance – Finance fundamentals, Financial modeling in Excel, Valuation, Accounting, Capital budgeting, Financial statement analysis (FSA), Investment banking (IB), Leveraged buyout (LBO), Financial planning and analysis (FP&A), Corporate budgeting, applying Python for Finance, Tesla valuation case study, CFA, ACCA, and CPA 2) Data science – Statistics, Mathematics, Probability, SQL, Python programming, Python for Finance, Business Intelligence, R, Machine Learning, TensorFlow, Tableau, the integration of SQL and Tableau, the integration of SQL, Python, Tableau, Power BI, Credit Risk Modeling, and Credit Analytics, Data literacy, Product Management, Pandas, Numpy, Python Programming, Data Strategy 3) Entrepreneurship – Business Strategy, Management and HR Management, Marketing, Decision Making, Negotiation, and Persuasion, Tesla's Strategy and Marketing 4) Office productivity – Microsoft Excel, PowerPoint, Microsoft Word, and Microsoft Outlook 5) Blockchain for Business All of our courses are: - Pre-scripted - Hands-on - Laser-focused - Engaging - Real-life tested By choosing 365 Careers, you make sure you will learn from proven experts, who have a passion for teaching, and can take you from beginner to pro in the shortest possible amount of time. If you want to become a financial analyst, a data scientist, a business analyst, a data analyst, a business intelligence analyst, a business executive, a finance manager, an FP&A analyst, an investment banker, or an entrepreneur 365 Careers’ courses are the perfect place to start. 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:'6780f8460b0053f1',m:'e36817e7e9837cc36af69a60788da7464f57ca35-1627840869-1800-AZOOzKOCTFnfUcOD92fQxkr3vA1/Y8+xHODuf10XpZc0gMjXGXJ9sgo57ITAqKjO+xkMtUpycePbZPMaqYPFsOWHOZQfoEiUkvARWaAM1BUWOyTPV5f8eRFLVMNZUUKBC3DY+bt4B1L18UN4hMn/3+ihe0T5RQC9jVktvaZGi9/rZokMF4rNwk1rfLlOQZYxYZ3isELOWZ1Cbx9YjxXqrNM=',s:[0xd658f5bf0f,0xd70c49261c],}})();
  3. Be much quicker at carrying out regular tasks Become your team's go-to-guy when it comes to Excel Use sophisticated functions that will improve the quality of your work Curated for the Udemy Business collection Requirements Install Microsoft 2016, 2013 or 2010 No previous knowledge is required! Great for students who want to learn at their own pace Description Do you want to learn how to work with Excel 2016? Even if you don’t have any prior experience? If so, then this is the right course for you! A Verifiable Certificate of Completion is presented to all students who complete this course. Microsoft Excel 2016 is here, and it promises to be one of the greatest versions that we’ve seen so far. However, it’s essential that you learn how to work with it effectively. If you want to become any of the following… Executive Assistant Office Clerk Auditor Accountant Business Analyst Financial Analyst Credit Counselor Sales Representative Sales Manager Financial Manager Investment Banker Real Estate Agent Market Research Analyst Financial Advisor Business Operations Manager Entrepreneur Someone who is involved with a business and would like to be successful Then you simply have to learn Microsoft Excel 2016. There is no way around it. But how can you do that if you have very limited time and no prior training? And how can you be certain that you are not missing an important piece of the puzzle? Microsoft Excel 2016 Beginners & Intermediate Excel Training is here for you . One of the best Excel courses available on Udemy, it includes everything you’ll need. We will start from the very basics and then gradually build a solid foundation that will serve you well throughout your career. What makes this course different from the rest of the Excel courses out there? High quality of production – HD video and animated slides (this isn’t a collection of boring lectures!) Knowledgeable instructor (experience in Big 4 Accounting + Commercial Finance) Downloadable materials: The course comes with a complete set of downloadable materials (handouts, Excel files, etc.) Extensive Case Studies that will help you reinforce everything that you’ve learned Excellent support: If you don’t understand a concept or you simply want to drop us a line, you’ll receive an answer within 24 hours Dynamic: We don’t want to waste your time! The instructor maintains a very good pace throughout the whole course How come Microsoft Excel is so important? Every large company uses it, right? So if you want to learn a new skill that is highly valued by all employers, you should start here. Here are 5 more reasons why you should take this course and learn Excel: Jobs. A solid understanding of Excel opens the door for a number of career paths Promotions. Top Excel users are promoted very easily inside large corporations Bill Gates knows how to work with Excel Secure Future. Excel skills remain with you and provide extra security. You won’t ever have to fear unemployment Girls dig guys who are proficient in Excel! Guys who can use VLOOKUP are proven to be the most popular with women J This course is suitable for people without any previous experience in Excel. We will start from the very basics and will gradually move on to some of the more advanced features, such as lookup functions, functions with conditions, goal seek, pivot tables, custom formatting, Excel 2016 charts, and other tools that are often used for the purposes of Financial Modeling. Additionally, the course includes practical case studies that will reinforce everything that you learn. One of the exercises that we will see in the course consists of building a complete Profit & Loss statement from scratch. This course is perfect for University students, Entry-level Finance, Business and Marketing professionals who would like to grow faster than their peers. Please don’t forget that the course comes with Udemy’s 30-day unconditional money-back-in-full guarantee. And why not give such a guarantee, when we are convinced that it will provide a ton of value for you? Enrol today and let's start this journey together! Who this course is for: Beginner, Intermediate and Advanced users who want to be proficient in Excel Show more Show less Featured review Kiran Sankar 24 courses 2 reviews Rating: 5.0 out of 5 a year ago It is a clear viewed course which helps me to learn EXCEL as earlier as possible. I loved the way of explanation. Only one suggestion I wanted to share is the certificate is not so great, Kindly change the certificate content if possible. Show more Show less Course content 8 sections • 72 lectures • 3h 11m total length Expand all sections Welcome! Course Introduction 3 lectures • 6min What Does the Course Cover? Preview 05:30 Bonus Gift Number 1 1 page Bonus Gift Number 2 1 page Quiz Number 1 1 question A Quick Introduction to the Basics of Excel 10 lectures • 33min Overview of Excel 2016 Preview 03:34 The Excel 2016 Ribbon 02:43 Working with Rows & Columns 01:49 Data Entry in Excel 03:00 Introduction to Formatting 05:52 Creating Formulas in Excel 03:01 Microsoft Excel at Its Best - Functions Preview 03:50 Work Efficiently By Using Cut, Copy & Paste 02:15 Format Cells 05:24 Pasting Values, Formulas and Formats with Paste Special 01:16 Quiz Number 2 5 questions Excel Best Practices: Useful Tips & Tools 19 lectures • 35min This Is How You Can Start Formatting Your Sheets in a Professional Way 02:05 Fast Scrolling That Would Allow You to Be 3x Faster 01:40 Fixing Cell References Properly 02:20 Using the Alt plus Enter combination 00:54 Learn How to Organize Your Excel Data with Text to Columns Preview 02:05 Wrapping Text in Excel 00:47 Create Easily Printable Documents by Using Set Print Area 01:17 Find and Select Special Types of Cells with Select Special (F5) 01:45 Learn How to Assign Dynamic Names within a Model 01:27 Excel Formulas that Make Sense - Named Ranges 01:39 Completing 33% of the course 00:32 Introduction to Custom Formatting 06:14 Assigning Custom Formats to Specific Cells (Ex. Multiples) 01:42 Execute 50 Commands with a Single Click - Excel Macros 03:04 Create a Drop-Down List by Using Data Validation 01:58 Using Custom Sort in Order to Sort Multiple Columns within a Table 01:28 Create a Great Index Page at the Beginning of Your Financial Models 02:05 Freeze the Title Row of Your Table - Freeze Panes 01:16 Excel's "Tell Me" Search Bar 00:46 Quiz Number 1 5 questions Keyboard Shortcuts in Excel 1 lecture • 5min Keyboard Shortcuts Save LOTS of time in Excel 04:38 Excel 2016 Functions 15 lectures • 46min A helpful consideration 00:37 Key Functions in Excel: COUNT, COUNTA, COUNTIF, COUNTIFS 04:06 Key Functions in Excel: SUM, SUMIF, SUMIFS 04:24 Key Excel Functions: AVERAGE & AVERAGEIF 01:59 Completing 50% of the course 00:38 Working with Text in Excel: LEFT, RIGHT, MID, UPPER, LOWER, PROPER, CONCATENATE 04:29 Find the Highest and the Lowest Values in a Range: MAX & MIN 00:52 Include ROUND in Your Financial Models 01:01 Transferring Data Efficiently: VLOOKUP & HLOOKUP Preview 07:47 Use INDEX & MATCH as a Substitute of VLOOKUP 07:27 IFERROR Allows You to Deal Easily with Error Mesages 01:43 Excel's Dynamic & Interactive Tables: Pivot Tables 02:17 Create Flexible Financial Models with the CHOOSE Function 02:24 Find the Result that You Are Looking For with Goal Seek 02:17 Include Sensitivity Analysis In Your Model Through Data Tables 04:10 Quiz Number 2 5 questions Create Professional Charts in Microsoft Excel 2016 7 lectures • 16min Introduction to Charts in Excel 2016 01:11 Inserting Charts in Excel & Learning About the Various Chart Types 02:10 Formatting of Excel Charts (1/2) 02:29 Formatting of Excel Charts (2/2) 03:09 Creating a Bridge Chart in Excel 2016 - As Easy As It Gets 01:42 An Easy Way to Create a Treemap 01:31 Use Sparklines to Show Data Trends 03:52 Build a Complete P&L from Scratch 15 lectures • 40min Introduction to the Case Study 00:51 This Is the data that we will use for our Exercise 02:42 Let's Reorder our Excel sheet and create a clear structure 02:16 Introducing a Code: The best way to work with large amounts of data 01:59 Finishing Touches of our Database 01:58 Using Vlookup in Order to Transfer Data Preview 05:29 Applying Sumif in Order to Populate the Database with Numbers 04:06 Demonstrating How Index & Match Can Successfully Replace Vlookup 03:51 Mapping the Items Within Our Database - A Key Exercise For Financial Analysts 02:16 Creating the Structure of the P&L Statement 02:21 Time for Some Formatting! The Secret of Creating Awesome Looking Excel Sheets Preview 03:17 Populating the P&L sheet with figures 02:47 How do We Find Mistakes in the easiest way possible? 02:14 Finishing Touches: Calculating Year-on-Year Growth and Percentage Incidence 03:08 Quiz Number 3 3 questions Course Challenge - Apply Your Skills in Practice 01:09 Practical Exercise - SUMIFS 2 lectures • 9min Practical Exercise - SUMIFS 08:05 Completing 100% of the course 00:29 Instructor 365 Careers Creating opportunities for Business & Finance students 4.5 Instructor Rating 446,048 Reviews 1,509,773 Students 74 Courses 365 Careers is the #1 best-selling provider of business, finance, and data science courses on Udemy. The company’s courses have been taken by more than 1,500,000 students in 210 countries. People working at world-class firms like Apple, PayPal, and Citibank have completed 365 Careers trainings. Currently, the 365 focuses on the following topics on Udemy: 1) Finance – Finance fundamentals, Financial modeling in Excel, Valuation, Accounting, Capital budgeting, Financial statement analysis (FSA), Investment banking (IB), Leveraged buyout (LBO), Financial planning and analysis (FP&A), Corporate budgeting, applying Python for Finance, Tesla valuation case study, CFA, ACCA, and CPA 2) Data science – Statistics, Mathematics, Probability, SQL, Python programming, Python for Finance, Business Intelligence, R, Machine Learning, TensorFlow, Tableau, the integration of SQL and Tableau, the integration of SQL, Python, Tableau, Power BI, Credit Risk Modeling, and Credit Analytics, Data literacy, Product Management, Pandas, Numpy, Python Programming, Data Strategy 3) Entrepreneurship – Business Strategy, Management and HR Management, Marketing, Decision Making, Negotiation, and Persuasion, Tesla's Strategy and Marketing 4) Office productivity – Microsoft Excel, PowerPoint, Microsoft Word, and Microsoft Outlook 5) Blockchain for Business All of our courses are: - Pre-scripted - Hands-on - Laser-focused - Engaging - Real-life tested By choosing 365 Careers, you make sure you will learn from proven experts, who have a passion for teaching, and can take you from beginner to pro in the shortest possible amount of time. If you want to become a financial analyst, a data scientist, a business analyst, a data analyst, a business intelligence analyst, a business executive, a finance manager, an FP&A analyst, an investment banker, or an entrepreneur 365 Careers’ courses are the perfect place to start. 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:'6780f8460b0053f1',m:'e36817e7e9837cc36af69a60788da7464f57ca35-1627840869-1800-AZOOzKOCTFnfUcOD92fQxkr3vA1/Y8+xHODuf10XpZc0gMjXGXJ9sgo57ITAqKjO+xkMtUpycePbZPMaqYPFsOWHOZQfoEiUkvARWaAM1BUWOyTPV5f8eRFLVMNZUUKBC3DY+bt4B1L18UN4hMn/3+ihe0T5RQC9jVktvaZGi9/rZokMF4rNwk1rfLlOQZYxYZ3isELOWZ1Cbx9YjxXqrNM=',s:[0xd658f5bf0f,0xd70c49261c],}})();
  4. Become your team's go-to-guy when it comes to Excel Use sophisticated functions that will improve the quality of your work Curated for the Udemy Business collection Requirements Install Microsoft 2016, 2013 or 2010 No previous knowledge is required! Great for students who want to learn at their own pace Description Do you want to learn how to work with Excel 2016? Even if you don’t have any prior experience? If so, then this is the right course for you! A Verifiable Certificate of Completion is presented to all students who complete this course. Microsoft Excel 2016 is here, and it promises to be one of the greatest versions that we’ve seen so far. However, it’s essential that you learn how to work with it effectively. If you want to become any of the following… Executive Assistant Office Clerk Auditor Accountant Business Analyst Financial Analyst Credit Counselor Sales Representative Sales Manager Financial Manager Investment Banker Real Estate Agent Market Research Analyst Financial Advisor Business Operations Manager Entrepreneur Someone who is involved with a business and would like to be successful Then you simply have to learn Microsoft Excel 2016. There is no way around it. But how can you do that if you have very limited time and no prior training? And how can you be certain that you are not missing an important piece of the puzzle? Microsoft Excel 2016 Beginners & Intermediate Excel Training is here for you . One of the best Excel courses available on Udemy, it includes everything you’ll need. We will start from the very basics and then gradually build a solid foundation that will serve you well throughout your career. What makes this course different from the rest of the Excel courses out there? High quality of production – HD video and animated slides (this isn’t a collection of boring lectures!) Knowledgeable instructor (experience in Big 4 Accounting + Commercial Finance) Downloadable materials: The course comes with a complete set of downloadable materials (handouts, Excel files, etc.) Extensive Case Studies that will help you reinforce everything that you’ve learned Excellent support: If you don’t understand a concept or you simply want to drop us a line, you’ll receive an answer within 24 hours Dynamic: We don’t want to waste your time! The instructor maintains a very good pace throughout the whole course How come Microsoft Excel is so important? Every large company uses it, right? So if you want to learn a new skill that is highly valued by all employers, you should start here. Here are 5 more reasons why you should take this course and learn Excel: Jobs. A solid understanding of Excel opens the door for a number of career paths Promotions. Top Excel users are promoted very easily inside large corporations Bill Gates knows how to work with Excel Secure Future. Excel skills remain with you and provide extra security. You won’t ever have to fear unemployment Girls dig guys who are proficient in Excel! Guys who can use VLOOKUP are proven to be the most popular with women J This course is suitable for people without any previous experience in Excel. We will start from the very basics and will gradually move on to some of the more advanced features, such as lookup functions, functions with conditions, goal seek, pivot tables, custom formatting, Excel 2016 charts, and other tools that are often used for the purposes of Financial Modeling. Additionally, the course includes practical case studies that will reinforce everything that you learn. One of the exercises that we will see in the course consists of building a complete Profit & Loss statement from scratch. This course is perfect for University students, Entry-level Finance, Business and Marketing professionals who would like to grow faster than their peers. Please don’t forget that the course comes with Udemy’s 30-day unconditional money-back-in-full guarantee. And why not give such a guarantee, when we are convinced that it will provide a ton of value for you? Enrol today and let's start this journey together! Who this course is for: Beginner, Intermediate and Advanced users who want to be proficient in Excel Show more Show less Featured review Kiran Sankar 24 courses 2 reviews Rating: 5.0 out of 5 a year ago It is a clear viewed course which helps me to learn EXCEL as earlier as possible. I loved the way of explanation. Only one suggestion I wanted to share is the certificate is not so great, Kindly change the certificate content if possible. Show more Show less Course content 8 sections • 72 lectures • 3h 11m total length Expand all sections Welcome! Course Introduction 3 lectures • 6min What Does the Course Cover? Preview 05:30 Bonus Gift Number 1 1 page Bonus Gift Number 2 1 page Quiz Number 1 1 question A Quick Introduction to the Basics of Excel 10 lectures • 33min Overview of Excel 2016 Preview 03:34 The Excel 2016 Ribbon 02:43 Working with Rows & Columns 01:49 Data Entry in Excel 03:00 Introduction to Formatting 05:52 Creating Formulas in Excel 03:01 Microsoft Excel at Its Best - Functions Preview 03:50 Work Efficiently By Using Cut, Copy & Paste 02:15 Format Cells 05:24 Pasting Values, Formulas and Formats with Paste Special 01:16 Quiz Number 2 5 questions Excel Best Practices: Useful Tips & Tools 19 lectures • 35min This Is How You Can Start Formatting Your Sheets in a Professional Way 02:05 Fast Scrolling That Would Allow You to Be 3x Faster 01:40 Fixing Cell References Properly 02:20 Using the Alt plus Enter combination 00:54 Learn How to Organize Your Excel Data with Text to Columns Preview 02:05 Wrapping Text in Excel 00:47 Create Easily Printable Documents by Using Set Print Area 01:17 Find and Select Special Types of Cells with Select Special (F5) 01:45 Learn How to Assign Dynamic Names within a Model 01:27 Excel Formulas that Make Sense - Named Ranges 01:39 Completing 33% of the course 00:32 Introduction to Custom Formatting 06:14 Assigning Custom Formats to Specific Cells (Ex. Multiples) 01:42 Execute 50 Commands with a Single Click - Excel Macros 03:04 Create a Drop-Down List by Using Data Validation 01:58 Using Custom Sort in Order to Sort Multiple Columns within a Table 01:28 Create a Great Index Page at the Beginning of Your Financial Models 02:05 Freeze the Title Row of Your Table - Freeze Panes 01:16 Excel's "Tell Me" Search Bar 00:46 Quiz Number 1 5 questions Keyboard Shortcuts in Excel 1 lecture • 5min Keyboard Shortcuts Save LOTS of time in Excel 04:38 Excel 2016 Functions 15 lectures • 46min A helpful consideration 00:37 Key Functions in Excel: COUNT, COUNTA, COUNTIF, COUNTIFS 04:06 Key Functions in Excel: SUM, SUMIF, SUMIFS 04:24 Key Excel Functions: AVERAGE & AVERAGEIF 01:59 Completing 50% of the course 00:38 Working with Text in Excel: LEFT, RIGHT, MID, UPPER, LOWER, PROPER, CONCATENATE 04:29 Find the Highest and the Lowest Values in a Range: MAX & MIN 00:52 Include ROUND in Your Financial Models 01:01 Transferring Data Efficiently: VLOOKUP & HLOOKUP Preview 07:47 Use INDEX & MATCH as a Substitute of VLOOKUP 07:27 IFERROR Allows You to Deal Easily with Error Mesages 01:43 Excel's Dynamic & Interactive Tables: Pivot Tables 02:17 Create Flexible Financial Models with the CHOOSE Function 02:24 Find the Result that You Are Looking For with Goal Seek 02:17 Include Sensitivity Analysis In Your Model Through Data Tables 04:10 Quiz Number 2 5 questions Create Professional Charts in Microsoft Excel 2016 7 lectures • 16min Introduction to Charts in Excel 2016 01:11 Inserting Charts in Excel & Learning About the Various Chart Types 02:10 Formatting of Excel Charts (1/2) 02:29 Formatting of Excel Charts (2/2) 03:09 Creating a Bridge Chart in Excel 2016 - As Easy As It Gets 01:42 An Easy Way to Create a Treemap 01:31 Use Sparklines to Show Data Trends 03:52 Build a Complete P&L from Scratch 15 lectures • 40min Introduction to the Case Study 00:51 This Is the data that we will use for our Exercise 02:42 Let's Reorder our Excel sheet and create a clear structure 02:16 Introducing a Code: The best way to work with large amounts of data 01:59 Finishing Touches of our Database 01:58 Using Vlookup in Order to Transfer Data Preview 05:29 Applying Sumif in Order to Populate the Database with Numbers 04:06 Demonstrating How Index & Match Can Successfully Replace Vlookup 03:51 Mapping the Items Within Our Database - A Key Exercise For Financial Analysts 02:16 Creating the Structure of the P&L Statement 02:21 Time for Some Formatting! The Secret of Creating Awesome Looking Excel Sheets Preview 03:17 Populating the P&L sheet with figures 02:47 How do We Find Mistakes in the easiest way possible? 02:14 Finishing Touches: Calculating Year-on-Year Growth and Percentage Incidence 03:08 Quiz Number 3 3 questions Course Challenge - Apply Your Skills in Practice 01:09 Practical Exercise - SUMIFS 2 lectures • 9min Practical Exercise - SUMIFS 08:05 Completing 100% of the course 00:29 Instructor 365 Careers Creating opportunities for Business & Finance students 4.5 Instructor Rating 446,048 Reviews 1,509,773 Students 74 Courses 365 Careers is the #1 best-selling provider of business, finance, and data science courses on Udemy. The company’s courses have been taken by more than 1,500,000 students in 210 countries. People working at world-class firms like Apple, PayPal, and Citibank have completed 365 Careers trainings. Currently, the 365 focuses on the following topics on Udemy: 1) Finance – Finance fundamentals, Financial modeling in Excel, Valuation, Accounting, Capital budgeting, Financial statement analysis (FSA), Investment banking (IB), Leveraged buyout (LBO), Financial planning and analysis (FP&A), Corporate budgeting, applying Python for Finance, Tesla valuation case study, CFA, ACCA, and CPA 2) Data science – Statistics, Mathematics, Probability, SQL, Python programming, Python for Finance, Business Intelligence, R, Machine Learning, TensorFlow, Tableau, the integration of SQL and Tableau, the integration of SQL, Python, Tableau, Power BI, Credit Risk Modeling, and Credit Analytics, Data literacy, Product Management, Pandas, Numpy, Python Programming, Data Strategy 3) Entrepreneurship – Business Strategy, Management and HR Management, Marketing, Decision Making, Negotiation, and Persuasion, Tesla's Strategy and Marketing 4) Office productivity – Microsoft Excel, PowerPoint, Microsoft Word, and Microsoft Outlook 5) Blockchain for Business All of our courses are: - Pre-scripted - Hands-on - Laser-focused - Engaging - Real-life tested By choosing 365 Careers, you make sure you will learn from proven experts, who have a passion for teaching, and can take you from beginner to pro in the shortest possible amount of time. If you want to become a financial analyst, a data scientist, a business analyst, a data analyst, a business intelligence analyst, a business executive, a finance manager, an FP&A analyst, an investment banker, or an entrepreneur 365 Careers’ courses are the perfect place to start. 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:'6780f8460b0053f1',m:'e36817e7e9837cc36af69a60788da7464f57ca35-1627840869-1800-AZOOzKOCTFnfUcOD92fQxkr3vA1/Y8+xHODuf10XpZc0gMjXGXJ9sgo57ITAqKjO+xkMtUpycePbZPMaqYPFsOWHOZQfoEiUkvARWaAM1BUWOyTPV5f8eRFLVMNZUUKBC3DY+bt4B1L18UN4hMn/3+ihe0T5RQC9jVktvaZGi9/rZokMF4rNwk1rfLlOQZYxYZ3isELOWZ1Cbx9YjxXqrNM=',s:[0xd658f5bf0f,0xd70c49261c],}})();
  5. Use sophisticated functions that will improve the quality of your work Curated for the Udemy Business collection Requirements Install Microsoft 2016, 2013 or 2010 No previous knowledge is required! Great for students who want to learn at their own pace Description Do you want to learn how to work with Excel 2016? Even if you don’t have any prior experience? If so, then this is the right course for you! A Verifiable Certificate of Completion is presented to all students who complete this course. Microsoft Excel 2016 is here, and it promises to be one of the greatest versions that we’ve seen so far. However, it’s essential that you learn how to work with it effectively. If you want to become any of the following… Executive Assistant Office Clerk Auditor Accountant Business Analyst Financial Analyst Credit Counselor Sales Representative Sales Manager Financial Manager Investment Banker Real Estate Agent Market Research Analyst Financial Advisor Business Operations Manager Entrepreneur Someone who is involved with a business and would like to be successful Then you simply have to learn Microsoft Excel 2016. There is no way around it. But how can you do that if you have very limited time and no prior training? And how can you be certain that you are not missing an important piece of the puzzle? Microsoft Excel 2016 Beginners & Intermediate Excel Training is here for you . One of the best Excel courses available on Udemy, it includes everything you’ll need. We will start from the very basics and then gradually build a solid foundation that will serve you well throughout your career. What makes this course different from the rest of the Excel courses out there? High quality of production – HD video and animated slides (this isn’t a collection of boring lectures!) Knowledgeable instructor (experience in Big 4 Accounting + Commercial Finance) Downloadable materials: The course comes with a complete set of downloadable materials (handouts, Excel files, etc.) Extensive Case Studies that will help you reinforce everything that you’ve learned Excellent support: If you don’t understand a concept or you simply want to drop us a line, you’ll receive an answer within 24 hours Dynamic: We don’t want to waste your time! The instructor maintains a very good pace throughout the whole course How come Microsoft Excel is so important? Every large company uses it, right? So if you want to learn a new skill that is highly valued by all employers, you should start here. Here are 5 more reasons why you should take this course and learn Excel: Jobs. A solid understanding of Excel opens the door for a number of career paths Promotions. Top Excel users are promoted very easily inside large corporations Bill Gates knows how to work with Excel Secure Future. Excel skills remain with you and provide extra security. You won’t ever have to fear unemployment Girls dig guys who are proficient in Excel! Guys who can use VLOOKUP are proven to be the most popular with women J This course is suitable for people without any previous experience in Excel. We will start from the very basics and will gradually move on to some of the more advanced features, such as lookup functions, functions with conditions, goal seek, pivot tables, custom formatting, Excel 2016 charts, and other tools that are often used for the purposes of Financial Modeling. Additionally, the course includes practical case studies that will reinforce everything that you learn. One of the exercises that we will see in the course consists of building a complete Profit & Loss statement from scratch. This course is perfect for University students, Entry-level Finance, Business and Marketing professionals who would like to grow faster than their peers. Please don’t forget that the course comes with Udemy’s 30-day unconditional money-back-in-full guarantee. And why not give such a guarantee, when we are convinced that it will provide a ton of value for you? Enrol today and let's start this journey together! Who this course is for: Beginner, Intermediate and Advanced users who want to be proficient in Excel Show more Show less Featured review Kiran Sankar 24 courses 2 reviews Rating: 5.0 out of 5 a year ago It is a clear viewed course which helps me to learn EXCEL as earlier as possible. I loved the way of explanation. Only one suggestion I wanted to share is the certificate is not so great, Kindly change the certificate content if possible. Show more Show less Course content 8 sections • 72 lectures • 3h 11m total length Expand all sections Welcome! Course Introduction 3 lectures • 6min What Does the Course Cover? Preview 05:30 Bonus Gift Number 1 1 page Bonus Gift Number 2 1 page Quiz Number 1 1 question A Quick Introduction to the Basics of Excel 10 lectures • 33min Overview of Excel 2016 Preview 03:34 The Excel 2016 Ribbon 02:43 Working with Rows & Columns 01:49 Data Entry in Excel 03:00 Introduction to Formatting 05:52 Creating Formulas in Excel 03:01 Microsoft Excel at Its Best - Functions Preview 03:50 Work Efficiently By Using Cut, Copy & Paste 02:15 Format Cells 05:24 Pasting Values, Formulas and Formats with Paste Special 01:16 Quiz Number 2 5 questions Excel Best Practices: Useful Tips & Tools 19 lectures • 35min This Is How You Can Start Formatting Your Sheets in a Professional Way 02:05 Fast Scrolling That Would Allow You to Be 3x Faster 01:40 Fixing Cell References Properly 02:20 Using the Alt plus Enter combination 00:54 Learn How to Organize Your Excel Data with Text to Columns Preview 02:05 Wrapping Text in Excel 00:47 Create Easily Printable Documents by Using Set Print Area 01:17 Find and Select Special Types of Cells with Select Special (F5) 01:45 Learn How to Assign Dynamic Names within a Model 01:27 Excel Formulas that Make Sense - Named Ranges 01:39 Completing 33% of the course 00:32 Introduction to Custom Formatting 06:14 Assigning Custom Formats to Specific Cells (Ex. Multiples) 01:42 Execute 50 Commands with a Single Click - Excel Macros 03:04 Create a Drop-Down List by Using Data Validation 01:58 Using Custom Sort in Order to Sort Multiple Columns within a Table 01:28 Create a Great Index Page at the Beginning of Your Financial Models 02:05 Freeze the Title Row of Your Table - Freeze Panes 01:16 Excel's "Tell Me" Search Bar 00:46 Quiz Number 1 5 questions Keyboard Shortcuts in Excel 1 lecture • 5min Keyboard Shortcuts Save LOTS of time in Excel 04:38 Excel 2016 Functions 15 lectures • 46min A helpful consideration 00:37 Key Functions in Excel: COUNT, COUNTA, COUNTIF, COUNTIFS 04:06 Key Functions in Excel: SUM, SUMIF, SUMIFS 04:24 Key Excel Functions: AVERAGE & AVERAGEIF 01:59 Completing 50% of the course 00:38 Working with Text in Excel: LEFT, RIGHT, MID, UPPER, LOWER, PROPER, CONCATENATE 04:29 Find the Highest and the Lowest Values in a Range: MAX & MIN 00:52 Include ROUND in Your Financial Models 01:01 Transferring Data Efficiently: VLOOKUP & HLOOKUP Preview 07:47 Use INDEX & MATCH as a Substitute of VLOOKUP 07:27 IFERROR Allows You to Deal Easily with Error Mesages 01:43 Excel's Dynamic & Interactive Tables: Pivot Tables 02:17 Create Flexible Financial Models with the CHOOSE Function 02:24 Find the Result that You Are Looking For with Goal Seek 02:17 Include Sensitivity Analysis In Your Model Through Data Tables 04:10 Quiz Number 2 5 questions Create Professional Charts in Microsoft Excel 2016 7 lectures • 16min Introduction to Charts in Excel 2016 01:11 Inserting Charts in Excel & Learning About the Various Chart Types 02:10 Formatting of Excel Charts (1/2) 02:29 Formatting of Excel Charts (2/2) 03:09 Creating a Bridge Chart in Excel 2016 - As Easy As It Gets 01:42 An Easy Way to Create a Treemap 01:31 Use Sparklines to Show Data Trends 03:52 Build a Complete P&L from Scratch 15 lectures • 40min Introduction to the Case Study 00:51 This Is the data that we will use for our Exercise 02:42 Let's Reorder our Excel sheet and create a clear structure 02:16 Introducing a Code: The best way to work with large amounts of data 01:59 Finishing Touches of our Database 01:58 Using Vlookup in Order to Transfer Data Preview 05:29 Applying Sumif in Order to Populate the Database with Numbers 04:06 Demonstrating How Index & Match Can Successfully Replace Vlookup 03:51 Mapping the Items Within Our Database - A Key Exercise For Financial Analysts 02:16 Creating the Structure of the P&L Statement 02:21 Time for Some Formatting! The Secret of Creating Awesome Looking Excel Sheets Preview 03:17 Populating the P&L sheet with figures 02:47 How do We Find Mistakes in the easiest way possible? 02:14 Finishing Touches: Calculating Year-on-Year Growth and Percentage Incidence 03:08 Quiz Number 3 3 questions Course Challenge - Apply Your Skills in Practice 01:09 Practical Exercise - SUMIFS 2 lectures • 9min Practical Exercise - SUMIFS 08:05 Completing 100% of the course 00:29 Instructor 365 Careers Creating opportunities for Business & Finance students 4.5 Instructor Rating 446,048 Reviews 1,509,773 Students 74 Courses 365 Careers is the #1 best-selling provider of business, finance, and data science courses on Udemy. The company’s courses have been taken by more than 1,500,000 students in 210 countries. People working at world-class firms like Apple, PayPal, and Citibank have completed 365 Careers trainings. Currently, the 365 focuses on the following topics on Udemy: 1) Finance – Finance fundamentals, Financial modeling in Excel, Valuation, Accounting, Capital budgeting, Financial statement analysis (FSA), Investment banking (IB), Leveraged buyout (LBO), Financial planning and analysis (FP&A), Corporate budgeting, applying Python for Finance, Tesla valuation case study, CFA, ACCA, and CPA 2) Data science – Statistics, Mathematics, Probability, SQL, Python programming, Python for Finance, Business Intelligence, R, Machine Learning, TensorFlow, Tableau, the integration of SQL and Tableau, the integration of SQL, Python, Tableau, Power BI, Credit Risk Modeling, and Credit Analytics, Data literacy, Product Management, Pandas, Numpy, Python Programming, Data Strategy 3) Entrepreneurship – Business Strategy, Management and HR Management, Marketing, Decision Making, Negotiation, and Persuasion, Tesla's Strategy and Marketing 4) Office productivity – Microsoft Excel, PowerPoint, Microsoft Word, and Microsoft Outlook 5) Blockchain for Business All of our courses are: - Pre-scripted - Hands-on - Laser-focused - Engaging - Real-life tested By choosing 365 Careers, you make sure you will learn from proven experts, who have a passion for teaching, and can take you from beginner to pro in the shortest possible amount of time. If you want to become a financial analyst, a data scientist, a business analyst, a data analyst, a business intelligence analyst, a business executive, a finance manager, an FP&A analyst, an investment banker, or an entrepreneur 365 Careers’ courses are the perfect place to start. 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:'6780f8460b0053f1',m:'e36817e7e9837cc36af69a60788da7464f57ca35-1627840869-1800-AZOOzKOCTFnfUcOD92fQxkr3vA1/Y8+xHODuf10XpZc0gMjXGXJ9sgo57ITAqKjO+xkMtUpycePbZPMaqYPFsOWHOZQfoEiUkvARWaAM1BUWOyTPV5f8eRFLVMNZUUKBC3DY+bt4B1L18UN4hMn/3+ihe0T5RQC9jVktvaZGi9/rZokMF4rNwk1rfLlOQZYxYZ3isELOWZ1Cbx9YjxXqrNM=',s:[0xd658f5bf0f,0xd70c49261c],}})();