Search
Close this search box.

Excel For Data Analysis

by

Learnvern

This Excel For Data Analysis course on LearnVern is completely free. It will provide a comprehensive understanding of the topic and its practical applications.
Free Course
Enroll Now
Share

#1

See all ranking

Excel For Data Analysis

by

Learnvern

This Excel For Data Analysis course on LearnVern is completely free. It will provide a comprehensive understanding of the topic and its practical applications.
Free Course
Enroll Now
Share

#1

See all ranking

3 Modules

with Certifications

2+ Hours

of Recorded Content

3.8 Rated

by 10000 Learners

Hindi

Language

3 Modules

with Certifications

2 + Hours

of Recorded Content

3.8 Rated

by 10000 Learners

Hindi

Language

About

Key Features

Content

FAQs

What's in it for You?

Key Features:

Available in multiples Languages
100% Self Paced Course
Lifetime access to all content
Downloadable Resources

Topics you will learn

  • Introduction

    • Introduction to Data Analysis With Excel
    • How to use LearnVern
    • What is data analysis and where to use it

  • Excel with Formulas

    • How to use Percentage Variance and Round functions in Excel
    • How to use count and different types of count functions?
    • How to perform calculations on string data using excel spread sheet functions?
    • How to calculate age and words count using excel spread sheet functions?
    • How to perform calculations using Date and Time functions
    • How To Perform Calculations On Time and Completion of Year Percentage Using Excel Spread Sheet Formulas
    • How To Find The Last Day And Nth Weekday Of The Month Using Date Functions
    • How To Perform Conditions Using Date And Time Functions
    • How To Perform Calculations Using Logical Operators On Given Data With Excel Spread Sheet Functions
    • How To Perform Calculations On Data Using Excel Spread Sheet Functions And Conditions
    • Excel With Formulas Quiz

  • Conditional Statements and Logical Operators

    • What Is Conditional Statements And How To Perform Calculations Using Logical Operators
    • How To Perform Calculations On Different Data Types With Multiple Conditions Using Logical And Operator
    • How To Use Multiple AND and OR Logical Operator With Conditions In Excel Spread Sheet
    • How To Perform Calculations Using One Logical OR and Multiple AND Operators with Ifelce Conditions
    • How To Perform Calculations And Check Output In Different Way Using Logical OR and NOT Operator
    • How And Where To Perform Calculations Using Logical XOR Operators With IFELSE conditions
    • Assignment On Conditional Statements and Logical Operators Assignment
    • Conditional Statement and Logical Operators Quiz

  • Common Excel Spread Sheet Statistical Functions

    • What Is Statistics And Statistical Function
    • What Is Intermediate Statistical Functions
    • What Is Difference Between Absolute And Relative Cell Reference
    • What And How To Use Index Function
    • What And How To Use Match Function
    • How To Use MMM Formula In Excel Spread Sheet
    • How To Use Percentiles In Excel Spread Sheet With Example
    • How To Use Quartile Using Match Function
    • What Is Outliers And Statistical Outliers
    • How To Use Leveraged Interquartile Range IQR
    • How To De Seasonalize Data Before Forecasting Using Excel Spread Sheet
    • Common Excel Spread Sheet Statistical Functions Quiz

  • Lookup Reference Text Date and Time Functions

    • What Is Lookup And Types Of Lookup Function
    • Different Types Of Examples Using Lookup Function
    • How To Perform Case Sensitive Lookup Using Index And Exact Function
    • How To Perform Aggregations On Data Using Lookup Function
    • What Is Reference And Types Of Reference Functions
    • What Is Reference Offset Function
    • How To Use Rows And Columns Reference Function
    • What And Where To Use Text Function
    • How To Use Vlookup, Len, Concatenate and Averageifs Function Using Excel Spread Sheet
    • How To Use Find IfError, Countifs and Sum Product Function Using Excel Spread Sheet
    • How To Use Date And Time Functions In Excel Spread Sheet
    • How To Use Day Days360 Edate And Date Value Function In Excel Spread Sheet
    • How To Use Eo Month ISOWeekNum Network Days Intl And Month Function In Excel Spread Sheet
    • How To Use Weekday WeekNum Workday.Intl And Year Frac Function Using Excel Spread Sheet
    • Assignment On Date and Time
    • Assignment On LookUp
    • Assignment On Reference
    • Lookup Reference ,Text Date and Time Functions Quiz

  • Formula Based Conditional Formatting

    • What And How To Use Conditional Formatting
    • Examples Using Conditional Formatting
    • Examples That Highlight Dates And Statistical Outliers Using Conditional Formatting
    • Assignment On Formula Based Conditional Formatting
    • Formula based Conditional Formatting Quiz

  • Data Visualization and Financial Formulas

    • What Is Data Visualization And How To Use
    • What Is The Importance Of Data Visualization
    • What Are The Common Data Types While Analysing Data
    • How To Use Different Charts For Data Analysis Presentation And Reporting
    • When To Use Histogram And Bullet Chart
    • When To Use Actual vs Target And Funnel Chart
    • How To Calculate Gross Profit Margin And Gross Profit Margin Percent
    • How To Calculate COGS EBIT And EBITDA
    • How To Calculate Customer Churn Return On Equity And Avg. Customer Lifetime Value In Excel Spread Sheet
    • How To Calculate Employee Turnover And Interest Rates
    • How To Calculate Effective Rate With FV
    • How To Create Loan Payment Calculator In Excel Spread Sheet
    • How To Create Mortgage Amortization Schedule And Dates Instead Of Payment Numbers
    • How To Calculate Depreciation Accelerated Depreciation And Present Value
    • How To Calculate Present Value Of Future Payments And Net Present Value
    • How To Calculate IRR Positive And Negative And Non-Periodic Cash Flows
    • When To Use Each Chart Or Graph Type In Excel Spread Sheet
    • How To Use Data Visualizations Examples On Extraction Of Data
    • Assignment On Data Visualization
    • Data Visualization And Financial Formulas Quiz

  • Excel Chart Formatting and Customization

    • How To Format And Customize Chart In Excel Spread Sheet
    • How To Customize Axes In Excel Spread Sheet Charts
    • How To Add Labels Hiding And Editing Data In Excel Spread Sheet Charts
    • When To Use Each Chart Or Graph Type In Excel Spread Sheet
    • How To Use Scatter Area Stock Radar And Waterfall Chart In Excel Spread Sheet
    • Assignment On Excel Chart Formatting and Customization

  • Mastering Advance Excel Charts and Graphs

    • What Is Mastering Advance Excel Spread Sheet Chart And Graph
    • How To Create a DOT PLOT Chart In Excel Spread Sheet
    • How To Create a DUMBELL And PANEL Chart In Excel Spread Sheet
    • Assignment On Mastering Advance Excel Charts and Graphs

  • Formatting Data with Pivot Tables

    • What When And How To Use Pivot Table
    • How To Group Pivot Table Items And Get Data In Right Format With Pivot Tables
    • How To Use Frequency Distribution And Slicers To Filter Pivot Tables Data
    • How To Update Pivot Table And Perform Calculations In Excel Spread Sheet
    • Assignment On Formatting Data with Pivot Tables
    • Formatting Data With Pivot Tables Quiz

  • Sorting Filtering and Grouping Data with Pivot Tables

    • How To Perform Sorting Filtering And Grouping Data With Pivot Tables Using Excel Spread Sheet
    • Assignment On Sorting, Filtering and Grouping with Pivot Tables

  • Enriching Data with Pivot Table Calculated Values and Fields

    • What Is Calculated Field And How To Use Them
    • Steps To Add Calculated Field In Pivot Table With Excel Spread Sheet
    • How To See Or List All Calculated Fields In Excel Spread Sheet
    • How To Delete Or Hide Calculated Fields
    • Assignment On Enriching Data With Pivot Table

  • Visualizing Data with Excel Spread Sheet Pivot Charts

    • How To Visualize Data With Pivot Charts
    • Why And How To Use Forecasting Linear Regression In Excel Spread Sheet
    • How To Implement Linear Regression
    • What Is Logistic Regression And Difference Between Linear And Logistic Regression
    • Visualizing Data with Excel Spread Sheet Pivot Charts Quiz

  • Linear and Logistic Regression

    • How To Implement Linear Regression Analysis In Excel Spread Sheet
    • How To Implement Logistic Regression Analysis In Excel Spread Sheet
    • Linear and Logistic Regression Quiz

