Events Calendar

Export Event

Title

CFA Society Los Angeles:  Mastering the Interview: Microsoft Excel

Location

 

Start Time

6/2/2022 3:00 PM

End Time

6/2/2022 4:30 PM

Event Description

A Career Development Advisory Council Sponsored Event

For many positions in finance, Excel is considered an essential tool used to efficiently analyze and manipulate data and to create compelling financial analysis. There are many different functions or tools in Excel that can be used but the best approach focuses on speed, accuracy and transparency so the analysis can easily be communicated to your boss and / or client. As such, employers are increasingly quizzing applicants during the interview process through a combination of verbal questions, take-home and in-person exams. This workshop will introduce common topics candidates are expected to know, practical approaches to solving a variety of problems in a limited period of time, and a few “gotchas” recruiters might employ to ensure candidates know their stuff.

Learning Topics Include:
  • Learn to use keyboard shortcuts
  • Use Excel’s filters in conjunction with specific arithmetic functions to summarize large volumes of data
  • Learn to use and automate some of Excel’s more advanced lookup functions including VLOOKUP, OFFSET, and INDEX
  • Become proficient with Pivot Tables, one of the most powerful tools in Excel, to quickly analyze large quantities of data
  • Discuss how Excel questions could be incorporated within an interview
Cost:
Nonmember: $20
Members: Free

To register for this program, click here.

Event Type

Society

Education Topic

 

City

Zoom

State/Province

 

Event Country

 

Event Region

Americas

Location Info

 

Speaker

 

CE Credits

 

SER Credit

N/A

Currency

N/A

Member Price

contact [email protected] for code

Non-Member Price

$20

Candidate Price

$20

Registration

 

Recurrence

 

All Day Event

 

Attachments

Content Type: MyCFA Calendar
Created at 4/8/2022 2:05 PM by [email protected]
Last modified at 4/8/2022 2:05 PM by [email protected]