Excel

Excel Quick Start Guide

Posted on Updated on

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

EQSG1

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.

EQSG2

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.

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

EQSG3

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.

EQSG5

EQSG9

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.

EQSG6

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.

EQSG7

EQSG8

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.

EQSG10

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.

EQSG11

Excel Shortcuts

Posted on Updated on

blog-excel-logo

Save over 60 minutes everyday using these simple excel shortcuts. Value your time! 

Function Short-Cut Key
Absolute/relative/mixed reference F4
AutoSum Alt=
Bold Ctrl+B
Border lines off Ctrl-Shift _
Border lines on Ctrl-Shift &
Calculate active sheet Shift-F9
Calculate all worksheets F9
Close Ctrl-W
Collapse selection to active cell Shift-Backspace
Comment insert/edit Shift-F2
Copy Ctrl+C
Copy formula from cell above Ctrl’
Copy value from cell above Ctrl-Shift”
Cut Ctrl+X
Date Ctrl;
Delete range Ctrl –
Delete to end of line Ctrl-Del
Show values/formulas Ctrl `
Edit cell F2
Enter formula as array Ctrl-Shift- Enter
Fill down Ctrl-D
Fill right Ctrl-R
Find Ctrl-F
Format cell or range  (Format Cells dialog box) Ctrl-1
Format commas (2 decimal places) Ctrl-Shift !
Format currency (2 decimal places) Ctrl-Shift $
Format date (day, month, year) Ctrl-Shift #
Format exponential number (2 decimal places) Ctrl-Shift ^
Format general number Ctrl-Shift ~
Format percentage (0 decimal places) Ctrl-Shift %
Format time (hour and minute) Ctrl-Shift @
Formula =
Function Wizard Shift-F3
GoTo Ctrl-G
Group row/column Alt-Shift- Right
Hard Return in cell Alt-Enter
Hide selected column(s) Ctrl-0 (zero)
Hide selected row(s) Ctrl-9
Insert chart sheet F11
Insert Function components Ctrl-Shift- A
Insert range Ctrl-Shift- Plus
Insert worksheet Shift-F11
Italics Ctrl-I
Menu bar F10
Move between noncontiguous selections Ctrl-Alt- Left/Right
Move left/right one screen Alt-PgUp/PgDn
Move to beginning of worksheet Ctrl-Home
Move to edge of region Ctrl-Dn, Up, Left, Right
Move to end of row End, Enter
Move to end of worksheet Ctrl-End
Move to next corner of selection Ctrl .
Move up through a selection Shift-Enter
Name a range (Insert/Name/Create) Ctrl-Shift- F3
Name a range (Insert/Name/Define) Ctrl-F3
New Ctrl-N
Next window Ctrl-F6
Next worksheet Ctrl-PgUp
Open Ctrl-O
Outline symbols display/hide Ctrl-8
Paste Ctrl-V
Paste named range (Insert/Name/Paste) F3
Previous window Ctrl-Shift- F6
Previous worksheet Ctrl-PgDn
Print Ctrl-P
Repeat Find Shift+F4
Repeat/Redo Ctrl-Y
Replace Ctrl -H
Save Ctrl-S
Save As F12
Scroll to display active cell Ctrl-Backspace
Select array to which active cell belongs Ctrl /
Select cells directly referred to by selected formula Ctrl [
Select cells referred to by selected formula Ctrl-Shift-{
Select cells with comments Ctrl-Shift ?
Select column Ctrl-Spacebar
Select current region Ctrl-Shift *
Select formulas that directly refer to active cell Ctrl-]
Select formulas that refer to active cell Ctrl-Shift }
Select objects on worksheet Ctrl-Shift-Spacebar
Select row Shift-Spacebar
Select to beginning of row Shift-Home
Select to beginning of worksheet Ctrl-Shift-Home
Select to edge of region Ctrl-Shift-Arrow
Select to end of row End, Shift-Enter
Select to end of worksheet Ctrl-Shift- End
Select visible cells in selection Alt ;
Select worksheet Ctrl-A
Shortcut menu Shift-F10
Spelling and Grammar check F7
Strikethrough on/off Ctrl-5
Style box Alt ‘
Tab inserted Ctrl-Alt-Tab
Time Ctrl-Shift-Colon
Underline Ctrl-U
Undo Ctrl-Z
Ungroup row/column Alt-Shift-Left
Unhide column(s) Ctrl-Shift )
Unhide row(s) Ctrl-Shift (

 

Microsoft_Word_logo     Outlook_logo_and_wordmark.svg       download