Course Offerings

Certificate you will get

Certificate Features

NSDC Certificate of Partnership with LearnVern.
Help build strong resume.
Great add-on to get Internship.
Upgrade your Job with this certificate proof.

After this Course

Pre Requsites

Curious Mind to learn new concepts
Strong internet connection

Course is for

Freshers

Professionals

Students

FAQ's

The course focuses on Excel For Data Analysis. It covers fundamentals through 3 interactive modules.
The course offers over 2 hours of recorded content.

Yes, there is a Paid Certification included with this course. The course material is entirely free; however, certification in this course requires payment of ₹999.

The course is currently available in Hindi.
Curious Mind to learn new concepts & Strong internet connection

The course is accessible on both web and mobile platforms.

This course is completely Free
To enroll in this course you can click on the Enroll Now button it will redirect you to course page, and on that page you can access the Excel For Data Analysis course completely free.

Similar Courses

Learnvern

English Grammar And Punctuation

2 Hours
4.6
10000
View Course
Learnvern

Stock Market And Stock Trading in Tamil

2 Hours
4.3
10000
View Course
Learnvern

Google Sheets Course

2 Hours
4.7
10000
View Course
Learnvern

Recruiter Training Course in English

2 Hours
4.8
10000
View Course
Learnvern

Selling on ECommerce – Amazon, Shopify in Tamil

2 Hours
10000
View Course
Learnvern

Stock Market And Stock Trading in Telugu

2 Hours
4
10000
View Course
Learnvern

Import And Export – The Complete Business Guide

2 Hours
4.8
10000
View Course

Course Vendors

Categories

Quick Links

Follow us on !

Instagram Linkedin
Made with 💝 in India
© Copyright 
2024
, OJSANT Technologies Pvt. Ltd.

Share this course within your network

WhatsApp
Facebook
Telegram
LinkedIn
Threads
X

Page Link