Data Analysis Fundamentals using Excel
Length
2 days
Price
$1999
Cities
Melbourne, Sydney, Brisbane, Adelaide, Canberra, Perth
LEARN MORE
WHY CHOOSE THIS COURSE
The Microsoft 10994 Data Analysis Fundamentals using Excel course offered by Logitrain is designed to provide learners with essential skills in data analysis using Microsoft Excel. This hands-on, instructor-led training is ideal for professionals who want to enhance their ability to interpret, manage, and present data effectively in a business environment.
Excel is one of the most widely used tools for data analysis across industries. This course focuses on building a strong foundation in Excel’s analytical features, enabling participants to transform raw data into meaningful insights. Whether you’re working in finance, marketing, operations, or administration, the skills gained in this course will help you make data-driven decisions with confidence.
Throughout the course, participants will learn how to create and format Excel tables, use PivotTables and PivotCharts to summarize and visualize data, and build interactive dashboards. The training also covers working with hierarchies and time-based data, which are essential for tracking performance and trends over time. Learners will explore the Excel Data Model, allowing them to connect to external data sources and build relationships between datasets.
The course is structured to be practical and job-focused, with real-world examples and exercises that reinforce learning. Logitrain’s experienced instructors guide participants through each module, ensuring they understand not only how to use Excel’s features but also when and why to apply them in a business context.
This course is suitable for individuals with a basic understanding of Excel who are looking to advance their skills in data analysis. It is particularly beneficial for business analysts, project managers, administrative professionals, and anyone involved in reporting or decision-making processes.
By the end of the training, participants will be able to:
- Create structured reports and dashboards
- Use PivotTables and PivotCharts for dynamic data analysis
- Work with time-based and hierarchical data
- Connect and model data from multiple sources
Prerequisites
- Basic knowledge of Microsoft Windows operating system and its core functionality.
- Advanced working knowledge of Excel spreadsheets, including formulas.
Exam
There is no certification exam associated with this course.
Books
- Course material for Data Analysis Fundamentals using Excel provided
Delivery
- Instructor-led Classroom Training at our premises
- Live Virtual Online Training attend in real-time from anywhere
- In-House Training at your premises (4+ participants)
Skills Gained
- Create an Excel report
- Create an Excel table
- Create a pivot table and pivot chart
- Create a dashboard and analyse data
- Create Hierarchies
- Create an Excel data model and connect to external data
Audience
- Anyone who wants to take Excel beyond formulas and add advanced capabilities like dashboards, hierarchies, and relationships.
- Ideal for power users, analysts, and professionals working with data.
Objectives
- Understand the core principles of data analysis and how they apply to business decision-making.
- Learn to organise, clean, and prepare datasets effectively within Microsoft Excel.
- Develop skills to use Excel functions and formulas for summarising and analysing data.
- Gain proficiency in creating charts, graphs, and pivot tables for data visualisation.
- Apply statistical techniques such as descriptive statistics and trend analysis using Excel tools.
- Interpret and present analytical results clearly to support actionable insights.
Outline
- Create an Excel report
- Create an Excel table
- Create a pivot table and pivot chart
- Create a dashboard and analyse data
- Create Hierarchies
- Create an Excel data model and connect to external data
- Filtering Excel Data
- Formatting Excel Data
- Create excel Charts
- Filter and format data
- Create charts
- Excel Data Tables
- Summarizing Data
- Create an Excel Table
- Summarize Excel Data
- Explain what Excel Data tables are
- Sort, filter, and validate data
- Summarize data
- Format summarized data
- Pivot Tables
- Pivot Charts
- Editing Pivot Tables and Pivot Charts
- Creating a Pivot Table
- Creating a Pivot Chart
- Editing Pivot Tables and Pivot Charts
- Describe pivot tables and how to create them
- Describe the various elements of a pivot chart
- Edit pivot tables and pivot charts
- Creating a Dashboard
- Data Analysis in Excel Pivot Tables
- Arranging Tables and Charts
- Slicing Data
- Data Analysis
- Describe a dashboard
- Filter data using a slicer
- Add calculated columns to a dashboard
- Find anomalies
- Hierarchies
- Time Data
- Create a Hierarchy
- Configure Time data
- Create an Animated Time Chart
- Describe hierarchies
- Create levels within a hierarchy
- Explain why time data is different and how to work with it
- Using an Excel Data Model
- External Data
- Add Multiple Tables
- Create Relationships
- Add External Data
- Explain an Excel Data Model and how to use it
- Import External Data and use it
- Link out to external data
Price
| Category | Full-Time (Weekdays) | Part-Time (Weeknights) | Part-Time (Weekends) |
|---|---|---|---|
| Days | Monday to Wednesday | Mondays and Tuesdays | Saturdays only |
| Time | 9:30 am to 5:00 pm | 6:00 pm to 9:00 pm | 10:00 am to 5:00 pm |
| Duration | 2 days | 2 weeks | 2 weeks |
| Price | $1999 | $1999 | $1999 |
Terms & Conditions
The supply of this course is governed by our terms and conditions. Please read them carefully before enrolling, as enrolment is conditional on acceptance of these terms and conditions. Proposed course dates are given, course runs subject to availability and minimum registrations.
Frequently Asked Questions (FAQ's)
What is the purpose of this course?
This course is designed to help learners understand the fundamentals of data analysis using Microsoft Excel. It focuses on practical techniques for organising, cleaning, and interpreting data, making it ideal for professionals who want to make data-driven decisions.
Can I attend this course online?
Absolutely. The course is available via live virtual training and in-person sessions at major Australian cities, giving you flexibility to learn from anywhere.
Is this course suitable for beginners?
Yes, it is perfect for beginners and professionals who want to strengthen their Excel skills for data analysis. It bridges the gap between basic spreadsheet use and analytical techniques.
Will I receive a certificate?
Yes, participants receive a certificate of completion from the training provider, which can be added to your resume or LinkedIn profile to showcase your new skills.
Our Partnership
We are proud to partner with Telstra, one of Australia’s leading technology and telecommunications companies, to deliver the Data Analysis Fundamentals using Excel course. This collaboration ensures learners gain practical, industry-relevant skills in data analysis, empowering them to make informed decisions and drive business success.
$90,000
Average annual salary for professionals with strong Excel-based data analysis skills in Australia
51%
Employers value Excel-based data analysis skills for analytics and BI roles.
12%
Year-on-year growth in job opportunities for professionals with Excel-based data analysis skills
120,000+
Active professionals with Excel-based data analysis expertise worldwide
8,840+
Australian companies recognise and employ professionals with Excel-based data analysis skills.
92%
Student satisfaction rate for Data Analysis Fundamentals using Excel training programs
Our Accreditations
