Select Page

## How to create bullet points in Excel (•)

Excel is not a word processor software, but you may still want to list things in various parts of your workbooks. Bullet points are great for creating lists, as its the universal indicator of an unordered list. Here, we’re going to cover 4 different ways to...

## How to concatenate strings in Excel

Although Excel tasks typically involve working with numbers, you can also manipulate text strings by concatenating them. In this guide, we’re going to show you how to concatenate strings in Excel using the ampersand character and also with the help of other...

## 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...

## How to convert feet to inches, and vice versa in Excel

Converting units can be time consuming when you rely on a separate tool or website to do it.​ In this guide, we are going to show you how to convert feet to inches and inches to feet in Excel. Download Workbook Manual approach The first approach we are going to show...

## How to convert pounds to kg, and vice versa

Converting units can be time consuming when you rely on a separate tool or website to do it. In this guide, we are going to show you how to convert pounds to kg and kg to pounds. Download Workbook Manual approach The first approach we are going to show you is doing...

## How to convert inches to cm, and cm to inches

Converting units can be time consuming when you rely on a separate tool or website to do it. In this guide, we are going to show you how to convert cm to inches and inches to cm in Excel. Download Workbook Manual approach The first approach we are going to show you is...

## 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...

## 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 remove file extension from filename in Excel

If you want to remove file extension from full file names, first you need to locate the period (.) which separates the filename and the extension. This action is fairly easy to do if your file names do not contain any periods other than the extension separator....