Course ID: EXCLSUPR

Excel Boot Camp for the Super-User

This course covers data cleanup and manipulation topics going beyond the Excel macro recorder learning how to edit visual basic code to accomplish macro steps that cannot be recorded such as IF testing, repetition, debugging code, and interaction with the user of the file. Advanced Pivot Table reporting features will also be covered. Many tips are given to enhance your work with Excel.


LEARNING OBJECTIVES
  • Upon completion of this course, participants will be able to:
  • Record and run macros related to data cleanup and repetitive tasks
  • Add and edit VBA code in the Visual Basic Editor that cannot be recorded
  • Add code for the Message Box and the Input Box
  • Add code for IF testing and Looping
  • Use the Visual Basic tools on the Developer Ribbon tab
  • Utilize best practices for structuring code and using VBA objects
  • Protect your VBA code
  • Perform advanced data analysis and reporting in Excel

MAJOR TOPICS
  • Exploring uses of the macro recorder for data cleanup and other tasks
  • Working with visual basic code in the Visual Basic Editor modules
  • Editing visual basic code
  • Understanding relative vs. absolute cell pointer movement
  • Incorporating decision-making code examples
  • Incorporating code examples for repetition
  • Understanding best practices for using variables
  • Using custom message boxes
  • Using custom input boxes to collect information
  • Debugging, testing, and protecting macro code
  • Utilizing auto-open and auto-close macros
  • Adding objects including buttons and tools
  • Building a complete macro project in the class
  • Incorporating advanced Pivot Table features and dashboards

DESIGNED FOR
CPAs and finance professionals who already work at an advanced level in Excel and desire to learn tips to improve productivity

FIELD OF STUDY
Computer Software & Applications

PREREQUISITES
Strong familiarity with Excel features

COURSE PRODUCER
Business Learning Institute

CPE CREDITS
8.0

LEVEL
Advanced

This course is available for your group as:

Group Live
 

Let's Roll!

To learn more or customize this course for your group, complete this form and a BLI team member will get back with you shortly.


Or, contact BLI: 888-481-3500 or learn@blionline.org