Editor’s Note: All newly updated in July 2024…
This excellent set of spreadsheets was created by Duncan Williamson back in 2000 for Biz/Ed, which was an excellent site but is not defunct (you can still find it and the original spreadsheets on the Internet Archive). He recently got in a nostalgic mood I think and saw that I had referenced his earlier work, which he had thought was lost to history. After that, he decided to update the original spreadsheets and he created a couple of new ones to discuss Dynamic Array Functions, which didn’t exist until somewhat recently. Finally, he also created a PDF workbook from the original notes.
At this Google Drive link, you will find eleven MS Excel files that offer introductions to various business topics along with illustrations of how a spreadsheet can be used to work with those topics. Spreadsheets include:
- Tasker: Introduction to balance sheet and income statement (covers basics of financial accounting)
- Markups and margins (discusses different ways to measure profit)
- Gearing (looks at different forms of financing; gearing is the relationship between long-term capital and capital employed)
- Depreciation (gives overview to concept and discusses different methods)
- Cost analysis (looks at analyzing the costs of an organization)
- Cost volume profit analysis (further develops cost analysis module and applies its principles in a variety of settings – includes break-even, margin of safety and profit volume)
- Budgeting (master budget exercise looking at cash budget, income statement, and balance sheet)
- Elasticity (looks at elasticities of demand, income, cross, advertising, and supply)
- Profit maximisation (focused on economist’s view of costs, revenue, and production opportunities but does offer some contrasts with accountant’s view)
- Dynamic Array Function (covering RANDARRAY, UNIQUE, SEQUENCE, SORT, SORTBY, and FILTER). There is a student’s copy and a teacher’s copy.
I have also downloaded all the files from the Google Drive link and combined them together in one ZIP file which you can download below.
Author: Duncan Williamson
Source: biz/ed
Subjects: Education, Finance, Free Stuff / Tools, Productivity / Work Tips
Click to See or Add Your Own »
Highly recommended download