what are the basic tools in excel

Essential Excel Tools: Unveiled

By Daniel Lopez
AD

Say you've just been hired as a data analyst, or perhaps you're trying to wrangle your small business's finances. Wherever you stand in the vast world of Excel, you'll soon discover that this powerful tool is not just a spreadsheet program; it's a versatile ally that can streamline your workflow, make data sense, and even crunch numbers with astonishing speed. So, what are the basic tools in Excel that you'll be using day-to-day? Let's dive in!

Before we embark on this journey, let's quickly cover how Excel works in essence. Excel is a collection of blank 'cells' arranged in a grid of 'rows' and 'columns'. Each cell has an 'address' or 'name', and all together these cells form a 'worksheet'. A 'workbook' is a collection of worksheets, and you can have multiple workbooks open at once.

Cells, Rows and Columns

The smallest element in Excel is the cell. A cell is a single little box that you can fill with text, numbers, or formulas. Each cell has a unique address based on its location within the grid. For instance, 'A1' refers to the first cell in the first column, 'B20' is the 20th cell in the second column, and so on.

AD
the 25 excel tools every professional should know infographical poster - click to enlarge
the 25 excel tools every professional should know infographical poster - click to enlarge
the excel basics for beginners poster is shown in green and white, with instructions on how
the excel basics for beginners poster is shown in green and white, with instructions on how
the excel formulas chart with numbers and symbols for each item in this table, you can
the excel formulas chart with numbers and symbols for each item in this table, you can

Columns are named after letters of the alphabet (A, B, C, ..., Z, AA, AB, ...), whilst rows are numbered. This naming system allows you to reference cells not just by their position in the grid, but by their content or by other cells that they reference.

Entering and Editing Data

To enter data, simply click on the cell where you want your data to appear and type away. To edit, click the cell to highlight it (this is called 'activating' the cell), and your data will appear in the 'Formula Bar' above (also known as the 'input bar'). Make your changes, and click Enter or press the arrow keys to move to the next cell.

basic of excel
basic of excel
bon à savoir ✅
bon à savoir ✅
the top 10 excel functions for beginners to use in your workbook or notebook
the top 10 excel functions for beginners to use in your workbook or notebook

One great timesaving trick - use the Fill Handle. Located at the bottom of a cell, the Fill Handle allows you to instantly copy your data over a range of cells.

Formulas

Formulas let you perform calculations on your data. The equal sign (=) tells Excel that what follows is a formula, not data. For example, typing '=SUM(A1:A10)' into cell A11 will calculate the sum of all numbers in cells A1 to A10 and display the result in A11. As you type, you can click in the formula bar or press Return or Tab to get suggestions, making it easier to build complex formulas.

AD

Formulas can reference ranges, up to 65535 cells away, a must-know when working with large datasets. Use absolute references to reference a precise cell, or relative references that adjust when copied.

excel shortcuts quick reference worksheet is shown in the above text box
excel shortcuts quick reference worksheet is shown in the above text box
Microsoft Excel Step by Step
Microsoft Excel Step by Step
Excel Formulas Cheat Sheet | 50+ Essential Excel Functions for Beginners
Excel Formulas Cheat Sheet | 50+ Essential Excel Functions for Beginners
the top 10 excel functions for beginners to use in your workbook or notebook
the top 10 excel functions for beginners to use in your workbook or notebook
Excel Important Tips 👍
Excel Important Tips 👍
Top 25 Basic Excel Formulas Every Beginner Must Know
Top 25 Basic Excel Formulas Every Beginner Must Know

Organization with Ranges and Naming

Now that you're comfortable with cells, rows, and columns, let's discuss how to reference groups of cells - ranges. You'll often see ranges written like this: "=$A$1:$A$100". Here, '$' is used to make a portion of the reference absolute.

Another standby is the ability to name a range. This is particularly useful when working with complex formulas that reference the same data. Name a range once, and you can reference it by name in any subsequent formula, making your workbooks more readable and less error-prone.

AD

Sorting and Filtering

With data in hand, you'll often need to digest it. Sorting helps by arranging data in ascending or descending order. Click on a cell, then go to 'Data' -> 'Sort'. Or, use the A-Z and 1-9 buttons to sort a column.

the advanced excel method is shown in green and white, with instructions on how to use it
the advanced excel method is shown in green and white, with instructions on how to use it

Filtering useful for creating subsets to examine. Click the drop-down arrow on the right of the header of a column,Select 'Filter' -> 'Unique items', then pick which values to filter by.

Tables

ExcelTables streamline data management. Click anywhere in your data, go to 'Home' -> 'Format as Table', and wait for magic. ExcelTable gets your data sorted and lists it in a useful format, with a column of row numbers and colored banding for easy navigation. Furthermore, insert a Slicer feature to filter tables!

AD

And that's the basic tools every Excel user should have in their toolkit! Excel can do so much more, but now you've got the foundation to start. Ready to explore filters, pivot tables, charts, and whatnot? Keep exploring, and remember, Excel is always learning!

AD