Excel Masterclass: Complete and Concise Microsoft Excel

Introduction 1 lecture 02:22 Introduction Why Learn Excel? Since 80% of jobs require spreadsheet and word processing skills, it makes sense you've probably stumbled over Excel at one point in time. But the tool does a whole lot more than just produce a table of numbers — here are four reasons why you should learn Excel (and even if you think you're a pro, how you can dig a little deeper into the platform). In this video, the structure and contents of the course are discussed. This will give you an idea of the course structure and what your are going to learn in this course. You can also skip lectures which you think you already know. You are on lecture 1 of 30 lectures of Microsoft Excel course - Microsoft Excel Masterclass: Complete and Concise using Excel 2016. Complete this MS Excel crash course to get Microsoft Excel course certificate Introduction 1 lecture 02:22 Introduction Why Learn Excel? Since 80% of jobs require spreadsheet and word processing skills, it makes sense you've probably stumbled over Excel at one point in time. But the tool does a whole lot more than just produce a table of numbers — here are four reasons why you should learn Excel (and even if you think you're a pro, how you can dig a little deeper into the platform). In this video, the structure and contents of the course are discussed. This will give you an idea of the course structure and what your are going to learn in this course. You can also skip lectures which you think you already know. You are on lecture 1 of 30 lectures of Microsoft Excel course - Microsoft Excel Masterclass: Complete and Concise using Excel 2016. Complete this MS Excel crash course to get Microsoft Excel course certificate Introduction Why Learn Excel? Since 80% of jobs require spreadsheet and word processing skills, it makes sense you've probably stumbled over Excel at one point in time. But the tool does a whole lot more than just produce a table of numbers — here are four reasons why you should learn Excel (and even if you think you're a pro, how you can dig a little deeper into the platform). In this video, the structure and contents of the course are discussed. This will give you an idea of the course structure and what your are going to learn in this course. You can also skip lectures which you think you already know. You are on lecture 1 of 30 lectures of Microsoft Excel course - Microsoft Excel Masterclass: Complete and Concise using Excel 2016. Complete this MS Excel crash course to get Microsoft Excel course certificate Introduction Why Learn Excel? Since 80% of jobs require spreadsheet and word processing skills, it makes sense you've probably stumbled over Excel at one point in time. But the tool does a whole lot more than just produce a table of numbers — here are four reasons why you should learn Excel (and even if you think you're a pro, how you can dig a little deeper into the platform). In this video, the structure and contents of the course are discussed. This will give you an idea of the course structure and what your are going to learn in this course. You can also skip lectures which you think you already know. You are on lecture 1 of 30 lectures of Microsoft Excel course - Microsoft Excel Masterclass: Complete and Concise using Excel 2016. Complete this MS Excel crash course to get Microsoft Excel course certificate Introduction Why Learn Excel? Since 80% of jobs require spreadsheet and word processing skills, it makes sense you've probably stumbled over Excel at one point in time. But the tool does a whole lot more than just produce a table of numbers — here are four reasons why you should learn Excel (and even if you think you're a pro, how you can dig a little deeper into the platform). In this video, the structure and contents of the course are discussed. This will give you an idea of the course structure and what your are going to learn in this course. You can also skip lectures which you think you already know. You are on lecture 1 of 30 lectures of Microsoft Excel course - Microsoft Excel Masterclass: Complete and Concise using Excel 2016. Complete this MS Excel crash course to get Microsoft Excel course certificate Introduction Why Learn Excel? Since 80% of jobs require spreadsheet and word processing skills, it makes sense you've probably stumbled over Excel at one point in time. But the tool does a whole lot more than just produce a table of numbers — here are four reasons why you should learn Excel (and even if you think you're a pro, how you can dig a little deeper into the platform). In this video, the structure and contents of the course are discussed. This will give you an idea of the course structure and what your are going to learn in this course. You can also skip lectures which you think you already know. You are on lecture 1 of 30 lectures of Microsoft Excel course - Microsoft Excel Masterclass: Complete and Concise using Excel 2016. Complete this MS Excel crash course to get Microsoft Excel course certificate Why Learn Excel? Since 80% of jobs require spreadsheet and word processing skills, it makes sense you've probably stumbled over Excel at one point in time. But the tool does a whole lot more than just produce a table of numbers — here are four reasons why you should learn Excel (and even if you think you're a pro, how you can dig a little deeper into the platform). In this video, the structure and contents of the course are discussed. This will give you an idea of the course structure and what your are going to learn in this course. You can also skip lectures which you think you already know. You are on lecture 1 of 30 lectures of Microsoft Excel course - Microsoft Excel Masterclass: Complete and Concise using Excel 2016. Complete this MS Excel crash course to get Microsoft Excel course certificate Why Learn Excel? Since 80% of jobs require spreadsheet and word processing skills, it makes sense you've probably stumbled over Excel at one point in time. But the tool does a whole lot more than just produce a table of numbers — here are four reasons why you should learn Excel (and even if you think you're a pro, how you can dig a little deeper into the platform). In this video, the structure and contents of the course are discussed. This will give you an idea of the course structure and what your are going to learn in this course. You can also skip lectures which you think you already know. You are on lecture 1 of 30 lectures of Microsoft Excel course - Microsoft Excel Masterclass: Complete and Concise using Excel 2016. Complete this MS Excel crash course to get Microsoft Excel course certificate Essential Formulas 8 lectures 33:09 Mathematical Functions This lecture covers Excel Mathematical formulas such as

