Extended: Excel Intermediate – Excelling – 90 MINS

Overview:

As part of our Council Mastery Series Deep Dive Sessions, this webinar focuses on unlocking the full potential of Microsoft Excel to improve council data management and analytical capabilities. Learn how to organise data, create meaningful reports, and apply advanced formulas to support informed decision-making.  This webinar will eliminate the confusion you may have encountered when trying to prepare your spreadsheet for printing.

What to Expect:

• Format: 90-minute live online session  – (Intermediate Level)
• Includes: Scenario-based guidance, + Extended Live Webinar + Q&A 
• Cost: This training webinar costs £65 per attendee for non-CloudyIT customers, or for existing CloudyIT customers, the equivalent number of Training Credits. Please see our Terms & Conditions for more details about attending this event.

Key Topics: 

• Data Validation to ensure data accuracy, automatically highlighting changes
• Making the most of advanced filtering and conditional formatting
• Examining Functions for:
• LOOKUPs, TEXT, SUMIFS, COUNTIFS, AVERAGEIFS, MATH&TRIG, STATISTICAL,
• Why formulas go wrong
• Using Copilot AI in Excel
• Identifying and removing duplicates
• Preparing your spreadsheet for printing
• Using named ranges in Formulas
• Calculate dates with NOW functions

Ideal for those who attended the Excel Essentials ‘Time to Excel’ course as this is a fast-paced course, although it will take the direction from its attendees. 

For Council staff, clerks, and anyone managing data or reports as part of their role. 

Continue Your Digital Learning Journey:

Combine what you’ve learned with insights from our 1-hour Jump-ins, which explore how Outlook integrates with other apps and tools like Teams and SharePoint, Loop, Planner, Bookings and Forms to create seamless workflows.

Take your next step with tools designed to help you assess your Microsoft 365 skills and grow your digital confidence.

• Complete the Microsoft 365 Digital Skills Audit Tool
•  Join us for an AI in Local Government Members’ Day
• Explore an in-person DisGovery Day