Excel Smarter: PivotTables & Power Query for Busy Professionals - ASK Training

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
- 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

Missed The Webinar? Watch On-Demand Now

Access This Webinar Slide Deck

Fill in the form below to gain access to the webinar slides.

"*" indicates required fields

Name*

Email Address*

Webinar*

Your privacy is important to us. By submitting this form, you consent to @ASK Training collecting, processing, and storing your personal information to respond to your inquiry and provide requested information. We may also send you updates and promotional offers, but you can opt out anytime by unticking the box above. We're committed to safeguarding your data and won't share it unless required by law or with your explicit consent. For more information, please see our Privacy Policy.

CAPTCHA

Name

This field is for validation purposes and should be left unchanged.