• SUM
• AVERAGE
• RAND
• MIN & MAX
• SUMPRODUCT

Excel formulas are most important part of MS Excel. Formulas are important in many jobs. In a recent survey we conducted about formulas, over 90% of respondents said that Excel formulas were "important", "very important", or "vital" to their job. If you are a beginner, you must practice all the Mathematical Excel formulas we have mentioned in this lecture. Exercise 1/12: Mathematical Formulas Exercise 1You are on lecture 4 of 30 lectures of Microsoft Excel course - Microsoft Excel Masterclass: Complete and Concise using Excel 2016. Once you complete this advanced Excel training course using Excel 2016, you will be able to

• Learn the most common Excel functions used in the Office
• Handle complex advanced Excel formula with ease
• Master advanced Excel lookup formulas VLOOKUP,HLOOKUP, INDEX, MATCH functions and many more
• Master Microsoft Excel's one of the most popular tools, PivotTables
• Improve your data representation skills by MS Excel Charts
• Create professional reports by using Excel Conditional formatting

We recommend you to do all Excel exercises which are spread through this advanced Excel certification course - Microsoft Excel Masterclass: Complete and Concise using Excel 2016. Complete this MS Excel crash course to get Microsoft Excel course certificate. Textual Formulas This lecture covers Excel Textual formulas such as

• TRIM
• CONCATENATE
• SUBSTITUTE
• UPPER & LOWER
• LENGTH
• LEFT, RIGHT & MID

Formulas are a powerful way to capture and save a working solution. They let you repeat the solution again whenever you like, always with perfect accuracy. They are far better than your faulty memory. Even if you are an intermediate Excel user you must complete the lecture and solve exercise to get a solid understanding of excel Textual formulas. Don't forget to take notes and add bookmarks during the lectures Exercise 2/12: Textual Formulas Exercise 2You have on lecture 6 of 30 lectures of Microsoft Excel course - Microsoft Excel Masterclass: Complete and Concise using Excel 2016. Once you complete this advanced Excel training course using Excel 2016, you will be able to

• Learn the most common Excel functions used in the Office
• Handle complex advanced Excel formula with ease
• Master advanced Excel lookup formulas VLOOKUP,HLOOKUP, INDEX, MATCH functions and many more
• Master Microsoft Excel's one of the most popular tools, PivotTables
• Improve your data representation skills by MS Excel Charts
• Create professional reports by using Excel Conditional formatting

We recommend you to do all Excel exercises which are spread through this advanced Excel certification course - Microsoft Excel Masterclass: Complete and Concise using Excel 2016. Complete this MS Excel crash course to get Microsoft Excel course certificate. Logical Formulas This lecture covers Excel Logical formulas such as

• AND & OR
• IF
• COUNTIF
• SUMIF

Logical Formulas help you translate your vision into reality. Ever felt like you can explain what you want to do in plain English, but you have no idea how to do it in Excel? Logical Formulas let you build the analysis that's in your head. Beginners will need some time to absorb Excel Logical functions. So I recommend you take play with different function to get a solid foundation for more advanced excel features. Exercise 3/12: Logical Formulas Exercise 3You are on lecture 8 of 30 lectures of Microsoft Excel course - Microsoft Excel Masterclass: Complete and Concise using Excel 2016. Once you complete this advanced Excel training course using Excel 2016, you will be able to

• Learn the most common Excel functions used in the Office
• Handle complex advanced Excel formula with ease
• Master advanced Excel lookup formulas VLOOKUP,HLOOKUP, INDEX, MATCH functions and many more
• Master Microsoft Excel's one of the most popular tools, PivotTables
• Improve your data representation skills by MS Excel Charts
• Create professional reports by using Excel Conditional formatting

We recommend you to do all Excel exercises which are spread through this advanced Excel certification course - Microsoft Excel Masterclass: Complete and Concise using Excel 2016. Complete this MS Excel crash course to get Microsoft Excel course certificate. Date-time (Temporal) Formulas This lecture covers Date-time related functions such as

