Excel for data analysis

5.00(2 Ratings)

Categories excel, Featured

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!

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:19
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

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.

Advance Excel
In this section we will cover some advance topics like: 1. vlookup 2. data validation 3. pivot tables 4. conditional formating

Student Ratings & Reviews

5.0

Total 2 Ratings

2 Ratings

0 Rating

DIVYA SINGH

4 months ago

As an aspiring data analyst, this course gave me more information about what I am currently doing and after finishing this course I have learned a lot and gave me more interest to learn more.
I could learn the very fundamentals of Excel and apply it to various workbooks as I got along the course. The course covers everything required and has been instructed in basic language, making it easy for a beginner like me to understand. This is definitely the best course to learn about Excel!

2 years ago

Excellent course on excel for beginners and intermediate level users !!

Level

Intermediate
Total Enrolled

22
Last Updated

June 27, 2023
Certificate

Certificate of completion

A course by

Manvirender

Founder at Klaymatrix Data Labs

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.