Includes index.
Front matter
Introduction
Mastering the new user interface
Staying connected using excel 2013
Introducing flash fill and analysis lens
Using the excel interface
Customizing excel
Extending excel with excel apps and add-ins
Keyboard shortcuts
The big grid and file formats
Calculating with excel
Understanding formulas
Controlling formulas
Understanding functions
Using everyday functions : math, date and time, and text functions
Using powerful functions : logical, lookup, web, and database functions
Using financial functions
Using statistical functions
Using trig, matrix, and engineering functions
Connecting worksheets, workbooks, and external data
Using super formulas in excel
Using names in excel
Fabulous table intelligence
Business intelligence
Sorting data
Removing duplicates and filtering
Using automatic subtotals
Using pivot tables to analyze data
Using slicers and filtering a pivot table
Mashing up data with powerpivot
Creating interactive dashboards with power view
Using what-if, scenario manager, goal seek, and solver
Automating repetitive functions using vba macros
More tips and tricks for excel 2013
Visual presentation
Formatting worksheets
Using data visualizations and conditional formatting
Graphing data using excel charts
Using sparklines
Using smartart, shapes, wordart, and text boxes
Using pictures and clip art
Sharing information
Printing
Excel web app and other ways to share workbooks
Saving time using the easy-xl program.
OBNB doesn't sell books, but you may be able to find a copy at one of these websites:
Excel 2013 in depth by Bill Jelen. ISBN 9780789748577. Published by Que in 2013. Publication and catalogue information, links to buy online and reader comments.
