Master Microsoft Excel - Excel from Beginner to VBA Expert

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

Course Description

Why buy individual Excel courses when this whole Microsoft Excel course will give you everything you need!

Microsoft Excel all-in-one Package - Become a certified Excel Ninja with #1 Excel course

  • Looking for an online Excel course to improve your skills and save time but don't know where to start?

  • Start mastering Excel, the world's most popular and powerful spreadsheet program and your sought after excel certification can help you impress your employer and advance your career prospects.

  • I have picked out the Excel Essential skills and packaged them in a structured course.

  • I will take you step-by-step through engaging video tutorials and teach you everything from scratch & to be able to use VBA to improve your work flow, save time and automate your current Excel projects.

What differentiates this course from other Microsoft Excel Courses?

Yes, there are many Microsoft Excel Courses out there teaching you the important Excel functions and features you need to master.

BUT, do you get step-step-step learning with Quizzes, Exercises and VBA programming all in one course?

This course will get you confident and comfortable designing from simple to complex spreadsheets. You will go beyond Excel basics & advanced section & become a smart user. As you go through the course, you will be able to apply what you learnt immediately to your job.

This Complete Excel Course is for two types of people:

1. Excel Beginners i.e. anyone who want to boost the career by learning excel from scratch to VBA Expert!

2. Excel intermediate and advanced users who want to make sure their skills cover all the essentials. This includes many Excel tricks and hidden features few data analysts know of.

This course covers all the fundamentals an Excel beginner needs to know as well as bridge the gaps for Excel Intermediate & Advanced users.

This is more than just Excel course as it starts off easy and adds VBA programming that many Excel users don't know of.

-----------------------------------------------------------------------------------------------------------------------------------------------

★★★★★ "So far, I have found it particularly useful in my personal life. This is amazing course which impacts the learner positively and makes him able to be a leader who cab bring change. it is very easy to understand. 100% i will be able to apply in my work & personal life. i learned so much from this course, it was a great learning opportunity and i look forward to continuing to put the things i learned into real world practice. Thank you for this excellent course. It was rigorous, robust, and very meaningful". Dips

★★★★★ "Its really what we say basic to build up. Great course and well explained look forward for more courses from these Teacher for Microsoft Office. Thanks for sharing Your Knowledge". Fluid|Serspin

The course comes with lifetime access. Buy now. Watch anytime.

By the end of the course you'll be confident, writing robust & elegant formulas and functions from scratch, allowing you to:

  • Input Data and Navigate Large Spreadsheets

  • Easily build dynamic tools & Excel dashboards to filter, display and analyze your data

  • Apply Excel hacks to get your work done faster

  • Be able to choose right Excel formula to automate your data analysis (Excel IF Function, ROUND and more)

  • Join datasets from multiple sources with Excel's LOOKUP, INDEX & MATCH functions

  • Get Answers from your Data

  • Organize, Clean and Manage Large Data

  • Create Interactive reports with Excel Pivot Tables, Pivot Charts, Slicers and Timelines

  • Import & transform data with tools like Get & Transform (Power Query)

  • Manipulate dates, times, text, and arrays

  • Reduce manual routine tasks to the click of button

  • VBA programming & read, write own Macro to automate the tasks

We will dive into a broad range of Excel formulas & functions. Below are some Excel Features & Functions that you will learn:

  • Useful Excel shortcuts for data entry and navigation.

  • Protect your Excel files and worksheets properly.

  • To apply formatting correctly for cleaner and more professional reports.

  • To use important features like drop-down lists and add data validation to the cells. The way you can restrict users to type the data which can be input in each cell.

  • Add Comments & Notes to cells & how to print the same if needed.

  • Add Data & time Stamps to your reports.

  • Lookup/Reference Functions.

  • Statistical Functions.

  • Logic Functions.

  • Text Functions.

  • Date & Time Functions.

  • The most useful & powerful functions such as COUNT, COUNTIFS, SUMIFS, SUMPRODUCT, Nesting IF functions by nesting AND and OR within them and many more.

  • Excel features that will help you to organize and structure data so it makes (Sort, Filter, Search & Replace Go to Special, combine text with & character.)

  • Excel Pivot Tables & Pivot Charts so that you can quickly get insights from your data.

  • What Excel Power Query can do for you and how easy it is to combine data from different spreadsheets

  • Use Power Query to unpivot the data drive another Pivot Table, transform messy data to tabular data.

  • Join Multiple Tables & create long table using Power Query that can be used to feed business intelligence solutions & Pivot Tables.

  • Import data from Text File.

  • Three different ways to run the Macro i.e. from Macro Dialog, Using Keyboard Shortcuts & using buttons.

  • More than just Excel! VBA (Visual Basic for Applications) from Scratch to advanced.

So, what are you waiting for? Enroll Today and take the next step in mastering Excel and go from Excel Novice to Excel Ninja! Become a certified Excel Ninja Today.

The course comes with lifetime access. Buy now. Watch anytime.

Who this course is for:

  • This online course is suitable for anyone who wants to learn Excel. No prior knowledge of Excel is required. This Microsoft Excel Course will take you through 4 levels of Microsoft Excel Topics (Beginner, Intermediate, Advanced and Beyond).
  • Whether you are a working professional, student, teacher, freelancer, or entrepreneur, this training can benefit you and help you take your Excel skills to the next level.
  • Excel is utilized in almost every office in the world, thus offers a great scope. It is highly used in decision making and a kind of analysis tool that represents data into graphical form.

