Shopping Cart

No products in the cart.

Klaymatrix Data Labs
Klaymatrix Data Labs
5.00
(1 Rating)

Excel for data analysis

Wishlist Share
Share Course
Page Link
Share On Social Media

Course Prerequisite(s)

What Will You Learn?

  • Learn how excel works
  • Key concepts like cell referencing that form the backbone of 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 Content

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 1 Rating
5
1 Rating
4
0 Rating
3
0 Rating
2
0 Rating
1
0 Rating
3 years ago
Excellent course on excel for beginners and intermediate level users !!

Want to receive push notifications for all major on-site activities?

✕