Pivot Tables interesting invention Story

Pivot Tables interesting invention Story

Pivot tables in excel are the very useful and powerful way for the person to analyze large datasheet. No special skills or mathematical brilliance are necessary, just the ability to click your mouse on right place. 

Pivot tables had developed by none other than Apple founder Steve Jobs. In 1985, Jobs was forced out of his duty as chairman of the board at Apple after failing to beat IBM in the business computer market. Fortunately, he was a stubborn man. 

Jobs started new company name Next.As he developed the NeXT computer, which would launch in 1988, Jobs was want to one killer software programs to create demand for the product. From his experience at Apple, he knew that a good spreadsheet program could drive sales demand.

 Jobs credited VisiCalc, the first widely used spreadsheet software, for the huge success of the Apple II computer, released in 1979.

In his search for that need-to-have product, Jobs met owner of software company Lotus. The organization had already developed Lotus 1-2-3, a popular spreadsheet program that ran on IBM computers. In this meetings Jobs would first stumble upon the “pivot table.”

Software developer Pito Salas was at the time working in research and development for Lotus, looking into how people typically utilize spreadsheets. Salas saw that users would often use spreadsheets to try to calculate summary statistics by categories.

Salas thinks the world needed software that would make those calculations simple. Rather than enter formulas, users would be able to point and click to get those summary statistics. The Lotus team called this tool “flexible views,” but today similar tools are called “pivot tables” in both Microsoft Excel and Google Sheets.

The Lotus team showed Jobs an early prototype. “Steve Jobs thought it was the coolest thing ever,” Salas, now a professor at Brandeis University, tells Quartz. Jobs then convinced Lotus to develop the pivot table software exclusively for the NeXT computer. The software came out as Lotus Improv, and though the NeXT computer was a commercial failure, Lotus Improv would be hugely influential. The “flexible views” aspect of Improv would be built into both Lotus 1-2-3 and Excel (the latter was the first to actually use the term “pivot table”).

Bill Jelen, Excel evangelist and co-author of Pivot Table Data Crunching, credits Salas as the “father of pivot tables.” Salas says his contribution to pivot tables is one of his life’s most gratifying accomplishments, though he believes he was just building on the foundations of many others.

Today, pivot tables are among the most important and commonly used tools in the spreadsheet wizard’s toolbox. “A pivot table lets you create a one-page summary report from hundreds of thousands of rows of data, often in four, five, or six clicks,” says Jelen. “It is the fastest way to get answers from large datasets.”

Pivot table, MS excel, computer software, excel 2007,office 7,steve jobs,computer world, window, Googlesheet pivot table, Microsoft pivot table, pito salas, 

It’s hard to know exactly how many people use Excel in their day-to-day work, but there are hundreds of millions of Excel users worldwide and it stands to reason that many have picked up the software’s most powerful tool. Pivot tables are generally listed at, or near, the top of lists of the most useful features in Excel. Data analysts use pivot tables to understand public health, economic growth and advertising effectiveness, among many other uses.  

“That’s my life,” says Justine Shakespeare, a senior program manager at nonprofit labor rights organization Verité. “All I do is make pivot tables.” In her case, the pivot tables are to analyze survey data from interviews with migrant workers in global supply chains. 

Here’s an example of the pivot table in action. Recently, a reporter at Quartz got access to data on remittances sent from the US to Mexico by month going back to 1995. But what the reporter really needed was a summary of the total remittances in the first six months of each year. Pivot tables were the way to go. Getting the numbers she needed involved inserting a pivot table, making a few selections to choose the data she needed, and filtering out the months she wanted to exclude.

Pivot table, MS excel, computer software, excel 2007,office 7,steve jobs,computer world, window, Googlesheet pivot table, Microsoft pivot table, pito salas,