Excel functions to analyze and visualize data

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

Course Description

Welcome to our first ever course Excel functions to analyze and visualize data

We are glad to meet you. If only we could shake hands!


Are you wondering how is this course going to be useful to you?

Hey, did you watch the promo video? If not, please do.

If you are looking to learn Microsoft Excel basics, this course will teach you exactly that.

Look, Microsoft Excel is ubiquitous. It is used in almost every job we do in today's world.

So your job will also possibly require you to do analysis on large heaps of data.

Our course does exactly that - we make you job ready for your prospective project / daily work.


What makes our course different from others?

Our course content is unique - you learn exactly what you are required to do in your daily work.

You get 1.5 hours of crisp synthesized practical real life illustrations of all concepts.

You will be carrying out the real life illustrations along with the instructor.

Same set up as the instructor. All illustration spreadsheets are shared.

It's almost like as if somebody is guiding you in person to carry out the various analysis.

You are going to love our instructor's teaching style.

He makes it very engaging and fun learning experience.

You will have practice assignments / course challenges with varying difficulty levels to test your learning from the course.

Our support team responds to any course queries within 24 hours of your request.

And of course, the price is competitive.


What will you learn in this course?

An overview of Microsoft Excel functions

(Large) Data Analysis techniques and Data visualization in Excel

This one single course will be comprehensive to cover the basic knowledge of Excel required for day to day work

You can watch the FREE course previews in the CURRICULUM section.

Read through the entire CURRICULUM section if you can.

All modules with details of lectures are provided.


What next?

Well, we sincerely hope to see you inside the course.

We wish you well and good luck.

Still confused? Don't hesitate to reach out.

Who this course is for:

  • Anyone who wants to learn Excel completely
  • Business analysts
  • Financial Analysts
  • Consultants
  • Start up founders
  • Project Managers
  • College students

Course content

1 section • 18 lectures • 1h 56m total length
  • Download the excel spreadsheet we will use in the course
    00:01
  • Extraction of data: using VLOOKUP function
    11:40
  • Extraction of data: using the HLOOKUP function
    09:31
  • Extraction of data: using the INDEX and MATCH function
    13:56
  • Extraction of data: using the IF, COUNTIF and COUNTIFS function
    09:09
  • Presentation of data: using the LINE graph
    12:33
  • Presentation of data: using the PIE chart
    11:45
  • Presentation of data: using the COLUMN chart
    13:03
  • Presentation of data: using the STACKED chart
    10:56
  • Presentation of data: using CONDITIONAL FORMATTING in Excel
    06:58
  • Practice Assignment: DIFFICULTY LEVEL - MEDIUM
    00:36
  • SOLUTION TO PRACTICE ASSIGNMENT
    00:04
  • Please review our course - we need your feedback
    00:22
  • Conclusion - contact us
    00:10
  • Please provide us your valuable feedback
    00:44

Instructor

Corporate Finance Expert, Ex McKinsey, Ex BlackRock
  • 4.3 Instructor Rating
  • 8,725 Reviews
  • 48,045 Students
  • 16 Courses

Ashish is a Business and Finance Expert with around 10 years of experience in this domain. He is currently a full-time instructor teaching Business, Finance and Data Analysis courses. Previously, he has worked with BlackRock, the world’s largest asset management company, as a Vice President in the Financial Markets Advisory (FMA) team. Prior to that, he worked with the Strategy and Corporate Finance practice at McKinsey, the world’s most prestigious consulting company. He has advised clients globally on various Strategy and Finance engagements.

Ashish also conducts corporate training in Finance in a leading consulting firm. He is passionate about teaching and strongly believes education should be accessible and affordable to all.


