Home
Courses
About Us
Contact
Register
Login
Back
Home
Courses
About Us
Contact
16 Sections
81 Lessons
4 Weeks
Expand all sections
Collapse all sections
Introduction to Excel
6
1.1
Introduction to Excel for Data Analytics
1.2
Excel Interface Overview
1.3
Workbook vs Worksheet
1.4
Rows, Columns & Cells
1.5
Excel Navigation Shortcuts
1.6
Create First Excel Sheet
Excel Basic Operations
6
2.1
Data Entry in Excel
2.2
Formatting Cells
2.3
Font & Alignment
2.4
Borders & Colors
2.5
Insert & Delete Rows Columns
2.6
Excel Shortcuts
Basic Excel Formulas
6
3.1
Introduction to Formulas
3.2
SUM Function
3.3
AVERAGE Function
3.4
COUNT Function
3.5
MIN & MAX Function
3.6
AutoFill Feature
Logical Functions
5
4.1
IF Function
4.2
Nested IF
4.3
AND Function
4.4
OR Function
4.5
IF with AND OR
Text Functions
6
5.1
LEFT Function
5.2
RIGHT Function
5.3
MID Function
5.4
LEN Function
5.5
CONCAT Function
5.6
TRIM Function
Lookup Functions
7
6.1
VLOOKUP
6.2
HLOOKUP
6.3
XLOOKUP
6.4
INDEX Function
6.5
MATCH Function
6.6
INDEX + MATCH
6.7
DGET Function
Data Cleaning
5
7.1
Remove Duplicates
7.2
Text to Columns
7.3
Find & Replace
7.4
Flash Fill
7.5
Data Validation
Sorting & Filtering
4
8.1
Sorting Data
8.2
Filtering Data
8.3
Advanced Filters
8.4
Custom Sorting
Conditional Formatting
4
9.1
Highlight Rules
9.2
Color Scales
9.3
Data Bars
9.4
Icon Sets
Pivot Tables
5
10.1
Pivot Table Introduction
10.2
Create Pivot Table
10.3
Pivot Table Filters
10.4
Pivot Table Charts
10.5
Group Data
Charts & Visualization
5
11.1
Column Chart
11.2
Bar Chart
11.3
Pie Chart
11.4
Line Chart
11.5
Dashboard Charts
Advanced Excel Formulas
5
12.1
SUMIF
12.2
COUNTIF
12.3
SUMIFS
12.4
COUNTIFS
12.5
IFS Function
Power Query (Data Analytics)
5
13.1
Power Query Introduction
13.2
Import Data
13.3
Data Transformation
13.4
Merge Tables
13.5
Clean Data
Dashboard Creation
4
14.1
Dashboard Planning
14.2
Create Dashboard
14.3
Interactive Dashboard
14.4
Slicers
Excel Automation
4
15.1
Macros Introduction
15.2
Record Macro
15.3
Run Macro
15.4
Edit Macro
Real Projects
4
16.1
Sales Dashboard
16.2
Employee Data Analysis
16.3
Marketing Data Dashboard
16.4
Business Report
This content is protected, please
login
and
enroll
in the course to view this content!
Login with your site account
Lost your password?
Remember Me
Not a member yet?
Register now
Register a new account
Are you a member?
Login now
Modal title
Main Content
