How to generate Excel month names

How to generate Excel month names

This article shows you how to generate month list by formulas and how to display Excel month names instead of actual date values. We will use DATE, YEAR and MONTH formulas as well as Number Formatting. Syntax =DATE( YEAR( previous date ), MONTH( previous date )+1, 1)...
How to calculate Excel Table totals

How to calculate Excel Table totals

This article shows how to calculate Excel table totals by using Excel Table which is one of the most underrated features in Excel. Steps Select a cell inside your table or whole range Press Ctrl + T or click Table icon under INSERT tab on the ribbon Make sure My table...
How to use Excel sort function

How to use Excel sort function

Although Excel has a built-in sort feature, there are times you may need to sort data by formula or in a formula. This article shows how to use Excel sort function with SMALL and ROW functions. Syntax =SMALL( column of list, ROW()-ROW(row of list’s title)) Steps...