Have You ever struggled to put PivotTable Field List back at its Original Position?*Original Position - right-side of the worksheet, as highlighted in the following picture: If Your answer is Yes, You...
Ctrl+Shift+F3 Create name by using names of row and column labels Insert, Name, Create Ctrl+Shift+F6 Previous Window Window, ... Ctrl+Shift+F12 Print File,...
Presentation Perfect Reports. Why Presentable, neatly crafted Reports makes a job more perfect and easy for Business Analyst who is going make decisions out of the information structured in reports. Many...
Nested If statements are complicated to type down and include many parameters. The best method to replace them is to use the lookup function. Using the lookup function shortens the formula at a considerable...