Microsoft Office Tutorials and References
In Depth Information
Identifying new features of Excel 2013
Microsoft Excel Mobile If you have a Windows Phone 8 device, you can use Excel
Mobile to view and manipulate your workbooks. You can create formulas, change
the formatting of worksheet cells, sort and filter your data, and summarize your data
by using charts. You can also connect your phone to your SkyDrive account, so all of
those files will be available even if you don’t have a notebook or other computer to
work with at the moment.
Identifying new features of Excel 2013
Excel 2013 includes all of the most useful capabilities included in previous versions of the
program. If you’ve used an earlier version of Excel, you probably want to know about the
new features introduced in Excel 2013. The following sections summarize the most
important changes from Excel 2010, Excel 2007, and Excel 2003.
If you are upgrading from Excel 2010
For users of Excel 2010, you’ll find that Excel 2013 extends the program’s existing
capabilities and adds some very useful new ones. The features introduced in Excel 2013 include:
Windows 8 functionality Excel 2013, like all Office 2013 programs, takes full
advantage of the capabilities of the Windows 8 operating system. When it is running on a
computer running Windows 8, Excel embodies the new presentation elements and
enables you to use a touch interface to interact with your data.
A window for each workbook Every workbook now has its own program window.
New functions More than 50 new functions are available, which you can use to
summarize your data, handle errors in your formulas, and bring in data from online
Flash Fill If your data is in list form, you can combine, extract, or format the data
in a cell. When you continue the operation, Excel detects your pattern and offers to
extend it for every row in the list.
Quick Analysis Lens Clicking the Quick Analysis action button, which appears next
to a selected cell range, displays different ways to visually represent your data.
Clicking an icon creates the analysis instantly.
Recommended PivotTable PivotTables create interactive and flexible data
summaries. You can have Excel recommend a series of PivotTables to create from your data,
click the one you want, and keep working.
Search JabSto ::

Custom Search