Excel resources

Excel Tips & Tricks

Articles, examples, and practical guidance from the SpreadsheetWeb team.

Page 39 of 60 · 540 articles

How to round numbers in Excel

In this guide, we are going to show you how to round numbers in Excel with the help of formulas and the number formatting feature.

In this guide, we're going to show you how to convert feet to inches and inches to feet in Excel. CONVERT and VLOOKUP functions are used.

In this guide, we are going to show you how to convert pounds to kg and kg to pounds. You can find examples with CONVERT and VLOOKUP.

In this guide, we are going to show you how to convert cm to inches, and inches to cm units using manual and dynamic methods.

In this article, we're going to show you how to sort text in Excel using formulas. This approach means a dynamic sorting capability.

A subtotal in Excel means aggregation of one set of a larger data. In this guide, we're going to show you how to calculate subtotal in Excel.

In this guide, we are going to show you how to remove file extension from filename in 2 ways with SUBSTITUE, FIND and LEFT functions.

In this guide, we're going to show you how to find square root in Excel. This can be calculated manually or using the SQRT function.

In this article, we're going to show you how to count Excel TRUE FALSE values. This article uses the COUNTIFS function to cound Booleans.