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 2013

Preview Preview Preview Preview Preview
Buy Now


Spreadsheets are typically used to enter and analyze data and numbers, and one way to relate, calculate, and summarize 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 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: General
Last aired on: Tuesday, October 15, 2013 @ 5:00 PM EDT
Duration: 30 minutes
Credit Hours: 0.5
Categories: Desktop Applications, Microsoft
Tags: cell references, copying formulas, formulas, Microsoft Excel, Microsoft Office 2013

Reviews (22)

Full Member
I enjoyed it
Full Member
very nice
Basic Member
This was a nice walk through of formulas. I took notes on a few of them. I think it was a nice way to simplify what might be overwhelming to some initially.
Nice work
Thank you for our explanation for the importance of order of operations within a formula. Your presentations are wonderful.
Basic Member
Very informative presentation.
Basic Member
Excellent info.
Basic Member
I am pretty savvy in Excel and even I learned something. A must watch for anyone using this program.
Basic Member
good information
Basic Member
Thanks Jerry, a good in depth look at excel formulas.
more reviews ...