Data Management, Manipulation & Analysis using Excel
The Data Management Training Course offers professionals a comprehensive pathway to master data manipulation and data analysis using Excel®. In today’s data-driven world, effective management and interpretation of data are essential skills for decision-making and operational success.
AI, Technology & Digital · 5 Days · Public · Al-Khobraa certified · From USD 2,500
Learning Objectives
- Understand and analyze relationships within data using advanced MS Excel tools.
- Create accurate data forecasts to support business planning.
- Organize and structure company data for improved accessibility and usability.
- Utilize MS Excel techniques to analyze data effectively and derive insights.
- Select and create appropriate charts to communicate data visually and impactfully.
Who Should Attend
This course is designed for administrators working at basic levels of ms excel, hr professionals, any professional, and other professionals seeking to strengthen their capability in this area.
- Administrators working at basic levels of MS Excel
- HR Professionals
- Any professional
Course Outline
Day 1 — An Introduction to the MS Excel Environment
- Cell referencing, cell formatting and entering formula
- Workbooks versus Worksheets
- Copy and pasting
- Left click versus right click
Day 2 — Using MS Excel Functions for Fundamental Data Analysis
- Use of text function, FIND(), LEN(), LEFT(), RIGHT() and &
- Use of count functions, COUNTA(), COUNTIF(), COUNTIFS() and SUMIF()
- Basic statistical functions, Max and Average
- Filtering, sorting and use of conditional formatting
Day 3 — Intermediate MS Excel Functions
- Use of VLOOKUP and HLOOKUP
- Date functions, YEAR, MONTH, DAY, YEARFRAC
- Selecting appropriate charts
- Introduction to Pivot tables
Day 4 — Carrying out Statistical Analysis using MS Excel
- Using MS Excel to calculate mean, mode and median
- The difference between the various standard deviation and variance function in MS Excel
- Using MS Excel to examine inter-dependency
- Drawing histograms in MS Excel
Day 5 — What if and Scenario Analysis Using MS Excel
- Naming cells in MS Excel
- Linking cells together to undertake scenario analysis
- Introduction to solver
- Advanced charting
Accreditation
Al-Khobraa certified. On completion delegates receive an Al-Khobraa certificate of achievement.
Dates & Venues
| Dates | Venue | Delivery | Duration | Fee (USD) |
|---|---|---|---|---|
| February 21–25, 2027 | Dubai, UAE | Public | 5 days | 3,900 |
| April 25–29, 2027 | London, UK | Public | 5 days | 3,900 |
| September 5–9, 2027 | Dubai, UAE | Public | 5 days | 3,900 |
| November 28 – December 2, 2027 | Dubai, UAE | Public | 5 days | 3,900 |
Inquire about Data Management, Manipulation & Analysis using Excel · Inquire on WhatsApp
Frequently Asked Questions
What do Al-Khobraa AI, technology and digital courses cover?
The portfolio covers cyber security, data analytics and data science, artificial intelligence (AI) and machine learning, Power BI and Excel for analysis, digital transformation and IT governance. Courses are applied — delegates work with real datasets and tools rather than slideware.
Who should attend an AI, technology or digital course?
These courses suit IT and cyber security staff, data and business analysts, engineers and operations professionals who work with plant or business data, digital transformation teams, and managers who commission or govern technology projects. Foundation-level courses assume no programming background.
How long are AI, technology and digital courses, and where are they held?
Most Al-Khobraa AI, technology and digital 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 AI, technology and digital training be delivered in-house for our team?
Yes. Any Al-Khobraa AI, technology and digital 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 AI, Technology & Digital Courses
- Advanced Data Management for Oil and Gas Professionals
- Advanced Visualization with Power BI Training
- AI Application for Utility Training Course
- AI for Data Analytics and Business Intelligence
- AI-Driven Simplification of Work Processes and Procedures
- AI for Event Planning & Management
- AI-Powered Data Visualization Course
- AI-Powered Project Planning & Execution for Success