Technical Portal

@UCyfJfNkbrn8E-AV4q2Kucdw - 4.8K subscribers

Thank you for giving so much love and support to my channel.. My only intention is to see you learn and enjoy your learning..!! Facilities of joining this Channel: • In this channel MS Excel Tutorial will be taught from basic • Our team will support you every time you need help • Video will be uploaded regular and in a fixed time • We have a project timeline and you’ll get videos of MS Excel Tutorial • Lots of tutorial videos are coming soon • We tried our best to make our videos easy to understand, but in case if you have any queries, please get in touch with us. • In each video you will be provided the data file or any supportive objects in the description. • Some essential study material will be provided and quiz will be played for Self-learning initiative. This Channel is not only for MS Excel Tutorials, tons of surprises and amazing stuffs are coming soon. Support my channel..!! Happy Learning..!!

Home Videos Live Playlists

Unknown Tech Factz | Episode #1 | Interesting Facts about IOT : Internet Of Things |

Unknown Tech Factz | Episode #1 | Interesting Facts about IOT : Internet Of Things | Technical Portal

999 views - 5 years ago

| ANNOUNCEMENT | A Big Announcement About The Upcoming Videos For You |

| ANNOUNCEMENT | A Big Announcement About The Upcoming Videos For You | Technical Portal

271 views - 5 years ago

Microsoft Excel Easy Tutorial : Extract data from Parenthesis - Easy VBA Solution

Microsoft Excel Easy Tutorial : Extract data from Parenthesis - Easy VBA Solution Technical Portal

1.5K views - 5 years ago

Microsoft Excel Easy Tutorial | Delete All Decimals In A Click | Ready to Use VBA Code |

Microsoft Excel Easy Tutorial | Delete All Decimals In A Click | Ready to Use VBA Code | Technical Portal

561 views - 5 years ago

Replace Blank cells with required text using VBA | Excel Ready To Use VBA Short Code |

Replace Blank cells with required text using VBA | Excel Ready To Use VBA Short Code | Technical Portal

2.4K views - 5 years ago

Find And Extract all Partial Matches from database range | Excel Array Function 2021|

Find And Extract all Partial Matches from database range | Excel Array Function 2021| Technical Portal

1.6K views - 5 years ago

How to extract Date or Time from a Datetime value in Excel | Split cells in Excel |

How to extract Date or Time from a Datetime value in Excel | Split cells in Excel | Technical Portal

1.9K views - 5 years ago

Automatically update Pivot Table when source data changes using VBA | Excel Pivot Table Tricks |

Automatically update Pivot Table when source data changes using VBA | Excel Pivot Table Tricks | Technical Portal

2K views - 5 years ago

10 Ways to Group Pivot Report as per Date value | MS Excel Pivot Table & Dashboards | Part - 4.1 |

10 Ways to Group Pivot Report as per Date value | MS Excel Pivot Table & Dashboards | Part - 4.1 | Technical Portal

718 views - 5 years ago

MS Excel Pivot Table and Dashboards Tutorial | Get Percentage Value Automatically | Part - 5.1 |

MS Excel Pivot Table and Dashboards Tutorial | Get Percentage Value Automatically | Part - 5.1 | Technical Portal

535 views - 5 years ago

MS Excel Pivot Table and Dashboard Tutorial | Learn Pivot Table | Group & Organize Data | Part-4.0 |

MS Excel Pivot Table and Dashboard Tutorial | Learn Pivot Table | Group & Organize Data | Part-4.0 | Technical Portal

945 views - 6 years ago

MS Excel Pivot Table and Dashboard Tutorial | Learn Pivot Table | Automated Pivot table | Part - 3 |

MS Excel Pivot Table and Dashboard Tutorial | Learn Pivot Table | Automated Pivot table | Part - 3 | Technical Portal

743 views - 6 years ago

MS Excel Pivot Table and Dashboard Tutorial | Learn Pivot Table | Dynamic Data Source | Part - 2.1 |

