In Excel how to create dynamic HYPERLINK
Click here to download the file used in the below example. In Excel usually, we save the folder locations for easy reference. But most of the times it will not…
How to get only Sunday dates in Excel
Click here to download the workbook which contains the below Example Requirement Want to see the list one particular WEEKDAY dates in a month. Suppose I want list dates which…
Excel tips on daily work
Some of the excel shortcuts we will use on a daily basis. Autofit columns Note: For Alt functions, we should enter keys one after not all together. Select the cells…
Excel tip on Eomonth,Today and workday function
Below syntax of functions EOMONTH(date, default is zero) TODAY() gives today’s date Remember this is a Volatile function which changes every day as per system dates. WORKDAY(strat_date, days, [holidays]) this will…
How to apply Pivot table in excel
Excel Pivot tables Below sales data in sheet 1. We want to know how much each salesman did for the overall year 2017. Before applying the pivot table it suggested…
In Excel How to use Sparklines options
Introduction to Excel Sparklines In Excel, sparklines are one of the features available in the latest versions. This option is used to present the trend analysis, for any given…