The FP&A Guy

View Original

Episode 57:How to improve your Excel skills

See this content in the original post

Show Notes

In this special FP&A Today episode, Paul is joined by three Excel experts whom Microsoft has recognized as Most Valuable Professionals (MVPs). Learn why it is important to up your Excel game and how you can do it. Below check out offers (saving $$$) from our MVPs exclusively for listeners of FP&A Today.

Get all your questions about Excel answered by the expert panel:

In this special episode:

  • Our MVPs on when Excel first emerged as a difference-maker in their lives

  • George Mount on the failure of finance to adapt to technology

  • The challenge of finance teams descending to the lowest common Excel skill set

  • The untapped power of PowerQuery and where to start

  • The power of prepping your data properly

  • Python vs Excel

  • Automating Excel reports using Python

  • How to deal with tricky Excel issues

  • Will Excel go extinct with the rise of AI

  • The thing that you absolutely could not live without in Excel

Read the Full Transcript and Blog

Special Offers Exclusively for FP&A Today listeners

1) George Mount

Subscribe to George’s newsletter to get access to his data analytics resource library and many other goodies https://stringfestanalytics.com/subscribe/

2) Mark Proctor

https://exceloffthegrid.com/fpa is an exclusive offer for our training academy to the listeners of FP&A Today - 30-day full access trial for $1, followed by a $100 annual discount. This is valid until 31 May.

Excel Off the Grid YouTube

3) Celia Alves

Celia offers an online course about automation of Excel Reporting procedures. Check out the special FP&A Today discount here https://snapreportschamp.com/course

DISCOUNT CODE for 20% OFF: FPA20

(valid up to June 4, 2023).

She also offers live corporate training about Power Query: 

https://solveandexcel.ca/corporatetraining/

Subscribe to Celia’s newsletter https://snapreportschamp.com/subscribenewsletter

Celia Alves - Solve & Excel - on YouTube https://www.youtube.com/CeliaAlvesSolveExcel

The #1 FP&A Community (Slack) Join here - A global community and resource hub for modern FP&A leaders like you.

FP&A Today is brought to you by Datarails.

Earn CPE credit through Earmark for listening to this episode.

For AFP FP&A Continuing Education credit, please complete the course via the Earmark Ap, must pass the quiz with 80% accuracy, and send the completed certificate to pbarnhust@thefpandaguy.com for issuance of 1 hour of credit toward your AFP FP&A Certification.

Datarails is the financial planning and analysis platform that automates data consolidation, reporting and planning, while enabling finance teams to continue using their own Excel spreadsheets and financial models.

Get in touch at www.datarails.com

See this content in the original post