This Excel 2016 tutorial includes everything you need to know to get started with Microsoft Excel.
Excel is a spreadsheet program that allows you to store, organize, and analyze information. While you may believe Excel is only used by certain people to process complicated data, anyone can learn how to take advantage of the program's powerful features. Whether you're keeping a budget, organizing a training log, or creating an invoice, Excel makes it easy to work with different types of data.
Watch the video below to learn more about Excel.
If you've previously used Excel 2010 or Excel 2013, then Excel 2016 should feel familiar. If you are new to Excel or have more experience with older versions, you should first take some time to become familiar with the Excel interface.
When you open Excel 2016 for the first time, the Excel Start Screen will appear. From here, you'll be able to create a new workbook, choose a template, and access your recently edited workbooks.
Click the buttons in the interactive below to become familiar with the Excel interface.
The Quick Access Toolbar lets you access common commands no matter which tab is selected. You can customize the commands depending on your preference.
The Name box displays the location, or name, of a selected cell.
In the formula bar, you can enter or edit data, a formula, or a function that will appear in a specific cell.
A column is a group of cells that runs from the top of the page to the bottom. In Excel, columns are identified by letters.
The Ribbon contains all of the commands you will need to perform common tasks in Excel. It has multiple tabs, each with several groups of commands.
From here, you can access your Microsoft account information, view your profile, and switch accounts.
The Tell me box works like a search bar to help you quickly find tools or commands you want to use.
Each rectangle in a workbook is called a cell. A cell is the intersection of a row and a column. Simply click to select a cell.
A row is a group of cells that runs from the left of the page to the right. In Excel, rows are identified by numbers.
Excel files are called workbooks. Each workbook holds one or more worksheets. Click the tabs to switch between them, or right-click for more options.
Click and drag the slider to use the zoom control. The number to the right of the slider reflects the zoom percentage.
There are three ways to view a worksheet. Simply click a command to select the desired view.
The scroll bars allow you to scroll up and down or side to side. To do this, click and drag the vertical or horizontal scroll bar.