Microsoft Office Excel was designed to support accounting functions such as budgeting, preparing financial statements and creating balance sheets. It integrates with external data to allow you to import and export banking information and financial data to and from other accounting software.
This course is designed for accounting professionals that are using MS Excel as their spreadsheet tool to develop reports and calculation for operation purpose. The objective is to bring awareness of more MS Excel PivotTable features that can enhance the operation analytical quality. This course focuses to illustrate the the building of an accounting dashboard based on data extraction