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 work when there is anyContinue reading
Category: Excel Concepts
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 are Sunday in January monthContinue reading
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 for which you want toContinue reading
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 help to calculate the nextContinue reading
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 converting the entire data intoContinue reading
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 data in a corresponding ExcelContinue reading