Data Analytics Using Excel

150 hrs

Digital Vidya’s Data Analytics Course is prudently embedded with Advanced Excel training. The course directs to refine the efforts of professionals in Sales, Marketing, Customer Satisfaction, Operations, Supply-Chain, Logistics, Finance, and Trading. The advanced excel course coupled with an introduction to data science and visualization helps a fresher or an analytics aspirant to get started in the Data Science & Analytics industry. In a recent report on European Data Science Salary, Excel was positioned as the most used tool by analysts. 70% of Data Science & Analytics professionals use Advanced Excel techniques. Our Data Analytics Course Using Excel builds a learner’s knowledge to perform the most complex calculations and process huge amount of data in a short span of time.

Dv logo png

Exploratoire

Ia

Astrolab



Programme

Big Data Foundation

Data Analytics Using Excel

PROGRAMME

Installation: SQL Installation

    Installation: SQL Installation

Week 1: Introduction To Analytics Techniques & Fundamentals of Excel

    Video 1 | Introduction To Analytics Techniques & Fundamentals of Excel

    Video 2 | Introduction To Analytics Techniques & Fundamentals of Excel

    Video 3 | Introduction To Analytics Techniques & Fundamentals of Excel

    Video 4 | Introduction To Analytics Techniques & Fundamentals of Excel

    Video 5 | Introduction To Analytics Techniques & Fundamentals of Excel

    Video 6 | Introduction To Analytics Techniques & Fundamentals of Excel

    Quiz | Introduction to Analytics Techniques & Fundamentals of Excel

Week 2: Useful Functions, Sorting & Filtering, Data Validation & Data Cleaning

    Video 1 | Useful Functions, Sorting & Filtering, Data Validation & Data Cleaning

    Video 2 | Useful Functions, Sorting & Filtering, Data Validation & Data Cleaning

    Video 3 | Useful Functions, Sorting & Filtering, Data Validation & Data Cleaning

    Video 4 | Useful Functions, Sorting & Filtering, Data Validation & Data Cleaning

    Video 5 | Useful Functions, Sorting & Filtering, Data Validation & Data Cleaning

    Video 6 | Useful Functions, Sorting & Filtering, Data Validation & Data Cleaning

    Video 7 | Useful Functions, Sorting & Filtering, Data Validation & Data Cleaning

    Video 8 | Useful Functions, Sorting & Filtering, Data Validation & Data Cleaning

    Video 9 | Useful Functions, Sorting & Filtering, Data Validation & Data Cleaning

    Quiz | Useful Functions, Sorting & Filtering, Data Validation & Data Cleaning

Week 3 : Data Functions and Working with Conditions in Excel

    Video 1 | Data Functions and Working with Conditions in Excel

    Video 2 | Data Functions and Working with Conditions in Excel

    Video 3 | Data Functions and Working with Conditions in Excel

    Video 4 | Data Functions and Working with Conditions in Excel

    Video 5 | Data Functions and Working with Conditions in Excel

    Video 6 | Data Functions and Working with Conditions in Excel

    Video 7 | Data Functions and Working with Conditions in Excel

    Quiz | Date Functions and working with Conditions in Excel

Week 4 : Data Manipulation Using Advanced Excel (Part 1)

    Video 1 | Data Manipulation Using Advanced Excel (Part 1)

    Video 2 | Data Manipulation Using Advanced Excel (Part 1)

    Video 3 | Data Manipulation Using Advanced Excel (Part 1)

    Video 4 | Data Manipulation Using Advanced Excel (Part 1)

    Video 5 | Data Manipulation Using Advanced Excel (Part 1)

    Quiz | Data Manipulation using Advanced Excel (Part-1)

Week 5 : Data Manipulation Using Advanced Excel (Part 2)

    Video 1 | Data Manipulation Using Advanced Excel (Part 2)

    Video 2 | Data Manipulation Using Advanced Excel (Part 2)

    Video 3 | Data Manipulation Using Advanced Excel (Part 2)

    Video 4 | Data Manipulation Using Advanced Excel (Part 2)

    Video 5 | Data Manipulation Using Advanced Excel (Part 2)

    Video 6 | Data Manipulation Using Advanced Excel (Part 2)

    Video 7 | Data Manipulation Using Advanced Excel (Part 2)

    Quiz | Data Manipulation using Advanced Excel (Part-2)

