Sunrise Pharmaceuticals Pty Ltd: A Computerised Accounting Practice Set Using MYOB Accountright Version 19
Sunrise Pharmaceuticals Pty Ltd is a computerised practice set using MYOB AccountRight Plus V19. This practice set is designed to provide experience in recording a variety of business transactions common to business, so that students will gain an understanding of a computerised accounting system, how it operates, how to set up a data file and enter opening balances, how to record transactions, and how to produce useful reports. This ?hands-on? methodology reinforces the students? understanding of accounting fundamentals typically encountered in practice, and is therefore, suitable for students undertaking a course in accounting or computer-based accounting information systems. Completion of the practice set for a one month period, should ensure a greater appreciation of the following: * The steps in a typical accounting cycle for a small business * The use of subsidiary ledgers * The perpetual inventory system * Balance day adjustments * The bank account reconciliation * How the accounting cycle culminates in the preparation of financial statements * How GST is recorded and the effect it has on transactions * The variety of source documents, and * How to extract information from source documents to record transactions Systems Requirements For Windows 7: Windows Vista (service Pack 2) or Windows XP (Service Pack 3) For Mac: Mac OS X 10.4 or later
Out of stock
About the Author
Michael Alexander is a Microsoft Certified Application Developer (MCAD) and author of several books on Microsoft Access and Excel. He has more than 15 years experience consulting and developing Office solutions and has been named a Microsoft MVP for his ongoing contributions to the Excel community.
Excel University Volume 3 – Featuring Excel 2013 for Windows: Microsoft Excel Training for CPAs and Accounting Professionals
The third installment in the Excel University series picks up right where Volume 2 leaves off. In the final exercise of Volume 2, we created a formula-based report that required several features and functions. In Volume 3, we build that same report without writing a single formula. We create it with the PivotTable feature. The first section of this volume covers PivotTable basics and concludes with a comparison between formula-based and PivotTable reports. The second section explores various report layout and design options that enable us to replace our formula-based reports with PivotTables when appropriate. In the final section, we consider the reporting process, including efficient ways to get data into our workbooks, how to prepare the data for use, and how to summarize it graphically with PivotCharts and other Excel features. Excel practice files and solutions videos are available online so you can work hands-on as you read through the content. The skills developed in this volume will help you get your work done in less time.
About the Author
Stephen L. Nelson is an author and CPA who provides accounting, business advisory, tax planning, and tax preparation services to small businesses. He is the author of more than 100 books, including QuickBooks For Dummies and Quicken For Dummies .
Excel University Volume 2 – Featuring Excel 2010 for Windows: Microsoft Excel Training for CPAs and Accounting Professionals
Building on the firm foundation established in the first volume, the second installment in the Excel University series continues to explore the Excel features, functions and techniques relevant to accounting and finance professionals. Volume 2 focuses on how to automate recurring-use reports. Amounts in hands-free reports update the instant updated data is inserted into the workbook, for example, when an updated trial balance is pasted into the data sheet. This volume covers the Excel items needed to build and automate reports, including lookups, dynamic headers, mapping tables, error trapping, conditional summing, and date related functions. Excel practice files and solutions videos are available online so you can work hands-on as you read through the content. The skills developed in this volume will help you get your work done in less time.
About the Author
Author of Excel University In his live CPE training sessions, Jeff Lenning CPA CITP has shown thousands of CPAs and accounting professionals across the country how to use Excel to streamline their work and become more efficient. Several publications have featured his Excel articles, including the Journal of Accountancy and California CPA Magazine. Highlights After graduating from the University of Southern California, Jeff began his career in the audit practice at Arthur Andersen’s Orange County office. He was a senior financial analyst at Gateway computers and the accounting manager at Interpore Cross International. In 2000, he founded Click Consulting Inc., a technology-consulting firm that specializes in Excel training, consulting, development, and personal coaching. Professional Involvement He is a past president of the CalCPA OCLB Chapter, the former chair of the California CPA State Technology Committee, co-chair of the California CPA OCLB Chapter Technology Committee, and an instructor for the AICPA and the California CPA Education Foundation. A Microsoft Office Certified Excel Expert, he is a nationally recognized trainer.