5.00(1 Ratings)
Excel for data analysis

About Course
Discover the joy of learning Excel with our user-friendly online course. Designed for all types of learners, our Excel course provides step-by-step guidance on mastering spreadsheets, formulas, and data manipulation. Gain practical skills and unlock endless possibilities for personal and professional growth. Enroll now and excel in Excel effortlessly!
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:04 -
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:41 -
Quiz-Pivot Table and Conditional Formatting
₹1,999
-
LevelIntermediate
-
Total Enrolled21
-
Last UpdatedJune 27, 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.
