Working Let’s understand with the working help of the example below (Table1: Sales Report) Table 1: Sales Report We have 2 Tab’s for conditional formatting i.e. Conditional_Formatting_1 & Conditional_Formatting_2 Figure 1.1 Conditional_Formatting_1 Figure 1.2 Conditional_Formatting_2 Let’s apply conditional formatting on the below table (Conditional_Formatting_1 tab) Step 1: Select the data(D2:H13) Step 2: Go to
Working Let’s understand how we can link one slicer to 2 Pivot tables based on different data sources with the help of an example. We have 2 Tables one is Sales table and other is the Lead Table. We also have a Product table where we have only Product which are available in Sales table
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 of time
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 value in
Subject Line There’s an in-built function to lookup values from the right side Overview Sometimes you may want to lookup value in a different way. There could be a table where you would want to use any column and then traverse from right to left to search according to the column. As you know the
