whats new in excel 2013
DESCRIPTION
A brief overview of top features in Excel 2013TRANSCRIPT
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!