Excel 2013 All-in-One For Dummies

Front Cover
John Wiley & Sons, Feb 15, 2013 - Computers - 792 pages
0 Reviews

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

Whether you're an Excel newbie or a veteran user to wants to get familiar with the latest version, Excel 2013 All-in-One For Dummies has everything you need to know.

 

What people are saying - Write a review

We haven't found any reviews in the usual places.

Contents

Visit www dummies comloheatsheetlexoelZO13aio to view this
Formulas and Functions
Formatting Worksheets
Editing and Proofing Worksheets
Managing Worksheets
Reorganizing the Workbook
Printing Worksheets
Building Basic Formulas
Using Hyperlinks
Data List Basics
Sorting Data
Filtering and Querying a Data List
Using Data Tables
Exploring Different Scenarios
Hide and Goal Seeking
Generating Pivot Tables

Date and Time Formulas
Financial Formulas
Math and Statistical Formulas
Lookup Information and Text Formulas
Worksheet Collaboration and Reyiew
Using the PowerPivot and Power View AddIns
Macro Basics
Macro Security
Using the Visual Basic Editor
Copyright

Other editions - View all

Common terms and phrases

About the author (2013)

Greg Harvey, PhD, is President of Mind Over Media and a highly skilled instructor. He has been writing computer books for more than 20 years, and his long list of bestsellers includes all editions of Excel For Dummies, Excel All-in-One For Dummies, and Excel Workbook For Dummies.

Bibliographic information