714.456.3333 (Orange) / 949.824.3434 (Irvine)
200 S. Manchester Ave. Orange, CA 92868

Excel 2016

Quick Start Guide

New to Excel 2016? Use this guide to learn the basics.


click on the photo to enlarge Click on the photo above to enlarge

Create something

Select File > New, and then select or search for the template you want. Begin with a Blank workbook to get right to work. Or save yourself time by selecting and then customizing a template that resembles what you need.

create somthing

Find recent files

Whether you only work with files stored on your PC's local hard drive or you roam across various cloud services, selecting File > Open takes you to your recently used workbooks and any files that you may have pinned to your list.

find recent files

Look up relevant information

With Smart Lookup, Excel searches the Internet for relevant information to define words, phrases, and concepts. Search results shown on the task pane can provide useful context for the data and information in your workbooks.

smart lookup

Discover contextual tools

Select relevant objects in your workbook to make contextual commands available. For example, selecting a chart element displays the Chart Tools tab with options for the Design and Format of a selected chart.

dicover contextual tools

Find whatever you need

Type a keyword or phrase into the Tell me what you want to do search box on the ribbon to quickly find the Excel features and commands you're looking for, to discover Help content, or to get more information online.

find whatever you need

Insert functions

On the Formulas tab, select Insert Function to search for and insert functions, look up the correct syntax, and even get in-depth Help about how your selected functions work.

insert functions

Manage data with Excel tables

You can choose to format any range of cells in your current workbook as an Excel table. Excel tables let you analyze and easily manage a group of related data independently from the other rows and columns in your workbook.

manage data with tables

Get other Quick Start Guides

Excel 2016 is just one of the newly designed apps in Office 2016. To download our free Quick Start Guides for any of the other new versions of your favorite apps, visit http://aka.ms/office-2016-guides.

other quick start guides

Next steps with Excel

See what's new in Office 2016

Explore the new and improved features in Excel 2016 and the other apps in Office 2016. Visit https://go.microsoft.com/fwlink/?linkid=871117 for more information.

Get free training, tutorials, and videos for Office 2016

Ready to dig deeper into the capabilities that Excel 2016 has to offer? Visit https://go.microsoft.com/fwlink/?linkid=871123 to explore our free training options.

Send us your feedback

Love Excel 2016? Got an idea for improvement to share with us? On the File menu, select Feedback and then follow the prompts to send your suggestions directly to the Excel product team. Thank you!