Excel 2013 All-in-One For Dummies

From the Back Cover
8 books in 1

Excel Basics
Worksheet Design
Formulas and Functions
Worksheet Collaboration and Review
Charts and Graphics
Data Management
Data Analysis
Macros and VBA
Excel newbie or expert in older versions ― here’s the reference you need for Excel 2013!

Understanding how to use the many features of Excel 2013 is only half the battle. The other half is understanding what these features can do for you. So whether you’re starting out or upgrading, using Excel on your desktop or tablet, this all-in-one guide covers what you need to know to master worksheets, formulas, functions, charts, even data analysis.

For beginners ― start out right with an entire minibook devoted to mastering Excel basics
Working with worksheets ― learn to set up, edit, manage, and dress up worksheets and print reports
Get functional ― explore formulas and functions from basic to complex and put them to work
Team effort ― share and collaborate on worksheets while keeping your data secure
Make it look great ― present your data with impressive charts and graphs that help interpret the information
Manage your data ― take advantage of Excel’s tools for managing large amounts of data and filtering out the information you need
Look ahead ― use Excel’s computational abilities to forecast and predict possible future outcomes
Extend Excel ― install Apps for Office, use COM add-ins, and write macros and custom functions with the Visual Basic Editor
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

About the Author
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.

Related Articles

Excel 2010 All-in-One for Dummies

A comprehensive, up-to-date, user-friendly guide to Excel 2010
Excel is the standard for spreadsheet applications and is used worldwide, but it’s not always user-friendly. That makes it a perfect For Dummies topic, and this handy all-in-one guide covers all the essentials, the new features, how to analyze data with Excel, and much more.

Eight minibooks address Excel basics, worksheet design, formulas and functions, worksheet collaboration and review, charts and graphics, data management, data analysis, and Excel and VBA.

Excel is the leading spreadsheet/data analysis software and is used throughout the world; the newest revision includes upgraded tools and a redesigned interface
For Dummies books are the bestselling guides to Excel, with more than three million copies sold
Excel 2010 All-in-One For Dummies 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
Eight self-contained minibooks cover the basics, worksheet design, formulas and functions, worksheet collaboration, presenting data in charts and graphics, data management, data analysis, and creating macros with VBA.

Newcomers to Excel as well as veterans who just want to learn the latest version will find Excel 2010 All-in-One For Dummies has everything they need to know.

Excel 2010 for Dummies

The bestselling Excel book on the market, updated for Excel 2010
As the world’s leading spreadsheet application, Excel has a huge user base. The release of Office 2010 brings major changes to Excel, so Excel For Dummies comes to the rescue once more!

In the friendly and non-threatening For Dummies style, this popular guide shows beginners how to get up and running with Excel and helps more experienced users get comfortable with new features.

Excel is the number one spreadsheet application worldwide, and Excel For Dummies is the number one guide to using it
With the major changes in Microsoft Office 2010, Excel has new features and a new interface design; users need help to get up to speed
The book includes everything you need to know to perform basic Excel 2010 tasks
Covers creating and editing worksheets and charts, formatting cells, entering formulas, inserting graphs, designing database forms, and adding database records
Also covers printing, adding hyperlinks to worksheets, saving worksheets as Web pages, adding existing worksheet data to an existing Web page, and much more

Whether you’re new to Excel or just need to understand the 2010 version, Excel 2010 For Dummies provides what you need to know.

Excel Formulas and Functions For Dummies 3rd Edition

Learn to use Excel for practical, day-to-day calculations

Excel is a powerful program with more than 300 built-in functions that can be used to perform an almost infinite number of calculations. This friendly book shows you how to use the 150 most valuable ones in real-world situations: to compare the cost of buying vs. leasing a car, calculate classroom grades, or evaluate investment performance, for example. Another 85 specialized functions are also described. Detailed, step-by-step instructions help you understand how functions work within formulas and how you can use them to solve everyday problems.

Excel is a complex tool, making it a perfect subject for the straightforward, plain-English approach of this book
Formulas and functions are explained in classic For Dummies fashion, with examples of how to apply the 150 most commonly used functions in real-world situations
Discover how to use Excel to compare the cost of 15 and 30-year mortgages, decide whether to buy or lease a car, calculate the actual cost of credit card purchases, forecast college expenses, design a database for your own use, and much more
Serves as an excellent resource for all versions of Excel, including the latest version 2013

Excel Formulas and Functions For Dummies, 3rd Edition helps you put the power of Excel to work in your daily life.

Excel Formulas and Functions for Dummies 2nd Edition

Put the power of Excel formulas and functions to work for you! Excel is a complex program. Mastering the use of formulas and functions lets you use Excel to compute useful day–to–day information, such as calculating the true cost of credit card purchases or comparing 15–year and 30–year mortgage costs. This fun and friendly book demystifies Excel′s built–in functions so you can put them to work. You′ll find step–by–step instructions on 150 of Excel′s most useful functions, how they work within formulas, and how to use them to make your life easier. See how to use 150 of Excel′s most useful functions, with real–world examples showing how each function is used within a formula Learn to calculate the costs of leasing versus buying a car, compute classroom grades, create an amortization table, or evaluate investment performance Fully updated for Excel 2010, but the principles will work with earlier versions of Excel as well Includes essential coverage of an additional 85 functions In the ever–popular, non–threatening For Dummies style, Excel Formulas and Functions For Dummies, 2nd Edition makes Excel′s power accessible to you.

MS Office Home & Student All-in-One for Dummies

The go-to reference for the new Office Home & Student 2013

The Home & Student version of Microsoft Office targets the home and education markets, covering the four applications most used outside the workplace: Word, Excel, PowerPoint, and OneNote. The minibooks in this essential All-in-One guide include real-world examples and projects that cover the new features and capabilities of Office 2013. Straightforward advice and beneficial projects help you to learn the basics of creating a resume in Word, establishing a home budget in Excel, developing a dynamic school presentation with PowerPoint, and taking notes in OneNote.

Targets home and school users of Office 2013, who primarily use Word, Excel, PowerPoint, and OneNote
Walks you through how to use Office 2013 for everyday projects, such as creating a cover letter in Word or reusable templates in Excel
Demonstrates how to jazz up a school presentation with PowerPoint
Provides you with straightforward instructions for taking notes in OneNote
Shares common Office 2010 tools and details the basics of the Office ribbon

Office Home & Student 2013 All-in-One For Dummies is an easy-to-understand guide to the essentials of Office 2013!