Excel Case Studies: Sales Analysis with Pivot Tables, Charts

Online Course

Udemy
Go to Udemy
Start Learning
Excel Case Studies: Sales Analysis with Pivot Tables, Charts
  1. What is the course about?
  2. Prerequisites & Facts
  3. Cost, Certificate & Degree
  4. Reviews & Experiences

What is the course about?

Excel Case Studies: Sales Analysis with Pivot Tables, Charts
The course Excel Case Studies: Sales Analysis with Pivot Tables, Charts is an online class provided by Udemy. It may be possible to receive a verified certification or use the course to prepare for a degree.

Learn by doing! Save time! Real case studies in sales analysis to learn functions IF, VLOOKUP, pivot tables and charts.

Course description
  • Excel Case Studies: Sales Analysis with Pivot Tables, Charts
  • Starting with a large set of unformatted data, summarize and analyze the data with Excel to find the important “nuggets” of information, and explain the results with clarity.
  • Specifically, prepare a sales and margin report for business, starting with basic invoice information, summarizing results by product line and by region.
  • Make complex pivot tables and display the results visually, with charts and conditional formatting to make a customer scorecard.
  • Use the Excel functions =if, =vlookup, =countif, =sumif, and make nested if statements.
  • Make an Excel data model to connect several Excel tables.
  • Basic familiarity with Excel is assumed. Students should be able to enter data and formulas. The examples are very easy to follow.
  • You’ll need a copy of Excel that you can use, preferably Excel 2013 or Excel 2016 for Windows. Excel 2010 will work as well.
  • 3 hours on-demand video
  • 89 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
  • Jeff Knowlton
Start Learning

Prerequisites & Facts

Excel Case Studies: Sales Analysis with Pivot Tables, Charts

Course Topic

Development, ECMAscript, Web Development

University, College, Institution

Udemy

Course Skill Level

see course summary

Course Language

English

Place of class

Online, self-paced (see curriculum for more information)

Degree

Certificate

Start Learning

Degree & Cost

Excel Case Studies: Sales Analysis with Pivot Tables, Charts

To obtain a verified certificate from Udemy you have to finish this course or the latest version of it, if there is a new edition. The class may be free of charge, but there could be some cost to receive a verified certificate or to access the learning materials. The specifics of the course may have been changed, please consult the provider to get the latest quotes and news.
Udemy
Excel Case Studies: Sales Analysis with Pivot Tables, Charts
provided by Udemy
Start Learning

Reviews

[display-frm-data id=”8278″ filter=”1″]

Please select a valid form
Here you can find information, reviews and user experiences for the course “Excel Case Studies: Sales Analysis with Pivot Tables, Charts“. The provider of the course – “Udemy” – will be glad to answer any questions you may have about the class, click here to use the offical support channels. It would be great if you could share your experience of participating in the course – Your honest review will surely help others to choose the right class!
School: Udemy
Topic: Excel, Microsoft, Office Productivity

More classes & courses

Start E-Learning
Popular courses with huge future potential
Schools & Universities
Learn with some of the best schools of the world
More online courses
Continue being curious & the world is yours
Contact us | Privacy Policy
© 2024 All Rights Reserved