Excel with These Excel Tips
Date: 25 November 2024
Time: 07:00 PM - 08:00 PM (GMT +8 Singapore Time)
Duration: 1 hour
Location: Online via Zoom
Speaker: Sandra Lechman
Access SlidesAbout the Webinar
Tired of staring at a complex spreadsheet, wishing you knew how to unlock its full potential? You're not alone! Many Singaporeans use Excel daily but struggle to go beyond the basics. This webinar will change that and help you be more efficient and confident with your data. Learn how to navigate complex datasets, organise information effortlessly, and apply powerful techniques that take your Excel skills to the next level. Join us and learn powerful tricks and formulas to transform your approach to Excel – no matter your skill level!
Webinar Outline:
- Introduction (5 minutes)
- Welcome and Introduction
- Shortcuts & Efficiency (10 minutes)
- Top Keyboard Shortcuts:
- Ctrl+Shift+L: Toggle filters on and off instantly.
- Alt+Enter: Enter a line break within a cell for better data presentation.
- Ctrl+T: Quickly convert a range into a Table for easier data manipulation.
- Navigation Tips:
- Ctrl+Arrow Keys: Jump to the edges of your data range instantly.
- Ctrl+Page Up/Page Down: Quickly switch between worksheet tabs.
- Data Management & Formatting (15 minutes)
- Efficient Data Entry Techniques: Use of AutoFill, Flash Fill, and data validation for quick and error-free data entry.
- Conditional Formatting: Demonstrate how to apply conditional formatting to highlight key data points automatically.
- Data Organization Tips: Best practices for sorting, filtering, and grouping data to make large datasets more manageable.
- Powerful Formulas & Functions (25 minutes)
- Introduction to Must-Know Formulas:
- Focus on 3 key formulas (SUM, IFs, and XLOOKUP).
- Common Formula Errors
- Tips on troubleshooting and avoiding common mistakes with examples
- Wrap-Up and Q&A Session (5 minutes)
- Recap of key takeaways & newfound Excel confidence
- Open forum for participants to ask questions and get clarification on key points
About the Speaker (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 webinar is conducted via Zoom. 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 webinar.
- The link to the webinar should not be shared with others.
- Ensure you have a strong internet connection. Using your mobile data is not recommended.
- This webinar will be recorded and made available on our website for later viewing.
- The webinar outline is subject to change.
Zoom Registration Link: Register Now
Access This Webinar Slide Deck
Fill in the form below to gain access to the webinar slides.
"*" indicates required fields