Automated 20-80 Analysis in Excel – Add-In Demo

Automated 20-80 Analysis in Excel

Increase your productivity with an Automated 20-80 Analysis in Excel with this Smart Add-In for Microsoft Excel. Doing an Excel Pareto Analysis has never been so easy! Execute better, focus on data that really matters in just one click. The videos below show how to do Automated Excel Pareto Analysis in one click by using this cost-effective yet powerful Excel Pareto Analysis Add-In.

Add-In Demo #1 - Simple

Add-In Demo #2 - Advanced

Add-In Features

Automated 20-80 Analysis in Excel: Easy Add-In Demo 1


Compatible with all  Microsoft Excel versions from Excel 2013 to latest versions.

Automated 20-80 Analysis in Excel: Easy Add-In Demo 2


Filters out hidden rows or already filtered cells to focus only on what matters to you.

Automated 20-80 Analysis in Excel: Easy Add-In Demo 3


Auto-detect range, but if you are not happy with it, you can still select your own.

Automated 20-80 Analysis in Excel: Easy Add-In Demo 4


Unlike native Excel functions, non-numerical values and errors  such as #DIV/0, #N/A  etc are simply handled without drama.  It is not fussy! 

Automated 20-80 Analysis in Excel: Easy Add-In Demo 5


Pareto targets, value filtering,  cells colors... You set your own rules.

Automated 20-80 Analysis in Excel: Easy Add-In Demo 6

Free Updates

Buy once. Get updates for life.

Pareto Analysis Excel Add-In Related Questions

Why doing a Pareto Analysis?

A Pareto Analysis is a simple yet powerful process derived from the 20/80 rule that allows you to focus on what really matters, usually time or money.

A Pareto Analysis can be applied to various matters such as profit optimization, quality management (six sigma), decision-making process and other complex issues. You can also apply the Pareto Principle to your life!  Get happier and more fulfilled by prioritizing your highest-valued activities, tasks, and projects with a Pareto Analysis of your activities. 

Want to know more? Check the FAQ here

Why an Excel Pareto Analysis Add-In?

Doing a Pareto Analysis in an Excel spreadsheet is a simple yet powerful process.

However, this process can be lengthy and take several minutes. It is especially true when your Excel spreadsheet suffers from information overload. As an example, you may need to apply filters to define the dataset you want to draw a conclusion from, fix values such as #N/A or #DIV/0 generated by missing or erroneous data, etc...

This Pareto Add-In brings the benefits from automation in one-click:

  • Convenience
  • Time Savings
  • Reliability

Not convinced? Check the DEMO here!

How Easy is the Excel Add-In to install?

Installing the Pareto Analysis Add-In is a straight forward process and is no different than any other standard Excel Add-In. Check the video below for more details.

Pareto Analysis Excel Add-In

Buying the Pareto Analysis Excel Add-In is a risk-free experience. If you are not happy with it, you simply get your money back. No questions asked.

Execute Better.  Execute Faster. Automate any Excel Pareto Analysis.

I love this add-in. It is cheap and fast. What used to take several minutes several times a day, now takes seconds. Less manual work spent on Excel spreadsheets and more time for myself!

It goes straight to the point of what is relevant.

Mark Tran

Business Owner

I save time for my cost analysis by using this Excel add-in. It is a quick and effective way of highlighting the main cost drivers of my numerous projects across different areas.

My manager loves it.

Yuri Baldassarre

Engineering Project Manager

I love this stuff, Microsoft should make it a native Excel feature! I mainly use the Pareto Analysis add-in for quick data analysis in Excel.

Indran Doreswamy, MBA

Business and Strategy Project Manager

As a Financial Analyst, I am often asked  to find the main cost drivers of ever changing bill of materials and other large data-sets.

With this add-in, I can now provide answers to last minutes requests and on-the-go questions in seconds, it is like real-time instantaneous execution.

Charith Hewavitharana

Finance Analyst, Ford Motor Company of Australia

Nowadays, business is all about productivity.

I work in a fast-paced environment, and I increase my output on a daily basis with this Excel add-in. I do not waste time anymore cleaning data, fixing broken formulas and doing the boring math for my Pareto Analysis. It makes my life easier for my sales analysis.

Veronica Lomibao, CPA

Business Analyst

Excel Pareto Analysis Tutorial and more – Blog Content


Murphy’s Law: 1 Gloomy View On How Things Usually Turn Out

Murphy’s Law is the adage that “Anything that can go wrong will go wrong.” People give Murphy’s Law relevance when things go awry as a reason to why it happened

Laborit’s Law / Law of the Least Effort: 1 clear explanation

Laborit’s Law or the Law of Least Effort suggests that humans prefer to carry out simple tasks that give immediate satisfaction to avoid stress or inconvenience

Illich’s Law or Law of Diminishing Returns: 1 simple concept

Illich’s Law or Law of Diminishing Returns suggests that optimal productivity is reached with an appropriate balance between working time and resting time.

Parkinson’s Law – Why We work better with tight deadlines – 1 Explanation

What is Parkinson's Law? Parkinson's Law states that "Work expands to fill the time available for its completion." In short, the more time is allowed to complete a task, the more time this task will take. Parkinson's Law was first published in The Economist magazine, ...

Carlson’s Law: 1 Simple yet Powerful Productivity Concept

Carlson's Law is about the negative impact of involuntary breaks. Taking much-needed and deserved intentional breaks is one thing - getting involuntarily distracted is another. It is proven: interruption seriously wrecks productivity. "The difference between the...

Hofstadter’s Law and the Planning Fallacy

Hofstadter’s Law falls into the Planning Fallacy category by stating “It always takes longer than you expect, even when you take into account Hofstadter’s Law”.

How to build a Pareto Chart in Google Sheets in 2 Easy Steps

This easy step-by-step tutorial shows how to build a Pareto Chart in Google Sheets. Download now the Free Google Sheets Pareto Chart template for immediate use.

Best Microsoft Excel Guide Books – Top 3 for Data Analysis

These 3 Best Microsoft Excel Guide Books provide Excel users with Powerful Data & Business Analysis techniques that go beyond Pareto Analysis and Pareto Charts.

Optimize Easily your Well-being with the 80/20 rule Approach

Happiness, the feeling of positivity, really is the foundation of productivity. - Miguel McKelvey Everyone deserves to have a happy and fulfilled life. Take control now of your well-being by applying the simple yet powerful 20/80 Rule to your life. This article shows...

How to do a Pareto Analysis in Excel in 5 simple steps – Easy tutorial

This tutorial explains how to do a manual Pareto Analysis in Excel in 5 simple steps. A Pareto Analysis is particularly useful to focus on what really matters as the Pareto principle states that, for many events, roughly 80% of the effects come from 20% of the causes.

Pin It on Pinterest