To import or connect to data, sort and filter data, validate data, flash fill values,. In the Function Library, Defined Names, and Formula Auditing groups. To find functions, define names, or troubleshoot formulas, select "Formulas" and look. To set page margins, page breaks, print areas, or sheet options, select "Page Layout"Īnd look in the Page Setup, Scale to Fit, and Sheet Options groups. To create tables, charts, sparkles, reports, slicers, and hyperlinks, select "Insert"Īnd look in the Tables, Charts, Sparkles, Filters, and Links groups. To format, insert, delete, edit or find data in cells, columns, and rows, select "Home"Īnd look in the Number, Styles, Cells, and Editing groups. To create, open, save, print, share, or export files, or change options, select "File"Īnd look in the Backstage view (select the commands in the left pane). Use the list below to find some of the more common tools and commands in Excel 2013. Those tabs have also changed to make things easier to find. 
Other tabs appear when you're working on certain things like charts and PivotTables. There's also a newįilters group with buttons for creating slicers and timelines. The Insert tab has new buttons to help you create charts and PivotTables. If you've used the ribbon in an earlier version of Excel, you'll notice a few changes. Just select the question mark in the top-right corner above the ribbon to open Excel We have many free resources to help you learn Excel 2013, including online training. Know where to find the Excel 2003 commands and toolbar buttons on the ribbon. If you've been using Excel 2003, you'll want to If you've been using Excel 2007 or 2010 and are familiar with the ribbon, you'll want Microsoft Excel 2013 looks different from previous versions, so we created this guide
0 kommentar(er)
