-
Section 1:Introduction 16
-
Download Excel Data File to Work AlongLecture1.1
-
Excel Intro & Resource UseLecture1.2
-
Excel _ StructureLecture1.3
-
Shortcuts & Ribbon TabLecture1.4
-
Working with Excel _ StructureLecture1.5
-
Removing Formats from Online DataLecture1.6
-
Formatting – Putting Years in FormulaLecture1.7
-
Filling Data & Auto FillLecture1.8
-
Auto-Fill Alphanumerical in ExcelLecture1.9
-
Formatting – Cleaning All FormatsLecture1.10
-
Sorting & Filtering in ExcelLecture1.11
-
Data Navigation & SelectionLecture1.12
-
Goto Dialogue BoxLecture1.13
-
Conditional Data Formatting with FilterLecture1.14
-
Paste Special & UsageLecture1.15
-
Test Your KnowledgeQuiz1.10 question
-
-
Section 2:Formulas and Functions 21
-
Introduction to Formula & FunctionsLecture2.1
-
Arithmetic FunctionsLecture2.2
-
Arithmetic ContinuedLecture2.3
-
Error Handling in ExcelLecture2.4
-
Error Handling – Data ValidationLecture2.5
-
Handling Single Condition in ExcelLecture2.6
-
Multiple CriteriaLecture2.7
-
Text Functions and Real time ApplicationLecture2.8
-
Handling Logics in ExcelLecture2.9
-
If with AND, OR and Nested IFSLecture2.10
-
Date Function in ExcelLecture2.11
-
Project: Finding NSE Working DaysLecture2.12
-
Look Up Functions – VlookupLecture2.13
-
Vlookup on Multiple ConditionsLecture2.14
-
Index MatchLecture2.15
-
Multidimensional Lookup Using Index MatchLecture2.16
-
Vlookup and ChooseLecture2.17
-
Tables in ExcelLecture2.18
-
Pivot TablesLecture2.19
-
Data Handling with SlicersLecture2.20
-
Project: NSE 100 Stocks Industry BifurcationLecture2.21
-
-
Section 3:Charts 9
-
Plotting Basic ChartLecture3.1
-
Adding Elements to ChartsLecture3.2
-
2-Axis ChartsLecture3.3
-
Pie ChartLecture3.4
-
XY and Scattered Plot with TrendlinesLecture3.5
-
Basic Dashboard Chart Using Multi Dimension LookupLecture3.6
-
Customized Pie in Pie ChartLecture3.7
-
Dashboard Chart using Doughnut ChartLecture3.8
-
Real Time Application of ChartsLecture3.9
-
This content is protected, please login and enroll course to view this content!