This is a MyXL9 podcast, episode number 10, special course announcement. It's like Friday night. Yeah, because you've done all the hard work. And now it's really time to just relax and enjoy it and hit that refresh button because it's all going to happen right then. If you're running, maybe stop and have a breather because you may fall over with what I'm about to tell you. Yeah, we're going to whoop it on you now.
We are going to whip it on you right now. Welcome to the My Excel Online Podcast, the need to know Excel insights, knowledge, and tips brought to you by the experts that know them best. Are you ready to explore your full potential and get better at Excel? It's time to stand out from the crowd with your host, John Mikaludis. G'day, guys, and welcome to the Microsoft Online Podcast with your host, John, Chief Inspirational Officer Mikaludis. In today's episode, we have a world expert in data cleansing and who I had the pleasure to interview in episode number seven. He is a Microsoft MVP, a co-host of Excel TV, and the leading author on the revised version of Guerrilla Data Analysis. I have brought him in today's episode to talk about his new online course, which is being co-instructed by yours truly.
Let's welcome from Portland, Oregon, Mr. Oz, Dr. Dirty Data. Hello, how are you, buddy? I'm wonderful. I'm feeling inspired by the Chief Inspirational Officer and I'm feeling nasty in a good kind of way. Not just dirty, but nasty. All right. You're Dr. Dirty Data, so you're there to clean up all the dirt in the data. And I'm the Chief Inspirational Officer because I want to inspire people and because I can choose whatever name I want because I have no boss. Oh, finally, I'm free. Free! I'm free from idiot bosses who give you stupid names.
Oh, man, I can be whatever I want. And I feel like being an inspirational officer because I think I inspire people with my blog posts, with my courses, with everything. And we're here to share the Excel message. And Oz, welcome again, buddy. Yeah, thanks, man. That's exciting, man. That should be inspiring for all types of people. Short, fat, skinny, bald, old, young, all of them. If they got data and it needs to be cleaned up, we are here to inspire and to let them know the way to get this stuff happening. There are plenty of ways. And one of them is Power Query. But we're going to talk about that later on. OK, because Power Query is the new Excel. When you think about Excel.
Before Power Query, you think about formulas, pivot tables, macros. After Power Query, all of that doesn't exist. Power Query is just, by itself, it elevates above Excel, above everything else. Man. That's like...
Excel is when you're 20 years old and you live in life and you live in a good life and you know some things. But then Power Query is when you hit 21 and everything is available to you. Everything. You don't have to cut corners and sneak and lie. No, you can live life free.
Oh, man. It is. It is. It gives you the license to kill. Yes. To kill dirty data. Ooh. Because they're mean. That's mean, isn't it? Dirty data. Crap data is everywhere. And we got to whoop this ass every chance we get because it creates misery. That's all crap data does is create misery. And so it goes beyond Excel.
It goes beyond being able to do a pivot table or to make a custom column in Power Query or write DAX formulas in Power Pivot. No, it goes beyond. It goes beyond. It's about eradicating misery. However you eradicate it, if you have to drag and drop stuff manually in Excel, you are still eradicating misery. That's the bottom line here. And there are shortcuts, aren't there? But yes, there's easier ways. Definitely there's easier ways. And Power Query does that. Power Query brings us some new powerful tools that address some common things that have to be done. And man, and being able to point things to a dedicated folder, to import things from a table, man, stuff that required VBA or some sophisticated stuff, man, no, no, no, no, no, no.
You got the power here, the fire, the power to be alive, the power to be alive, the power to help people, the power to end misery, the power to bring joy. Because you can go from paying people wrong to running out of stuff in your inventory to buying too much stuff and then have things go bad on you because your data is a mess. But when the data is right, not only does the misery go away, but you save money, you make money, you end. irritating phone calls with customers complaining you end people questioning whether you paid them right you end um whether somebody's inspection went right um where did the non-profits grant money go they can say where it went when they have their data straight and especially if they use power query oh I'm fired up, Oz. Yes. You've got to be fired up. Can the church say amen? Amen. Yes, that's right. You should bring out a course. Oh, man. You're already in the future. It's coming. Oh, it is. I can feel it. I can feel it. All right, guys. We are here to talk to you about our course, our super course about whipping dirty Dada's ass. Yes. And saving you hours each day.
saving you those miserable hours where you've got to stay back until 6.30, 7.30 to get a report done, you know, week after week, day after day sometimes. When the month end comes and you get a report, you're like, oh, you've got to stay back. And then when you go home late, there's lots of traffic, the food isn't there, the kids are sleeping. We want to alleviate that. We want to get rid of that. And there is a way. And it's not VBA macros and it's not a super formula.
It is Power Query plus some other tools which we're going to talk about within Excel that you can use. You can use to save time and automate stuff in your Excel and automate your workbook and reports. So next month when it comes in there, you just got to press a button. Literally got to press a button. If you have a mouse, that's what you're going to do. If you have a mouse, go buy a mouse because you won't be able to press a button. That is going to help you. So that's a prerequisite number one. Now, Oz and I have decided to bring you this because we were talking about.
and how we can help people. And Oz had the idea of writing a book about data cleansing. And I go to him, I go, man, books, what are you going to, who buys books? People buy books, but do they learn from it? Do they really learn from it? It's not a way to empower people and reach lots of people. Online courses are the way to do that. And they're massive, they're massive right now. And it's easy because it is accessible, they're cheaper, and everyone can access them. They can listen to them online, while they're offline, on the mobile phones, whatever you want. Now's the time. You know, I was thinking about, you know, because I've written a book.
And the stuff that I can show people in a video, I can get into it and give the warnings and give multiple examples. Whereas writing that stuff down and taking screenshots and stuff, man, that's painful. Now, I'm glad that I've written a book. I'm proud of the book. And I thank Bill Jelen for that opportunity. But I tell you, writing a book is painful. Making a video where I can show people.
show them, man, that's a powerful way to go. And I feel like once I'm going, you know, it's just keep moving forward. Yep. Yeah. Yeah. It is powerful. Videos are powerful. And it also shows your personality because you've got a massive personality and you can just talk and people resonate with you. And that's why you're good on video. And that's why I got you in this because if you weren't good, I wouldn't get you here. So why did this idea...
come to fruition, this data cleansing course. Why data cleansing not something else? Well, because I feel like this is the true, true power. being able to cleanse data because all the talk about big data and data visualization, all the fancy stuff, predictive analysis and whatnot, none of that can happen if the data is a mess. Nothing. I've seen businesses paralyzed because their data was a mess, not because they didn't have a good marketing plan or whatever. You know, in fact, they couldn't market because the data was a mess. And in a lot of instances, people aren't looking to build a dashboard to do visualization. That's a very specialized kind of conversation. But when you're trying to say,
Take 50 kids on a field trip and you're trying to manage their permission slips and their insurance and the venue and buses and stuff. That's not necessarily data visualization. That's something you can put in a spreadsheet and manage. But if it's a mess, if it's not organized right, you're going to have problems. You're back to misery. And I worked with a nonprofit a while ago, and they had gotten to a point to where they were so successful that they couldn't run on $20 donations here and there. They needed to apply for grants, but they couldn't get the data together to show their success. Data sprinkled all over different spreadsheets on different computers and trying to sweep them together and get
you know, things in the right columns, they couldn't do it. So they had to just keep on relying on $20, $50 donations out of somebody's pocket. So that's the kind of thing that I want to give the power to. And I hear things like, you know, that should be in a database. Well, my skill with Excel came because the stuff in the database was a mess. You know, databases are expensive to run and reports get outdated. And when it's not a priority of the person who needs to fix the report or who has the skill to fix the report.
What do you got? You got the raw ass data that you got to work with if you can work with it. And so that's why I want to give somebody the power to where they say, you know, I want to help this customer, but I've got this old ass report and IT can't fix it until next month. And the customer's going to have to wait. Hell no. Hell no. If you know how to work with raw data, you can help that customer. You can end that misery. That person should not live a second longer with misery than they have to.
And that's where my passion comes from for this is helping people and ending misery. And it starts if you can work with raw data and clean data. It is not that hard. People get the data. It comes in. They think, how do I do this? Like spend hours, maybe days to get help. Yeah. Because I don't know the tools to use.
Within Excel, the right tools to use, how to set up the data, because there are tools in there, hidden in there. But no one has taught these people because they're thrown in the deep end. They were promoted from marketing into sales. And all of a sudden, they're using Excel. And like, okay, let's do a course. And the course is not going to – general Excel course is not going to teach you about setting up your data right and analyzing it. No, it's not. And a lot of companies.
don't spend money on their employees it's just the way it is i don't know why because employees are number one without them companies will not run but it's politics whatever you want to call it you know you see the ceos flying on planes and going on business trips that cost 10 000 a trip they could spend that on on their employees that's why i don't work in companies because i don't believe in um in the corporate environment because i don't have the people yeah i talked with somebody um who does uh software development and she's got a her career is in it and she explained to me that I had a unique perspective, you know, being a freelancer, working with the business, working on their IT. And I think this is true of a lot of Excel users because we straddle that line. You know, the people who do SQL and databases, that's their career. They don't take phone calls from, you know, why is my paycheck late? Or, you know, why didn't my shipment not go out? Why don't you have my exam graded? They don't hear the frustration. We have to take the call and walk over there and say, what's going on? And they say, well, it's month end. I can't deal with that right now.
And then we have to go back to the phone and tell the customer, well, I'm working on it. The IT people, the database people, the CEOs, they're often so far removed from the front line that there isn't the urgency, you know, of having somebody on the phone who might be crying, who's calling you all kind of bad names because they're mad or a big account that's threatening, look, we're going to go to somebody else. No, we get to feel that urgency. Everyone hates dirty, unorganized, and messed up data. And it usually comes from the ERP system, which is the enterprise resource planning system. So it's an example like QuickBooks, Oracle, SAP. The data from the ERP that comes to Excel doesn't come into the right format. And to fix that, it'll cost a lot of money. If you go to Mr. QuickBooks or Oracle, it's going to cost you a lot of money. We're talking about hundreds of thousands of dollars to get that fixed up and coming to Excel right. And they can't get it. It's just the way it is.
So they rely on these Excel people or these analysts who some of them have Excel experience, others don't, to fix that data up. And there's about 95% that don't know how to fix that. And that's where these courses come in. That's where you come in and I come in to help with this. That's right. And eradicate the misery, eradicate the pain. And for me, it's saving hours a day or a week. If I can do that and you can go home earlier and with a smile on your face and have the purpose of achieving something and also learning Excel and learning the possibilities, then I've done my job and you've done your job as well. What other pain points do you have there? Can we talk about? Well, there's what you're saying about QuickBooks. I've dealt with several clients where you can't get a data dump out of it because that's what...
See, okay, so I walk in and somebody needs something around their data and they say, we got these reports. Okay. I look at the report and I say, the data is raw somewhere. Can you get me the data dump? And then we can do what we need to do. But if you have me start with a report, then I've got to do a lot more. And then a lot of times they can get the data dump. But then in QuickBooks case, I hear about, well, there is some third party app that you can get, but no QuickBooks won't export a data dump. So here we go with data cleansing and data shaping.
So a report for those people out there is something that comes in that has all the subtotals, all the grand totals already there, a lot of gaps in there. So like a profit and loss report. It's not meant for Excel. It's meant for people to look at. Exactly. That's what your report you want to get at the end. But there's a lot of data in that report that's available that we can use to do further analysis.
And you can't do that. You can't. Well, you can. It's going to take you a lot of time to mash it up and put it into a flat file, as we call it, or to a tabular format where you have a unique column with all the data at the bottom. For example, the months in a column, the years in the column, values, and you have employees in another column.
Having your data like that, you can do heaps of analysis. You can use paper tables to analyze that. If your data is not in that format, then you're going to struggle. But that's where we come in. We can use Power Query to clean all that report data and bring it into a flat file or into an Excel-friendly format, and you can do your analysis.
and automate that if this is something that has to be done weekly daily monthly whatever um you can use the queries in power query to do all the hard stuff once and then refresh when you get new data oh yes oh yeah that is the most the most powerful feature that if you can just get that reports into The way that you like it, using Power Query, it records all the steps. And as I said, the next month, all you got to do is get a new report for the next month, whatever it may be.
And then just press refresh and it brings it out. So no more struggling to do the same thing or putting macros in there. And then the macro gets, gets stuffed up and then someone else. No, no, no, no, no, no. No, when you, when you hit that, when you hit that refresh button, it's like Friday night. Yeah. Because you, you've done all the hard work and now it's really time to just relax and enjoy it and hit that refresh button because it's all going to happen right then. Oh yeah. Oh yeah. When you press that refresh button.
You've saved yourself that hour within a day with that day. So you can go home on that Friday early, go to the pub as I used to do when I was single on a Friday and enjoy drinks before you go home at six in the morning. That gives you the power to have that extra hour in the pub. And a lot of people value that. And not only is it about the saving of time, but it's the increased accuracy. You can trust once you've done that. You can have confidence. If you have confidence, you have power. That's what I say. That's right. And you can show that to your boss.
It's going to give you more opportunities, more projects, and you're just going to get elevated within that company in a heartbeat. If you know how to use Power Query and the other data analysis techniques, man, you're in there. Okay. Let's talk about this course, Oz. Okay. All right. All right. Let's go. Let's go. We've been working on this for the last few months and let's talk about this course. Okay. It'd be good if I had the course open. All right. Let me just open it up now.
All right. We have the course. It's broken up into several different areas. And the first area is formulas. And that's taught by yours truly, John, Chief Inspirational Officer Mikalutas.
And I talk about the different formulas that you can use to clean data, extract data, and manipulate data, I'll say that correctly, into the way that you want it because the data comes in with three or four parentheses or a lot of dashes, and you want to get rid of them. There are ways to do that, and I'll show you the different formulas. For example, the text, you have clean formula. You have the find, the left, right formula, mid, replace, substitute. You have the text formula. You have the trim.
Heaps there. There's heaps there. I show you about three, four examples of each. And it's just, I get amazed at what you can do with these formulas. You think, wow, man. And then like you can do whatever you really want. If you want to take that data and put something else in there, for example, the part number is missing in the middle of a serial number. Wow. You can get the part number and put it in there. And I'll show you how to do that.
And let me add that, you know, we've talked a lot about Power Query and the thrust of the course is about data cleansing. So we do show a lot of things that are in native Excel because sometimes you have to think about it. You know, is this something I'm going to do one time? And maybe you go ahead and just do it in native Excel. And it's helpful to know how to do it in native Excel. And then there are some things that you definitely want to do in Power Query. And especially if it's something repetitive, you want to do it in Power Query. But overall, we're talking data cleansing. Yeah. And there are many ways to skin this poor cat. The quick way, if you want to do it once.
You can use formulas or you can use find and replace. But if you're going to automate it, as I said, it's best to use Power Query. So there are different ways. And we'll show you the different ways and when to use it. I had a Russian professor who said there's more than one way to pluck a goose. And I'm going to tell you that goose is going to get plucked somehow. And Eden as well.
All right. Go ahead. I'm getting goosebumps thinking about this. Yeah. All right. So formulas, text formulas. Then I go on to the date and time formulas because we get data that's in messed up date and time formulas. I'll go through that and also look up formulas. You can't have a course without VLOOKUP or a match. So I'll use that and I'll show you how you can use that to clean data, bring data in, reshape data. There's some tips and also case studies in there with.
The match if formula offset. A lot of stuff there. We'll go on to different data techniques to clean data. And we're talking text to columns, duplicates, removing duplicates, paste special, formatting cells, conditional formatting. Find and replace. And putting those wild cards in there. Wild cards are great. Wild cards, man. No one knows that. But when someone showed me, I was like, this is a bonus round here. That's a great trick. Go to special. Go to special. There's so many features within that. Lots of there. Yeah. You can find blanks within your worksheet by putting in color. So all the blanks, color them up, and then you can use a filter to filter by color. So you're filtering the blanks, and you can go in there and fill in the data. There's all these things there. Row differences. Sort and filter.
custom filter to uncover misspellings. What is that? That's just, who would have thought of that? Oz did because he's just a master. So we have a lot of tips on that, a lot of videos on native data features within Excel. And we'll show you that. And then Oz goes and talks about Excel tables because Excel tables are the best thing since Excel was invented. And to analyze your data, you have to put into Excel tables. You have to. That's number one. Even if you're not going to use the data, just put into...
Excel table by pressing control T or insert table just to make it look pretty. There are so many advantages. But when you're using Power Query, your data has to be in an Excel table. It needs to because I have seen as a glue or hinges, something that allows your spreadsheet to flex and stay together. Because when you have that table nomenclature, when you have a sum that's looking at a table and a specific column in a table, now it's looking at that column in that table as opposed to a range that might change.
You might drag the formula only partly way down and then you get something crazy. And then what? You're inflicting misery on the person who has to deal with the consequences. So put things in a table. I love Excel tables. Wow. All right. Then we go on to Power Query and Oz. Take it away. What are you going to show us in this course? I show a lot of converting things to flat files where you get reports that have the totals in them and headers that are off to the side by themselves. Things that.
look great for a human eye, but Excel can't use it. So I show things like unpivot. Unpivot is where you have things already summarized, say going by the column, but that can't help you. You need it going, you know, vertical instead of horizontal. So it's also called unwinding data, but the bottom line, and we do have a video on it is unpivot. Man, that is a powerful thing. The first time I saw that it saved me about 45 minutes of work. Fill down, fill up. Meaning when you have holes in your data.
Say you have on row one, there is the month of May and then you get down to row 80. Then there is June and then row 87. Then July starts. But if you start to move that data around, it's not going to stay with the months. So you need May to fill in the gap all the way until it changes to June. And then June, fill in all the way until it changes to July. So easy using fill down in that example. I show how to do an if statement inside of Power Query. It's a bit different from using an if statement inside of a native Excel. And it's a very powerful thing to do.
There are duplicate finders. There's a feature in Power Query called keep duplicates. Sometimes you want to do that and get rid of the things that aren't duplicates. Great thing to be able to have available to you. So those are some of the things that I show. Pointing Power Query to a dedicated folder. And this is exciting. This is where, say, you do get new data, say, every month.
You can just drop new data into that folder. Don't even have to open the Excel file. Just drop it into that folder. Go back to your main spreadsheet and hit refresh and it integrates any new data and any updated data. So if you do have to say your main data is already in there and you find out something was wrong, go to the main data in that file, in that folder.
update it, save it, go back to the main worksheet and then just refresh. So easy. Oh yeah. Oh yeah. And how about consolidating multiple sheets, which before you're going to do via Vlookups or a lot of copies, copying and pasting. And I get, I get that a lot from people. I go, how I've got all my months in, in one workbook within the sheets, January, March, and I want to consolidate it or append it into one sheet.
a show how to append and then how to merge. Appending is when you just stack things on top of each other. But then when you do a merge, that's where Power Query, you know, if it finds John in three sheets, it will put John all together on one row. John's, you know, so if you have John and his birthday on one sheet and John and his phone number on another and John and what kind of car he drives is on another one. it will match those up on one row. Whereas an append, just stacks of things on top of each other. And, you know, and I show when you want to do each one. So much easier in Power Query. So much easier. Well, that's power there. That's power there for you. All right. There's some great stuff there, Oz. Mind-blowing stuff. And when I first used Power Query, I saw this query editor pop up and I was like, oh, what's this? Confusing. And it does take a bit of getting used to.
But, you know, that's where we came in and we learned everything so we can teach you how to use it in the most comfortable way. And sometimes you have to get out of your comfort zone and learn something new because when you get out of your comfort zone, that's when the magic happens. That's when real magic happens and it opens many doors and you just go into another world where you're like, the possibilities are endless. So make that jump, that leap of faith as people say, get in there, get in there, get in there. And, you know, we're there to help you, we're there to show you, to guide you. That's why we're here. Also, go on, Oz.
Yeah, I was going to say that one thing that I enjoyed about developing the course and some good feedback that we've gotten has been, you know, like a lot of my contribution to the course has been more complex, real world stuff. You know, we don't stress standalone tips and tricks because, you know, that's like showing you how to screw in a screw with a screwdriver, but then you still can't build anything. You know, so we want to ensure that you can build something when you're done. And so I've looked at some things, you know, from. what people have shown me, what I've seen with clients, what I've dealt with, you know, when I worked in a corporation, what were some things that happened? It never was. It's just put in a pivot table. No.
I had to do some data parsing and fix some dates and then some stuff that was bolded, needed to be unbolded, you know, before I could put the stuff in a pivot table. So we want to show you that so that you are truly empowered. And I liked doing that. So some of the examples are kind of complex and it's that way on a purpose. Ours is great. It's showing all that and how it all ties in. All these different concepts tie in to one problem and you can use different ways to.
to get to a solution. And Oz is great at that. His videos are awesome. And he's quite funny as well. So you can watch a couple of his videos. All right. Now we have some bonus videos as well in there. And also some cool videos that Oz has produced on his YouTube channel. So you have that available to download as well. All right. There's plenty of stuff there. Now let's go on to the benefits, the benefits of the course or what you get in this course when you purchase a course. Let me tell you, if you're running, maybe stop and have a breather because you may fall over with what I'm about to tell you. Yeah, we've got whooping on you now.
We are going to whip it on you right now. Let me have a sip of water just to calm myself down because – One second. All right. First of all, what you get, apart from all that, which is over 100 tutorials, and we're going to keep on adding new stuff as we go. Yes.
You get this cutting edge and easy to navigate learning management system, which you can access anytime. So the first thing you get in this course is lifetime access. Okay. Maybe it's 12 months access or six months access or two years. Lifetime access. As long as you're alive, you will have access to this course.
Or as long as you're interested in learning data cleansing for as many years as that may be, you have access to this. And you also get this learning management system, which is a platform. It's easy to use. You can put in there your discussions, your questions if you ever have any issues and we're there to support you. You can download videos from there. There's resources, there's quizzes, there's attachments. You can change the speed of the video. And if you think we're going too slow, you can speed it up, which is a great way to learn quickly. It's like speed reading and speed learning. So that learning management system, you can access it on your phone, on your laptop.
PC, tablet, and whatever new things bring out soon. So that's one thing. You get all the workbooks that we show you in start and finish form, downloadable to keep forever on your desktop or wherever you want to keep it. So you get that so you can follow along and practice what we show you. You have the start and the finish. So if you don't know how we got there, you got the finish model. You can work yourself backwards if you like. So you get all the downloadable workbooks. You get the videos as well. So every video you get to download and keep forever offline. So you don't need to be connected online. You can keep it offline and work whilst you're...
on an airplane, even though they've got Wi-Fi now, but some of them don't, you know? So you're traveling through a tunnel for 30 minutes. You can just view the downloadable video and it's great to keep the videos there. You also get lifetime access, as I said before. So what that means is, is that whenever we come up with new videos, they're going to get added on there. So you're not just going to get over a hundred videos. Who knows? In a year or two time, it might be 200 videos. So we're constantly, every quarter, we're going to be updating with new videos. And I think it's important to say that
When people join the course, it becomes our course and the students will help guide what those new... what the new content is going to be. Yeah, because we know so much, but then you guys have different problems with different ERP systems. And what we're going to have is a special VIP bonus, which is when you sign up, we're going to have quarterly live calls with you to solve your problem. So a week before or a month before, you can send in to us your data that you don't know how to fix. And we're going to show you during that live call of how to get to a solution.
is going to become a video. So whichever, every solution that we come up with, that's going to be on that video. So every quarter there'll be new videos added based on your needs. And that's just, for me, that's just free support, isn't it? Yeah. It pays for the course itself. It pays for the course. Just that VIP bonus there. Yeah. And I look forward to that. It's going to be great. It's going to be great. You may have an issue and someone may have a similar issue, but you know, they may be scared to ask, but if we can show the people that, okay.
You have that problem and we show a solution. And I'm sure there'll be plenty of other people that say, hey, I have that as well. I can use that now. So those quarterly calls are going to be just amazing and incredible resource there. Okay. What else do we have in there, Oz? What else do we have? You get email support. So if you have an issue, send us an email and we get back to you to come to the solution. So you have us to help you and hold your hand whenever you need it. Okay. You also get lifetime.
Discount 25% off on future Microsoft Online courses that come out. And there'll be plenty of courses because I'm working this year and next year to bring out courses. That's what I'm doing, just bringing out courses. And apart from that, you get a certificate of course completion. You get a certificate sent out automatically. And that's great to have on your resume and on your arsenal. And if you want to go for a promotion, you can use that. Say, hey, I've taken this course. These are my skills up to date. And you also get a 30-day risk-free money-back guarantee.
So you can go in this course, you can take it for the full 30 days, study and apply it to see if it works for you. And if you're not 100% satisfied, then, you know, we're more than happy to refund the full purchase amount, even if it's, you know, on the 30th day. So give the course good, go watch all the videos, download the workbooks and ask us any questions during 30 days. And if you're not going to become an Excel master and you don't think that this course, you know, accomplishes your objectives and contact us and we'll give you a refund. So, you know, there's no risk here. Another thing is how can people get access to this course? Now, this course is by invitation only and it's only open.
a few times a year. And it's only open for four days per year during those blocks. Okay. Now I've set up a link and I'll give it to you now. MyExcelOnline.com backslash data cleansing. Type that in and that will take you into some free training. So you get free training about Power Query, about formulas, about data tools within Excel.
And there's three videos there. It's free training and we'll show you the possibilities. At the end of that training, we're going to open the course. So today is the 17th of June, 2016. You may be listening in the future, but today is our launch. It's 17th of June. The course goes live on Monday, the 27th of June, 2016. And it's going to be open for four days only up until the 30th of June. So during those four days, you can buy the course and then we're going to close it. We're going to close it because we want to take care of the students and focus on their needs and create more videos based on their needs as well. So do those quarterly calls.
Now, next time we're going to have that course up and running, just use the same link, mikesonline.com slash data cleansing. If you go to the link in the future and the training's not there, there'll be a place to fill in your details, your name and email. And that means you can register for the course. So whenever it's open, we're going to send you an email and say, hey. Our course is open. Go through our training series and you have X amount of days during these days to purchase the course. So that is the way to do it. And man, I'm excited and I'm proud. I'm proud to have created this with yours. I've learned a lot in the process. And yeah, you guys are just going to learn so much. You're going to learn so much. Open your eyes and I'm proud of it.
And I've enjoyed working with you and I've enjoyed, you know, coming up with examples that can help people. And I know, you know, I like to have fun and I can be loud and everything. But, you know, seriously, this means a lot to me because, you know, really, I have seen the results of when people's data is a mess, you know, and a nonprofit that wants to do a kids after school program. That's important. But if they can't get their data together to get the money to get the grants. Well, what happens to the after school program?
You know, and the person whose career is in jeopardy because of some data goof. You know, that's the stuff that I really want to help people, you know, be the hero for those people. You know, unchain yourself from having to rely on IT or a database admin to do something for you. And I saw this when, you know, I was working at a company and I had a director. He got tired of having to wait for stuff.
You know, and then he had somebody look, can you give us enough training to where he can do something and I don't have to wait for this guy for two weeks. And it was about, you know, running the department and having the data so we could run the department. So, yes, so this is beyond showing you how to make a custom column and power query. This is about the after school program and paying people and careers and embarrassment. You know, this is about being a hero that ends all that.
I'm not going to add anything more because you've just summed it up there. It's been a pleasure creating this course. And for you listeners out there, if you have any comments, just go on to MicrosoftOnline.com backslash podcast, and you can leave a comment on this episode, which is going to be episode number 10. All right, Oz, mate, I appreciate it. And thank you very much once again. You're an expert. It's been great. And to all you guys out there, we're going to see you inside the course. That's right. And you're going to get the fire. Yeah, you're going to get the power. Man, it's going to be good. All right, guys. I love you all. Speak soon.
We hope you enjoyed this episode of the My Excel Online podcast. Be sure to subscribe and share this with your colleagues so they can reach their full Excel potential. You can also visit MyExcelOnline.com slash podcast for show notes as well as John's online Excel courses and free tutorials to help you stand out from the crowd. Until next time, keep excelling.