Seminar Advanced Training for Microsoft Excel Seminar

Presented by National Seminars Group

National Seminars Group

Bring this seminar on-site to your facility for groups of 10 or more.

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

Course Description


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

 

More Seminar Information

National Seminars Group
National Seminars Group

Summary

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

Delivery Method

Seminar Seminar

Also Available As

On-Site Training On-Site Training

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.

 
Search similar training
Email this page
Print this document
 

Dates and Locations

Duluth, MN
3/31/2020 - 3/31/2020
Tuition: $189

St Cloud, MN
4/1/2020 - 4/1/2020
Tuition: $189

Bloomington, MN
4/2/2020 - 4/2/2020
Tuition: $189

Brookfield, WI
4/3/2020 - 4/3/2020
Tuition: $189

Madison, WI
4/6/2020 - 4/6/2020
Tuition: $189

see all dates/locations

 

Frequently Asked
Questions

Payment Options
Bill Me/Invoice
Credit Card

Register
Online
Fax Form

Availability
Select a date from the list at the bottom of the page for specific information about that class.

Other Information
Seminar

All Date/Location Information

California (Find training in California)
4/28/2020-4/28/2020 in Monterey, CA         Find a seminar in Monterey CA
6/22/2020-6/22/2020 in San Diego, CA         Find a seminar in San Diego CA
4/27/2020-4/27/2020 in San Jose, CA         Find a seminar in San Jose CA

Colorado (Find training in Colorado)
5/13/2020-5/13/2020 in Boulder, CO         Find a seminar in Boulder CO
5/15/2020-5/15/2020 in Denver, CO         Find a seminar in Denver CO
5/14/2020-5/14/2020 in Ft Collins, CO         Find a seminar in Ft Collins CO
5/12/2020-5/12/2020 in Golden, CO         Find a seminar in Golden CO

Connecticut (Find training in Connecticut)
6/5/2020-6/5/2020 in North Haven, CT         Find a seminar in North Haven CT

Idaho (Find training in Idaho)
5/18/2020-5/18/2020 in Boise, ID         Find a seminar in Boise ID

Illinois (Find training in Illinois)
5/7/2020-5/7/2020 in Arlington Heights, IL         Find a seminar in Arlington Heights IL
5/6/2020-5/6/2020 in Oak Brook, IL         Find a seminar in Oak Brook IL

Indiana (Find training in Indiana)
5/11/2020-5/11/2020 in Columbus, IN         Find a seminar in Columbus IN

Kentucky (Find training in Kentucky)
5/13/2020-5/13/2020 in Lexington, KY         Find a seminar in Lexington KY

Massachusetts (Find training in Massachusetts)
5/6/2020-5/6/2020 in Andover, MA         Find a seminar in Andover MA

Maryland (Find training in Maryland)
4/30/2020-4/30/2020 in Annapolis, MD         Find a seminar in Annapolis MD
5/1/2020-5/1/2020 in Hagerstown, MD         Find a seminar in Hagerstown MD

Maine (Find training in Maine)
4/15/2020-4/15/2020 in Augusta, ME         Find a seminar in Augusta ME

Michigan (Find training in Michigan)
5/19/2020-5/19/2020 in East Lansing, MI         Find a seminar in East Lansing MI

Minnesota (Find training in Minnesota)
4/2/2020-4/2/2020 in Bloomington, MN         Find a seminar in Bloomington MN
3/31/2020-3/31/2020 in Duluth, MN         Find a seminar in Duluth MN
4/1/2020-4/1/2020 in St Cloud, MN         Find a seminar in St Cloud MN

North Dakota (Find training in North Dakota)
6/2/2020-6/2/2020 in Bismarck, ND         Find a seminar in Bismarck ND
6/3/2020-6/3/2020 in Fargo, ND         Find a seminar in Fargo ND

New Hampshire (Find training in New Hampshire)
5/13/2020-5/13/2020 in Manchester, NH         Find a seminar in Manchester NH
5/14/2020-5/14/2020 in West Lebanon, NH         Find a seminar in West Lebanon NH

New Jersey (Find training in New Jersey)
6/18/2020-6/18/2020 in Parsippany, NJ         Find a seminar in Parsippany NJ

New York (Find training in New York)
6/3/2020-6/3/2020 in Albany, NY         Find a seminar in Albany NY
6/1/2020-6/1/2020 in Buffalo, NY         Find a seminar in Buffalo NY
6/17/2020-6/17/2020 in Melville, NY         Find a seminar in Melville NY
6/16/2020-6/16/2020 in New York City, NY         Find a seminar in New York City NY
6/4/2020-6/4/2020 in Poughkeepsie, NY         Find a seminar in Poughkeepsie NY
6/2/2020-6/2/2020 in Syracuse, NY         Find a seminar in Syracuse NY

Ohio (Find training in Ohio)
5/12/2020-5/12/2020 in Cincinnati, OH         Find a seminar in Cincinnati OH

Texas (Find training in Texas)
6/15/2020-6/15/2020 in San Antonio, TX         Find a seminar in San Antonio TX

Virginia (Find training in Virginia)
4/29/2020-4/29/2020 in Fairfax, VA         Find a seminar in Fairfax VA
4/28/2020-4/28/2020 in Virginia Beach, VA         Find a seminar in Virginia Beach VA

Vermont (Find training in Vermont)
5/15/2020-5/15/2020 in Burlington, VT         Find a seminar in Burlington VT

Washington (Find training in Washington)
5/19/2020-5/19/2020 in Spokane, WA         Find a seminar in Spokane WA

Wisconsin (Find training in Wisconsin)
4/3/2020-4/3/2020 in Brookfield, WI         Find a seminar in Brookfield WI
4/6/2020-4/6/2020 in Madison, WI         Find a seminar in Madison WI

West Virginia (Find training in West Virginia)
4/24/2020-4/24/2020 in Charleston, WV         Find a seminar in Charleston WV
4/23/2020-4/23/2020 in Parkersburg, WV         Find a seminar in Parkersburg WV