Basic tasks in Excel (2022)

Excel is an incredibly powerful tool for getting meaning out of vast amounts of data. But it also works really well for simple calculations and tracking almost any kind of information. The key for unlocking all that potential is the grid of cells. Cells can contain numbers, text, or formulas. You put data in your cells and group them in rows and columns. That allows you to add up your data, sort and filter it, put it in tables, and build great-looking charts. Let’s go through the basic steps to get you started.

Excel documents are called workbooks. Each workbook has sheets, typically called spreadsheets. You can add as many sheets as you want to a workbook, or you can create new workbooks to keep your data separate.

  1. Click File, and then click New.

  2. Under New, click the Blank workbook.

    Basic tasks in Excel (1)

  1. Click an empty cell.

    For example, cell A1 on a new sheet. Cells are referenced by their location in the row and column on the sheet, so cell A1 is in the first row of column A.

  2. Type text or a number in the cell.

  3. Press Enter or Tab to move to the next cell.

  1. Select the cell or range of cells that you want to add a border to.

  2. On the Home tab, in the Font group, click the arrow next to Borders, and then click the border style that you want.

    Basic tasks in Excel (2)

For more information, see Apply or remove cell borders on a worksheet.

  1. Select the cell or range of cells that you want to apply cell shading to.

  2. On the Home tab, in the Font group, choose the arrow next to Fill Color Basic tasks in Excel (3), and then under Theme Colors or Standard Colors, select the color that you want.

For more information about how to apply formatting to a worksheet, see Format a worksheet.

When you’ve entered numbers in your sheet, you might want to add them up. A fast way to do that is by using AutoSum.

  1. Select the cell to the right or below the numbers you want to add.

  2. Click the Home tab, and then click AutoSum in the Editing group.

    Basic tasks in Excel (4)

    (Video) The Beginner's Guide to Excel - Excel Basics Tutorial

    AutoSum adds up the numbers and shows the result in the cell you selected.

For more information, see Use AutoSum to sum numbers

Adding numbers is just one of the things you can do, but Excel can do other math as well. Try some simple formulas to add, subtract, multiply, or divide your numbers.

  1. Pick a cell, and then type an equal sign (=).

    That tells Excel that this cell will contain a formula.

  2. Type a combination of numbers and calculation operators, like the plus sign (+) for addition, the minus sign (-) for subtraction, the asterisk (*) for multiplication, or the forward slash (/) for division.

    For example, enter =2+4, =4-2, =2*4, or =4/2.

  3. Press Enter.

    This runs the calculation.

    You can also press Ctrl+Enter if you want the cursor to stay on the active cell.

For more information, see Create a simple formula.

To distinguish between different types of numbers, add a format, like currency, percentages, or dates.

  1. Select the cells that have numbers you want to format.

  2. Click the Home tab, and then click the arrow in the General box.

    Basic tasks in Excel (5)

  3. Pick a number format.

    Basic tasks in Excel (6)

    If you don’t see the number format you’re looking for, click More Number Formats. For more information, see Available number formats.

A simple way to access Excel’s power is to put your data in a table. That lets you quickly filter or sort your data.

  1. Select your data by clicking the first cell and dragging to the last cell in your data.

    To use the keyboard, hold down Shift while you press the arrow keys to select your data.

  2. Click the Quick Analysis button Basic tasks in Excel (7) in the bottom-right corner of the selection.

    Basic tasks in Excel (8)

    (Video) Basic Tasks in Excel 2013 - Part 1

  3. Click Tables, move your cursor to the Table button to preview your data, and then click the Table button.

    Basic tasks in Excel (9)

  4. Click the arrow Basic tasks in Excel (10) in the table header of a column.

  5. To filter the data, clear the Select All check box, and then select the data you want to show in your table.

    Basic tasks in Excel (11)

  6. To sort the data, click Sort A to Z or Sort Z to A.

    Basic tasks in Excel (12)

  7. Click OK.

