Microsoft Excel for Accountants 'part 1'

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 properly and also to control your printers. The book also describes the analysis of financial data and figures, summarising the raw data into an 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: Windows and InformationThis section describes and evaluates the hardware components which are controlled by the operating system, introduces you to the hardware components that are very vital and needed in using the operating system. It will enlighten you more about the various Excel menus that are available. With the knowledge gained from these two chapters, we will be able to process data into information. This section stands as the foundation of this book and will help us accomplish the other tasks in the following chapters.Section Two: Excel Data and TablesThis section begins with the knowledge acquired from section one. It includes how to process Excel data into Excel information by using PivotTables. It will also give you insights on how to use filters and slicers. Finally, it will broaden your knowledge about data tables and how to use conditional formatting.Section Three: Reports and ChartingThis section reviews and explains how to use solvers and scenarios, with appropriate profit and loss examples. It will also teach you how to chart data and familiarize you with the charting toolbars. In the next section, we will look at more awesome features of charting.Section Four: Forecasting and Financial StatementsThis section further broadens our knowledge about charting and maps, based on the tutorial of the previous section. It will also enlighten us more about the forecasting tools that are available to us in Excel. Finally, it will introduce us to financial statements with Excel which will be of utmost help to us in section five of Part 1, and both section one and two in Part 2.Section Five: Trial Balance and Balance SheetThis section covers and teaches you how to adjust the trial balance from a random pool of data, and how to update the data in the trial balance. The trial balance created in this section will be used to prepare a balance sheet in this section, and an income & cash flow statement in Part 2.The audio video recordings for this book can be found at https: //www.udemy.com/courses/search/?q=Microsoft%20Excel%20for%20accountants&src=sac&kw=microsoft%20excel%20for%20accountants