When reporting still depends on Excel, inconsistent formulas, duplicate records, and version confusion can distort KPI reporting and management dashboards; training should focus on data cleaning, validation, and audit-friendly workbook design.
Abuja, Nigeria
Data Science, AI, and Advanced Analytics
Data Management, Manipulation & Analysis using Excel Training Course
Nigeria's purpose-built capital where government, tech, and culture converge for professional growth
5 Days
Duration
In-Person
Delivery
12 Dates
Available
Certificate
Included
Excel like a pro—transform raw data into strategic insights that drive results.
Upcoming In-Person Schedules in Abuja
Reserve Your Spot Today — Pay When You're Ready!
| Code | Start Date | End Date | Duration | Fee | |
|---|---|---|---|---|---|
| DMA-01 | Mon - Fri (5 Days) | USD 2,900 | Reserve my seat → Register my team → | ||
| DMA-01 | Mon - Fri (5 Days) | USD 2,800 | Reserve my seat → Register my team → | ||
| DMA-01 | Mon - Fri (5 Days) | USD 2,800 | Reserve my seat → Register my team → | ||
| DMA-01 | Mon - Fri (5 Days) | USD 2,800 | Reserve my seat → Register my team → | ||
| DMA-01 | Mon - Fri (5 Days) | USD 2,800 | Reserve my seat → Register my team → | ||
| DMA-01 | Mon - Fri (5 Days) | USD 2,800 | Reserve my seat → Register my team → |
Here's What You'll Learn
Each module tackles real challenges you face in your role
1
Excel as a Data Management Tool
2
Data Cleaning and Preparation
3
Essential Formulas and Functions for Analysis
4
Sorting, Filtering, and Conditional Logic
5
PivotTables and PivotCharts for Insight
6
Data Visualization for Impact
7
Advanced Data Analysis Tools
8
Automation with Macros and Power Query
9
Integrating and Linking Data
10
Building Interactive Dashboards
Market-specific guidance for Sri Lanka
A country-aware view of the pressures, proof points, and practical tools that shape how this course applies locally.
Tools and platforms relevant to this field
4Field-relevant examples that may be featured in training where they support the confirmed scope. Exact coverage depends on participant needs and delivery format.
-
Microsoft Excel MicrosoftThe standard tool for cleaning data, building formulas, summarizing records, and producing management reports.
-
Microsoft Power Query MicrosoftUsed to import, reshape, and combine data from multiple files or systems before analysis in Excel.
-
Microsoft Power Pivot MicrosoftUsed for data modeling and analysis when workbooks need relationships, larger datasets, or more robust reporting.
-
Power BI MicrosoftUsed to turn cleaned Excel data into dashboards and shareable management reports.
Training visit intelligence for Abuja
Practical notes for confirmed delegates: arrival, venue expectations, after-class options, and on-the-ground considerations.
Optional after-class stops
8
nature
Millennium Park
Abuja's largest public park with landscaped gardens, walking paths, and water fountains — ideal for a relaxing break between training sessions.
Learn more
heritage
Nigerian National Mosque
One of the largest mosques in West Africa, featuring striking golden domes and four minarets. Open to non-Muslim visitors outside prayer times.
heritage
Nigerian National Christian Centre
An architectural landmark adjacent to the National Mosque, symbolising the coexistence of faiths in Nigeria's capital.
culture
Nike Art Gallery, Abuja
A four-storey gallery housing over 8,000 artworks spanning traditional Yoruba textiles, paintings, sculptures, and contemporary installations.
leisure
Jabi Lake
A scenic 1,300-hectare artificial lake popular for boat rides, waterfront dining, and evening strolls with city-light reflections.
nature
Zuma Rock
A 725-metre monolith on the outskirts of Abuja, famous for its natural human-face pattern — a great half-day excursion for photography enthusiasts.
culture
Thought Pyramid Art Centre
A contemporary art space in Abuja hosting exhibitions, live events, and a restaurant, popular with both locals and visitors.
food
Nkoyo Restaurant
Located in Ceddi Plaza, Nkoyo serves authentic Nigerian cuisine including Jollof rice, suya, and plantains in a vibrant atmosphere.
Local demand signals 5
Sector-level context showing where this capability is relevant in Abuja.
Federal Government & Public Administration
As Nigeria's purpose-built capital, Abuja hosts the presidency, legislature, supreme court, and major regional bodies — delegates in governance, compliance, or policy training benefit from proximity to these institutions.
Information & Communications Technology
Nigeria leads Africa's ICT market. NITDA and NCC are headquartered in Abuja, and the Abuja Technology Village holds special economic zone status, making the city relevant for cybersecurity, digital economy, and telecom training.
Financial Services & Fintech
The CBN and SEC are based in Abuja, overseeing banking regulation, monetary policy, and capital markets — directly relevant for delegates in financial compliance, risk management, and audit training.
Oil, Gas & Energy Regulation
Nigeria's petroleum regulators and the national oil company are headquartered in Abuja, making it a key location for energy governance, HSE, and extractive-industry training.
Standards, Quality & Certification
SON is Nigeria's national standardisation and certification authority covering ICT, agriculture, energy, and manufacturing — relevant for delegates pursuing quality management or standards-related training.
Training venue
Abuja's central business districts (Wuse, Maitama, Central Area) offer international-standard hotels with conference and training facilities suitable for professional groups. Expect 4-star and above properties with reliable air conditioning, AV-equipped meeting rooms, and on-site catering.
Getting there
No direct Sri Lanka to Abuja service was confirmed in the search results. The verified routings shown are connecting options into Abuja’s Nnamdi Azikiwe International Airport (ABV), including via Doha on Qatar Airways and via other European hubs on SWISS or Lufthansa; typical total journey time is roughly 14–18 hours depending on the connection.
Visa
Nigeria replaced its Visa-on-Arrival system with a fully electronic e-Visa effective 1 May 2025. Delegates must apply and receive approval via the Nigeria Immigration Service e-Visa portal before travel; ECOWAS nationals remain visa-free for up to 90 days. Apply at least one week before departure — approvals typically take 24–48 hours.
Safety
Abuja is generally safer than Lagos but delegates should use registered taxis or ride-hailing services, avoid displaying valuables, and stay in well-known business districts after dark. Keep copies of travel documents separate from originals and monitor local advisories.
Internet
Reliability: average
Weather year-round
- Apr 37/26°C One of the hottest months as the rainy season begins. High UV index; sun protection essential.
- Jan 34/21°C Hot and dry with very low humidity (~21%); Harmattan haze may reduce visibility. Virtually no rainfall.
- Jul 30/22°C Peak wet season — frequent heavy showers, high humidity. Cooler than the dry months.
- Oct 32/22°C Tail end of the rainy season; showers tapering off. Warm and increasingly sunny.
Where this course runs
Data Management, Manipulation & Analysis using Excel Training is delivered in the cities below — pick the one that fits your schedule.
