Request a Catalog.

7 Powerful Excel Features Every Government User Needs to Know

Recording Date: January 27, 2016
Price: Free

Attending this Webcast is free. Registration is required.
Sign-up for your Free MyAMA account now or call 1-800-262-9699.


Take Your Spreadsheet Skills to the Next Level

Many government employees use Microsoft Excel® only occasionally for updating figures on a monthly report, creating a budget, or preparing mailing lists.  Being comfortable using Excel is a great skill to have, but becoming a more knowledgeable user is even better.

When you master some power-user tricks, you'll be more productive and valuable at work.

While it is important to play around with Excel and try different functions, having an expert walk you through the process is so much better.

During this webcast, you’ll get a step-by-step demonstration of some key Excel features that can truly advance your skills and boost your productivity.

What You Will Learn

This training course is particularly useful if you are a new or intermediate Excel user. For 60 minutes, you’ll learn about:

  • Customizing the Ribbon and Quick Access toolbar
  • Data sets vs. tables – which to use and why
  • Conditional formatting
  • Sorting and filtering data
  • Using AutoSum to total data quickly
  • Steps to grouping and subtotaling data
  • Building charts and using Sparklines to create visuals

You and your entire team will benefit from this informative program, so be sure to register today!

While attending this program is FREE, reservations are required.

Who Should Attend

This webcast is designed for government employees who have foundational knowledge of Microsoft Excel and would like to learn how to increase their productivity and take advantage of more advanced features.

Please note: The presenter will be demonstrating these methods and techniques using Excel 2010, but many of the methods and techniques can also be applied using other versions of Excel.

*Microsoft and Excel are registered trademarks of Microsoft.

About the Presenters

BJ Wilson  is a Microsoft Certified Trainer with Osprey Productions. In addition to being a Microsoft Certified Trainer, he is a Microsoft Certified Excel Expert. He has been helping people learn Microsoft Office for the past 10 years.


Related Seminars

For additional training on this topic, consider these AMA seminars:

ring Excel Pivot Tables
How to use this built-in Excel® tool to simplify your data analysis chores


Technical Requirements

To fully participate in this electronic, interactive and live session, please check your system (or ask your IT department) to ensure it meets the following requirements:

Supported OS, Browser and Additional Requirements

Microsoft® Windows® XP, Windows Vista, Windows 7, Windows

  • Internet Explorer 7 or higher, Mozilla Firefox, Google Chrome
  • Adobe® Flash® Player 11.2 or higher

Macintosh (OS X 10.5 or higher)

  • Mozilla Firefox, Apple Safari, or Google Chrome


  • Ubuntu 10.04 or higher; Red Hat Enterprise Linux 6; OpenSuSE 11.3
  • Mozilla Firefox

Test Your Computer

Please ensure that your computer is "Flash/Connect enabled" by clicking on the following link in order to run a short test:

If successful, you will receive a "Test Completed Successfully" message on the page.

Additional Requirements:

  • Minimum bandwidth requirement is 512 kbps for meeting attendees
  • POP-UP Blockers must be turned off to access the program
  • Additional Technical specs can be found here.

Important tip - Please allow 15 minutes prior to joining a session to conduct your set-up and testing!