Click here Subject Line You don’t need a helper for lookup all the time Overview Sometimes you may need to get the output without using helper column. What is a helper column? We create a separate column and concatenate both the values in a separate column and then use it as a lookup value to
Click here Subject Line RAG indicators make reports colourful and impressive Overview Sometimes you may want to rate status reports based on different indicators just like the traffic lights using red, amber (yellow) and green to signify different scale ratings. There is always a need to make reports appealing based on the format and presentation.
Click here Subject Line Slice and Dice as you need for multiple data sources Overview Sometimes you may need to slice and dice or drill down for certain reports. Drill-down reports are used to validate and verify and also to zoom in to find particulars about a single value. Slicer is a powerful way to
Click here Subject Line How to automate the pivot table in different reports? Overview As we know Pivot tables are used to Summarize, Sort, Reorganize, and Group, Count, Total or Average data. But sometimes we many need to make copies of the pivot table for each unique item in a field. This will help us to save lot
Click here Subject Line 2 way lookup is amazing Overview Sometimes you may want to lookup a value in a table using both rows and columns. You can build your own formula that to perform a two-way lookup with help of INDEX and MATCH function. Syntax =INDEX(data,MATCH(val,rows,0),MATCH(val,columns,0)) Let’s understand both the function INDEX function returns a