Excel Tips and Tricks

How to round numbers in Excel

How to round numbers in Excel

Rounding numbers is a crucial element of creating legible and easy-to-use spreadsheet tools. Excel offers a few methods to do this, including a formula approach and the number formatting feature. In this guide, we're going to show you how to round numbers in Excel...

How to sort text in Excel using formulas

How to sort text in Excel using formulas

Although Excel already has built-in sorting features, doing this with formulas might be useful in some cases for a more dynamic approach. The formula approach will be updated automatically whenever calculations are executed. In this article, we're going to show you...

How to calculate subtotal in Excel

How to calculate subtotal in Excel

A subtotal is the aggregation of a data set, typically showing the totals of a certain section in that data set. A budgeting spreadsheet is a good example for this where subtotals are used to display more details of certain categories. In a budgeting application, you...

How to count Excel TRUE FALSE values

How to count Excel TRUE FALSE values

TRUE and FALSE are logical (Boolean) values in Excel. They are special values that can be used in formulas as is - although both values looks like a regular text string, you can include them in formulas without the use of double quotes. This behavior may seem...