Wall Street Prep
Thu Nov 12, 1-5p (ET)

Become an Excel Power User: Beginner Level (PCs Only) 4-Hour Virtual Power Session

Format: Live Virtual
Date: Nov 12
Time: 1-5p (ET)
CPE Credits: 4.5
Date doesn't work? Start Learning Now Online

Become an Excel Power User in 4 Hours

  • Up your Excel Speed and EfficiencyFor 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 TrainingWe start with the basics before we quickly introduce lesser known time-saving keyboard shortcuts and powerful Excel functions and features.
  • Taught by Finance ProfessionalsLed by finance professionals who understand how Excel is used on the job.
Includes 2 FREE Excel Online CoursesEnrollment 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.
Show More Show Less

Wall Street Prep training is used at ...

clients clients

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

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.

Show More Show Less

Trainee Reviews

"The training covers all the important aspects of an Excel in a very detailed way-and there is something new to learn for a beginner as well as an expert."
Avijit A.
"I think this was better than my classes that I took via zoom because we worked through the same Excel sheets together. This gave me an opportunity to test my skills as opposed to many of my classes which involved me watching my professors go through their different slide decks."
Nicholas P.
"It's incredibly useful and it's taught by someone who knows what he is doing and can answer experiences both from a technical point of view and a personal/experiential POV."
Rory B.
"The interactive and hands-on spreadsheet is great to be able to take away formulas and student's work product for the day."
Deborah S.
"Very informative and useful. I will use some of the tools I just learned."
Simae N.
"I think it gives you basic understanding of key functionality. Also, good handouts, good examples in class, and site you can reference outside of class."
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

  • Whether you describe yourself as a beginner or proficient in Excel, this course will take you to the next level and turn you into an advanced "power" user.
  • time-saving keyboard shortcuts and powerful Excel functions and features that you can immediately put to use.
  • Wall Street Prep's Excel Crash Course is used at top financial institutions and business schools.
Learn More
CPE logo

Earn 4.5 CPE Credits for this Seminar

CPE logo Wall Street Prep is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org.

Questions? We're standing by.

To learn more about this boot camp, fill out the form below or call us at: 617-314-7685









X

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.