For more information, see Create or delete an Excel table

The Quick Analysis tool (available in Excel 2016 and Excel 2013 only) let you total your numbers quickly. Whether it’s a sum, average, or count you want, Excel shows the calculation results right below or next to your numbers.

  1. Select the cells that contain numbers you want to add or count.

  2. Click the Quick Analysis button Basic tasks in Excel (13) in the bottom-right corner of the selection.

  3. Click Totals, move your cursor across the buttons to see the calculation results for your data, and then click the button to apply the totals.

    Basic tasks in Excel (14)

Conditional formatting or sparklines can highlight your most important data or show data trends. Use the Quick Analysis tool (available in Excel 2016 and Excel 2013 only) for a Live Preview to try it out.

  1. Select the data you want to examine more closely.

  2. Click the Quick Analysis button Basic tasks in Excel (15) in the bottom-right corner of the selection.

  3. Explore the options on the Formatting and Sparklines tabs to see how they affect your data.

    Basic tasks in Excel (16)

    For example, pick a color scale in the Formatting gallery to differentiate high, medium, and low temperatures.

    Basic tasks in Excel (17)

  4. When you like what you see, click that option.

Learn more about how to analyze trends in data using sparklines.

The Quick Analysis tool (available in Excel 2016 and Excel 2013 only) recommends the right chart for your data and gives you a visual presentation in just a few clicks.

  1. Select the cells that contain the data you want to show in a chart.

  2. Click the Quick Analysis button Basic tasks in Excel (18) in the bottom-right corner of the selection.

  3. Click the Charts tab, move across the recommended charts to see which one looks best for your data, and then click the one that you want.

    Basic tasks in Excel (19)

    Note:Excel shows different charts in this gallery, depending on what’s recommended for your data.

Learn about other ways to create a chart.

(Video) How to Pass Excel Assessment Test For Job Applications - Step by Step Tutorial with XLSX work files

To quickly sort your data

  1. Select a range of data, such as A1:L5 (multiple rows and columns) or C1:C80 (a single column). The range can include titles that you created to identify columns or rows.

  2. Select a single cell in the column on which you want to sort.

  3. Click Basic tasks in Excel (20) to perform an ascending sort (A to Z or smallest number to largest).

  4. Click Basic tasks in Excel (21) to perform a descending sort (Z to A or largest number to smallest).

To sort by specific criteria

  1. Select a single cell anywhere in the range that you want to sort.

  2. On the Data tab, in the Sort & Filter group, choose Sort.

  3. The Sort dialog box appears.

  4. In the Sort by list, select the first column on which you want to sort.

  5. In the Sort On list, select either Values, Cell Color, Font Color, or Cell Icon.

  6. In the Order list, select the order that you want to apply to the sort operation— alphabetically or numerically ascending or descending (that is, A to Z or Z to A for text or lower to higher or higher to lower for numbers).

    For more information about how to sort data, see Sort data in a range or table.

  1. Select the data that you want to filter.

  2. On the Data tab, in the Sort & Filter group, click Filter.

    Basic tasks in Excel (22)

  3. Click the arrow Basic tasks in Excel (23) in the column header to display a list in which you can make filter choices.

  4. To select by values, in the list, clear the (Select All) check box. This removes the check marks from all the check boxes. Then, select only the values you want to see, and click OK to see the results.

    (Video) Excel - How To Do List

For more information about how to filter data, see Filter data in a range or table.

  1. Click the Save button on the Quick Access Toolbar, or press Ctrl+S.

    Basic tasks in Excel (24)

    If you’ve saved your work before, you’re done.

  2. If this is the first time you've save this file:

    1. Under Save As, pick where to save your workbook, and then browse to a folder.

    2. In the File name box, enter a name for your workbook.

    3. Click Save.

  1. Click File, and then click Print, or press Ctrl+P.

  2. Preview the pages by clicking the Next Page and Previous Page arrows.

    Basic tasks in Excel (25)

    The preview window displays the pages in black and white or in color, depending on your printer settings.

    If you don’t like how your pages will be printed, you can change page margins or add page breaks.

  3. Click Print.

  1. On the File tab, choose Options, and then choose the Add-Ins category.

  2. Near the bottom of the Excel Options dialog box, make sure that Excel Add-ins is selected in the Manage box, and then click Go.

  3. In the Add-Ins dialog box, select the check boxes the add-ins that you want to use, and then click OK.

    If Excel displays a message that states it can't run this add-in and prompts you to install it, click Yes to install the add-ins.

