$399 – $425

Microsoft Excel - From User to Power User

Actions and Detail Panel

$399 – $425

Event Information

Share this event

Date and time

Location

Location

Online event

Event description
In this jam-packed course, you’ll discover MANY time-saving techniques that will make you an Excel POWER USER!

About this event

In this jam-packed course, you’ll discover time-saving techniques through the use of Excel. You will learn from design and formatting; formulas and data analysis; hidden charting and graphing techniques; PivotTable and PivotChart® reports; how to validate and secure your data and much more!

What Will We Cover?

  • An in-depth knowledge of Excel's ribbon, menus, and functions, including how to create new tabs and hide the ones you never use
  • Quick and easy techniques to import data from virtually any kind of file or database system, such as Microsoft Access, or SQL Server®
  • How to use Excel to quickly create professional-looking forms in minutes (not hours!)
  • Add control items to your worksheets, including checkboxes, spinner buttons, and many others
  • Formulas versus Functions – The differences you need to know
  • Understand the most common text functions like UPPER, PROPER, and CONCAT
  • Discover how to use IF functions to make logical comparisons
  • Understand the purpose – and drawbacks – of VLOOKUP
  • Write formulas with relative and absolute cell references and know exactly when to use each one
  • Quickly create custom AutoFilters to view your data the way that tells the story you need to know
  • Use the new Search Filter to quickly narrow down the available filter options in your tables, PivotTable, and PivotChart views.
  • Find exactly what you are looking for from up to a million items, instantly.
  • How to quickly create a basic chart with a single keystroke
  • Insert Sparklines into cells to instantly reveal trends in your data
  • The quick and easy way to display your data using a PivotChart®
  • How to use the hidden advanced data analysis tools in a PivotTable report
  • The easy, visual way to immediately change and restructure the information reported in your PivotTable
  • How to share your Excel workbook and not worry about someone making changes that’ll ruin your work
  • And MORE!

To view/print this event flyer, CLICK HERE.

This workshop is a 2-day event and will begin each day at 10:00 AM Eastern and end at 5:00 PM Eastern.

Share with friends

Date and time

Location

Online event

Organizer Leader Development Institute

Organizer of Microsoft Excel - From User to Power User

Save This Event

Event Saved