presents


National Seminars Group & Padgett Thompson
a division of Rockhurst University Continuing Education Center
Course Description


Advanced Microsoft® Excel For the Power User

Program Description   Who Should Attend

Workshop Agenda   Guarantee

Dates/Locations, Pricing, Register

What You’ll Learn  

Program Description

Now that you have the handle on Excel, push its potential to the max. Harness the full power of a VBA macro. Learn the Visual Basic for Applications language used by Excel and streamline a series of actions into a single command. Plus, get even more advanced techniques to analyze and share data.

What You’ll Learn

  1. Use the Visual Basic Editor to make changes in existing macros
  2. Streamline your access to your VBA modules with the VBE Project Explorer
  3. Take a look inside the Code Window
  4. Create interactive macros
  5. Pause your macro to allow for user input
  6. Create a new macro with the Visual Basic Editor
  7. Customize your dialog sheets with text boxes, radio buttons and dropdown lists
  8. Add Logic power to your macros with the If/Then command
  9. Debug a macro with the Step feature
  10. Turn your Excel workbook into a Web page and download data from an Internet site using a Web query
  11. Combine data from multiple users by setting up a shared workbook
  12. Use the AutoFilter and Advanced Filter to display information you need
  13. Plus, get the most advanced tips and tricks for the true power user

Who Should Attend

Your Guarantee of Complete Satisfaction

We stand behind our seminars with a 100 percent , iron-clad, money-back guarantee of satisfaction. If for any reason you’re not completely satisfied with the solid skills, the tips, tools and shortcuts, and the crucial information you receive during this workshop, we’ll refund your money in full. Every penny. Guaranteed!

Program Hours:
9:00 a.m. to 4:00 p.m. Registration begins at
8:30 a.m.


Group Discount: When 3 enroll from your organization, a 4th attends FREE!

Lunch:
Lunch is on your own.

Continuing Education:
Continuing education credits may be recognized by your professional board. Contact your own board to find out what's required. If you cancel your registration up to five business days before the workshop,

Bring a seminar to your site! For information about bringing a course to your site please call 919-480-2550 or email the registry at .

If this course or the dates/locations below do not have what you are looking for, then click here and we will find it for you right away. It will save you a lot of time and energy finding it yourself.

** Register Online**

Select date/location from list box below (Use side arrow to scroll). Complete form and click on 'Send'

Title: Mr. Mrs. Ms
Fields with an "*" are required input.
* Attendee Name:
Position:
* E-Mail:
Company:
* Address 1:
Address 2:
* City:
* State/Province:
* Zip/Postal Code:
Country:
* Phone:
* Fax:
* Contact first and last name:
Approving supervisor first and last name:
Click here to add more attendees.
Dollar Amount of Transaction:
(Please add appropriate sales tax if in SD or WV.)

Payment Information
Invoice Me, or
Credit Card Info:
Credit Card Type: American Express VISA Mastercard
Credit Card Number:
Expiration Date:
Name on Card:
 
PO # (if applicable):
Tax Exempt #:

Additional Attendees: Use for listing additional attendees only.
Attendee 2 Name:
Attendee 3 Name:
Attendee 4 Name:
(4th is FREE when you register 3)
Attendee 5 Name:
Attendee 6 Name:
Attendee 7 Name:
Attendee 8 Name:
(8th is FREE when you register 7)

Additional Information:

National Seminars Group will e-mail confirmation soon. If you are not paying via credit card, you will receive an invoice with payment instructions.

Cancellation Policy:
If you cannot attend a workshop for which you are registered, you may send a substitute or receive a credit memo toward a future workshop. If you cancel your registration up to five business days before the workshop, your registration fee will be refunded less a $10 enrollment charge.

You can also register by emailing your registration information to us at or calling us at 919-480-2550. Please mention the meeting number specified above and BE SURE TO STATE VIP CODE "919-120001-000 -- Training Registry".

Cover Page | Padgett Thompson Seminars



The Training Registry