Excel Smarter: PivotTables & Power Query for Busy Professionals

Date: 25 July 2025

Time: 06:30 PM - 08:00 PM (GMT +8 Singapore Time)

Duration: 1 hour 30 minutes

Location: Online via Zoom

Speaker: Sandra Lechman

Register Now

About the Webinar

Tired of spending hours on repetitive Excel tasks? Learn how to work smarter, not harder with the powerful features of PivotTables and Power Query. In this 1.5 hour session, discover how to turn messy spreadsheets into interactive reports and automated workflows that save time and reduce errors. Whether you're managing sales reports, cleaning large datasets, or refreshing monthly dashboards, this webinar will help you unlock Excel’s full potential with practical, real-world examples.

This programme is brought to you in collaboration with National Library Board (NLB) and is part of the SkillsFuture Festival 2025.

Webinar Outline:

  • Introduction & Why These Tools Matter (15 mins)
    • How PivotTables & Power Query save hours of manual work
    • Real-world examples (sales reports, expense tracking, data cleaning)
  • Mastering PivotTables (30 mins)
    • Creating & formatting PivotTables from raw data
    • Grouping, filtering, and calculated fields
    • Dynamic dashboards: Slicers & timelines for interactive reports
  • Power Query Basics (30 mins)
    • Importing & cleaning messy data automatically
    • Merging datasets (e.g., combining multiple Excel files)
    • Automating repetitive tasks (e.g., monthly report refreshes)
  • Q&A + Pro Tips (15 mins)
    • Common errors & fixes
    • Keyboard shortcuts for speed
    • Q&A
 

About the Speaker (Sandra Lechman)

Picture of Sandra Lechman

Sandra Lechman has over 25 years of experience in the IT training and consultancy industry. She has worked with both the public and private sectors, receiving awards such as Best IT Trainer and the Innovators’ Act Award. Sandra is certified in Adobe and Microsoft applications and is a beta tester for Adobe and Microsoft exams. She holds qualifications in Computer Studies, validated by the University of Cambridge.

Sandra is also certified as a Trainer, Curriculum Developer, and Assessor, with credentials from the SSG. She has extensive experience training diverse learners and creating customized training solutions. Known for her passion, Sandra consistently receives excellent feedback for her engaging and informative training sessions.

Webinar Information

     
  • This programme is conducted entirely online. You may access Zoom via the app or using a web browser.
  • Please ensure that you enter a valid email address as you will receive an email with the link to the online programme/event near the day of the programme/event.
  • The link of the programme should not be shared with others.
  • Do ensure you have a strong internet connection. Using your mobile data is not recommended.
  • The National Library Board, Singapore (NLB) reserves the right in its absolute discretion to disqualify or refuse admission to any registrant without any reason and notice.
  • Please note that presentation slides may be available during or after the programme, depending on the programme. Where applicable, only participants who attend the programme can have access to the slides via instructions given during the programme.
  •  

Zoom Registration Link: Sign Up