The mother of all Excel offers!

“Who Else Wants To Gain The Fundamental Excel Knowledge To Save Time, Avoid Effort, Work Smarter, Make Money, etc., Without Investing Years Of Research & Study And Trial And Error, And Without Paying A Fortune In Excel Training?”

“Liberated! An Excel Expert’s Library Of Insider Techniques And Insights To TAKE Your Excel Skills And Career To The Next Level”

Dear Excel friend,

This is some of the “insider” Excel techniques and wisdom I wish were around when I was starting out with data earlier in my career. Learning even one or two of these Excel concepts would have short-cut my success by… oh… five… maybe five years. Probably more.

If you want to gain the fundamental Excel knowledge that will increase job satisfaction, make you more valuable at your office and be considered for the next promotion, or put with confidence on your resume, the fundamental skills such as VBA, dashboarding, PivotTables, etc., to get a better job, then read every word of this page…

…because here you can get a magic shortcut to becoming an Excel Expert.

In fact, you are going to discover more Excel techniques and knowledge you actually need.

WARNING: This package contains so much information that can be overwhelming for many. Don’t get this if you don’t have some time set for going through this program. Even the wait for downloading the material can be painful. And this is not for everyone because the Excel techniques should be put into practice to actually benefit from them. If you are the kind of person who implements, then this is the most important message you will ever read…

And here’s why…

…after working for 8 years for the biggest construction company in Latin America, I decided to share with the Excel community some of the Excel secrets I used to get a promotion over a promotion and that gave me Excel guru status in the office and gained me the respect of peers and bosses.

I decided to package all my Excel books, videos, checklists, blueprints, workbooks, etc., into a convenient Excel bundle you can access immediately.

And without paying a fortune in Excel training!

Announcing…

The Wizdoh Excel Bundle

A comprehensive library of Excel wisdom and techniques to definitely master Excel VBA and macros, dashboards, PivotTables, Data preparation, lookup formulas, and more.

 

Excel-bundle_big

This complete Excel resource is perfect if you want to have a reference library of insider Excel secrets you can access at any time.

“Just downloaded 1.3 GB of your tutorials. Wow!”

Just downloaded 1.3 GB of your tutorials. Wow!…Still, your Excel teachings are the most developed & logical of any I’ve experienced or tried.

Hope I can go straight thru them this time & grow from a medium expertise in Excel to mastery, with your help.”

Gary Williams
USA

“You have give me all the tools I could possibly ever ask for!”

Hi John,

Let me simply state that this has been an incredible purchase and I thank you very much for it. I have downloaded most the material and need to figure out where to begin. I have opened many of the supporting files and docs, and have watched several of the videos. I could not be more pleased!

I have not had a chance to view the entire course, but I have very much enjoyed what I have seen so far. I am extremely have with my purchase. You have give me all the tools I could possibly ever ask for!

I hope that many others took advantage of your generous offer, and that you and your family achieve your goals.

Regards

Joel”

Joel Bernstein

These are the 12 Excel programs you get:

Program 1: How To Write Excel Macros From Scratch Online Video program

6-week roadmap to Excel VBA mastery so you add a WOW productivity factor to your work, designing, writing and running your own macros

producto-combo

This is the “insider” VBA course John wishes was around when he was starting out with macros earlier in his career. Learning even one or two of these VBA concepts would have short-cut his own success by… oh… five… maybe five years. Probably more.

Included in this in-depth 11+hours of macros training are VBA concepts many Excel users never get it… such as:

  • Understand Excel VBA once for all with intuitive, friendly and jargon-free explanations that just make sense. This course is written by an Excel user for Excel users not for developers). Learn programming using simple language you can understand. For example, understand algorithms using a friendly monkey, the object model using an analogy that involves trees and fishes :). Explain these complex concepts to your coworkers and boss with total confidence.
  • Connect the dots about how Excel VBA works by starting from the most basic fundamentals (programming background). Understand algorithms, the pillar programming concept, which regular Excel VBA training programs assume you already know. This new knowledge will build up you confidence to complete New and Challenging assignments
  • Fully understand Excel VBA language so you write programming expressions you computer understands. Analogies with English are used extensively, so you see VBA is not that complicated. No more trial and error to get a macro that gets the job done. Get rid of your limitations due to your limited VBA knowledge, make sense of err messages as you write and avoid errors from the ground up
  • How to create Excel Macros that work for variable size arrays and sheets. Learn how to iterate through cells, rows and columns in your sheets. Learn how to use loops that literally think and know where to start and when to stop processing information. And use this knowledge to process big spreadsheets with a mouse click!
  • How to find the best solution and the syntax for your macros. When you implement flowcharting right, you become a professional who always knows which is the best way to start your macros, how to find the VBA code and structure of simple to complex VBA macro projects (even at an enterprise level). You also increase your confidence to tackle bigger automation projects because your planning and design skills will make macros simple to write and read (decreasing debugging time and effort). This is another critical concept regular Excel VBA training programs assume you already know. When you gain this knowledge, you will design your own macros to reduce workload to almost half and will become a valuable asset for your company
  • How to code common Excel routines like: how to work with ranges, how to work with sheets and workbooks, etc. Code templates provided!
  • Know the main VBA functions you can use. List of main available functions provided! so you know instantly which functions exist
  • How to communicate with other applications using VBA: Access, Word, Outlook, PowerPoint, etc. Code templates provided! Gain Prestige creating powerful applications such as one that prepares the weekly presentation out of many Excel workbooks, or another one that creates contracts in Microsoft Word out of Excel tables
  • How to find the full syntax of VBA expressions to control any aspect of Excel objects: Charts, Pivot Tables, Sheets, Workbooks, etc. A one-line template is provided that works with every object of Excel. It’s something like fill in the blank template. Speed up the time to complete a job and do it minutes because you will be able to write simple lines of VBA code that do tens of boring tasks for you. Don’t work late anymore
  • Demystify the scary Excel Object model using a simple analogy that makes perfect sense. This knowledge is critical to know the full VBA syntax of your automation instructions. Also, download the object model organized in a friendly mind map, so you have the big picture of all Excel VBA objects you can use and how to access to them. Be Praised And Admired by your coworkers and boss who still don’t get it
  • Easy VBA examples so you see how the concepts are implemented in real situations.
  • And much more…

