Skip to main content

Microsoft 2010 Excel - Working with Ranges, Lookup Tables, and Text

Microsoft Excel is an extremely powerful tool when used correctly.  This presentation will build on the basics of Excel tables presented previously. By naming tables and ranges, you can simplify formulas as well as conduct amazing look-up capabilities. This presentation will show you how to pull data from ranges. This presentation will also show you how to manipulate text.

During this Webinar, see how you can use basic features of Microsoft Excel.

Learn: 
• How to use relative and absolute cell references.
• How to rapidly calculate sums or averages of entire columns
• How to calculate across multiple worksheets
• How to add analysis and find formulas on a worksheet
• How to name ranges and tables
• How to look-up data in a table or range
• How to manage text data


This session will be held using Google+ Hangouts on Air.

https://plus.google.com/u/0/ev...iu0j5be960

Who Is Attending

Add Comment

Comments (0)

Post

About the Extension Foundation

This website is supported in part by New Technologies for Ag Extension (funding opportunity no. USDA-NIFA-OP-010186), grant no. 2023-41595-41325 from the USDA National Institute of Food and Agriculture. Any opinions, findings, conclusions, or recommendations expressed in this publication are those of the author(s) and do not necessarily reflect the view of the U.S. Department of Agriculture or the Extension Foundation. For more information, please visit extension.org. You can view the terms of use at extension.org/about/terms.

×
×
×
Link copied to your clipboard.
×