Software & Apps MS Office 93 93 people found this article helpful Excel Tutorials for Beginners Get started with these tips for beginners by Ted French Writer Former Lifewire writer Ted French is a Microsoft Certified Professional who teaches and writes about spreadsheets and spreadsheet programs. our editorial process Ted French Updated on November 13, 2019 MS Office Excel Word Powerpoint Outlook Tweet Share Email 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 up and running 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. Understand the Excel Screen Elements Understand the Basic Excel Screen Elements covers the main elements of an Excel worksheet. These elements include: Cells and active cellsAdd sheet iconColumn lettersRow numbersStatus barFormula barName boxRibbon and ribbon tabsFile tab Explore a Basic Excel Spreadsheet Excel Step by Step Basic Tutorial covers the basics of creating and formatting a basic spreadsheet in Excel. You'll learn how to: Enter dataCreate simple formulasDefine a named rangeCopy formulas with the fill handleApply number formattingAdd cell formatting Create Formulas With Excel Math To learn how to add, subtract, multiply, and divide in Excel, see How to Use Basic Math Formulas Like Addition and Subtraction in Excel. This tutorial also covers exponents and changing the order of operations in formulas. Each topic includes a step-by-step example of how to create a formula that carries out 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. To make this job easier, use the SUM function. Quickly Sum Columns or Rows of Numbers in Excel shows you how to: Understand the SUM function syntax and argumentsEnter the SUM functionAdd numbers quickly with AutoSUMUse the SUM function dialog box Move or Copy Data When you want to duplicate or move data to a new location, see Shortcut Keys to Cut, Copy, and Paste Data in Excel. It shows you how to: Copy dataPaste data with the clipboardCopy and paste using shortcut keysCopy data using the context menuCopy data using menu options on the Home tabMove data with shortcut keysMove data with the context menu and using the Home tab Add and Remove Columns and Rows Need 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'll learn the best ways to add or remove singular or multiple columns and rows using a keyboard shortcut or the context menu. Hide and Unhide Columns and Rows How to Hide and Unhide Columns, Rows, and Cells in Excel teaches you how to hide sections of the worksheet to make it easier to focus on important data. It's easy to bring them back when you need to see the hidden data again. Enter the Date To learn how to use a simple keyboard shortcut to set the date and time, see Use Shortcut Keys to Add the Current Date/Time in Excel. If you prefer to have the date automatically update every time the worksheet is opened, see Use Today's Date within Worksheet Calculations in Excel. Enter Data in Excel Dos and Dont's of Entering Data in Excel covers best practices for data entry and shows you how to: Plan the worksheetLay out the dataEnter headings and data unitsProtect worksheet formulasUse cell references in formulasSort data Build a Column Chart How to Use Charts and Graphs in Excel explains how to use bar graphs to show comparisons between items of data. Each column in the chart represents a different data value from the worksheet. Create a Line Graph How to Make and Format a Line Graph in Excel in 5 Steps shows you how to track trends over time. Each line in the graph shows the changes in the value for one data value from the worksheet. Visualize Data With a Pie Chart Understanding Excel Chart Data Series, Data Points, and Data Labels covers how to use pie charts to visualize percentages. A single data series is plotted and each slice of the pie represents a single data value from the worksheet.