Getting Started-Course files
Welcome
()
Is this course for you?
Subscribe to "Everyday Excel VBA" YouTube Channel!
For Mac users
The importance of a Course Certificate and the future of higher education
How to Switch Sessions of the Course
()
How to get help
Opening macro-enabled workbooks
Course files
Easy Projects: Lesson Choices-REAL-TIME CURRENCY CONVERTER
Currency Converter - Problem Statement
Introduction to the currency converter project
()
How to run a data query
()
Initializing the combo boxes and today's date
()
Importing data from the currency website using proper date format
()
Plotting the last 30 days
()
Easy Projects: Lesson Choices-GEOGRAPHY TOOLBOX
Geography Toolbox - Problem Statement
Introduction to the Geography Toolbox project
()
All about the "Geography Toolbox - STARTER.xlsm" file
()
How to populate the first set of combo boxes
()
How to populate the second set of combo boxes
()
How to utilize the combo box selections
()
How to calculate the distance between two points knowing latitude and longitude
()
Expectations for input validation and error handling
()
How to unhide and hide sheets
()
Intermediate Projects: Lesson Choices-ULTIMATE ORGANIZER
Ultimate Organizer - Problem Statement
Introduction to the Ultimate Organizer project
()
A demonstration of the Ultimate Organizer
()
How to add a category
()
How to add a new record, Part 1
()
How to add a new record, Part 2
()
How to reveal hidden labels and text boxes
()
How to add an icon to the Quick Access Toolbar to run your user form
()
Intermediate Projects: Lesson Choices-REGRESSION TOOLBOX
Regression Toolbox - Problem Statement
Introduction to the Regression Toolbox project
()
Introduction to the "Regression Toolbox - STARTER.xlsm" file
()
All about simple linear regression
()
All about general linear regression
()
(OPTIONAL): All about multilinear regression
()
Matrix approach to regression, Part 1
()
Matrix approach to regression, Part 2
()
A more complex example of the matrix approach to regression
()
Using Excel’s matrix functions in VBA code
()
What is adjusted R-squared?
()
Calculating adjusted R-squared
()
Plotting experimental data and model predictions in VBA
()
Monte Carlo Simulation-MONTE CARLO SIMULATION
Monte Carlo Simulation Problem Statement
Introduction to Monte Carlo simulation
()
Monte Carlo cookie example
()
How to output a random variable that follows a certain distribution
()
The uniform distribution
()
The discrete distribution
()
The normal distribution
()
The triangular distribution
()
The Beta-PERT distribution
()
How to apply a VBA user form to a Monte Carlo simulation
()
An overview of the profitability analysis spreadsheet
()
Grade Manager Project (for Honors)-GRADE MANAGER
Grade Manager - Problem Statement
Introduction to the Grade Manager Project
()
Creating a new folder inside a preexisting directory
()
Importing the Roster.xlsx file to a new sheet
()
Creating section rosters from main roster file, Part 1
()
Creating section rosters from main roster file, Part 2
()
Initializing column headings on section roster files
()
Syncing files, Part 1
()
Syncing files, Part 2
()
How to create a dated backup file
()
Adding a new grade item to all section sheets, Part 1
()
Adding a new grade item to all section sheets, Part 2
()
Adding a new grade item to all section sheets, Part 3
()
Search and replace tool
()