/training/webcasts/7-Powerful-Excel-Features-Every-Government-User-Needs-to-Know.aspx
Request a Catalog.
Share

7 Powerful Excel Features Every Government User Needs to Know

(Read reviews)
On-Demand
Price: Free


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

Overview

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

 
best live chat

Technical Requirements

http://event.on24.com/view/help/ehelp.htmlTo 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

  • Windows 7+ (Microsoft Edge, Latest Internet Explorer, Firefox, or Chrome)
  • Apple Mac OS 10.9+ (*Latest Firefox, Safari, or Chrome)
  • Ubuntu Linux (Firefox only)
  • Android 4.x (Chrome Browser Only)
  • Apple iOs (*Latest version, Safari Browser Only)

* Official support for the "latest" version of a newly released browser, among those noted above, will be added within 8 weeks of public release. Until then, the previous version will continue to be supported instead.

If you are using an unsupported version of a Windows, Mac, or Linux operating system, you may experience difficulty in viewing and/or listening to the event.

Test Your Computer

The audio portion of this AMA web event will be delivered directly through your computer’s speakers or attached headphones. To fully participate in this electronic, interactive, live session, please test your system and review the requirements (or ask your IT department) before the program begins:

TEST NOW

Additional Requirements:

  • Minimum bandwidth requirement is 512 kbps for meeting attendees
  • In order to access the event, your computer must have cookies and JavaScript enabled. If your operating system currently does not have cookies or JavaScript enabled, contact your network administrator.
  • POP-UP Blockers must be turned off to access the program.

Still need Help? Additional technical information can be found here. You can also view these tips in Spanish and French.

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