Curriculum
- 12 Sections
- 86 Lessons
- 104 Weeks
Expand all sectionsCollapse all sections
- Course Overview1
- Relative Vs Absolute Cell Reference (Use of $ Sign)3
- Lookup and References Functions14
- 4.0VLOOKUP Function when the range is whole column8 Minutes
- 4.1VLOOKUP Function for the specific range7 Minutes
- 4.2Copy-paste techniques for the VLOOKUP formula6 Minutes
- 4.3Difference between TRUE and FALSE in VLOOKUP Function3 Minutes
- 4.4Carefulness for VLOOKUP Function6 Minutes
- 4.5HLOOKUP function4 Minutes
- 4.6MATCH function3 Minutes
- 4.7INDEX function3 Minutes
- 4.8Combination of INDEX and MATCH function in a single formula6 Minutes
- 4.9Calling left column value from the source3 Minutes
- 4.10Dynamic column index number in VLOOKUP function4 Minutes
- 4.11OFFSET function13 Minutes
- 4.12LOOKUP function13 Minutes
- 4.13VLOOKUP function – Bonus Video9 Minutes
- Logical Functions with Nested IF5
- Advanced Conditional Formatting13
- 6.0Setting a single conditional formatting5 Minutes
- 6.1Setting multi-level conditional formatting in the same range7 Minutes
- 6.2KPI reporting -1 using data bar (Positive-negative)3 Minutes
- 6.3KPI reporting -2 using data bar (All Positive)2 Minutes
- 6.4KPI reporting -3 Highlighting top or bottom values4 Minutes
- 6.5KPI reporting -4 Using icon set2 Minutes
- 6.6Customizing the icon set5 Minutes
- 6.7Highlighting the duplicate values4 Minutes
- 6.8Conditional formatting using formula5 Minutes
- 6.9Conditional formatting using Color Scale3 Minutes
- 6.10Add, Edit or remove conditional formatting2 Minutes
- 6.11Clearing the Conditional Formatting2 Minutes
- 6.12Finding out the conditional formatting applied cells5 Minutes
- PivotTable11
- 7.0Overview of PivotTable6 Minutes
- 7.1Creating PivotTable using one row and one column8 Minutes
- 7.2Creating PivotTable report with multiple groups5 Minutes
- 7.3Changing layout of PivotTable4 Minutes
- 7.4Drill down your PivotTable value5 Minutes
- 7.5Filtering the PivotTable Data4 Minutes
- 7.6Formatting PivotTable Data3 Minutes
- 7.7Adding a new calculated column5 Minutes
- 7.8Creating PivotChart6 Minutes
- 7.9Use Slicers in PivotTable5 Minutes
- 7.10Conclusion of PivotTable2 Minutes
- Data Linking and Reporting Techniques from Large Data1
- Graphical Presentation13
- 9.0Knowing the chart layouts and styles from the ribbon7 Minutes
- 9.1Chart formatting from the ribbon6 Minutes
- 9.2Creating chart taking data from non-continuous ranges2 Minutes
- 9.3Recognizing Chart Elements9 Minutes
- 9.4Changing chart type3 Minutes
- 9.5Adding secondary axis5 Minutes
- 9.6Column chart and column chart customization13 Minutes
- 9.7Line chart and line chart customization10 Minutes
- 9.8Pie chart and pie chart customization4 Minutes
- 9.9Doughnut chart and doughnut chart customization11 Minutes
- 9.10Waterfall Chart with customization8 Minutes
- 9.11KPI presentation using 3 kinds of Sparklines7 Minutes
- 9.12Thermometer Chart for target vs achievement10 Minutes
- Data Summarization Techniques4
- Secure Your Sheet and File with Password Protected4
- VBA & Macro Basics – An Overall Idea12
- 12.0What is VBA and Macro?5 Minutes
- 12.1Why will you use VBA & Macro?3 Minutes
- 12.2Example of few ready real files created using VBA & Macro8 Minutes
- 12.3Configuring Excel to start VBA and Macro2 Minutes
- 12.4Project 1 – Creating first macro11 Minutes
- 12.5Running the macro clicking on a button4 Minutes
- 12.6Project 2 – Macro running by shortcut key4 Minutes
- 12.7Saving process of the Macro enabled file3 Minutes
- 12.8Understanding how macro writes the scripts5 Minutes
- 12.9Editing VBA code of a recorded macro4 Minutes
- 12.10Adding new lines in VBA code10 Minutes
- 12.11Conclusion of VBA and Macro10 Minutes
- Data Validation5