Excel 2013 In Depth (eBook)

Beyond the Basics...Beneath the Surface...In Depth
Excel 2013 In Depth
Do more in less time!
Experienced with Excel? Don't let Excel 2013 make you feel like a beginner again! This book is packed with intensely useful Excel 2013
knowledge you just won't find anywhere else. Packed with new tips and shortcuts, it's the fastest, best way to master Excel 2013's full power,
and leverage its new tools for everything from formulas, charts, and functions to dashboards, data visualization, and social media integration!Supercharge your workbooks with new apps from the Excel App Store
Leverage the improved Excel Web App to create highly interactive web pages and online surveys
Build spreadsheets that are more trustworthy, error-resistant, flexible, intelligent, and understandable
Create formulas, charts, subtotals, and pivot tables faster with Excel 2013's new Flash Fill and Quick Analysis
Quickly apply attractive, consistent formats to any workbook or chart
Return data from web services with new WEBSERVICE and FILTERXML functions
Solve real-world business intelligence analysis problems with sorting, filtering, and pivot tables
Take full advantage of What-If, Scenario Manager, Goal Seek, and Solver
Create amazing PowerPivot data mashups that integrate information from anywhere
Use Power View to generate stunningly intuitive data visualizations, including maps and dashboards
Share workbooks on the Web and social networks, including Twitter and LinkedIn
Automate repetitive functions using Excel macros
All In Depth books offer
Comprehensive coverage with detailed solutions
Troubleshooting help for tough problems you can't fix on your own
Outstanding authors recognized worldwide for their expertise and teaching style

---

Get more out of Microsoft Excel(R) 2013: more productivity and better answers for greater success! Drawing on his unsurpassed Excel experience, Bill Jelen ("e;Mr Excel"e;) brings together all the intensely useful knowledge you need: insights, techniques, tips, and shortcuts you just won't find anywhere else. Excel 2013 In Depth is the fastest, best way to master Excel 2013's full power; get comfortable with its updated interface; and leverage its new tools for everything from formulas, charts, and functions to dashboards, data visualization, and social media integration. Start by taking a quick "e;tour"e; of Excel 2013's most valuable new features. Then, learn how to Build more trustworthy, error-resistant, flexible, extensible, intelligent, and understandable spreadsheets Get more productive with Excel 2013's new Start Screen and Timelines Create formulas, charts, subtotals, and pivot tables faster with new Flash Fill and Analysis Lens Quickly apply attractive, consistent formats Master every function you'll ever need,- including powerful new web services functions Solve real-world business intelligence analysis problems Create amazing PowerPivot data mashups that integrate information from anywhere Use Power View to generate stunningly intuitive maps, dashboards, and data visualizations Share workbooks on the Web and social networks Leverage the improved Excel Web App to create highly interactive web pages and online surveys Automate repetitive functions using Excel macros Supercharge your workbooks with new apps from the Excel App Store Like all In Depth books, Excel 2013 In Depth delivers complete coverage with detailed solutions, and troubleshooting help for tough problems you can't fix on your own. Whatever you intend to do with Excel 2013, this is the only book you'll need!