Advanced Training for Microsoft Excel Seminar training classes conferences & workshops presented by National Seminars Training Group register for training on FindaSeminar.com

Home

Add your seminars

Training Calendar Creator Seminar Venues Training Provider Directory
 

New Seminar Search:  

 
find similar training...
Search by state...
Email this event ...

Customer Support


Do you need help finding the right class, date, or location or other assistance?

Request information about upcoming training seminars workshops and conferences in   and other cities listed on FindaSeminar.com Submit a support request and receive a prompt reply.

We guarantee this National Seminars Training Group training seminar

We are an authorized partner of National Seminars Training Group

 

Price protection. The price to attend Advanced Training for Microsoft Excel is set by the training providerThere is no added charge for our services.

We honor most training provider coupons
*.   Call  a representative to see if your discount coupon applies.


Privacy. Your personal information won't be shared with anyone but the training provider National Seminars Training Group.


Security. When you register for this seminar on FindaSeminar.com your personal data and payment information is safely collected and processed using secure SSL encryption technology.

Flexibility. FindaSeminar.com offers you three ways to register for Advanced Training for Microsoft Excel seminar by National Seminars Training Group.
Register online, by phone, or fax.
Who should attend Advanced Training for Microsoft Excel
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.
Reviews
Write and read National Seminars Training Group reviews and reviews about the training seminar Advanced Training for Microsoft Excel on the Seminar News Network and the Training News Network.
 

Frequently asked questions and registration options for the training seminar Advanced Training for Microsoft Excel

 
Find Training Near You
Use our clickable map to find training near you
Use Our Clickmap
 
Education and training domain names

Education and training news articles

hotel seminars meeting space directory
hotel meeting space training facilities restaurant and lodging

 

Advanced Training for Microsoft Excel  

 Email information about this seminar Advanced Training for Microsoft Excel by National Seminars Training Group to yourself your manager or associates Email this event... View and register for other training seminars like Advanced Training for Microsoft Excel by National Seminars Training Group on FindaSeminar.com Find similar training.. Find and register for other training seminars by National Seminars Training Group on FindaSeminar.com Other seminars from National Seminars Training Group

By:

training seminars by National Seminars Training Group National Seminars Training Group   

For:

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.

Cost:   

see Registration info for seminar cost, group discount etc.

Seminar Summary:

An intensive day of training that puts you in command of Excel’s most advanced features and functions (see full course description)

 
 

 Seminar / Training class dates & locations

 
 SORT RESULTS BY:

 DATE

LOCATION

SELECTED VENUE DETAILS

Facility Name: 
Address:





Registration Information:

Event cost:  $
USD

class times and cancellation policy

 
 




 From 
 To 
 Click to register by Register by fax for Advanced Training for Microsoft Excel training seminar Register by mail for Advanced Training for Microsoft Excel training seminar Register by phone to attend Advanced Training for Microsoft Excel training seminar

Print payment approval request form Advanced Training for Microsoft Excel training seminar

Pre-Registration questions? Find answers in our registration FAQ or Request information about upcoming training seminars workshops and conferences in   and other cities listed on FindaSeminar.com Submit a support request

 
 
 

 

share this page 

print the agenda print agenda for the Advanced Training for Microsoft Excel seminar

 

 

Training Course Syllabus:


Advanced Training for Microsoft® Excel

Program Description:

Supervision Is All About Outcomes

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.
 

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. Easily create sophisticated graphs that shine with professional polish with the tips and tricks you’ll learn.

 

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

 

SEMINAR TRAINING TIME:

Seminar Check-In  8:30 AM    Seminar Class 9:00 AM - 4:00 PM

Seminar Summary:

An intensive day of training that puts you in command of Excel’s most advanced features and functions (see full course description)

print this agenda print agenda for the Advanced Training for Microsoft Excel training seminar

 view dates and locations for this seminar

 

 

     
 

 
     

 

  Also try the advanced seminar search tool

   FindaSeminar HomeComputer Training

unix training
training classes

 © 2002-2014 FindaSeminar.com™ All Rights Reserved.  Terms of Use |  Privacy Policy |  Training News Network

   

Custom Search