In the last blog post, we have introduced PivotTables as a powerful analytical tool in Excel to manipulate large amounts of data into decision-useful reports. Microsoft introduced an enhanced PivotTable tool called PowerPivot that is available as an add-in for Excel 2010 and 2013. The PowerPivot add-in is now able to process even larger amounts of data, from internal and external sources, to create dashboards that even work online, moving PivotTables to the cloud. This website provides an introduction and working examples of the PowerPivot add-in.
Home » Ch 10 - decision support with spreadsheet software » PowerPivot – more analytical power in Excel
PowerPivot – more analytical power in Excel
Recent Posts
Archives
- May 2018
- October 2017
- September 2017
- August 2017
- July 2017
- June 2017
- December 2016
- November 2016
- October 2016
- September 2016
- August 2016
- July 2016
- June 2016
- May 2016
- April 2016
- March 2016
- February 2016
- January 2016
- December 2015
- November 2015
- October 2015
- September 2015
- August 2015
- July 2015
- June 2015
- May 2015
- April 2015
- March 2015
- February 2015
- January 2015
- December 2014
- November 2014
- October 2014
- September 2014
- August 2014
- July 2014
- June 2014
- May 2014
- April 2014
- January 2014
Categories
- Ch 1 – introduction to information systems and accounting.
- Ch 10 – decision support with spreadsheet software
- Ch 2 – basic terminology and concepts
- Ch 3 – the role and development of IS in accounting
- Ch 4 – Accounting information systems change and development
- Ch 5 – Enterprise systems
- Ch 6 – integrating information systems
- Ch 7 – XBRL
- Ch 8 – accounting software for smaller business
- Ch 9 – software-as-a-service
- Uncategorized
Latest Posts
-
Some useful Excel links collected from the Internet
In my second-year undergraduate Management Accounting course, we spend a few weeks on learning the ins and outs of Excel. However, learning and improving on…
-
Mini-series Part 3: Digitalization and the accountant
In the first two parts of this mini-series, I discussed the definitions of (Part 1) and role of AIS (Part 2) in digitization and digitalization.…
-
Mini-series Part 2: Digitization, digitalization and AIS
In the second part of this mini-series on digitization and digitalization, I would like to highlight the connection between digitization, digitalization and accounting information systems…
-
Mini-series Part 1: Definition of digitization and digitalization
In the next three posts on this blog, I would like to introduce the topic of digitization/digitilization, and the effects on accounting and accountants. If…
Business information systems for accounting students 