Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
3 Hour(s) 24 Minute(s)
Language
English
Taught by
Arti Dilip Bendre
Certificate
- Available
- *The delivery and distribution of the certificate are subject to the policies and arrangements of the course provider.
Rating
Course Overview
Using formula, charts, pivot tables , what-if analysis and Solver add-in to understand complex data
This course on "Data Analysis Using Excel" is a beginner level course in Excel that helps in dealing with large amount of data and drawing meaningful conclusions from the data.
The course begins with the use of functions and formulae so that you can transform the raw input into meaningful data. You learn how to visually represent data using different techniques like charts, pivot charts and sparklines. These techniques will let you choose the best method available as per your specific requirement. To slice and dice large data sets and to understand hierarchical relationships between data, you will learn the use of pivot tables. You will learn to give a professional touch to your reports by the use of header and footer. You will learn different tools which aid in decision making - like the goal seek or the scenario manager. You will learn how to let Excel solve complex optimization problems for you using he Solver add-in.
By the end of this course, you will be able to transform raw data into meaningful reports, identify trends, test scenarios, and make informed decisions. Whether you are a student, professional, or business user, this course will help you harness the full potential of Excel for smarter and faster data analysis.
Course Content
- 8 section(s)
- 58 lecture(s)
- Section 1 Introduction
- Section 2 Module1: Using Formulae
- Section 3 Module2: Data Visualization Using Charts
- Section 4 Module 3: Pivot Tables and Pivot Charts
- Section 5 Module 4: Adding Sparklines, Headers and Footers
- Section 6 Module 5: Problem Solving Using Excel
- Section 7 Module 6: Interactive Dashboard using Excel
- Section 8 Recap
What You’ll Learn
- Learn how to create formulae and identify the right formula for a use case. Troubleshoot and debugging of formulae
- Add visualization techniques i.e. charts, pivot charts and sparklines to tables and format the charts
- Analyse the data using pivot tables. Understand the different options available in pivot tables
- Use Excel for forecasting, what-if analysis and optimization technique using the Solver add-in
- Building interactive dashboards using Excel
Skills covered in this course
Reviews
-
BBexxa
I was looking for a solid Excel course, and this one delivered. The instructor is very knowledgeable, and the course is packed with useful content. I feel like I’ve gained real skills that I can use in my work. Highly recommend!
-
CCharlotte
I was looking for a course that would help me improve my Excel skills, and this one did the job perfectly. The content is comprehensive, and the instructor is very engaging. Highly recommend!
-
LLucas
This course is a fantastic introduction to data analysis with Excel. The instructor is very patient, and the lessons are easy to follow. I'm very happy with my purchase!
-
TTashiya
I had no prior experience with Excel, but this course helped me get started with data analysis in no time. The instructor is very encouraging, and the content is exactly what I needed.
