Get the most out of the Teacher Learning Community. Sign in now. Not a member? Click here to get started for free!

Use Formulas and Cell References in Excel 2016

Preview Preview Preview Preview Preview
Buy Now


Spreadsheets are typically used to enter, store, and analyze data and numbers. One way to relate, calculate, and summarize this data is by using formulas and cell references. In this webinar, Jerry Swiatek will explore basic formulas and how show to enter and edit them in Excel. He will examine various parts of a formula, such as common operators, constants, and references, and will explain the importance of order of operations within a formula. Jerry will discuss cell references, including the advantages of using them in formulas. You will also learn how to copy and move formulas and when to use relative, absolute, and mixed references in formulas, as well as quick ways to look for errors in formulas.


Status: Available On-Demand
Subject: ICT
Last aired on: Thursday, October 19, 2017 @ 3:00 PM EDT
Duration: 30 minutes
Credit Hours: 0.5
Categories: Business Education, Desktop Applications, Microsoft
Tags: cell references, copying formulas, formulas, Microsoft Excel, Microsoft Office 2016

Reviews (33)

Full Member
Good information!
Full Member
Nicely done!
Basic Member
Good job
Great information. Thank you.
Full Member
I have a lot to learn! Thank you for your presentation!
Basic Member
Thank you!
Nice work
Always great information and resources to know.
Basic Member
great information
Basic Member
Very useful information!
more reviews ...