MS Excel Pivot Table and Dashboard Tutorial | Learn Pivot Table | Dynamic Data Source | Part - 2.1 | Technical Portal

655 views - 6 years ago

MS Excel Pivot Table and Dashboards Tutorial | Learn Pivot Table Easily | Data Slicer | Part - 2 |

MS Excel Pivot Table and Dashboards Tutorial | Learn Pivot Table Easily | Data Slicer | Part - 2 | Technical Portal

1.3K views - 6 years ago

MS Excel Pivot Table and Dashboards Tutorial | Learn Pivot Table Easily | Tips & Tricks | Part - 1 |

MS Excel Pivot Table and Dashboards Tutorial | Learn Pivot Table Easily | Tips & Tricks | Part - 1 | Technical Portal

8.5K views - 6 years ago

🔴 INDEX and MATCH in Excel with multiple criteria tricks | Excel Tips & Tricks 2021 |

🔴 INDEX and MATCH in Excel with multiple criteria tricks | Excel Tips & Tricks 2021 | Technical Portal

995 views - 6 years ago

Get the 2nd, 3rd or the Nth Match value without Vlookup or Index Match Function | Easy Tricks |

Get the 2nd, 3rd or the Nth Match value without Vlookup or Index Match Function | Easy Tricks | Technical Portal

593 views - 6 years ago

MS Excel Pivot Table & Dashboard Creation Trailer | Upcoming Video Details |

MS Excel Pivot Table & Dashboard Creation Trailer | Upcoming Video Details | Technical Portal

3.3K views - 6 years ago

Microsoft Excel | How to use Index Match function with Date as criteria | Index Match Function |

Microsoft Excel | How to use Index Match function with Date as criteria | Index Match Function | Technical Portal

18K views - 6 years ago

Microsoft Excel| Extract Multiple matches in separate Columns| Without VBA | Index Match | Part-2 |

Microsoft Excel| Extract Multiple matches in separate Columns| Without VBA | Index Match | Part-2 | Technical Portal

2.8K views - 6 years ago

Microsoft Excel | Extract Multiple matches in separate Rows | Without VBA | Index Match | Part - 1 |

Microsoft Excel | Extract Multiple matches in separate Rows | Without VBA | Index Match | Part - 1 | Technical Portal

4.5K views - 6 years ago

Microsoft Excel Trick : Use Index Match function where lookup array is in descending order

Microsoft Excel Trick : Use Index Match function where lookup array is in descending order Technical Portal

968 views - 6 years ago

Microsoft Excel : How to Calculate Loan Interest for a Given Period | Financial Modeling |

Microsoft Excel : How to Calculate Loan Interest for a Given Period | Financial Modeling | Technical Portal

732 views - 6 years ago

Microsoft Excel | Index and Match in Excel | Nested functions based on criteria on multiple column |

Microsoft Excel | Index and Match in Excel | Nested functions based on criteria on multiple column | Technical Portal

3.7K views - 6 years ago

Microsoft Excel Easy bundle pricing with a simple Formula | Data Analysis and Handling |

Microsoft Excel Easy bundle pricing with a simple Formula | Data Analysis and Handling | Technical Portal

3K views - 6 years ago

Important method of Index and Match function in Microsoft Excel | Find and Replace required results

Important method of Index and Match function in Microsoft Excel | Find and Replace required results Technical Portal

412 views - 6 years ago

How to calculate compound interest rate in Microsoft Excel | Excel FV Function |

How to calculate compound interest rate in Microsoft Excel | Excel FV Function | Technical Portal

1.1K views - 6 years ago

How to calculate the Rate Percentage in Microsoft Excel | Excel RATE Function |

How to calculate the Rate Percentage in Microsoft Excel | Excel RATE Function | Technical Portal

10K views - 6 years ago

Everything about Hlookup Function in Excel | Vlookup and Hlookup Highlights |

Everything about Hlookup Function in Excel | Vlookup and Hlookup Highlights | Technical Portal

1.7K views - 6 years ago

