ELKAMELBI's video: EP 04 Example Designing the Flat Table in Excel

Link to Sample File: https://1drv.ms/x/s!AvVs0CO1qJZZp3cc2NJ5cjNp3Yhl?e=Vnl0Jt In this episode, we follow the steps learned in episode 03 to design the flat table, for our call support center example, in Excel. we learn the importance of using "Format As Table" feature in Excel which define your range as a flat table (database table). we also look in detail how to create calculated fields to get numerical results as well as categorial results. This is the fourth episode of an Excel training that aims to teach you how to work effectively, how to start thinking objectively when it comes to data projects and most of all how to come out of it equipped with a solid understanding of data structure and clear workflow that makes losing your path in Excel a thing of the past.