This is the fourth in a series of four books with the title of Excel Solutions for Accountants: written after a career in the world of accounting, education, and training: in which the author has seen first-hand what accountants know, what they think they know and what they don’t know. All accountants have gaps in their knowledge and skills: these books fill them. These four books contain graphs, formulas, and functions! With a step by step walk through of hundreds of cases and problems. What you will experience is our training and consultancy work: from one of the largest companies in the world to the individual cost accountant who was keen to learn more and more. NOTE: This is a BookBoon publication and you have to provide your email address to access it. The book is free for students, but all others only get it free for 30 days and requires a monthly subscription of $5.99 after that (as at Feb, 2021).
Type of Material:
Open (Access) Textbook (156 pages)
Recommended Uses:
Educational resource to be incorporated into classroom use in the form of in-class presentation/open discussion and homework assignments in the area of Accounting and Accounting Information Systems. Individual, very hands-on work with Excel examples.
Technical Requirements:
Internet browser – no need to download any software or plug-in.
Download book as PDF from this site
Identify Major Learning Goals:
To provide auditing educators/students with an entertaining way to integrate Excel functions and Accounting concepts in order to stimulate discussion and to develop related cognitive skills.
Use tools and functions in Excel to perform accounting and financial tasks: create graphs, calculate compound interest, forecasting, creating pivot tables, power query, using linear programming, etc.
Learn new and better ways to perform accounting and financial analysis
Target Student Population:
College students and accounting practitioners that are beginner to intermediate users of Excel.
Prerequisite Knowledge or Skills:
Introductory financial accounting course, 1st year business
MS Office Excel software
Content Quality
Rating:
Strengths:
Author provides audience with a very creative method of teaching Excel and Accounting concepts.
The eBook gives some good examples of how Excel functions, formulas and graphs can be used to present financial information in different or nonconventional ways. The ideas and tips provided are practical hands on advice for Excel users, providing good approaches to analysis and presentation of financial information.
Concerns:
While the specific examples in the eBook are fairly clear, the whole eBook was not that concise. There are a lot of pages of material and the learner has to skim through sections in order to find the content that is useful. It is difficult to follow in some of the examples because the data that was used is not available to the learner, or some of the references to external sites are broken.
Potential Effectiveness as a Teaching Tool
Rating:
Strengths:
Teachers and students could learn a lot in a short time about Excel and Accounting and at the same time develop practical critical thinking skills. Many of the examples provide useful knowledge related to formulas, graphs and functions that the beginner Excel user can use to produce accounting and financial information.
Concerns:
It is difficult to learn efficiently. Many of the examples depict the data and applicable graphs. It is time consuming to follow along and replicate the examples without the datasets. Also, in some instances, it is not entirely clear what the information produced can be used for, the author has left it up to the learner to figure out.
Ease of Use for Both Students and Faculty
Rating:
Strengths:
The author’s website and related educational resources are professionally done. Good instructions, good visuals and some ideas for presenting information in a nontraditional format.
Concerns:
Not that easy to follow along for practice. The datasets are not included for learners to try creating the graphs and using the functions.
Creative Commons:
Search by ISBN?
It looks like you have entered an ISBN number. Would you like to search using what you have
entered as an ISBN number?
Searching for Members?
You entered an email address. Would you like to search for members? Click Yes to continue. If no, materials will be displayed first. You can refine your search with the options on the left of the results page.
Searching for Members?
You entered an email address. Would you like to search for members? Click Yes to continue. If no, materials will be displayed first. You can refine your search with the options on the left of the results page.
