Skip to Main Content
Teach Yourself VISUALLY Excel 2016
book

Teach Yourself VISUALLY Excel 2016

by Paul McFedries
October 2015
Beginner content levelBeginner
352 pages
9h 32m
English
Visual
Content preview from Teach Yourself VISUALLY Excel 2016

CHAPTER 4

Building Formulas

image

Are you ready to start creating powerful and useful worksheets by building your own formulas? This chapter explains formulas, shows you how to build them, and shows you how to incorporate the versatile worksheet functions in Excel into your formulas.

Understanding Excel Formulas

Build a Formula

Understanding Excel Functions

Add a Function to a Formula

Add a Row or Column of Numbers

Build an AutoSum Formula

Add a Range Name to a Formula

Reference Another Worksheet Range in a Formula

Move or Copy a Formula

Switch to Absolute Cell References

Hide the Formula Bar or Ribbon

Troubleshoot Formula Errors

Understanding ...

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

Excel 2010 Made Simple

Excel 2010 Made Simple

Abbott Katz

Publisher Resources

ISBN: 9781119074731Purchase book