Category: Excel Guides

shape
shape
shape
shape
shape
shape
shape
shape
Standard

How to Use SUBTOTAL in Excel: Function and Subtotal Tool Explained

Excel has two things called subtotal, and people often confuse them. The SUBTOTAL function calculates a sum, average, count or other result for a list, and it can ignore rows hidden by a filter. The Subtotal command on the Data tab inserts subtotal rows into a sorted list, one for each group, with an outline

Standard

How to Split Text in Excel: Text to Columns, Formulas and TEXTSPLIT

Imported data often arrives with several values squeezed into one cell, such as a full name, an address with commas, or a code that joins a prefix and a number. Splitting that text into separate columns makes it possible to sort, filter and summarize it. Excel offers several ways to do this: the Text to

Standard

How to Generate Random Numbers in Excel: RAND, RANDBETWEEN and RANDARRAY

Random numbers are useful for sampling data, picking winners, shuffling lists, creating test data and running simulations. Excel has three main functions for this: RAND returns a decimal between 0 and 1, RANDBETWEEN returns a whole number between two limits, and RANDARRAY returns a whole block of random values in newer versions. The catch is

Standard

How to Multiply in Excel: Cells, Columns, Percentages and PRODUCT

Multiplication is one of the most common jobs in a spreadsheet: price times quantity, hours times rate, amount times tax. Excel handles it with the asterisk operator, the PRODUCT function and the SUMPRODUCT function, and with Paste Special for changing a whole column at once. This guide shows each method with worked examples you can