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.

• 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.

Who Is Attending

Add Comment

Comments (0)


About the Extension Foundation

The Extension Foundation was formed in 2006 by Extension Directors and Administrators. Today, the Foundation partners with Cooperative Extension through liaison roles and a formal plan of work with the Extension Committee on Organization and Policy (ECOP) to increase system capacity while providing programmatic services, and helping Extension programs scale and investigate new methods and models for implementing programs. The Foundation provides professional development to Cooperative Extension professionals and offers exclusive services to its members. In 2020 and 2021, the Extension Foundation has awarded 85% of its direct funding back to the Cooperative Extension System, 100% of funds are used to support Cooperative Extension initiatives. 

This technology is supported in part by New Technologies for Agriculture Extension grant no. 2020-41595-30123 from the USDA National Institute of Food and Agriculture and membership funding. Any opinions, findings, conclusions, or recommendations expressed in the content are those of the author(s) and do not necessarily reflect the view of the U.S. Department of Agriculture. For more information, please visit You can view the terms of useat

Link copied to your clipboard.