Excel for data analysis
- Offered byLearnVern
Excel for data analysis at LearnVern Overview
Duration | 35 hours |
Total fee | Free |
Mode of learning | Online |
Official Website | Explore Free Course |
Credential | Certificate |
Excel for data analysis at LearnVern Highlights
- Earn a certificate after completion of the course
- Life Time Access
Excel for data analysis at LearnVern Course details
- 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