AISECT LEARN LMS
Data Analytics using Advanced Excel
0%
Previous
Course data
Course Overview
Announcements
1. Introduction to Advanced Excel
1.1 Brief Introduction to Advanced Excel
Brief Introduction to Advanced Excel -SLM
Quiz on Brief Introduction to Advanced Excel
1.2 Role of Excel in Data Analytics
Role of Excel in Data Analytics-SLM
Quiz on Role of Excel in Data Analytics
1.3 Data Cleaning in Excel
Data Cleaning in Excel -SLM
Quiz on Data Cleaning in Excel
1.4 Intermediate Excel Functions
Intermediate Excel Functions -SLM
Quiz on Intermediate Excel Functions
1.5 Descriptive Statistics
Descriptive Statistics -SLM
1.5 Quiz on Descriptive Statistics
2. Basics Excel Formulas and Function
2.1 How to Calculate Sum
How to Calculate Sum
Quiz on How to Calculate Sum
2.2 How to Calculate Average
How to Calculate Average
2.2 Quiz on How to Calculate Average
2.3 How to Calculate Count
2.3 How to Calculate Count
2.3 Quiz on How to Calculate Count
2.4 Concatenate
2.4 Concatenate
2.4Quiz on Concatenate
2.5 Today/Time and Dated if
Today/Time and Dated if
2.5 Quiz on Today/Time and Dated if
2.6 Count If and Sum If
Count If and Sum If
2.6 Quiz on Count If and Sum If
2.7 If Else and If Error
If Else and If Error
2.7 Quiz on If Else and If Error
3. Introduction to Pivot Tables
3.1 How To Create Pivot Table in Excel
How To Create Pivot Table in Excel
3.1 Quiz on How To Create Pivot Table in Excel
3.2 Root Cause Analysis
Root Cause Analysis
3.2 Quiz on Root Cause Analysis
3.3 Comparative Analysis
Comparative Analysis
3.3 Quiz on Comparative Analysis
3.4 Introduction to Visualizations and Pie Charts
Introduction to Visualizations and Pie Charts
3.4 Quiz on Introduction to Visualizations and Pie Charts
3.5 Histograms
3.5 Histograms
3.5 Quiz on Histograms
4. Data visualization in Excel
4.1 Bar Charts
4.1 Bar Charts -SLM
4.1 Quiz on Bar Charts
4.2 Line Charts
4.2 Line Charts
4.2 Quiz on Line Charts
4.3 Box and Box Plot
4.3 Box and Box Plot -SLM
4.3 Quiz on Box and Box Plot
4.4 Scatter Plots
4.4 Scatter Plots -SLM
4.4 Quiz on Scatter Plots
4.5 Conditional Formatting
4.5 Quiz on Conditional Formatting- SLM
4.5 Conditional Formatting
5.Advanced Excel Functions and Formulas
5.1 V-Lookup
5.1 V-Lookup- SLM
5.1 Quiz on V-Lookup
5.2 H-Lookup
5.2 H-Lookup-SLM
5.2 Quiz on H-Lookup
5.3 Filtering and Sorting
5.3 Filtering and Sorting-SLM
5.3 Quiz on Filtering and Sorting
5.4 Data Cleaning In Advanced Excel
5.4 Data Cleaning In Advanced Excel -SLM
5.4 Quiz on Data Cleaning In Advanced Excel
Final Assessment
Final Assessment
Discussion Forum
Data Analytics using Advanced Excel- Discussion Forum
Next
AISECT LEARN LMS
Side panel
सभी कार्यक्रम
For Learners
Programs
Career Path
हिंदी (hi)
English (en)
वर्कप्लेस के लिए हिंदी (hi_wp)
हिंदी (hi)
खोज
बंद करे
खोज
Toggle search input
लॉग इन करें
यूज़रनेम
पासवर्ड
Remember username
Forgot Password?
लॉग इन करें
Site Navigation
Data Analytics using Advanced Excel
मुख्य पेज
पंचांग
छोड़ कर मुख्य सामग्री पर जाएं
कोर्स जानकारी
मुख्य पेज
पाठ्यक्रम
New Structure Higher Education
Data Analytics using Advanced Excel
सन्क्षिप्त विवरण
Data Analytics using Advanced Excel
Data
Analytics
using Advanced Excel Course
Skill Level
:
Beginner