Postgraduate Certificate in Revenue Management using Microsoft Excel

• <data\_analysis\_with\_excel>: Learn to analyze and interpret large data sets using Microsoft Excel. This unit will cover data importing, cleaning, and visualization techniques.<br> • <financial\_modeling\_in\_excel>: Understand how to build financial models in Excel, including forecasting and budgeting models. This unit will also cover scenario analysis and sensitivity analysis.<br> • <advanced\_excel\_functions>: Master advanced Excel functions, such as lookup and reference functions, logical functions, and text functions. This unit will also cover array formulas and data tables.<br> • <pivot\_tables\_and\_business\_intelligence>: Learn how to create pivot tables and use Excel's data analysis tools for business intelligence. This unit will also cover Power Pivot and Power Query.<br> • <excel\_dashboards\_and\_visualization>: Create dynamic and interactive Excel dashboards to visualize data and communicate insights. This unit will cover data visualization best practices and techniques.<br> • <excel\_automation\_and\_programming>: Learn how to automate Excel tasks using Visual Basic for Applications (VBA) programming. This unit will cover macros, user forms, and add-ins.<br> • <excel\_add\_ins\_and\_customization>: Customize Excel by creating add-ins and modifying the ribbon interface. This unit will cover the Custom UI Editor and developing add-ins using VBA.<br> • <data\_security\_and\_privacy\_in\_excel>: Understand how to protect sensitive data in Excel, including password protection, data encryption, and data validation. This unit will also cover data privacy regulations and best practices.<br> • <excel\_collaboration\_and\_sharing>: Collaborate with others in Excel using co-authoring and sharing