LearnVern
LearnVern Logo

Excel for data analysis 

  • Offered byLearnVern

Excel for data analysis
 at 
LearnVern 
Overview

A comprehensive overview of Excel for data analysis

Duration

35 hours

Total fee

Free

Mode of learning

Online

Official Website

Explore Free Course External Link Icon

Credential

Certificate

Excel for data analysis
 at 
LearnVern 
Highlights

  • Earn a certificate after completion of the course
  • Life Time Access
Details Icon

Excel for data analysis
 at 
LearnVern 
Course details

Skills you will learn
More about this course
  • This course will enable you to start your career in the field of Data Analytics
  • As each company has started storing data of its Customers, Preferences, User and a lot more this store data needs to be analyzed and monitored
  • This Data Analytics course will help you learn how to manage and report on this data
  • This course is a step by step approach of how to use excel and its advance features to build a successful career in Data Analytics

Excel for data analysis
 at 
LearnVern 
Curriculum

Introduction

Introduction to Data Analysis With Excel

How to use Learn Vern

Excel with Formulas

How to use Percentage Variance and Round functions in Excel

How to use count and different types of count functions

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

Common Excel Spread sheet Statistical Functions

What Is Statistics And Statistical Function

What Is Intermediate Statistical Functions

Lookup Reference Text Date and Time Functions

What Is Lookup And Types Of Lookup Function

Different Types Of Examples Using Lookup Function

Other courses offered by LearnVern

– / –
13 hours
– / –
Free
– / –
– / –
View Other 1 CoursesRight Arrow Icon
qna

Excel for data analysis
 at 
LearnVern 

Student Forum

chatAnything you would want to ask experts?
Write here...