Microsoft Excel For Accountants Part 2

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