MicrosoftExcel2016QuickTips&ShortcutsToSaveYouTime

MCCLunch&LearnSeriesSeries:One

What’sNewInExcel2016

• TellMe

• SmartLookup

• 6NewChartTypes

• WaterfallCharts

• One-Click Forecasting

• 3DMaps

• GetandTransform

• InkEquation

• SharingandCollaboration

DothingsquicklywithTellMe

TypeakeywordorphraseintotheTellmewhatyouwanttodosearchboxontheribbontoquicklyfindtheExcelfeaturesandcommandsyou’relookingfor,todiscoverHelpcontent,ortogetmoreinformationonline.

ExcelRibbon– TellMe

Newfeature inOffice2016

ExcelRibbon– TellMe– Example#1

ExcelRibbon– TellMe– Example#2

Insightsintowhatyou'reworkingon,withSmartLookup

Fact-checkorexploretermsinyourdocumentswithBing-poweredSmartLookup. Simplyhighlighttermsinyourdocumentandusethisfeaturetobringinsearchresultsfromthewebrightintoyourreadingorauthoringenvironment.

ExcelRibbon– SmartLookup

Newfeature inOffice2016

Tellyourdata“story”morevividlywith6NewChartTypes

InExcel2016,Microsofthasaddedsixnewcharts—Treemap,Sunburst,Histogram,Pareto(sortedhistogram),Box&Whisker,Waterfall…andFunnel*.

ExcelRibbon– InsertTab– RecommendedCharts

Newfeature inOffice2016

*AvailabletoOffice365subscribersonly

UseWaterfallCharts tomakeyourpoint

AWaterfallchart—sometimescalledabridgechart—displaysarunningtotalasvaluesareaddedorsubtracted,usefulforunderstandinghowaninitialvalue(forexample,netincome)isaffectedbyaseriesofpositiveornegativevalues.

ExcelRibbon– InsertTab– InsertWaterfallChart

Newfeature inOffice2016

QuicklycreateaforecastvisualizationwithOne-ClickForecasting

ThenewForecastSheetbutton inExcel2016letsyouusehistoricaltime-baseddatatocreateaforecastvisualizationthatpredictsthingslikefuturesales,inventoryrequirements,orconsumertrends.

ExcelRibbon– Datatab– ForecastSheet

Newfeature inOffice2016

Discovergeospatialpatternswith3DMaps

With3DMaps,getaccesstothepopular3Dgeospatialvisualizationtoolthatallowsyoutodiscoverpatternsinyourdataasitrelatestolocation,time,andgeopoliticalcontext.

ExcelRibbon– InsertTab– 3DMap

Newfeature inOffice2016

GetandTransform (Query)

Excel2016nowcomeswithbuilt-infunctionalityandcapabilitiesofPowerQueryforExcel,thatbringseaseandspeedtogettingandtransformingyourdata—allowingyoutofindandbringallthedatayouneedintooneplace.

ExcelRibbon– Datatab– NewQuery

Newfeature inOffice2016

WritecomplexmathequationswithInkEquation

Includingmathequationshasgottenmucheasier.Justuseyourfingeroratouchstyluswithatouchdevice(oramousewithacomputerorlaptop)towritemathequationsbyhand,andExcelwillconvertittotext.

ExcelRibbon– InsertTab– Equation– InkEquation

Newfeature inOffice2016

SimplerworkbookSharingandCollaborating

Co-authoringletsyouworksmarterandfasterbyallowingyoutokeepyourdocument inoneplace,intheCloud,whileprovidingeasyaccessandeditingcapabilitiesforyourteam,orviewingforpeopleoutsideofyourorganization.

ExcelRibbon– Sharebutton

Newfeature inOffice2016

Tips&TricksToSaveYouTime

• Ribbon

• QuickAccessToolbar

• Startscreen

• AutoFill

• FlashFill

• QuickAnalysis

• AutoSumandStatusBar

• InkEquation

• SharingandCollaboration

• HeaderandFooter

StartquicklywiththeStartscreen

TheStartscreenprovidesquickaccesstomostrecentlyusedworkbooks, oropenotherworkbooks fromlocalorcloudstorage.YouwillalsohaveinstantaccesstovariousExceltemplates,orsearchonlineforothertemplates,thatcanhelpyoustartanewprojectquickly.

ExcelStartScreen&Templates

Featureavailable sinceOffice2013

ExcelRibbon andContextualTabs

TheExcelRibbonmakesfindingthingsfasterandeasierbygroupingcontrolstogetherbyfunctionalityoncontextualtabsthatappearonlywhenyouneedthem,whicheliminatestheneedformultiplerowsoftoolbars.

ExcelRibbon– HomeTab

Featureavailable sinceOffice2007

ExcelRibbon– InsertTab

ExcelRibbon– PageLayoutTab

ExcelRibbon– FormulasTab

ExcelRibbon– DataTab

ExcelRibbon– ViewTab

ExcelRibbon– ViewTab

QuickAccessToolbar

TheQuickAccessToolbarisacustomizabletoolbarthatcontainsasetofcommandsthatareindependent ofthetabontheribbonthatiscurrentlydisplayed.

AboveRibbon- QuickAccessToolbar

Featureavailable sinceOffice2007

NavigateworksheetsquicklywiththeCtrlanddirectionalkeys

Jumptoaworksheet’sedgeusingtheCtrlandmatchingarrowkey,inthedirectionofthearrow.

NavigateacrossworksheettabsusingCtrl+thePgUp orPgDn keys.

ExcelRibbon – TellMe

Featureavailable sinceOffice2010

SpeeduptaskswiththeSheetTabBar

