AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
Excel pivot table tutorial1/23/2024 ![]() ![]() Excel 97 included a new and improved PivotTable Wizard, the ability to create calculated fields, and new pivot cache objects that allow developers to write Visual Basic for Applications macros to create and modify pivot tables.Microsoft further improved this feature in later versions of Excel: Early in 1994 Microsoft Excel 5 brought a new functionality called a "PivotTable" to market. In 1993 the Microsoft Windows version of Improv appeared. Borland purchased the DataPivot technology in 1992 and implemented it in their own spreadsheet application, Quattro Pro. A few months after the release of Improv, Brio Technology published a standalone Macintosh implementation, called DataPivot (with technology eventually patented in 1999). Lotus Development released Improv in 1991 on the NeXT platform. ![]() This core functionality would provide the model for pivot tables. With Improv, users could define and store sets of categories, then change views by dragging category names with the mouse. A tool that could help the user recognize these patterns would help to build advanced data models quickly. While working on a concept for a new program that would eventually become Lotus Improv, Salas noted that spreadsheets have patterns of data. In their book Pivot Table Data Crunching, Bill Jelen and Mike Alexander refer to Pito Salas as the "father of pivot tables". A pivot table is an outcome of statistically processing on a tabularized raw data and can be used for decision making.Īlthough pivot table is a generic term, Microsoft held a trademark on the term in the United States from 1994 to 2020. The aggregations or summaries on the groups of the individual terms might include sums, averages, counts, or other statistics. For cross-tabulation that aggregates only by counting (rather than summing, averaging, etc.), see Contingency table.Ī pivot table is a table of values which are aggregations of groups of individual values of a more extensive table (such as from a database, spreadsheet, or business intelligence program) within one or more discrete categories. ![]()
0 Comments
Read More
Leave a Reply. |