Thursday, July 7, 2022

Excel fundamentals boot camp

July 7, 2022

I like to learn how to provide training courses in the future as well. I have spent hundreds of hours to work on Excel, and I also spent time to get familiar with VBA programming. 

 

Hello jianmin,


Registration is now open for the next semester of my Excel Fundamentals Boot Camp, which begins on August 19, 2022. This course will teach you all the core skills of an Excel Analyst!

What is the course about?
The Excel Fundamentals Boot Camp is developed and delivered by me, Ken Puls, and will ensure that your Excel skills advance to an intermediate level. Our goal is to fill any knowledge gaps you may have.

This course will make you more efficient and build the core level of skills required to move onto advanced Excel analytics in the future (should you choose to do so). You’ll learn all the fundamental skills for the Excel analyst, including:
  • A refresher on Excel formulas, as well as absolute and relative referencing
  • A review of Math, Logic, Text, and Date functions
  • A deep dive into the powerful, but often feared, VLOOKUP (yes, there are better alternative functions today, but trust us, if you can master this function you can master any Excel function!)
  • An overview of how to create PivotTables, and how to summarize data sets of all sizes
  • An introduction to Power Query for gathering, cleaning, and transforming your data with ease (seriously, it will change your life!)

The training consists of:
  • Viewing the online videos (recorded by Ken Puls).
  • Working through the downloadable practice exercises.
  • Attending weekly live online Q&A calls with me for help with questions about that week's lessons.
  • Attending the monthly live online Ask Me Anything sessions with me for on-going support as you apply your skills to your own work and run into real world problems.
  • A copy of our handy Power Query Recipes collection to refer back to. (This includes all new and updated cards for as long as you are subscribed to the course.)

Although the the new semester officially kicks off on August 19, you’ll get immediate access to the all of the video content so you can dive in as soon as you're ready. Students are able to continue to join the live AMA sessions for as long as they are subscribed, even after their initial semester is finished.

Early Bird Discount
The regular price of this course is $695 USD for a full year of access (and then $169 USD/year after that if you choose to continue your subscription). However, you automatically save $100 if you register before July 17, 2022!

No comments:

Post a Comment