This is the My Excel Online Podcast, episode number three. 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 Mikoludis. 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 PE, 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. G'day, guys. Welcome to the MyExcelOnline podcast with your host, John McElutis. In today's episode, I'm going to talk about my flagship online course, which is called the Extreme Pivot Table Course. Now, I spent over 12 months preparing this Pivot Table course just so you can become an expert in pivot tables.
200 tutorials as we speak, 217 to be exact, and I have 14 different chapters. Now, these tutorials are short tutorials. They're three-minute video tutorials. You can view them online during 12 months, or you can download them as well, and you can keep them on your computer, and you don't have to be connected to watch them. So you have the two options there. And the different chapters that I go through, I'll explain a little bit about them. Now, the first chapter is about customizing your pivot table. So I'll talk about how you need to arrange your data set before you create a pivot table. So you've got to put it into a...
tabular format so you can get your data into that pivot table. Once you have it into that tabular format, you can do lots of analysis. So I'll quickly explain about the different ways that you can get a clean data set in a tabular format. And then we'll talk about creating a pivot table and the different areas within a pivot table. And then I'll talk about all the different options that are there under the options.
tools. So I'll talk about the data, talk about actions, different styles, options regarding refresh, refreshing your data, the different designs, you have different pivot table styles and how you can customize them. Then we'll talk about the layout of the pivot table and how you can add in subtotals, grand totals, and then the layout and format. So we're going to there regarding how to format error values and format empty sales. So that's the first chapter. The second chapter is about value field settings and how to summarize values by. We have different ways to summarize values by, and that's by sum, by count, average, maximum, minimum, product, count numbers, standard deviation, and variance.
Then the third chapter is about show values as. There are different ways that you can analyze your data, and this is great. We talk about the percentage of grand total, the percentage of. We do the difference from previous years or previous months, the running total in or year to date. And we can also rank from smallest to largest. So we'll talk about the different ways that you can show your pivot table data. Then we'll go into grouping. You can group by dates, by months, by quarters, years. You can also group by sales ranges, by text, and also by time. We'll go into sorting and the different ways that you can sort your pivot table. Then we'll get into filters. There's an array of filters by date.
by labels, by values, by top 10, by bottom 10. I'll go through each different scenario. Then we'll talk about slices, which is a new feature in Excel 2010, and how to insert a slicer, the different slicer styles, and how you can customize those slices. We also go into calculated fields and items, and I'll show you in which scenarios you would use a calculated field and an item. Then we'll go into pivot charts and how to insert a pivot chart, the different pivot chart designs and layers, and then we go into creating a dashboard with slices and pivot chart, and it's a really fun tutorial there. Then we'll go into conditional formatting, and I have 17 different tutorials just on conditional.
formatting pivot tables. Conditional format is great and you get lots of value out of this chapter. Then we'll go into the get pivot data formula and how to use it and when to use it. Then we'll talk about macros and recording a macro using your pivot table just so you can show different scenarios like a top 10 macro and a different pivot table views macro. So I've got six tutorials there. Then we'll talk about data management and how to reduce file memory because if you have a lot of pivot tables, then your memory gets eaten up. So I have different ways where you can reduce file memory. And the final bit is a bonus video. So I have extra tutorials there. I talk about the break-even model, the frequency distribution.
how to consolidate, sales forecast, interactive balance sheet pivot table. So all up, there's 217 tutorials and I'm always adding new videos throughout the year. And within each chapter, you also get tips and you also have two business cases, an accounting business case study and a finance business case study. So I'll show you how you can apply the different pivot table features using accounting and financial data. So all in all, an amazing resource. If you want to become a better finance analyst and be able to analyze millions of rows of data with a press of two clicks, this extreme pivot table course is for you.
Now, this course is for new Excel users, beginners, intermediates, and even advanced Excel users. If you have lots of data that is given to you and you need to analyze it quickly without using formulas, then this course is for you. So I'm talking about finance analysts, accountants, business owners, engineers. I even have a doctor who is taking my course because he's analyzing all the different data from a sample test that was given to him. So if you work with data that needs to be analyzed quickly, efficiently, and without errors, then this course is for you.
Now, the course is designed for Excel 2007, 2010, 2013, and 2016. Now, in 2007, slices are not available and also some pivot table calculations. Now, I have some student testimonials here that I want to share with you. I've got Joyce from England that says, I've learned more about pivot tables within a week of taking this course than I have over the last couple of years. Really amazing stuff. Also, Jose from Spain says, this is the best Excel course that I've taken. It not only talks about pivot tables in great detail, it also touches on charts, conditional formatting, and macros. James from the US, this course is tremendously comprehensive.
The best part is that the course is served in small, bite-sized pieces that are easily digested. A teaching course that doubles as a reference guide. And also Gary from Australia says, I will highly recommend this course for anyone who wants to harness the power of using paper tables. The most important thing for me was that the course went through every aspect of a paper table and thoroughly went through each option. Even though I have used paper tables for some time, this course went through many aspects that I did not even know existed.
Now, after taking this course, you'll be able to analyze as well lots of data and tell a story in a quick and interactive way. You'll also learn how to build stunning dashboards and get noticed by top management and prospective employers. Now, I also have a special discount for all the podcast listeners. Now, if you put in the coupon code podcast in the checkout area, you get a special discount just for listening to this podcast. And what I'm going to do is have links on the show notes. You can click and go to the paper table course there. You can enter the coupon code podcast and get yourself a discount for the course.
So the other features that you get when you sign up to this course is you get all the workbooks that we go through. You can download them and keep them on your desktop for free. And you get a high definition quality videos viewable from your PC, laptop or tablet. Also with our high-tech learning platform, you can track your progress, ask questions, and interact with other students. You also get a bonus pivot table cheat sheet. You also get a free tutorial progress tracker. And I also throw in my free top 20 time-saving keyboard shortcuts. I also give 12 months personal email support. So if you ever get into a jam and you don't know how to do a certain task using pivot tables, then I will get back to you as soon as you send me an email with an answer. You also get a certificate of completion.
And that's another great thing is that when you finish the course, you can download the certificate of completion saying you completed the course, which you can add to your resume. You also get 25% discount on any future courses as a Mike's online student. I give that discount to any future courses which I bring out. Finally, you get 30 days money back guarantee. If you're not satisfied with the course, then I'll return 100% of your money without any questions. That's my personal guarantee to you. So you've got nothing to lose there. This is an awesome course. I've got over 10,000 students who have taken this course and have increased their Excel skills. I've got some great feedback from everyone. So that's the course for you guys. The Extreme Pivot Table course. Have a look at the show notes to get your discount coupon. And if you have any questions, you can always send me an email at podcast at myexcelonline.com.
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.