Quick Start Guide
New to E Excel 2016? Use this guide to learn the basics.
Begin with a Blank workbook to get right to work. Or save yourself a bunch of
time by selecting and then customizing a template that resembles what you need.
Click File > New, and then select or search for the template you want.
Need to work on the go and across different devices? Click File > Account to sign in and access your recently used files anywhere, on
through seamless integration between Office, OneDrive, OneDrive for Business, and SharePoint.
Find recent files
Whether you only work with files stored on your PC’s local
hard drive or you roam across various cloud services,
clicking File > Open takes you to your recently used workbooks and any files that you may have pinned to your list.
Discover contextual tools
Select relevant objects in your
workbook to make contextual commands available.
For example, clicking a chart element displays the Chart Tools tab with options for the Design and Format of a selected chart.
Share your work with others
To invite others to view or edit your workbooks in the cloud, click the Share button in the top right corner of the app window.
In the Share pane that opens, you can get a sharing link or send invitations to the people you select.
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.
Insert functions, build formulas
On the Formulas
tab, click Insert Function to
display the Insert Function dialog
Here, you can search for and insert functions, look up the correct syntax, and even get in-depth Help about how your selected functions work.
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.
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.
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,
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 http://aka.ms/office-2016-whatsnew 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 http://aka.ms/office-2016-training 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, click Feedback and then follow the prompts to send your suggestions directly to the Excel product team. Thank you!