If you still think learning VBA is too hard to learn, I understand you are skeptical…

I am not exaggerating when I say that my VBA explanations use real language anybody can understand, because I am well-known in this industry as the Excel guy who puts it in simple terms. See the raving and unsolicited testimonials above.

This Excel VBA program is designed for non-programmers, just like you. I don’t assume you already know some programming concept and so I take you to Excel mastery from the ground up.

I enjoy the way the information is presented in the lessons. Very easy to understand unlike most of the material I have found on VBA programming.

Anita McLain | Student, Cleveland, Ohio

Dear John…Really you are fascinating and have an explanation method that is highly attractive. Your approach impressed me because it hits the point directly…

Emad T | Student

Hi John, The presentation and content get better with each tutorial. I am finally beginning to understand VBA. Well done, keep up the good work.

Alan Smith | Student

This is definitely a great course with lots of good examples; the analogies used are very much nearer to the normal life

Srinivaskalyan | Student, India

Dear Dr.John Great presentation for this tutorial (How to manipulate Excel objects – parentheses mine). Frankly, i have read many books about VBA and could not feel that i really got the meaning of the presented concepts. Your way of presenting these concepts were amazing. Thanks a lot for this great help

Emad T | Student

Dear John, …I want you to know how blessed I am meeting someone like you with this craft of yours…!Its really helpful and easy to understand. Nothing more to say, Ill keep this for life and share to my colleagues…

Wish you the best of everything through the years to come. Muchas Gracias.

Garry Pasan | Student

Explanation is awesome. This course is perfect for “non-programmers”. Thanks John

Vinod Gupta | Student, Hyderabad – India

Hi John, I am really enjoying your course so far. I can’t believe how much content is in just Week 2. So much to learn….

Kim Cook | Student

I have personally reviewed the program which is designed in a way to learn VBA quickly and easiest manner. The best part is the step by step approach and numerous examples and videos which is very important for a beginner. The learning from this program will definitely improve your productivity and efficiency at work.

Ayush Jain | Microsoft MVP 2010

Very simple, clear explanations of VBA lessons. You are a good Professor. I think you will be a famous person in the future. I haven’t seen like these explanations before, it’s very good

thank you

thank you

thank you

thank you

thank you

thank youuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuu John Franco

Mohamed | Student

Structured and friendly Excel VBA Macros video training program…

Week 1 – “Flow” module: will teach you everything about how Excel VBA works. The lessons of week 1 will demystify Excel VBA so you will perceive that Excel VBA is not that complicated. Here are some of the lessons:

  • How Excel VBA works
  • What the Excel VBA components are and how they work together
  • and much more…

Week 2 – “Language” module: will teach you everything about the VBA syntax. The lessons of week 2 will empower you to write your first macros. You will make sense of terms. Your VBA background will be strengthened here. Here are some of the lessons:

  • How to speak the VBA language
  • What are the main Excel VB functions and statements
  • Why you need to use variables and how to work with them
  • How to manipulate Excel objects (Introduction)
  • and much more…

Week 3 – “Objects” module: will teach you everything about object oriented programming and Excel VBA objects syntax. The lessons of week 3 will empower you to understand the Excel object hierarchy and to write the full syntax of objects. Here are some of the lessons:

  • What is an object & Excel Object Model revealed
  • How to manipulate Excel objects (In depth)
  • How to work with the Range object
  • How to integrate forms into your macros
  • How to work with another application’s objects
  • and much more…

Week 4 – “Where” module: will teach you everything about where the writing/debugging/support tools are located in the Excel VBA editor. The lessons of week 4 will empower you to use the VBA design environment with confidence and comfort. Here are some of the lessons:

  • How to use the VBA writing tools
  • How to use the VBA debugging tools
  • And much more…

Week 5 – “Flowchart” module: will teach you everything about designing the logic of macros. The lessons of week 5 will empower you to use programming diagrams called flowcharts for any kind of problem you might have. Here are some of the lessons:

  • Introducing the most important programming concept: the algorithm
  • What is a flowchart and why to use one
  • How to diagram decision and loop structures, Function and Sub procedures
  • and much more…

Week 6 – “Write” module: will teach you everything about writing the code of your macros. The lessons of week 6 will empower you to write macros professionally! This is where it ALL comes together! Here are some of the lessons:

  • VBA code writing productivity tips
  • How to code common Excel routines (how to iterate through cells and sheets, how to work with arrays, how to write Excel custom functions (UDFs), etc)
  • and much more…

Comes with Excel VBA practice and support files…

  • Put hands on the VBA code and learn by doing
  • Download Excel files and explore the macros as you want
  • Make copies to the original files and tweak the code to explore how the code works
  • Adapt the code to your own purposes and projects
  • Download pdf reports with concepts expanded
  • And much more…

