Microsoft Office Tutorials and References
In Depth Information
• Creating charts: Create a wide variety of highly customizable charts.
• Organizing lists: Use the row-and-column layout to store lists efficiently.
• Text manipulation: Excel is a good tool for cleaning up and standardizing text-based data.
• Accessing other data: Import data from a wide variety of sources.
• Creating graphical dashboards: Summarize a large amount of business information in a concise format.
• Creating graphics and diagrams: Use Shapes and SmartArt to create professional-looking diagrams.
• Automating complex tasks: Perform a tedious task with a single mouse click with Excel's macro capabilit-
This book focuses on a single aspect of Excel: formulas. As you'll see, formulas play a significant role in all the
tasks listed here.
What's New in Excel 2013?
When a new version of Microsoft Office is released, sometimes Excel gets lots of new features — and some-
times it gets very few new features. In the case of Office 2013, Excel got quite a few new features, but nothing
Here's a quick summary of what's new in Excel 2013, relative to Excel 2010:
• Cloud storage: Excel is tightly integrated with Microsoft's SkyDrive web-based storage.
• Support for other devices: Excel is available for other devices, including touch-sensitive devices, such as
Windows RT tablets and Windows phones.
• New aesthetics: Excel has a new “flat” look and displays an (optional) graphic in the title bar. Cursor move-
ments and chart updates are animated, making it easier to see changes. Color schemes are no longer suppor-
ted, and the Ribbon is hidden by default.
• Single document interface: Excel no longer supports the option to display multiple workbooks in a single
window. Each workbook has its own top-level Excel window and Ribbon.
• New types of assistance: Excel provides recommended pivot tables and recommended charts.
• Fill Flash: This is a new way to extract (by example) relevant data from text strings. You can also use this
feature to combine data in multiple columns.
• Support for Office Apps: You can download or purchase apps that can be embedded in a workbook file.
• Pivot charts: You can create pivot charts without creating a pivot table.
• New Slicer option: The Slicer feature, introduced in Excel 2010 for use with pivot tables, has been expan-
ded and now works with tables.
• Timeline filtering: Similar to Slicers, a Timeline makes it easy to filter data by dates.
• Quick Analysis: This feature provides single-click access to various data analysis tools.
• Enhanced chart formatting: Modifying charts is significantly easier.