A Second Dose of MS Excel

In this post I would like to share a few more videos that I have created to illustrate some other interesting Excel concepts.  The focus of the tutorials featured in this post is to connect the dots by tying basic concepts and using them in real life scenarios.So here is the second dose of MS Excel:

 Video Tutorial 6: Using VLOOKUP to create Business Reports

Real life scenario and use case: You have lots of data in your spreadsheets and you want to create summary reports pulling out relevant data items from these sheets. Using the VLOOKUP function and concepts in Video 8, you can create many useful business reports. This shows an interesting practical use of the VLOOKUP function and why it is so sought after by 'Excellers' .

Video Tutorial 7:  Data Consolidation in MS Excel

Real life scenario and use case : You have many offices or branches and each office sends you data in different Excel workbooks by email. Using the consolidation tool in Excel, you can summarize data in these different sheets & workbooks on one sheet. A great skill to learn that can save you hours of work!

Video Tutorial 8: Tables and Data Validation Using Dynamic Lists

Real life scenario and use case: You want to provide users with drop down lists to select data making sure that as data is added to your sheet, the drop down continues including the newly entered data and this list keep dynamically evolving.  We will use the concepts in this video to great effect in the next tutorial to create interesting business reports. 

Video Tutorial 9: Entering, Modifying and Deleting Data Using Forms

Real life scenario and use case : You have a huge sheet and you want to enter, modify or delete data cleanly without scrolling up, down, left or right in those humongous spreadsheets. This easy trick shows you how.

Hope you enjoyed these video lessons. There is a lot more to know and I am sure these short tutorials will motivate you to keep learning !

😊