This course has passed.


Whether you want to manage spreadsheets with ease, create chart tables or effectively visualise your data, our Excel Skills for the Public Sector course will turn your fear of Excel into confidence with efficient tools and techniques you won’t forget.

Through interactive workshops and tutor led discussions, familiarise yourself with a range of Excel formula functions, while using basic maths. Learn how to effectively manage larger tables – including sorting multiple columns and inserting row filters to extract data – and gain techniques to build functional charts.

Leave the day with useful tips, tricks and proven shortcuts to improve how you use Excel in the workplace.

Please note we also run an advanced version of this course.

Unlocking the Power of Virtual

Our virtual courses have been designed with you in mind. From group exercises in breakout rooms to live chat, whiteboards and interactive polls, we use a range of tools and techniques to ensure that you can connect with your trainer; network and share best practice with your peers and leave the day with the skills you need.

Our courses provide you with an interactive and engaging learning environment that can be accessed from any location, helping you to continue to connect, learn and grow. Click here to discover more!

Please note we will use Zoom to virtually deliver this course.

trainer photo
Alan Gilbert
Microsoft Excel and Power BI Consultant

In his 20+ years of teaching Microsoft products, Alan has helped a vast array of industries from finance to construction, media, and government. In the past he has been both lead trainer for Go Courses, and training manager for Ultima Concepts. As work increased, he established his own IT consultancy in 2013, following on from 18 years as a full-time trainer.

Being a certified Microsoft Office Specialist, he found the demand for Microsoft Excel training and consultancy work, including Excel’s many facets, increased substantially. Subsequently, that insider’s perspective led him to establish a second consultancy specialising in Microsoft ...

Read more

Learning Outcomes

  • Learn how to create and format tables
  • Gain techniques to summarise data with formulas
  • Improve your confidence at using Excel
  • Increase your confidence at creating charts
All the Understanding ModernGov courses are Continuing Professional Development (CPD) certified, with signed certificates available upon request for event.

Enquire About In-House Training

To speak to someone about a bespoke training programme, please contact us:
0800 542 9414
[email protected]


Collapse all
09:25 - 09:30


09:30 - 10:00

Trainer’s Welcome and Clarification of Learning Objectives

10:00 - 10:45

Workshop: Creating and Formatting Tables, Filling Data

  • Create an excel table from scratch
  • Wrap text in cells
  • Data entry with the fill series
  • Sorting columns
  • Manage worksheets
10:45 - 11:00

Morning Break

11:00 - 12:00

Workshop: Summarising Data with Formulas

  • Insert formula functions
  • Use AutoSum to sum
  • Statistical functions AVERAGE, MAX, and MIN
  • Write basic math calculations
  • Learn when to use brackets
  • Troubleshoot formula errors
12:00 - 13:00

Workshop: Managing Rows and Columns

  • Insert and delete rows and columns
  • Adjust multiple column widths and row heights
  • Hide and unhide columns and rows

Workshop: Calculation with Absolute Reference:

  • Difference between relative and absolute reference
  • Lock cells when copying formulas
  • Change relative formulas to absolute with $ signs
13:00 - 13:45


13:45 - 14:00

Reflection Session

  • Trainer will review the day’s learning and the next stages of the course
  • Delegates will have time to ask questions and share views with one another
14:00 - 14:45

Workshop: Managing Content Formatting

  • Work with data formatting
  • Manage number formatting
  • Control formatting with the format painter

Workshop: Managing Large Tables

  • Table navigation keyboard shortcuts
  • Use freeze panes to lock tables when scrolling
  • Use filters to extract table data
14:45 - 15:00


15:00 - 16:00

Workshop: Working with Charts and Output to Print

  • Why should we use charts?
  • Choosing the right chart for your data
  • Inserting chart titles and axis titles
  • Add data labels
  • Chart formats and changing chart types
  • Print tables and charts
  • Print a range
  • Print page titles across every page
  • Scale print size
16:00 - 16:15

Round Up and Key Takeaways