Microsoft Excel is a powerful tool which can be harnessed to turn huge volumes of data into useful information for making financial decisions. Through this course, you will learn how to create templates to suit your unique reporting needs, use formulae and pivot tables to analyse data, and how to increase and sustain your productivity by shortening the time required to input and generate data for periodical reporting.
♦ Understand the overview of budgeting requirement
♦ Design templates and link up various input data
♦ Work with different worksheets
♦ Consolidate financial data into a central depository
♦ Design Charts and Reports
♦ Use Formulae to calculate and organise data
♦ Use Pivot Tables to generate management reports within minutes of your time