When

Thursday, November 12, 2020 from 1:00 PM to 5:00 PM EST
Add to Calendar 

Where

This is an online event. 
 

 
 

Contact

Jennifer Montenaro 
CFA Society of Columbus 
614-678-0356 
montenaj@yahoo.com 
 

CFA Society of Columbus WSP Become an Excel Power User: Beginner Level (PCs Only) 

CFA Columbus is excited to be partnering with Wall Street Preo to offer our members access to thier bootcamps and power session course at a discount!

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 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.