MICROSOFT EXCEL FOR ACCOUNTANTS 'PART THREE'

  • 0.0
1 hour on-demand video
$ 12.99

Brief Introduction

Learn how to create the VBA control center, a beautiful dashboard, how to analyse the What If Model & use consolidation

Description

The content of this video is designed to be useful for people who have previously used earlier versions of Excel & Powerpoint and for people who are discovering Excel & Powerpoint for the first time. In other words, this videos will boost your proficiency in using Excel and also make you understand Windows, the operating system in which Excel runs in order to enable you to manage files in a proper way and also to control your printers.

The video also contains the analysis of financial data and figures, summarising 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 such to the non-financial members of the management team where you work. This video 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.

Requirements

  • Requirements
  • You should have gone through the Part 1 and 2 of Microsoft Excel for Accountants so that you can get more understanding

Knowledge

  • Learn how to create the VBA Control Center
  • Learn how to analyse and create professional excel dashboard
  • Learn how to use consolidation
  • Learn how to hyperlink between PowerPoint and Excel
  • Learn how to generate and analyse ‘What If’ Model
  • Learn how to present reports to top management
  • Learn how to analyze historical data in Excel
  • Learn how to create an Excel Reporting Dashboard
  • Learn how to beautify your Dashboard
  • Learn how to create a sales dashboard
  • Learn how to create a marketing dashboard
  • Learn how to create a finance dashboard
$ 12.99
English
Available now
1 hour on-demand video
Olawunmi Daniel Balogun
Udemy
Share
Saved Course list
Cancel
Get Course Update
Computer Courses