• TODAY & NOW
• DAY, MONTH & YEAR
• DATEDIF & DAYS

Date and time formats are very common in day to day business use. Skill with Temporal formulas allows you to deploy a full set of razor-sharp tools when solving problems which involves date and time formats. Without formula skills, you are forced to use a dull saw on every job, no matter how large or tedious. Exercise 4/12: Date-Time Formulas Exercise 4You have on lecture 10 of 30 lectures of Microsoft Excel course - Microsoft Excel Masterclass: Complete and Concise using Excel 2016. Once you complete this advanced Excel training course using Excel 2016, you will be able to

• Learn the most common Excel functions used in the Office
• Handle complex advanced Excel formula with ease
• Master advanced Excel lookup formulas VLOOKUP,HLOOKUP, INDEX, MATCH functions and many more
• Master Microsoft Excel's one of the most popular tools, PivotTables
• Improve your data representation skills by MS Excel Charts
• Create professional reports by using Excel Conditional formatting

We recommend you to do all Excel exercises which are spread through this advanced Excel certification course - Microsoft Excel Masterclass: Complete and Concise using Excel 2016. Complete this MS Excel crash course to get Microsoft Excel course certificate. Essential Formulas. 8 lectures 33:09 Mathematical Functions This lecture covers Excel Mathematical formulas such as

• SUM
• AVERAGE
• RAND
• MIN & MAX
• SUMPRODUCT

Excel formulas are most important part of MS Excel. Formulas are important in many jobs. In a recent survey we conducted about formulas, over 90% of respondents said that Excel formulas were "important", "very important", or "vital" to their job. If you are a beginner, you must practice all the Mathematical Excel formulas we have mentioned in this lecture. Exercise 1/12: Mathematical Formulas Exercise 1You are on lecture 4 of 30 lectures of Microsoft Excel course - Microsoft Excel Masterclass: Complete and Concise using Excel 2016. Once you complete this advanced Excel training course using Excel 2016, you will be able to

• Learn the most common Excel functions used in the Office
• Handle complex advanced Excel formula with ease
• Master advanced Excel lookup formulas VLOOKUP,HLOOKUP, INDEX, MATCH functions and many more
• Master Microsoft Excel's one of the most popular tools, PivotTables
• Improve your data representation skills by MS Excel Charts
• Create professional reports by using Excel Conditional formatting

We recommend you to do all Excel exercises which are spread through this advanced Excel certification course - Microsoft Excel Masterclass: Complete and Concise using Excel 2016. Complete this MS Excel crash course to get Microsoft Excel course certificate. Textual Formulas This lecture covers Excel Textual formulas such as

• TRIM
• CONCATENATE
• SUBSTITUTE
• UPPER & LOWER
• LENGTH
• LEFT, RIGHT & MID

Formulas are a powerful way to capture and save a working solution. They let you repeat the solution again whenever you like, always with perfect accuracy. They are far better than your faulty memory. Even if you are an intermediate Excel user you must complete the lecture and solve exercise to get a solid understanding of excel Textual formulas. Don't forget to take notes and add bookmarks during the lectures Exercise 2/12: Textual Formulas Exercise 2You have on lecture 6 of 30 lectures of Microsoft Excel course - Microsoft Excel Masterclass: Complete and Concise using Excel 2016. Once you complete this advanced Excel training course using Excel 2016, you will be able to

• Learn the most common Excel functions used in the Office
• Handle complex advanced Excel formula with ease
• Master advanced Excel lookup formulas VLOOKUP,HLOOKUP, INDEX, MATCH functions and many more
• Master Microsoft Excel's one of the most popular tools, PivotTables
• Improve your data representation skills by MS Excel Charts
• Create professional reports by using Excel Conditional formatting

We recommend you to do all Excel exercises which are spread through this advanced Excel certification course - Microsoft Excel Masterclass: Complete and Concise using Excel 2016. Complete this MS Excel crash course to get Microsoft Excel course certificate. Logical Formulas This lecture covers Excel Logical formulas such as

• AND & OR
• IF
• COUNTIF
• SUMIF

Logical Formulas help you translate your vision into reality. Ever felt like you can explain what you want to do in plain English, but you have no idea how to do it in Excel? Logical Formulas let you build the analysis that's in your head. Beginners will need some time to absorb Excel Logical functions. So I recommend you take play with different function to get a solid foundation for more advanced excel features. Exercise 3/12: Logical Formulas Exercise 3You are on lecture 8 of 30 lectures of Microsoft Excel course - Microsoft Excel Masterclass: Complete and Concise using Excel 2016 H

LEFT, RIGHT & MID

Formulas are a powerful way to capture and save a working solution. They let you repeat the solution again whenever you like, always with perfect accuracy. They are far better than your faulty memory. Even if you are an intermediate Excel user...