Week 6: Excel Tables & Data Analysis

    Video 1 | Excel Tables & Data Analysis

    Video 2 | Excel Tables & Data Analysis

    Video 3 | Excel Tables & Data Analysis

    Video 4 | Excel Tables & Data Analysis

    Video 5 | Excel Tables & Data Analysis

    Video 6 | Excel Tables & Data Analysis

    Video 7 | Excel Tables & Data Analysis

    Video 8 | Excel Tables & Data Analysis

    Quiz | Excel Tables & Data Analysis

Week 7: Data Visualization, Array Functions & Introduction to VBA Macros

    Video 1 | Data Visualization, Array Functions & Introduction to VBA Macros

    Video 2 | Data Visualization, Array Functions & Introduction to VBA Macros

    Video 3 | Data Visualization, Array Functions & Introduction to VBA Macros

    Video 4 | Data Visualization, Array Functions & Introduction to VBA Macros

    Video 5 | Data Visualization, Array Functions & Introduction to VBA Macros

    Quiz | Data Visualization, Array Functions & Introduction to VBA Macros

Week 8 : Introduction to Statistics & Application in Excel (Part-1)

    Video 1 | Introduction to Statistics & Application in Excel (Part-1)

    Video 2 | Introduction to Statistics & Application in Excel (Part-1)

    Video 3 | Introduction to Statistics & Application in Excel (Part-1)

    Video 4 | Introduction to Statistics & Application in Excel (Part-1)

    Video 5 | Introduction to Statistics & Application in Excel (Part-1)

    Video 6 | Introduction to Statistics & Application in Excel (Part-1)

    Video 7 | Introduction to Statistics & Application in Excel (Part-1)

    Quiz | Introduction to Statistics & Application in Excel

Week 9: Introduction to Statistics & Application in Excel (Part-2)

    Video 1 | Introduction to Statistics & Application in Excel (Part-2)

    Video 2 | Introduction to Statistics & Application in Excel (Part-2)

    Video 3 | Introduction to Statistics & Application in Excel (Part-2)

    Video 4 | Introduction to Statistics & Application in Excel (Part-2)

    Video 5 | Introduction to Statistics & Application in Excel (Part-2)

    Video 6 | Introduction to Statistics & Application in Excel (Part-2)

    Video 7 | Introduction to Statistics & Application in Excel (Part-2)

    Video 8 | Introduction to Statistics & Application in Excel (Part-2)

    Quiz | Introduction to Statistics & Application in Excel (Part-2)

Week 10: MS SQL (Part-1)

    Video 1 | MS SQL (Part-1)

    Video 2 | MS SQL (Part-1)

    Video 3 | MS SQL (Part-1)

    Video 4 | MS SQL (Part-1)

    Video 5 | MS SQL (Part-1)

    Video 6 | MS SQL (Part-1)

    Video 7 | MS SQL (Part-1)

    Video 8 | MS SQL (Part-1)

    Video 9 | MS SQL (Part-1)

    Quiz | SQL (Part-1)

Week 11: MS SQL (Part-2)

    Video 1 | MS SQL (Part-2)

    Video 2 | MS SQL (Part-2)

    Video 3 | MS SQL (Part-2)

    Video 4 | MS SQL (Part-2)

    Video 5 | MS SQL (Part-2)

    Video 6 | MS SQL (Part-2)

    Video 7 | MS SQL (Part-2)

    Video 8 | MS SQL (Part-2)

    Video 9 | MS SQL (Part-2)

    Quiz | SQL (Part-2)

Week 12: Power Bi – Introduction

    Part 1 - Introduction to Power BI

    Part 2 - Navigating Through Power BI Interface

    Part 3 - Importing Data into Power BI

    Part 4 - Understanding the Data and Calculating a Column

    Part 5 - Report Making in Power BI

    Part 6 - Formatting Charts, Publishing a report and Dashboard

    Part 7 - Relationships and Map base Visualisations

    Part 8 - Creating Measures with DAX

    Part 9 - Time Intelligence in Power BI

    Content | Power BI

    Quiz | Power BI

programme-3

À propos du formateur

Cours

Divya Mahajan

AUTRE, ?