Expected Outcomes

  1. Master Microsoft Excel from Novice to VBA Programmer Mastering the Math, Statistical, Logic and Text functions Create dynamic reports by mastering most popular tools, Excel Pivot Tables and Power Query Impress your boss by unlocking dynamic formulas with IF, Nesting Vlookup functions, INDEX, MATCH functions and many more Keyboard shortcuts to save hours of time and boost your productivity in Excel Use “What-If” analysis based on changing conditions Utilize the full power of Microsoft Excel by automating your day to day tasks through Macros and VBA Get LIFETIME access to exercises, quizzes & 1-on-1 expert support Requirements This course was created with Excel 2016 however all features will work in Excel 2010, 2013, 2016 and Office 365. Require a computer with excel installed (2016 version or later recommended) and a willingness to learn. No prior knowledge is required as each step is explained in this course Description Why buy individual Excel courses when this whole Microsoft Excel course will give you everything you need! Microsoft Excel all-in-one Package - Become a certified Excel Ninja with #1 Excel course Looking for an online Excel course to improve your skills and save time but don't know where to start? Start mastering Excel, the world's most popular and powerful spreadsheet program and your sought after excel certification can help you impress your employer and advance your career prospects. I have picked out the Excel Essential skills and packaged them in a structured course. I will take you step-by-step through engaging video tutorials and teach you everything from scratch & to be able to use VBA to improve your work flow, save time and automate your current Excel projects. What differentiates this course from other Microsoft Excel Courses? Yes, there are many Microsoft Excel Courses out there teaching you the important Excel functions and features you need to master. BUT, do you get step-step-step learning with Quizzes, Exercises and VBA programming all in one course? This course will get you confident and comfortable designing from simple to complex spreadsheets. You will go beyond Excel basics & advanced section & become a smart user. As you go through the course, you will be able to apply what you learnt immediately to your job. This Complete Excel Course is for two types of people: 1. Excel Beginners i.e. anyone who want to boost the career by learning excel from scratch to VBA Expert! 2. Excel intermediate and advanced users who want to make sure their skills cover all the essentials. This includes many Excel tricks and hidden features few data analysts know of. This course covers all the fundamentals an Excel beginner needs to know as well as bridge the gaps for Excel Intermediate & Advanced users. This is more than just Excel course as it starts off easy and adds VBA programming that many Excel users don't know of. ----------------------------------------------------------------------------------------------------------------------------------------------- ★★★★★ "So far, I have found it particularly useful in my personal life. This is amazing course which impacts the learner positively and makes him able to be a leader who cab bring change. it is very easy to understand. 100% i will be able to apply in my work & personal life. i learned so much from this course, it was a great learning opportunity and i look forward to continuing to put the things i learned into real world practice. Thank you for this excellent course. It was rigorous, robust, and very meaningful ". Dips ★★★★★ "Its really what we say basic to build up. Great course and well explained look forward for more courses from these Teacher for Microsoft Office. Thanks for sharing Your Knowledge ". Fluid|Serspin The course comes with lifetime access. Buy now. Watch anytime. By the end of the course you'll be confident, writing robust & elegant formulas and functions from scratch, allowing you to: Input Data and Navigate Large Spreadsheets Easily build dynamic tools & Excel dashboards to filter, display and analyze your data Apply Excel hacks to get your work done faster Be able to choose right Excel formula to automate your data analysis (Excel IF Function, ROUND and more) Join datasets from multiple sources with Excel's LOOKUP, INDEX & MATCH functions Get Answers from your Data Organize, Clean and Manage Large Data Create Interactive reports with Excel Pivot Tables, Pivot Charts, Slicers and Timelines Import & transform data with tools like Get & Transform (Power Query) Manipulate dates, times, text, and arrays Reduce manual routine tasks to the click of button VBA programming & read, write own Macro to automate the tasks We will dive into a broad range of Excel formulas & functions. Below are some Excel Features & Functions that you will learn: Useful Excel shortcuts for data entry and navigation. Protect your Excel files and worksheets properly. To apply formatting correctly for cleaner and more professional reports. To use important features like drop-down lists and add data validation to the cells. The way you can restrict users to type the data which can be input in each cell. Add Comments & Notes to cells & how to print the same if needed. Add Data & time Stamps to your reports. Lookup/Reference Functions. Statistical Functions. Logic Functions. Text Functions. Date & Time Functions. The most useful & powerful functions such as COUNT, COUNTIFS, SUMIFS, SUMPRODUCT, Nesting IF functions by nesting AND and OR within them and many more. Excel features that will help you to organize and structure data so it makes (Sort, Filter, Search & Replace Go to Special, combine text with & character.) Excel Pivot Tables & Pivot Charts so that you can quickly get insights from your data. What Excel Power Query can do for you and how easy it is to combine data from different spreadsheets Use Power Query to unpivot the data drive another Pivot Table, transform messy data to tabular data. Join Multiple Tables & create long table using Power Query that can be used to feed business intelligence solutions & Pivot Tables. Import data from Text File. Three different ways to run the Macro i.e. from Macro Dialog, Using Keyboard Shortcuts & using buttons. More than just Excel! VBA (Visual Basic for Applications) from Scratch to advanced. So, what are you waiting for? Enroll Today and take the next step in mastering Excel and go from Excel Novice to Excel Ninja! Become a certified Excel Ninja Today. The course comes with lifetime access. Buy now. Watch anytime. Who this course is for: This online course is suitable for anyone who wants to learn Excel. No prior knowledge of Excel is required. This Microsoft Excel Course will take you through 4 levels of Microsoft Excel Topics (Beginner, Intermediate, Advanced and Beyond). Whether you are a working professional, student, teacher, freelancer, or entrepreneur, this training can benefit you and help you take your Excel skills to the next level. Excel is utilized in almost every office in the world, thus offers a great scope. It is highly used in decision making and a kind of analysis tool that represents data into graphical form. Show more Show less Course content 24 sections • 108 lectures • 15h 35m total length Expand all sections A Quick Tour to the Basics of Excel 3 lectures • 23min The Ribbon Commands Preview 06:49 The Work Surface - Workbook and Worksheets Preview 07:21 Navigation Tools with 100+ Keyboard Shortcuts 08:33 Getting to Know Excel Step-By-Step 5 lectures • 30min First File 06:27 Formatting 07:59 Work with Alignment and Wrap text 03:57 Hiding and unhiding rows and columns 04:53 Basic Math 06:36 Cell Referencing & Excel Functions 8 lectures • 1hr 22min Formula Anatomy 08:37 Absolute and Relative Cell Referencing 15:34 Function Anatomy 09:02 Math Functions 09:28 Basic Statistics 07:37 Logic Functions 08:47 Text Functions 11:02 Understanding Dates & Time 11:57 Lookup & IF Family Functions 9 lectures • 1hr 17min Formula Auditing 08:00 Conditional Math - SUMIF, COUNTIF & SUMPRODUCT Functions 09:26 External Links 07:50 Temporal Functions - EOMONTH & EDATE Functions 08:14 VLOOKUP with Approximate Match 09:44 VLOOKUP with Exact Match 08:11 Using lookup with Large Tables 06:08 Nesting Lookup Functions 07:14 Lookup Functions - Hlookup, Index, Match & Index with Match 11:45 Test your Knowledge 0 lectures • 0min Test your Knowledge with this Quiz 35 questions Optimizing Data: Sorting, Filtering, Tables & Macro 5 lectures • 1hr Basic & Advanced Sorting 15:40 Basic & Advanced Filtering 19:37 Naming Ranges 08:18 Excel Tables 08:22 Recording Macros 07:34 Quick Insights with Excel Pivot Tables & Data Analysis Tools 8 lectures • 1hr 13min Creating PivotTables 06:48 Formatting Pivot Tables 09:32 Calculated Fields in Pivot Tables 06:54 Slicers to Calculate & Manipulate Fields 09:42 Grouping by date, time and other factors 13:24 Pivot Chart 06:32 What-If analysis & Data Analysis Tools 11:11 Solver in Excel 09:07 Formatting including Conditional & Number Formatting in Excel 5 lectures • 49min Cell Formatting 07:46 Outlining 16:42 Build own Custom Number Formats 09:32 Conditional formats with Built-in Rules 07:43 Conditional formats with Custom Rules 06:51 Working with Excel Charts 8 lectures • 50min Column Charts 05:00 Bar Charts 05:55 Pie Charts 06:48 Line Charts 06:18 Waterfall Charts 04:04 Sparklines 08:15 Combination Charts - Area and Line 07:24 Combination Charts - Column and Line 06:31 Power Query in Excel 8 lectures • 1hr 8min Unpivoting Data using Power Query 07:58 Build Contiguous Data using Power Query 06:11 Importing Data from a Text File 07:27 Join Multiple Tables & Create One Master Table 07:40 Getting Data from Text Files 12:37 Getting Data from Excel Tables 08:29 Getting Data from Excel Ranges 10:33 Getting Data from External Excel Files 06:52 14 more sections Instructor Sam s Instructor 4.0 Instructor Rating 516 Reviews 35,273 Students 4 Courses Hi! My name is Sam and i'm 29. I have been using Excel since my early teens, and very soon realized that I absolutely love it. A few years back, I got first opportunity to work in Excel, when I landed the job. Nothing is impossible . All of it depends on how we're skilled on it! 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:'678192ed1932408a',m:'5d370d36286ed94b6fc84e485c3ee5de68ca905b-1627847202-1800-AV5h+sC1Am5/rzSwi/FsW34VYf7ES0uchzmglsYqaqIPFrb5HSNr8JSYrHXSG130S0nm/3DudBc/T31Ixywc6fV4eV3xn9HJxhMcz9NSugnlx0Ql1/8hej8f5JGKsJeiWfFy3HWrEuHhGxbz56Oj3k+TVx/2261XNSitRqMyi7KhxA8oxP0WwQ5tUywDv+eUTg==',s:[0x569664e397,0xd5091b619b],}})();
  2. Mastering the Math, Statistical, Logic and Text functions Create dynamic reports by mastering most popular tools, Excel Pivot Tables and Power Query Impress your boss by unlocking dynamic formulas with IF, Nesting Vlookup functions, INDEX, MATCH functions and many more Keyboard shortcuts to save hours of time and boost your productivity in Excel Use “What-If” analysis based on changing conditions Utilize the full power of Microsoft Excel by automating your day to day tasks through Macros and VBA Get LIFETIME access to exercises, quizzes & 1-on-1 expert support Requirements This course was created with Excel 2016 however all features will work in Excel 2010, 2013, 2016 and Office 365. Require a computer with excel installed (2016 version or later recommended) and a willingness to learn. No prior knowledge is required as each step is explained in this course Description Why buy individual Excel courses when this whole Microsoft Excel course will give you everything you need! Microsoft Excel all-in-one Package - Become a certified Excel Ninja with #1 Excel course Looking for an online Excel course to improve your skills and save time but don't know where to start? Start mastering Excel, the world's most popular and powerful spreadsheet program and your sought after excel certification can help you impress your employer and advance your career prospects. I have picked out the Excel Essential skills and packaged them in a structured course. I will take you step-by-step through engaging video tutorials and teach you everything from scratch & to be able to use VBA to improve your work flow, save time and automate your current Excel projects. What differentiates this course from other Microsoft Excel Courses? Yes, there are many Microsoft Excel Courses out there teaching you the important Excel functions and features you need to master. BUT, do you get step-step-step learning with Quizzes, Exercises and VBA programming all in one course? This course will get you confident and comfortable designing from simple to complex spreadsheets. You will go beyond Excel basics & advanced section & become a smart user. As you go through the course, you will be able to apply what you learnt immediately to your job. This Complete Excel Course is for two types of people: 1. Excel Beginners i.e. anyone who want to boost the career by learning excel from scratch to VBA Expert! 2. Excel intermediate and advanced users who want to make sure their skills cover all the essentials. This includes many Excel tricks and hidden features few data analysts know of. This course covers all the fundamentals an Excel beginner needs to know as well as bridge the gaps for Excel Intermediate & Advanced users. This is more than just Excel course as it starts off easy and adds VBA programming that many Excel users don't know of. ----------------------------------------------------------------------------------------------------------------------------------------------- ★★★★★ "So far, I have found it particularly useful in my personal life. This is amazing course which impacts the learner positively and makes him able to be a leader who cab bring change. it is very easy to understand. 100% i will be able to apply in my work & personal life. i learned so much from this course, it was a great learning opportunity and i look forward to continuing to put the things i learned into real world practice. Thank you for this excellent course. It was rigorous, robust, and very meaningful ". Dips ★★★★★ "Its really what we say basic to build up. Great course and well explained look forward for more courses from these Teacher for Microsoft Office. Thanks for sharing Your Knowledge ". Fluid|Serspin The course comes with lifetime access. Buy now. Watch anytime. By the end of the course you'll be confident, writing robust & elegant formulas and functions from scratch, allowing you to: Input Data and Navigate Large Spreadsheets Easily build dynamic tools & Excel dashboards to filter, display and analyze your data Apply Excel hacks to get your work done faster Be able to choose right Excel formula to automate your data analysis (Excel IF Function, ROUND and more) Join datasets from multiple sources with Excel's LOOKUP, INDEX & MATCH functions Get Answers from your Data Organize, Clean and Manage Large Data Create Interactive reports with Excel Pivot Tables, Pivot Charts, Slicers and Timelines Import & transform data with tools like Get & Transform (Power Query) Manipulate dates, times, text, and arrays Reduce manual routine tasks to the click of button VBA programming & read, write own Macro to automate the tasks We will dive into a broad range of Excel formulas & functions. Below are some Excel Features & Functions that you will learn: Useful Excel shortcuts for data entry and navigation. Protect your Excel files and worksheets properly. To apply formatting correctly for cleaner and more professional reports. To use important features like drop-down lists and add data validation to the cells. The way you can restrict users to type the data which can be input in each cell. Add Comments & Notes to cells & how to print the same if needed. Add Data & time Stamps to your reports. Lookup/Reference Functions. Statistical Functions. Logic Functions. Text Functions. Date & Time Functions. The most useful & powerful functions such as COUNT, COUNTIFS, SUMIFS, SUMPRODUCT, Nesting IF functions by nesting AND and OR within them and many more. Excel features that will help you to organize and structure data so it makes (Sort, Filter, Search & Replace Go to Special, combine text with & character.) Excel Pivot Tables & Pivot Charts so that you can quickly get insights from your data. What Excel Power Query can do for you and how easy it is to combine data from different spreadsheets Use Power Query to unpivot the data drive another Pivot Table, transform messy data to tabular data. Join Multiple Tables & create long table using Power Query that can be used to feed business intelligence solutions & Pivot Tables. Import data from Text File. Three different ways to run the Macro i.e. from Macro Dialog, Using Keyboard Shortcuts & using buttons. More than just Excel! VBA (Visual Basic for Applications) from Scratch to advanced. So, what are you waiting for? Enroll Today and take the next step in mastering Excel and go from Excel Novice to Excel Ninja! Become a certified Excel Ninja Today. The course comes with lifetime access. Buy now. Watch anytime. Who this course is for: This online course is suitable for anyone who wants to learn Excel. No prior knowledge of Excel is required. This Microsoft Excel Course will take you through 4 levels of Microsoft Excel Topics (Beginner, Intermediate, Advanced and Beyond). Whether you are a working professional, student, teacher, freelancer, or entrepreneur, this training can benefit you and help you take your Excel skills to the next level. Excel is utilized in almost every office in the world, thus offers a great scope. It is highly used in decision making and a kind of analysis tool that represents data into graphical form. Show more Show less Course content 24 sections • 108 lectures • 15h 35m total length Expand all sections A Quick Tour to the Basics of Excel 3 lectures • 23min The Ribbon Commands Preview 06:49 The Work Surface - Workbook and Worksheets Preview 07:21 Navigation Tools with 100+ Keyboard Shortcuts 08:33 Getting to Know Excel Step-By-Step 5 lectures • 30min First File 06:27 Formatting 07:59 Work with Alignment and Wrap text 03:57 Hiding and unhiding rows and columns 04:53 Basic Math 06:36 Cell Referencing & Excel Functions 8 lectures • 1hr 22min Formula Anatomy 08:37 Absolute and Relative Cell Referencing 15:34 Function Anatomy 09:02 Math Functions 09:28 Basic Statistics 07:37 Logic Functions 08:47 Text Functions 11:02 Understanding Dates & Time 11:57 Lookup & IF Family Functions 9 lectures • 1hr 17min Formula Auditing 08:00 Conditional Math - SUMIF, COUNTIF & SUMPRODUCT Functions 09:26 External Links 07:50 Temporal Functions - EOMONTH & EDATE Functions 08:14 VLOOKUP with Approximate Match 09:44 VLOOKUP with Exact Match 08:11 Using lookup with Large Tables 06:08 Nesting Lookup Functions 07:14 Lookup Functions - Hlookup, Index, Match & Index with Match 11:45 Test your Knowledge 0 lectures • 0min Test your Knowledge with this Quiz 35 questions Optimizing Data: Sorting, Filtering, Tables & Macro 5 lectures • 1hr Basic & Advanced Sorting 15:40 Basic & Advanced Filtering 19:37 Naming Ranges 08:18 Excel Tables 08:22 Recording Macros 07:34 Quick Insights with Excel Pivot Tables & Data Analysis Tools 8 lectures • 1hr 13min Creating PivotTables 06:48 Formatting Pivot Tables 09:32 Calculated Fields in Pivot Tables 06:54 Slicers to Calculate & Manipulate Fields 09:42 Grouping by date, time and other factors 13:24 Pivot Chart 06:32 What-If analysis & Data Analysis Tools 11:11 Solver in Excel 09:07 Formatting including Conditional & Number Formatting in Excel 5 lectures • 49min Cell Formatting 07:46 Outlining 16:42 Build own Custom Number Formats 09:32 Conditional formats with Built-in Rules 07:43 Conditional formats with Custom Rules 06:51 Working with Excel Charts 8 lectures • 50min Column Charts 05:00 Bar Charts 05:55 Pie Charts 06:48 Line Charts 06:18 Waterfall Charts 04:04 Sparklines 08:15 Combination Charts - Area and Line 07:24 Combination Charts - Column and Line 06:31 Power Query in Excel 8 lectures • 1hr 8min Unpivoting Data using Power Query 07:58 Build Contiguous Data using Power Query 06:11 Importing Data from a Text File 07:27 Join Multiple Tables & Create One Master Table 07:40 Getting Data from Text Files 12:37 Getting Data from Excel Tables 08:29 Getting Data from Excel Ranges 10:33 Getting Data from External Excel Files 06:52 14 more sections Instructor Sam s Instructor 4.0 Instructor Rating 516 Reviews 35,273 Students 4 Courses Hi! My name is Sam and i'm 29. I have been using Excel since my early teens, and very soon realized that I absolutely love it. A few years back, I got first opportunity to work in Excel, when I landed the job. Nothing is impossible . All of it depends on how we're skilled on it! 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:'678192ed1932408a',m:'5d370d36286ed94b6fc84e485c3ee5de68ca905b-1627847202-1800-AV5h+sC1Am5/rzSwi/FsW34VYf7ES0uchzmglsYqaqIPFrb5HSNr8JSYrHXSG130S0nm/3DudBc/T31Ixywc6fV4eV3xn9HJxhMcz9NSugnlx0Ql1/8hej8f5JGKsJeiWfFy3HWrEuHhGxbz56Oj3k+TVx/2261XNSitRqMyi7KhxA8oxP0WwQ5tUywDv+eUTg==',s:[0x569664e397,0xd5091b619b],}})();
  3. Create dynamic reports by mastering most popular tools, Excel Pivot Tables and Power Query Impress your boss by unlocking dynamic formulas with IF, Nesting Vlookup functions, INDEX, MATCH functions and many more Keyboard shortcuts to save hours of time and boost your productivity in Excel Use “What-If” analysis based on changing conditions Utilize the full power of Microsoft Excel by automating your day to day tasks through Macros and VBA Get LIFETIME access to exercises, quizzes & 1-on-1 expert support Requirements This course was created with Excel 2016 however all features will work in Excel 2010, 2013, 2016 and Office 365. Require a computer with excel installed (2016 version or later recommended) and a willingness to learn. No prior knowledge is required as each step is explained in this course Description Why buy individual Excel courses when this whole Microsoft Excel course will give you everything you need! Microsoft Excel all-in-one Package - Become a certified Excel Ninja with #1 Excel course Looking for an online Excel course to improve your skills and save time but don't know where to start? Start mastering Excel, the world's most popular and powerful spreadsheet program and your sought after excel certification can help you impress your employer and advance your career prospects. I have picked out the Excel Essential skills and packaged them in a structured course. I will take you step-by-step through engaging video tutorials and teach you everything from scratch & to be able to use VBA to improve your work flow, save time and automate your current Excel projects. What differentiates this course from other Microsoft Excel Courses? Yes, there are many Microsoft Excel Courses out there teaching you the important Excel functions and features you need to master. BUT, do you get step-step-step learning with Quizzes, Exercises and VBA programming all in one course? This course will get you confident and comfortable designing from simple to complex spreadsheets. You will go beyond Excel basics & advanced section & become a smart user. As you go through the course, you will be able to apply what you learnt immediately to your job. This Complete Excel Course is for two types of people: 1. Excel Beginners i.e. anyone who want to boost the career by learning excel from scratch to VBA Expert! 2. Excel intermediate and advanced users who want to make sure their skills cover all the essentials. This includes many Excel tricks and hidden features few data analysts know of. This course covers all the fundamentals an Excel beginner needs to know as well as bridge the gaps for Excel Intermediate & Advanced users. This is more than just Excel course as it starts off easy and adds VBA programming that many Excel users don't know of. ----------------------------------------------------------------------------------------------------------------------------------------------- ★★★★★ "So far, I have found it particularly useful in my personal life. This is amazing course which impacts the learner positively and makes him able to be a leader who cab bring change. it is very easy to understand. 100% i will be able to apply in my work & personal life. i learned so much from this course, it was a great learning opportunity and i look forward to continuing to put the things i learned into real world practice. Thank you for this excellent course. It was rigorous, robust, and very meaningful ". Dips ★★★★★ "Its really what we say basic to build up. Great course and well explained look forward for more courses from these Teacher for Microsoft Office. Thanks for sharing Your Knowledge ". Fluid|Serspin The course comes with lifetime access. Buy now. Watch anytime. By the end of the course you'll be confident, writing robust & elegant formulas and functions from scratch, allowing you to: Input Data and Navigate Large Spreadsheets Easily build dynamic tools & Excel dashboards to filter, display and analyze your data Apply Excel hacks to get your work done faster Be able to choose right Excel formula to automate your data analysis (Excel IF Function, ROUND and more) Join datasets from multiple sources with Excel's LOOKUP, INDEX & MATCH functions Get Answers from your Data Organize, Clean and Manage Large Data Create Interactive reports with Excel Pivot Tables, Pivot Charts, Slicers and Timelines Import & transform data with tools like Get & Transform (Power Query) Manipulate dates, times, text, and arrays Reduce manual routine tasks to the click of button VBA programming & read, write own Macro to automate the tasks We will dive into a broad range of Excel formulas & functions. Below are some Excel Features & Functions that you will learn: Useful Excel shortcuts for data entry and navigation. Protect your Excel files and worksheets properly. To apply formatting correctly for cleaner and more professional reports. To use important features like drop-down lists and add data validation to the cells. The way you can restrict users to type the data which can be input in each cell. Add Comments & Notes to cells & how to print the same if needed. Add Data & time Stamps to your reports. Lookup/Reference Functions. Statistical Functions. Logic Functions. Text Functions. Date & Time Functions. The most useful & powerful functions such as COUNT, COUNTIFS, SUMIFS, SUMPRODUCT, Nesting IF functions by nesting AND and OR within them and many more. Excel features that will help you to organize and structure data so it makes (Sort, Filter, Search & Replace Go to Special, combine text with & character.) Excel Pivot Tables & Pivot Charts so that you can quickly get insights from your data. What Excel Power Query can do for you and how easy it is to combine data from different spreadsheets Use Power Query to unpivot the data drive another Pivot Table, transform messy data to tabular data. Join Multiple Tables & create long table using Power Query that can be used to feed business intelligence solutions & Pivot Tables. Import data from Text File. Three different ways to run the Macro i.e. from Macro Dialog, Using Keyboard Shortcuts & using buttons. More than just Excel! VBA (Visual Basic for Applications) from Scratch to advanced. So, what are you waiting for? Enroll Today and take the next step in mastering Excel and go from Excel Novice to Excel Ninja! Become a certified Excel Ninja Today. The course comes with lifetime access. Buy now. Watch anytime. Who this course is for: This online course is suitable for anyone who wants to learn Excel. No prior knowledge of Excel is required. This Microsoft Excel Course will take you through 4 levels of Microsoft Excel Topics (Beginner, Intermediate, Advanced and Beyond). Whether you are a working professional, student, teacher, freelancer, or entrepreneur, this training can benefit you and help you take your Excel skills to the next level. Excel is utilized in almost every office in the world, thus offers a great scope. It is highly used in decision making and a kind of analysis tool that represents data into graphical form. Show more Show less Course content 24 sections • 108 lectures • 15h 35m total length Expand all sections A Quick Tour to the Basics of Excel 3 lectures • 23min The Ribbon Commands Preview 06:49 The Work Surface - Workbook and Worksheets Preview 07:21 Navigation Tools with 100+ Keyboard Shortcuts 08:33 Getting to Know Excel Step-By-Step 5 lectures • 30min First File 06:27 Formatting 07:59 Work with Alignment and Wrap text 03:57 Hiding and unhiding rows and columns 04:53 Basic Math 06:36 Cell Referencing & Excel Functions 8 lectures • 1hr 22min Formula Anatomy 08:37 Absolute and Relative Cell Referencing 15:34 Function Anatomy 09:02 Math Functions 09:28 Basic Statistics 07:37 Logic Functions 08:47 Text Functions 11:02 Understanding Dates & Time 11:57 Lookup & IF Family Functions 9 lectures • 1hr 17min Formula Auditing 08:00 Conditional Math - SUMIF, COUNTIF & SUMPRODUCT Functions 09:26 External Links 07:50 Temporal Functions - EOMONTH & EDATE Functions 08:14 VLOOKUP with Approximate Match 09:44 VLOOKUP with Exact Match 08:11 Using lookup with Large Tables 06:08 Nesting Lookup Functions 07:14 Lookup Functions - Hlookup, Index, Match & Index with Match 11:45 Test your Knowledge 0 lectures • 0min Test your Knowledge with this Quiz 35 questions Optimizing Data: Sorting, Filtering, Tables & Macro 5 lectures • 1hr Basic & Advanced Sorting 15:40 Basic & Advanced Filtering 19:37 Naming Ranges 08:18 Excel Tables 08:22 Recording Macros 07:34 Quick Insights with Excel Pivot Tables & Data Analysis Tools 8 lectures • 1hr 13min Creating PivotTables 06:48 Formatting Pivot Tables 09:32 Calculated Fields in Pivot Tables 06:54 Slicers to Calculate & Manipulate Fields 09:42 Grouping by date, time and other factors 13:24 Pivot Chart 06:32 What-If analysis & Data Analysis Tools 11:11 Solver in Excel 09:07 Formatting including Conditional & Number Formatting in Excel 5 lectures • 49min Cell Formatting 07:46 Outlining 16:42 Build own Custom Number Formats 09:32 Conditional formats with Built-in Rules 07:43 Conditional formats with Custom Rules 06:51 Working with Excel Charts 8 lectures • 50min Column Charts 05:00 Bar Charts 05:55 Pie Charts 06:48 Line Charts 06:18 Waterfall Charts 04:04 Sparklines 08:15 Combination Charts - Area and Line 07:24 Combination Charts - Column and Line 06:31 Power Query in Excel 8 lectures • 1hr 8min Unpivoting Data using Power Query 07:58 Build Contiguous Data using Power Query 06:11 Importing Data from a Text File 07:27 Join Multiple Tables & Create One Master Table 07:40 Getting Data from Text Files 12:37 Getting Data from Excel Tables 08:29 Getting Data from Excel Ranges 10:33 Getting Data from External Excel Files 06:52 14 more sections Instructor Sam s Instructor 4.0 Instructor Rating 516 Reviews 35,273 Students 4 Courses Hi! My name is Sam and i'm 29. I have been using Excel since my early teens, and very soon realized that I absolutely love it. A few years back, I got first opportunity to work in Excel, when I landed the job. Nothing is impossible . All of it depends on how we're skilled on it! 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:'678192ed1932408a',m:'5d370d36286ed94b6fc84e485c3ee5de68ca905b-1627847202-1800-AV5h+sC1Am5/rzSwi/FsW34VYf7ES0uchzmglsYqaqIPFrb5HSNr8JSYrHXSG130S0nm/3DudBc/T31Ixywc6fV4eV3xn9HJxhMcz9NSugnlx0Ql1/8hej8f5JGKsJeiWfFy3HWrEuHhGxbz56Oj3k+TVx/2261XNSitRqMyi7KhxA8oxP0WwQ5tUywDv+eUTg==',s:[0x569664e397,0xd5091b619b],}})();
  4. Impress your boss by unlocking dynamic formulas with IF, Nesting Vlookup functions, INDEX, MATCH functions and many more Keyboard shortcuts to save hours of time and boost your productivity in Excel Use “What-If” analysis based on changing conditions Utilize the full power of Microsoft Excel by automating your day to day tasks through Macros and VBA Get LIFETIME access to exercises, quizzes & 1-on-1 expert support Requirements This course was created with Excel 2016 however all features will work in Excel 2010, 2013, 2016 and Office 365. Require a computer with excel installed (2016 version or later recommended) and a willingness to learn. No prior knowledge is required as each step is explained in this course Description Why buy individual Excel courses when this whole Microsoft Excel course will give you everything you need! Microsoft Excel all-in-one Package - Become a certified Excel Ninja with #1 Excel course Looking for an online Excel course to improve your skills and save time but don't know where to start? Start mastering Excel, the world's most popular and powerful spreadsheet program and your sought after excel certification can help you impress your employer and advance your career prospects. I have picked out the Excel Essential skills and packaged them in a structured course. I will take you step-by-step through engaging video tutorials and teach you everything from scratch & to be able to use VBA to improve your work flow, save time and automate your current Excel projects. What differentiates this course from other Microsoft Excel Courses? Yes, there are many Microsoft Excel Courses out there teaching you the important Excel functions and features you need to master. BUT, do you get step-step-step learning with Quizzes, Exercises and VBA programming all in one course? This course will get you confident and comfortable designing from simple to complex spreadsheets. You will go beyond Excel basics & advanced section & become a smart user. As you go through the course, you will be able to apply what you learnt immediately to your job. This Complete Excel Course is for two types of people: 1. Excel Beginners i.e. anyone who want to boost the career by learning excel from scratch to VBA Expert! 2. Excel intermediate and advanced users who want to make sure their skills cover all the essentials. This includes many Excel tricks and hidden features few data analysts know of. This course covers all the fundamentals an Excel beginner needs to know as well as bridge the gaps for Excel Intermediate & Advanced users. This is more than just Excel course as it starts off easy and adds VBA programming that many Excel users don't know of. ----------------------------------------------------------------------------------------------------------------------------------------------- ★★★★★ "So far, I have found it particularly useful in my personal life. This is amazing course which impacts the learner positively and makes him able to be a leader who cab bring change. it is very easy to understand. 100% i will be able to apply in my work & personal life. i learned so much from this course, it was a great learning opportunity and i look forward to continuing to put the things i learned into real world practice. Thank you for this excellent course. It was rigorous, robust, and very meaningful ". Dips ★★★★★ "Its really what we say basic to build up. Great course and well explained look forward for more courses from these Teacher for Microsoft Office. Thanks for sharing Your Knowledge ". Fluid|Serspin The course comes with lifetime access. Buy now. Watch anytime. By the end of the course you'll be confident, writing robust & elegant formulas and functions from scratch, allowing you to: Input Data and Navigate Large Spreadsheets Easily build dynamic tools & Excel dashboards to filter, display and analyze your data Apply Excel hacks to get your work done faster Be able to choose right Excel formula to automate your data analysis (Excel IF Function, ROUND and more) Join datasets from multiple sources with Excel's LOOKUP, INDEX & MATCH functions Get Answers from your Data Organize, Clean and Manage Large Data Create Interactive reports with Excel Pivot Tables, Pivot Charts, Slicers and Timelines Import & transform data with tools like Get & Transform (Power Query) Manipulate dates, times, text, and arrays Reduce manual routine tasks to the click of button VBA programming & read, write own Macro to automate the tasks We will dive into a broad range of Excel formulas & functions. Below are some Excel Features & Functions that you will learn: Useful Excel shortcuts for data entry and navigation. Protect your Excel files and worksheets properly. To apply formatting correctly for cleaner and more professional reports. To use important features like drop-down lists and add data validation to the cells. The way you can restrict users to type the data which can be input in each cell. Add Comments & Notes to cells & how to print the same if needed. Add Data & time Stamps to your reports. Lookup/Reference Functions. Statistical Functions. Logic Functions. Text Functions. Date & Time Functions. The most useful & powerful functions such as COUNT, COUNTIFS, SUMIFS, SUMPRODUCT, Nesting IF functions by nesting AND and OR within them and many more. Excel features that will help you to organize and structure data so it makes (Sort, Filter, Search & Replace Go to Special, combine text with & character.) Excel Pivot Tables & Pivot Charts so that you can quickly get insights from your data. What Excel Power Query can do for you and how easy it is to combine data from different spreadsheets Use Power Query to unpivot the data drive another Pivot Table, transform messy data to tabular data. Join Multiple Tables & create long table using Power Query that can be used to feed business intelligence solutions & Pivot Tables. Import data from Text File. Three different ways to run the Macro i.e. from Macro Dialog, Using Keyboard Shortcuts & using buttons. More than just Excel! VBA (Visual Basic for Applications) from Scratch to advanced. So, what are you waiting for? Enroll Today and take the next step in mastering Excel and go from Excel Novice to Excel Ninja! Become a certified Excel Ninja Today. The course comes with lifetime access. Buy now. Watch anytime. Who this course is for: This online course is suitable for anyone who wants to learn Excel. No prior knowledge of Excel is required. This Microsoft Excel Course will take you through 4 levels of Microsoft Excel Topics (Beginner, Intermediate, Advanced and Beyond). Whether you are a working professional, student, teacher, freelancer, or entrepreneur, this training can benefit you and help you take your Excel skills to the next level. Excel is utilized in almost every office in the world, thus offers a great scope. It is highly used in decision making and a kind of analysis tool that represents data into graphical form. Show more Show less Course content 24 sections • 108 lectures • 15h 35m total length Expand all sections A Quick Tour to the Basics of Excel 3 lectures • 23min The Ribbon Commands Preview 06:49 The Work Surface - Workbook and Worksheets Preview 07:21 Navigation Tools with 100+ Keyboard Shortcuts 08:33 Getting to Know Excel Step-By-Step 5 lectures • 30min First File 06:27 Formatting 07:59 Work with Alignment and Wrap text 03:57 Hiding and unhiding rows and columns 04:53 Basic Math 06:36 Cell Referencing & Excel Functions 8 lectures • 1hr 22min Formula Anatomy 08:37 Absolute and Relative Cell Referencing 15:34 Function Anatomy 09:02 Math Functions 09:28 Basic Statistics 07:37 Logic Functions 08:47 Text Functions 11:02 Understanding Dates & Time 11:57 Lookup & IF Family Functions 9 lectures • 1hr 17min Formula Auditing 08:00 Conditional Math - SUMIF, COUNTIF & SUMPRODUCT Functions 09:26 External Links 07:50 Temporal Functions - EOMONTH & EDATE Functions 08:14 VLOOKUP with Approximate Match 09:44 VLOOKUP with Exact Match 08:11 Using lookup with Large Tables 06:08 Nesting Lookup Functions 07:14 Lookup Functions - Hlookup, Index, Match & Index with Match 11:45 Test your Knowledge 0 lectures • 0min Test your Knowledge with this Quiz 35 questions Optimizing Data: Sorting, Filtering, Tables & Macro 5 lectures • 1hr Basic & Advanced Sorting 15:40 Basic & Advanced Filtering 19:37 Naming Ranges 08:18 Excel Tables 08:22 Recording Macros 07:34 Quick Insights with Excel Pivot Tables & Data Analysis Tools 8 lectures • 1hr 13min Creating PivotTables 06:48 Formatting Pivot Tables 09:32 Calculated Fields in Pivot Tables 06:54 Slicers to Calculate & Manipulate Fields 09:42 Grouping by date, time and other factors 13:24 Pivot Chart 06:32 What-If analysis & Data Analysis Tools 11:11 Solver in Excel 09:07 Formatting including Conditional & Number Formatting in Excel 5 lectures • 49min Cell Formatting 07:46 Outlining 16:42 Build own Custom Number Formats 09:32 Conditional formats with Built-in Rules 07:43 Conditional formats with Custom Rules 06:51 Working with Excel Charts 8 lectures • 50min Column Charts 05:00 Bar Charts 05:55 Pie Charts 06:48 Line Charts 06:18 Waterfall Charts 04:04 Sparklines 08:15 Combination Charts - Area and Line 07:24 Combination Charts - Column and Line 06:31 Power Query in Excel 8 lectures • 1hr 8min Unpivoting Data using Power Query 07:58 Build Contiguous Data using Power Query 06:11 Importing Data from a Text File 07:27 Join Multiple Tables & Create One Master Table 07:40 Getting Data from Text Files 12:37 Getting Data from Excel Tables 08:29 Getting Data from Excel Ranges 10:33 Getting Data from External Excel Files 06:52 14 more sections Instructor Sam s Instructor 4.0 Instructor Rating 516 Reviews 35,273 Students 4 Courses Hi! My name is Sam and i'm 29. I have been using Excel since my early teens, and very soon realized that I absolutely love it. A few years back, I got first opportunity to work in Excel, when I landed the job. Nothing is impossible . All of it depends on how we're skilled on it! 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:'678192ed1932408a',m:'5d370d36286ed94b6fc84e485c3ee5de68ca905b-1627847202-1800-AV5h+sC1Am5/rzSwi/FsW34VYf7ES0uchzmglsYqaqIPFrb5HSNr8JSYrHXSG130S0nm/3DudBc/T31Ixywc6fV4eV3xn9HJxhMcz9NSugnlx0Ql1/8hej8f5JGKsJeiWfFy3HWrEuHhGxbz56Oj3k+TVx/2261XNSitRqMyi7KhxA8oxP0WwQ5tUywDv+eUTg==',s:[0x569664e397,0xd5091b619b],}})();
  5. Keyboard shortcuts to save hours of time and boost your productivity in Excel Use “What-If” analysis based on changing conditions Utilize the full power of Microsoft Excel by automating your day to day tasks through Macros and VBA Get LIFETIME access to exercises, quizzes & 1-on-1 expert support Requirements This course was created with Excel 2016 however all features will work in Excel 2010, 2013, 2016 and Office 365. Require a computer with excel installed (2016 version or later recommended) and a willingness to learn. No prior knowledge is required as each step is explained in this course Description Why buy individual Excel courses when this whole Microsoft Excel course will give you everything you need! Microsoft Excel all-in-one Package - Become a certified Excel Ninja with #1 Excel course Looking for an online Excel course to improve your skills and save time but don't know where to start? Start mastering Excel, the world's most popular and powerful spreadsheet program and your sought after excel certification can help you impress your employer and advance your career prospects. I have picked out the Excel Essential skills and packaged them in a structured course. I will take you step-by-step through engaging video tutorials and teach you everything from scratch & to be able to use VBA to improve your work flow, save time and automate your current Excel projects. What differentiates this course from other Microsoft Excel Courses? Yes, there are many Microsoft Excel Courses out there teaching you the important Excel functions and features you need to master. BUT, do you get step-step-step learning with Quizzes, Exercises and VBA programming all in one course? This course will get you confident and comfortable designing from simple to complex spreadsheets. You will go beyond Excel basics & advanced section & become a smart user. As you go through the course, you will be able to apply what you learnt immediately to your job. This Complete Excel Course is for two types of people: 1. Excel Beginners i.e. anyone who want to boost the career by learning excel from scratch to VBA Expert! 2. Excel intermediate and advanced users who want to make sure their skills cover all the essentials. This includes many Excel tricks and hidden features few data analysts know of. This course covers all the fundamentals an Excel beginner needs to know as well as bridge the gaps for Excel Intermediate & Advanced users. This is more than just Excel course as it starts off easy and adds VBA programming that many Excel users don't know of. ----------------------------------------------------------------------------------------------------------------------------------------------- ★★★★★ "So far, I have found it particularly useful in my personal life. This is amazing course which impacts the learner positively and makes him able to be a leader who cab bring change. it is very easy to understand. 100% i will be able to apply in my work & personal life. i learned so much from this course, it was a great learning opportunity and i look forward to continuing to put the things i learned into real world practice. Thank you for this excellent course. It was rigorous, robust, and very meaningful ". Dips ★★★★★ "Its really what we say basic to build up. Great course and well explained look forward for more courses from these Teacher for Microsoft Office. Thanks for sharing Your Knowledge ". Fluid|Serspin The course comes with lifetime access. Buy now. Watch anytime. By the end of the course you'll be confident, writing robust & elegant formulas and functions from scratch, allowing you to: Input Data and Navigate Large Spreadsheets Easily build dynamic tools & Excel dashboards to filter, display and analyze your data Apply Excel hacks to get your work done faster Be able to choose right Excel formula to automate your data analysis (Excel IF Function, ROUND and more) Join datasets from multiple sources with Excel's LOOKUP, INDEX & MATCH functions Get Answers from your Data Organize, Clean and Manage Large Data Create Interactive reports with Excel Pivot Tables, Pivot Charts, Slicers and Timelines Import & transform data with tools like Get & Transform (Power Query) Manipulate dates, times, text, and arrays Reduce manual routine tasks to the click of button VBA programming & read, write own Macro to automate the tasks We will dive into a broad range of Excel formulas & functions. Below are some Excel Features & Functions that you will learn: Useful Excel shortcuts for data entry and navigation. Protect your Excel files and worksheets properly. To apply formatting correctly for cleaner and more professional reports. To use important features like drop-down lists and add data validation to the cells. The way you can restrict users to type the data which can be input in each cell. Add Comments & Notes to cells & how to print the same if needed. Add Data & time Stamps to your reports. Lookup/Reference Functions. Statistical Functions. Logic Functions. Text Functions. Date & Time Functions. The most useful & powerful functions such as COUNT, COUNTIFS, SUMIFS, SUMPRODUCT, Nesting IF functions by nesting AND and OR within them and many more. Excel features that will help you to organize and structure data so it makes (Sort, Filter, Search & Replace Go to Special, combine text with & character.) Excel Pivot Tables & Pivot Charts so that you can quickly get insights from your data. What Excel Power Query can do for you and how easy it is to combine data from different spreadsheets Use Power Query to unpivot the data drive another Pivot Table, transform messy data to tabular data. Join Multiple Tables & create long table using Power Query that can be used to feed business intelligence solutions & Pivot Tables. Import data from Text File. Three different ways to run the Macro i.e. from Macro Dialog, Using Keyboard Shortcuts & using buttons. More than just Excel! VBA (Visual Basic for Applications) from Scratch to advanced. So, what are you waiting for? Enroll Today and take the next step in mastering Excel and go from Excel Novice to Excel Ninja! Become a certified Excel Ninja Today. The course comes with lifetime access. Buy now. Watch anytime. Who this course is for: This online course is suitable for anyone who wants to learn Excel. No prior knowledge of Excel is required. This Microsoft Excel Course will take you through 4 levels of Microsoft Excel Topics (Beginner, Intermediate, Advanced and Beyond). Whether you are a working professional, student, teacher, freelancer, or entrepreneur, this training can benefit you and help you take your Excel skills to the next level. Excel is utilized in almost every office in the world, thus offers a great scope. It is highly used in decision making and a kind of analysis tool that represents data into graphical form. Show more Show less Course content 24 sections • 108 lectures • 15h 35m total length Expand all sections A Quick Tour to the Basics of Excel 3 lectures • 23min The Ribbon Commands Preview 06:49 The Work Surface - Workbook and Worksheets Preview 07:21 Navigation Tools with 100+ Keyboard Shortcuts 08:33 Getting to Know Excel Step-By-Step 5 lectures • 30min First File 06:27 Formatting 07:59 Work with Alignment and Wrap text 03:57 Hiding and unhiding rows and columns 04:53 Basic Math 06:36 Cell Referencing & Excel Functions 8 lectures • 1hr 22min Formula Anatomy 08:37 Absolute and Relative Cell Referencing 15:34 Function Anatomy 09:02 Math Functions 09:28 Basic Statistics 07:37 Logic Functions 08:47 Text Functions 11:02 Understanding Dates & Time 11:57 Lookup & IF Family Functions 9 lectures • 1hr 17min Formula Auditing 08:00 Conditional Math - SUMIF, COUNTIF & SUMPRODUCT Functions 09:26 External Links 07:50 Temporal Functions - EOMONTH & EDATE Functions 08:14 VLOOKUP with Approximate Match 09:44 VLOOKUP with Exact Match 08:11 Using lookup with Large Tables 06:08 Nesting Lookup Functions 07:14 Lookup Functions - Hlookup, Index, Match & Index with Match 11:45 Test your Knowledge 0 lectures • 0min Test your Knowledge with this Quiz 35 questions Optimizing Data: Sorting, Filtering, Tables & Macro 5 lectures • 1hr Basic & Advanced Sorting 15:40 Basic & Advanced Filtering 19:37 Naming Ranges 08:18 Excel Tables 08:22 Recording Macros 07:34 Quick Insights with Excel Pivot Tables & Data Analysis Tools 8 lectures • 1hr 13min Creating PivotTables 06:48 Formatting Pivot Tables 09:32 Calculated Fields in Pivot Tables 06:54 Slicers to Calculate & Manipulate Fields 09:42 Grouping by date, time and other factors 13:24 Pivot Chart 06:32 What-If analysis & Data Analysis Tools 11:11 Solver in Excel 09:07 Formatting including Conditional & Number Formatting in Excel 5 lectures • 49min Cell Formatting 07:46 Outlining 16:42 Build own Custom Number Formats 09:32 Conditional formats with Built-in Rules 07:43 Conditional formats with Custom Rules 06:51 Working with Excel Charts 8 lectures • 50min Column Charts 05:00 Bar Charts 05:55 Pie Charts 06:48 Line Charts 06:18 Waterfall Charts 04:04 Sparklines 08:15 Combination Charts - Area and Line 07:24 Combination Charts - Column and Line 06:31 Power Query in Excel 8 lectures • 1hr 8min Unpivoting Data using Power Query 07:58 Build Contiguous Data using Power Query 06:11 Importing Data from a Text File 07:27 Join Multiple Tables & Create One Master Table 07:40 Getting Data from Text Files 12:37 Getting Data from Excel Tables 08:29 Getting Data from Excel Ranges 10:33 Getting Data from External Excel Files 06:52 14 more sections Instructor Sam s Instructor 4.0 Instructor Rating 516 Reviews 35,273 Students 4 Courses Hi! My name is Sam and i'm 29. I have been using Excel since my early teens, and very soon realized that I absolutely love it. A few years back, I got first opportunity to work in Excel, when I landed the job. Nothing is impossible . All of it depends on how we're skilled on it! 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:'678192ed1932408a',m:'5d370d36286ed94b6fc84e485c3ee5de68ca905b-1627847202-1800-AV5h+sC1Am5/rzSwi/FsW34VYf7ES0uchzmglsYqaqIPFrb5HSNr8JSYrHXSG130S0nm/3DudBc/T31Ixywc6fV4eV3xn9HJxhMcz9NSugnlx0Ql1/8hej8f5JGKsJeiWfFy3HWrEuHhGxbz56Oj3k+TVx/2261XNSitRqMyi7KhxA8oxP0WwQ5tUywDv+eUTg==',s:[0x569664e397,0xd5091b619b],}})();
  6. Use “What-If” analysis based on changing conditions Utilize the full power of Microsoft Excel by automating your day to day tasks through Macros and VBA Get LIFETIME access to exercises, quizzes & 1-on-1 expert support Requirements This course was created with Excel 2016 however all features will work in Excel 2010, 2013, 2016 and Office 365. Require a computer with excel installed (2016 version or later recommended) and a willingness to learn. No prior knowledge is required as each step is explained in this course Description Why buy individual Excel courses when this whole Microsoft Excel course will give you everything you need! Microsoft Excel all-in-one Package - Become a certified Excel Ninja with #1 Excel course Looking for an online Excel course to improve your skills and save time but don't know where to start? Start mastering Excel, the world's most popular and powerful spreadsheet program and your sought after excel certification can help you impress your employer and advance your career prospects. I have picked out the Excel Essential skills and packaged them in a structured course. I will take you step-by-step through engaging video tutorials and teach you everything from scratch & to be able to use VBA to improve your work flow, save time and automate your current Excel projects. What differentiates this course from other Microsoft Excel Courses? Yes, there are many Microsoft Excel Courses out there teaching you the important Excel functions and features you need to master. BUT, do you get step-step-step learning with Quizzes, Exercises and VBA programming all in one course? This course will get you confident and comfortable designing from simple to complex spreadsheets. You will go beyond Excel basics & advanced section & become a smart user. As you go through the course, you will be able to apply what you learnt immediately to your job. This Complete Excel Course is for two types of people: 1. Excel Beginners i.e. anyone who want to boost the career by learning excel from scratch to VBA Expert! 2. Excel intermediate and advanced users who want to make sure their skills cover all the essentials. This includes many Excel tricks and hidden features few data analysts know of. This course covers all the fundamentals an Excel beginner needs to know as well as bridge the gaps for Excel Intermediate & Advanced users. This is more than just Excel course as it starts off easy and adds VBA programming that many Excel users don't know of. ----------------------------------------------------------------------------------------------------------------------------------------------- ★★★★★ "So far, I have found it particularly useful in my personal life. This is amazing course which impacts the learner positively and makes him able to be a leader who cab bring change. it is very easy to understand. 100% i will be able to apply in my work & personal life. i learned so much from this course, it was a great learning opportunity and i look forward to continuing to put the things i learned into real world practice. Thank you for this excellent course. It was rigorous, robust, and very meaningful ". Dips ★★★★★ "Its really what we say basic to build up. Great course and well explained look forward for more courses from these Teacher for Microsoft Office. Thanks for sharing Your Knowledge ". Fluid|Serspin The course comes with lifetime access. Buy now. Watch anytime. By the end of the course you'll be confident, writing robust & elegant formulas and functions from scratch, allowing you to: Input Data and Navigate Large Spreadsheets Easily build dynamic tools & Excel dashboards to filter, display and analyze your data Apply Excel hacks to get your work done faster Be able to choose right Excel formula to automate your data analysis (Excel IF Function, ROUND and more) Join datasets from multiple sources with Excel's LOOKUP, INDEX & MATCH functions Get Answers from your Data Organize, Clean and Manage Large Data Create Interactive reports with Excel Pivot Tables, Pivot Charts, Slicers and Timelines Import & transform data with tools like Get & Transform (Power Query) Manipulate dates, times, text, and arrays Reduce manual routine tasks to the click of button VBA programming & read, write own Macro to automate the tasks We will dive into a broad range of Excel formulas & functions. Below are some Excel Features & Functions that you will learn: Useful Excel shortcuts for data entry and navigation. Protect your Excel files and worksheets properly. To apply formatting correctly for cleaner and more professional reports. To use important features like drop-down lists and add data validation to the cells. The way you can restrict users to type the data which can be input in each cell. Add Comments & Notes to cells & how to print the same if needed. Add Data & time Stamps to your reports. Lookup/Reference Functions. Statistical Functions. Logic Functions. Text Functions. Date & Time Functions. The most useful & powerful functions such as COUNT, COUNTIFS, SUMIFS, SUMPRODUCT, Nesting IF functions by nesting AND and OR within them and many more. Excel features that will help you to organize and structure data so it makes (Sort, Filter, Search & Replace Go to Special, combine text with & character.) Excel Pivot Tables & Pivot Charts so that you can quickly get insights from your data. What Excel Power Query can do for you and how easy it is to combine data from different spreadsheets Use Power Query to unpivot the data drive another Pivot Table, transform messy data to tabular data. Join Multiple Tables & create long table using Power Query that can be used to feed business intelligence solutions & Pivot Tables. Import data from Text File. Three different ways to run the Macro i.e. from Macro Dialog, Using Keyboard Shortcuts & using buttons. More than just Excel! VBA (Visual Basic for Applications) from Scratch to advanced. So, what are you waiting for? Enroll Today and take the next step in mastering Excel and go from Excel Novice to Excel Ninja! Become a certified Excel Ninja Today. The course comes with lifetime access. Buy now. Watch anytime. Who this course is for: This online course is suitable for anyone who wants to learn Excel. No prior knowledge of Excel is required. This Microsoft Excel Course will take you through 4 levels of Microsoft Excel Topics (Beginner, Intermediate, Advanced and Beyond). Whether you are a working professional, student, teacher, freelancer, or entrepreneur, this training can benefit you and help you take your Excel skills to the next level. Excel is utilized in almost every office