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
1.2 Role of Excel in Data Analytics
Role of Excel in Data Analytics-SLM
1.3 Data Cleaning in Excel
Data Cleaning in Excel -SLM
1.4 Intermediate Excel Functions
Intermediate Excel Functions -SLM
1.5 Descriptive Statistics
Descriptive Statistics -SLM
2. Basics Excel Formulas and Function
2.1 How to Calculate Sum
How to Calculate Sum
2.2 How to Calculate Average
How to Calculate Average
2.3 How to Calculate Count
2.3 How to Calculate Count
2.4 Concatenate
2.4 Concatenate
2.5 Today/Time and Dated if
Today/Time and Dated if
2.6 Count If and Sum If
Count If and Sum If
2.7 If Else and If Error
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.2 Root Cause Analysis
Root Cause Analysis
3.3 Comparative Analysis
Comparative Analysis
3.4 Introduction to Visualizations and Pie Charts
Introduction to Visualizations and Pie Charts
3.5 Histograms
3.5 Histograms
4. Data visualization in Excel
4.1 Bar Charts
4.1 Bar Charts -SLM
4.2 Line Charts
4.2 Line Charts
4.3 Box and Box Plot
4.3 Box and Box Plot -SLM
4.4 Scatter Plots
4.4 Scatter Plots -SLM
4.5 Conditional Formatting
4.5 Conditional Formatting- SLM
5.Advanced Excel Functions and Formulas
5.1 V-Lookup
5.1 V-Lookup -SLM
5.2 H-Lookup
5.2 H-Lookup-SLM
5.3 Filtering and Sorting
5.3 Filtering and Sorting-SLM
5.4 Data Cleaning In Advanced Excel
5.4 Data Cleaning In Advanced Excel -SLM
Discussion Forum
Discussion Forum
Next
AISECT LEARN LMS
Side panel
All Programs
For Learners
Programs
Career Path
English (en)
English (en)
वर्कप्लेस के लिए हिंदी (hi_wp)
हिंदी (hi)
Search
Close
Search
Toggle search input
Log in
Username
Password
Remember username
Forgot Password?
Log in
Site Navigation
Data Analytics using Advanced Excel
Home
Calendar
Skip to main content
Course info
Home
Courses
New Structure Higher Education
Data Analytics using Advanced Excel
Summary
Data Analytics using Advanced Excel
Data
Analytics
using Advanced Excel Course
Skill Level
:
Beginner