Resources On-Demand

Excel Series: Excel Skills to Improve Forecasting, Decision-Making and Client Reporting (Part 3) - 2021

This webinar on demand is part of a series of webinars. Click here to read more

This webinar focussed on developing the skills to be able to compile professional reports to improve forecasting for better business decisions, as well as the ability to compile professional reports for presentation to clients.

The key concepts discussed in this webinar were:

• Creating and managing pivot tables to detect trends and make data comparisons.
• Understanding and creating line graphs for financial data/report interpretation.
• Managing graph layouts and adding notes to graphs to apply in management accounting reports.

Data sets to be used during this webinar include:

• Quality control data.
• Price lists and inventory (stock).

Outcomes

This webinar will enable you to:

• Apply basic Excel features/functions in your practice to save time and improve productivity.
• Improve the technical accuracy (integrity) of your work by improving the process of importing, cleaning, and validating data.