Harvey G. Microsoft Excel 2013 All-in-One For Dummies

John Wiley & Sons, Inc., 2013. - 795 pages. На англ. языке.The comprehensive reference, now completely up-to-date for Excel 2013!As the standard for spreadsheet applications, Excel is used worldwide – but it’s not always user-friendly. However, in the hands of veteran bestselling author Greg Harvey, Excel gets a whole lot easier to understand! This handy all-in-one guide covers all the essentials, the new features, how to analyze data with Excel, and much more. The featured minibooks address Excel basics, worksheet design, formulas and functions, worksheet collaboration and review, charts and graphics, data management, data analysis, and Excel and VBA.Covers the changes in the newest version as well as familiar tasks, such as creating and editing worksheets, setting up formulas, and performing statistical functions.
Walks you through the new analysis tools that help make it easier to visualize data with the click of a mouse.
Details new ways to explore your data more intuitively and then analyze and display your results with a single click.Open the book and find:
How to build your own workbook templates
Instructions for using Excel on a touchscreen
All the ways to enter data
Tips for preventing formula errors
Hints for sharing data with other Office 2013 programs
Graphics you can include in your charts
How to query external data sources
A guide to PowerPivot and Power View add-ins