-
Module 1
38-
Introduction to MS Excel, Quick review on MS Excel Options, Ribbon, SheetsLecture1.1
-
Difference between Excel 2003, 2007, 2010 and 2013Lecture1.2
-
Saving Excel File as PDF, CSV and Older versionsLecture1.3
-
Using Excel Shortcuts with Full List of ShortcutsLecture1.4
-
Copy, Cut, Paste, Hide, Unhide, and Link the Data in Rows, Columns and SheetLecture1.5
-
Using Paste Special OptionsLecture1.6
-
Formatting Cells, Rows, Columns and SheetsLecture1.7
-
Protecting & Unprotecting Cells, Rows, Columns and Sheets with or without PasswordLecture1.8
-
Page Layout and Printer PropertiesLecture1.9
-
Inserting Pictures and other objects in WorksheetsLecture1.10
-
Lookup and Reference Functions: VLOOKUP, HLOOKUP, INDEX, MATCH, etcLecture1.11
-
Database FunctionsLecture1.12
-
Date and Time Functions: DATE, DATEVALUE, DAY, DAY360, SECOND, MINUTES, HOURS, NOW, TODAY, MONTH, YEAR, YEARFRAC, TIME, WEEKDAY, WORKDAY etcLecture1.13
-
Statistical Functions: AVEDEV, AVERAGE, AVERAGEA, AVERAGEIF, COUNT, COUNTA, COUNTBLANK, COUNTIF,FORECAST, MAX, MAXA,MIN, MINA, STDEVA etcLecture1.14
-
Text Functions: LEFT, RIGHT, TEXT, TRIM, MID, LOWER, UPPER, PROPER, REPLACE, REPT, FIND, SEARCH, SUBSTITUTE, TRIM, TRUNC, CONVERT, CONCATENATE, DOLLAR etc And MoreLecture1.15
-
Using Conditional FormattingLecture1.16
-
Using Conditional Formatting with Multiple Cell RulesLecture1.17
-
Using Color Scales and Icon Sets in Conditional FormattingLecture1.18
-
Creating New Rules and Managing Existing RulesLecture1.19
-
Sorting Data A-Z and Z-ALecture1.20
-
Using Filters to Sort DataLecture1.21
-
Advance Filtering OptionsLecture1.22
-
Creating Pivot TablesLecture1.23
-
Using Pivot Table OptionsLecture1.24
-
Changing and Updating Data RangeLecture1.25
-
Formatting Pivot Table and Making Dynamic Pivot TablesLecture1.26
-
Creating Pivot ChartsLecture1.27
-
Types of Pivot Charts and Their UsageLecture1.28
-
Formatting Pivot Charts and Making Dynamic Pivot ChartsLecture1.29
-
Advanced FilteringLecture1.30
-
Data validationLecture1.31
-
ConsolidationLecture1.32
-
GroupsLecture1.33
-
SubtotalLecture1.34
-
How to Record / Run Excel Macro ?Lecture1.35
-
What is Excel Macro ?Lecture1.36
-
How Add Developer’s Tab in Excel 2007 / 2010Lecture1.37
-
How to add different types of controls like Text Box, Radio button, button etc. in ExcelLecture1.38
-
-
Module 2
17-
Mathematical Function (Using Case Studies)Lecture2.1
-
Logical Function (Using Case Studies)Lecture2.2
-
Text Function (Using Case Studies)Lecture2.3
-
Flash Fill (Using Case Studies)Lecture2.4
-
Area ChartsLecture2.5
-
Surface ChartsLecture2.6
-
Trend line ChartsLecture2.7
-
Candle Stick ChartsLecture2.8
-
Pie ChartsLecture2.9
-
XY (Scatter Charts)Lecture2.10
-
Time Series ChartsLecture2.11
-
Bubble ChartsLecture2.12
-
Radar ChartsLecture2.13
-
Doughnut ChartsLecture2.14
-
Rotating 3D Excel ChartsLecture2.15
-
More Case StudiesLecture2.16
-
Add-On Tools (Analytical Tools)Lecture2.17
-
-
Basic Python
26-
Introduction to PythonLecture3.1
-
Python – The Universal LanguageLecture3.2
-
Installing PythonLecture3.3
-
iPython – a better Python interpreterLecture3.4
-
Types – Dynamic v/s Static Typing – tstrong v/s Weak TypingLecture3.5
-
NumbersLecture3.6
-
StringsLecture3.7
-
UnicodeLecture3.8
-
Complex TypesLecture3.9
-
Operators – Operator OverloadingLecture3.10
-
VariablesLecture3.11
-
Scopping And ExpressionsLecture3.12
-
Use of tabs and whitespaces as indentLecture3.13
-
Conditionals – for…elseLecture3.14
-
The general syntaxLecture3.15
-
Default values for argumentsLecture3.16
-
Returning and receiving multiple valuesLecture3.17
-
Variable number of arguments – args, kwargsLecture3.18
-
Scope revisitedLecture3.19
-
Primitive v/s Composite TypesLecture3.20
-
ListsLecture3.21
-
TuplesLecture3.22
-
Maps (or Dictionaries)Lecture3.23
-
SetsLecture3.24
-
EnumsLecture3.25
-
Looping TechniquesLecture3.26
-
-
Data Analysis with Python
27-
Installing Anaconda and Jupyter NotebookLecture4.1
-
Jupyter Notebook overviewLecture4.2
-
Importing data from a csv, text file or another databaseLecture4.3
-
Overview of various methods and attributes of NumpyLecture4.4
-
ArrayLecture4.5
-
Creating 1 dimensional arraysLecture4.6
-
Creating 2 dimensional arraysLecture4.7
-
Array indexingLecture4.8
-
Accessing array elementsLecture4.9
-
Concatenating Numpy arraysLecture4.10
-
Arithmetic operations with arraysLecture4.11
-
CovarianceLecture4.12
-
CorrelationLecture4.13
-
Linear RegressionLecture4.14
-
Overview of various methods and attributes of PandasLecture4.15
-
IntroductionLecture4.16
-
Working with various Series attributesLecture4.17
-
IntroductionLecture4.18
-
PivotingLecture4.19
-
SortingLecture4.20
-
AggregationLecture4.21
-
Descriptive statistical analysis with PandasLecture4.22
-
Introduction to MatplotlibLecture4.23
-
Various Matplotlib methodsLecture4.24
-
Creating Line, Scatter, Bar, etc. chartsLecture4.25
-
Customising charts using: X and Y labels, Limits, Ticks, LegendsLecture4.26
-
Introduction to PyplotLecture4.27
-
-
R Programming
43-
R–OVERVIEWLecture5.1
-
R – ENVIRONMENT SETUPLecture5.2
-
R – BASIC SYNTAXLecture5.3
-
R – DATA TYPESLecture5.4
-
R – VARIABLESLecture5.5
-
R – OPERATORSLecture5.6
-
R – DECISION MAKINGLecture5.7
-
R – LOOPSLecture5.8
-
R – FUNCTIONLecture5.9
-
R – STRINGSLecture5.10
-
R – LISTSLecture5.11
-
13.R – MATRICESLecture5.12
-
R – ARRAYSLecture5.13
-
R – FACTORSLecture5.14
-
R – DATA FRAMESLecture5.15
-
R – PACKAGESLecture5.16
-
R – DATA RESHAPING MeltLecture5.17
-
The DataLecture5.18
-
R – CSV FILESLecture5.19
-
R – EXCEL FILE Input as xlsxLecture5.20
-
FileLecture5.21
-
R – BINARY FILESLecture5.22
-
R – XML FILESLecture5.23
-
R – JSON FILELecture5.24
-
R – WEB DATALecture5.25
-
R – DATABASESLecture5.26
-
R – PIE CHARTSLecture5.27
-
R – BOXPLOTSLecture5.28
-
R – HISTOGRAMSLecture5.29
-
R – LINE GRAPHSLecture5.30
-
R – SCATTERPLOTSLecture5.31
-
R – LINEAR REGRESSIONLecture5.32
-
R – MULTIPLE REGRESSIONLecture5.33
-
R – LOGISTIC REGRESSIONLecture5.34
-
R – NORMAL DISTRIBUTIONLecture5.35
-
R – BINOMIAL DISTRIBUTIONLecture5.36
-
R – POISSON REGRESSIONLecture5.37
-
R – ANALYSIS OF COVARIANCELecture5.38
-
R – TIME SERIES ANALYSISLecture5.39
-
R – NONLINEAR LEAST SQUARELecture5.40
-
R – DECISION TREELecture5.41
-
R – SURVIVAL ANALYSISLecture5.42
-
R – CHI SQUARE TESTLecture5.43
-
-
SQL
16-
IntroductionLecture6.1
-
Creating New TablesLecture6.2
-
SQL SELECT StatementsLecture6.3
-
Manipulating Data(Insert, Delete, Update)Lecture6.4
-
Distinct, Order By, Join clauses and Aggregate FunctionsLecture6.5
-
Using Primary keys, Foreign keysLecture6.6
-
Get Data from Multiple TablesLecture6.7
-
Using DDL StatementsLecture6.8
-
Restricting and Sorting DataLecture6.9
-
Using Single-row FunctionsLecture6.10
-
Conversion FunctionsLecture6.11
-
Conditional ExpressionsLecture6.12
-
Using the Group FunctionsLecture6.13
-
Subqueries to solve queriesLecture6.14
-
Linking SQL file with PythonLecture6.15
-
Accessing databaseLecture6.16
-
