Launch your Graphy
There are no items in your cart
Add More
Add More
| Item Details | Price | ||
|---|---|---|---|
Increment time by one hour in MS Excel using Auto fill feature
access_time 2024-11-15T01:39:57.361Z face Rajesh Pathak
MS Excel has a very useful feature named as 'auto fill' which can fill data in Excel spreadsheet quickly without using any formulas. This blog article is about using auto fill feature of MS Excel to increment time by one hour. Let's begin to learn this trick. Explore the 'Advanced Excel program' usi...
'Show Details' in pivot table
access_time 2024-11-14T12:37:51.076Z face Rajesh Pathak
This blog article provides step-by-step instructions to use drill down feature of pivot table known as 'show details'. 'Show details' helps in data analysis because it has the power of bringing entire data of a selected row in a new worksheet. This feature helps you to get the source data worksheet ...
Refresh pivot button macro
access_time 2024-11-14T11:51:39.563Z face Rajesh Pathak
This blog article provides step-by-step instructions to create macro recording button of 'refresh pivot table' in Excel using Excel's macro recorder. Macro recorder has been there in Excel since a long time and learning to use this tool can help you to save lots of time because it allows you to auto...
Data bars in conditional formatting in Excel
access_time 2024-11-13T12:47:48.796Z face Rajesh Pathak
This blog article provides step-by-step instructions to create data bars in Excel using Excel's conditional formatting feature. Conditional formatting is a great feature in Excel which allows the users to visualize data in interesting and useful manner. Data bar is one of the tools of this condition...
Extract domain names in Excel using flash fill
access_time 2024-11-13T12:18:04.83Z face Rajesh Pathak
This blog article provides step-by-step instructions to extract domain names given in an Excel file using Excel's flash fill feature. Flash fill feature in Excel helps to merge or split data in no time without using any complex formula. You will find below an example of powerful use of flash fill. L...