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…
Commerce and Excel Hub
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…
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…
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…
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…
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…
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…