-
Course Introduction
-
Download Related Files
-
-
Section-1 Basic Concepts, Formulas
-
1-1 Excel User Interface
-
1-2 Data Types
-
1-5 Absolute refe
-
1-6 Mixed ref
-
-
Section-2 Functions
-
2-1 Functions Intro
-
2-2 Functions Sum
-
2-3-1 Functions Sumif
-
2-3-2 Functions sumif expl
-
2-4 Functions Sumproduct
-
2-5-2 Functions If and
-
2-6 Functions if or
-
2-7 Functions if nested
-
2-8-1 Functions Vlookup
-
2-8-2 Functions Vlookup1
-
2-9 Functions Vlookup Match
-
2-10 Functions HLookup
-
-
Section-3 Data Manipulation
-
3-1 Import data to excel
-
3-2 filter1
-
3-3 filter2
-
3-4 sort
-
3-5 subtotal
-
3-6 Conditional formating
-
-
Section-4 Pivot Tables
-
4-1 Pivot Table1
-
4-2 Pivot Table 2
-
4-3 Pivot tables3
-
4-4 Pivot table fields
-
4-5 Pivot Table 4
-
-
Section-5 Visualizations & Charts
-
5-1 Charts 1
-
5-2 Charts 2
-
5-3 Charts 3
-
5-4 Charts 4
-
5-5 Charts 5
-
-
Projects
-
Project 1 Salary 2
-
Project 1 Salary 3
-
Project 1 Salary 4
-
Project 1 Salary 5
-
Project 1 Salary 6
-
Project 2 Cashflow 2
-
3 Project Dashboard 2