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.🦁
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
Programme
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
À 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.