Real-Life Business Case Study Scenarios
EzyLearn has been developing its own software training courses since 1996. Our training course materials include:
- step-by-step workbooks,
- exercise files,
- educational demonstration videos, and
- knowledge review tests.
We are continuously adding content to our courses, using the ‘Micro Courses Concept’ (or, in other words, case studies).
Case studies give you a relevant way of learning that is specifically linked to real-life, real-time situations — based on real people. Below are some of our micro courses and where to find them. We can alert you when we add new micro course products — simply subscribe to our blog.
Investing in a Granny Flat (for Intermediate Excel)
With the Australian property market having gone gangbusters for almost an entire generation now, many people are exploring the option of adding a granny flat to their properties. Regional areas like Newcastle and Wollongong still have plenty of house and land opportunities that lend themselves to building a second dwelling on an existing block.
Sometimes a granny flat is built to house a relative (the proverbial ‘granny’ flat) but just as often they are constructed to be used as an investment to reap a higher income return from an existing property. Our new “Investing in a Granny Flat” Micro Course is designed to give you the tools to work out the total costs, estimated return, and even expenses and tax aspects like depreciation, so you can make an educated financial calculation and decision.
Wipe Thousands Off Your Mortgage (for Advanced Excel)
Deposits, repayments, principal and interest are some terms most of us speak about often, or at least when we are managing the mortgage on our home or investment properties, or other debts.
We have created the micro course “Wipe Thousands Off Your Mortgage” that provides loan payment formulas that are included in Microsoft Excel and how, with a little discipline and good use of your earnings or wages, you can save thousands in interest expenses — more than double, in fact, than you have to spend.
This micro course is available as part of our Microsoft Excel Advanced Course.
Ad Hoc Payroll (for MYOB, Xero and Excel)
A ‘Micro Business’ is another name used for independent contractors who work by themselves, or with a business helper. These business often don’t follow regular payroll processing procedures because their cash flow and payment needs can be inconsistent.
We have created an “Ad Hoc Payroll” Micro Course which demonstrates how PAYG, Super and other payroll transactions can be managed with the use of Microsoft Excel spreadsheets rather than with complicated accounting software packages and their payroll modules.
Reconciling Bank Statements for a Messy Startup
We’ve created a typical start up scenario of a person who has left the corporate world because they want to start working closer to home and choose their own work hours. We’v included some directors loans, wages payments and some other activities that are not common or normal in an established business.
This case study was created to give students experience in creating journal entries and understanding what to look for when it comes to asset purchases, depreciation and transactions that contain different components of GST.
This micro course is used in the Xero Bank Reconciliation and Journal Entries (Course 513).
Use Microsoft Excel PivotTables and PivotCharts to schedule rooms and staff
In 2004 (yes EzyLearn has been operating since 1996), we operated & managed physical computer training centres in Lane Cove, Dee Why, Gordon, Chatswood and Parramatta and we had thousands of students enrolling into lots of different courses and at different times of the day/night and our CEO wanted to know which were the most popular.
Steve created the training schedule each quarter to allocate training rooms, trainers, training resources like workbooks, floppy disks (yes that’s what we used back then) and Tim Tams. Our most popular courses back then were:
- MYOB on Saturdays,
- Microsoft Excel in the evenings, and
- Absolute Beginners, File Management and using Email and Web Browsers during the day!
In our Microsoft Excel Advanced Training Course we use the actual live data of enrolments for 2004 (removed any student names and details of course!) and go through a number of different exercises to demonstrate how we made executive strategic decisions about the business based on historical data and using Pivot Tables and Pivot charts in Microsoft Excel.
Corporate Employee & Small Business Owner
Meet Jerry and join his journey as he builds up his first and subsequent businesses. We base his experiences on real life work, business and every day scenarios as we update our course content and integrate our highly popular software accounting courses with business start up ones.
Micro Courses in Development
Xero Course: Quarterly Reporting, Cashflow, Budgets and Strategic Decisions
Based on the transactions in our Xero Bank Reconciliations course we follow our Corporate Executive come small business owner as he navigates the world of small business. We use financial information to see what can be improved, what needs to change and what is doing very well. We look at mistakes made about funding larger capital purchases and some of the other options available to Jerry as well as other ways to improve cash flow and budgets to help run a smoother business next quarter.
Releasing Equity in your Home Loan Mortgage
Using some real life examples from the Newcastle Property Market we demonstrate how property owners in Sydney, Brisbane and Melbourne can use the recent increase in their homes to release equity and use that to borrow to buy an investment property in a regional area like Newcastle where you can still by a house and land, do subdivions, add granny flats, perform renovations and get a great solid return on your equity.
Subscribe to be Alerted
Do you want to be notified when we release a new business case study in one of our courses? Subscribe to our blog.