Become an Excel Power User in 4 Hours
Up your Excel Speed and Efficiency
For finance professionals, proficiency in Excel is a fundamental part of the job. This virtual session will teach you how to navigate through worksheets, build formulas and dramatically increase your speed with powerful keyboard shortcuts.
We start with the basics before we quickly introduce lesser known time-saving keyboard shortcuts and powerful Excel functions and features.
Taught by Finance Professionals
Led by finance professionals who understand how Excel is used on the job.
Includes 2 FREE Excel Online Courses
Enrollment in this seminar includes access to 2 online Excel courses (one for Windows and one for Mac) that will let you dive deeper into Excel with more functions, more shortcuts and popular features like Pivot Tables.
What You'll Learn
- Go from beginner to advanced Excel “Power User.” (For Windows versions of Excel. See here for Mac compatibility.)
- Understand the Excel environment, including ideal settings and ribbon navigation.
- Learn the keyboard shortcuts you can’t live without.
- Learn core Excel functions you’ll use again and again to solve the most-encountered Excel tasks.
- Learn how to THINK in Excel and use the program as an incredible problem-solving tool.
- Work with large data sets with tools like sorting, filtering, data validations.
- Unlock the power of Excel’s most popular lookup functions such as IF, VLOOKUP, INDEX, MATCH and more.
- Improve Excel presentation with dynamic headers, custom formatting and conditional formatting.
Wall Street Prep training is used at ...
Boot Camp Details
Revisit what you learn
This virtual seminar will be recorded and available for you to review any time from your Wall Street Prep learning dashboard.
Targeted for Windows Versions of Excel
Please note, this virtual “Power Session” is targeted for Excel for Windows users. Mac users are welcome but there will be some shortcuts we cover that do not work on a Mac.
This power session is taught at the Beginner level. Attendees must have Excel installed on their machines and have a basic familiarity with Excel navigation (i.e. copy/paste) and how to use a function (IF statements and SUM).
Our instructors are all practitioners with years of directly relevant real- world experience and have a passion for teaching. They understand the importance of teaching in a way that empowers students to apply the lessons from the classroom directly on the job.
Participants may cancel up to 3 weeks prior to the event for a full refund. A 20% cancellation fee will apply up to 1 week prior to the event. No refunds will be granted for cancellations made within 1 week of the event. Wall Street Prep reserves the right to cancel the seminar if enrollment is insufficient. Trainees will be refunded in full in the event of a cancellation.
— Avijit A.
— Nicholas P.
— Rory B.
— Deborah S.
— Simae N.
— Cristina P.
Why Attend a Boot Camp?
Our live courses pulls no punches. Each boot camp is the same intensive training used to prepare incoming analysts at top financial institutions.
Learn by Doing
Attendees “learn by doing” by working through practical exercises and building financial models from scratch using real case studies.
Boot camps provide an opportunity to network with MBAs and professionals from industries including investment banking, corp dev and FP&A.
Our instructor-practitioners are experienced bankers who give real-world context by connecting training to their own experience on the desk.
Our training reinforces speed, efficiency and consistency in Excel that investment banking analysts are expected to have on Day 1.
Continuing Ed & Webinars
Enrollment to most boot camps includes access to our continuing education online training platform and webinar series.
Can't Attend? Learn Excel Online Now
Earn 4.5 CPE Credits with WSP Online Courses
Questions? We're Standing By.
To learn more about this boot camp, fill out the form below or call us at: 617-314-7685
The Wall Street Prep Quicklesson Series
7 Free Financial Modeling Lessons
Get instant access to video lessons taught by experienced investment bankers. Learn financial statement modeling, DCF, M&A, LBO, Comps and Excel shortcuts.