Advanced Excel Analytics: VBA Programming
Wednesdays, June 3rd & 10th, 2020
1:00 PM - 4:00 PM Eastern Time
Computer Software & Applications
This course focuses on using Visual Basic for Applications scripts, the programming language which Excel uses to write functions and custom macros. The use of user forums, which control macro events, is also discussed. The seminar features a revised and updated in-depth case study analysis and includes a look at new and updated features and functionality tools of more recent Excel versions. All examples and illustrations will utilize financial and treasury applications.
- Understand the use of VBA and its relation to macros
- Identify the key parts of the Visual Basic Editor
- Utilize VBA to write simple functions and subroutines
- Debug programs using VBA tools
- Explore updated Excel tools In more recent versions of the program
Advanced understanding of Excel/Excel Programming, and scripting of macros and functions.
SpeakerBill Hu, PhD, CFA, CTP
Professor of Finance, Arkansas State University
Arkansas State University
As a recipient of the Excellence in Teaching award from the Neil Griffin College of Business at ASU, Dr. Hu keeps his classes current and relevant by reaching out to the finance industry onsite and online covering topics such as Revenue Forecasting, Financial Modeling, Integrated Financial Statements, Data Analytics and Visualization, Simulations, Big Data, and Excel. Over the years, he has trained thousands of finance professionals on these topics.
Dr. Hu's research includes pricing strategies, market microstructure, behavioral finance, etc. When writing doctoral essays in 2008, Dr. Hu applied machine learning (ML) to classify stock spam emails and disseminated the impacts of spam messages on financial markets in multiple research papers. Recently, he has started projects related to cryptocurrencies. Prior to the study of finance, Dr. Hu was a nanotechnologist and had a variety of scholarly articles and patents in the field of chemistry.