Content

This course will cover:

  • Navigating the modern Excel Ribbon and Quick Access Toolbar
  • Data entry best practices and using “Auto Fill features” to automate tasks.
  • Writing essential formulas: SUM, AVERAGE, MIN, MAX, COUNT, TODAY
  • Understanding Relative vs. Absolute cell referencing ($)
  • Formatting cells based on data types and error handling
  • Managing data using official Excel Tables (Sort & Filter)
  • Creating and editing basic charts (Column, Bar, Pie)
  • Page layout and printing preparation-Print to pdf

Outcomes

  • Navigate the Excel environment without frustration.
  • Create accurate formulas to perform basic business calculations.
  • Format spreadsheets to be visually professional and consistent.
  • Manage large sets of data by sorting and filtering effectively.
  • Present data visually using charts.
  • Prepare and print documents properly (avoiding printing errors).

Who Should Attend

Perfect for beginners and self-taught users alike, this course builds a strong foundation for the modern workplace. You will unlock new levels of efficiency by mastering time-saving features, allowing you to manage data effectively and with full confidence. 

Benefits to You and Your Organisation 

  • Individual Benefit: Save time on daily administrative tasks by learning shortcuts and automation features.
  • Organisational Benefit: Reduce data errors and ensure consistent, professional formatting across team documents.
  • Organisational Benefit: Increase overall team productivity by ensuring staff can handle basic data tasks independently.

Learn about our speakers

Jagmohan (Jagg) Singh

Trainer
-

Jagmohan (Jagg) Singh is a premier Software and Professional Development Trainer with over 18 years of global experience across the IT, Insurance, and Hospitality sectors. Jagg specializes in transforming training from a functional task into a strategic differentiator that drives measurable business results.

He has a remarkable track record of empowering over 57,000 professionals (50,000+ in India and 7,000+ in Australia), helping them master complex technical skills while refining their professional demeanor for maximum organizational impact.

Key Qualifications:
Microsoft Certified Trainer (MCT): Specialist in Microsoft 365, Teams Administration, and Data Analytics.
Certified Professional: Cert IV in Training and Assessment (TAE) and Diploma in Financial Planning (Australia).
Academic Foundation: MBA in Sales & Marketing; BSc in Computer Science.

Areas of Expertise:
End-to-End L&D Strategy: Expert in Training Need Analysis (TNA), content development, and delivery planning that aligns with C-Suite objectives.
Software & Data Mastery: Bridging the gap between complex data/software tools (Microsoft 365, Power BI) and practical business application.
Sales & Leadership Coaching: Developing high-performance teams through behavioral competency modeling and integrated coaching (Classroom + Field Monitoring + E-Learning).
Evidence-Based Results: Dedicated to showcasing training effectiveness through clear ROI and productivity metrics.

Upcoming course availability

In person

May 2026

Friday, 08 May 2026

Format
Face-to-face

Duration
1 full-day
9:00am - 4:30pm (8:45am registration)

Inclusions
Resources, morning tea, lunch and refreshments

Location
Adelaide CBD, SA 5000
(please visit registration links for further information)
View map

Costs
Personal Member $575
State Govt Employee Member $615
Corporate Member $625
Non-Member $725

This course is also available in-agency. Please contact us for further information