5.00(1 Ratings)
Excel for data analysis

About Course
Are you new to Excel or at times get stuck working on it ? Then this course will help you get all the fundamentals of excel, spreadsheets, data analysis and other useful concepts. By the end of the course you would be able to work with data through you excel in a smart way, including working with data using various excel tools and techniques. Learning excel would definitely add to your datascience skills, giving you that extra visibility for the hiring managers if you are a job seeker and also enhance your team visibility if you are a working professional. A must have skill in any professional field, whether you are doing hard core data analysis or just doing your routine work, a sound excel knowledge is a skill that sets you apart from the crowd.
What I will learn?
- Learn how excel works
- Key concepts like cell referencing that form the backbone spreadsheets
- Using key functions like vlookup to get you going with any kind of spreadsheet
- Develop understanding about analyzing data with excel using concepts like pivot tables
Course Curriculum
Basics of excel
In this section, we will cover briefly about excel, shortcuts, data types and other interesting aspects of excel
-
Dataset for download
00:00 -
Introduction to Excel
01:55 -
Create your excel environment
03:20 -
Data types
03:31 -
Excel Short Cuts
08:18 -
Quiz-Basics of Excel
Cell referencing, Error Handling and Filters
In this section we will talk about:
1. Cell referencing, the backbone of excel spreadsheet
2. Error handling
3. Filters
-
Cell referencing
05:37 -
Cell Referencing (Part 2)
11:31 -
Quiz – Cell Referencing
-
Error Handling
04:44 -
Filters
05:05 -
Quiz- Error Handling and Filters
Working with text
Text or Strings form a major component of data analysis. This section will talk about how to work with text data. The section has been divided into 3 separate sub sections for ease of learning.
-
Handling strings- Part 1
05:07 -
Handling strings- Part 2
03:16 -
Handling strings- Part 3
03:35
Advance Excel
In this section we will cover some advance topics like:
1. vlookup
2. data validation
3. pivot tables
4. conditional formating
-
Vlookup
07:10 -
Data Validation
05:54 -
Quiz-vlookup and data validation
-
Pivot Tables
08:15 -
Conditional formatting
04:40 -
Quiz-Pivot Table and Conditional Formatting
Course Completion (Required for certification)
This section is for capturing your feedback so that we can further improve our courses. Please fill this quick survey to officially finish your course.
-
Thanks for taking this course
00:00
₹1,999
-
LevelIntermediate
-
Total Enrolled20
-
Last UpdatedFebruary 4, 2023
-
CertificateCertificate of completion
Hi, Welcome back!
A course by

Manvirender
Founder at Klaymatrix Data Labs
Material Includes
- Topic wise instructional videos
- Quizzes to check progress
- Downloadable exercise sheets
- One-year free access
- Verified certification on successful completion
Requirements
- Microsoft Excel 2016 or above is recommended
- Internet connection
Tags
Target Audience
- This course is meant for anybody looking to learn excel and make inroads into datascience
- No programming or technical experience required
Get Certified
One successful completion of the course you can easily download your certificate with authentic ID and same would also be available under your profile page.
