Questions?

1.800.258.7246


home  |  about us  |  view cart  |  search

Follow us on: FacebookTwitterGoogle+LinkedIn
National Seminars Training - Your Complete Learning Center SEMINAR FINDER
State:
ZIP:
Sign Up for Emails or Special Offers
Email:
ZIP:
One-day Advanced Training for Microsoft Excel
An intensive day of training that puts you in command of Excel’s most advanced features and functions

Price: $179.00 per person Register Now
Live Seminar Date and Location:
Sonesta Downtown Hotel
1800 Market Street
Philadelphia, PA 19103


Date: December 18, 2017
Time: 9:00 AM - 4:00 PM
Additional Dates/Locations in Your Area:
  • December 19, 2017  |  Allentown, PA  |  Details
  • December 20, 2017  |  Lancaster, PA  |  Details
  • April 03, 2018  |  Annapolis, MD  |  Details

Program Description:
One-Day Seminar
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.

Your expert instructor will use our exclusive hands-off training approach that features state-of-the-art projection equipment. This method guarantees that you’ll learn — and retain — a maximum amount of information in a minimum amount of time!

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.

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
QUICK LINKS

STAR12

Corporate Training

CEU/CPE Information

Cancellation Details



NO EVENTS SHOWING IN YOUR AREA?
We can bring this training to you! We can tailor this (or any) program to meet your organization’s exact needs. Call one of our training consultants today at 1-800-344-4613 for more information!

RELATED WEBINARS

Need training, but don’t have time to get out of the office? Then take a look at our related webinars. They are a fast and convenient way to get the training you need ... right from your own computer.

12/19/17
Organizing and Managing Data in Microsoft Excel®

01/18/18
How to Use Microsoft Excel Pivot Tables to Easily Summarize and Analyze Data

01/23/18
Microsoft® Outlook® Tips, Tricks, and Techniques

02/05/18
Unlocking the Secrets of Adobe® Acrobat®

02/09/18
Increase Productivity Using Google Docs™ and Spreadsheets

CUSTOMER SERVICE: 1.800.258.7246
National Seminars Training
1.800.258.7246