Startling fact: Even Journalists Use PivotTables Now To Quickly Find The Crucial Information That Are In Big Tables, Who Never Thought They Could
“Who Else Wants To Discover How To Go From Hours To Create The Customized Report You Just Need, To Coming Up With Several Ones In Minutes, And Still Have Time To Find Surprises In The Data, Or To Curiously Explore Every New Table You Stumble Upon? – Even If You Work With Intimidating Tables”
“Know What Every Top Data Analyst, Consultant, And Manager Ought To Know About PivotTables”
Wednesday, 10 AM.
From: John Franco, Excel author
Dear Excel User,
It seems incredible that just learning one Excel feature (PivotTables) can give you almost absolute power and control over big tables and dashboarding!
People discover the magic PivotTables can do, when their “two and a half days” report is done in minutes (without typing any lookup formula or copying and pasting), or when they suddenly start perceiving big data as manageable and enjoyable!
You know that almost everyone in the office and industry is sort of possessed talking about PivotTables and everyone seems to love PTs!
PivotTables users are so excited because they are now big-data ready. In a sense, PivotTable users are new-economy ready.
Producing reports in minutes (not in days) is crucial because that’s the speed of business today.
The PivotTable is the ultimate data success tool and is easy to understand. Yet many data analysts, managers, and consultants find PivotTables hard to learn and use.
The reason why so many are struggling with PivotTables is simple…
…Excel has wired us to think in a way that makes almost impossible to truly master PivotTables.
We are conditioned to thinking in term of tables but PivotTables hate tables.
The same way we do in business, PivotTables always work with objects of the real world, not with tables.
It’s not your fault :(
This is a habit created by Microsoft.
That’s the first thing you must know about Pivot Tables.
Let me give you an example…
You have a Teacher table, a Students table, and a Courses table. But the only thing that is real is that there are students who take a course, which is taught by a teacher.
Student 1, Teacher 2, Math
Student 3, Teacher 2, Grammar
Every student is complete. If you work with complete objects and actually think in objects, you are on the right path to winning the data analysis game.
Thinking in objects is the data philosophy that will make you successful with PivotTables.
Keep reading please…
…because in a moment I will share with you a comprehensive roadmap to master PivotTables from the ground up.
Many people out there are afraid because they are getting results by chance. That’s not professional becaues if you are caught out, your reputation will be severely harmed.
If you have always wanted to become a master of PivotTables to win the data analysis and presentation game, but the superficial how-to explanations have always prevented you from getting started, then this is an important message you must read.
Why Pivot Tables are important
You already think Pivot Tables is the technology to 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…
…because you have heard enough from your peers highlighting the power it brings to their data analysis game, or you have seen Pivot Tables used in spreadsheets and can see they reveal all the secrets that are in the data (and without typing any single vlookup, sumif formula, etc., neither investing in costly bi solutions nor coding complex macros).
I also thought PivotTables were amazing but I felt a novice because I found the data pivoting concepts daunting and was unable to figure out how to use all the many options or prepare the data and create impressive reports.
Before I learned how the Pivot Tables technology truly worked, I was intimidated by colossal files of $300+ million Civil Engineering projects. And the crucial data that was in my hands to make or support major business decisions, was like a closed book. The secret relationships inside the data never leap to my attention. I wanted to open the book.
But I fear tables no more.
I am now able to fully understand and use PivotTables to win the data analysis game and I can show you why PivotTables are not complicated…
Why PivotTables are learnable
Many professionals think PivotTables are not learnable because few people seem to understand them. The data pivoting concepts seem daunting. There are way too many options, they are too complex and the report creation technique seems is not a repeatable process.
Those who get it are seen as having a special gift or insight that led them to understand PivotTables.
Nothing is further than truth…
…it’s interesting how asking the wrong question can lead us to never try something.
Asking, “are PivotTables 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 PivotTables are a thing they cannot learn because they see it as a thing, not as a verb. If you make PivotTables 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 PivotTables. 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 learning PivotTables is that you stop focusing on the damn PivotTable as a monstrous entity and start focusing on the details that make it work.
Why are journalists taking PivotTables classes?
It’s interesting but a fact…
Journalists are taking Pivot Tables classes!
I stumbled upon a journalism report from a Harvard University foundation dedicated to elevating the standards of journalism, where a journalist shared his view of his craft and how he took PivotTables classes to advance his career. At one point, he says, “I hoped to finally push past this pivot table business and learn how to draw useful information out of databases…”
Committed journalists are learning PivotTables to researching corruption cases, national budgets, baseball players’ salaries, etc.
They need to understand.
As professionals and leaders, they analyze 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 PivotTables should be in your toolbox.
…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. Yes, you need to spend time explaining to your colleagues how the spreadsheet works.
And 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.
What PivotTables can do for you…
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 or if you provide insights to the upper management team.
And because being insightful realizes you.
We all crave for clarity, foresight, and wisdom. And a PivotTable is our crystal ball!!!
People who use PivotTables 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 PivotTables…
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, create impressive reports in minutes.
If you gain PivotTables knowledge, you will get a promotion, get a new and better job or start your own consulting firm.
Another crucial reason why every data analyst, manager, and consultant should learn PivotTables now…
There’s no question you need the so-called BI capabilities. But many forget two important facts…
Fact 1: The PivotTable is a BI tool!
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?
The PivotTable paradigm is the core of the innovative Excel BI features.
Actually, if you learn PivotTables, 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 PivotTables is because they give them total control over the analysis process.
How I discovered and understood Pivot Tables and why you can master PTs too…
I discovered PivotTables like you…
…Everyone in the office 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 PivotTables out. During the first years, I managed to get impressive 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 PivotTables 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 PivotTables.
And this is great news!
I’ve taken every tip, trick, technique and philosophy that I’ve learned from successfully using PivotTables to create customized reports from large data, and put them in a comprehensive Excel coaching program.
Here’s how you can learn PivotTables using simple language and analogies anyone can understand…
This Could Be You !
Announcing my new Excel Coaching Program!
A 7-week PivotTables Mastery Blueprint
This program shows data analysts, managers, and consultants, how to completely understand and use Pivot Tables for instantly finding and presenting the information they need.
This comprehensive online course walks you through PivotTables 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 PivotTable 7-week roadmap, 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 PivotTables in minimum time by learning the fundamentals. If you master the PivotTables 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 and impressive reports they want. Gain knowledge of the fine PivotTables points such as cube and cache technology, the difference between Excel and PivotTables, the 2 types of data fields and how to use them (all tables have them but none of them reveal them), the 7 new PivotTables 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.
What makes this course different?
Most professionals find the data pivoting concepts daunting and this is so because they have never focused on the fundamentals before operating this complex tool.
Here, you will get insights and information way beyond the how-to trick that only works for one situation.
Here you will learn the fundamental principles that empower you to face any situation, whether you work in accounting, HR, IT, retailing, health, education, engineering or any other industry. And you will find the practical HOW-TO guidance also.
Are you going to learn Pivot Tables from the right master?
I am very well known in the Excel community 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+
- Intermediate Excel level
- And a desire to get started
Who is this course for?
This comprehensive PivotTables online course is for you if you…
- Never created a PT before and want to get started with PivotTables in the right way
- Want to upgrade your PT skills and knowledge
- Deal with big data and your reports take too much time and effort to create
- Are looking for a new job and want to add value to your career profile putting PivotTables on your resume with total confidence
This PivotTables coaching program covers it all…
This 7+ hour training program will show about everything from scratch to create any varied and customized report you might need.
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.
What you need to do next…
- Order your Master Of PivotTables 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?
PivotTables is not a quantum physics experiment. 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.
Learning PivotTables is worth the effort but it can take months, even years to discover how to use the tool in any situation, especially if you rely on Google and YouTube because they give you only bits of information but never the whole picture.
Or you can take advantage of the 10+ years John’s already invested in hard work dealing with big tables and PivotTables, researching and synthesizing 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…
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, some of 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 PivotTables 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 Master Of PivotTables video lessons, practice at your own pace, and cannot understand and use PivotTables 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 PivotTables 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).
Bonus 3 – “Pivot Tables Machine” Coaching Program ($197)
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: email@example.com