Create a Loop for a series of items in Excel | No VBA | IF & ROWS ( ) | Art of The Balance (Part 1)

Описание: In this tutorial, I will be talking about creating a loop for a series of item in Excel. It is a very essential step to transform the data from an aggregate format to transactional format. Once you learned this trick and know how to use INDEX-MATCH function, you will then know the power of Excel.

The function we use in the tutorial is very simple, the IF function and the ROWS function. We will divide the video into 2 parts so I can better deliver the logic. Again, we are not trying to learn all the functions, we learn how to use the core functions and how to think like EXCEL, w

My teaching methodology will help you understand the logic of the functions rather than forcing yourself to memorize how to use the functions.
-------------------------------------------------------------
Timestamps:
0:00:00 - Introduction - we can loop a series of items to help us transform the data from aggregate format to transactional format
0:00:44 - Transform the data manually by copy and paste
0:01:44 - Why we should not do it manually
0:02:00 - Create a looping worksheet
0:04:30 - ROWS function
0:07:23 - VLOOKUP function to wrap up the worksheet
-------------------------------------------------------------
Art of The Balance

I teach Accountants Excel to enhance their performance.
I build Excel file for Companies to improve the reporting and operating process.

Social Media:
Instagram:   / artofthebalanceaccounting  
LinkedIn:   / artofthebalance