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
4.65 (63 reviews)
298
students
7.5 hours
content
Aug 2024
last update
$64.99
regular price
What you will 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
Course Gallery
Loading charts...
Related Topics
1997674
udemy ID
30/10/2018
course created date
13/03/2020
course indexed date
Bot
course submited by