Course Structure
This course is a hybrid format of pre-recorded video training interspersed with live online Q&A and coaching with Ken Puls, for direct help with your questions. The Boot Camp is broken down into two main sections:
Section 1: Course Curriculum
The main course curriculum includes 31 hours of training. The materials are delivered in a mixture of pre-recorded video training and hands-on practice over an 8-week semester with a weekly time commitment of approximately 2.5 hours per week. (Schedule included below.) In addition, attendees will also have access to live 30-minute weekly Q&A sessions to ask questions related to the course material, for a total time estimate of 3 hours per semester.
We understand that sometimes work can get in the way of the ability to attend live sessions. For this reason, questions for the Q&A sessions may be submitted in advance, and all of the live Q&A sessions will be recorded and shared with participants. Thus, you will still be able to learn from the discussions even if you are not able to join Ken live (due to time zone conflicts, other commitments, etc.) or get called away for part of the session. This also allows you to watch the recordings on your own schedule, and to pause, rewind, and practice more with example files.
In addition, since your purchase (or renewal) provides access to the course for an entire year (from the start date of your initial semester), you are able to join any later semester as long as your subscription is active! That’s right – in the case that life knocks you offline, the next semester is open for you to either restart or pick up where you left off.
Section 2: Long Term Support
In addition to the main course curriculum, this course also includes access to monthly “Ask Ken Anything” (AMA) sessions. Each of these optional sessions is up to 2 hours in length, conducted live, and recorded for later viewing. This is a great way to receive continued coaching on a longer-term basis, as you apply your skills in the real world and run into real world problems.
As with all of our training courses, we also provide access to our curated Skillwave Support Forum as well, allowing you to get answers on a quicker basis should you need more immediate help.
If you are not able to join us live for the Q&A or AMA’s (please see below for schedules), you can still submit your questions to Ken beforehand and he will answer them in the session. You will then be able to watch the answer later on in the session recording.
Total Training Hours
The core of this course contains 31 hours of training, based on:
- 13h video
- approximately 5h of practice time with the example files
- 3h of Q&A sessions
- approximately 10h of AMA sessions (based on attending/watching half of the AMA’s)
If registrants attend (or watch the recordings of) all 24 hours of the optional AMA sessions, this course includes up to 45 hours of training in total.
Arhamul Amin (verified owner) –
I liked learning about Power Query and VLOOKUPs. I also I loved the fact that we get to meet every now and then to ask questions not just related to the program but struggles with our own work as well.
Shannon (verified owner) –
I liked having the ability to listen to the lesson and then apply newly learned skills to practice spreadsheets provided. I also liked that I was allowed 1 year to complete the course. Ken Puls is a great instructor and incorporates humor to keep you engaged. The last Excel course I took was in the 90’s so I was shocked as to how much of Excel I had been under using. Thank you for opening my eyes to new possibilities and ways to improve data management and productivity.
Sylvia L. (verified owner) –
I liked the flexibility of watching the videos on my own time. Content was in easily digestible modules. I truly found this course life changing. I wish I had taken it sooner. The hours I have spent manually transforming data soon will be all gone. I have already started to use it before I even finished the course.
Jeff Becker (verified owner) –
I loved learning the capabilities of Excel. I had no idea you could do so much. I’m glad I had an opportunity to participate in the course.