Analyzing Data with Excel

Analysing Data with Excel

COURSE TRAINERS

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)
Fulltime	3 days	R 7,500.00	Get a Quote
Webinar	3 days	R 6,500.00	Get a Quote

Discounts Available

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

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.

Start Date	End Date	Branch	Status
Mon 27 May 2024	Wed 29 May 2024	Fourways	Provisional	Enquire
Mon 16 Sep 2024	Wed 18 Sep 2024	Fourways	Provisional	Enquire

Submit Enquiry