1. Periodical Dashboard. Created a dashboard to present the data DAILY, WEEKLY, MONTHLY, QTRLY and Yearly on selection of Options by using Form Controls, Dynamic Ranges, Advance Functions, and Dynamic Conditional Formatting, 2. Analytical Dashboard. Created a dashboard to analyze how many movies released by big producers and small produces by using Scrollbar, Charts and advance functions. 3. Cost Allocation Report. Created a macros to allocate the expenditure to different department based selected cost centers and headcount of department.