Data Analytics Using Excel

30h

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. This class belongs to the path Datascientist. Each class you buy gives you an access to the 2 other classes in Datascience and Machine Learning.🦁

Inscription gratuite Tester sans inscription Achetez avec le CPF

Accessible to everyone

You can discover Data analysis and the use of Python

Professionnal

Built and writen by former Senior dev from Microsoft, Paypal and startuppers in marketing and Deeptech

Datadriven

Discover how to analyze multiple datas

Exhaustive

Installation (Jupyter), strong and datas, Python, Panda, OOP...


Objectifs de la mission

Understanding Datascience with Excel

Certificat

Cette formation permet de décrocher :

Data Scientist

Achetez avec le CPF

Programme

En savoir plus

Data Scientist

Data Analytics Using Excel

PROGRAMME

Installation: SQL Installation

    Installation: SQL Installation

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 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 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 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 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 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 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 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 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 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 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 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

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

Divya Mahajan

AUTRE, ?

Expert marketing ayant crée plusieurs entreprise, Digital Vidya propose également des cours en datascience pour améliorer le ciblage. Parmi ses membres des innovateurs, startuppers, développeurs ayant participé à la création de Paypal.