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
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
Statistics with R
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 | ZAR 8,250.00 | Get a Quote | |
| Live Virtual Training | 3 days | ZAR 6,750.00 | Get a Quote |
Discounts Available
Save up to 10% by booking and paying 10 business days before the course.
Brochure:
Customer Testimonials
Bestmed Medical Scheme
training was good and i have learned a lot about excel
Bestmed Medical Scheme
I liked the V-Lookup and how to create Pivot chats.
Exxaro Resources Limited
Great experience, excellent content, and great practical's which helped with the understanding of the concepts and applications. will definitely be using these acquired skills now in our master data environment.
Bestmed Medical Scheme
Mr. Lawrence is very patient well equipped when it comes to the training aspect. if you ask something he will slowly explain to you and ensure that you understand i would really like to applaud Ntate Lawrence. now i know how to navigate the excel spread-sheet thank you for the training
Multichoice Support Services (Pty) Ltd
The training was interactive, questions were addressed and the trainer was punctual and passionate about the subject.
Exxaro Resources Limited
Best relevant training in years!
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
There are currently no scheduled dates.
Please note that this course needs a minimum of 6 delegates to schedule a course. You can choose to be added to the waiting list by clicking the button below, and we will contact you when we have enough delegates interested. Should we not get enough delegates, we will refund or credit your paid booking.
Should you need this course urgently, the following options are available:
- Pay for 6 delegates (whether you have them or not) and we will schedule the course as soon as possible.
- If you have fewer delegates and cannot pay for 6, we can negotiate a shortened course where some of the time will be spent in blended learning - watching videos and doing tutorials and exercises with some contact time with the trainer. We would want to discuss what your core needs are so that we cover those aspects. You need to have paid for 3 delegates at least.