Self-Paced Courses
Members, please login to access content.
If you are not a member, click the Register Now button to join.
This AFP Mini-Course has been approved for 0.6 CTP & FPAC recertification credits. Once you have watched all the videos in the course you will see a link below to complete the quiz. In order to claim the credit for recertification you will need to pass the quiz.
Kevin is an expert facilitator specializing in streamlining processes. He has an extensive history of delivering spot-on analytical training solutions for both small, private firms and multi-billion-dollar corporations.
Currently in his PhD candidacy for Education in Instructional Design, Kevin has a passion for transferring key skill sets and knowledge to his clients.
Also holding an MBA in Finance & a Chemical Engineering degree, he understands the nuances of both worlds.
Having more than 30 years of experience within the financial arena, Kevin creates training sessions that are uniquely designed for his niche clients. His latest customized courses are
* Advanced Financial Modeling
* Economics for Capital Budgets
* Refinery Economics
* Power BI & Python Boot Camps
All courses envelop his clients’ operational intricacies and place them into easy to understand lessons with repeatable processes. Kevin provides a perfect mixture of technical knowledge, practical experience, and fun classroom interaction to further reinforce solid take-aways and memorable application upon class completion.
Sneak Peek
- Autofilling
- Days of Week
- Months of Year
- Number Sequence
- Text & Numbers Together
- Flash Filling
- Paste Special
- Copy Formatting to another cell
- Divide or Multiply all numbers by a unique value
- Values
- Rand() to create quick dummy data
- Pick Lists
- From Database
- Remove Duplicates
- Create Picklist
- AverageIf() & Countif()
- Conditional Formatting
- Using colors to create a heat map
- Working with Dates
- Break off month, day, year from number sequence
- Splice dates together