Train 24/7 with 5,000+ Online Courses via Pryor+

Pryor+ offers a true blended learning approach that includes more than 15,000 learning opportunities for live and online learning.

Who doesn’t want to save time when setting up a spreadsheet? In this program, you’ll go behind the scenes and learn how to properly set up cell references as well as copy and paste formulas. Once you understand these simple concepts, you can create dynamic spreadsheets where you don’t have to enter your data over and over again.

What You'll Learn

  • Take advantage of data already in your spreadsheet by creating formulas with cell references.
  • Reduce the time it takes to set up a spreadsheet by copying and pasting formulas properly.
  • Set up relative or absolute cell references so that you can be confident your formulas are being used accurately.