Non-Fiction Books:

Microsoft Excel for Accountants 'part 2'

MS Excel for Accountants
Click to share your rating 0 ratings (0.0/5.0 average) Thanks for your vote!

Format:

Paperback / softback
$52.99 was $66.99
Available from supplier

The item is brand new and in-stock with one of our preferred suppliers. The item will ship from a Mighty Ape warehouse within the timeframe shown.

Usually ships in 3-4 weeks

Buy Now, Pay Later with:

Afterpay is available on orders $100 to $2000 Learn more

Availability

Delivering to:

Estimated arrival:

  • Around 11-21 June using International Courier

Description

The content of the book is designed to be useful for people who have previously used earlier versions of Excel and for people who are discovering Excel for the first time, and the Excel version used in this book is Excel 2016. In other words, this book will boost your proficiency in using Excel and also help you to understand Windows, the operating system in which Excel runs to enable you to manage files correctly and also to control your printers. The book also describes the analysis of financial data and figures, summarizing the raw data into the alternative perspective of the same source information. Taking up a profession as an accountant, you will need to have a detailed understanding of how to interpret figures and also how to communicate these to the non-financial members of the management team where you work. This book further broadens your knowledge about the 'new' information discovered. This book is designed to teach and equip you with the necessary Excel skills that will help you become a professional spreadsheet user.The book is split into five sections so that it can be easily accessible, they are: Section One: Financial Statements CoreIn section five of Part 1 of this book, we introduced financial statements and went on further to elaborate and explain how to create a balance sheet from our Trial Balance data. In this section, we will discuss how to create an income statement from the Trial Balance data and cash flow statement from the Balance Sheet. We will then end this section with how to create a note worksheet.Section Two: Analyzing Financial Statements and PowerPoint IntroductionThis section includes analyzing financial statements and also calculating the ratio analysis based on the financial statement created in Part 1 and 2. It will also teach us how to analyze data from the trial balance adjusted in Part 1 and present it in our profit center. Lastly, it will introduce us to PowerPoint presentations.Section Three: Presenting the InformationThis section reviews and explains the PowerPoint menus in detail for us to get familiar with the functionalities of PowerPoint. It will further enlighten us about the PowerPoint report structure. Finally, we will look at how we can use the PowerPoint report structure to give a wonderful presentation with the ultimate slide show. In Part 3, We will look at how to hyperlink between PowerPoint and Excel.Section Four: Whatsits AnalysisThis section introduces us to Whatsits analysis and also how we can present the whatsit model report to management through appropriate report structures. It will also introduce us to the historical data that we are going to be analyzed in Section Five.Section Five: Presenting the Historical DataThis section analyses and broaden our knowledge about how to present the information in tables and charts so that it can be used for quick decision making and also for future reference. We will also look at the second stage of how we can present the historical data in the form of a unit table and then finalize it in the third stage. The tables and charts in this section would be used to prepare our Excel Reporting Dashboard in Part 3.The audio video recording for this book can be found at https: //www.udemy.com/courses/search/?q=Microsoft%20Excel%20for%20accountants&src=sac&kw=microsoft%20excel%20for%20accountan
Release date Australia
January 18th, 2020
Audience
  • General (US: Trade)
Pages
252
Series
Dimensions
152x229x14
ISBN-13
9798600597136
Product ID
33433733

Customer reviews

Nobody has reviewed this product yet. You could be the first!

Write a Review

Marketplace listings

There are no Marketplace listings available for this product currently.
Already own it? Create a free listing and pay just 9% commission when it sells!

Sell Yours Here

Help & options

Filed under...