Certificate in Data Analytics using Excel

How It Works

  1. 1. Select Certification & Register
  2. 2. Receive Online e-Learning Access (LMS)
  3. 3. Take exam online anywhere, anytime
  4. 4. Get certified & Increase Employability

Test Details

  • Duration: 60 minutes
  • No. of questions: 50
  • Maximum marks: 50, Passing marks: 25 (50%).
  • There is NO negative marking in this module.
  • Online exam.

Benefits of Certification


$49.00 /-

Why should I take this certification?

Earning Vskills Data Analytics Using Excel certification is a great way to boost your employability and enhance your analytical skills. This certification equips you with essential data manipulation, analysis, and visualization techniques using Excel, a widely-used tool across industries. It’s ideal for professionals who want to make data-driven decisions and stand out in today’s data-centric job market.

How will I benefit from this certification?

This certification will help you gain the necessary knowledge to start a career in the field of data analytics. It is a beginner-to-intermediate certification in data analytics that lays the foundation for a strong career in this field.

Note: The course having online videos, not hard copy material.


Data Analytics using Excel Table of Contents

https://www.vskills.in/certification/data-analytics-using-excel-table-of-contents

Companies that hire Data Analytics Professionals

Vskills Certified Candidate will find employment in Top MNC's like Tech Mahindra, Dell, Mphasis, Cognizant, HCL, Accenture, TCS.

Jobs in Data Analytics

Checkout the various job openings for Data Analytics Professionals, click here..

Vskills Internship in Data Analytics

Vskills runs its flagship internship program where bright interns work with academic council, click to know more details..

Apply for Data Analytics using Excel Certification

By Net banking / Credit Card/Debit Card

We accept Visa/Master/Amex cards and all Indian Banks Debit Cards. There is no need to fill application form in case you are paying online.

Please click buy now to proceed for online payments.

​Visa Card Master Card American Express

 

Buy Now
TABLE OF CONTENT

1. Course Introduction

  • Introduction to the Course
  • Navigating Excel
  • Data Types in Excel

2. Using Excel Spreadsheets for Data Analysis

  • Viewing and Entering Data
  • Formatting and Data Types in Excel
  • Excel Formula Basics
  • Exploring Excel Functions
  • Referencing Data in Formulas
  • Exercise 1

3. Cleaning and Managing Data

  • Introduction to Data Quality
  • Importing File Data
  • Removing Duplicate Data
  • Identifying Data Attributes
  • Cleaning Data
  • Exercise 2

4. Analyzing Data

  • Sort and Filter Data
  • Concatenation and SUMIF
  • Tackling Complicated "OR" Criteria
  • Summarizing Data Using Pivot Tables
  • Creating a Pivot Chart
  • Working with Excel Charts
  • Analyzing Financial Data
  • Waterfall Charts
  • Conditional Formatting
  • Using Database Functions
  • Evading Formula Errors
  • Exercise 3

5. What-If Analysis and Analysis ToolPak

  • Scenario Manager in What-If Analysis
  • Data Tables in What-If Analysis
  • Goal Seek in What-If Analysis
  • Loading the Analysis ToolPak
  • Correlation and Covariance in Analysis ToolPak
  • Descriptive Statistics, Moving Average, and Exponential Smoothing
  • Additional Analytical and Statistical Applications
  • Exercise 4
  • Closing

Write a review

Please login or register to review

 For Support