Excel 2010 To Office 365 For Business

Excel 2010 to Office 365 for businessMake the switchMicrosoft Excel 2013 desktop looks different from previous versions, so here’s a brief overview of new features and important changes.Add commands to the Quick Access ToolbarKeep favorite commands and buttons visible, even when you hidethe ribbon.Explore commands on the ribbonEach ribbon tab has groups, and each grouphas a set of related commands.Show or hide the ribbonChoose Ribbon Display Options or press Ctrl F1 to hide or showthe ribbon.Manage filesOpen, save, print and share yourfiles. Also change options andaccount settings in this view.Get visual cuesWatch for action buttons thatappear in the sheet and animationsthat show data changes. Forexample, select a chart and you’llsee Chart Tools with two extra tabs– Design and Format.Create sheetsStart with one sheet, and addmore sheets as needed.Access other tabsMore tabs appear on the ribbonwhen you need them, like chartor PivotTable tabs.Show shortcut menusGet in the habit of right-clickingyour sheet, chart, or PivotTabledata. Excel will show youcommands that are relevant foryour data.Open a dialog boxClick the launcher icon toshow more options for agroup.Show Key TipsIf you’d rather use thekeyboard, press Alt toshow keys that let youaccess commands on theribbon.And yes — the keyboardshortcuts you’ve usedbefore will still work.Change viewsWork faster in the view of yourchoice: Normal, Page Layout,or Page Break Preview.Zoom in or outDrag the zoom slider to changethe zoom level.

What is Office 365 for business?Just as Office 2010 was a suite of desktop apps, your Office 365 for businesssubscription gives you a suite of powerful online services—including the latest versionof Office desktop apps. Office 365 lets you: Install Office desktop apps on as many as five computers. Create, view and edit documents from anywhere using Office Online. Work offline and your changes automatically sync when you’re back online.How do I sign in to Office 365?1. From your web browser, go to https://portal.office.com.2. Enter your work or school account and password, and thenchoose Sign in. For example:j.doe@contoso.com or j.doe@contoso.onmicrosoft.com Use mobile Office apps on your Windows Phone, Android, iPad, or iPhone.Find your way aroundHow do I use Excel in Office 365?From anywhere in Office 365, click the app launcherservices, including all the Office Online apps:You can use the Excel 2013 desktop app, Excel Online, or device-specific Excel apps.So how do you decide which to use? If you’re using a computer, Excel 2013 has themost features. On a device, the Excel mobile app has the most features. However, formany tasks, the web-based Excel Online may meet your needs.Excel 2013*Excel OnlineExcel mobile appUse it if Your Office 365 planincludes it. You want offline access.You need aquick way toread and makesimple edits.You want the mostediting features availableon your device.Runs onLaptops and desktopsYour browserSpecific devicesHow toget itComes with some, but notall Office 365 plans (*Excel2011 for Mac)Browse fromOneDrive orSitesWindows PhoneiPadiPhoneAndroid phone and tabletCalendarSchedule meetingsand appointments.OutlookRead andsend email.PeopleGet contactinformation.for quick access to allYammerConnect withco-workers.OneDrive for BusinessStore your businessdocuments.SitesAccessteam sites.Office OnlineCreate and collaborate ondocuments from your browser.