Program 2: How To Pull Specific Information From Excel Tables Using VLOOKUP and INDEX & MATCH formulas

Step by step guidance to set up and troubleshoot lookup formulas.

PullSpecificInformationFrom

Included in this in-depth and easy-to-follow guide are secrets most Excel users never discover… such as:

  • How to understand and remember VLOOKUP and INDEX and MATCH syntax and how to write them like a pro. Develop an intuitive way to look at the lookup arguments that just sticks, even if you don’t use these formulas often. Develop the confidence and right frame of mind to use VLOOKUP and INDEX and MATCH in a broad range of data scenarios, from pulling data to moving data between sheets
  • How to prepare the data before using VLOOKUP and INDEX and MATCH so you trust the results you get and can send crucial reports with total confidence to upper management or customers. If you want to stand out from the data newbies crowd, this data quality skill will make you a trusted data professional
  • How to systematically setup the VLOOKUP and INDEX and MATCH formulas so you trust the results you get, even if you get the infamous #N/As (sometimes they are right). No more trial and error to find the sources of errors like #N/A and #VALUE. No more frustration when you get unexpected error results because now you know exactly where to look at to locate the error. Detailed lookup implementation checklist provided
  • You will learn the SPECIFIC situations where you can use these formulas in. Learn how to lookup texts, dates and numbers, what types of tables are not suitable for VLOOKUP, what kind of tables are not suitable to lookup formulas (avoid dealing with duplicate results). Increase your confidence to deal with challenging data scenarios
  • How to troubleshoot lookup problems. This is specially helpful when you have data and reports from other sources. Learn how to find and fix non-matching errors (#N/A) and other typical errors as well (#REF!, #VALUE). Learn how to diagnose and solve typical problems like extra spaces, numbers stored as texts, weird and undetectable characters, etc. You will never ever be in the dark and doubt anymore when you don’t get a matching. Checklist provided so you always deliver results, even if you face challenging data projects
  • Step by step instructions to make multiple column/criteria VLOOKUP and INDEX and MATCH formulas. This is specially helpful when you want to get a match by more than one column, for example, if first name and last name are in separate columns
  • See closely how lookup formulas work in real scenarios using the practice files. Secretly put your hands on done-for-you lookup files where you can explore how these concepts are put into practice

…and much more!

“I must say that this is very valuable content. I have used many Excel tutorial books when I was starting off but yours is leagues above.
I never thought that somebody could give the Lookup function so much thought and studied it so much in depth. We could definitely benefit from your mega work.

What I like best in your book is the language; I really like the free flow expression of ideas through practical and easy to relate to illustrations…”

Abhishek Raju | Lead Researcher at Indian Institute of Management | Bangalore Area, India

“I wanted to say…Thank-you for such a beneficial, enjoyable and teaching style for conveying this lookup material. After completing this program I finally completed a 10 year quest in understanding Excel data management. I was so excited in connecting the dots that I could not pull myself away from the data manipulation of some old databases for the last 72 hours.

Thank-you for a quality product.”

Phil Egan | Corpus Christi, Texas

Program 3: How To Write Excel Macros From Scratch Guide

6-week roadmap to Excel VBA mastery so you add a WOW productivity factor to your work, designing, writing and running your own macros

How To Write Excel Macros From Scratch

Greatest Gold-Mine of Proven “Excel lookup training” Ever Crammed Into One Excel Program…

Win Acclaim implementing these core techniques (200+ pages with step by step guidance, detailed illustrations and practice files)…

Section I – Lookup Syntax Mastery

  • Why you use tables
  • Why you use lookup in Excel tables?
  • VLOOKUP syntax demystified
  • INDEX & MATCH syntax demystified
  • Multiple criteria syntax
  • Syntax of big formulas
  • How to gain experience with VLOOKUP and INDEX & MATCH formulas
  • Main differences between VLOOKUP and INDEX & MATCH
  • VLOOKUP and INDEX & MATCH limitations
  • VLOOKUP and INDEX & MATCH advantages
  • The 10 most typical lookup mistakes

Section II – Table Set Up

  • What’s an Excel table
  • How can lookup formulas use information from different tables
  • The 10 don’ts to consider when using Excel tables
  • The 10 dos to consider when using Excel tables
  • Typical dirty data scenarios
  • How to detect and fix dirty data
  • How to cross check if your data is ready for searches
  • How do you get the same results using several mediums

Section III – Troubleshooting

  • Lookup troubleshooting introduction
  • The psychology of non-matching problems (#N/As)
  • How to get a perfect match?
  • Preventing/troubleshooting unconvincing #N/A messages
  • Common lookup errors to look for
  • Interpreting genuine #N/A messages
  • How can you replace a #N/A value by a meaningful message?
  • How to diagnose and fix other lookup messages

And much more…

Important: this program includes practice files compatible with Excel 2003 and later versions.

Program 4: Understanding Pivot Tables Mechanics

Learn The Paradigm Behind Fields Dragging-And-Dropping To Create The Reports You Have In Mind, Get New Patterns And Answers On Purpose, And To Understand The Reports Created By Others

Included in this in-depth manual are secrets most Excel users never discover… such as:

  • Learn which are the right datasets for using in Pivot Tables. When you know this simple fields-differentiation, you will know instantly which tables are suitable for PT data mining and which not. You can even advice others when they are trying to do PTs with the wrong datasets
  • Understand how the fields are arranged to create the reports you want. Know how the order of fields affects your reports. Know what data formats can be pivoted and how to arrange the hierarchies as you want. And impress your boss with your consistent results, no matter the assignments you are required to do
  • Step by step and fully illustrated explanations to understand exactly what will show up in a Pivot Table (no more trial-and-error to get what you want). You can paint creatively in the PT canvas what you have in mind. I explain everything using the grocery analogy and plain language you can understand. You will be able to teach PTs to those who are still struggling and establish your PT guru reputation
  • Find new and fresh insights from your data by using the singular Pivot Tables paradigm to the fullest. Present your findings in your reports and meetings. Also publish this in your resume “I can convey meaning from complex data” and you will get a better job
  • How to perform 5 well-known data mining tasks. I explain this using real examples. Create a new sense of possibilities in data exploration and understanding
  • And much more…

I worked through the first half of the book last night. What has really helped me is the point you make about the data items in the raw data being either Categories or Data. As soon as I thought about it, that made sense of a lot of my past experiences with PTs.…

And having the spreadsheet to play with, to try things out, has been great. It is much richer in Categories than anything I might have created for myself, and so makes it easier for me to see patterns emerging as I tick successive boxes on the right-hand side.

Many thanks for a good booklet.

Chris Reynolds | IT Support Officer, Student

Win Acclaim implementing Pivot Tables now…

What’s inside…

  • Chapter 1 – How Pivot Tables fields work (pivot table paradigm)
  • Chapter 2 – The right dataset for your Pivot Tables reports
  • Chapter 3 – The 3 secret Pivot Tables fields rules
  • Chapter 4 – How to organize your Pivot Tables fields to perform advanced data mining

And you also get my unpublished Pivot Table videos that will help you fully understand the mechanics of Pivot Tables for ABSOLUTELY FREE! (50+ minutes of teaching)

  • Demystifying Pivot Tables (part 1 and 2)
  • Example 1: Adventures Store Sales (+ Excel practice file)
  • Example 2: Office Supplies (+ Excel practice file)
  • Example 3: World population (+ Excel practice file)
  • How to create a Pivot Table report from scratch
  • How to preserve the PT report format between updates

Important: this program includes practice files compatible with Excel 2007 and later versions.

Program 5: How To Create Dynamic And Interactive Excel Dashboards

More than 30 step-by-step and fully explained techniques, for setup, presenting data and giving the user the ability to “adjust” the data they are viewing.

Included in this in-depth and easy-to-follow guide are secrets most Excel users never discover… such as:

  • More than 30 step-by-step and illustrated explanations (with commented practice Excel files) that will empower you to learn a new dashboard technique literally in minutes. Implement any new technique while you read, with easy to follow explanations. You have the ability to focus on the techniques that matter to you until you fully implement them. Your coworkers will think you have a private dashboard coach teaching you these secrets
  • How to present the data you want to users, implementing friendly controls: option buttons, check boxes, scroll bars, etc. Become popular among decision makers when they start feeling special customizing the reports as they want
  • How to pull data at once using common functions as VLOOKUP, INDEX & MATCH. If you have not mastered these functions yet, you will also get an intuitive explanation of how these formulas work. Empower people to have real time access to database information in Excel (without using complicated database connections)
  • Know how to limit data entry and so avoid report crashing and learn how to do it in several ways: using data validation, protecting your sheets, etc. Don’t be afraid anymore that your reports will crash in the hands of end-users
  • Learn how to animate charts simply with dynamic datasets (no need of macros. Only lookups). These techniques will set you apart from the horde of people who use Excel as a plain spreadsheet
  • Avoid using these techniques in the wrong scenarios by knowing the main pitfalls of each technique
  • How to create movie animations using simple VBA code (VBA template provided). This technique will set you apart from the majority of Excel users who only know rudimentary animation techniques
  • Obtain general ideas of initial design & setup
  • Learn how to create a great user-experience, giving the user the ability to adjust the data they are viewing. Build truly interactive and friendly dashboards users can literally change on the fly. Learn how to change charts, pivot tables, Excel on the go, just by pressing friendly buttons. I provide VBA code templates to make this easier
  • Prevent users crash your reports by protecting the key areas of your dashboards. Have peace of mind your reports will work as expected no matter the degree of heavy use they are exposed to
  • And much more…

I Love you John Franco, you make me a master at Excel.

Nipun | Subscriber

Dear John…Really you are fascinating and have an explanation method that is highly attractive. Your approach impressed me because it hits the point directly…

Emad T | Student

You bring to light useful functions/methods/approaches otherwise unknown to a significant portion of Excel users.

Anonymous | Excel subscriber during a survey

This is definitely a great course with lots of good examples; the analogies used are very much nearer to the normal life

Srinivaskalyan | Student

As A teacher I loved your simple creative ways of explaining complex subjects, it was through your teaching I learned so much more and in turn shared with my students. To this day I use your rules about designing a good table. I always enjoyed your teaching style and I am thrilled to know you have returned to Excel.

Debra | Student

Dear John, …I want you to know how blessed I am meeting someone like you with this craft of yours…!Its really helpful and easy to understand. Nothing more to say, Ill keep this for life and share to my colleagues… Wish you the best of everything through the years to come. Muchas Gracias.

Garry Pasan | Student

Fantastic explanation with easy to learn description of complex Excel formulas with clear examples and screen shots/files.

Anonymous | Excel subscriber during a survey

Greatest Gold-Mine of Proven “Dashboard Techniques” Ever Crammed Into One Excel Program…

Win Acclaim implementing these core techniques (fully explained with step by step guidance and illustrations)…

How to keep your dashboard title prominent and up to date – Dynamic Headings

  • Technique # 1.How to create a dynamic heading
  • Technique # 2.How to create a dynamic Chart caption

How to pull data at once – Dynamic datasets

  • Technique # 3. How to pull datasets using VLOOKUPS
  • Technique # 4. How to pull datasets using HLOOKUPS
  • Technique # 5. How to pull datasets using INDEX & MATCH (single)
  • Technique # 6. How to pull datasets using INDEX & MATCH (multiple)
  • Technique # 7. How to pull summarized datasets using Pivot Tables
  • Technique # 8. How to pull summarized datasets using Subtotal functions (SUMIF, COUNTIF, etc.)
  • Technique # 9. How to pull Pivot Table datasets for powerful charts
  • Technique # 10. How to filter Chart datasets
  • Technique # 11. How to pull multiple-matching data
  • Technique # 12. How to filter Chart items
  • Technique # 13. How to change the Chart source array dynamically

How to empower dashboard users without crashing your dashboards – Dynamic inputs

  • Technique # 14. How to set up an input cell
  • Technique # 15. How to format Input cells
  • Technique # 16. How to protect output cells
  • Technique # 17. How to set up controlled cells
  • Technique # 18. How to pick categories from a drop down list
  • Technique # 19. How to pick categories from a list
  • Technique # 20. How to increment values gradually
  • Technique # 21. How to make a single choice
  • Technique # 22. How to make multiple choices
  • Technique # 23. How to choose a date from a date picker
  • Technique # 24. How to present graphical aids for Inputs and outputs

How to keep users up to date – Dynamic outputs

  • Technique # 25. How to format outputs
  • Technique # 26. How to trap mistakes in cells
  • Technique # 27. How to present messages on Excel Shapes
  • Technique # 28. How to create a cartoon animation
  • Technique # 29. How to create a movie animation
  • Technique # 30. How to create a Chart animation
  • Technique # 31. How to create a gauge using Excel charts
  • Technique # 32. How to create a thermometer using a simple Bar chart
  • Technique # 33. How to show information in a Popup

How to edit your dashboard on the fly – Dynamic setup

  • Technique # 34. How to set up a Chart remotely
  • Technique # 35. How to set up a Pivot Table remotely
  • Technique # 36. How to set up a Table remotely
  • Technique # 37. How to set up the look and feel of Excel remotely

General techniques

  • Technique # 38. How to organize your dashboard content into tabs
  • Technique # 39. How to create a Static TOC
  • Technique # 40. How to create a Dynamic TOC
  • Technique # 41. How to change the Zoom level
  • Technique # 42. How to lock the position and content of controls
  • Technique # 43. How to change the look and feel of Excel

And much more…

Important: this program includes practice files compatible with Excel 2007 and later versions.

Program 6: How to Design Excel Dashboards

5 fundamentals to present data creatively, meaningfully, beautifully and professionally

How to Design Excel Dashboards

Thanks for highlighting the core thinking behind creating management reports. Sometimes we are involved with technical parts and miss out the management point of view. Thanks again for sharing such a thought. Regards

Kamal | “How to Design Dashboards” Student

Hi John, I just bought your dashboards course. It looks very good and a new innovative way to view things!!

Rob R. | “How to Design Dashboards” Student

Enjoying dashboards so far, I love the way you are breaking things down and getting my brain working and improving my thought process.

Rob R. (again) | “How to Design Dashboards” Student

You can get it absolutely for free when you get my “How To Build Dynamic And Interactive Dashboards” program TODAY.

This easy-to-follow guide will show you:

  • The 5 fundamentals to present data creatively, meaningfully, beautifully and professionally
  • Step by step design framework to build any dashboard project without unnecessary rework and making decision makers love and use your dashboards
  • Learn how to lay out your dashboards professionally: know how to present data to upper management, know how to choose colors, fonts, etc, know how to layout your reports so users are engaged, know what data to present and what data to omit (avoiding embarrassment with upper management people), know the elements that go on every professional dashboard
  • Know 3 single questions you should ask before you create any dashboard. If you don’t ask these questions you will be never be taken seriously by managers and decision-makers. This simple technique also empowers you to please different managers and users
  • Know how to grab dashboard users attention. Know where to put the data in relation to the charts. Learn what data to highlight, what data to hide. And convert your managers into addict users of your dashboards
  • Obtain general ideas of initial design & setup
  • Present data in a way that decision makers love. Know how to identify their motives and present exactly what they want. Contribute to the bottom line of your organization, helping decision makers to understand data, track, analyze, forecast, etc major business functions. Help identify problems and opportunities in your business. Inform managers about business performance
  • Establish your professional leadership with improved communication/reporting skills. Enhance your reputation as a data presentation expert
  • And much more…

Program 7: How to Extract Information from Excel Tables

50+ Dashboard Formula Templates That Will Pull Almost Any Answer From Your Data

If you don’t have at your fingertips the many options available to extract data, and would like to discover how to extract information from Excel tables, to answer unusual end-users questions and to create customized reports for you and for your manager, I can show you exactly how to do it quickly and easily.

In fact, I am going to reveal more done-for-you lookup formulas than you will ever need.

 

Jonh’s Toolbox for Excel Lookups is a very useful book for people working with data using Excel. The book details several scenarios of Lookup using Vlookup, Index & Match in great detail. The language is simple to understand and easy to follow.

My personal experience with Lookup formulas is that learning to use Vlookup can change the way you look at your data related problems. I get tremendous productivity in my work by using the right Lookup tricks.

I recommend reading this book if you work a lot with data and tables.

Chandoo | Chandoo.org

You get 50+ dashboard formula templates that will show you how to pull out single items from tables using simple and complex criteria (using VLOOKUP, INDEX & MATCH, Array Formulas), how to pull out summarized values from tables (using COUNTIF, SUMIF, AVERAGEIF, COUNTIFS, SUMIFS, AVERAGEIFS, Array Formulas), how to pull arrays using VLOOKUP, INDEX & MATCH, Array Formulas.

You will also find a new and simpler way of understanding the arguments so you don’t need to remember the syntax every time. You will also learn the fundamental principles of looking up.

Everything revealed in pdf format (137 pages).

This easy-to-follow guide will show you:

  • How to easily implement a VLOOKUP successfully (free of unwanted #N/A errors) with a step by step proven checklist and expert “best practice” guidance
  • How to implement the 10 magical Excel lookup/data formulas that will pull almost any answer from your Excel list: VLOOKUP, INDEX and MATCH, SUMPRODUCT, Array Formulas, COUNTIF, COUNTIFS, SUMIF, SUMIFS, AVERAGEIF and AVERAGEIFS – 45 scenarios are provided
  • Write advanced lookup/data Excel formulas quickly and easily by adapting any of the 50+ dashboard formulas scenarios provided to you
  • …and much more

This guide also comes with 50+ sample Excel files so you can get some real hands on experience!

Yes! If you order today, you will also get 50+ Excel templates files, with the exact content of the book so you can easily follow along and implement the concepts.

If you are the kind of person that need to see things in action to understand and get started, then here you will find joy in seeing all the dashboard formulas in use and being able to actually play with them.

Program 8: Pivot Table Data Success Blueprint

The Secrets Of High-Quality PivotTable Data And Reliable Reporting And Dashboarding

WARNING: The PivotTable Is An Amazing And Powerful Tool, But Can Only Be Used To Its Full Potential If The Source Data Is In The Right Structure. If Data Isn’t Normalized And Consolidated (And Cleaned), It Makes It Incredibly Difficult To Analyze It As A Single Dataset

If you want to stop pulling your hair trying to take full advantage of the PivotTables power because your data is never in the right format, then this is the most important message you will ever read…

…because I will share the secret psychology of perfect data and proven data preparation techniques to get your data in the best format for PivotTables.

In fact, I am going to reveal more data preparation techniques than you will ever need.

It’s well known that everyone is working with larger data sets from multiple sources (and players). Data collecting and storing is at its peak. It can be a challenge to put everything together.

And the sad truth is that data travels a lot, and in that handling process, ends up corrupted and needs to be cleaned. It explodes across several sheets or workbooks, and you know the different datasets are related but you don’t know how to put everything together into a single table.

And this is also a startling fact…

…people never produce data for PivotTables. Excel, neither other programs have an “export for PivotTable” command.

To make things worst, you and I know that there’s no even a picture of how the perfect dataset looks like. And because only a few know the right data structure, almost nobody cares about exporting data in the special layout that is needed for PivotTables.

Learn how to consistently get your data in the best quality and format for PivotTables even if it’s poor quality or spread over different sheets and files.

This is a proven step by step PivotTable data preparation blueprint!

Read what others say about my PivotTable Data Success Blueprint…

“WOW, the introduction- you are so right. The objects explanation is a masterpiece. “

“I read carefully the PivotTable Data Success Blueprint – WOW, the introduction- you are so right. The objects explanation is a masterpiece.

You are right in your Objects explanation. To think and understand about the goal of the report / the query that one received and to build the solution (the table that is the source to the PT) accordingly. One need to understand what is his main object and to build and organize the data around it.

As to the ways to approach the problem – obviously, if it is a one-time occasion, the manual appending and using the vlookup and then a pivot table is much faster. However, if the pupils’ attribution to an organic class and/or field of interest is dynamic, then using the Power Query is the chosen one. I still do not understand why I failed to import the 5 classes files to the PQ using “From Folder”, I had to load them one after the other the whole 5, doing the same 5 times.

In general, since I was a “Lotus 1-2-3-“ beginner, I was taught to think in tables, and the importance of data normalization. Therefore, whenever I see data, I start thinking of how to organize it in order to have the best PT out of it. So when I got the “5 teachers files” I knew that I need to gather it to one DB, and wanted to play with the new Power Query tool. Since I’m not that skilled with PQ, I faced some know-how barriers and your PT data success blueprint helped me with them.

I must say that in Israel there are many Excel Experts and some companies that teach Excel (for beginners, advanced, VBA etc) but I didn’t find any one with an approach like yours or Oz.”

Lior D.
Accountant, Finance manager
Israel

The best thing about a system is that it’s REPEATABLE. You can use this data preparation system every time, and consistently get your data ready for PivotTables.

Find inside secrets many Data Analysts and professionals never get it such as…

  • Discover the secret data psychology to look at data in a simplified way. With this simplified way to look at data (even at the most complex datasets), you will never again suffer for not having the different tables together because you will be able to easily uncover the underlying structure of your data even if you work with big tables or data is spread over different sheets and files
  • Know how a perfect dataset looks like. Find inside a clear picture of a table featuring the main elements of a perfect dataset. Visualizing the special layout of your data is key to getting it in the right structure for PivotTables. You will also develop the skill to ask for the right dataset. You can also send the pdf so others produce the data in the desired format
  • Discover the 4 possible scenarios every dataset fits in. This is, in fact, a comprehensive data success roadmap that will show you every possible scenario and how to solve them. You can use this data success blueprint to tackle complex data scenarios others are scary even to think about. And learn the concepts using rich illustrations and simple explanations
  • Learn how to merge tables from different sources using several methods such as lookup formulas, Power Query, etc.
  • Learn how to perform data cleaning using formulas, filtering, Power Query, and other proven tricks and techniques. Be among the 1% elite professionals and data analysts who are up to date with the latest technology such as Power Query. Put Power Query skills on your resume and get a better job or be considered for a promotion
  • and much more…

Program 9: PivotTables Domination

How to completely understand and use PTs for better data analysis and presentation

It seems incredible that just learning one Excel feature (Pivot Tables) can give you almost absolute power and control over big tables and dashboarding!

Yet many data analysts, managers, and consultants find Pivot Tables hard to learn and use.

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.

This Could Be You !

“I’m not frighted of pivot tables anymore!!!!”

“My main role involves working with an MS Access Database, and exporting details from that via queries/reports to spreadsheets for distribution to various sections of our company.

However, I have recently taken on producing a dashboard for our team, which is shared with government as well as the business! At the moment the dashboard is made up of lots of worksheets which produce tables on a “Dashboard” worksheet. There is a lot of work manipulating the data to produce an easily readable, meaningful and understandable dashboard for varying levels of management.

The Pivot Tables Seminar has given me lots of ideas of how the dashboard can be better produced, and hopefully be more dynamic rather than a monthly task! I’m not a data analyst but find manipulating the data on a dashboard to be fun (as far as work is!).
I will continue to follow your seminars, and have learnt a lot – I’m not frighted of pivot tables anymore!!!!
I find your training extremely useful and helpful, thank you”

Lesley F. | UK

“Categories and Data has been my big step forward.”

I worked through the first half of one of the videos last night… What has really helped me is the point you make about the data items in the raw data being either Categories or Data. As soon as I thought about it, that made sense of a lot of my past experiences with PTs.

Obviously, my learning style is such that I need to “see” a pattern or organization in the data structure. “Categories and Data” slotted straight into that need. The box, fruit, and vegetables didn’t help me at all, but then I knew that idea of sorting and grouping from previous work on PTs in a past existence. But horses for courses, Categories and Data has been my big step forward.

And having the spreadsheet to play with, to try things out, has been great. It is much richer in Categories than anything I might have created for myself, and so makes it easier for me to see patterns emerging as I tick successive boxes on the right-hand side.

Many thanks for a good program.

Regards,”

Chris Reynolds | IT Support Officer

“…a different insight I am thankful for”
“That was a different insight I am thankful for. It does underline the difference between excel and pivot tables. The hist video is indeed an anchor for every user”
Jan D.

 —

“…You have opened my eyes.”
“Thank you, John. You have opened my eyes.”
James Gibbons.

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.

Program 10: How To Create and Modify Excel Charts Using VBA

A gallery of VBA code to change the look-and-feel and functioning of Excel charts

HowToCreateChartsVBA_3dcover

This easy-to-follow Excel VBA guide will show you:

  • How to change the look-and-feel of your Charts using VBA, chart element by chart element: Series, Plot area , Up/down bars, Axis: horizontal/vertical axis (category), horizontal/vertical axis (value), Chart area, Gridlines, Legend, Trendline, Chart title, Data table, Data labels
  • How to create Excel Charts with one click
  • A Gallery Of Charts VBA code to change every aspect of any chart
  • …and much more

This guide also comes with a macro sample Excel file so you can get some real hands on experience!

Program 11: How To Create, Setup And Format Pivot Tables Using VBA

Actionable VBA code to develop Pivot Table report applications

How To Create, Setup And Format Pivot Tables Using VBA

This easy-to-follow Excel VBA guide will show you:

  • How to create Excel Pivot Tables with one click. Comes with A Gallery Of Pivot Tables VBA code to change every aspect of any PT report
  • How to change the look-and-feel of your Pivot Tables using VBA, element by chart element: Row fields, Column Fields, Page Fields, Value fields. Impress your boss with Pivot Tables applications
  • …and much more

This guide also comes with a macro sample Excel file so you can get some real hands on experience!

Program 12: Simple Macro Writing System (SMWS)

The art and science of developing operational Excel macros

This is a complete system covering all aspects of writing a macro such as naming your macro, version control, finding the full syntax of your macros, debugging, distributing your macros for maximum use and impact, etc. My SMWS home study program is a complete step by step system that will make your macros almost magically write themselves, to get the job done and be much ahead of deadlines.

“I like your formalized structure for macro writing…”

I like your formalized structure for macro writing. I have done some of my own macros but it has always been more seat of the pants development.

Jeff B. | Student

Get turn-by-turn directions along your macro development journey!

Here’s what this Simple Macro Writing System will do for you (in just 3 hours of learning)…

  • Get started before you are ready using proven macro templates and psychology that will help you make progress despite the doubts, lack of knowledge, lack of time, lack of confidence, etc. You can use these macro templates to name your macros, to lay out your macros, etc. Turn chaos into order and stagnation into movement. See progress in the macro development work right from the start
  • Discover how to think like a developer and find code alternatives to choose from. This practical developer mindset is part of the DNA of the SMWS program and will get you more macros written that you will ever need.
  • Discover the 5 basic building blocks of every operational macro that you need to put together if you want to ensure the best use of your valuable time (blueprint provided). This is a blueprint you can follow to create operational Excel macros in minimum time. This structure will also help you make your macros more manageable (never again abandon a project due to the fear of complexity and viability). Create structured macros that are scalable, reusable and easy to integrate into other projects and workbooks
  • Develop the confidence to accomplish bigger tasks that will make your boss consider you for a promotion, get a better job or start your own lucrative Excel VBA consulting firm or freelance career
  • Also, discover how to design a macro blueprint that you and your clients will immediately understand. No more wasted time trying to remember how your macros work or trying to explain to others how your macros work. Don’t be lost in the dark in the middle of VBA code of in-progress Excel macros
  • How to structure a macro in a way that you can keep evolving it, easily control the versions, etc. You never have time to write a full macro in one sitting, so with this macro blueprint, you can retake your projects where you left them because you have a consistent structure that guides you and you always know that the macro was originally intended for.
  • Learn how to break down big projects into manageable pieces so they are easier to develop and maintain (simple macro structure templates provided). If you have old Excel macros you have spent lot of time coding but never became operational, you can bring them back to live by adding some structure to it
  • Learn how to make your macros dynamic so you code only once for permanent use by you and others even if your macros face different spreadsheet sizes and situations
  • Leverage your Excel VBA code across ALL your macros (not just one) because you develop a solid structure that is shared by all your macros and projects. Develop a library of macros you can use to automate the operation of your business and organization or to start a consulting VBA firm
  • How to avoid a macro monster that you will abandon using a simple debugging tip
  • How to make your macros accessible to you and others. Learn how to anchor your macros to Excel buttons, shortcuts, ribbon, etc. right on the boss’s and customers’ desktops
  • Improve recorded macros. Use the macro blueprints and templates to remove unnecessary code and add structure to your recorded macros
  • Learn how to rewrite your macros for simplicity and change
  • Adapt others’ macros to your style
  • And much more

Here’s how to get started!

You might be able to figure it all out on your own. Eventually.

Or you can take advantage of the 10+ years John’s already invested in hard work, researching, even meditating on the Excel fundamentals, testing and implementing Excel techniques.

There is absolutely no sane reason why you should want to waste years of your own life attempting to cover this same trial-and-error ground.

The Excel knowledge is scattered through books, forums, and blogs and synthesizing that information requires lots of work and motivation. You might spend months and end up with partial knowledge because gurus don’t have time to mentor you along the way and usually they don’t expose everything they know.

If you can get a better job or a promotion with these in-demand data skills, the price of this bundle is ridiculous.

If get the programs separately, you would pay USD1500+.

If you attend several crowded Excel seminars to cover ALL these topics, you would pay $5000, and pay extra for the travel and hotel expenses. And seriously, you won’t cover what is covered here. And you won’t have rich material to study after the training is gone.

If you act now, you get access to The “Excel Bundle” program and bonuses for only…

USD 397

This includes private access to the Download Area where you can download your guides, practice files, checklists, bonuses and updates for 12 months, and email support for 6 months.

You can download everything to your computer and study at your own pace.

If you want to get exactly the information you need in just a few minutes of time, then you can learn one technique at a time, at your own pace because the information is structured in a way so that  you can learn each technique independently, so you don’t miss anything if you go in any order.

If you’re serious about getting started on Excel macros, lookups, Pivot Tables, Dashboards, go ahead and click the button below.

Click Here To Get Access To An Excel Guru’s Library Of Wisdom And Proven Techniques

(or click here to pay 99 today and take advantage of my 4 easy installments payment option)

Delivered instantly in PDF, mp4 and xlsx format, via a download page.

If you have any question about this product, contact us.

ccbadge

60-day-money-back-guarantee

You risk nothing

If within 60 days of purchase, you follow the program lessons, do the homework and cannot implement these techniques to build interactive and dynamic Excel dashboards, create your own macros from scratch, extract information from tables using VLOOKUP and INDEX&MATCH, preparing, analyzing and presenting data using Pivot Tables, and more, or if you simply didn’t like the material, just ask a refund and you will get your money back, no questions asked.

I have been selling information products online since 2011 to thousands of professionals from around the world.

Just contact us (use the subject “refund”). Will take care of it.

Still not sure? Check out the common questions.

FAQ

I am interested in taking the course. Would you please let me know payment options?

You can pay using a credit card: Visa, Mastercard, Diners Club, American Express, Discover, JCB, and also using Paypal.

Payments are securely processed through ClickBank, a US company with 200 million of customers worldwide.

What happens if I don’t like the material or if it’s too advanced/basic for me?

Don’t risk a penny. You are covered by my unconditional money-back guarantee. If you don’t like the material, you just send me an email (subject: Refund) and I will issue a refund immediately.

Can I download the videos also?

Yes, you can download everything, pdf guides, Excel practice files, and mp4 videos. Everything is conveniently set up in a single download page so you save time and start learning ASAP.

I would like to know which version of Excel is used in the VBA training videos and the dashboard program?

Excel 2007+

I shall say that most of what I cover here are fundamentals, common to all versions.

How is the course structured, is it on demand or at set times?

You can download everything and read or watch everything whenever and wherever you want. The guides and videos take you step by step from the basics to the most advanced concepts.

Thanks!

jf-email-signature

 

 

 

 

Disclaimer:


ClickBank is the retailer of products on this site. CLICKBANK® is a registered trademark of Click Sales, Inc., a Delaware corporation located at 917 S. Lusk Street, Suite 200, Boise Idaho, 83706, USA and used by permission. ClickBank’s role as retailer does not constitute an endorsement, approval or review of these products or any claim, statement or opinion used in promotion of these products.