Skip to Main Content
Office 2013 All-In-One Absolute Beginner’s Guide
book

Office 2013 All-In-One Absolute Beginner’s Guide

by Patrice-Anne Rutledge
August 2013
Beginner content levelBeginner
704 pages
18h 22m
English
Que
Content preview from Office 2013 All-In-One Absolute Beginner’s Guide

18. Using Formulas

In This Chapter

Entering a Formula into a Cell

Copying a Formula to Another Cell

Troubleshooting Formulas

Excel is great for simple data entry, but its real strength is its capability to perform calculations. After you design a sheet to perform calculations, you can easily change the data and watch Excel instantly recalculate.

This chapter not only shows you how to enter a formula, but also teaches you fundamental basics, such as the difference between absolute and relative referencing, which is important when you want to copy a formula to multiple cells, and how to use a Name to refer to a cell instead of having to memorize a cell address. You’ll take the formula basics you learn here and apply them later in Chapter ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Microsoft® Office 2013 QuickSteps, 3rd Edition

Microsoft® Office 2013 QuickSteps, 3rd Edition

Carole Matthews, Marty Matthews, Bobbi Sandberg
Office 2013: The Missing Manual

Office 2013: The Missing Manual

Nancy Conner, Matthew MacDonald

Publisher Resources

ISBN: 9780133391541Purchase book