Here is a link to a very useful exercise on the Excel INDEX and MATCH functions. These functions are useful for looking up data in spreadsheets.
Home » Ch 10 - decision support with spreadsheet software » Excel tips – INDEX and MATCH
Excel tips – INDEX and MATCH
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 