5.00
(1 Rating)

Excel for data analysis

By Manvirender Categories: excel, Featured
Wishlist Share
Share Course
Page Link
Share On Social Media

What Will You 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 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

Earn a certificate

Add this certificate to your resume to demonstrate your skills & increase your chances of getting noticed.

selected template

Student Ratings & Reviews

5.0
Total 1 Rating
5
1 Rating
4
0 Rating
3
0 Rating
2
0 Rating
1
0 Rating
2 years ago
Excellent course on excel for beginners and intermediate level users !!

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