Tutorial on Pivot Table – Part 1

Rating 3.00 out of 5 [?]On first day at work, I was given an excel workbook that was used to test the reports which are generated using a software and are delivered to the client. The workbook had a large amount of data, kind of a database in itself and … Continue reading

Array Formula in MS-Excel or LibreOffice Calc

Rating 4.00 out of 5 [?] Preparing MS-Excel based test beds is what my job is, as boring as it sounds it helps me learn new things and understand how powerful a tool MS-Excel really is and use it to get the job done. In this tutorial I am going … Continue reading

Using Index and Match instead of VLookup

Rating 4.25 out of 5 [?]How many times have you used VLookup and felt that the column you want to look up on comes after the one you want to display? I have been using MS-Excel extensively at work and the problem I described is encountered every day by me. … Continue reading

Embedding Shockwave Flash in MS-Office Applications

Rating 3.00 out of 5 [?]Flash Games are generally blocked in your office network. But at times we want to bust stress and flash games are way to go 🙂 … Here is a small tutorial that will help you embed a shockwave flash file in MS-Office applications like MS-Excel … Continue reading