What is the difference between Aggregate Subtotal and Sum function | Advantages of using AGGREGATE |

What is the difference between Aggregate Subtotal and Sum function | Advantages of using AGGREGATE | Technical Portal

1.9K views - 6 years ago

Master of all Functions: Learn to use the AGGREGATE Function in Microsoft Excel

Master of all Functions: Learn to use the AGGREGATE Function in Microsoft Excel Technical Portal

471 views - 6 years ago

How to split a value as per required percentage using Vlookup in Excel

How to split a value as per required percentage using Vlookup in Excel Technical Portal

5.5K views - 6 years ago

Most Important Methods of VLOOKUP Function to get results as required | Vlookup Tips & Tricks |

Most Important Methods of VLOOKUP Function to get results as required | Vlookup Tips & Tricks | Technical Portal

636 views - 6 years ago

Pro Microsoft Excel VBA Series | VBA ElseIF Statement | Part - 10.1 |

Pro Microsoft Excel VBA Series | VBA ElseIF Statement | Part - 10.1 | Technical Portal

250 views - 6 years ago

Pro Microsoft Excel VBA Series | VBA IF Statement and END IF Statement | Part - 10.0 |

Pro Microsoft Excel VBA Series | VBA IF Statement and END IF Statement | Part - 10.0 | Technical Portal

576 views - 6 years ago

How to Sum the top Highest or Lowest n values in a range by a criteria | Excel Tips 2021|

How to Sum the top Highest or Lowest n values in a range by a criteria | Excel Tips 2021| Technical Portal

947 views - 6 years ago

Top 5 time saving Vlookup Tips & Tricks in Microsoft Excel of 2021 | Essential ways to use Vlookup |

Top 5 time saving Vlookup Tips & Tricks in Microsoft Excel of 2021 | Essential ways to use Vlookup | Technical Portal

2.1K views - 6 years ago

How to Sum the top Highest or Lowest n values in a range | Excel Tips 2021 |

How to Sum the top Highest or Lowest n values in a range | Excel Tips 2021 | Technical Portal

370 views - 6 years ago

How to get the Last N Columns Sum value | SUM + INDEX + COLUMNS | Excel 2021 Tips |

How to get the Last N Columns Sum value | SUM + INDEX + COLUMNS | Excel 2021 Tips | Technical Portal

1.8K views - 6 years ago

How to get Two way lookup Value with INDEX and MATCH Function in Excel | Excel Tips 2021 |

How to get Two way lookup Value with INDEX and MATCH Function in Excel | Excel Tips 2021 | Technical Portal

379 views - 6 years ago

How to do 3D SUMIF for multiple worksheets | #Errorfree 2021 Tips|

How to do 3D SUMIF for multiple worksheets | #Errorfree 2021 Tips| Technical Portal

3.8K views - 6 years ago

How to Sum every nth column? | SUMPRODUCT + MOD + COLUMN Function in Excel | Excel Tips 2021 |

How to Sum every nth column? | SUMPRODUCT + MOD + COLUMN Function in Excel | Excel Tips 2021 | Technical Portal

6K views - 6 years ago

How to get the closest Date value in database | Index + Match with Nested Min and ABS Function |

How to get the closest Date value in database | Index + Match with Nested Min and ABS Function | Technical Portal

3.1K views - 6 years ago

Pro Microsoft Excel VBA Course | For Each Loop Through Files in Folder | VBA Example | Part - 9.6 |

Pro Microsoft Excel VBA Course | For Each Loop Through Files in Folder | VBA Example | Part - 9.6 | Technical Portal

555 views - 6 years ago

Pro Microsoft Excel VBA Course | For Each Loop VBA Example | Get Column Value | Part - 9.5 |

Pro Microsoft Excel VBA Course | For Each Loop VBA Example | Get Column Value | Part - 9.5 | Technical Portal

312 views - 6 years ago

Pro Microsoft Excel VBA Course | For Each Loop VBA Example | Get Row Value | Part-9.4 |

