Need Help? Call us at (281) 541-2807 Visit our Facebook Page Follow us on Twitter Subscribe to our RSS Feeds

Advanced Training for Microsoft Excel

presented by National Seminars Group
View the National Seminars Group Profile and Course Listings

Bring a trainer to your location to deliver this class for groups of 10 or more.

Summary

An intensive day of training that puts you in command of Excel’s most advanced features and functions

Workshop Description/Agenda

Thanks to an exciting training opportunity coming to your area, you can get up to speed fast on the most advanced features for improving your efficiency and expanding your capabilities in Excel. Advanced Training for Microsoft® Excel, a comprehensive one-day learning event, has been developed for Excel users who’re ready to put this amazing software to work for amazing results.

Excel, the longstanding powerhouse of spreadsheet software, is one of the most commonly used business applications on the planet. As an Excel user, you know that the software has unlimited capabilities for making your job easier and less stressful. But learning the countless features available to you can be a daunting task. This workshop will teach you the most advanced features and functions Excel offers – taking your level of proficiency from basic to advanced. After one day of training you’ll be amazed at how this powerful program can work for you.

What You'll Learn:

  1. Use Visual Basic for Applications to create macros that will execute scores of commands with a single click.
  2. Analyze millions of cell values and distill that data into meaningful information you can use.
  3. Let VBA walk you through setting up simple macros that can create reports, generate statistics, and develop new data files.
  4. Build macros that not only create monthly reports but automatically reset each team member’s worksheets with new YTD and quarterly totals.
  5. Use the Visual Basic Editor to enhance the power and flexibility of your existing macros.
  6. Create interactive macros that will prompt users for required data and check entries for accuracy.
  7. Quickly develop dialog sheets with text boxes, radio buttons, check boxes, and pull down lists for more accurate data entry.
  8. Set macros to utilize logical constructs such as If … Then statements to perform data evaluation and correction for your users.
  9. Automatically generate reports, graphs, statistics, and totals from data entered by multiple users in a shared workbook.
  10. Quickly publish your Excel workbook with graphs, charts, and reports as a Web page – complete with interactive options.
  11. Quickly, cleanly draw out crucial records with the AutoFill and Advanced Filter options.
  12. Let Excel’s PivotTable and PivotChart features manage millions of cell values to create useful statistics in just seconds.
  13. Use statistical, financial, database, and other functions to provide unmatched accuracy and reliability to your department and corporate reports.
  14. Easily create sophisticated graphs that shine with professional polish with the tips and tricks you’ll learn.
  15. Download extensive Internet data onto an Excel spreadsheet and quickly organize it into useful reports and statistical analysis.

Who Should Attend?

This training has been designed for Excel users who’re ready to tap into the advanced features and functions for increased efficiency and productivity, and for greater capability to analyze and share data.

  • Managers and supervisors
  • Office managers
  • Accounting and finance professionals
  • Administrative assistants
  • Project managers
  • Sales managers
  • Business professionals
  • Anyone who generates reports, analyzes data, or uses spreadsheets in their work

Workshop Agenda:

Easy Editing Techniques

  • Using the Advanced Filter and AutoFilter to display the information you need
  • Controlling multiple ranges with AutoFill
  • Extracting filtered ranges
  • Using multiple criteria for creating advanced filters, databases, and list management
  • Time-saving keyboard shortcuts

Sharing Workbooks

  • Setting up shared workbooks
  • View users sharing a workbook
  • Change the updated frequency
  • Merging shared files
  • Creating pull-down menus for shared workbooks

More Than Your Basic Macro

  • Macro review: Running, stopping, and pausing macros
  • Assign macros to buttons and objects
  • Starting Visual Basic Editor (VBE)
  • Using VBE to create new macros and edit existing ones
  • Using Variables in macros
  • Creating interactive macros
  • Debugging macros with the Step feature Editing Steps for Macros
  • Editing existing macros from the macros menu
  • Editing existing macros using Editor
  • Streamlining your access to VBA modules with Project Explorer
  • Where to find free Visual Basic Code for macros

Formulas and Functions

  • Building complex formulas quickly and easily
  • Using the Function Palette and cutting your work time in half
  • Using key logic functions If, And, Or, and Not to make data more usable
  • Creating conditional formulas
  • Using Match, Index, V, and HLookup in large worksheets
  • Manipulating text entries with Excel’s extensive set of functions and formulas

