This unit covers setting up the Excel work environment, creating worksheets, and building basic tables. Participants will learn how to organise data professionally and apply essential formatting. The unit also focuses on working with lists, filters, and sorting, providing a solid foundation for more advanced skills.
This unit focuses on the use of pivot tables, as well as creating advanced formulas and functions. Participants will learn effective methods for analysing data and applying Excel functions to achieve accurate results. Practical techniques are introduced to simplify working with large datasets, enhancing efficiency in handling complex data.
This unit explores advanced formatting techniques, including the professional presentation of tables and reports. Participants are introduced to macros and how they can be used to automate repetitive tasks. The unit provides powerful tools to save time and improve work quality, along with an introductory overview of VBA.
This unit focuses on building dynamic and professional dashboards for effective data presentation. Participants will also learn the fundamentals of writing basic VBA code to extend Excel’s capabilities. The unit supports learners in transitioning from a standard user to a more advanced Excel user