Betway Sportsbook. Whether it's a parlay after a long day or a straight bet before bed, you've got more ways to play. Get way more with Betway. Must be 19+. Ontario only. Please play responsibly. Concerned about your gambling? Visit ConnectsOntario.ca.
This is the MyExcel Online Podcast, episode number 16. When someone tries PowerPivot out and starts seeing what it can do for them in their business, it's like they're the first person to discover fire. And this person's like, oh, didn't you see that? Like, wow, like the world just changed. Welcome to the MyExcel 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 Mikoludis.
Hey guys, and welcome to the Microsoft Online Podcast with your host, John McElutis. In today's episode, we have an Excel MVP who is an expert in PowerPivot, one of the founding engineers behind PowerPivot during his 14-year career at Microsoft. He is one of the foremost authorities on self-service, business intelligence, and next-generation spreadsheet technology. He left Microsoft in 2010 to start his consulting and analytics company called PowerPivotPro.com, where he blogs and teaches about the empowering nature of PowerPivot and Power BI. He is the author of two books, including the world's number one selling Power BI book called PowerPivot and Power BI, the Excel User's Guide.
and has penned over 600 articles and white papers. Let's welcome from Indianapolis, USA, Mr. Rob Colley. Rob, how are you, buddy? Welcome to the show. Oh, thank you very much. That's probably the best intro I've ever had. In terms of word count alone, that's a heck of an intro. Much appreciated. Well, I had to cut it down from 2,000 words to about 200, so yeah, I'm good at copywriting. Did you use a word count formula in Excel for that, or did you just cheat and use Word?
I cheated and used Word. There you go. I didn't know there's a word count formula in Excel. Well, I figured that you're just good at that, right? We probably just would count the spaces. There is not a word count function, you're right. But I'm sure we could find 15 different ways to write that formula. Probably using VBA, which I'm not good at. Good stuff, buddy. Now, I've told our listeners a little bit about your background. Now, why don't you expand more and tell our listeners how you got to become an Excel expert and a PowerPivot expert? Well, it's kind of funny. Most people who get good at Excel, I didn't set out.
to be that, like, you know, really Excel people who quote unquote Excel people, they all kind of fall into it, you know? And even though I worked at Microsoft, I did not gravitate to Excel naturally. Like I remember at one point, like in the late 1990s, we'd finished up a release of Office, which is where I worked. And someone was asking me where I wanted to go work next. And I said, you know, I gave him a long speech. But one of the things I said was like, for instance, I could never go work on something like Excel, right? And I just said it like in this like really dismissive way, like there's just no way I would ever go work on something like that, right? I had no idea what Excel was like, really.
And I sort of accidentally got assigned to the Excel team at some point. I did not choose to go work on the Excel team. But it's funny. You fall into things, and then you decide, oh, I kind of like this. This suits me. And that's exactly what happened. It was really, honestly, fantasy football that we were playing at Microsoft in the late 90s before it was even a big thing on the web. We were scoring it using Excel. And I discovered that Excel was a way that I could gain an advantage over my coworkers.
you know, who weren't really Excel people. And that's really what started it for me. Like the first pivot table I ever built, like I worked on the Excel team for a year before I even knew what pivot tables did. Okay. And the first pivot table I ever built was to, uh, roll up the skill levels of a couple of different fantasy football leagues that I was assembling, right? To sort of matchmake, you know, and keep the competitive balance, right? And I'm like, oh, that's probably what Excel, what pivot tables are good for. And it was right. And believe it or not, that's the beginning. Like that's where the addiction started. Nice one. And then you went into Power Pivot, right? Well, also completely by accident. So I stayed on Excel for actually, you know, quite a while considering how quickly people move around at Microsoft. I was, you know, I was a veteran by the time I was done. So on the 2007 release of Excel, I led the team that did sort of the business intelligence focused.
features like you know the pivot table overhaul cube formulas which probably you know no one's heard of but it's really cool and the table feature that was on my team as well but these were all people reporting to me doing those features i had an awesome team i was just kind of like the mascot and about that time as we were finishing that up there was an actual fantasy football software team at microsoft that was building a fantasy football website and they came and knocked on my door and i said yeah i gotta i gotta go yeah and so i went and joined that team and after about six months that team was deemed that whole project was deemed silly by management and they canceled it And here I was now stuck in the other side of the company. And I got folded into Bing, the search engine. And I spent about a year there. Did not like it. And I was looking for a new job. And at that time, I was looking for a new job. Amir Nets, the distinguished engineer in charge of what was called Project Gemini, dropped me an email. Like I was looking at the career website at Microsoft. And he drops me this email and says, hey, you want to come look at what we're doing over here? And I went over there. I'm like, oh, my gosh, you're building like TurboXcel. Yeah, I'm in. So yeah, Project Gemini is what became PowerPivot. And I was one of the first few full-time engineers working on that.
And how is that, working on that and getting, you know, starting that from scratch into what it is now? You know, hugely surprising. You have this, as a Microsoft engineer, there's this cycle of emotions that you go through on every single product. At the beginning, you get really excited, like, yeah, this new thing we're going to do is going to change the world. Like, I'm sure the engineers that were building Clippy.
The Clippy office assistant were in the beginning of phases of that project. I'm positive that they were like, this is it. We're launching the dawn of intelligent assisted software. I promise you that's how they felt. And then the reality that you end up with is incredibly disappointing. And I think Clippy is probably the best example of crashed expectations. But seriously, when we were working on the table feature, we weren't thinking of it as the table feature. We were thinking of it as the beginning of structured reference. We're really going to make spreadsheets work the way that they always kind of should have. It's just incredibly ambitious. And then it becomes a useful thing, but nothing game changing.
And when I left Microsoft in 2010, PowerPivot wasn't even quite done yet. And I left for family reasons that we could fill an entire podcast with, but it wouldn't be relevant. So let's stay away from that. Yeah. And I left for family reasons and found myself in a corner of the country where there wasn't any software development going on. I was in Cleveland, Ohio, and I decided to just try PowerPivot sort of as the way to establish my personal brand outside of Microsoft. And what I discovered...
was that for the first time ever, something that we'd worked on, that I'd worked on, the original ambitious expectations that we had were actually justified. And in fact, I found something different, which is that it was way better than any of us had ever dared hope it would be. You know, again, I just started blogging about PowerPoint as a way to get my name out there and fully expected it to fail, you know, like not be very good. But like, I remember this lightning bolt moment where I'm like, oh my gosh, the world is going to change. And this was me working with it as a user at that point from the outside.
And that happened in like late 2009, early 2010. And every dollar I've made as a professional since 2000, early 2010. So like seven years in now, my entire profession has been 100% power pivot. Wow. And dollar made and also dollars saved for your clients, right? Oh my gosh, yes. We have single workbooks that we have built with our clients that save, you know, a particular client saves over $25 million a year from a single power pivot workbook.
And how is that? It's that workbook in a way. It's like the scorecard for the entire company. It tells them how they're doing. The CEO of this multi-billion dollar international organization, the CEO has access to this PowerPivot scorecard, which is an Excel scorecard. It's rendered in Excel with PowerPivot behind it. And they can view that in their web browser using Excel online. But it's sliceable and drillable. You can go down to regional managers and area vice presidents and get all the way down even to individual office.
individual offices within particular cities. It scores them all in terms of customer satisfaction, which is really the only thing that's important to their business. That's what determines their bottom line is customers in and you want to make that positive experience so customers come in and stay and reduce attrition, dissatisfaction. So customers leave. And so their customer intake funnel has become a lot more efficient.
And their, you know, customer leakage, you know, attrition has become, you know, much more reduced simply because everyone knows where they stand at all times. And this is the kind of thing that typically you hear people say, you could never use Excel for that, right? Like you need an enterprise business intelligence solution that costs millions of dollars and takes years to implement. And we did it in two weeks. Wow. Geez, man. Power People is amazing. I'm just, you know, scratching the surface of what's possible and you can do so much. And as you said, 25 million, that's, yeah, that's one company. Imagine how much you can save for all these other companies out there and that are using these enterprise solutions are just rubbish.
Yeah, the guy that I worked with at that company, he went to his IT team and said, we need this project. And they said, hey, fantastic. We can get started in a year and a half. Not even exaggerating. We can get started in a year and a half. And we were done in two weeks. And that thing's now run for almost four years, that workbook. So at $25 million a year, that's a $100 million workbook that we didn't charge them. We really need to figure out how to charge a percentage of the money saved. Yeah, yeah. One percent of money saved. There you go. Which then we'd probably hear a different story. Yeah, that workbook is saving us maybe like $100 grand a year. Nice one, Seth.
So now you're at PowerPivotPro.com. And I remember when you started, as you said, it was just yourself. But now you have like a team of 10 people. I see all these faces on the website. It's grown into a company, hasn't it?
Yeah, we're lagging behind on updating our team page. Here's the way it feels is that when someone tries PowerPivot out and starts seeing what it can do for them in their business, it's like they're the first person to discover fire. And they look around, you know, their colleagues and coworkers in the office and like everyone's still looking at them like nothing's changed, you know. And this person's like, didn't you see that? Like, wow, like the world just changed right there. Everyone's like, nah, we don't really get it, you know. And so those people, you know, that's sort of like what our whole company is staffed by now. That's who our employees are, those people who've seen this and they can't go back, you know.
They can't go back to the old way. And so some people, when they catch fire with PowerPivot, their organization, their company, they recognize it and they get it. And they're like, wow, we really need to be kind of going all in on this. And those people have incredible increases in their job satisfaction as a result. If you see it and your organization doesn't see it, it's really dissatisfying. You've got to go find some other place. We're collecting people like that. And the demand for our services is truly exploding because, again, even if in terms of percentage of the world and PowerPivot awareness is still really, really, really low.
Even knowing that it exists, much less knowing how to use it. But even though the percentage is really low, the absolute number of companies is large. And then Microsoft's also been doing, if you maybe heard about Power BI, this is what's really cool, even cooler in some ways, is that they are making a big, big, big noise, Microsoft marketing, about Power BI. And here's the amazing secret for the Excel audience. It's still just Power Pivot. It's the same thing. It's the same formula language. If you learn Power Pivot, you are learning Power BI at the same time and don't even know it.
And so the awareness of Power BI is also causing a big spike in demand for our consulting and training services. Wow. And what other services do you provide? Training and online training seminars? We have an interesting almost like personality crisis at our company. On one hand, like as a company, we ask ourselves, hey, are we a business to consumer type of company or are we a business to business type of company? So clearly the example where we did the $25 million workbook, that's us doing rapid consulting work for a big company. But then there's also like our relationship with individuals.
that are trying to revolutionize their careers, we're really passionate about that. And so our blog, we're one of the few consulting companies in the world whose homepage is just the blog. We allow the blog to be front and center. So for individuals, and also for scenes, but for individuals, we have an online video university that's sort of self-paced, incredibly comprehensive. And we've had thousands of people go through that over the years. And in fact, some of the people who are coming back and getting hired by us now.
are people who originally took that video university. So like the seeds were sown, you know, like in 2013 when we started that course. And so that's one thing that we definitely, you know, still run and people seem to love it. We also do, you know, here in the US, we do a series of public, you know, training seminars where we, you know, we go to a particular city and anyone can enroll as a student in that two to three day class. But our business is, you know, like every day where we're picking up new clients that we're helping them adopt. The core of our business is helping organizations adopt this stuff.
So there's always a fine line between training and consulting. One of the jokes we say is that if a company asks us for consulting, they say, we want you to build something for us. We teach them. We build it for them, but we also teach them how to improve it and modify it so they don't really need to lean on us except for brand new stuff that they've never done before. We can help them get over that hump. But they can continue to modify. That workbook, the $100 million workbook, has continued to evolve. The client knows how to modify it. So if they ask for consulting, we give them training. If they ask for training,
You know, the best training is also consulting in some sense, because if we use your data and your business problems as the sort of the environment, the test bed for teaching, it becomes a lot more impactful and you retain it a lot better. Yeah, that's probably a much longer answer than what you were expecting. Yeah, no, that's nice. I like it. Very clear. And our listeners will appreciate it. I've seen your blog posts and, you know, I love them, you know, put a lot of effort into it, a lot of design, a lot of artwork and just to make it clear as well. And, you know, your knack of writing is just funny. So for people out there who want to go and go on to the blog, go to palpivotpro.com and just...
Go to a few articles that Rob's written. They're really, really great. They're really great. And you're writing from another world, mate. So really good stuff. All right. Now, let's go on to the next part, which is your expertise. Obviously, PowerPivot. Now, for our listeners out there who are beginners and intermediates and haven't seen PowerPivot, tell them, what is PowerPivot for those people who haven't seen it or used it before? I think the easiest way to understand PowerPivot is in terms of the benefits that it provides you. Now, first of all, it's from Microsoft.
If you're telling people about it, make sure to emphasize it's from Microsoft. This is not something that my company has built. I helped build this when I was at Microsoft. So it is very trustworthy. It's from the trusted source, Microsoft itself. Secondly, it is an extension to Excel.
So PowerPivot is not some brand new application. You don't launch it from the start menu as a separate app. You launch Excel, and then you can activate PowerPivot from within Excel. You should really think of it as a second engine, a second brain hiding under the hood in Excel that is primarily a calculation engine, but also a data storage engine. So that's sort of what it is. But it's the benefits. Again, I think the benefits are the key. The first one is that the one that sort of gets people's attention pretty quickly is so much of our work in Excel is taking multiple tables of data.
There's a table that comes from this system over here and another table that gets emailed to me. And all of those tables ultimately need to kind of like come together and play a symphony together in order to give me some sort of meaningful result. And, you know, one of the places where Excel, people who are learning Excel tend to like hit the steepest wall is when they start trying to learn things like VLOOKUP to sort of turn all those tables into one big Franken table. And PowerPivot makes that super, super, super easy. You just literally can drag drop between columns across tables and say, hey, these two columns match. And PowerPivot goes, okay, got it. Those two tables can now work together without.
any additional work. So it's kind of nice, whether you're a novice or scared of VLOOKUP, it's actually easier to learn relationships than it is, which is what the PowerPivot drag-drop thing is. It's easier to learn relationships than it is to learn VLOOKUP. But even if you're a pro, you're a shark, you've been using VLOOKUP forever, and there's always people who are like, I don't even use VLOOKUP anymore. I'm an index match ninja. Even for those people, this is still way better because it's a heck of a lot less tedious, and it also doesn't make your workbook run slow. The workbook is still super fast. That brings me to the second benefit, which is you can cram a lot of data into PowerPivot.
One of the reasons why we see people using access all the time is because, well, we have more than a million rows of data and it won't fit on a worksheet. I have a single workbook that I carry around on my flimsy little laptop that has 300 million rows of data in a workbook. And it's in multiple tables that are linked together. And the whole thing recalculates in less than a second. Wow. Yeah, it's amazing. But even if you don't have 300 million rows, like I use PowerPivot to calculate and to analyze even a single table of 50 rows of data. I will use PowerPivot because it is just better. And that brings me to the third benefit, which is something I call portable formulas.
And it's a bit of an abstract concept, but once you see it in practice, you're like, oh my gosh, this is crazy. Like in Excel, when you go build some sort of sophisticated analysis or something, and then someone says to you, oh, that's great, but you know, I'd like to see it broken out a little bit differently. The Excel person's heart sinks because they have to go and rebuild the whole thing basically with that new assumption in mind. In Power Pivot, all of the formulas that you write, you write the formula one time, right? So if you have like a percentage of total formula or a change versus last month formula, or even like a year to date formula, you write that formula literally once in the whole workbook.
There's not even copying and pasting it across cells. And when someone asks you to change the look of things or change the question, you just check a single checkbox in your PowerPivot field list, and everything just automatically re-updates. The formula just automatically adjusts to the new question. And you're done. That's amazing, man. We even tell people that at that moment, when they check that checkbox and they get the new result, that they should enforce a 30-minute waiting period before they go back and show the results to the person who was asking. Because if you just show the checkbox, it cheapens what you did. It'll make those other people think that all you did was check a checkbox. But no, you earned that checkbox by being smart in advance. And then the final big benefit that I like to emphasize to people is auto-refresh. You're just grabbing the latest data and pushing it through a workbook to produce some sort of charts and reports. Even if the workbook is done, you just need to grab the latest data and do that. It's very often a labor-intensive process. With PowerPivot,
Refresh, the whole thing is a one-click. Even with data transformation, like you needed to make changes to the data and sort of format it differently on the way in. That's where Power Query comes in. And those two tools play amazingly well together. So single-click automatic refresh. And then even better, you can get to zero-click automatic refresh because you can schedule your workbooks to refresh themselves and distribute themselves, the latest versions, to your colleagues. So you could actually go on vacation and not have to log in from the beach or whatever.
to make the latest data for your buddies. Well, that's great because I get the number one question that I get from when I do my pivot table webinars is, you know, how do you auto refresh? And that always comes up. How do you automatically refresh? And, you know, there's a couple of ways that you can do it, but yeah, auto refresh is popular. And also how to consolidate or how to merge tables. And you just covered that by using PowerPivot. Man, that's amazing stuff. That is great. Awesome benefits there. Now I'm going to, in the show notes, I'm going to put in there how to install PowerPivot. So you don't need to explain to that. In the show notes, people can go there and I've got a tutorial of how to install PowerPivot. Now quickly, pivot table versus PowerPivot.
Well, the beautiful thing is, is that PowerPivot, when you're using PowerPivot, you're still using like the thing that you're seeing in the Excel grid, like your final results is still just an Excel pivot table. So, you know, everything you know about pivot tables is still completely valuable. Like PowerPivot itself doesn't introduce some sort of new like display type, like, you know, your pivot tables and pivot charts in Excel. That is the way that you see the data and the calculations that are being built in PowerPivot. So sort of like the final user interface for it is still just Excel sheets.
There's really no reason. Once you've sort of tried out PowerPivot, there's no reason to, you're not choosing between pivot tables and PowerPivot. It's more like, which kind of pivot tables do you want to make? Do you want to make pivot tables that are powered by the traditional under the hood pivot table engine, which is what we've been using for years? Or do you want to use the pivot tables that have the big monster PowerPivot calculation engine behind it? And so for me, I don't make...
quote unquote, regular pivot tables anymore. All of my pivot tables always have the power pivot engine behind them because I always want to take advantage of, even if it's a small data set, I always want to be able to take advantage of that portable formulas thing. I always want to be able to take advantage of the auto refresh thing, even for the simplest stuff. So it's not really an either or, which is really nice. Really, really, really nice. Now, there's a couple of features here that I want to talk about. And if you could just quickly explain to our listeners.
Number one, measures. What are they? They've changed the names? It was calculated field, then it was measures? Yeah, again, they've been changing it, yeah. Measures is what they've settled on, which I like. Measure is just a formula for a pivot table. So one of the things people are always asking us for when I worked on the Excel team was, I want to go to my pivot table and write a formula next to it in the grid and have that formula fill down and adjust as the pivot table changes size and shape. And at its heart, that's what a measure is. It's exactly that feature. You don't type it into the grid. You type it into a separate formula bar. And for those of the handful of people in the world who have been using...
Traditional pivot tables, there was a feature in there called calculated fields, which is similar to what PowerPivot offers you. By comparison, many, many, many years of an entire team at Microsoft building the measures feature, whereas the calculated fields feature was kind of like a tiny little thing that was put in years ago and never improved. So for instance, there's a distinct count function in PowerPivot's formula language that allows pivot tables to give you a distinct count, a unique count that doesn't count duplicates, for instance. And this is one of the funny ways that people discover PowerPivot is they're Googling or whatever. They're searching for, how do I get a unique count or a distinct count in a pivot table? And they're like, what was this PowerPivot thing? The measures language, the formula language for measures is 100% made to look just like Excel. So it has a sum function that works like the Excel sum function. It has an if function that works just like the Excel if function. Then it has a collection of these new magic functions, like distinct count, for instance. And once you've encountered this one function called calculate,
which is like the magic do anything I want formula function, I guarantee you that will be your new favorite Excel function. It'll be your favorite function ever. Whatever your current favorite is, calculate is your new favorite. Money some product. Well, I'm going to go calculate over some product any day of the week, man. Any day. Any day. Yeah. But I understand why some product is awesome. But calculate. Yeah. And you can do crazy things like a formula, like I said, that always gives you the year to date value. And if you like listed months down the side of your pivot table on rows, each one of those months will give you the year to date total for that that was true during that month.
And then you want to filter it? You can filter it. The formula just keeps working. It's really cool. Wow, that's just super, super amazing, man.
Wow. What else can calculate do? One more thing. What else can calculate do? One of the things that I've done a lot of before PowerPivot was I would often create multiple pivot tables on the same worksheet that all looked exactly the same. They had the same structure. It's just that I would set a report filter to a different value on each pivot table. So one pivot table would show me the results for region one, and another pivot table would show the results for region two. But otherwise, they'd look exactly the same. And then I would write formulas that reached into those pivot tables to do comparisons. So region one versus region two, the percentage of total or whatever.
And then you end up creating this other report, maybe on another worksheet, that hides all those pivot tables as data sources. Well, now you can have a single pivot table that's sort of like filtered in lots of different ways at the same time. So you can have a single field that's saying, you know, this is my region one sales, this is region two sales, or like this is my bicycles only sales. You have complete control on a granular, almost like cell by cell basis, if you want, within the pivot table over what the filtering is. But the report filter feature of pivots, you change that filter, it changes everything. You can sort of get individual columns filtered by different things. And you don't even have to display, like for example, like the region.
field you wouldn't have to have region on your pivot like on rows or columns or anything like that you can you could just have like region one sales displayed right next to total sales wow man and why hasn't anyone told us about this that's the thing that's been frustrating me the most it's sort of like so the power pivot feature was built by like the sql server organization but it was built for the excel audience okay that was my job was to make it you know appealing to the excel folks uh when i was working on it but it was built by the sql team the excel team didn't really understand it in the early years like in 2010 is when it was first released we're coming up on the seventh anniversary of the release of power pivot and we still haven't heard about it right really frustrating So the Excel team didn't really understand it at first. And the SQL team, even though they knew that they needed to build it for the Excel audience, they didn't really understand how to talk to the Excel audience. So all the efforts to sell PowerPivot were driven by the SQL team. And they were aimed at the business intelligence audience, which is an audience that looks at Excel and goes, why are you giving us Excel? It was a real mismatch the way that they tried to sell it, in my opinion. We have not had, to this day, any sort of concerted effort from Microsoft to advertise the existence of PowerPivot to the people who need it. It has just fallen through the cracks. And I'm optimistic because the Excel team...
They completely get it now, completely. They're huge fans. They realize, wow, this is the coolest thing that anyone's ever given us. Like the SQL team just gave it to them, right? And so, you know, they're really getting organized now and figuring out how they're going to, you know, sort of, you know, get the proper value out of that and to, you know, get the word out. So, you know, stay tuned on that. Fingers crossed that something excellent will happen. I keep checking in on that story. And, but yeah, nothing, nothing yet. All right. Good stuff, mate. And that sounds like it's very powerful. So yeah, thanks for letting us know the possibilities with those measures. Now, next one, DAX formulas. What are they for the people out there that it's the first time they're hearing it? DAX, the name, D-A-X, what does it stand for?
DAX is a scary name, right? It sounds hard. It stands for data analysis expressions. Shouldn't it be DAI? Yeah, yeah. The way to think of it is Excel Plus. For example, the IF function that works just like the Excel IF function is a DAX function. So if you write an IF formula in PowerPivot, you've written DAX. You get to go to your LinkedIn and update your LinkedIn to say DAX programmer. And if you got paid to do it, you're now a professional DAX programmer. That's a joke, but it's also the truth. You can and should do that. You know DAX. The DAX formula language was built.
to be an extension to the Excel formula language. And you can't use it in the Excel grid. You can only use it in the PowerPivot calculation environment. But again, that lives inside Excel. And the results of it get displayed in Excel. So it is absolutely an easy transition. You're writing some functions. You're writing if functions. You're like, whoa, I'm a DAX programmer, right? I'm a DAX formula specialist. But then you get to, you know, like, ooh, what's this calculate function do? Ooh. Just like the way that everyone learns Excel. You know, you learn it incrementally. DAX is something that, you know, I'm always getting a little bit better at DAX, just like everyone's always getting a little bit better at Excel.
So DAX is, as I said, an extension of the Excel formulas and only available within PowerPivot via the measures and also via the columns area in the... Yep, there's calculated columns, just like you would expect. All right. So how many DAX formulas are there? Oh, gosh, just a couple hundred. Yeah. Even just the functions that are used for navigating time, like the year-to-date version, the change versus last year version. There's a few dozen, just the calendar navigation type stuff, calendar running totals and trending and things like that. I don't actually know off the top of my head, but I think I would say at least 200.
There are many of them that I still, after seven years as a professional, have never used them. So you don't need to know all of them. There's like 10 of them. But if you know those 10, you can move mountains. Yeah, yeah. You're a consultant. Yes, exactly. Good stuff. Man, yeah, a lot of information. Great information. Thank you for that. And I know that our listeners have at least now started to understand what PowerPivot is, when they should use it, and the possibilities. That's great. Now, who should actually use PowerPivot? Should it be the finance analyst, the sales analyst, the admin person? Finance, for sure. In general, anyone that finds themselves building, let's say, pivot tables for other people.
or even for themselves. But certainly if you're building them for other people to inform them, PowerPivot should be in your tool set eventually. You don't have to go stampeding into it all at once, but your future lies there for sure. And you can be a beginner. It's not that hard to learn.
Wow. All right. Now, what's the weirdest thing that you've seen done with Power Pivot? I did a Pokemon team evaluator. There's a blog post. If you search Pokemon on our website, you'll find there was a – I wrote a simulator that will determine the optimal three-person, three-Pokemon team. I think that's probably – although the funniest things are client stories that I'm not allowed to tell. There's been some really funny things we've found with Power Pivot. We've got people stealing. Okay. Cool. It's like the eye of Sauron. Nothing hides from Power Pivot. You should implement.
Power Pivot in the IRS. Yes. Yeah. Although maybe not. We'll keep it from them. They'll need to know that we're stealing. All right. Now, what do you see Power Pivot in 10 years time? I see it as basically like a formula language is even being taught like in business schools. And it's sort of indistinguishable from the rest of Excel. Like it's just like the way that, you know, it's like a slightly more structured turbocharged version of Excel. We hardly even notice the difference between regular Excel and Power Pivot. I think that's the destiny. Wow. Taught in business schools. Is that happening at the moment? Some places it is. Yeah. I think Excel should be taught in high school. I agree.
Can we take a short break and we'll be back with Rob's online course and his favorite Excel tips. Can you analyze this spreadsheet using Excel pivot tables? Sure. If you can show me how to. Introducing the Extreme Pivot Table online course, which teaches you how to analyze business data and highlight key metrics so that you can make insightful business decisions, create interactive analytical dashboards that will reach top management.
and set you apart from your peers, which will make you more important and increase your chances of a promotion or pay rise. Developed over 15 years through extensive professional use and including real business case studies is the ultimate pivot table course. With over 200 short downloadable video tutorials accessible online anywhere 24-7, 12-month personal support if you ever get stuck, and a 30-day money-back guarantee. Visit myexcelonline.com today and give your professional development the boost it deserves. All right, we are back here with Rob Colley from PowerPivotPro.com, and he has a course about PowerPivot. Now, Rocky, tell us why you decided to create this online course. Well, there was a lot of reasons for it. So actually, let's start with the book that I first wrote. I wrote the first book, my first book on PowerPivot, because I noticed that even other Excel MVPs were not taking to PowerPivot. They didn't even really almost like know about it. And when they did try it, they didn't ever like get super deep into it. And this seemed like a real...
almost like tragedy to me because it's like it's super excel it's like excel just just way better certain things anyway and i wrote it almost like the first book almost like it's a love letter to the other excel mvps join us yeah like i think there are so many awesome excel techniques that i see every day you know from other excel mvps and excel bloggers and celebrities you know and and i go okay that's amazing how cool is that if they added power pivot underneath that they could add a completely another level of flexibility to it it would just blow me away and everyone else away and even them But some people don't learn as well reading. Some people really like video. There's so many different learning styles. I've been sort of getting more and more wisdom about this over time. Not everyone learns the same way. So the video course, when I set out to create it, was meant to be sort of the video alternative to the book.
And, but then as I was making the videos, something about making videos, like with all kinds of, like, I really got into that. Like it took me six months to make, to make this video course. And there's so many animations, custom animations that I made for it. And, you know, in the course of like raising the quality bar to that level, I started, it was, it felt like it was such like, like forever, you know, building this thing was like, it was going to stand for a long time. And so believe it or not, creating the video course forced me to even become better at power pivot, creating it. I had to go back and sharpen some fundamentals and get clearer about it. Creating the video course was the last time that I really personally,
got better at Power Pivot. That pushed me forward. So it was really kind of cool in a number of ways. Yeah, because it's like performing live. You've got to show it within a matter of five minutes. And you've got to know what you're talking about. It's not like a book where you've got to copy and paste and come back. But this is, you have your five minutes. You can edit it and understand that, but you've got to know what you're talking about. So you've really got to know what you're talking about. So that's the power of online training. So cool stuff. And it took you six months to record. My pivot type of course took 12 months. Really? I believe it. You know, if you're doing a good job of it, you know, like, and I remember over and over again, I'd be like halfway through like creating and recording a module. And then an inspiration would strike me. I'd be like, oh, you know, there's a much better way to explain.
this yes and i'd like put my head in my hands going and i can't unsee that thought i have to start over and sometimes yeah you record a video three times or four times yeah yep but you perfect it you know once you get it done it's there it's you know it's there forever it is it is and i'm disadvantaged i don't have the awesome radio voice that you do i'm gonna have to maybe hire you to be the voiceover well sometimes i have a sexy voice and put it on but i don't think i have a radio voice your voice is nice as well yeah I appreciate that. I don't know who has a radio voice. It's just, we just talk and teach. So we're not here to be disc jockeys. You know, we're teaching Excel. So look, I've taken your course and it's great. And people out there should definitely have a look at it. It's a great course. And your teaching style is just, it's unique. And yeah, you get your point across very easily. So easy to understand. So it's a great course. Now, what can our listeners expect from this online course? What kind of modules do you have? And what do you go through for anyone that hasn't taken this course yet? Advice I give to your listeners is that if you take our course, our video course, don't try to blaze through it. It is meant to be, you know, sort of slow, slowly chewed.
over the course of maybe even, you know, six months or so, because it is, even if you read like the latest version of my book, the video course is more comprehensive than that. I think there are like, I don't want to scare people, but there's like 96 separate videos that average about 15 minutes each. You can digest a single video in a sitting, you know, it's not, it's bite size. There's just a lot of bites. And by the time you get through like the first 25% of it, you're already a superhero, seriously, of data analysis. And then it's like, even in the book, there's like a chapter in our book that's just one page long that's called intermission that encourages you to just go put the book down, put the book down and go conquer in the world for a while.
Use those powers and then come back and read the rest of the book because like it just, you do not have to be expert at this to be amazing. Like when I was really bad, like bad at power pivot, I was already a superhero. It's a funny thing to say. I tell my students that your, your first goal in all of this is to suck. Just get to the point where you're bad at it and you're amazing. And then you start getting, you know, over time you get good. So yeah, it's incredibly comprehensive.
That intimidates people sometimes, but you don't have to just blaze through it. No, look, you just need two modules and then bang, you're up and running. So it's an hour and a bit, so it's not too long. Now, which people are you targeting for this? Is there an Excel beginner, someone that hasn't started yet, intermediate users that have been using Excel for a few years or advanced users? Who's this calls for? I definitely built it with the sort of existing PivotTable user in mind. And I wouldn't say that you have to be an advanced PivotTable user to start with PowerPivot.
But it's not even really that pivot table knowledge is crucial. I think it's more of like a qualification test in terms of what interests you. Like I have this theory that it's kind of a silly theory, but there's some truth behind it, that there's essentially like a data gene. that you either have it or you don't. And when you think about a pivot table, at least it is most fundamental. You're checking checkboxes in a list and you're getting some subtotals and grand totals. And it's not really fundamentally a complicated thing. But it's scary. Most people, even people who use Excel, are intimidated by it. So it's almost like it's an enthusiasm test. Have you been using pivot tables? Yes? Okay, then you're our people. You should definitely take a look at PowerPivot. But again, it's not like heavy-duty pivot table knowledge is a hard prereq.
for getting started with PowerPivot or anything like that. It's more like, are you the right kind of person? Are you interested in this kind of stuff? But for me, whenever we're working with a new client with our company, I always ask them, let's go find the people in your organization that are using PivotTables and VLOOKUP or the equivalent of VLOOKUP. There's always the index matchers that are a bit more hardcore. For the record, I never graduated index match, but we always look for those people. And I'll tell you what, if you're a Pivot and VLOOKUP person, PowerPivot is the most amazing thing for you.
And that's the target. I'm sure there's plenty of people listening that are in that scenario. So you should check out this course. Now, quickly, the modules. What do you go through this course? What kind of features or power pivot do you show?
The fundamentals in the first chunk of the course, we introduce you to what it's like to load data and how to do that. And then really it focuses a lot around this concept of relationships that replace VLOOKUP and the equivalence of VLOOKUP and how those work and how those really aren't for those handful of people who are database savvy. And by the way, I'm not database savvy. I'm not a SQL guy. Everything's really down to earth, no jargon, kind of our rule. And so we explain relationships as really just being...
wires that transmit filters. A filter can be sent from one table to another. We get into how the calculation engine works. There's a six-step process for how these calculations work. Super, super, super simple. None of the steps are complicated at all, but we just really drill that into your head. In the end of that first, let's say, 25% of the class, you walk away from that with a knowledge of how you can have tables linked together to play a symphony of data. It's not difficult. Then when you start adding formulas to your pivot tables, these things called measures, which are just the most amazing formulas ever, how those get calculated behind the scenes so that
If ever one of them starts giving you a number you don't expect, you're able to quickly debug it and figure out what the issue is. That's even in our live classes when we teach in person. Basically follow the same sort of curriculum in our live class. Those fundamentals are the thing that you really need to know. Once you know that, you can ignore all the rest of the advanced stuff for a long time if you want. That's where it starts. What are relationships? How do they actually work? Because, you know, learning to think in multiple tables is not something that's, it's not hard, but it's different for Excel people because Excel is a one table world. You want to build a chart? Get all the data into one table.
We want to build a pivot, get it all into one table. And so like PowerPivot is almost like the opposite. It almost prefers separate tables. It's new muscle memory. It's new neural pathways, but they're not difficult. They're just new. And the more advanced stuff that you teach at the end of the course, what does that cover? Well, we get into cube formulas, which are awesome for building scorecards and dashboards. We do a really sort of short introduction to macros. And if you've never been a macro user, we make that pretty easy. And we convey sort of like, here's the value in using macros with PowerPivot. If you are an existing macro user, you get some really good ideas for how you can use macros, like again, in concert with PowerPivot. We also provide...
sort of a library of sample macros there's just a lot of things about working with power pivot that gets you interested in different corners of the excel macro language like manipulating slicers for instance is not something that you know it's not traditionally been a hot spot for macro development so we provide some seeds in that regard but then we really get deep into the into the calculation engine the power pivot calculation engine in other ways and sort of show you like here's a way to triple your superpowers once you sort of established a comfort zone with the basics and if you kind of like bake them into your into your brain really good then we can sort of come along to you and say and here's the atomic weapon that's been you know, hiding in the shadows. We didn't want to tell you about it in the beginning. It's a little more complicated. But once you have that fundamentals, you can grasp this now. And all of a sudden, you know, like, it's like 10x on your existing superpowers. It's crazy. It's almost like this exponential or logarithmic scale, like the Richter scale or something like that. When you're a three on the power pivot scale, you're already 1000 times as effective as you are with sort of traditional Excel analysis tools. But then when you go from three to four on the power pivot scale, now you're 10 times what you were before.
I had this long curve where every three months I would look back at the things I'd done three months ago in power pivot and gone, Oh man, those, I could do that so much better today. But the thing I did three months ago was insanely valuable. Like it was, it was a world beater. So there's nothing wrong with it. It's just that like every three months I'm like, wow, I'm just like, my powers are expanding. It was a really interesting, you know, for me, it was about a year and a half of that, of like every three months going, yep, I'm a lot better. I'm a lot better. But, but I was awesome back then. I finally reached the point where I think I'm not sure that I'm, I'm ever going to get any better than I am now. Until they bring something else. That's right. Yeah. Yeah. That's a lot of powerful stuff. And I'm positive that a lot of your students have just taken this course.
gone on to bigger and better things in the corporate world. Do you have any testimonials or any scenarios like that of your students taking this course and then just getting a pay rise or getting a promotion? Well, over and over and over again, our students or our clients, the people that we help one way or another, and again, there's lots of different ways for us to teach you this stuff. The book, the video, on-site training, we do public classes. Again, it's sort of like everyone has a different way that they prefer to learn. But over and over and over again, we get unsolicited testimonials from former clients and students, and they'll email us, and they'll tell us their story every single time that are the same three words.
changed my life. That's what they say. I don't send out a survey saying, hey, has this stuff changed your life? Check here for true, check here for false. I don't ask any questions. This is completely voluntary. And over and over and over again, we could do this, you know, like the, if this equals that, we could do a string compare test here. Every single time the words changed my life come up, not changed my career, which would be awesome. Okay.
my life that's how much better and yeah people do they change jobs they make a lot more money it's amazing like that's the thing that's really the whole team of us like that's what really gets us up every day gets us you know pumped every single day is the life change and the happiness like the first slide that I put up on the screen when I do a public class has a big you know smiley face cartoon smiley face on it and the title of the slide is intro to happy nice we're there to talk about formulas and all kinds of other quote-unquote boring stuff yeah you know but I'm talking about life change and happy and it's the truth Isn't that crazy? Like software never does. Software never does that. No, no, no. But this definitely does that. This is just on another world, man. Power Pivot is just another thing. And hey, tell our listeners, they wanted to get in this course. How did they get in there? What's the best way to take your online course? Well, we have, you know, obviously our website, powerpivotpro.com. It's on our menus on the website under the how we can help menu item. But I think we're also going to put a couple of links like in the description of the podcast on your site. Is that right? Yeah, that's right. Yeah, we'll put the links in there. Yep. And we have a discount code for your listeners. Oh, nice. Thank you.
It's four letters. I think it has to be capitals. I'm not really sure if it's case-sensitive, but it's all caps MYXL, M-Y-X-L, in honor of MYXL online. And actually, that will be good for 20% off of the video course. You can also use it for any of our in-person trainings that are coming up. Sadly, they're only in the U.S. The video training, of course, is available everywhere. But our series of public classes that's coming up throughout the U.S., that discount code will also be good for 10%.
off of the, uh, the in-person course. All right. Thanks, Rob. And you can find the links to this course by visiting the show notes on Mike's online.com full slash podcast. Awesome stuff. Thanks, Rob. Now let's just finish up by going on to your Excel favorites. I'm sure you have a keyboard in front of you. What's your favorite keyboard shortcut? So, okay. You know, the stories of people who are taught Excel by like not even giving them a mouse, right? Like you just have to use the keyboard for everything. I'm not one of those guys that's, that's pried the F1 key off of this keyboard. Yeah. I'm a, like, I think that like a truly hardcore Excel modeler
would watch me work, at least with regular Excel, and be going like, wow, this guy, you know, he's kind of amateur, isn't he? You know, he doesn't know all those keyboard shortcuts. Like, for example, I have not learned to use the keyboard to navigate between worksheet tabs, you know, the page down, page up stuff. I don't even remember. Is it alt? Is it alt page up? Or is it control? Yeah, well, it's so awkward that my fingers can't get to it. And that's why I don't use this. I'm like, yeah, so. Yeah, well, I just have this mental block. Like, alt tab is meant to show me the thing I was just looking at, right? So, like, I just changed worksheets, you know, worksheets. I feel like alt tab should take me back, right? Like, computer, just know what I was looking at. Yeah.
Definitely the control arrow keys, you know, those are indispensable. Control arrow down, control, you know, arrow left, and then the control shift. Like, really, that's the stuff that I wear out. All right. Cheers, buddy. Thanks for that. Now, I know the answer to the next question, but I'm still going to ask her. What is your favorite Excel tip? Yeah, that's a setup, isn't it? My favorite Excel tip is to understand that you probably already have a version of Excel that has PowerPivot in it. You just need to go turn it on. So you go into Comm add-ins and you turn on PowerPivot. That's the number one checkbox. Nice. And if you don't have a version that supports it, you can always download the Power BI desktop.
And use that to work with PowerPivot because it's free. Yes, it is. Yep. Totally is. That's another good Excel team. All right. Now, what's your favorite function and why? My favorite function is the calculate function, which appears in PowerPivot. It's only in PowerPivot. It is the do anything I want magic function. There was an old joke when I used to work on the Excel team. And this joke has aged out because anyway, so I used to say, hey, folks, we've got average if and sum if. And then we had the sum ifs, sum ifs, and average ifs, right?
We have sum and count and average. Yep, yep, yep. There's no max. There's no max if. No min if. What the heck, guys? Did we just get bored? The reason this joke is dying is because Excel 2016 has now introduced exactly those functions, min and max ifs. And the calculate function is the anything if. You want year over year percent change if? Yep, that's calculate. You want standard deviation if? Yep, that's calculate. You want percent contribution of margin to blah, blah, blah if? Yep, that's calculate. And it's easy to do. It sounds like, ooh, that's scary. No, no, you just take any formula.
you've ever written in PowerPivot, okay? And then you can get the if version of it, like the filtered version of it. And it also lets you do all kinds of other crazy things. Like it's not even if, it's also like you can take any formula you've ever written and get the year to date running total version of it with just a flick of the wrist. It's crazy. It seems like cheating. And I always tell people when we teach Calculate in the class, like we're about to teach you your new favorite Excel function. Other really cool thing about PowerPivot formulas is that you don't really have to understand how they work.
Like if someone gives you an Excel formula and you don't understand how it works, the moment you have to modify it and you always have to modify it for your needs. Now, the fact that you don't understand how it works means you can't really follow the pattern. But in PowerPivot, the formulas, you just write them once. And every modified version of them is just manipulating the pivot table field list. You do anything you want with it. You never need to change the formula. So if someone gives you a formula that works, even if you don't understand how it works, you never need to modify it. It's sort of like counterintuitive that you can cheat and you can follow and you can steal and you can copy other people's patterns in PowerPivot.
You really can't do that in regular Excel, at least not nearly as effectively. Man, it sounds powerful, powerful, powerful. So all you guys out there, go for it. Calculate. Calculate is the formula to use within Power Pivot. Now, there are a lot of Excel add-ins. And what's one that you always use? Well, I won't cheat. I won't cheat and say Power Pivot. It did start as an add-in. Built by Microsoft. But it's much more baked in. It's more native now. I'm going to say Power Update is my indispensable add-in because there's nothing like auto-refresh where you don't even have to be in the office. Like the latest version.
of your dashboards and reports to produce the latest data gets pulled into them and then they get distributed to the right people hands-free without you having to be there to turn that crank yeah so power update is definitely my favorite add-in i'll put a link in the show notes for people to access that okay apart from your blog what's a great online resource for learning excel that you've found throughout your time let's see here so like i've been i've learned a lot certainly like from the like the mr excel forums over the years you know like anybody else like actually you know google is really the it's really the go-to right for basically everything most people actually find our site through google yeah as opposed to from word of mouth For me, I'm now almost a little bit snobbish. Unless someone's working with these new tools, it doesn't make a whole lot of sense for me to be reading and learning from them. But Ken Pauls, the MVP out of Canada, I actually originally wrote the first book for him. He was the one that pushed me over the edge to write the first book. That was your love letter to him. It was. It was my love letter to Ken Pauls. And it eventually took. And he's really power pivot and also power query.
He got so into those things that he quit his job. He's now like a full-time, you know, power pivot and power query professional. Like he's a, he's one of my, you know, my favorite conversion stories, right? Like I infected him and now we're back to where we used to be, which is that Ken does things that I look at and go, wow, I don't know how the hell you did that. That's amazing. Ken's website, excelguru.ca. Definitely a good one. He's a super smart guy, Ken. What a great, what a great dude. I've really been improved by knowing him. All right. Now, if you're going to remain one Excel book to our listeners, what would it be?
I didn't anticipate this question. The best Excel book to read might not even be an Excel book. I would read something like, if you haven't read it before, I'd read something like the book Moneyball. Even if you're not into baseball, which I am not, I am not a baseball fan at all. I found that book fascinating. And it shows what a handful of spreadsheet heads can do to an industry that's not conditioned to use data. And by the way, it's not just about baseball. Basically, these folks in the book Moneyball, they use spreadsheets and math and statistics and stuff. And I'm not a statistics.
buff at all. I'm not, I'm not, I'm not a stats guy. Um, but they use this kind of, these kinds of techniques just completely take unfair advantage over the entire world of baseball. Like they're just for a while there for a few years, like they're a grownup playing against children. So the beautiful thing is, is that there's nothing at all that makes baseball special in that regard. The entire business world is like that everywhere. Everyone's always talking about, Hey, what's the next big thing in data? Is it data science? Is it big data? Is it Hadoop? No, like we see, we work with hundreds of companies every year. And the number one thing that's the next big thing in data is doing sort of like what we would think of as the basics and doing them well.
There are Moneyball-sized opportunities everywhere. Every single person listening to this is working for or with companies that absolutely can be revolutionized and on short timeframes by truly applying data and applying these data tools effectively for the first time. They have to just get out of their comfort zone and learn these tools. And they're going to find out some great insights about the company. And can you see that one day, the headline, Power Pivot Wins the World Series? That would be awesome. I'd pay a lot to see that. But I think the book Moneyball, it's a page-turner. It's exciting.
It's an exciting book if you haven't read it. It is fun to read. It's well-written. And it almost reads like a novel, except that it's true. The whole thing's true. A novel about data, but it's true. And it's just so great. Thanks, Rob. You can find the links to this book and everything we've been chatting about today, including tutorials on Rob's favorite shortcuts and tips by visiting myexcelonline.com forward slash podcast. I have a final scenario here for you, Rob. Okay, let's say that I'm an Excel beginner or intermediate user, and I need to learn the most important features of Excel within a week because I have a job interview coming up.
With all the Excel knowledge that you know today and all the online and offline resources available will be the quickest way for me to start learning Excel and preparing for this job interview. Wow. I have found that, especially with a job interview, the unfortunate thing is the person interviewing you probably doesn't know the difference between someone who's good at Excel and someone who's not. That's right. That's fortunate and unfortunate, right? If you happen to be being interviewed by someone who is good at Excel, the number one way to impress someone today would be to say that you know how to write macros or even better, in some ways, scarier, is to say that you know how to do array formulas.
Those are sort of the apex predators of the quote-unquote traditional Excel world. I don't know that going into a job interview and saying that you know PowerPivot, sadly, I don't think it's going to help you that much yet because the awareness isn't there. If you know about it, if the interviewer doesn't, you're not really going to get any credit for that. If you can show them examples of the work that you can do with PowerPivot, that's different. Of course, that requires that you have access to their data ahead of time, which doesn't really happen in an interview. The Excel interview is a tough one. If you always know your audience, like even in a presentation situation, knowing who your audience is, if you can find out some things about your interviewer before the interview, that might make a huge difference. If they're a Wall Street financial type.
Going in there and talking about macros and array formulas is probably going to be your most wow factor. That'll get their attention. If they're not like that, if they're not an Excel person, being really good at charts to make pretty charts, knowing how to make things pretty will be your best skill set. And not knowing who the interviewer ahead of time is a big disadvantage. So if you think it might be one or the other, like sort of an Excel novice that's interviewing you or like a high-end modeler, I would invest in those two directions. Be able to say that with a straight face that you can write macros and array formulas.
And also, by the way, here's something that I've made in Excel. I can make things look this good. Yeah, you're right. Because there's always a lot of, you know, management reports that you do every month. So if you can show that charts and make it pretty, I'm sure that you will have an advantage compared to the next person coming in there. All right, Rob, that's a great answer, buddy. Finally, what's the best way for our listeners to connect with you? Well, you know, we hang out at our website, read our articles, powerpivotpro.com, leave comments. We're pretty active in responding to comments. We're also Power Pivot Pro on Twitter. We're pretty responsive there as well. So those are, you know, sort of the two primary ways. We also have a Facebook page and YouTube. We're in the process of revamping those. So I would focus on our website.
and on our Twitter. All right, Rob. Thanks, buddy. Thanks for your time today. It's been an eye-opener with Power Pivot. A lot of our listeners as well have just seen the power that's within Power Pivot. And you've given us a lot of insight. You are a genius in that field. And thank you for your time. On the contrary, thank you for having me on. This is an honor. I really appreciate it. Well, thanks, Rob. And hopefully I can get you on again down the track when you have your new book coming up. Are you planning to release a book? I have another book idea in mind. It's too early for me to disclose it. Another love letter.
Another love letter. This one would be, the teaser I'll give, this one would be very non-technical. It would be about data, but not technical, not about the formulas and stuff. Maybe fictional. Oh, maybe. A love letter novel. A data love letter mystery. To data nerds. Yes, from data, with love. Good stuff. I'm looking forward to that, Rob. Thanks once again, buddy, and speak to you soon. Thank you very much, John. Much appreciated. Hey, guys, I hope you enjoyed this podcast show. Thank you for listening.
Now, I need your help. I need you to please leave an honest review for the MyExcelOnline podcast on iTunes. Now, ratings and reviews are extremely helpful and greatly appreciated, and I read each and every one of them. So if you go onto iTunes and search for the MyExcelOnline podcast, you can leave a review and also subscribe so you can receive all the new episodes as soon as they come out. Also, if you go over to my blog at MyExcelOnline.com slash blog, you can subscribe to receive weekly Excel lessons for free. Now, these are going to be delivered to your inbox each and every Friday containing a lesson on formulas.
pivot tables, charts, and analysis. By signing up, you also get a copy of my free Excel ebook called The Ultimate Excel Resource Guide. In this ebook, I show you and review the best Excel blogs, the best Excel YouTube channels, the must-have Excel forums for you to succeed. I handpick and review the best Excel online courses. I'll show you the various Excel books that are available. And I'll also explain the different time-saving add-ins that you must have in order to get the full potential out of Excel. Plus, I have much more information. Now, this e-book is jam-packed, full of value, and it's free if you sign up to my weekly Excel lessons. So go over onto my Excel blog and subscribe to receive your free e-book and also get your awesome weekly lessons. All right, until the next episode, keep excelling.
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.