Pro Microsoft Excel VBA Course | For Each Loop VBA Example | Get Row Value | Part-9.4 | Technical Portal

237 views - 6 years ago

How to get the Cell Address of Lookup Value | Cell Function with Nested Index Match Function |

How to get the Cell Address of Lookup Value | Cell Function with Nested Index Match Function | Technical Portal

7.3K views - 6 years ago

Pro Microsoft Excel VBA Course | Exit Do Loop Syntax in VBA | Find Specific Value | Part - 9.3 |

Pro Microsoft Excel VBA Course | Exit Do Loop Syntax in VBA | Find Specific Value | Part - 9.3 | Technical Portal

217 views - 6 years ago

Pro Microsoft Excel VBA Course | DO UNTIL LOOP | LOOP UNTIL Syntax | Difference | Part - 9.2 |

Pro Microsoft Excel VBA Course | DO UNTIL LOOP | LOOP UNTIL Syntax | Difference | Part - 9.2 | Technical Portal

168 views - 6 years ago

Pro Microsoft Excel VBA Course | DO WHILE Loop | LOOP WHILE Syntax | Part - 9.1 |

Pro Microsoft Excel VBA Course | DO WHILE Loop | LOOP WHILE Syntax | Part - 9.1 | Technical Portal

212 views - 6 years ago

Pro Microsoft Excel VBA Course | For Each Loop with Nested IF Statement | Hide Blank Rows |Part-8.9|

Pro Microsoft Excel VBA Course | For Each Loop with Nested IF Statement | Hide Blank Rows |Part-8.9| Technical Portal

328 views - 6 years ago

How to use the SUM Function with Nested Index in Microsoft Excel to get the Total Range Value

How to use the SUM Function with Nested Index in Microsoft Excel to get the Total Range Value Technical Portal

9.2K views - 6 years ago

Excel Short VBA Code #16.2 | How to Use For Each Loop Wisely Delete All Shapes of All Worksheets |

Excel Short VBA Code #16.2 | How to Use For Each Loop Wisely Delete All Shapes of All Worksheets | Technical Portal

301 views - 6 years ago

Microsoft Excel Short VBA Code #16.1 | How to Use For Each Loop Wisely | Delete All Shapes |

Microsoft Excel Short VBA Code #16.1 | How to Use For Each Loop Wisely | Delete All Shapes | Technical Portal

338 views - 6 years ago

Pro Microsoft Excel VBA Course | For Each Loop | Loop Through Open Workbooks only | Part 8.8 |

Pro Microsoft Excel VBA Course | For Each Loop | Loop Through Open Workbooks only | Part 8.8 | Technical Portal

227 views - 6 years ago

Pro Microsoft Excel VBA Course | For Each Loop | Loop Through Workbooks & Unprotect All | Part 8.7 |

Pro Microsoft Excel VBA Course | For Each Loop | Loop Through Workbooks & Unprotect All | Part 8.7 | Technical Portal

248 views - 6 years ago

How to find Lookup Value in Multiple Table Array | Vlookup Function in Excel |

How to find Lookup Value in Multiple Table Array | Vlookup Function in Excel | Technical Portal

12K views - 6 years ago

Pro Microsoft Excel VBA Course | For Each Loop In A Cell Range | Part - 8.6 |

Pro Microsoft Excel VBA Course | For Each Loop In A Cell Range | Part - 8.6 | Technical Portal

220 views - 6 years ago

Pro Microsoft Excel VBA Course | For Next Loop | Exit For Loop | Part - 8.5 |

Pro Microsoft Excel VBA Course | For Next Loop | Exit For Loop | Part - 8.5 | Technical Portal

1.6K views - 6 years ago

Pro Microsoft Excel VBA Course | For Loop Syntax | Reverse Step Technique | Part - 8.4 |

Pro Microsoft Excel VBA Course | For Loop Syntax | Reverse Step Technique | Part - 8.4 | Technical Portal

339 views - 6 years ago