Excelerate With Us

Excel works in form of a Table structure and Row & Column format. At times, we would start making entries in a format, just to realize later that transposing the data would have given a better view of the data. Also, sometimes we would copy data from the internet or somewhere, which is not in the format we desire. Transpose data means, to switch or rotate cells. There are 3 different ways to achieve this. In this video, I explain all the methods with relevant examples. 1. Static Transpose: This is when we want to transpose the data completely and does not want the original data. There is a simple copy Paste Special method to achieve this. 2. There is a relatively new array function to achieve this. This is formula hence works well, when base data needs to be kept. This being array function is not easy to use. Please check the video carefully 3. There is another easy method to achieve Transpose by reference. It can be also used to convert a single column to a table structure. Many t...

  Flash Fill in Excel is one of the most powerful functions. With this single feature, one can perform most functions for which complex TEST formulas would require. Check this video with different examples of how to use Flash Fill. Example 1: In this example, I explain how to split name, merge name, change first name-last name, change case. Also how to extract the name from email id.   Example 2: GST consists of State id, PAN No, and other 3 characters. In this example, I explain how to separate PAN No from GST id, with a single click.   Example 3: Phone number in the US and other countries follows a specific format. In this example, I explain how to format phone numbers in various formats.   Example 4: Data like Account numbers, Phone numbers, etc needs to be masked for various reasons. In this example, I explain how such data can be easily masked using the flash-fill function.   Example 5: If there is an id like abcd123, separating text and n...