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
$27
Buy Now

Overview

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.

Details

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

Full Member
 
good information
Full Member
 
Thanks Jerry, a good in depth look at excel formulas.
Full Member
+8
 
Excellent info from simple to more complex formula setups in Excel.
Full Member
+7
 
Many thanks.
Basic Member
 
Good information on some of the basic formulas.
Full Member
+10
 
Thank you!
Full Member
+10
 
Thank you for this information about Excel. I really needed to learn more about the program.
Full Member
+10
 
nice presentation
Basic Member
 
Very informative!
Full Member
+7
 
Thank you for this information! Great for my UIL kiddos
more reviews ...