Expected Outcomes

  1. Complete overview of Microsoft Excel interface Data analysis in Excel Data visualization in Excel Requirements None. We will teach everything from scratch. Description Welcome to our first ever course Excel functions to analyze and visualize data We are glad to meet you. If only we could shake hands! Are you wondering how is this course going to be useful to you? Hey, did you watch the promo video? If not, please do. If you are looking to learn Microsoft Excel basics, this course will teach you exactly that. Look, Microsoft Excel is ubiquitous. It is used in almost every job we do in today's world. So your job will also possibly require you to do analysis on large heaps of data. Our course does exactly that - we make you job ready for your prospective project / daily work. What makes our course different from others? Our course content is unique - you learn exactly what you are required to do in your daily work. You get 1.5 hours of crisp synthesized practical real life illustrations of all concepts. You will be carrying out the real life illustrations along with the instructor. Same set up as the instructor. All illustration spreadsheets are shared. It's almost like as if somebody is guiding you in person to carry out the various analysis. You are going to love our instructor's teaching style. He makes it very engaging and fun learning experience. You will have practice assignments / course challenges with varying difficulty levels to test your learning from the course. Our support team responds to any course queries within 24 hours of your request. And of course, the price is competitive. What will you learn in this course? An overview of Microsoft Excel functions (Large) Data Analysis techniques and Data visualization in Excel This one single course will be comprehensive to cover the basic knowledge of Excel required for day to day work You can watch the FREE course previews in the CURRICULUM section. Read through the entire CURRICULUM section if you can. All modules with details of lectures are provided. What next? Well, we sincerely hope to see you inside the course. We wish you well and good luck. Still confused? Don't hesitate to reach out. Who this course is for: Anyone who wants to learn Excel completely Business analysts Financial Analysts Consultants Start up founders Project Managers College students Show more Show less Course content 1 section • 18 lectures • 1h 56m total length Basic excel functions to analyze large data 18 lectures • 1hr 56min Introduction - brief overview on the course Preview 03:44 Download the excel spreadsheet we will use in the course 00:01 The dataset we will analyze in this course Preview 02:55 Extraction of data: Using the SUMIF function Preview 08:14 Extraction of data: using VLOOKUP function 11:40 Extraction of data: using the HLOOKUP function 09:31 Extraction of data: using the INDEX and MATCH function 13:56 Extraction of data: using the IF, COUNTIF and COUNTIFS function 09:09 Presentation of data: using the LINE graph 12:33 Presentation of data: using the PIE chart 11:45 Presentation of data: using the COLUMN chart 13:03 Presentation of data: using the STACKED chart 10:56 Presentation of data: using CONDITIONAL FORMATTING in Excel 06:58 Practice Assignment: DIFFICULTY LEVEL - MEDIUM 00:36 SOLUTION TO PRACTICE ASSIGNMENT 00:04 Please review our course - we need your feedback 00:22 Conclusion - contact us 00:10 Please provide us your valuable feedback 00:44 Instructor Ashish Agarwal Corporate Finance Expert, Ex McKinsey, Ex BlackRock 4.3 Instructor Rating 8,725 Reviews 48,045 Students 16 Courses Ashish is a Business and Finance Expert with around 10 years of experience in this domain. He is currently a full-time instructor teaching Business, Finance and Data Analysis courses. Previously, he has worked with BlackRock, the world’s largest asset management company, as a Vice President in the Financial Markets Advisory (FMA) team. Prior to that, he worked with the Strategy and Corporate Finance practice at McKinsey, the world’s most prestigious consulting company. He has advised clients globally on various Strategy and Finance engagements. Ashish also conducts corporate training in Finance in a leading consulting firm. He is passionate about teaching and strongly believes education should be accessible and affordable to all. 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:'678169230f75f41f',m:'9fe537af2b0b80e9193abce5f7096f481f7b2539-1627845490-1800-AbTBcuDFazshWW0sFLnIo3HAamA7J+sCwdj0P40LNM67hbrvekZvStQiCiYh6FnNQ0+q8iCj/PHOy7WG4bL4k9fTDEU1WUkYDu6xg2tWft3LSBQN7Jc4TTD0lytdy3Fn52vxtQK++kELnyYW6h9qgY3f8ckK28jACHucWsK3DhyudiYkk8nuBd62bng+w1tmAg==',s:[0x5e75b5adb6,0x5a2d6076d1],}})();
  2. Data analysis in Excel Data visualization in Excel Requirements None. We will teach everything from scratch. Description Welcome to our first ever course Excel functions to analyze and visualize data We are glad to meet you. If only we could shake hands! Are you wondering how is this course going to be useful to you? Hey, did you watch the promo video? If not, please do. If you are looking to learn Microsoft Excel basics, this course will teach you exactly that. Look, Microsoft Excel is ubiquitous. It is used in almost every job we do in today's world. So your job will also possibly require you to do analysis on large heaps of data. Our course does exactly that - we make you job ready for your prospective project / daily work. What makes our course different from others? Our course content is unique - you learn exactly what you are required to do in your daily work. You get 1.5 hours of crisp synthesized practical real life illustrations of all concepts. You will be carrying out the real life illustrations along with the instructor. Same set up as the instructor. All illustration spreadsheets are shared. It's almost like as if somebody is guiding you in person to carry out the various analysis. You are going to love our instructor's teaching style. He makes it very engaging and fun learning experience. You will have practice assignments / course challenges with varying difficulty levels to test your learning from the course. Our support team responds to any course queries within 24 hours of your request. And of course, the price is competitive. What will you learn in this course? An overview of Microsoft Excel functions (Large) Data Analysis techniques and Data visualization in Excel This one single course will be comprehensive to cover the basic knowledge of Excel required for day to day work You can watch the FREE course previews in the CURRICULUM section. Read through the entire CURRICULUM section if you can. All modules with details of lectures are provided. What next? Well, we sincerely hope to see you inside the course. We wish you well and good luck. Still confused? Don't hesitate to reach out. Who this course is for: Anyone who wants to learn Excel completely Business analysts Financial Analysts Consultants Start up founders Project Managers College students Show more Show less Course content 1 section • 18 lectures • 1h 56m total length Basic excel functions to analyze large data 18 lectures • 1hr 56min Introduction - brief overview on the course Preview 03:44 Download the excel spreadsheet we will use in the course 00:01 The dataset we will analyze in this course Preview 02:55 Extraction of data: Using the SUMIF function Preview 08:14 Extraction of data: using VLOOKUP function 11:40 Extraction of data: using the HLOOKUP function 09:31 Extraction of data: using the INDEX and MATCH function 13:56 Extraction of data: using the IF, COUNTIF and COUNTIFS function 09:09 Presentation of data: using the LINE graph 12:33 Presentation of data: using the PIE chart 11:45 Presentation of data: using the COLUMN chart 13:03 Presentation of data: using the STACKED chart 10:56 Presentation of data: using CONDITIONAL FORMATTING in Excel 06:58 Practice Assignment: DIFFICULTY LEVEL - MEDIUM 00:36 SOLUTION TO PRACTICE ASSIGNMENT 00:04 Please review our course - we need your feedback 00:22 Conclusion - contact us 00:10 Please provide us your valuable feedback 00:44 Instructor Ashish Agarwal Corporate Finance Expert, Ex McKinsey, Ex BlackRock 4.3 Instructor Rating 8,725 Reviews 48,045 Students 16 Courses Ashish is a Business and Finance Expert with around 10 years of experience in this domain. He is currently a full-time instructor teaching Business, Finance and Data Analysis courses. Previously, he has worked with BlackRock, the world’s largest asset management company, as a Vice President in the Financial Markets Advisory (FMA) team. Prior to that, he worked with the Strategy and Corporate Finance practice at McKinsey, the world’s most prestigious consulting company. He has advised clients globally on various Strategy and Finance engagements. Ashish also conducts corporate training in Finance in a leading consulting firm. He is passionate about teaching and strongly believes education should be accessible and affordable to all. 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:'678169230f75f41f',m:'9fe537af2b0b80e9193abce5f7096f481f7b2539-1627845490-1800-AbTBcuDFazshWW0sFLnIo3HAamA7J+sCwdj0P40LNM67hbrvekZvStQiCiYh6FnNQ0+q8iCj/PHOy7WG4bL4k9fTDEU1WUkYDu6xg2tWft3LSBQN7Jc4TTD0lytdy3Fn52vxtQK++kELnyYW6h9qgY3f8ckK28jACHucWsK3DhyudiYkk8nuBd62bng+w1tmAg==',s:[0x5e75b5adb6,0x5a2d6076d1],}})();
  3. Data visualization in Excel Requirements None. We will teach everything from scratch. Description Welcome to our first ever course Excel functions to analyze and visualize data We are glad to meet you. If only we could shake hands! Are you wondering how is this course going to be useful to you? Hey, did you watch the promo video? If not, please do. If you are looking to learn Microsoft Excel basics, this course will teach you exactly that. Look, Microsoft Excel is ubiquitous. It is used in almost every job we do in today's world. So your job will also possibly require you to do analysis on large heaps of data. Our course does exactly that - we make you job ready for your prospective project / daily work. What makes our course different from others? Our course content is unique - you learn exactly what you are required to do in your daily work. You get 1.5 hours of crisp synthesized practical real life illustrations of all concepts. You will be carrying out the real life illustrations along with the instructor. Same set up as the instructor. All illustration spreadsheets are shared. It's almost like as if somebody is guiding you in person to carry out the various analysis. You are going to love our instructor's teaching style. He makes it very engaging and fun learning experience. You will have practice assignments / course challenges with varying difficulty levels to test your learning from the course. Our support team responds to any course queries within 24 hours of your request. And of course, the price is competitive. What will you learn in this course? An overview of Microsoft Excel functions (Large) Data Analysis techniques and Data visualization in Excel This one single course will be comprehensive to cover the basic knowledge of Excel required for day to day work You can watch the FREE course previews in the CURRICULUM section. Read through the entire CURRICULUM section if you can. All modules with details of lectures are provided. What next? Well, we sincerely hope to see you inside the course. We wish you well and good luck. Still confused? Don't hesitate to reach out. Who this course is for: Anyone who wants to learn Excel completely Business analysts Financial Analysts Consultants Start up founders Project Managers College students Show more Show less Course content 1 section • 18 lectures • 1h 56m total length Basic excel functions to analyze large data 18 lectures • 1hr 56min Introduction - brief overview on the course Preview 03:44 Download the excel spreadsheet we will use in the course 00:01 The dataset we will analyze in this course Preview 02:55 Extraction of data: Using the SUMIF function Preview 08:14 Extraction of data: using VLOOKUP function 11:40 Extraction of data: using the HLOOKUP function 09:31 Extraction of data: using the INDEX and MATCH function 13:56 Extraction of data: using the IF, COUNTIF and COUNTIFS function 09:09 Presentation of data: using the LINE graph 12:33 Presentation of data: using the PIE chart 11:45 Presentation of data: using the COLUMN chart 13:03 Presentation of data: using the STACKED chart 10:56 Presentation of data: using CONDITIONAL FORMATTING in Excel 06:58 Practice Assignment: DIFFICULTY LEVEL - MEDIUM 00:36 SOLUTION TO PRACTICE ASSIGNMENT 00:04 Please review our course - we need your feedback 00:22 Conclusion - contact us 00:10 Please provide us your valuable feedback 00:44 Instructor Ashish Agarwal Corporate Finance Expert, Ex McKinsey, Ex BlackRock 4.3 Instructor Rating 8,725 Reviews 48,045 Students 16 Courses Ashish is a Business and Finance Expert with around 10 years of experience in this domain. He is currently a full-time instructor teaching Business, Finance and Data Analysis courses. Previously, he has worked with BlackRock, the world’s largest asset management company, as a Vice President in the Financial Markets Advisory (FMA) team. Prior to that, he worked with the Strategy and Corporate Finance practice at McKinsey, the world’s most prestigious consulting company. He has advised clients globally on various Strategy and Finance engagements. Ashish also conducts corporate training in Finance in a leading consulting firm. He is passionate about teaching and strongly believes education should be accessible and affordable to all. 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:'678169230f75f41f',m:'9fe537af2b0b80e9193abce5f7096f481f7b2539-1627845490-1800-AbTBcuDFazshWW0sFLnIo3HAamA7J+sCwdj0P40LNM67hbrvekZvStQiCiYh6FnNQ0+q8iCj/PHOy7WG4bL4k9fTDEU1WUkYDu6xg2tWft3LSBQN7Jc4TTD0lytdy3Fn52vxtQK++kELnyYW6h9qgY3f8ckK28jACHucWsK3DhyudiYkk8nuBd62bng+w1tmAg==',s:[0x5e75b5adb6,0x5a2d6076d1],}})();