Short Series on Microsoft Excel 2010

      Comments Off on Short Series on Microsoft Excel 2010
(Last Updated On: February 23, 2018)

In a recent survey, I asked the folks working with the University of Wyoming Extension what I should be providing training on. The number one topic was Microsoft Excel. Here are four recent training sessions I held on the topic:

Microsoft Excel 2010 Basics

Microsoft Excel is an extremely powerful tool when used correctly.  This is the first presentation of a series on Microsoft Excel and will cover the basics. With the basics under your belt, you will be able to create complex planning and tracking documents. Using examples such as expense reports and invoices, we will explore these basic features.

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

Learn:
• How to customize the menu and ribbon bars
• How to add, move, delete, and format content
• How to create and use basic formulas
• How to work across multiple worksheets and workbooks
• How to create and use basic formulas
• How to print worksheets

Working with data tables

This presentation will build on the basics of Excel presented previously. Excel has the ability to hold over 1 million records on a single worksheet. This presentation will help you manage the data you enter. You will learn how to control information presented as well as sort and filter information to suit your needs. 

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

Learn:
• How to create a data table
• How to add content to data tables to include using Excel forms
• How to import external data
• How to sort and filter data
• How to control the look and feel of data tables and ranges
• How to create a basic pivot table
• How to merge data tables into Word documents or Outlook Email messages

Working with Ranges, Lookup Tables, and Text

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

Working with charts and images

Once you have data entered into Excel, you can use charts to help tell a story. This presentation will help you create charts and format the resulting chart to tell the best story possible. You will learn how to change the look of the chart as well as add informational elements.

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

Learn:
• How to use themes to quickly customize a table or chart.
• How to add a chart to a workbook
• How to modify chart features
• How to add analysis tools such as trendlines to a chart
• How to modify the look of charts with images

 

What other topic would you like me to work on?