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 (12)

Full Member
Thanks for great webinar.
Full Member
Full Member
Full Member
Great resource! He has a knack for simplifying intimidating topics.
Full Member
Lots of useful information
Full Member
Great info. Thanks!
Full Member
Useful information.
Full Member
very helpful...thanks
Full Member
Thank you so much for this information. Very Useful info.
Full Member
more reviews ...