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

• Intermediate users who know the basics but want to learn how to make the most of Excel's features and functions
• Self-taught users who want to push their skills to the next level
• Advanced users who are eager to learn additional shortcuts and tips that will boost their speed and productivity in Excel

“Short and to the point, covering all bases, knowledgeable to all questions.”
L. Ledesma
Payroll Manager

"I've attended many events through National Seminars Group and have not once been disappointed with the skills I've learned. Today may have even been the best seminar yet. I learned many new things and was refreshed on things I'd learned in the past. Thank you!"
O. Unell
VP of Sales
Brighton Express

"Speaker was energetic and provided insight into issues and situations that I deal with at work and home ... great information and presentation."
L. Morton
Office and Program Coordinator

“The day went by quickly and was packed with valuable information. Presented with clear ‘how-to’s,’ ‘whys,’ etc., without a lot of wasted words.”
P. Lympany
Fiscal Services Supervisor
Burbank School District