Using Analytical Options

  • Using Goal Seek and Solver
  • Working with the Analysis Toolpak
  • Working with scenarios to analyze data and equations
  • Working with view options

Advanced Charting, Tables, Databases, and Lists

  • Using auditing to create a visual map of your data
  • Creating custom charts for added interest and relevance to your reporting
  • Exploring database functions
  • Working with data forms
  • Creating data tables
  • How to create and manage PivotCharts and Tables

Who Should Attend

This training has been designed for Excel users who’re ready to tap into the advanced features and functions for increased efficiency and productivity, and for greater capability to analyze and share data.

Additional Information

Training Provider: National Seminars Group

Course Topics: Computers / Software Training > Office Software

Training Course Summary: An intensive day of training that puts you in command of Excel’s most advanced features and functions


Find Similar Training Find Similar Training
Email This Training's Information Email This Page

Live Seminar Dates/Locations

JAN 22    IN CAPE GIRARDEAU, MO
JAN 23    IN COLUMBIA, MO
JAN 24    IN SPRINGFIELD, MO
JAN 25    IN JOPLIN, MO
JAN 30    IN OMAHA, NE
JAN 31    IN DES MOINES, IA
FEB 1    IN CEDAR RAPIDS, IA
FEB 6    IN AUSTIN, TX
FEB 25    IN SIOUX CITY, IA
FEB 25    IN EUGENE, OR
FEB 25    IN ZANESVILLE, OH
FEB 26    IN AKRON, OH
FEB 26    IN SPENCER, IA
FEB 26    IN PORTLAND, OR
FEB 27    IN INDEPENDENCE, OH
FEB 27    IN SIOUX FALLS, SD
MAR 1    IN RAPID CITY, SD
MAR 4    IN GREEN BAY, WI
MAR 4    IN BILLINGS, MT
MAR 5    IN BROOKFIELD, WI
MAR 6    IN BLOOMINGTON, MN
MAR 7    IN DULUTH, MN
MAR 8    IN ST CLOUD, MN
MAR 12    IN COLUMBUS, OH
MAR 13    IN DAYTON, OH
MAR 14    IN INDIANAPOLIS, IN
MAR 22    IN BOWLING GREEN, KY
MAR 25    IN ERIE, PA
MAR 26    IN BUTLER, PA
MAR 27    IN ALTOONA, PA
MAR 28    IN JOHNSTOWN, PA
MAR 29    IN PITTSBURGH, PA
APR 1    IN MONTEREY, CA
APR 4    IN PARKERSBURG, WV
APR 9    IN WAUSAU, WI
APR 10    IN APPLETON, WI
APR 18    IN VIRGINIA BEACH, VA
APR 23    IN HAGERSTOWN, MD
APR 24    IN WASHINGTON, DC
APR 25    IN ANNAPOLIS, MD
APR 26    IN DOVER, DE
APR 29    IN AUGUSTA, ME
APR 30    IN SOUTH PORTLAND, ME
MAY 1    IN ANDOVER, MA
MAY 2    IN WEST LEBANON, NH
MAY 3    IN MANCHESTER, NH
MAY 6    IN FARMINGTON HILLS, MI
MAY 7    IN ANN ARBOR, MI
MAY 8    IN EAST LANSING, MI
MAY 9    IN JACKSON, MI
MAY 9    IN BOISE, ID
MAY 10    IN KALAMAZOO, MI
MAY 10    IN SPOKANE, WA
MAY 14    IN OAK BROOK, IL
MAY 16    IN COLUMBUS, IN
MAY 20    IN RUTLAND, VT
MAY 20    IN FT COLLINS, CO
MAY 21    IN BURLINGTON, VT
MAY 21    IN BOULDER, CO
MAY 22    IN GOLDEN, CO
MAY 22    IN PLATTSBURGH, NY
MAY 23    IN DENVER, CO
MAY 28    IN CINCINNATI, OH
MAY 29    IN LEXINGTON, KY
JUN 4    IN EDISON, NJ
JUN 5    IN PARSIPPANY, NJ
JUN 6    IN NEW YORK CITY, NY
JUN 10    IN GLENS FALLS, NY
JUN 11    IN ALBANY, NY
JUN 13    IN ROCHESTER, NY
JUN 24    IN MIDDLETOWN, NY
JUN 25    IN POUGHKEEPSIE, NY
JUN 26    IN TARRYTOWN, NY
JUN 27    IN NORTH HAVEN, CT