Overview

Get more out of Microsoft Excel® 2013: more productivity and better answers for greater success! Drawing on his unsurpassed Excel experience, Bill Jelen (“Mr Excel”) 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 visualisation, and social media integration. Start by taking a quick “tour” 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 visualisations 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

Full Product Details

Author:   Bill Jelen
Publisher:   Pearson Education (US)
Imprint:   Que Corporation,U.S.
Dimensions:   Width: 17.90cm , Height: 6.40cm , Length: 22.90cm
Weight:   1.842kg
ISBN:  

9780789748577

ISBN 10:   0789748576
Pages:   1248
Publication Date:   07 February 2013
Audience:   Professional and scholarly ,  Professional & Vocational
Format:   Paperback
Publisher's Status:   Active
Availability:   In Print  
This item will be ordered in for you from one of our suppliers. Upon receipt, we will promptly dispatch it out to you. For in store availability, please contact us.

Table of Contents

Chapter 1 Staying Connected Using Excel 2013 Chapter 2 Introducing Flash Fill and Analysis Lens Chapter 3 Using the Excel Interface Chapter 4 Customizing Excel Chapter 5 Extending Excel with Excel Apps and Add-Ins Chapter 6 Keyboard Shortcuts Chapter 7 The Big Grid and File Formats Chapter 8 Understanding Formulas Chapter 9 Controlling Formulas Chapter 10 Understanding Functions Chapter 11 Using Everyday Functions: Math, Date and Time, and Text Functions   Chapter 12 Using Powerful Functions: Logical, Lookup, Web, and Database Functions Chapter 13 Using Financial Functions Chapter 14 Using Statistical Functions Chapter 15 Using Trig, Matrix, and Engineering Functions Chapter 16 Connecting Worksheets, Workbooks, and External Data Chapter 17 Using Super Formulas in Excel Chapter 18 Using Names in Excel Chapter 19 Fabulous Table Intelligence Chapter 20 Sorting Data Chapter 21 Removing Duplicates and Filtering Chapter 22 Using Automatic Subtotals Chapter 23 Using Pivot Tables to Analyze Data Chapter 24 Using Slicers and Filtering a Pivot Table Chapter 25 Mashing Up Data with PowerPivot Chapter 26 Creating Interactive Dashboards with Power View or GeoFlow Chapter 27 Using What-If, Scenario Manager, Goal Seek, and Solver Chapter 28 Automating Repetitive Functions Using VBA Macros Chapter 29 More Tips and Tricks for Excel 2013 Chapter 30 Formatting Worksheets Chapter 31 Using Data Visualizations and Conditional Formatting Chapter 32 Graphing Data Using Excel Charts Chapter 33 Using Sparklines Chapter 34 Using SmartArt, Shapes, WordArt, and Text Boxes Chapter 35 Using Pictures and Clip Art Chapter 36 Printing

Reviews

Author Information

Bill Jelen, Excel MVP and the host of MrExcel.com, has been using spreadsheets since 1985, and he launched the MrExcel.com website in 1998. Bill was a regular guest on Call for Help with Leo Laporte and has produced more than 1,500 episodes of his daily video podcast, Learn Excel from MrExcel. He is the author of 36 books about Microsoft Excel, writes the monthly Excel column for Strategic Finance magazine, and his Excel tips appear regularly in the CFO Excel Pro Newsletter and CFO magazine. Before founding MrExcel.com, Bill Jelen spent 12 years in the trenches–working as a financial analyst for finance, marketing, accounting, and operations departments of a $500 million public company. He lives near Akron, Ohio with his wife, Mary Ellen.

Tab Content 6

Author Website:  

Customer Reviews

Recent Reviews

No review item found!

Add your own review!

Countries Available

All regions