Key areas that will be covered on this course include

• Use Excel exclusively to generate all your reports and statements
• Develop dynamic reports that you can use to present to non-financial managers/directors that are easy to understand and navigate
• Develop a complex data warehouse that will store and manage all the data you require
• Prepare consolidated “ad hoc” reports quickly and easily in Excel using a wide choice of report criteria
• Easily create detailed graphic reports that support and enhance your financial data
• Using Excel to take control of financial data and put it into a format that can be used for effective decision making
• Taking advantage of Excel’s many specialized features to produce management reports, quickly and easily
• Eliminating the disparity between accounting programs and allow source data to become uniform
• Utilize Macros and advanced functions to save time when manipulating data and automating the production of management reports and charts
• Developing projections and trend analysis spreadsheets to assist with management decision making
• Writing and using Excel Macro’s and Formulae to save time by automatically doing repetitive work