For more information about how to use add-ins, see Add or remove add-ins.

Excel allows you to apply built-in templates, to apply your own custom templates, and to search from a variety of templates on Office.com. Office.com provides a wide selection of popular Excel templates, including budgets.

For more information about how to find and apply templates, see Download free, pre-built templates.

(Video) Top 10 Most Important Excel Formulas - Made Easy!

FAQs

What are 5 basic Excel functions? ›

5 Functions of Excel/Sheets That Every Professional Should Know
  • VLookup Formula.
  • Concatenate Formula.
  • Text to Columns.
  • Remove Duplicates.
  • Pivot Tables.
23 Jan 2019

What tasks can you do in Excel? ›

Complete List of Things You Can Do With Excel
  • Tools, Calculators and Simulations.
  • Dashboards and Reports with Charts.
  • Automate Jobs with VBA macros.
  • Solver Add-in & Statistical Analysis.
  • Data Entry and Lists.
  • Games in Excel!
  • Educational use with Interactive features.
  • Create Cheatsheets with Excel.
5 Sept 2022

What are the basic things in Excel? ›

What are the 4 major parts of Excel? ›

Excel data types are the four different kinds of values in Microsoft Excel. The four types of data are text, number, logical and error.

What are Excel skills? ›

Advanced Excel skills include the ability to produce graphs and tables, use spreadsheets efficiently, and perform calculations and automation to process large volumes of data. With the rise of big data and data analytics, advanced Excel skills are a real asset both during the job hunt and everyday work tasks.

What are the 20 Excel functions? ›

Complete Excel Formulas with Their Functions
FormulasFunctional Description
VLOOKUPSearch for Data from a table arranged in an upright format
MATCHDisplays the position of a specific cell address
COUNTIFCounting the Number of Cells in a Range with specific criteria
COUNTACounting the Number of Filled Cells
19 more rows
5 Aug 2022

How do I master skills in Excel? ›

  1. Master the Shortcuts. You can save precious time by learning some keyboard shortcuts. ...
  2. Import Data from a Website. Learning how to import data is an essential function that can greatly speed up your workflow. ...
  3. Filter Your Results. ...
  4. Calculate the Sum. ...
  5. AutoCorrect and AutoFill. ...
  6. Display Formulas. ...
  7. Manage Page Layout.
14 Sept 2022

What are Excel data Analyst Skills? ›

8 Excel functions that every Data Analyst must know
  • Sort. ...
  • Filter. ...
  • SUMIF function. ...
  • Pivot Tables. ...
  • Text Formulas. ...
  • IF formulas. ...
  • Charts. ...
  • Conditional Formatting.
24 Mar 2015

What Is syntax in Excel? ›

A formula in Excel is used to do mathematical calculations. Formulas always start with the equal sign = typed in the cell, followed by your calculation. Note: You claim the cell by selecting it and typing the equal sign ( = )

What are the 9 Uses of Excel? ›

9 Essential Uses for Excel in Business
  • Accounting. Let's start with a simple application that most businesses already utilize. ...
  • Payroll. Similar to accounting, payroll becomes much simpler if automated through Excel. ...
  • Inventory. ...
  • Time Tracking. ...
  • Customer Relationship Management. ...
  • Charts. ...
  • Return on Investment. ...
  • Work Scheduling.
5 Jun 2018

How many functions are there in Excel? ›

