Excel Tutorials for Beginners

These Excel tutorials for beginners include screenshots and examples with detailed step-by-step instructions. Follow the links below to learn everything you need to get started with Microsoft’s popular spreadsheet software.

This article applies to Excel 2019, Excel 2016, Excel 2013, Excel 2010, Excel for Mac, and Excel for Android.

  1. Understanding Excel screen elements
  2. Learn a simple Excel spreadsheet
  3. Creating Formulas with Excel Math
  4. Add numbers with the SUM function
  5. Move or copy data
  6. Add and remove columns and rows
  7. Hide and show columns and rows
  8. Enter date
  9. Enter data in Excel
  10. Plot a column chart
  11. Create line chart
  12. Visualize data with a pie chart

Understanding Excel screen elements

Understanding the Basics of an Excel Screen covers the basics of an Excel worksheet. These elements include:

  • Cells and active cells

  • Add a leaf icon

  • Column with letters

  • Line numbers

  • status bar

  • Formula bar

  • box name

  • Ribbon and Ribbon Tabs

  • File tab

Learn a simple Excel spreadsheet

The basic Excel Steps tutorial covers the basics of creating and formatting a basic table in Excel. You learn how:

  • Enter the details

  • Create simple formulas

  • Define a named range

  • Copy formulas with fill handle

  • Apply number formatting

  • Add cell formatting

Creating Formulas with Excel Math

For more information about addition, subtraction, multiplication, and division in Excel, see Using basic math formulas such as addition and subtraction in Excel. This tutorial also covers measurements and changing the order of operations in formulas. Each topic provides a step-by-step example of creating a formula that performs one or more of the four basic math operations in Excel.

Add numbers with the SUM function

Adding rows and columns of numbers is one of the most common operations in Excel. Use the SUM function to make this task easier. Quickly sum columns or rows of numbers in Excel shows how to:

  • Understanding the syntax and arguments of the SUM function

  • Enter the sum function

  • Add songs quickly with AutoSUM

  • Using the SUM Function dialog box

Move or copy data

To duplicate or move data to a new location, see Keyboard shortcuts for cutting, copying, and pasting data in Excel. It shows how:

  • Copy data

  • Paste data to clipboard

  • Copy and paste with keyboard shortcuts

  • Copy data using the context menu

  • Copy the data using the menu items on the Home tab

  • Moving data with keyboard shortcuts

  • Move data using the context menu and Home tab

Add and remove columns and rows

Do you want to adjust the layout of your data? How to add and delete rows and columns in Excel explains how to expand or shrink the work area as needed. You will learn about the best ways to add or remove individual or multiple columns and rows using a keyboard shortcut or context menu.

Hide and show columns and rows

How to hide and show columns, rows, and cells in Excel will teach you how to hide worksheet sections so that you can more easily focus on important data. They are easy to retrieve when you need to see hidden data again.

Enter date

For more information about using a simple keyboard shortcut to set the date and time, see Use keyboard shortcuts to add the current date/time in Excel. If you prefer the date to be automatically updated every time you open the worksheet, see “Using today’s date” in Worksheet Calculations in Excel.

Enter data in Excel

Do’s and Don’ts in Excel provides data entry guidelines and shows you how to:

  • Plan your worksheet

  • Post your details

  • Enter headings and data units

  • Protect sheet formulas

  • Use cell references in formulas

  • Sort data

Plot a column chart

How to use charts and graphs in Excel explains how to use bar charts to show comparisons between data items. Each bar in the chart represents a different data value from the worksheet.

Create line chart

Creating and formatting a line chart in Excel in 5 steps will show you how to track trends over time. Each line in the chart shows the change in value for one data value from the worksheet.

Visualize data with a pie chart

An introduction to data series, data points, and data labels in Excel charts shows you how to use pie charts to visualize percentages. One data series is charted, and each segment of the pie chart represents one data value from the worksheet.

Leave a Reply

Your email address will not be published. Required fields are marked *