Excel Basics | For Accountants |
https://youtube.com/watch?v=ZX13uWEcaUQHi guys and welcome back to my channel. In this video I show some basics in Excel that every accountant should know. If you'd like to see more, make sure…
How To Extract Multiple Matches Into Separate Rows || Excel Tips & Tricks || dptutorials
https://youtube.com/watch?v=TjNnYGatTjoIn this tutorial let us see how to extract multiple matches into separate rows in Excel Here we will be using an array formula with a combination of Index and…
Most Important 30 Excel Tips with very simple method in Hindi
https://youtube.com/watch?v=YDVdh23aOQEThis tutorial gives you the best 30 Excel Tricks with very easy examples that makes you more understand about each trick. List of Tutorials: 1 How to Highlight the Errors…
Count Duplicate Number Sets in Excel
Written by Debra Dalgleish from Contextures Blog Recently, someone asked me how to count duplicate number sets. There were hundreds of rows, with 6 numbers in each row. Did any…
Microsoft Excel Tips : How to Create a Bar Graph From an Excel Spreadsheet
https://youtube.com/watch?v=tp5XpilgukICreate a bar graph from an Excel spreadsheet by highlighting the information and clicking chart wizard from the toolbar. Make a bar graph with Excel with tips from an assistant…
Introducing Power BI Play Date – Online class to master Power BI (oh yeah, Power Query & Power Pivot too)
Hello friends, It’s here. Power BI Play Date – my latest online training program is now ready for your consideration. Please take a few minutes to read this to know…
3 Pro Excel Tips You Need To Know
https://youtube.com/watch?v=X24lbNlmrwI3 Pro Excel Tips to make your life easier! Learn the importance of Pivot Charts and Tables, formatting data sets as Tables and an awesome way to use Text Boxes!…
INDEX and MATCH with multiple criteria || Excel Tips & Tricks || dptutorials
https://youtube.com/watch?v=nHbW_eUZ-XwIn this tutorial let us see how to use INDEX and MATCH with multiple criteria To lookup values with INDEX and MATCH, using multiple criteria we need to use an…
Tips for Using ARRAY Formulas and Functions in Excel
https://youtube.com/watch?v=F2iS8fiqLaoARRAY Formulas and Functions are very powerful. However, they do take a little bit of time to understand. In fact, several of my viewers have asked me to break-down the…