Author: Sikander Sultan
Publisher:
Published: 2017-07-15
Total Pages: 273
ISBN-13: 9781521852910
DOWNLOAD EBOOK →
Thinking of Mastering Excel 2016 for Accounting Career? Then you have landed in the right place.This book is about spreadsheets, and it has been designed to give users a step by step detailed approach to building professional spreadsheets from first design to well structured completed projects. If you're looking to prepare Management Accounts, Statement of Financial Performance, Statement of Financial Position, Statement of Changes in Equity, Cash Flow statement, Ratio Analysis, Forecasting, Budgeting, Variance Analysis, Investment Analysis, etc using Excel 2016; then this course is a goldmine for you.This book is structured to use as a learning and reference resource, it is written from the perspective of those who want to use the spreadsheet as a basis for analysing financial results, preparation of reports, making a detailed presentation on financial matters to the decision makers.After carefully studying the book and practising what you have learned in this book, you will be able to create financial statements with ease using Excel and also be enlightened about the extended functionalities in Excel 2016. This book is the final part of the series. The following areas will be learned and, one would acquire detailed knowledge after studying this part three of the series:* The basics of VBA Control Centre* How to analyse and create professional excel dashboard* How to use consolidation* How to hyperlink between PowerPoint and Excel* How to generate and analyse 'What If' Model* How to prepare advanced financial reports (Management accounts, income statement, balance sheet, cash flow statement) * How to present business reports and findings to the top management The subject of this book can be seen and used in real life situations, in the preparation of year end accounts, mid-end accounts, monthly management accounts, budgeting, forecasting, trend analysis, transactional analysis, M&A activities, internal and external auditing. All in all, this course is designed to equip you with the necessary Excel skills essentially becoming a professional spreadsheet user within a matter of few days.Master Excel skills to achieve greater work efficiency, surpass your peer group, impress your boss. Get the well-deserved job, bonus increment and pay rise!