Excel and Google Sheets Training in VIC Melbourne

Excel and Google Sheets Training in VIC Melbourne, Australia

This course provides an in-depth guide to using Excel and Google Sheets for effective data analysis, management, and reporting.

Enroll Now

Excel and Google Sheets Training is a professional training program delivered by ProgNXT in VIC Melbourne, Australia. ProgNXT, a globally recognized corporate training provider in 55+ countries, offers this Excel and Google Sheets Training course with hands-on, instructor-led sessions. This training provides an in-depth guide to using Excel and Google Sheets for effective data analysis, management, and reporting. Participants will...

Expert Panel

Designed and delivered by the ProgNXT Data Analysis Expert Panel — a vetted team of industry professionals with 12+ years of hands-on experience in Excel, SQL, Python, Tableau, and Power BI

ProgNXT Data Analysis Expert Panel

Course Code: KKN60
14 Hrs
Last Updated: April 2026

Course Rating5/5

This training provides an in-depth guide to using Excel and Google Sheets for effective data analysis, management, and reporting. Participants will learn how to use advanced features of both tools for creating complex spreadsheets, automating tasks, analyzing data, and collaborating in real-time.

Welcome to the official Excel and Google Sheets Training certification program in VIC Melbourne, Australia. This comprehensive training is designed to elevate your professional skills and provide you with practical, industry-relevant knowledge locally. As a globally recognized corporate training provider operating in 55+ countries, ProgNXT ensures that our curriculum meets the highest standards of excellence.

Whether you are looking to upskill your team or advance your personal career, our expert-led sessions will guide you through the core concepts of this domain. Upon successful completion of the 14 Hrs program, participants will receive a globally accepted certification, demonstrating their proficiency and readiness to tackle complex challenges in the field.

Participants should have:

Basic familiarity with Excel or Google Sheets.
A general understanding of spreadsheet concepts such as rows, columns, and basic formulas.

By the end of the training, participants will be able to:

Use advanced Excel and Google Sheets functions for data analysis and reporting.
Create interactive reports, dashboards, and visualizations.
Perform data analysis tasks such as filtering, sorting, and pivot tables.
Automate repetitive tasks using formulas, conditional formatting, and macros (in Excel) and scripts (in Google Sheets).
Collaborate effectively by sharing and commenting on documents in Google Sheets.

Participants will gain skills in:

Data manipulation using Excel and Google Sheets functions (e.g., VLOOKUP, SUMIF, INDEX/MATCH).
Creating dynamic charts and visualizations.
Using PivotTables for summarizing large datasets.
Implementing conditional formatting and data validation for better data presentation.
Automating tasks using macros (Excel) or Google Apps Script (Google Sheets).
Collaborating and sharing documents in both platforms.

Participants will be evaluated on their ability to:

Apply advanced formulas and functions to solve complex data problems.
Create effective data visualizations (charts, graphs) and dashboards.
Design and use PivotTables for summarizing data.
Automate tasks and streamline workflows using macros and scripts.
Collaborate in Google Sheets with real-time updates and sharing features.

Upon successfully completing the training and assessments, participants will be awarded the ProgNXT Certificate of Completion, recognizing their proficiency in Excel and Google Sheets.

Day 1: Advanced Data Manipulation and Analysis

Session 1: Advanced Functions and Formulas
- Using VLOOKUP, HLOOKUP, INDEX/MATCH, and nested formulas.
- Conditional functions: IF, SUMIF, COUNTIF, etc.
- Text and date functions for data cleaning.
Session 2: Data Validation and Conditional Formatting
- Setting up data validation rules (dropdowns, date ranges, etc.).
- Implementing conditional formatting to highlight trends and anomalies.
- Creating custom rules for data integrity.
Session 3: PivotTables and Data Summarization
- Introduction to PivotTables for data summarization.
- Grouping data and creating calculated fields.
- Creating PivotCharts for visual data representation.
Hands-On Lab:
- Participants practice using advanced formulas, data validation, and PivotTables with real datasets.

Day 2: Automation, Visualization, and Collaboration

Session 4: Creating Dashboards and Visualizations
- Designing interactive charts and graphs.
- Best practices for creating dynamic dashboards in both Excel and Google Sheets.
- Using sparklines and advanced chart types for better insights.
Session 5: Automating Tasks with Macros (Excel) and Google Apps Script (Google Sheets)
- Introduction to recording macros in Excel.
- Writing custom VBA code for task automation.
- Using Google Apps Script to automate tasks in Google Sheets.
Session 6: Collaboration and Sharing
- Sharing and commenting on Google Sheets documents in real time.
- Protecting data and managing permissions in both platforms.
- Version history and collaboration best practices.
Final Hands-On Lab:
- Participants work on a final project, creating a dashboard, automating a task, and collaborating on a shared document.

This training equips participants with the advanced skills necessary to leverage Excel and Google Sheets for efficient data analysis, reporting, and collaboration in their daily tasks.

Participants will receive:

A detailed training manual covering key functions and techniques in Excel and Google Sheets.
Sample datasets for practice and hands-on exercises.
Access to video tutorials and resources for further learning.
Cheat sheets for common Excel and Google Sheets formulas.

Participants will be evaluated through hands-on exercises, quizzes, and a final project.
ProgNXT Certificates of completion will be awarded to participants who successfully complete the course assessments.

Excel and Google Sheets Training Events in melbourne

Online Events

Global Region	Location	Start Date	End Date	Action
‌	‌	‌	‌	‌
‌	‌	‌	‌	‌
‌	‌	‌	‌	‌
‌	‌	‌	‌	‌
‌	‌	‌	‌	‌

More Upcoming Session Dates

November 2026

🌐 Online Instructor-Led

1st Nov 2026→2nd Nov 2026

📍 VIC Melbourne, Australia

11th Nov 2026→12th Nov 2026

📍 VIC Melbourne, Australia

22nd Nov 2026→23rd Nov 2026

🌐 Online Instructor-Led

24th Nov 2026→25th Nov 2026

December 2026

📍 VIC Melbourne, Australia

8th Dec 2026→9th Dec 2026

🌐 Online Instructor-Led

10th Dec 2026→11th Dec 2026

🌐 Online Instructor-Led

18th Dec 2026→19th Dec 2026

📍 VIC Melbourne, Australia

27th Dec 2026→28th Dec 2026

Events for other courses in VIC Melbourne, Australia

Global Region	Course Name	Start Date	End Date	Action
‌	‌	‌	‌	‌
‌	‌	‌	‌	‌
‌	‌	‌	‌	‌
‌	‌	‌	‌	‌
‌	‌	‌	‌	‌

Excel and Google Sheets Training in VIC Melbourne