-
Course Overview 1
-
Download the Working Excel FilesLecture1.102 min
-
-
Relative Vs Absolute Cell Reference (Use of $ Sign) 4
-
Relative cell reference – No cell lockingLecture2.1
-
Partial absolute cell reference – Row or column lockingLecture2.2
-
Full absolute cell reference – Row and column lockingLecture2.305 min
-
QuizQuiz2.12 questions
-
-
Lookup and References Functions 15
-
VLOOKUP Function when the range is whole columnLecture3.108 min
-
VLOOKUP Function for the specific rangeLecture3.207 min
-
Copy-paste techniques for the VLOOKUP formulaLecture3.306 min
-
Difference between TRUE and FALSE in VLOOKUP FunctionLecture3.403 min
-
Carefulness for VLOOKUP FunctionLecture3.506 min
-
HLOOKUP functionLecture3.604 min
-
MATCH functionLecture3.703 min
-
INDEX functionLecture3.803 min
-
Combination of INDEX and MATCH function in a single formulaLecture3.906 min
-
Calling left column value from the sourceLecture3.1003 min
-
Dynamic column index number in VLOOKUP functionLecture3.1104 min
-
OFFSET functionLecture3.1213 min
-
LOOKUP functionLecture3.1313 min
-
VLOOKUP function – Bonus VideoLecture3.14
-
QuizQuiz3.15 questions
-
-
Logical Functions with Nested IF 6
-
IF() Condition excluding ELSELecture4.105 min
-
IF() Condition including ELSELecture4.205 min
-
IFS() Condition excluding ELSELecture4.304 min
-
IFS() Condition including ELSELecture4.403 min
-
Nested IF() formula with AND ORLecture4.506 min
-
QuizQuiz4.11 question
-
-
Advanced Conditional Formatting 14
-
Setting a single conditional formattingLecture5.105 min
-
Setting multi-level conditional formatting in the same rangeLecture5.207 min
-
KPI reporting -1 using data bar (Positive-negative)Lecture5.303 min
-
KPI reporting -2 using data bar (All Positive)Lecture5.402 min
-
KPI reporting -3 Highlighting top or bottom valuesLecture5.504 min
-
KPI reporting -4 Using icon setLecture5.602 min
-
Customizing the icon setLecture5.705 min
-
Highlighting the duplicate valuesLecture5.804 min
-
Conditional formatting using formulaLecture5.905 min
-
Conditional formatting using Color ScaleLecture5.1003 min
-
Add, Edit or remove conditional formattingLecture5.1102 min
-
Clearing the Conditional FormattingLecture5.1202 min
-
Finding out the conditional formatting applied cellsLecture5.1305 min
-
QuizQuiz5.13 questions
-
-
PivotTable 12
-
Overview of PivotTableLecture6.106 min
-
Creating PivotTable using one row and one columnLecture6.208 min
-
Creating PivotTable report with multiple groupsLecture6.305 min
-
Changing layout of PivotTableLecture6.404 min
-
Drill down your PivotTable valueLecture6.505 min
-
Filtering the PivotTable DataLecture6.604 min
-
Formatting PivotTable DataLecture6.703 min
-
Adding a new calculated columnLecture6.805 min
-
Creating PivotChartLecture6.906 min
-
Use Slicers in PivotTableLecture6.1005 min
-
Conclusion of PivotTableLecture6.1102 min
-
QuizQuiz6.15 questions
-
-
Data Linking and Reporting Techniques from Large Data 2
-
Data consolidation from multiple files using PowerQueryLecture7.111 min
-
QuizQuiz7.11 question
-
-
Graphical Presentation 14
-
Knowing the chart layouts and styles from the ribbonLecture8.107 min
-
Chart formatting from the ribbonLecture8.206 min
-
Creating chart taking data from non-continuous rangesLecture8.302 min
-
Recognizing Chart ElementsLecture8.409 min
-
Changing chart typeLecture8.503 min
-
Adding secondary axisLecture8.605 min
-
Column chart and column chart customizationLecture8.713 min
-
Line chart and line chart customizationLecture8.810 min
-
Pie chart and pie chart customizationLecture8.904 min
-
Doughnut chart and doughnut chart customizationLecture8.1011 min
-
Waterfall Chart with customizationLecture8.1108 min
-
KPI presentation using 3 kinds of SparklinesLecture8.12
-
Thermometer Chart for target vs achievementLecture8.1310 min
-
QuizQuiz8.12 questions
-
-
Data Summarization Techniques 5
-
SUMIFS functionLecture9.109 min
-
COUNTIFS functionLecture9.2
-
SUMPRODUCT functionLecture9.307 min
-
Live Dashboard techniques using SUMIFS, COUNTIFS and ChartLecture9.410 min
-
QuizQuiz9.11 question
-
-
Secure Your Sheet and File with Password Protected 5
-
Entry restriction in a specific area of a sheetLecture10.107 min
-
Set the password to unprotect the sheetLecture10.202 min
-
Unprotect the sheet with correct passwordLecture10.302 min
-
Removing password to unprotect the sheetLecture10.402 min
-
QuizQuiz10.11 question
-
-
VBA & Macro Basics – An Overall Idea 13
-
What is VBA and Macro?Lecture11.105 min
-
Why will you use VBA & Macro?Lecture11.203 min
-
Example of few ready real files created using VBA & MacroLecture11.308 min
-
Configuring Excel to start VBA and MacroLecture11.402 min
-
Project 1 – Creating first macroLecture11.511 min
-
Running the macro clicking on a buttonLecture11.604 min
-
Project 2 – Macro running by shortcut keyLecture11.704 min
-
Saving process of the Macro enabled fileLecture11.803 min
-
Understanding how macro writes the scriptsLecture11.905 min
-
Editing VBA code of a recorded macroLecture11.1004 min
-
Adding new lines in VBA codeLecture11.1110 min
-
Conclusion of VBA and MacroLecture11.1210 min
-
QuizQuiz11.13 questions
-
-
Data Validation 6
-
Overview of data validationLecture12.102 min
-
Setting data validation in a specific areaLecture12.207 min
-
Changing data validationLecture12.303 min
-
Clearing data validationLecture12.401 min
-
Searching data validated set areaLecture12.503 min
-
QuizQuiz12.11 question
-
This content is protected, please login and enroll course to view this content!