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
Statistics with R
COURSE TRAINERS
Kirstin S Bosworth
Lawrence Maoka
Lawrence Maoka
Lawrence is a Sales Manager and Training instructor at Leading Edge Business Solutions (Pty) Ltd since April 2008 and has been a technical instructor since 2004. Lawrence combines technical knowledge with good communications skills and consistently receives enthusiastic reviews from his students. Lawrence has trained in all 9 provinces of South Africa as well as in the DRC, Botswana, and Swaziland.
Operating Systems and Application Software
Windows 95 – Windows 10, Office 97/2000/XP/2003/2007/2010/2013/2016
Linux
PowerBI
Microsoft Word, Excel, PowerPoint, Outlook, Access, Project, Visio, Microsoft Excel Dashboards
Open /Libre Office Writer, Calc, Impress, Base
Thunderbird
Google Apps
Gimp, Scribus
Wordpress and Joomla Content Management Systems
Soft skills / Business Skills
Selling, Presentation, Communication, Time Management & Anger Management.
Certified
Certified Technical Trainer (Ctt+)
N5 Electrical Engineering
Installation Liaison Officer (Telecommunication)
Business Communication
Entrepreneurship
Microsoft Office Specialist, Word, Excel, PowerPoint
ICDL
Network+
I-Net+Hardware and Networking from City & Guilds of London
IC3
Google AdWords
Google Analytics
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:
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 16 Sep 2024 | Wed 18 Sep 2024 | Fourways | Provisional | Enquire |
| Mon 20 Jan 2025 | Wed 22 Jan 2025 | Fourways | Scheduled |