Bitesize Excel

 

Our Bitesize Excel course is designed to provide short, focused sessions that build up to full proficiency in Excel. These sessions can be accessed anytime and anywhere, making it easy for anyone in your school to participate. The flexible format allows learners to start at the very beginning, jump in at their current skill level, or focus on specific topics of interest.

​

Excel is an essential tool for managing data, producing reports, and supporting school administration. Many staff inherit spreadsheets or work with Excel only occasionally, leading to inefficiency or mistakes.

 

This Bitesize course breaks learning into small, manageable steps, giving participants confidence as they progress from beginner to fully competent users. Assignments at the end of each session reinforce understanding and provide recognition through certificates at each level.   Each session includes downloadable notes, a video presentation to follow along with on your own Excel, and a short assignment to ensure participants can apply the skills independently.

 

Beginner Level

• Session 1: Creating a spreadsheet, understanding the Excel interface, inserting and editing text and numbers, performing simple calculations, and printing.

• Session 2: Basic formatting for numbers and text, moving and copying data, and using simple formulas.

This stage ensures learners are comfortable navigating Excel and performing the fundamental tasks needed for everyday use.

 

Basic User Level

• Session 3: Text and number formatting, borders and shading, creating headings.

• Session 4: Using the smart drag handle and more advanced formulas such as AVERAGE, COUNT, IF, SUMIF, and others.

• Session 5: Creating and formatting charts to visualise data clearly.

At this level, participants begin to create more structured, visually effective spreadsheets and use formulas to automate calculations.

​

Intermediate User Level

• Session 6: Freeze panes, filters, sorting, subtotals, and pivot tables.

• Session 7: Keyboard shortcuts, conditional formatting, and data validation.

• Session 8: Absolute and relative cell references, and understanding BODMAS.

• Session 9: Multitab and multisheet calculations, protection, and advanced printing options.

• Session 10: Macros and toolbars to increase productivity and efficiency.

This stage equips participants with the skills to manage large or complex datasets, automate repetitive tasks, and produce professional, accurate spreadsheets.

 

Outcomes - By the end of the course, participants will have progressed from beginner to confident intermediate users of Excel. They will have mastered essential techniques, time-saving tips, and practical skills that can be applied immediately in a school setting. Each completed session earns a certificate, providing formal recognition of learning and achievement at the appropriate level.