Skip to Main Content
Office 2013 Digital Classroom
book

Office 2013 Digital Classroom

by Walter Holland, AGI Creative Team
August 2013
Beginner content levelBeginner
672 pages
14h 31m
English
Wiley
Content preview from Office 2013 Digital Classroom

Excel Lesson 4: Using Formulas in Excel 2013

ex04.psd

In this lesson, you’ll learn how to perform calculations in Excel. Specifically, you will write formulas using operators and cell references. Then you will use the Function library to construct more detailed formulas. You will also learn to apply a range of cells in formulas and move and copy formulas from one part of a worksheet to another. Finally, you will learn how to check your worksheet for errors.

What you’ll learn in this lesson:

  • Writing simple and complex formulas
  • Performing quick calculations with AutoSum
  • About the difference between absolute and relative cell references
  • Creating range names to describe data
  • Moving and copying formulas

Starting up

You will work with files from the Excel04lessons folder. Make sure you have loaded the OfficeLessons folder onto your hard drive from www.digitalclassroombooks.com/Office2013. If you need further instructions, see “Loading lesson files” in the Starting up section of this book.

The most useful feature of Excel is its ability to perform calculations. Through formulas, you can use Excel to calculate any range of values. Excel’s extensive Function library, which is a set of predefined formulas, enables you to perform sophisticated data analysis with little or no experience.

Formulas

A formula is a mathematical equation used to calculate a value. In Excel, a formula must ...

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 Word 2007 Step by Step

Microsoft® Office Word 2007 Step by Step

Joyce Cox and Joan Lambert
Microsoft® Office 2013 QuickSteps, 3rd Edition

Microsoft® Office 2013 QuickSteps, 3rd Edition

Carole Matthews, Marty Matthews, Bobbi Sandberg

Publisher Resources

ISBN: 9781118571613Purchase bookOther