-
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 PropertiesInserting Pictures and other objects in WorksheetsLecture1.9
-
Lookup and Reference Functions: VLOOKUP, HLOOKUP, INDEX, MATCH, etcLecture1.10
-
Logical Function: IF / ELSE, AND, OR, NOT, TRUE, NESTED IF/ELSE etcLecture1.11
-
Database Functions Date and Time Functions: DATE, DATEVALUE, DAY, DAY360, SECOND, MINUTES, HOURS, NOW, TODAY, MONTH, YEAR, YEARFRAC, TIME, WEEKDAY, WORKDAY etcLecture1.12
-
Information Functions : Math and Trigonometry Functions: RAND, ROUND, CEILING, FLOOR, INT, LCM, MOD, EVEN, SUMIF, SUMIFS 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
-
What is Excel Macro ?Lecture1.35
-
How to Record / Run 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
43-
Visual Basic Editor in ExcelLecture2.1
-
VBA Control PropertyLecture2.2
-
How to write Excel Macro – Your First Excel MacroLecture2.3
-
Excel Macro Tutorial : Excel User FormLecture2.4
-
VBA Spin ButtonLecture2.5
-
Toggle Button in ExcelLecture2.6
-
ComboBox / Drop Down List In ExcelLecture2.7
-
ListBox In ExcelLecture2.8
-
How to Open Excel Workbook using Excel MacroLecture2.9
-
Using RANGE Object in Excel MacroLecture2.10
-
What is difference between CELLS() and RANGE()Lecture2.11
-
Excel Macros, Excel Terms, Macro commentsLecture2.12
-
UserformsLecture2.13
-
Variables in Excel VBALecture2.14
-
Implicit and Explicit declaration of variables in Excel MacroLecture2.15
-
Important : Declaring multiple Variables with one Dim StatementLecture2.16
-
For Next Loop in Excel MacroLecture2.17
-
While Loop and Do While Loop in Excel VBALecture2.18
-
VBA Programming : If Then Statements / If else StatementsLecture2.19
-
VBA Programming : Decision – Select Case in Excel VBALecture2.20
-
Variables in Excel VBALecture2.21
-
Implicit and Explicit declaration of variables in Excel MacroLecture2.22
-
Important : Declaring multiple Variables with one Dim StatementLecture2.23
-
For Next Loop in Excel MacroLecture2.24
-
While Loop and Do While Loop in Excel VBALecture2.25
-
VBA Programming : Decision – Select Case in Excel VBALecture2.26
-
Events, Error HandlingLecture2.27
-
Excel Objects, Programming ChartsLecture2.28
-
Message box, Input boxLecture2.29
-
Introduction to SQLLecture2.30
-
Creating New TablesLecture2.31
-
SQL SELECT StatementsLecture2.32
-
Manipulating Data(Insert, Delete, Update)Lecture2.33
-
Distinct, Order By, Join clauses and Aggregate FunctionsLecture2.34
-
Using Primary keys, Foreign keysLecture2.35
-
Get Data from Multiple TablesLecture2.36
-
Using DDL StatementsLecture2.37
-
Using Single-row FunctionsLecture2.38
-
Restricting and Sorting DataLecture2.39
-
Conversion FunctionsLecture2.40
-
Conditional ExpressionsLecture2.41
-
Using the Group FunctionsLecture2.42
-
Subqueries to solve queriesLecture2.43
-