Learn how to use all 300+ Excel formulas and functions including worksheet functions entered in the formula bar and VBA functions used in Macros.

How many types of functions are there in Excel? ›

Excel groups functions into 12 categories: Compatibility, Cube, Database, Date and Time, Engineering, Financial, Information, Logical, Lookup & Reference, Math & Trigonometry, Statistical and Text.

What is the purpose of Excel? ›

Microsoft Excel enables users to format, organize and calculate data in a spreadsheet. By organizing data using software like Excel, data analysts and other users can make information easier to view as data is added or changed. Excel contains a large number of boxes called cells that are ordered in rows and columns.

What are the 4 features of spreadsheet? ›

These terminologies include;
  • Row.
  • Column.
  • Cell.
  • Active Cell.
  • Worksheets.
  • Workbook.
  • Chart.
  • Data Range.

Why Excel is called spreadsheet? ›

The word "spreadsheet" came from "spread" in its sense of a newspaper or magazine item (text or graphics) that covers two facing pages, extending across the centerfold and treating the two pages as one large page.

What are the 11 data formats in Excel? ›

The following are the type of number formats available in Excel.
  • General. General is a number format selected as the default by excel for any number you type into the spreadsheet. ...
  • Number. Number Format is exclusively used when you are working with numbers. ...
  • Currency. ...
  • Accounting. ...
  • Date. ...
  • Time. ...
  • Percentage. ...
  • Fraction.
13 Sept 2022

What is the best way to learn Excel? ›

Microsoft offers free Excel classes online on edX to learn both fundamental and advanced Excel skills. Introduction to Data Analysis using Excel is a 4-week, self-paced online course perfect for learners with little or no prior experience using the software.

What are the 4 types of Excel? ›

Excel data types are the four different kinds of values in Microsoft Excel. The four types of data are text, number, logical and error. You may perform different functions with each type, so it's important to know which ones to use and when to use them.

What are the 20 Excel functions? ›

Complete Excel Formulas with Their Functions
FormulasFunctional Description
VLOOKUPSearch for Data from a table arranged in an upright format
MATCHDisplays the position of a specific cell address
COUNTIFCounting the Number of Cells in a Range with specific criteria
COUNTACounting the Number of Filled Cells
19 more rows
5 Aug 2022

What are the top 10 Excel formulas? ›

1) Excel SUM formula: =SUM (C2,C3,C4,C5) 2) Excel Average Formula: = Average (C2,C3,C4,C5) 3) SumIF formula = SUMIF (A2:A7,“Items wanted”, D2:D7) 4) COUNTIF Formula: COUNTIF(D2:D7, “Function”)

Videos

1. Basic Tasks in Excel 2013 - Part 2
(Hun Kim)
2. How to use Microsoft Excel for Beginners (with 12 useful basic tasks)
(RamCPACMA)
3. Automated Excel Task tracker in 20 minutes #ExcelTaskTracker
(Excel Is Simple)
4. Task Management Template for Excel (2021)
(Excel Highway)
5. Exercise 12 | Excel Practice Book | How To Make Sales Report In Ms Excel
(New-Tech Online Training)
6. Interactive Excel Project Management Dashboard - FREE Download
(MyOnlineTrainingHub)

Top Articles

You might also like

Latest Posts

Article information

Author: Laurine Ryan

Last Updated: 12/29/2022

Views: 6544

Rating: 4.7 / 5 (57 voted)

Reviews: 88% of readers found this page helpful

Author information

Name: Laurine Ryan

Birthday: 1994-12-23

Address: Suite 751 871 Lissette Throughway, West Kittie, NH 41603

Phone: +2366831109631

Job: Sales Producer

Hobby: Creative writing, Motor sports, Do it yourself, Skateboarding, Coffee roasting, Calligraphy, Stand-up comedy

Introduction: My name is Laurine Ryan, I am a adorable, fair, graceful, spotless, gorgeous, homely, cooperative person who loves writing and wants to share my knowledge and understanding with you.