Youcanaddmoreworksheets(andothertypesofsheets,suchasachartsheet,macrosheet,ordialogsheet),renamethem,movethem,ordeletethemwiththeSheetTabBar.Youcanevenquicklychangethecolorofatab.

ExcelSheetTabBar

Featureavailable sinceOffice2003

AutoSum andQuickSumwiththeStatusBar

ToquicklygettheSumofarangeofcells,allyouneedtodoisselecttherange,andclickAutoSum—even quicker,selecttherangeandlook inthe lowerright-handsideoftheExcelwindow,theStatusBar.

ExcelRibbon - HomeTab– AutoSum&QuickSumwiththeStatusBar

Featureavailable sinceOffice2003

FilldataautomaticallyinworksheetcellsAutoFill

Insteadofenteringdatamanuallyonaworksheet, youcanusetheAutoFillfeaturetofillcellswithdatathatfollowsapattern,orthatisbasedondatainothercells.

AutoFill

Featureavailable sinceOffice2003

SavetimewithFlashFill

WiththeExcelFlashFillfeatureyoucanquicklysplitasinglecolumnofdataintomultiplecolumns,justbytyping.FlashFillrecognizespatternsinyourdata,andcompletesthedataaccordingly.

ExcelRibbon – DataTab– FlashFill

Featureavailable sinceOffice2013

Transpose (rotate)datafromrowstocolumns(orviceversa)

WhenyouhaveanExcelworksheetwithdataincolumnsthatyouwanttorearrangeinrowsinstead—orviceversa—Excel’sTransposefeaturecanhelpyoudothat.

ExcelRight-ClickOptions– PasteOptions

Featureavailable sinceOffice2010

EasilyvisualizeyourdatawiththeQuickAnalysis tool

Youcaninstantlycreatedifferenttypesofcharts,includinglineandcolumncharts,oraddminiaturegraphs(calledSparklines).Youcanalsoapplyatablestyle,createPivotTables,quicklyinserttotals,andapplyconditionalformatting.

QuickAnalysis

Featureavailable sinceOffice2013

Combinethecontentsofmultiplecells

Usetheampersand(&)operatorinaformulatocombinetextfrommultiplecellsintoonecell,suchasafirstnameandalastname.

ExcelRibbon– DataTab

Featureavailable sinceOffice2010

Quicklyaddabuilt-inHeader&Footer

Excelhasmanybuilt-inheadersandfootersthatyoucanuse.Forworksheets,youcanworkwithheadersandfootersinPageLayoutview.Or,youcanjustchoosefromthemanybuilt-inelementsfoundintheribbon.

ExcelRibbon - InsertTab– Header&Footer

Featureavailable sinceOffice2003

Print justwhatyouneedwithExcel

YoucanprintMicrosoftExcelworksheetsandworkbooks oneatatime,orseveralatonetime.Youcanalsoprintapartialworksheet,suchasanExceltable,withjustthe informationyouneed.

ExcelRibbon - InsertTab– Header&Footer

Featureavailable sinceOffice2010

FAQHowdoMicrosoftOffice2016appsdiffer?• Officeapps vsOfficeMobileapps vsOfficeOnlineApps

Office2016apps(andtheExcel2016appdiscussed here) aredesignedfor:• Office2016Suitefordesktops andlaptops isavailableforpurchaseaspartofOffice365,orasstandalonesuite.

OfficeMobileapps aredesigned for:• Providesimple butpowerfulmobile featuresoptimizedfortouchandmobile use,andbuiltforviewingandlightediting--Agreat

waytotakeyourworkonthego.• OfficeMobileappsareavailableforiOSiPhoneoriPad,Androidphoneortablet,PC,Mac,andmore.

OfficeOnline apps:• Create,share,andcollaboratefromanywhereusingyourfavoritewebbrowser--Another greatwaytotakeyourworkonthego

whenworkingonapublicorshareddevicewithoutOfficeappsinstalled.• Moveseamlessly fromOfficeOnline tothefull-featureddesktopapps(whenavailable)—without leavingyourdocument.

ReferenceThe“WelcometoExcelworkbook”covers10featuresandletsyoupracticeusingeachone:• Todownloadit,goto:https://aka.ms/10exceltricksDifferencesbetweenusingaworkbookinthebrowserandinExcel:• https://support.office.com/en-us/article/Differences-between-using-a-workbook-in-the-browser-and-in-Excel-F0DC28ED-B85D-4E1D-

BE6D-5878005DB3B6Getandprepyourdatafor3DMaps:• https://support.office.com/en-us/article/Get-and-prep-your-data-for-3D-Maps-a732ef13-4f84-414d-9ed2-e97911115a44?ui=en-

US&rs=en-US&ad=USDownloadsampledataworkbooks:• https://support.office.com/en-us/article/Get-started-with-Power-Map-88a28df6-8258-40aa-b5cc-577873fb0f4a?ui=en-US&rs=en-

US&ad=US#__exploring_sample_datasetsCreateaDataModelinExcel:• https://support.office.com/en-us/article/Create-a-Data-Model-in-Excel-87e7a54c-87dc-488e-9410-5c75dbcb0f7b?ui=en-US&rs=en-

US&ad=USGettingstartedwithPowerPivotinMicrosoftExcel:• https://support.office.com/en-us/article/Get-started-with-Power-Pivot-in-Microsoft-Excel-fdfcf944-7876-424a-8437-

1a6c1043a80b?ui=en-US&rs=en-US&ad=US

Questions?

INSTRUCTIONSANDSCREENSHOTSINTHISGUIDEAPPLYTOExcel2016

SomefeaturesareonlyavailablewithanOffice365account

ThankYou!

©2016Microsoft Corporation. Allrightsreserved.Thisdocument isforinformational purposesonly.Microsoftmakesnowarranties, express orimplied, inthissummary.