Excel Advanced/ App creator
Excel is a powerful tool for school staff, yet many users only scratch the surface of its capabilities in day-to-day tasks. The Excel Advanced / App Creator course is designed to take participants beyond the basics, building fully functional Excel applications while mastering advanced features that save time and improve productivity.
Many school staff work with spreadsheets every day, but lack the confidence or time to explore advanced tools. This course provides a structured, practical approach to learning advanced Excel functions while creating real, usable applications. Participants gain skills in automation, data management, visualization, and formula-driven design — making
Excel a true problem-solving tool in a school context. Upon completion of assignments, delegates receive a Certificate in Advanced Excel.
Session 1 – Habit Tracker Application
Participants will create a fully functional habit tracker, covering layout and formatting, working with multiple sheets, named ranges, conditional formatting using icons and data sets, IF and COUNTIF functions, hiding rows and columns, HSTACK, dropdown selection boxes, ISBLANK, INDEX, and creating charts from habit data.
This session introduces advanced formulae and dynamic features while producing a practical, visual tool.
Session 2 – Kanban Chart Application
Delegates create a visual Kanban chart to manage tasks and projects, learning layout and formatting, borders and shading, column width and row height, text wrapping, using Paste Special options, conditional formatting to highlight dates, and creating macros.
Participants gain skills in visual project management and automation techniques.
Session 3 – Random Number Generator Application
This session covers building a random number generator with full options, including RANDBETWEEN and RANDARRAY functions, absolute and relative references, INDEX, UNIQUE, SEQUENCE functions, and methods to prevent duplications. Participants explore dynamic data generation and advanced formula logic.
Session 4 – Study Scheduler Application
Delegates will create a study scheduler, learning layout and formatting, formatting numbers, dates and times, calculations involving dates and times, marking tasks complete and changing priority, grouping by subject, creating macros, and editing macros in VBA.
This session combines calculation, automation, and interactive functionality to support structured planning.
Session 5 – To-Do Application
Participants build a fully functional To-Do application, including layout and formatting, data validation for consistent entry, conditional formatting with icons and data sets, working with data bars, applying filters and advanced sorting, and task completion options. This session consolidates learning, combining layout, validation, automation, and interactive features into a practical productivity tool.
Outcomes - By the end of the course, participants will have developed advanced Excel skills and the confidence to create fully functional applications tailored to their school environment. Staff will be able to design, automate, and manage their own tools to track tasks, schedule activities, generate data, and visualise information efficiently. The practical assignments and certificate at the end provide tangible evidence of achievement and skill.
