Mastering Excel
5.0
(0)
15 learners
What you'll learn
This course includes
- 42.5 hours of video
- Certificate of completion
- Access on mobile and TV
Course content
1 modules • 238 lessons • 42.5 hours of video
Mastering Excel
238 lessons
• 42.5 hours
Mastering Excel
238 lessons
• 42.5 hours
- MIS Explained | MIS Introduction in Hindi 13:38
- Excel User Interface Explained | Excel Introduction 05:32
- JOB Oriented Career Path-Why MIS? 20:14
- Excel Options | Advanced Excel Setting 16:20
- Difference between Save and Save as Excel 13:42
- Excel Paste Special | Every excel user must know in depth uses 18:06
- Excel Cell Reference :RELATIVE REFERENCE | Ms - Excel Cell Reference 11:15
- Excel Cell Reference :ABSOLUTE REFERENCE | Ms - Excel Cell Reference 09:00
- Excel Cell Reference :Mixed Reference | Ms-Excel Cell Reference 10:04
- Excel Cell Reference:-Mixed Reference Part-1 | Ms - Excel Cell Reference 09:53
- Excel Custom Formatting Part1 | Smart ways to use custom formatting in excel 09:38
- Excel Custom Formatting :Part 2 | Smart ways to use Custom Formatting 08:49
- Conditional Formatting in Excel :Part 1 | Ms-Excel Advanced Conditional Formatting 12:31
- Conditional Formatting in Excel :Part 2 | Ms Excel - Advanced Conditional Formatting 09:35
- Conditional Formatting in Excel :Part 3 | Ms Excel - Advanced Conditional Formatting 07:42
- Customized Conditional Formatting :Part 1 | Smart ways to use advanced custom conditional formatting 12:34
- Formula vs Function :Part-1 16:19
- Customize Conditional Formatting :Part 2 | Smart ways to use advanced custom conditional formatting 06:34
- Customized Conditional Formatting :Part 3 | Smart ways to use advanced custom conditional formatting 05:45
- Formula vs Function :Part 2 06:55
- EXCEL IF FORMULA :Part 1 | Ms - Excel if function in hindi 19:02
- EXCEL IF FORMULA :Part 2 | Ms - Excel if function in hindi 13:02
- EXCEL IF FORMULA: Part 3 | Ms - Excel if function in hindi 09:57
- Excel Nested IF Function 09:03
- Excel Logical Function-OR function , AND function 10:14
- How to use the XOR Function | XOR Logical Function With Example 10:16
- NOT Function in Excel | How to use NOT formula in Excel in hindi 06:38
- Rand and Randbetween Formula | How to use Rand and Randbetween Function in Excel in Hindi 09:43
- Excel - IFERROR Function | How to use IFERROR formula in excel | Hindi 09:17
- Excel Sumif Function | Sumifs formula in excel in hindi 11:25
- SUMIFS With Wildcard | Excel Sum based on Partial Text Match 07:57
- Sumifs Wildcard as Character | How to us Excel Sumifs with Wildcards characters in Formulas 10:40
- SURPRISING Sumifs Trick in Excel | SUMIFS Function Hindi 12:46
- Ms Excel - Text Functions in Hindi | How to use Text Function in Excel you need to know 13:55
- Text Function in Excel in Hindi | Best use of most used text function 08:34
- Replace and Substitute Functions | Difference between Replace and Substitute in Excel | in Hindi 10:54
- Excel's Find and Replace Advanced |Surprising Features Part-1 12:53
- How to Add Zero 00 before Numbers in Excel | Add Leading Zero in Excel in Hindi 05:47
- Excel's Find and Replace Advanced |Surprising Features Part-2 12:49
- Find and Search Functions |Difference between find and Search in Excel 09:48
- Advanced Text Function in Excel | Best use of Left, Right and Replace Function in Excel in Hindi 07:11
- Advanced Text Function in Excel | Best use of Right and Replace Function in Excel in Hindi 09:58
- Excel MID Function | How to use MID Function in Excel | Example with Explanation 13:15
- Advanced Text Function in Excel | Best use of Left , Mid , Len , Right COMBINED 09:12
- Date Functions & Formulas Part 1 | How to combine Day Month and today function 10:24
- Date Functions & Formulas Part 2 | EDATE and EOMONTH Functions in Excel 14:21
- Excel Weekday Function Part 1 | How to use the WEEKDAY Function in Excel with IF Function 10:44
- Excel Workday function: Find end date - exclude weekends & holidays | Workday and Workday.intl 11:16
- Excel Weekday Function Part 2 | How to use the WEEKDAY Function in Excel with IF Function 08:35
- Excel Date Functions : Date Value , Weeknum , Days , Days360 10:18
- DATEDIF Function | How to Calculate Age in Excel from a Date of Birth | How Old Are You? 11:51
- Statistical Function : Average , AverageA , AverageIF , AverageIFS in Excel 12:52
- TOP 5 Excel Count Formulas | How to use COUNT , COUNTA , COUNTBLANK , COUNTIF and COUNTIFS 08:19
- Excel COUNTIF Function 12 Examples of Different Criteria | Count Text , Number and Unique Occurrence 12:19
- MAX and MIN Function in Excel | How to use MAXA and MINA Function 07:04
- Excel LARGE and SMALL Functions | How to use Array Functions LARGE and SMALL in Excel 12:50
- How to Use RANK Formula in Excel in Hindi | Customized Rank in Excel | Use of RANK.AVG and RANK.EQ 11:08
- Frequency Formula in Excel in Hindi | How to use MAX and MIN with IF Formula | 10:42
- Database Functions (DSUM , DAVERAGE , DCOUNT , DMAX , DMIN , DPRODUCT) 10:44
- Excel DGET Function-VLOOKUP Problems Solved 10:01
- Information Function in Excel | ISBLANK , CELL , INFO 11:18
- Information Function in Excel | ISNUMBER , ISTEXT | VLOOKUP With ISNUMBER and ISTEXT 12:49
- SHEET and SHEETS Functions in Excel | Information Functions 10:59
- How to use ISEVEN and ISODD in Excel | ISFORMULA Function and ISLOGICAL Function in Excel 10:53
- EXCEL ERROR WORLD -Part 1 | LIVE EXAMPLES 11:26
- EXCEL ERROR WORLD Part 2 | LIVE EXAMPLES 13:56
- EXCEL ERROR HANDLER | Error Handling in Excel 10:13
- Excel SECURITY | How to Protect Worksheet , Workbook , Lock cells and hide Formula in Excel | Hindi 08:33
- Excel Printing Tips | How to Print in Excel | Page Setup , Page Layout , Margins , Custom Header 08:34
- Excel Goto Special | Selection tips to use Goto Special options in Hindi | Fill Blank Tricks 15:10
- FORMULA AUDITING in Excel | How to Track Changes in Excel 11:26
- Naming Ranges in Excel : Part-1 | Ms Excel - Name Range 10:10
- Naming Ranges in Excel in hindi | Part-2 | Ms Excel - Name Range 11:42
- Interview Capsule- Basic Excel Revision -Part1 38:09
- Interview Capsule- Basic Excel Revision -Part2 41:15
- Normal and Advanced Sorting in excel | Ms - Excel Data Sorting 07:51
- Custom and horizontal sort in Excel | Ms Excel - Data Sorting 11:52
- Filter and Color Sorting in Excel | Ms Excel - Data Sort 05:35
- Bold,Italic and Underline Sorting in Excel | Ms - Excel Data Sorting 05:26
- Alternate Sorting and Magical Tips | Ms Excel - Data Sorting 05:03
- Upper , Lower and Proper Case Sorting | Ms Excel Data Sorting 05:16
- Auto Filter in Excel | Ms Excel - Filtering Data 13:55
- Custom Filter in Excel | Ms Excel - Filtering Data 09:04
- Wildcard Filter in Excel | Ms Excel - Data Filtering 04:14
- ReApply Filter in Excel | Ms Excel Filtering Data 03:49
- Color , Bold , Italic and Underline Filter | Ms Excel - Filtering Data 07:16
- Show only Number , Text and Special Character Filter | Ms Excel - Filtering Data 06:20
- Advance Filter in Excel | Ms Excel - Filtering Data 08:05
- Advanced Filter Multiple Criteria | Ms Excel - Filtering Data 05:19
- Advanced Filter with Formula | Ms Excel - Filtering Data 06:21
- SUBTOTAL Function in Excel | How to use Subtotal in Excel Explanation with Examples in Hindi 15:59
- Multi Level SUBTOTAL in Excel | How to Create Nested Subtotal in Excel 13:31
- Subtotal Grouping | Dynamic Subtotal | How to use Excel Group Ungroup Subtotal in Hindi 08:03
- Text to Columns in Excel Part 1| How to Split Multiple Lines in a Cell into a Separate Columns 13:22
- Text to Columns in Excel Part 2 | Delimited and Fixed Width Text to Columns in Excel 09:29
- DATA Validation in Excel Part 1| How to use Data Validation option for Whole Numbers an Error Alert 12:32
- Data Validation and Drop Down List | Auto updating Drop Down List in Excel | Circle Invalid Data 13:58
- Excel Custom Data Validation | Use formula to check for text , numbers ,len , Weekday, Pattern 10:19
- Excel Custom Data Validation | Use formula to check for Weekend , Leadspace ,NoSpace ,Duplicate 10:38
- Data Validation And Conditional Formatting | Excel Drop Down List including cell color change 08:29
- Excel Financial Function PMT Explained in Hindi with Example 10:17
- Excel Goal Seek Explained with Example 13:44
- Excel Solver Example and step by step explanation in hindi 10:06
- HyperLinks in Excel Function and Feature 14:19
- Scenario Manager in Excel | Excel What IF Analysis 16:17
- 3D SUM in Excel | Consolidate Data 3D Sum Explained with Example in hindi 07:54
- Data consolidation in Excel | Ms Excel - Consolidation 11:41
- Working with external data in excel | How to import external data in excel 10:50
- Link multiple file into one-Existing Connection in excel in hindi 08:55
- One Variable Data Table in Excel in hindi 11:06
- Two Variable Data Table in Excel in Hindi 12:25
- Excel Financial Functions | How to use PMT, IPMT, PPMT, FV in Hindi 11:36
- Excel Array Formula: Mastering Excel Array Formulas 10:57
- Excel Array Formula : Frequency Function in Excel | Transpose Function | in Hindi 08:31
- Excel Array Formula: Mastering Excel Array Formulas | Max | Large | LEN Array Function Hindi 09:52
- Excel Array Formula : Constructing Array with Condition | in Hindi 10:09
- Flash Fill in Excel | Time Saving Excel Flash Fill for Data Cleaning Tricks in Excel 09:36
- Mastering Excel's SUMPRODUCT Formula 12:21
- Excel Flash Fill | Data Cleaning Tricks in Excel 08:18
- Mastering Excel's SUMPRODUCT Formula | Advantage SUMPRODUCT vs STANDARD Formula Part 1 07:55
- Mastering Excel's SUMPRODUCT Formula | Advantage SUMPRODUCT vs STANDARD Formula Part 2 08:20
- Mastering Excel's SUMPRODUCT Formula | Advantage SUMPRODUCT vs STANDARD Formula Part 3 12:42
- Excel SUM between DATES | How to Sum between dates using SUMIFS and SUMPRODUCT 09:10
- Mastering Excel's SUMPRODUCT Formula vs others-COUNT, COUNTA, COUNTIF, COUNTIFS, SUM, SUMIF, SUMIFS 09:59
- Mastering Excel's SUMPRODUCT Formula vs others-AVERAGE, AVERAGEIF, AVERAGEIFS 08:34
- Mastering Excel's SUMPRODUCT Formula vs others-MAX,MAX Multiple Criteria 07:00
- SUMPRODUCT vs COUNTIF | Excel Real Time Case Study | Advantage of Sumproduct over Countif Formula 08:59
- RANKIF Function | Ranking with Condition using SUMPRODUCT| Customized Rank in Excel 11:54
- Excel SUMPRODUCT | Sum of Top 3 Number Criteria Based 08:17
- Sum of Digits in a Number using Sumproduct Formulas 11:08
- Quarterly Totals from Monthly Data | Sumproduct and Pivot Table 06:58
- IF and ARRAY in Excel - Relationship | One to one | One to Many | Many to Many 05:25
- VLOOKUP EXPLAINED | Vlookup Simply explained with vlookup formula example in Hindi 10:31
- Vlookup with Exact Match | Vlookup Approximate Match | Hindi 05:46
- IF or VLOOKUP | If Condition vs Vlookup |Vlookup with IF Formula in Excel in Hindi 09:05
- Vlookup Optimization | Vlookup with other Functions in Hindi 10:11
- Vlookup with IF Formula | How to use if and vlookup functions together in excel in Hindi 12:14
- Vlookup to Get Complete Record | Column , Columns | Lookup Full Record 15:37
- Vlookup to Get Complete Record | Row , Rows | Lookup Full Record 09:53
- Double Vlookup | How to use Double Vlookup in Excel in Hindi | Nested Vlookup | Multiple Vlookup 08:45
- Vlookup an Empty Cell | If Lookup Cell is BLANK then...Vlookup MagicTrick in hindi 09:46
- VLOOKUP with two lookup Values | Multiple Criteria in Lookup | Multilookup in hindi 08:07
- HLOOKUP Explained With Examples | Basics of Hlookup in excel with example in Hindi 09:05
- Hlookup in Excel with Puzzle Example in Hindi | Hlookup with Columns and Rows 12:19
- VLOOKUP and HLOOKUP Combined | How to use Vlookup and Hlookup Formula together in Excel in Hindi 07:43
- Vlookup with Sumproduct | Hlookup with Sumproduct 10:00
- How to use VLOOKUP with MATCH Function in Excel | How to use MATCH Formula in Excel | 2D LOOKUP 12:42
- VLOOKUP with MATCH Function in Excel | How to use MATCH Formula with VLOOKUP in Excel | 2D LOOKUP 11:01
- vlookup with IF Formula in Excel | How to use IF and Vlookup functions together in Excel 11:30
- INDEX Function Explained (An Alternative to VLOOKUP) | How to use Excel Index - the right way 13:05
- How to use Excel Index Match | Index + Match Function Example Series Best Explanation in Hindi 09:11
- Index Match Formula - Reference & Area to Lookup Answer From 3 Different Tables | Part-1 Hindi 15:08
- Index Match Formula - Reference & Area to Lookup Answer From 3 Different Tables | Part-2 Hindi 14:51
- Excel Picture Lookup | How to create Image Lookup with Index & Match Functions 08:57
- INDEX & MATCH - One Way Lookup in Excel One Way Lookup Formula & Conditional Formatting 14:36
- Index & Match Functions- Excel Two Way Lookup using Index & Match & Conditional Formatting 15:46
- Index & Match Functions- Excel Three Way Lookup using Index & Match & Conditional Formatting 15:57
- Two Way Lookup Multiple Methods | Vlookup with Match , Index & Match , Sumproduct and Naming Range 05:45
- Excel CHOOSE Function Explained | How to use the Powerful Choose Formula in Excel in Hindi 10:37
- Excel CHOOSE FUNCTION - Things you are allowed to lookup | Part-1 Hindi 10:04
- Excel CHOOSE FUNCTION - Things you are allowed to lookup | Part-2 Hindi 15:18
- Excel CHOOSE FUNCTION | Best use of Choose Function with SUM and WEEKDAY Function | in Hindi 07:47
- Excel CHOOSE FUNCTION | How to use VLOOKUP with Choose Function without Helper Column | Hindi 10:23
- Excel CHOOSE FUNCTION | VLOOKUP To The LEFT | HLOOKUP To The TOP 07:21
- Excel INDIRECT Function Explained | Step by Step Excel INDIRECT Tutorial in Hindi 14:03
- Excel INDIRECT Function Sheet References | How to use INDIRECT to Reference Sheets 09:30
- Excel INDIRECT Function Wildcards for Sheet References | How to use wildcards and INDIRECT Function 08:45
- Excel INDIRECT Function-How to get value of last row and last column of a table 09:11
- Excel VLOOKUP with INDIRECT Function in Hindi | Use INDIRECT to Reference sheets within VLOOKUP 10:04
- INDIRECT Dependent Dynamic Drop Down List | How to create Dynamic Drop-Down List in Excel 12:35
- Excel INDIRECT Function - Transfer Record from One sheet to Multiple Sheets | Case Study 13:09
- Vlookup Second Match | Use Vlookup and Indirect to find the 2nd Match or nth match in Excel 12:08
- Reverse Transpose using INDIRECT Function | Ways to Transpose (Reverse or flip) Excel Data 10:49
- EXCEL ADDRESS FUNCTION Explained | How to use Address Function in Excel 08:20
- ADDRESS Function With INDIRECT | Data Consolidation using Reference Function in Excel 07:54
- ADDRESS Function with VLOOKUP and INDIRECT | How to use ADDRESS Function in Excel 10:10
- Excel OFFSET Function Explained Step by Step | Offset Functions for Dynamic Calculations in Hindi 13:31
- Excel OFFSET Function DYNAMIC Range | How to use Excel Offset Function for Dynamic Calculations 13:46
- Excel OFFSET Function for DYNAMIC Calculations | OFFSET Function Dynamic Range 08:48
- Excel OFFSET + MATCH Function | How to use Offset Match Formula in Excel 08:54
- Dynamic Vlookup in Excel | Make a Dynamically updated Vlookup Table in Excel using OFFSET Function 14:34
- Offset Dynamic Reference | Extract Data with Offset and Index Function in Excel 08:16
- Excel OFFSET Function for Dashboard and To Automatically Create a Report 12:09
- VLOOKUP EXTRAZ | Case Sensitive Vlookup Part 1 09:40
- VLOOKUP EXTRAZ | Case Sensitive Vlookup Part 2 08:12
- Lookup Function in Excel | Lookup vs Vlookup vs Hlookup 09:20
- Lookup Function | Lookup Vector and Result Vector |How to Find the last value in a Range 11:12
- Switch Formula in Excel | Vlookup with Switch Function 08:54
- Vlookup Challenge | Interview Oriented Questions 08:42
- Offset दोबारा | Left Lookup | Up Lookup | Double Lookup using Offset Function 10:13
- Three Way Lookup with Refine Conditional Formatting Solution 06:09
- Ms Excel - Pivot Table| Introduction Pivot table in excel in hindi 11:17
- Excel Pivot Tables Are Easy! | 5 Pivot Table Examples Explained 08:34
- Pivot Table Grouping | How to Group in Pivot Table in Hindi 09:57
- Custom Grouping in Pivot Tables | How to group a Pivot Table Manually | Hindi 06:02
- Pivot Tables Summarize Values by | Excel Pivot Tables 08:55
- Advanced Pivot Table Options in Excel | 18:34
- Pivot Table Show Value as : % Grand Total , % Column Total , % Row Total Calculations 11:28
- Pivot Table Show Value as : % Parent Total, % Parent Row Total, Difference From,Running Total, Rank 20:22
- Filter vs Slicer | Pivot Table Slicer and Timeline | Using Excel Slicers to Filter Data 12:06
- Excel Pivot Table Calculated Fields and Calculated Items | How to add a calculated field to a pivot 15:19
- consolidate multiple worksheet into one pivot table | How to combine multiple worksheet into one 09:36
- Dynamic Pivot Table | Dynamic Range for a Pivot Table using the Offset Function 12:38
- Auto Refresh Pivot Table | How to Refresh Pivot Table automatically when source data changes Excel 12:28
- Excel GetPivotData function | Use GetPivotData Function to Pull Values from Pivot Table 10:37
- Advanced Pivot Table Relationship -Part-1 | Combining Data from Multiple Sheets in Excel 10:42
- Advanced Pivot Table Relationship -Part-2 | Combining Data from Multiple Sheets in Excel 10:05
- Pivot Table Multisheet | Microsoft Power Query | Combine sheets with Excel Power Query 15:34
- Pivot Table Multiple Workbook | Create a Pivot Table from Multiple Workbooks | Excel Power Query 19:13
- Pivot Table Productivity Super Tricks in Excel 11:29
- How to Unpivot Data in Excel using Pivot Table Method 08:12
- Excel Charts and Graphs | How to make a chart or Graph in Excel in Hindi | Chart Basics Explained 10:30
- Excel Column Chart | Stacked and Clustered | Combo Chart 09:07
- Excel Bar Chart | Line Chart | How to make Bar Graph in Excel | How to make a Line Graph in Excel 07:04
- How to Make a PIE Chart and DOUGHNUT in Excel | Interactive 3D PIE Chart 09:45
- Histogram Chart | Box and Whisker Chart | How to make a Histogram in Excel | Box and Whisker Plots 12:01
- Excel Charts | Combo Chart , Scatter Chart, Bubble Chart and Map Chart 06:26
- Excel Charts | Stock Chart , Surface Chart and Radar Chart 06:41
- Excel Charts | Treemap Chart , Sunburst Chart , Funnel Chart and Waterfall Chart 07:11
- Excel Dynamic Chart with Dynamic Label 10:26
- Infographics: Progress Circle Chart in Excel | Doughnut Chart for Excel Dashboard 08:05
- Create Speedometer Chart in Excel | Excel Chart and Infographics 11:28
- Vertical Bullet Chart in Excel 08:42
- How to build interactive Excel Dashboards Explained | 5 Design tips for better dashboard 06:34
- Dashboard Step by Step | How to Build Interactive Excel Dashboard | Beginners Guide In Hindi 13:31
- Dashboard Step by Step | How to Build Interactive Excel Dashboard Cont... 11:16
- Dashboard Step by Step | How to Build Interactive Excel Dashboard | Beginners Guide Mini Dashboard 11:02
- Dashboard Step by Step | How to build Interactive Excel Dashboard | Dynamic Chart in Excel 14:41
- Dashboard Step by Step | How to build Interactive Excel Dashboard | Dynamic Chart in Excel 08:41
- Dashboard Step by Step | Radio Button Example | How to build Interactive Excel Dashboard 13:02
- Dashboard Step by Step | Check Box Example | How to build Interactive Excel Dashboard 15:06
- Make Sales Dashboard in Excel Hindi | How to build interactive Sales Dashboard Step by Step 19:00
- KPI DASHBOARD in Excel-Part 1 | How to create a KPI Dashboard in Excel | Step by Step | in Hindi 19:47
- KPI DASHBOARD in Excel-Part 2 | How to create a KPI Dashboard in Excel | Step by Step | in Hindi 13:31
- Sales Dashboard Prototype | How to Create Sales Dashboard in Excel 14:27
- 👉 Do This Sales Dashboard Project & Get Hired😳 05:20
- 90% Log Excel Mein Ye 5 Galtiyaan Karte Hain 05:54
- KPI Dashboard Assignment in Excel 03:41
Take this course with you
Download the app to continue lessons from your phone anytime.
