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.
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
À propos du formateur
Divya Mahajan
AUTRE, ?