Please read “the purpose of excel project” to do steps 4,5, and 7.
Step 4: Prepare trend analysis on key KPIs and determine those that require special attention in designing your audit plan and program. Include the trend analyses visualizations in your report
Step 5: Note any issues/anomalies you believe should be further analyzed.
Step 7: Prepare a report on the development of your forecast. State your forecast assumptions and how they were developed. Disclose how the Company and their industry are thinking about
Please watch this video to help you how to analyses: