whats new in excel 2013

What’s new in

Excel 2013

Your Presenter

Pranav AinavoluSoftware Engineer @ Thomson ReutersMicrosoft User Group Hyderabadhttp://about.me/pranav.ainavoluhttp://pranavon.net@a_pranav

Agenda

• Top Features - That’s it!

First Look

• Brand New UI• Cleaner• Professional-looking results quickly• New Templates

Top Features

• Fill out an entire column of data in a flash

• Instant data analysis• Create the right chart for your data• One workbook, one window• New Excel functions• Save and share files online• Powerful data analysis• Filter table data by using slicers

Fill out an entire column of data in a flash• Flash Fill Tool• Learn and detect your pattern• Fill the columns with appropriate data

Instant data analysis

• Quick Analysis Tool• Data -> Charts in 1 or 2 steps• Preview with conditional formatting, sparklines, or charts

Filter table data by using slicers

• Filter data in Excel tables, Query tables, and Other data tables

Create the right chart for your data

• Recommended Charts• Most suitable charts for your data

One workbook, one window

• Easy to work with multiple Workbooks

New Excel functions

• Lot of new function categories - math and trigonometry, statistical, engineering, date and time, lookup and reference, logical, and text

Save and share files online

• Save files directly in SkyDrive or Office 365

• Share worksheets with others• Work together on same file• Embed worksheet data in a web page• Share an Excel worksheet in an online

meeting

Powerful data analysis

• Recommended PivotTable• Share worksheets with others• Work together on same file• Embed worksheet data in a web page• Share an Excel worksheet in an online

meeting

I’m done. Thank you!