My 20% off opportunity for early bird students is gone in:
“How To Understand And Use Pivot Tables To Quickly Find And Present The Crucial Patterns That Are In Tables That Contain Dozens Or Even Hundreds Of Columns, And Hundreds, Thousands, Or Even Hundreds Of Thousands Of Rows…Without Typing Any Single Vlookup, Sumif Formula, Etc., Neither Investing In Costly BI Solutions Nor Coding Complex Macros”
Dare To Know The Truth About How To Completely Understand And Unleash The Unlimited Excel Data Analysis Power And Stop Being Intimidated By Colossal But Insightful Tables?
Wednesday, 10 AM.
From: John Franco, Excel author, creator of Wizdoh.com
Dear Excel User,
You work with big tables and you need to quickly find the crucial details you need and present them in the format you and others want, but…
…You and I know certain things about working with big tables…
…we almost never scroll vertically to the bottom because it seems we would never get there anyway. And even if we could scroll the table vertically or horizontally we couldn’t get any insight from it because the damn table is inscrutable.
And the big data keeps becoming bigger and bigger. It’s a big data fever.
With more volume, we can gain even deeper insights into our business. But we know the data is full of secrets waiting to be uncovered ONLY by those who have the key.
Like you, I was in the same situation when I was intimidated by colossal files of $300+ million Civil Engineering projects.
So, you are reading this letter and doing it for a single reason…
…because the crucial data that is in your hands to make or support major business decisions, is like a closed book. The secret relationships inside the data never leap to your attention, because in a sense, you cannot open the book.
We treasure our data because those books contain lots of opportunities.
We know the data contains the cold hard facts of what happened, of where you are right now as a business or organization. The data contains the keys to make decisions to repeat your success or avoid failures in the future.
And there’s so much data that you are always stumbling upon new tables and want to know what it’s all about, cost effectively.
You want to analysis and present the damn data to make or support critical business decisions, and do it in minimum time and with minimum effort.
On your data analysis journey, you are already familiar using formulas such as VLOOKUP, INDEX & MATCH, SUMIF, etc, to create highly customized reports, but you are reading this letter because you are playing a faster data analysis game, and need a better tool…
…why Excel formulas fail
You can find the details you need using Excel formulas but they take too much time to type, debug and to explain to others. You will struggle with changing your formulas to each cell every time there is a revision.
Once you set up formulas, they usually run without any effort, but we tend to forget how they work when we finally need to change or fix something.
And Excel keeps slowing down and locking up because of the large amount of data. Excel formulas can bring Excel to its knees, making your spreadsheets painfully slow.
That’s not what works in today’s fast economy.
And you need to spend time explaining to your colleagues how the spreadsheet works.
It’s lonely at the top
You are interested in quickly finding the details you need and creating customized reports using Pivot Tables because you are a boss. Meaning that you are in a leadership role, aspiring to a leadership role or providing powerful support to CEO, Business Owners, Executives, etc.
But winning the leadership game and establish your reputation and respect is not easy because…
…Pivot Tables contain so many options and are not so easy to understand, and because…
…you cannot ask for help because you are alone in your hero quest to insight to leading your organization to deliver value to your customers, improving business processes, and meeting objectives.
So, you cannot bounce things off your staff simply because you need to make decisions at the speed of business. And because providing the answers on our own is crucial for our advancement in our career.
And because they don’t understand what Pivot Tables truly are.
You wouldn’t want to navigate your journey alone, I mean, without the proper tool, right?
The reason why Pivot Tables are the future of Excel…
There’s no question you need the so-called BI capabilities. But many forget two important facts…
Fact 1: Pivot Tables are BI!
Fact 2: BI is big business and Microsoft want a part of the pie!
You should not think Excel differently from BI because Microsoft is including Power Pivot (Excel 2016), data models and other innovative BI features as part of the Microsoft BI suite.
And guess what?
Pivot Tables integrate fully into that set of innovative BI features.
Actually, if you learn Pivot Tables, you embrace the future of spreadsheet technology.
BI are built for corporations not for individuals because they lock you up into monthly fees, and into another corporate-like reporting system, you will hate. And BI software also has a learning curve. And your company might abandon that altogether and return to Excel.
And the reason why most professionals love Pivot Tables is because they give them total control over the analysis process.
Why are journalists taking Pivot Tables classes?
Yes! Journalists are taking Pivot Tables classes. And they are doing it to get deeper into research of corruption cases, understanding national budgets, etc.
They need to understand. As professionals and leaders, they analysis the data to be ahead of their game. But journalists don’t call themselves data analysts. They are just being professional journalists.
You don’t need to identify with being a data analyst if that’s not your specific role. Instead of focusing on the data, focus on what you get from the data…
…understanding, wisdom, leadership, breaking news!
If you are a professional and leader, then Pivot Tables should be in your toolbox.
How I discovered and understood Pivot Tables and why you can master PTs too…
I discovered Pivot Tables like you. Everyone was talking about it. And we never want to miss something important.
But important things come at a price…
…it took me years to figure Pivot Tables out. During the first years, I managed to get my reports done but never at the first attempt. I was afraid and nervous because if someone would have asked how did I do it, I would have been unable to explain it because it was half by chance. I knew I was in front of something different. A new technology.
I dedicated the next years to study this new data analysis technology so I became able to fully take advantage of it.
Being a professional, I decided to make my research more systematic. Everything changed when I realized I was focusing on Pivot Tables and not on the data itself. Then, I started looking for patterns and relationships in the data, and then, I started connecting the dots. From secret data relationships to how Excel stores those relationships, I learned it all.
Once I discovered the secrets of pivoting data, I took advantage of working with huge tables to gain experience with Pivot Tables.
And I can show you exactly how Pivot Tables work!
Why Pivot Tables are learnable
Many professionals think Pivot Tables are not learnable because few people seem to understand them. There are way too many options, they are too complex and the reports not predictable.
Those who get it are seen as having a special gift or insight that lead them to understand Pivot Tables.
Nothing is further than truth…
It’s interesting how asking the wrong question can lead us to never try something.
Asking, “are Pivot Tables learnable?” is like asking, “are cars learnable?”
You know that question is not rooted in reality. A better question should be, “is driving a car learnable?”
Many professionals think Pivot Tables are a thing they cannot learn because they see it as a thing, not as a verb. If you make Pivot Tables a verb, then you find the concrete things needed to be done to perform the action. For example, finding an appropriate car, knowing how to turn it on, how to stop, etc.
Now you understand why my Grandmother says, “I can’t learn how to use computers.”
She never sees the details.
You can use computers because you know the details such as how to turn it on, where the programs are located, how to open a program, etc. The same with Pivot Tables. For example, you can learn what kind of tables are used, the kind of fields used, the type of result you get if you drop a field to one area or another, etc.
The secret to learn Pivot Tables is that you stop focusing on the damn Pivot Table as an entity and start focusing on the details that make it work.
What I discovered after 10 years of working with Pivot Tables…
Imagine that every time you change a view of your data, you are going to have another “Aha!” experience that you didn’t have on the previous report?
Being insightful is crucial if you are on a leadership journey.
And because being insightful realizes you.
We all crave for clarity, foresight, and wisdom. And Pivot Table is our crystal ball!!!
People who use Pivot Tables gain confidence to be in a leadership position because once you increase your confidence, you fear less and can go further.
And there so many benefits of using Pivot Tables…
Eliminate array formulas and complicated lookup formulas with their use, save space in your spreadsheets because you don’t need to create auxiliary columns neither hiding your calculations, you don’t need to spend time explaining to your colleagues how the spreadsheet works because your reports don’t contain complex formulas, PTs make your data more manageable, you won’t feel intimidated by big tables anymore, create emergency dashboards, be prepared for more complex reports that might be coming
And now I am ready to share my secrets with those who are willing to advance their data analysis methods.
If you are not willing to lose this unfair advantage over others who don’t use PTs yet, then here’s a way to understand Pivot Tables, gain experience working with Pivot Tables and big tables, and develop your confidence to use them in any situation, in minimum time…
Announcing my new Excel Coaching Program!
Showing professionals, data analysts, managers, and consultants, how to completely understand and use Pivot Tables for instantly finding and presenting the details they need.
This comprehensive online course walks you through Pivot Tables and helps you build confidence so that you can apply the concepts in real life, or put the skills on your resume.
During this in-depth and easy to follow Pivot Table 7-hour online course, you’ll learn:
- What the real power of understanding and using Pivot Tables in your work is. You will see how you can be in control of your data, your work and so your life
- How to understand Pivot Tables. Go beyond the popular HOW-TO training tailored to the masses and get deeper into secret Pivot Tables and data analysis insights that many pros never unveil because they have a big Ego to satisfy
- Gain experience with Pivot Tables in minimum time by learning the fundamentals. If you master the Pivot Tables fundamentals, the rest will follow. Don’t be part of the horde of people doing painful trial and error and hoping their random “fields dragging and dropping” will produce the customized reports they want. Gain knowledge of the fine Pivot Tables points such as cube and cache technology, the difference between Excel and Pivot Tables, the 2 types of data fields and how to use them (all tables have them but none of them reveal them), the 7 new Pivot Tables perspectives that will give you the right mindset to take advantage of Pivoting technology, what kind of tables are suitable for Pivoting, what operations are available, how the fields are arranged, how the different measures are calculated, etc.
- Learn in what format the data should be put to analyze it. Avoid the costly mistake that keeps people working with the wrong kind of tables and never being able to express what they and their managers need
- How to organize a simple report with a large amount of data. Understand the fine points and tricks such as how to show less/more detail without trial and error, etc.
- How to create fully customized analysis and reports. Learn how to express what you want with Pivot Tables report blueprints. Discover how to exactly drag and drop the fields to show the metrics that you want such as top 10 products/students/projects, total sales/cost per product and quarter/month/week, etc.
- How to keep the PT formatting while updating (an entire module is focused on this)
- Techniques to avoid Excel slowing down and locking up because of the large amount of data (an entire module is focused on this)
- How to create Pivot Charts step by step
- Learn the concepts through varied samples across many industries and purposes: financial, grocery list, store sales, pipe network, HR, payroll, operations, education, sales, infrastructure, health, accounting.
This Could Be You !
What makes this course different?
Knowing the HOW is not enough because situations vary. You NEVER find a 1-2-3 situation. The key to succeeding in today’s hyper-dynamic world is learning the WHY, the core, which never changes. The course teaches you the WHY and infuses the HOW with this intelligence.
Are you going to learn Pivot Tables from the right master?
I am very well known in this industry as the guy who gets to the root of the matter, and explains it in lay terms anyone can understand. You will find here insights, not information (just look at the kind of testimonials my students and subscribers send me).
- Excel 2010+
- And a desire to get started
This Pivot Table coaching program covers it all…
This program will show about everything from scratch to create any varied and customized report.
Module 1 – Pivot Tables fundamentals – How to gain experience with Pivot Tables in minimum time (2 hours)
Discover things such as: Why you should learn Pivot Tables, How a PT achieves faster data analysis and presentation (Yes! understand PivotCache, Getpivotdata and cubes), Pivot Tables definition – Learn what a Pivot Table is, How to create a Pivot Table report step by step, How to improve your relationship with Data, How to identify the right kind of tables and how to prepare the data, etc., …and so much more…
At the end of this module, you will understand Pivot Tables and gain experience in using Pivot Tables.
Module 2 – Immediate insights and reports – How to uncover the patterns that lie in the data and express what you want in customized reports (2 hours)
Discover things such as How to show more/less detail, How to Aggregate data and make a calculation, How to see the data by date, subject and unit at the same time, How to combine texts, dates and figures, …and so much more…
At the end of this module, you will be able to quickly organize the data and produce a useful report fast.
Module 3 Pivot Tables Control – How to fully customize your PT reports (2 hours)
Discover things such as How to control the layout of your PT report, How to control the subtotals display, How to control the format of your report, How to control the location of your report, …and so much more…
At the end of this module, you will be able to fully customize your reports to express what you and upper management need.
Module 4 – Up to date Pivot Tables – How to keep your Pivot Tables 100% accurate and fresh (1 hour)
Discover things such as Why you need to update your Pivot Tables, When to update your Pivot Table report, How to update your Pivot Table report manually, How to automatically update your report upon workbook opening, How to automatically update your report every x minutes, How to automatically update your report to include new data (auto-refresh using VBA), How to prevent your formatting to change upon updating, How to avoid having to manually refresh all of your Pivot Tables to get them to include any new data, more updating troubleshooting, …and so much more…
At the end of this module, you will be able to automatically update your reports, and avoid common issues during updating such as formatting lost or new data not included.
Module 5 – Sharing Pivot Tables – How to share your insights confidently (1 hour)
Discover things such as Problems of sharing Pivot Tables, Questions you should ask before sharing Pivot Tables, What to include when you share a Pivot Table?, 5 ways to share a Pivot Table?, 3 Pivot Table professional formatting tips, …and so much more…
At the end of this module, you will be able to send your Pivot Tables the right way, to the right person.
Module 6 – High performing Pivot Tables – How to boost the performance of your Pivot Tables (1 hour)
Discover things such as 3 secrets to keeping your Pivot Table report file light and fast, 2 Proven ways to manage the PivotCache memory usage, …and so much more…
At the end of this module, you will be able to work with Pivot Tables efficiently even if you work with big tables.
Module 7 – Pivot Charts – How to present your Pivot Table report graphically (1 hour)
Discover things such as What is a Pivot Chart?, How to create a Pivot Chart step by step, Differences between regular charts and Pivot Charts, …and so much more…
At the end of this module, you will be able to quickly present your reports graphically using Pivot Charts.
Here’s how it works…
- Order your Pivot Tables Domination Home Study Course right now. Choose either one payment or the generous payment plan.
- You’ll get immediate access to the video lessons so you can get started right away if you like.
- If at any time within the next 60 days you decide this system is not for you, simply send me an email and you will receive a prompt refund.
How much is this?
Pivot Tables is not brain surgery. You can figure it out on your own. Eventually and if you are willing to invest time and effort doing trial and error trying to create even simple reports from big data, or reading books, forums, and blogs and synthesizing that information.
Or you can take advantage of the 10+ years John’s already invested in hard work dealing with big tables and Pivot Tables, researching and synthetizing his findings.
There is absolutely no sane reason why you should want to waste years of your own career attempting to cover this same ground.
It’s up to you.
If you order today, you can unleash the data analysis of Excel and quickly analysis and present data for just…
*Videos will be available for download after the 60 day Money Back Guarantee period ends. You can watch the videos online in the meantime. Downloaded videos are for personal use only. Videos cannot be shared with others.
**Membership and access to the training materials is for one person only. Multiple logins will be blocked by the system.
If you decide to attend a live training, you will spend that much just on the traveling and hotel expenses. And if you have attended Excel seminars, you know many of them suck. You don’t have the chance to retake the lessons, The teachers don’t walk their talk (they don’t use Excel in the real world, to solve real problems), you need to get absent from your work or business, you are exposed to silly questions from poorly trained students, etc.
If you are looking to get Excel training focused on price only, you will end up hiring mediocre trainers and enrolling in superficial programs.
There’s a saying that goes like this: “if you think education is expensive, try ignorance.”
…just think, how much will it cost you to do nothing?…
…no confidence to put this valuable skill on your resume to land a new and better job. No ability to lead your organization to a brighter future and get a promotion for doing it. No ability to understand the world around you and make better decisions.
If you are serious about quickly analyzing the data and present the insights to upper management, and secure a leadership position, get a better job, put Pivot Tables skill on your resume, then this course is for you.
And you risk nothing…
You love it or your money back
If within 60 days of purchase, you follow the video lessons, do the homework and cannot understand and use Pivot Tables to quickly find and present the crucial patterns that are in your data, or if you simply didn’t like the material, just ask a refund and you will get your money back, no questions asked.
Just contact us (use the subject “refund”). Will take care of it.
Click that button and take your first step to understanding and using Pivot Tables that will supercharge your data analysis skills, your earning potential, and your life.
To Your Success,
And one more thing…
…if you order today, I’ll give you these practical bonuses:
Bonus 1 – 20+ category-rich Excel practice files
Download more than 20 curated Excel category-rich practice files.
Have identical data to manipulate, so you apply the principles appropriately and further understand them. Yes! Every example is exactly as presented in the video so you are able to move quickly through each concept.
Find inside varied samples for many industries and purposes: financial, grocery list, store sales, pipe network, HR, payroll, operations, education, sales, infrastructure, health, accounting, etc.
Get hands-on experience creating each Pivot Table report so you know you’ve mastered the skills.
If sample files are not available at present, you can use these practical sample files to get started with your learning today.
Bonus 2 – Notes of the course to further your learning
It’s a gold mine of notes covering the entire range of Pivot Tables topics. You can keep it as a reference, enrich the map with your own notes.
Comes in PDF format, and in native .xmind format so you can put your hands on it, edit, expand the notes with your own insights and notes (Instructions to download the free mapping file are provided inside).
Limited-time bonus 1- “Dashboard Formulas Blueprints” Coaching Program ($297).
This program will show you how to extract information from colossal Excel tables to create dashboards…without remembering complex formulas, quickly and easily.
This program will show you more than 50 proven dashboard formulas templates so you don’t have to memorize complex syntax to create customized and highly interactive reports.
You know that once you set up formulas, they usually run without any effort, but we forget how they work when we finally need to change or fix something.
In this in-depth Excel coaching program you will discover amazing dashboard secrets, even many gurus never get it, such as…
- What are the secret formulas used in every dashboard and report
- Quick examples of functions for pulling almost any answer from your data
- How to pull all the data together or where you want it to! Even if the data is scattered across several books and sheets
- How to make complex formulas easy to remember and write
- Different ways of getting the answers with different methods
- How to extract data using several parameters and complex criteria
- How to optimize your spreadsheets performance. Proven techniques to avoid your formulas bring Excel to its knees
This program is for you if want to share information interactively and more efficiently in customized dashboards that better identify KPIs, trends, etc.; over a period of time or meeting complex criteria, to facilitate decision-making at the administrative level.
Limited-time Bonus 2 – “Pivot Tables Machine” Coaching Program ($297)
This program will show you how to automate the creation of Pivot Tables reports and dashboards using VBA.
Find inside the VBA fundamentals of Pivot Tables and actionable VBA Code to create Pivot Table reports and dashboards from scratch.
In this in-depth Excel coaching program you will discover amazing dashboard secrets, even many gurus never get it, such as…
- How to create a Pivot Table from scratch using VBA
- The exact VBA code to customize every aspect of your PT report
- How to interact with a Pivot Table. E.g. responding to user selections
- How to control every aspect of PTs using VBA
- How to refresh your PT reports automatically
- and so much more…
If you want to put your reports and dashboards creation on autopilot, then this advanced Pivot Tables program is for you.
Can I learn at my own pace or is there fixed schedule?
Watch the videos whenever and wherever you want. You can sign-in at any moment and from any device and start learning. Pause your learning and retake it later.
Is this course for me?
This course is for you if you work with large and structured data and want to get insights from it and present them.
Also, you should take this course if you have never tried Pivot Tables before, if you gave up learning PTs and want to understand Pivot Tables once for all, if you want to increase your understanding of the PTs fundamentals so you perform more advanced analysis and gain confidence to present your findings, if you are a consultant looking to get more solid at your skills so you can take new and better clients, etc.
Is the program online only?
You can watch videos online or download them to your computer or device. The content is yours. You decide how to watch the lessons.
To complete the course, how many hours/tutorials should I be viewing per week?
Each tutorial is like 30 min average. Each module/week has 5 lessons in average. So you would need something like 3 hours per week.
Are there exercises for each lesson?
Some lessons have some suggested activities. They are not assignments but ideas and inspiration to explore the concepts.
If I am not getting correct results, can I send my practice to someone for comments/review? Is help only available through email or is it possible to chat or talk to someone?
You can open a support ticket. You will get an answer by email in the next 24 hours.
Can I purchase the course for myself and my team?
Yes, you can purchase for multiple users and take advantage of my group discount. Please email me with the number of students and I can provide a discounted price: firstname.lastname@example.org