arrow_back
Introduction
01 Course Intro video
Starting with Microsoft Excel
1. Starting with Excel_Cut1_10-06-2023
1.1 Intro
1.2 tools _ commands
1.3. filling range concept_Cut1_19_06_2023
1. Starting with Microsoft Excel
2. Logical Statements in Excel
2. Logical statement in Excel_Cut1_10-06-2023
2.1 If Basic Function
2.2. sumif function
2.3 Sumifs
2.4 countif
2.5 if and or not
2. Logical Statement in Excel
3. Functions in Excel Part I
3. Functions in Excel part_1_Cut1_10-06-2023
3.1 basic conditional formatting_Cut1_19_06_2023
3.2 condiforma data bars_Cut1_19_06_2023
3.3 condiforma top _ bottom rules_Cut1_19_06_2023
3.4 condiforma color scales_Cut1_19_06_2023
3.5 condiforma icon sets_Cut1_19_06_2023
3.6 Worksheet Protection_Cut1_12-06-2023
3.7 data protection_Cut1_12-06-2023
3.8 hide rows _ column_Cut1_19_06_2023
3.9 unhide rows and columns_Cut1_12-06-2023
3.10 insert rows _ columns14. insert rows _ columns_Cut1_19_06_2023_1
3.11 delete rows _ columns_Cut1_19_06_2023
3.12 Sorting the data_Cut1_12-06-2023
3. Functions in Excel Part 1
4. Functions in Excel Part II
4. Function in Excel part_2_Cut1_10-06-2023
4.1 Flash Fill_Cut1_12-06-2023
4.2 text to columns_Cut1_12-06-2023
4.3 lower case_Cut1_19_06_2023
4.4 proper case-_Cut1_19_06_2023
4.5 Spark - lines _ Columns_Cut1_12-06-2023
4.6 Page Setup_Cut1_12-06-2023
4. Functions in Excel Part 2
4. Data Validation Part 1
4. Data Validation Part 2
4. Data Validation Part 3
4. Data Validation Part 4
4. Consolidate part 1
4. Consolidate part 2
4. Consolidate Part 3
4.C - Choose Function
4.D - Match Function
4. Match Index Function Part 1
4. Match Index Function Part 2
4. Match Index Function Part 3
5. Lookups
5. Lookups_Cut1_10-06-2023
5.1. Vlookup functions_Cut1_12-06-2023
5.2. Hlookup functions_Cut1_12-06-2023
5. Lookups
6. Pivot Table _ Charts
6. Pivot table and Charts_Cut1_10-06-2023
6.1 Begineers of pivot table_Cut1_19_06_2023
6.2 slicers
6.3 Complete Home Tab_Cut1_12-06-2023
6. Pivot Table Charts
7. Date _ Time Functions
7. Date and Time Functions_Cut1_10-06-2023
7.1. date _ time functions_Cut1_19_06_2023
7.2 Len_Cut1_12-06-2023
7.3. Trim_Cut1_12-06-2023
7. Date _ Time Functions
8. Data Handling
8. Data Handling_Cut1_10-06-2023
8.1 Concatenate_Cut1_12-06-2023
8.2 Concatenate _ Text Cases_Cut1_12-06-2023
8.3 DSUM_Cut1_12-06-2023
8.4 Dmin _ Dmax_Cut1_12-06-2023
8.5 Dcount _ Dcounta_Cut1_12-06-2023
8. Data Handling
9. Advanced Components in Excel
9. Advanced Components in excel_Cut1_10-06-2023
9.1 Filters in Data_Cut1_12-06-2023
9.2 Involving the text of equations_Cut1_12-06-2023
9.3 Linking worksheets or any objects-_Cut1_12-06-2023
9.4 Draw Tab_Cut1_12-06-2023
9.5 design the data_Cut1_19_06_2023_1
9. Advanced Components in MS Excel
11. Macro & VBA
11. Macro _ VBA_Cut1_10-06-2023
11.1 Introduction to Macros_Cut1_19_06_2023
11.2 Basics_ Creating _ Editing Code_Cut1_19_06_2023
11.3 Advanced_ Creating _ Editing Code_Cut1_19_06_2023
11.4 Functions - user defined_Cut1_19_06_2023
11.5 What is Logical Statement__Cut1_19_06_2023
11.6 Logic Statement_ Nested IF_Cut1_19_06_2023
11.7 Basics of Object Model_Cut1_19_06_2023
11.8 Working with the Object model_Cut1_19_06_2023
11.9 Basics of Looping Statement_Cut1_19_06_2023
11.10 Advanced_ Looping Statement_Cut1_19_06_2023
11.11 Understanding Variables_Cut1_19_06_2023
11.12 Advanced Variables_Cut1_19_06_2023
11.13 Basic VBA Editor_Cut1_19_06_2023
11.14 INVOCKING MACROS_Cut1_19_06_2023
11.15 Advanced_ Interactive Code_Cut1_19_06_2023
11. Excel VBA Macro
Dashboard
10.1 Dashboard
10.2 Dashboard
10.3 Dashboard
10.4 Dashboard
10.5 Dashboard
10.6 Dashboard
10.7 Dashboard
10.8 Dashboard