A Gentle Introduction To Advanced Excel Techniques and VBA

Take your EXCEL skills to the next level . Learn basic data analysis , lookup techniques, macros and programming in VBA

Created by: Charlie Chiarelli
Experienced Online Educator

What Will I Learn?

• Review some Excel basics to get you up to speed
• Analyze spreadsheet data using goal seek and solver
• Implement pivot tables to analyze complex data in a variety of ways
• Use advanced Excel commands which incorporate conditional statements
• Implement look up tables using the vlookup and index commands
• Create simple macros to automate specific procedures
• Create user defined functions
• Create simple VBA (Visual Basic Applications) incorporating string and numeric variables
• Create simple applications which incorporate combo boxes, dialog boxes and other UI interface controls
• Create simple applications which check user input using the concepts of Selection (IF) and Repetition(DO...LOOP)
• Create Menu driven workbooks
• Implement user friendly input techniques by creating custom user forms
• Create a fully functioning Budget Application to track household or business expenses

Requirements

• A recent version of Excel (most techniques taught will work with Office Version 97 or later ...the actual course was created using Excel 2016)
• Should have at least a beginners knowledge of how to use Excel

Target audience

• Individuals looking to enhance their Excel skills to perform advanced data analysis and automation (macros, programming in VBA)