Excel VBA Finance and Invest One Day Bootcamp
- Beginner
- 18 and older
- $349
- Earn 3,490 reward points
- Price Lock Guarantee
- 185 Madison Ave, New York, NY
- 7 hours & 30 minutes
May 1st
10am–5pm EDT
Discover Classes. Earn 10% Rewards.
Excel VBA Finance and Invest One Day Bootcamp is unfortunately unavailable
Thankfully we have 40 other Excel Classes for you to choose from. Check our top choices below or see all classes for more options.
Excel Level I: Fundamentals
Noble Desktop @ 185 Madison Ave, New York, NY & Virtually Online
Master the essentials of Microsoft Excel in this practical hands-on workshop. Learn calculations, functions, graphs, formatting, and printing, and gain the skills you need to excel in data management. Expand your proficiency with Noble Desktop.
$249
20 Seats Left
May 7th
10am–5pm EDT
$249
20 Seats Left
May 13th
10am–5pm EDT
$249
20 Seats Left
May 17th
10am–5pm EDT
$249
20 Seats Left
May 28th
10am–5pm EDT
$249
20 Seats Left
This class has 24 more dates.
Tap here to see more
Wed, May 1st, 10am–5pm EDT
(7 hours)
Other dates (28)
Excel Level II: Intermediate
Noble Desktop @ 185 Madison Ave, New York, NY & Virtually Online
Take your Excel skills to the next level with an intermediate course that covers VLOOKUP, Pivot Tables, and more. With Noble Desktop, you'll gain the expertise needed to manipulate and analyze data effectively. Enhance your Excel abilities today.
Apr 28th
10am–5pm EDT
$249
20 Seats Left
May 2nd
10am–5pm EDT
$249
20 Seats Left
May 8th
10am–5pm EDT
$249
20 Seats Left
May 14th
10am–5pm EDT
$249
20 Seats Left
May 20th
10am–5pm EDT
$249
20 Seats Left
This class has 23 more dates.
Tap here to see more
Sun, Apr 28th, 10am–5pm EDT
(7 hours)
Other dates (27)
Excel Specialist Certification Program
NYC Career Centers @ 185 Madison Ave, New York, NY & Virtually Online
Enhance your Excel skills and gain a competitive edge in the job market with the Excel Specialist Certification Program. Master essential Excel functions, advanced formulas, and data management techniques while preparing for the Microsoft Excel certification exam. Elevate your career prospects with the top-rated Excel certification program in NYC.
May 1st
10am–5pm EDT
Meets 3 Times
$899
20 Seats Left
May 13th
10am–5pm EDT
Meets 3 Times
$899
20 Seats Left
May 28th
10am–5pm EDT
Meets 3 Times
$899
20 Seats Left
May 28th
10am–5pm EDT
Meets 3 Times
$899
20 Seats Left
Jun 3rd
10am–5pm EDT
Meets 3 Times
$899
20 Seats Left
This class has 15 more dates.
Tap here to see more
Wed, May 1st, 10am–5pm EDT
(21 hours over 3 sessions)
Other dates (19)
Excel Level III: Advanced
Noble Desktop @ 185 Madison Ave, New York, NY & Virtually Online
Take your Excel skills to the next level with advanced techniques and tools in this comprehensive course. Learn to manipulate and analyze complex data, utilize advanced functions, and write macros for improved efficiency. Master Excel and enhance your productivity in any professional setting.
May 2nd
6–9pm EDT
Meets 2 Times
$249
20 Seats Left
May 3rd
10am–5pm EDT
$249
20 Seats Left
May 5th
10am–5pm EDT
$249
20 Seats Left
May 15th
10am–5pm EDT
$249
20 Seats Left
May 30th
10am–5pm EDT
$249
20 Seats Left
This class has 15 more dates.
Tap here to see more
Thu, May 2nd, 6–9pm EDT
(6 hours over 2 sessions)
Other dates (19)
Excel Bootcamp
Noble Desktop @ 185 Madison Ave, New York, NY & Virtually Online
Master the power of Excel with a comprehensive 3-day course. From calculations to macros, become a pro in this essential business tool.
May 1st
10am–5pm EDT
Meets 3 Times
$549
20 Seats Left
May 13th
10am–5pm EDT
Meets 3 Times
$549
20 Seats Left
May 28th
10am–5pm EDT
Meets 3 Times
$549
20 Seats Left
Jun 3rd
10am–5pm EDT
Meets 3 Times
$549
20 Seats Left
Jun 4th
6–9pm EDT
Meets 6 Times
$549
20 Seats Left
This class has 14 more dates.
Tap here to see more
Wed, May 1st, 10am–5pm EDT
(21 hours over 3 sessions)
Other dates (18)
Sold Out
Start Dates (0)
- $349
- 7 hours & 30 minutes
Showing
1
–
0
of
0
Class Description
Description
What you'll learn in this excel class:
Step by step this course explains how to start building sophisticated financial models capital investment and financing decisions.
We start with Excel essentials and then move to Excel VBA (Visual Basic for Applications) programming.
This Excel Macro Course assumes no previous knowledge of Macros. This basic VBA class, that will help you apply skills to build quantitative models in excel.
Four projects for the course:
A laptop with installed Excel.
Who should attend:
Investment banking analysts and associates, Private equity, asset management and hedge fund associates, Corporate finance and business development professionals, MBA students and business undergraduates, Anyone seeking to improve their Excel skills.
Total In-Class Time: 7.5 hours from 10:00 am - 5:30 pm.
We start with Excel essentials and then move to Excel VBA (Visual Basic for Applications) programming.
This Excel Macro Course assumes no previous knowledge of Macros. This basic VBA class, that will help you apply skills to build quantitative models in excel.
Four projects for the course:
- Multiple Linear Regression
- Logistic Regression
- Monte Carlo Simulation (AR1)
- Scraping data from Yahoo Finance
- Macros / VBA
- What are Macros?
- What is VBA?
- How to record macros
- How to run macros
- VBA Editor
- Modules
- Procedures
- Project Explorer
- Toolbars / Options
- Creating / Editing Code
- Create Procedures
- Subs
- Comments
- Invoking Macros
- Hot Keys
- Quick Access Toolbar
- Call Command
- Compiling Code
- Stepping through code
- Reset Run
- Variables
- Declarations
- Option Explicit
- Data Types
- Working with The Object Model
- Ranges: Rows, Columns, Cells
- Naming conventions
- Navigation / Selection Techniques
- Offsets
- Range Names
- Logic Statements
- IF Statements
- Looping Statements
- Do Loops
- Error Handlers, Preventing fatal errors and crashes
- Programming Control Structures
- How to use Variables and Arrays
- How to Write Programs With the Visual Basic Editor
- Decision Control: If/Then/Else and Select Case
- Flow Control: For/Next, Do While, For Each
- Macros vs Excel Formulas: Strengths and Weaknesses: When to avoid VBA and do it in excel?
- Introduction to VBA and Recording Macros
- Writing VBA Code - Introduction to Variables,
- Decision and Looping Controls
- Graceful Error Handling using ON ERROR
- Create User Defined Functions and Workbook Events
- Use the models in the class at your workplace
- How to Call Excel Functions and Write New Functions
- How to Call Excel Dialogs
- How to Debug and Fix Macros, How to Handle Errors
A laptop with installed Excel.
Who should attend:
Investment banking analysts and associates, Private equity, asset management and hedge fund associates, Corporate finance and business development professionals, MBA students and business undergraduates, Anyone seeking to improve their Excel skills.
Total In-Class Time: 7.5 hours from 10:00 am - 5:30 pm.
Refund Policy
To reschedule or cancel, email us at [email protected]
All courses include a non-refundable registration fee (10% of the undiscounted course price).
- Students may cancel up to 11 business days before the class/program start date and receive a refund, less the registration fee.
- Cancellations within 11 business days are not permitted; however, students may reschedule up to 4 business days before the class start date.
Note: Any refunds must be requested within 180 days from the original payment date; courses rescheduled within 11 business days of the start date are not eligible for refunds.
Reviews of Classes at Practical Programming (378)
Similar Classes
People who viewed this class also viewed the following classes
CourseHorse Gift Card
Practical Programming
Practical Programming classes and workshops for everyone who wants to learn how to code from scratch or practice Python. You will learn how to start using Python, problem solving with algorithms and make dynamic web applications.
No coding experience needed, anyone who would like to learn how to code...
Read more about Practical Programming
This school has been carefully vetted by CourseHorse and is a verified NYC educator.
Practical Programming
Midtown, Manhattan
185 Madison Ave 3rd Fl
Btwn E 34th & E 35th Streets
New York, New York 10016 Midtown, Manhattan
185 Madison Ave 3rd Fl
Btwn E 34th & E 35th Streets
New York, New York 10016
We are located in New York City on 34th street and Madison Avenue, a few blocks from Penn Station, Port Authority and Times Square. You may also attend this class live online (virtual training) via Zoom. We will reach out with additional information, including the Zoom info and class files.
Give This Course as a Gift Card
- Thousands of classes
- No expiration
- Unique and memorable gifts for any occasion
- Personalized
- Explore a passion, gain a new skill, discover a new hobby, engage in a memorable experience
- Instant delivery
- Lock in a price with the Inflation Buster Gift Card Price Adjuster™
Book this Class as a Group Event
Booking this class for a group? Find great private group events
Or see all Excel Group Events
Explore group events and team building activities ranging from cooking, art, escape rooms, trivia, and more.
One last thing!
Add a name to your account.
What name do you want displayed with your post?
What name do you want displayed with your post?
-
Price Lock Guarantee
Secure your booking now and we'll match any price drop within 48 hours across all booking platforms, ensuring you never miss out on savings!
-
Earn 10% Reward Points
Maximize your savings with every purchase. Unlock rewards on every transaction, ensuring you get the most value out of your experience!
-
No Added Fees
Enjoy hassle-free transactions without worrying about additional charges. With us, what you see is what you pay - no surprises!
-
Curated Courses
Discover a curated selection of courses handpicked by experts in the field. Dive into quality content that suits your learning needs and interests!
Get it first. Sign up for up-to-the-minute offers, sales and news.
More in Microsoft Office
Made in NYC
© CourseHorse, Inc. 2024 Loading...