Scribd
Upload
4 views2 pages

Data Analytics with Excel Course Details

The Data Analytics with Excel program consists of 8 lectures over 4 weeks, totaling 40 hours of instruction. It covers topics such as basic Excel navigation, advanced formatting, data analysis techniques, and VBA integration, along with 2 assignments and assessments. Participants will also engage in a capstone project involving over 10 projects.

Uploaded by

rudhrasingh9878
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
4 views2 pages

Data Analytics with Excel Course Details

The Data Analytics with Excel program consists of 8 lectures over 4 weeks, totaling 40 hours of instruction. It covers topics such as basic Excel navigation, advanced formatting, data analysis techniques, and VBA integration, along with 2 assignments and assessments. Participants will also engage in a capstone project involving over 10 projects.

Uploaded by

rudhrasingh9878
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Data Analytics with Excel Progra

Duration of each lecture 3 hours


No. of Lectures 08 Lectures
No of Week 04 weeks
No of Months 01 Months
No of Modules 01 Modules
No. of Assignment 02 Assignment
No. of Assessment 02 Assessment

Lecture 01 Introduction to Data Analytics, Scope of Data An

Microsoft Excel Overview, Basic Navigation and U


Lecture 02
referencing, Formatting Excel

Advanced Formatting, Shortcuts and Basic Formula


Lecture 03
Filtering, Advanced Filtering, Charts, Types of C

Advanced Charting Techniques and Pivot Tables,


Lecture 04
Grouping and Summarizing Data

Module 01 Lookup Function, Vlookup, Using VLOOKUP with


Advanced Lecture 05 Criteria Hlookup, Combining HLOOKUP with Other
Match Function, Using MATCH for Dynamic Ref
Excel
Introduction to VBA & Macros, Understanding VB
Lecture 06 Debugging and error handling, Integrating VBA w
functions,

Understanding the basics of data analysis, Data Im


Lecture 07 Cleaning, Using Formulas and Functions, Data Visu
Building a Dashboard

Advanced Data Analysis Techniques, Dashboards an


Lecture 08 Case Studies and Real-World Applications, Practical e
data analysis in Excel

Project Discussion session


nalytics with Excel Program
Total Course Duration 40 hours
Pre learning Lectures 3 hours
Live Lectures 16 hours
Video Recorded of Lectures 16 hours
Capstone Project Involvement 05 hours
[Link] Capstone Project 10+ Projects
Batch Weekend

tion to Data Analytics, Scope of Data Analytics 2

Excel Overview, Basic Navigation and Usage, Cell


2
referencing, Formatting Excel

ormatting, Shortcuts and Basic Formulas, Sorting,


2
g, Advanced Filtering, Charts, Types of Charts,

Charting Techniques and Pivot Tables, Creating,


Grouping and Summarizing Data
2

nction, Vlookup, Using VLOOKUP with Multiple,


kup, Combining HLOOKUP with Other Functions, 2
nction, Using MATCH for Dynamic Referencing

n to VBA & Macros, Understanding VBA basics,


g and error handling, Integrating VBA with Excel 2
functions,

ding the basics of data analysis, Data Import and


Using Formulas and Functions, Data Visualization, 2
Building a Dashboard

ata Analysis Techniques, Dashboards and Reports,


and Real-World Applications, Practical examples of 2
data analysis in Excel

iscussion session

You might also like