How to Add a Total Row in Excel Table

In this tutorial, you will learn how to add a Total Row to an Excel table. If you’re wondering what Total Rows and Excel Tables are, don't worry. We’re going to tackle them one by one but before that, let's get some background.Excel 2007 came up with a feature called "Excel Tables". Although Excel Table is an overly generic term, they provide … [Read more...]

How to Create, Use, Edit and Delete Named Ranges in Excel

Names are one convenient identity. Imagine how we'd be addressed if we didn't have names? Excel tries to make our lives easier by providing us with a similar convenience.What are Named RangesIn Excel, a cell or a range of cells can be named to make their usage easier. It would be simpler to use a named range directly in a formula or select said … [Read more...]

How To Sort By Date In Excel

When you have a large data set to analyze, it’s often helpful to sort the dates in chronological order. Of course, Excel has some built-in tools to get the job done, but sometimes they can’t do exactly what we want. In this article, we’ll talk about everything you need to know about sorting dates chronologically.When you’re through, you’ll be … [Read more...]

Excel MONTH Function – How To Use

The MONTH function is categorized as a Date/Time function in Excel and extracts the month component of a valid Excel date for us. The function returns an integer between 1 to 12. This return may be relayed to another function by nesting the MONTH function.SyntaxThe syntax of the MONTH function is as … [Read more...]

Excel YEAR Function – How To Use

The YEAR function in Excel is categorized as a Date/Time function. It extracts the year component from a valid, Excel recognized date and returns it as a four-digit value. For instance, when a cell contains the date 12/25/2001, the YEAR function returns 2001.The YEAR function is used by financial analysts for extracting the year component from … [Read more...]

Excel ERROR.TYPE Function – How To Use

The Excel ERROR.TYPE function returns a number that corresponds to an error type. As the name suggests, the function only works for errors. Upon finding anything other than errors, the function returns the #N/A (not available) error. When an error is found, the function returns an integer (error code) that tells you the type of error.But wait, … [Read more...]

Excel YEARFRAC Function – How to Use

The YEARFRAC function is categorized as a Date and Time function in Excel. It returns the difference between two supplied dates in terms of years. When the difference is fractional, the output will have a non-integer output, such as 3.5 years, for instance.Fractional years can save a lot of time for financial analysts projecting revenues or cash … [Read more...]

Excel WORKDAY Function – How to Use

The WORKDAY function is categorized as a Date and Time function. It helps us add or subtract N working days to a date provided by us.The formula has various possible use-cases. For instance, think of a wholesale business that has agreed to deliver orders from retailers within 10 working days. Instead of keeping track of overdue orders manually, … [Read more...]