- 3.1 - Understanding Primary Keys
- 3.2 - Preparing the worksheet
- Quiz 3
- 4.1 - Customer Table - Introduction
- 4.2 - Customer Table - Vlookup function
- 4.3 - Product Table
- 4.4 - Other Tables
- 4.5 - Returns Table - IFERROR function
- 4.6 - Returns Table - Switch parameter
- 4.7 - Conclusion
- Quiz 4
- 5.1 - Recap & Exploratory analysis
- 5.2 - Preparation for Exploratory analysis
- 6.1 - Pivot Table
- 6.2 - Profit computation
- 7.1 - Hypothesis 2 Overall profitability
- 8.1 - Hypothesis 3 Book cases
- 9.1 - Sales growth computation
- Quiz 5
- 10.1 - Overview - High Level Explorations
- 10.2 - Product Wise Exploration
- 10.3 - Customer type wise exploration
- 11.1 - Overview - Deep Dive Analysis
- 11.2 - Product wise deep dive
- 11.3 - Customer type wise - exercise
- 11.4 - Customer type wise - solution
- 11.5 - Corp Customers - exercise
- 11.6 - Corp Customers - solution
- 11.7 - Corp Customers - Tech - exercise
- 11.8 - Corp Customers - Tech - solution
- 11.9 - Corp Customers - office supplies - exercise
- 11.10 - Corp Customers - office supplies - solution
- Quiz 6
- 12.1 - Project
- 12.2 - Project charts
- 12.3 - Thank you
About this Course
In this course you will understand the importance of Data and how it is used in businesses. The course begins with the concepts data collection and data acquisition. The course then goes on to the exploratory analysis and high level explorations. Throughout the course you will find examples and cases based on Microsoft excel.
Clear your Doubts
Project/Practicals in this Course
Can I download the videos & learn?
You can re-watch the videos as many times you wish but we do not allow downloading on our platform as we keep track of your progress in regards to the course you learn.
What is special about Twenty19 courses?
Twenty19 Courses are fun to learn and they are structured to be easily understood by anyone.The courses are developed with College students in mind.So courses will have a lot of real world examples and Twenty19 courses are easy to take up and earn a certificate.
If I have any doubt while learning, How can I clear my doubts?
You can raise your doubt in Clear your doubts forum anytime, course experts will answer all your questions. You can also reach us at +91 9962033243 (give us a missed call), send an SMS or drop an email to firstname.lastname@example.org, one of our team member will call you to support.
Is it safe to use my debit/credit card for making the payment?
No doubt, Your transaction is always safe and secure with Twenty19.
Do I get a certificate of completion?
Yes!! you will receive an E-certificate from us once you complete the course. You can include this is in your Resume to get placed better.
How will I receive the certificate?
Twenty19 certificates will be emailed to your Twenty19 registered Email ID .The very next day of your course completion you will be receiving the certificate.You can download and print your certificate.