What’s new on the Excel 2013 ribbon?Install Office 2013 desktop appsIf Office is not already on your computer, you can install it from Office 365.1. Sign in to Office 365, and then choose Install now.Select a chart and options appear next to the chart along with the conditional Design tabfor Chart Tools on the ribbon. Choose the buttons to fine-tune your chart.Install apps onyour PCInstall apps onyour deviceUse Office OnlineCreate and editdocuments fromyour browser.2. Choose Run, and then follow the rest of the installation instructions.The Insert tab has new buttons that help you choose the best charts and PivotTables.And now you can easily create timelines and slicers with the Filters group.For more information, see Install Office using Office 365 for business(http://go.microsoft.com/fwlink/p/?LinkId 272460).

Things you might be looking for in Excel 2013Use the list below to find some of the more common tools and commands in Excel 2013. See also Changed functionality in Excel 2013 (http://go.microsoft.com/fwlink/p/?LinkId 396711).TaskIn Excel 2010In Excel 2013Open, save, or print a workbookChoose the File tab, then click the option.Choose the File tab, then the option.Set up options (such as defaultfont, colors, auto-save)Choose File, then Options,and set your options.Choose File, then Options, and set your options.Compare workbooks side by sideOpen each workbook, then click View Arrange All.All workbooks were in the same window.Open each workbook. Each onehas in its own window to moveindependently or you canchoose View View Side by Side.Fill out a column with patterneddataSelect each cell and enter the data.Flash Fill recognizes the pattern and automatically fills the remaining cells.Save an open workbook as atemplate1. Choose Office Save As.2. Type the name for the template in the File namebox.3. Choose Excel Template or Excel Macro-EnabledTemplate in the Save as type box.4. Click Save.First create a folder to store your templates.Then choose File Export Change File Type Template.See Save a workbook as a template(http://go.microsoft.com/fwlink/p/?LinkId 396712).Save a chart as a templateChoose the chart, and thenChoose Chart Tools Design Save as Template.Right-click the chart,and then choose Save as Template.Split the workbookUse the Split box controls.Select the cell where you wantto place the split, and thenchoose View Split.

Creating and saving workbooksNo matter if you start from your Excel desktop app or from Office 365, you can create aworkbook and then store it in your OneDrive for Business or SharePoint document library.Create a workbook using Excel 2013Excel 2013 provides templatesyou can use to create newworkbooks or you can startwith a blank workbook. Youcan also learn more from theExcel 2013 Quick Start Guide(http://go.microsoft.com/fwlink/p/?LinkId 272044).Save to SharePoint document librarySharePoint sites include a documentlibrary by default. You can saveworkbooks here and anyone withaccess to that site can see andcollaborate on documents andworkbooks.Create a workbook from Office 365You don’t need the Excel desktop app to create a new workbook. If you’ve got OneDrivefor Business or a SharePoint document library, you can create a workbook from there.Excel Online lets you co-edit and automatically saves your workbook to that location.Save to OneDrive for BusinessOneDrive for Business is youronline file storage.Workbooks saved here areprivate until you share themwith others. Plus, you canaccess them from almostanywhere.1. Choose the app launcherand then choose OneDriveor Sites.2. Choose New.3. Choose PowerPointpresentation.,

Opening and deleting workbooksOpen a workbook from Office 365Quickly open a workbook from OneDrive for Business or a SharePoint team site.You’ll notice differences when youfirst open Excel 2013. You can choosefrom a blank workbook, a list ofavailable templates, your Recentworkbooks with their location, orOpen Other Workbooks to get toyour OneDrive for Business and ateam site document libraries.Excel 2013Select a workbookand then chooseEdit to open inExcel 2013.Excel OnlineChoose theworkbook name toautomatically openin Excel Online.Open a workbook from Excel 2013Choose the location of your workbook, and then open it.SharePointOpen your workbook froma SharePoint team site.OneDrive for BusinessUse this location to getto your online storage.RecentWorkbooksGet quickaccess toworkbooks intheir defaultlocations.OneDrive.comSign in with aMicrosoft accountto access personalworkbooks.Delete a workbook from Office 365Deleting workbooks from OneDrive for Business and SharePoint is just as simple.1. Select theworkbookyou want todelete.2. ChooseManage.3. ChooseDelete.

Working offline with ExcelNeed to work somewhere without an Internet connection? You can sync documentsor entire folders to your computer before you go. When you’re back online, yourchanges will automatically sync.How does Sync work?The first time you sync, it takes a little longer to download your documents on yourdesktop or other device. You can now work offline and not lose your changes.Anytime you make a change, those changes are automatically uploaded.Sync a libraryYou can sync the entire library of your OneDrive for Business and SharePoint team site.1. Choose the app launcher,and then choose OneDrive orSites.2. Choose Sync.After you sync OneDrive for Business or a team SharePoint site, you get an associatedfolder on your device Favorites with the documents that you have synced.OneDrive forBusinessLists the documentsin your OneDrive forBusiness library.Sync a document or folderYou can sync only the documents or folders you’re working on.1. Choose the applauncher, andthen chooseOneDrive or Sites.2. Select adocument or folder.3. Choose Sync.Your desktopShows the locationcontaining copies ofthe documents yousynced from yourOneDrive forBusiness library.

Working with othersExcel OnlineShare workbooksWherever your workbook is stored, it’s easy to share it with others—whether they’repart of or outside of your organization. When you share, the people who need toreview or edit get an email with a link to the workbook. With just a quick click,reviewers can open it from nearly anywhere and on practically any device.2. Choose Share.Does a coworker not have Excel on their computer? Or do they use a Mac? No problem!With Excel Online, you can do basic co-edits in the same document at the same time.No Save button?Don’t worry, Excel Onlineautomatically saves yourworkbook.Need more options?Open in Excel 2013 touse advanced optionssuch as charts andPivotTables.ShareIf everyone is working inExcel Online, you can coedit the same workbooksimultaneously.3. Enter yourreviewer’sname oremailaddress.Excel Onlineshows who isediting andwhat changesthey havemade.1. Select your workbook.4. ChooseShare.Who’s editingSee the names ofothers editing if theyhave signed in.ChangesSee who has changedwhat cells in theworkbook.

Working from mobile devicesWhether you use a Windows Phone,Android device, iPhone, tablet, or iPad,you can view and edit Excel workbooksstored on a SharePoint site or OneDrivefor Business.All you need is the Office Mobile app toget to your workbooks. Now you canview and make last minute changes to aworkbook right on your phone ortablet.Set up your deviceFor mobile, it’s all about the apps and the work or school account you use for Office 365for business to your device. Find and install the right app for your device from yourdevice’s app store. For step-by-step instructions, see: Set up a mobile device using Office 365 for business(http://go.microsoft.com/fwlink/p/?LinkId 396709) Set up Office 365 for business on your: Windows Phone (http://go.microsoft.com/fwlink/p/?LinkId 396654) iPhone (http://go.microsoft.com/fwlink/p/?LinkId 396655) iPad (http://go.microsoft.com/fwlink/p/?LinkId 524315) Android phone and tablet (http://go.microsoft.com/fwlink/p/?LinkId 525632)Need more info? Check out the Office 365 for business learning center(http://go.microsoft.com/fwlink/p/?LinkId 392570) for additional quick startguides and how-to videos. Find more tips for switching to Office 365(http://go.microsoft.com/fwlink/p/?LinkId 398049).

most features. On a device, the Excel mobile app has the most features. However, for many tasks, the web-based Excel Online may meet your needs. Excel 2013* Excel Online Excel mobile app Use it if Your Office 365 plan includes it. You want offline access. You need a quick way to