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 Hindi13:38
- Excel User Interface Explained | Excel Introduction05:32
- JOB Oriented Career Path-Why MIS?20:14
- Excel Options | Advanced Excel Setting16:20
- Difference between Save and Save as Excel13:42
- Excel Paste Special | Every excel user must know in depth uses18:06
- Excel Cell Reference :RELATIVE REFERENCE | Ms - Excel Cell Reference11:15
- Excel Cell Reference :ABSOLUTE REFERENCE | Ms - Excel Cell Reference09:00
- Excel Cell Reference :Mixed Reference | Ms-Excel Cell Reference10:04
- Excel Cell Reference:-Mixed Reference Part-1 | Ms - Excel Cell Reference09:53
- Excel Custom Formatting Part1 | Smart ways to use custom formatting in excel09:38
- Excel Custom Formatting :Part 2 | Smart ways to use Custom Formatting08:49
- Conditional Formatting in Excel :Part 1 | Ms-Excel Advanced Conditional Formatting12:31
- Conditional Formatting in Excel :Part 2 | Ms Excel - Advanced Conditional Formatting09:35
- Conditional Formatting in Excel :Part 3 | Ms Excel - Advanced Conditional Formatting07:42
- Customized Conditional Formatting :Part 1 | Smart ways to use advanced custom conditional formatting12:34
- Formula vs Function :Part-116:19
- Customize Conditional Formatting :Part 2 | Smart ways to use advanced custom conditional formatting06:34
- Customized Conditional Formatting :Part 3 | Smart ways to use advanced custom conditional formatting05:45
- Formula vs Function :Part 206:55
- EXCEL IF FORMULA :Part 1 | Ms - Excel if function in hindi19:02
- EXCEL IF FORMULA :Part 2 | Ms - Excel if function in hindi13:02
- EXCEL IF FORMULA: Part 3 | Ms - Excel if function in hindi09:57
- Excel Nested IF Function09:03
- Excel Logical Function-OR function , AND function10:14
- How to use the XOR Function | XOR Logical Function With Example10:16
- NOT Function in Excel | How to use NOT formula in Excel in hindi06:38
- Rand and Randbetween Formula | How to use Rand and Randbetween Function in Excel in Hindi09:43
- Excel - IFERROR Function | How to use IFERROR formula in excel | Hindi09:17
- Excel Sumif Function | Sumifs formula in excel in hindi11:25
- SUMIFS With Wildcard | Excel Sum based on Partial Text Match07:57
- Sumifs Wildcard as Character | How to us Excel Sumifs with Wildcards characters in Formulas10:40
- SURPRISING Sumifs Trick in Excel | SUMIFS Function Hindi12:46
- Ms Excel - Text Functions in Hindi | How to use Text Function in Excel you need to know13:55
- Text Function in Excel in Hindi | Best use of most used text function08:34
- Replace and Substitute Functions | Difference between Replace and Substitute in Excel | in Hindi10:54
- Excel's Find and Replace Advanced |Surprising Features Part-112:53
- How to Add Zero 00 before Numbers in Excel | Add Leading Zero in Excel in Hindi05:47
- Excel's Find and Replace Advanced |Surprising Features Part-212:49
- Find and Search Functions |Difference between find and Search in Excel09:48
- Advanced Text Function in Excel | Best use of Left, Right and Replace Function in Excel in Hindi07:11
- Advanced Text Function in Excel | Best use of Right and Replace Function in Excel in Hindi09:58
- Excel MID Function | How to use MID Function in Excel | Example with Explanation13:15
- Advanced Text Function in Excel | Best use of Left , Mid , Len , Right COMBINED09:12
- Date Functions & Formulas Part 1 | How to combine Day Month and today function10:24
- Date Functions & Formulas Part 2 | EDATE and EOMONTH Functions in Excel14:21
- Excel Weekday Function Part 1 | How to use the WEEKDAY Function in Excel with IF Function10:44
- Excel Workday function: Find end date - exclude weekends & holidays | Workday and Workday.intl11:16
- Excel Weekday Function Part 2 | How to use the WEEKDAY Function in Excel with IF Function08:35
- Excel Date Functions : Date Value , Weeknum , Days , Days36010: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 Excel12:52
- TOP 5 Excel Count Formulas | How to use COUNT , COUNTA , COUNTBLANK , COUNTIF and COUNTIFS08:19
- Excel COUNTIF Function 12 Examples of Different Criteria | Count Text , Number and Unique Occurrence12:19
- MAX and MIN Function in Excel | How to use MAXA and MINA Function07:04
- Excel LARGE and SMALL Functions | How to use Array Functions LARGE and SMALL in Excel12:50
- How to Use RANK Formula in Excel in Hindi | Customized Rank in Excel | Use of RANK.AVG and RANK.EQ11: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 Solved10:01
- Information Function in Excel | ISBLANK , CELL , INFO11:18
- Information Function in Excel | ISNUMBER , ISTEXT | VLOOKUP With ISNUMBER and ISTEXT12:49
- SHEET and SHEETS Functions in Excel | Information Functions10:59
- How to use ISEVEN and ISODD in Excel | ISFORMULA Function and ISLOGICAL Function in Excel10:53
- EXCEL ERROR WORLD -Part 1 | LIVE EXAMPLES11:26
- EXCEL ERROR WORLD Part 2 | LIVE EXAMPLES13:56
- EXCEL ERROR HANDLER | Error Handling in Excel10:13
- Excel SECURITY | How to Protect Worksheet , Workbook , Lock cells and hide Formula in Excel | Hindi08:33
- Excel Printing Tips | How to Print in Excel | Page Setup , Page Layout , Margins , Custom Header08:34
- Excel Goto Special | Selection tips to use Goto Special options in Hindi | Fill Blank Tricks15:10
- FORMULA AUDITING in Excel | How to Track Changes in Excel11:26
- Naming Ranges in Excel : Part-1 | Ms Excel - Name Range10:10
- Naming Ranges in Excel in hindi | Part-2 | Ms Excel - Name Range11:42
- Interview Capsule- Basic Excel Revision -Part138:09
- Interview Capsule- Basic Excel Revision -Part241:15
- Normal and Advanced Sorting in excel | Ms - Excel Data Sorting07:51
- Custom and horizontal sort in Excel | Ms Excel - Data Sorting11:52
- Filter and Color Sorting in Excel | Ms Excel - Data Sort05:35
- Bold,Italic and Underline Sorting in Excel | Ms - Excel Data Sorting05:26
- Alternate Sorting and Magical Tips | Ms Excel - Data Sorting05:03
- Upper , Lower and Proper Case Sorting | Ms Excel Data Sorting05:16
- Auto Filter in Excel | Ms Excel - Filtering Data13:55
- Custom Filter in Excel | Ms Excel - Filtering Data09:04
- Wildcard Filter in Excel | Ms Excel - Data Filtering04:14
- ReApply Filter in Excel | Ms Excel Filtering Data03:49
- Color , Bold , Italic and Underline Filter | Ms Excel - Filtering Data07:16
- Show only Number , Text and Special Character Filter | Ms Excel - Filtering Data06:20
- Advance Filter in Excel | Ms Excel - Filtering Data08:05
- Advanced Filter Multiple Criteria | Ms Excel - Filtering Data05:19
- Advanced Filter with Formula | Ms Excel - Filtering Data06:21
- SUBTOTAL Function in Excel | How to use Subtotal in Excel Explanation with Examples in Hindi15:59
- Multi Level SUBTOTAL in Excel | How to Create Nested Subtotal in Excel13:31
- Subtotal Grouping | Dynamic Subtotal | How to use Excel Group Ungroup Subtotal in Hindi08:03
- Text to Columns in Excel Part 1| How to Split Multiple Lines in a Cell into a Separate Columns13:22
- Text to Columns in Excel Part 2 | Delimited and Fixed Width Text to Columns in Excel09:29
- DATA Validation in Excel Part 1| How to use Data Validation option for Whole Numbers an Error Alert12:32
- Data Validation and Drop Down List | Auto updating Drop Down List in Excel | Circle Invalid Data13:58
- Excel Custom Data Validation | Use formula to check for text , numbers ,len , Weekday, Pattern10:19
- Excel Custom Data Validation | Use formula to check for Weekend , Leadspace ,NoSpace ,Duplicate10:38
- Data Validation And Conditional Formatting | Excel Drop Down List including cell color change08:29
- Excel Financial Function PMT Explained in Hindi with Example10:17
- Excel Goal Seek Explained with Example13:44
- Excel Solver Example and step by step explanation in hindi10:06
- HyperLinks in Excel Function and Feature14:19
- Scenario Manager in Excel | Excel What IF Analysis16:17
- 3D SUM in Excel | Consolidate Data 3D Sum Explained with Example in hindi07:54
- Data consolidation in Excel | Ms Excel - Consolidation11:41
- Working with external data in excel | How to import external data in excel10:50
- Link multiple file into one-Existing Connection in excel in hindi08:55
- One Variable Data Table in Excel in hindi11:06
- Two Variable Data Table in Excel in Hindi12:25
- Excel Financial Functions | How to use PMT, IPMT, PPMT, FV in Hindi11:36
- Excel Array Formula: Mastering Excel Array Formulas10:57
- Excel Array Formula : Frequency Function in Excel | Transpose Function | in Hindi08:31
- Excel Array Formula: Mastering Excel Array Formulas | Max | Large | LEN Array Function Hindi09:52
- Excel Array Formula : Constructing Array with Condition | in Hindi10:09
- Flash Fill in Excel | Time Saving Excel Flash Fill for Data Cleaning Tricks in Excel09:36
- Mastering Excel's SUMPRODUCT Formula12:21
- Excel Flash Fill | Data Cleaning Tricks in Excel08:18
- Mastering Excel's SUMPRODUCT Formula | Advantage SUMPRODUCT vs STANDARD Formula Part 107:55
- Mastering Excel's SUMPRODUCT Formula | Advantage SUMPRODUCT vs STANDARD Formula Part 208:20
- Mastering Excel's SUMPRODUCT Formula | Advantage SUMPRODUCT vs STANDARD Formula Part 312:42
- Excel SUM between DATES | How to Sum between dates using SUMIFS and SUMPRODUCT09:10
- Mastering Excel's SUMPRODUCT Formula vs others-COUNT, COUNTA, COUNTIF, COUNTIFS, SUM, SUMIF, SUMIFS09:59
- Mastering Excel's SUMPRODUCT Formula vs others-AVERAGE, AVERAGEIF, AVERAGEIFS08:34
- Mastering Excel's SUMPRODUCT Formula vs others-MAX,MAX Multiple Criteria07:00
- SUMPRODUCT vs COUNTIF | Excel Real Time Case Study | Advantage of Sumproduct over Countif Formula08:59
- RANKIF Function | Ranking with Condition using SUMPRODUCT| Customized Rank in Excel11:54
- Excel SUMPRODUCT | Sum of Top 3 Number Criteria Based08:17
- Sum of Digits in a Number using Sumproduct Formulas11:08
- Quarterly Totals from Monthly Data | Sumproduct and Pivot Table06:58
- IF and ARRAY in Excel - Relationship | One to one | One to Many | Many to Many05:25
- VLOOKUP EXPLAINED | Vlookup Simply explained with vlookup formula example in Hindi10:31
- Vlookup with Exact Match | Vlookup Approximate Match | Hindi05:46
- IF or VLOOKUP | If Condition vs Vlookup |Vlookup with IF Formula in Excel in Hindi09:05
- Vlookup Optimization | Vlookup with other Functions in Hindi10:11
- Vlookup with IF Formula | How to use if and vlookup functions together in excel in Hindi12:14
- Vlookup to Get Complete Record | Column , Columns | Lookup Full Record15:37
- Vlookup to Get Complete Record | Row , Rows | Lookup Full Record09:53
- Double Vlookup | How to use Double Vlookup in Excel in Hindi | Nested Vlookup | Multiple Vlookup08:45
- Vlookup an Empty Cell | If Lookup Cell is BLANK then...Vlookup MagicTrick in hindi09:46
- VLOOKUP with two lookup Values | Multiple Criteria in Lookup | Multilookup in hindi08:07
- HLOOKUP Explained With Examples | Basics of Hlookup in excel with example in Hindi09:05
- Hlookup in Excel with Puzzle Example in Hindi | Hlookup with Columns and Rows12:19
- VLOOKUP and HLOOKUP Combined | How to use Vlookup and Hlookup Formula together in Excel in Hindi07:43
- Vlookup with Sumproduct | Hlookup with Sumproduct10:00
- How to use VLOOKUP with MATCH Function in Excel | How to use MATCH Formula in Excel | 2D LOOKUP12:42
- VLOOKUP with MATCH Function in Excel | How to use MATCH Formula with VLOOKUP in Excel | 2D LOOKUP11:01
- vlookup with IF Formula in Excel | How to use IF and Vlookup functions together in Excel11:30
- INDEX Function Explained (An Alternative to VLOOKUP) | How to use Excel Index - the right way13:05
- How to use Excel Index Match | Index + Match Function Example Series Best Explanation in Hindi09:11
- Index Match Formula - Reference & Area to Lookup Answer From 3 Different Tables | Part-1 Hindi15:08
- Index Match Formula - Reference & Area to Lookup Answer From 3 Different Tables | Part-2 Hindi14:51
- Excel Picture Lookup | How to create Image Lookup with Index & Match Functions08:57
- INDEX & MATCH - One Way Lookup in Excel One Way Lookup Formula & Conditional Formatting14:36
- Index & Match Functions- Excel Two Way Lookup using Index & Match & Conditional Formatting15:46
- Index & Match Functions- Excel Three Way Lookup using Index & Match & Conditional Formatting15:57
- Two Way Lookup Multiple Methods | Vlookup with Match , Index & Match , Sumproduct and Naming Range05:45
- Excel CHOOSE Function Explained | How to use the Powerful Choose Formula in Excel in Hindi10:37
- Excel CHOOSE FUNCTION - Things you are allowed to lookup | Part-1 Hindi10:04
- Excel CHOOSE FUNCTION - Things you are allowed to lookup | Part-2 Hindi15:18
- Excel CHOOSE FUNCTION | Best use of Choose Function with SUM and WEEKDAY Function | in Hindi07:47
- Excel CHOOSE FUNCTION | How to use VLOOKUP with Choose Function without Helper Column | Hindi10:23
- Excel CHOOSE FUNCTION | VLOOKUP To The LEFT | HLOOKUP To The TOP07:21
- Excel INDIRECT Function Explained | Step by Step Excel INDIRECT Tutorial in Hindi14:03
- Excel INDIRECT Function Sheet References | How to use INDIRECT to Reference Sheets09:30
- Excel INDIRECT Function Wildcards for Sheet References | How to use wildcards and INDIRECT Function08:45
- Excel INDIRECT Function-How to get value of last row and last column of a table09:11
- Excel VLOOKUP with INDIRECT Function in Hindi | Use INDIRECT to Reference sheets within VLOOKUP10:04
- INDIRECT Dependent Dynamic Drop Down List | How to create Dynamic Drop-Down List in Excel12:35
- Excel INDIRECT Function - Transfer Record from One sheet to Multiple Sheets | Case Study13:09
- Vlookup Second Match | Use Vlookup and Indirect to find the 2nd Match or nth match in Excel12:08
- Reverse Transpose using INDIRECT Function | Ways to Transpose (Reverse or flip) Excel Data10:49
- EXCEL ADDRESS FUNCTION Explained | How to use Address Function in Excel08:20
- ADDRESS Function With INDIRECT | Data Consolidation using Reference Function in Excel07:54
- ADDRESS Function with VLOOKUP and INDIRECT | How to use ADDRESS Function in Excel10:10
- Excel OFFSET Function Explained Step by Step | Offset Functions for Dynamic Calculations in Hindi13:31
- Excel OFFSET Function DYNAMIC Range | How to use Excel Offset Function for Dynamic Calculations13:46
- Excel OFFSET Function for DYNAMIC Calculations | OFFSET Function Dynamic Range08:48
- Excel OFFSET + MATCH Function | How to use Offset Match Formula in Excel08:54
- Dynamic Vlookup in Excel | Make a Dynamically updated Vlookup Table in Excel using OFFSET Function14:34
- Offset Dynamic Reference | Extract Data with Offset and Index Function in Excel08:16
- Excel OFFSET Function for Dashboard and To Automatically Create a Report12:09
- VLOOKUP EXTRAZ | Case Sensitive Vlookup Part 109:40
- VLOOKUP EXTRAZ | Case Sensitive Vlookup Part 208:12
- Lookup Function in Excel | Lookup vs Vlookup vs Hlookup09:20
- Lookup Function | Lookup Vector and Result Vector |How to Find the last value in a Range11:12
- Switch Formula in Excel | Vlookup with Switch Function08:54
- Vlookup Challenge | Interview Oriented Questions08:42
- Offset दोबारा | Left Lookup | Up Lookup | Double Lookup using Offset Function10:13
- Three Way Lookup with Refine Conditional Formatting Solution06:09
- Ms Excel - Pivot Table| Introduction Pivot table in excel in hindi11:17
- Excel Pivot Tables Are Easy! | 5 Pivot Table Examples Explained08:34
- Pivot Table Grouping | How to Group in Pivot Table in Hindi09:57
- Custom Grouping in Pivot Tables | How to group a Pivot Table Manually | Hindi06:02
- Pivot Tables Summarize Values by | Excel Pivot Tables08:55
- Advanced Pivot Table Options in Excel |18:34
- Pivot Table Show Value as : % Grand Total , % Column Total , % Row Total Calculations11:28
- Pivot Table Show Value as : % Parent Total, % Parent Row Total, Difference From,Running Total, Rank20:22
- Filter vs Slicer | Pivot Table Slicer and Timeline | Using Excel Slicers to Filter Data12:06
- Excel Pivot Table Calculated Fields and Calculated Items | How to add a calculated field to a pivot15:19
- consolidate multiple worksheet into one pivot table | How to combine multiple worksheet into one09:36
- Dynamic Pivot Table | Dynamic Range for a Pivot Table using the Offset Function12:38
- Auto Refresh Pivot Table | How to Refresh Pivot Table automatically when source data changes Excel12:28
- Excel GetPivotData function | Use GetPivotData Function to Pull Values from Pivot Table10:37
- Advanced Pivot Table Relationship -Part-1 | Combining Data from Multiple Sheets in Excel10:42
- Advanced Pivot Table Relationship -Part-2 | Combining Data from Multiple Sheets in Excel10:05
- Pivot Table Multisheet | Microsoft Power Query | Combine sheets with Excel Power Query15:34
- Pivot Table Multiple Workbook | Create a Pivot Table from Multiple Workbooks | Excel Power Query19:13
- Pivot Table Productivity Super Tricks in Excel11:29
- How to Unpivot Data in Excel using Pivot Table Method08:12
- Excel Charts and Graphs | How to make a chart or Graph in Excel in Hindi | Chart Basics Explained10:30
- Excel Column Chart | Stacked and Clustered | Combo Chart09:07
- Excel Bar Chart | Line Chart | How to make Bar Graph in Excel | How to make a Line Graph in Excel07:04
- How to Make a PIE Chart and DOUGHNUT in Excel | Interactive 3D PIE Chart09:45
- Histogram Chart | Box and Whisker Chart | How to make a Histogram in Excel | Box and Whisker Plots12:01
- Excel Charts | Combo Chart , Scatter Chart, Bubble Chart and Map Chart06:26
- Excel Charts | Stock Chart , Surface Chart and Radar Chart06:41
- Excel Charts | Treemap Chart , Sunburst Chart , Funnel Chart and Waterfall Chart07:11
- Excel Dynamic Chart with Dynamic Label10:26
- Infographics: Progress Circle Chart in Excel | Doughnut Chart for Excel Dashboard08:05
- Create Speedometer Chart in Excel | Excel Chart and Infographics11:28
- Vertical Bullet Chart in Excel08:42
- How to build interactive Excel Dashboards Explained | 5 Design tips for better dashboard06:34
- Dashboard Step by Step | How to Build Interactive Excel Dashboard | Beginners Guide In Hindi13: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 Dashboard11:02
- Dashboard Step by Step | How to build Interactive Excel Dashboard | Dynamic Chart in Excel14:41
- Dashboard Step by Step | How to build Interactive Excel Dashboard | Dynamic Chart in Excel08:41
- Dashboard Step by Step | Radio Button Example | How to build Interactive Excel Dashboard13:02
- Dashboard Step by Step | Check Box Example | How to build Interactive Excel Dashboard15:06
- Make Sales Dashboard in Excel Hindi | How to build interactive Sales Dashboard Step by Step19:00
- KPI DASHBOARD in Excel-Part 1 | How to create a KPI Dashboard in Excel | Step by Step | in Hindi19:47
- KPI DASHBOARD in Excel-Part 2 | How to create a KPI Dashboard in Excel | Step by Step | in Hindi13:31
- Sales Dashboard Prototype | How to Create Sales Dashboard in Excel14:27
- 👉 Do This Sales Dashboard Project & Get Hired😳05:20
- 90% Log Excel Mein Ye 5 Galtiyaan Karte Hain05:54
- KPI Dashboard Assignment in Excel03:41
