Excel Quick Start Guide

Posted on Updated on

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


Create something

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.


Stay connected

Need to work on the go and across different devices? Click File > Account to sign in and access your recently used files anywhere, on any device, 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

Manage data with Excel tables

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.

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 box. 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.



Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s