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

Overview

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.

Details

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

Full Member
 
very helpful...thanks
Full Member
 
Thank you so much for this information. Very Useful info.
Full Member
 
informative
Full Member
+7
 
Thanks!
Basic Member
+7
 
a nice basic overview - I was hoping for something more advanced though
more reviews ...