-
Financial Modelling in Excel
36-
Mathematical Functions ABS, FACT, GCD, INT, LOG, MROUND, etc…Lecture1.1
-
Statistical Function in Excel AVERAGE, COUNTIF, COVARIANCE, MIN, etc…Lecture1.2
-
Text FunctionsLecture1.3
-
Financial Functions Npv, PV, FV, IRR, PMT, etc….Lecture1.4
-
Flash FillLecture1.5
-
Cell ReferencingLecture1.6
-
Ranges & Name BoxLecture1.7
-
Formula Error MessagesLecture1.8
-
Formula AuditingLecture1.9
-
Connecting Worksheets and WorkbooksLecture1.10
-
Consolidation of DataLecture1.11
-
Consolidation of Balance SheetLecture1.12
-
Investment AnalysisLecture1.13
-
Bond Valuation & YieldLecture1.14
-
Coup FunctionLecture1.15
-
Calculation of Accrued InterestLecture1.16
-
Analysis ToolPakLecture1.17
-
Regression AnalysisLecture1.18
-
Sales AnalysisLecture1.19
-
Formatting WorksheetsLecture1.20
-
Area ChartsLecture1.21
-
Surface ChartsLecture1.22
-
Trend line ChartsLecture1.23
-
Candle Stick ChartsLecture1.24
-
Pie ChartsLecture1.25
-
XY (Scatter Charts)Lecture1.26
-
Time Series ChartsLecture1.27
-
Bubble ChartsLecture1.28
-
Radar ChartsLecture1.29
-
Doughnut ChartsLecture1.30
-
Rotating 3D Excel ChartsLecture1.31
-
Sparkline’s in ExcelLecture1.32
-
Data Form & PrintingLecture1.33
-
Macros & HyperlinksLecture1.34
-
Data Lock & Data ProtectionLecture1.35
-
Case StudiesLecture1.36
-
-
SQL
14-
Introduction to SQLLecture2.1
-
Creating New TablesLecture2.2
-
SQL SELECT StatementsLecture2.3
-
Manipulating Data(Insert, Delete, Update)Lecture2.4
-
Distinct, Order By, Join clauses and Aggregate FunctionsLecture2.5
-
Using Primary keys, Foreign keysLecture2.6
-
Get Data from Multiple TablesLecture2.7
-
Using DDL StatementsLecture2.8
-
Restricting and Sorting DataLecture2.9
-
Using Single-row FunctionsLecture2.10
-
Conversion FunctionsLecture2.11
-
Conditional ExpressionsLecture2.12
-
Using the Group FunctionsLecture2.13
-
Subqueries to solve queriesLecture2.14
-
This content is protected, please login and enroll course to view this content!