Mastering Data Analysis and Visualization with MS Excel
This highly participative Mastering Data Analysis and Visualization with MS Excel training course will help you to enhance the use of Excel through the extended use of Power Query for data preparation and analysis. Excel has many features and tools to help you save time and produce effective spreadsheets for reporting on data insights, as well as charts and graphs to help you further analyze and visualize the data and present the data in visual form.
Finance & Accounting · 5 Days · Public · Al-Khobraa certified · From USD 3,900
Learning Objectives
- The structured way of data analytics and visualization with Excel,
- Knowledge on how to differentiate data quality,
- The understanding on how to find hidden patterns within the data with Excel AI,
- Step-by-step process of data visualization with the use of Excel Charts,
- Framework for data loading, cleansing, transformation and use,
- How to avoid common pitfalls of data visualization.
Who Should Attend
This course is designed for consultants, marketing managers, operation managers, and other professionals seeking to strengthen their capability in this area.
- Consultants
- Marketing managers
- Operation Managers
- Project Managers
- Financial Managers
- Urban planners
- Transport and traffic engineers
- Supply Chain Managers
- Risk managers
- Plant managers
Course Outline
Day 1 — Basic Excel Formulas and New Functions
- Excel Introduction
- Data Entry and Manipulation
- Working With Ranges
- Math and Logic Functions
Day 2 — Data Modeling and Analysis with Excel
- Power Query Introduction
- Data Modeling with Power Query
- Using data profiling tools
- Data Transformation
Day 3 — Business Intelligence in Practice with Excel
- Reporting with Excel
- Pareto Chart
- Boston Consulting Matrix
- PivotTable
Day 4 — Visualizations with Excel and dashboards
- Different chart types and its use
- Color Scales and Icons
- Formulas
- Checking data distribution
Day 5 — Array, Logic, Statistical and Lookup Functions
- Manipulating Arrays
- Finding Outliers
- Calculating Probabilities
- LET, LAMBDA, and LAMBDA Helper Function
Accreditation
Al-Khobraa certified. On completion delegates receive an Al-Khobraa certificate of achievement.
Dates & Venues
| Dates | Venue | Delivery | Duration | Fee (USD) |
|---|---|---|---|---|
| December 28 – January 1, 2027 | Cameroon, Central Africa | Public | 5 days | 4,500 |
Inquire about Mastering Data Analysis and Visualization with MS Excel · Inquire on WhatsApp
Frequently Asked Questions
What do Al-Khobraa finance and accounting courses cover?
The portfolio covers IFRS (International Financial Reporting Standards) and IPSAS, financial analysis and reporting, budgeting and forecasting, cost and management accounting, accounts payable and receivable, internal controls and audit, and finance for non-finance managers.
Who should attend a finance and accounting course?
These courses suit accountants and financial analysts, finance managers and controllers, budgeting and planning staff, internal auditors, accounts payable and receivable teams, and non-financial managers who own a budget or read financial statements.
How long are finance and accounting courses, and where are they held?
Most Al-Khobraa finance and accounting courses run over 5 days. The exact duration, dates and city for this course are listed in the dates section on this page. Public sessions run across Saudi Arabia — Riyadh, Jeddah, Al-Khobar, Jubail and Yanbu — as well as regional and international venues, with live virtual classrooms available on request.
What certificate will I receive?
Delegates who complete the course receive an Al-Khobraa certificate of completion, issued by a Saudi-registered training provider. Al-Khobraa also delivers internationally accredited programs; where a course carries an external awarding body such as PMI, CIPS, ILM or IOSH, that body is named on the course's own page.
Can finance and accounting training be delivered in-house for our team?
Yes. Any Al-Khobraa finance and accounting course can be delivered in-house at your own premises anywhere in Saudi Arabia or the GCC, with the content, dates and language of delivery tailored to your team. Al-Khobraa is an approved HRDF (Hadaf) provider, so eligible Saudi employers can seek training support. Contact us for a quotation.
Related Finance & Accounting Courses
- Accounting, Decision Making and Financial Communication
- Accounting and Finance Policies & Procedures
- Accounts Payable: Planning, Organizing and Achieving Best Practice
- Accounts Reconciliation Strategies and Management
- Adapting the Corporate Budget in the Wake of Unknowns
- Adding Value in Internal Audit Training
- Advance Finance for non-Finance Professional
- Advanced Cost Management for the Competitive Business Environment