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.
-
Step-By-Step Training
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.
All Upcoming Dates
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.
Prerequisites
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).
Experienced Instructors
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.
Cancellation Policy
- Cancellations made up to 3 weeks before the event receive a full refund.
- Cancellations up to 1 week before the event incur a 20% cancellation fee.
- No refunds are given for cancellations within 1 week of the event.
- Wall Street Prep reserves the right to cancel seminars due to low enrollment, with full refunds issued to participants in such cases.
Transfer Policy
Participants wishing to change their enrollment date or switch bootcamps must adhere to the following criteria:
- Requests must be submitted at least 1 week before the original seminar start date.
- Only one transfer is allowed per registration, to be used within one year of the initial registration.
- Transfers are final and non-refundable.
- The new bootcamp must be of equal or lesser cost; otherwise, participants will be charged the difference.
- Participants who do not attend their original bootcamp without prior notice are ineligible for transfer.
Trainee Reviews
— Avijit A.
— Nicholas P.
— Rory B.
— Deborah S.
— Simae N.
— Cristina P.
Why Attend a Boot Camp?
Comprehensive Training
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.
Networking Opportunity
Boot camps provide an opportunity to network with MBAs and professionals from industries including investment banking, corp dev and FP&A.
Experienced Instructors
Our instructor-practitioners are experienced bankers who give real-world context by connecting training to their own experience on the desk.
Excel Mastery
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