So if you watched my video, but need help when you’re implementing the techniques into your work, I will help. Also, I include fairly comprehensive workbooks and notes so people can refer and don’t have to watch the video again. With every video, there is an Excel workbook. Mynda: I try not to repeat myself too much. Rick: Within each video, are there a certain amount of comments that link to other videos or workbooks in the structure of each module? At the MVP summit, I announced I could market some of other MVP’s topics to my program, such as VBA which I am not going to cover myself. I’m trying to be flexible in how I build it. It evolves over the course of creating it. I never started by saying it’s going to be a three hour class with 20 videos.
Microsoft excel training 2015 how to#
Then, I added analyzing the data or how to get the data for your charts. I teach a broad skill set to apply to different data scenarios. And then I added interacting elements. Mynda: I had a list of things I wanted to cover. How do you figure your overall course structure? Do you have a target of how many videos are within a subject topic? You mentioned keeping videos to five minutes which is a tactical design principle. Rick: Let’s talk about design principles. The only difference with the video is that you are actually demonstrating it as well. It’s like a blog post where you come up with your topic, decide what level of knowledge you’re going to assume people have, and you start writing. I determine what I want to teach and, sometimes, I have to take a step back and build to that point. Decide on a starting point, such as showing how to manage data in a pivot table. Mynda: It’s like standing up in front of a class and teaching a topic.
What steps would you recommend an interested audience member take to get started? You’ve created something that has a shelf life that goes further than the initial creation. Rick: We have had a lot of experts with a wealth of knowledge present on Excel TV, but not a lot of them have turned that knowledge into something they can monetize. How To Get Started In Developing Training With blogging and stretching my knowledge and getting all kinds of questions, I now know what advanced is – such as Macros and VBA’s and complex nested formulas! You help them understand what level they are. I related it back to my job and what I thought were good Excel skills, which I have learned were intermediate skills. I started with my syllabus and listed what beginners should know as a minimum and then the next level. Can you talk about how you categorize certain topics into those levels? Jordan: You have different levels of courses from beginner to advanced levels. Categorizing Topics Into Beginner & Advanced Levels Think of the things you have trouble with in a particular topic and break it down to how you understand it to teach it to others. Aim for five minutes (if the topic can be covered) so you don’t lose people. I found if I wrote a script or an outline to follow, I was less nervous. I started by writing blog posts, building an audience, finding my Excel voice, and my technique or approach to sharing what I know. Data reporting was part of my real job and passion so dashboard was, naturally, a great topic as it bands so many different parts of Excel to what a regular job requires. We started with Excel but we also have outsourced courses for Word and Outlook.
Video courses are the best fit for those types of workers who cannot leave the office to attend a class. Mynda: I started because I wanted to teach people with small businesses about the programs they have at their fingertips. Can we talk about your catalog of training courses and how you created it? Rick: After the Microsoft Excel MVP Summit, Jordan relayed that there was a lot of conversation about training programs.
Microsoft excel training 2015 tv#
Microsoft Excel Video Course Diva and Excel MVP Mynda Treacy, who runs the successful online Excel Training program (at ) with topics ranging from Excel Dashboard to Microsoft Word and Outlook courses, joins Excel TV host Rick Grantham and cohosts Excel Author Szilvia Juhasz and Microsoft Excel MVP Jordan Goldmeier to discuss Excel training programs.
0 kommentar(er)
