Skip to main content

Analysing Data with Excel

TRAINING COURSE

Analysing Data with Excel

RELATED COURSES

Advanced SQL
Critical Thinking
Data Modelling with M and Power Query
Data Visualization with Python
Data Visualization with R
Excel Dashboards and Power Pivot
GIS ESSENTIALS – “Getting Spatially Enabled”
Introduction to Statistics
Machine Learning with Python
Machine Learning with R
Microsoft Power BI Boot Camp
Microsoft Power BI Desktop Advanced Course
Microsoft Power Query
Microsoft PowerBI Dashboard User Course
MySQL
MySQL Administration
PLSQL
PostgreSQL
PostgreSQL Administration
PostgreSQL for Business Intelligence and Mass-data-analysis
Problem Solving and Decision Making
Problem-Solving SAQA US242817
Python Dashboards with plotly Dash
Python Pandas and Jupyter ETL and Data wrangling
Python Regression
Python Statistical Modelling
Python Statistics
Python Web Apps with Flask MVC Framework
R, Into the Tidyverse (Data Wrangling and ETL)
Regression with R
SQL
SQL Online
Statistics with R

COURSE TRAINERS

Kirstin S Bosworth
Lawrence Maoka

Details

The main purpose of the course is to give students the ability to apply Excel data analysis. The course goes beyond the capabilities of tables and charts and uses Pivot Charts, the Excel Data Model and Power Pivot.

After completing this course, students will be able to:

  • Perform data analysis fundamentals.
  • Visualize data with Excel.
  • Analyze data with formulas and functions.
  • Analyze data with PivotTables
  • Present visual insights with dashboards in Excel.
  • Create geospatial visualizations with Excel.
  • Perform statistical analysis.
  • Get and transform data.
  • Model and analyze data with Power Pivot.
  • Present insights with reports.

Delivery Methods

Leading Training is focusing on providing virtual training courses for the foreseeable future and will only consider in-person and classroom training on request, with a required minimum group size of six delegates. We remain committed to offering training that is fast, focused and effective.

Delivery Method Duration Price (excl. VAT)
Classroom 3 days R 8,250.00 Get a Quote
Live Virtual Training 3 days R 6,750.00 Get a Quote

Discounts Available

Save up to 10% by booking and paying 10 business days before the course.

Brochure:

Download Brochure


Information may change without notice.

Audience

This course is intended for students who are experienced with Microsoft Excel and who wish to add Business intelligence techniques and visualization. The course will take students beyond the capabilities of tables and charts using Pivot Charts and Excel Data Model.

Pre-Requisites

Before attending this course, students must have:

  • Basic knowledge of the Microsoft Windows operating system and its core functionality.
  • Skills using Excel worksheets, particularly in creating formulas and functions.

Course Outline / Curriculum

Data Analysis Fundamentals

  • Introduction to Data Science
  • Create and Modify Tables
  • Sort and Filter Data

Visualizing Data with Excel

  • Visualize Data with Charts
  • Modify and Format Charts
  • Apply Best Practices in Chart Design

Analyzing Data with Formulas and Functions

  • Analyze Data with Formulas and Named Ranges
  • Analyze Data with Functions
  • Implement Data Validation, Forms, and Controls
  • Create Conditional Visualizations with Lookup Functions

Analyzing Data with PivotTables

  • Create a PivotTable
  • Analyze PivotTable Data

Presenting Visual Insights with Dashboards in Excel

  • Visualize Data with PivotCharts
  • Filter Data Using Slicers and Timelines
  • Create a Dashboard in Excel

Creating Geospatial Visualizations with Excel

  • Create Map Charts in Excel
  • Customize Map Charts in Excel

Performing Statistical Analysis

  • Visualize Trendlines and Sparklines with Excel
  • Analyze Data with the Data Analysis ToolPak

Getting and Transforming Data

  • Connect to Data with Queries
  • Clean and Combine Data
  • Shape and Transform Data

Modeling and Analyzing Data with Power Pivot

  • Install Power Pivot in Excel
  • Create Data Models with Power Pivot
  • Create Power Pivots
  • Perform Advanced Data Analysis and Visualization

Presenting Insights with Reports

  • Plan a Report
  • Create a Report

Schedule Dates and Booking

To apply for a booking, click on the relevant "Book Now" button below.
Note: places are only fully secured once payment has been made.

Leading Training is focusing on providing virtual training courses for the foreseeable future and will only consider in-person and classroom training on request, with a required minimum group size of six delegates. We remain committed to offering training that is fast, focused and effective.

Start Date End Date Branch Status  
Mon 27 May 2024 Wed 29 May 2024 Fourways Provisional Enquire
Wed 10 Jul 2024 Fri 12 Jul 2024 Fourways Scheduled

Book Live Virtual Training

Mon 16 Sep 2024 Wed 18 Sep 2024 Fourways Provisional Enquire
Submit Enquiry