Microsoft 365
Advanced Excel: advanced functions, pivot tables and Power Query in the Central African Republic
Analyse your data faster and without errors
Two days to take your Excel skills to the next level: lookup and conditional functions, structured tables, pivot tables, charts, Power Query and first automations.
- Duration
- 2 days · 14 hours
- Level
- Intermediate
- Format
- In-company · Virtual classroom
Upcoming sessions
This course is run on demand: in a virtual classroom or at your premises, on dates that suit you. Ask us for the next dates or a quote for your team.
Also available
- In-company, at your premises: Central African Republic, France
- In a virtual classroom: Central African Republic, France
This course in the Central African Republic
Onarcle offers the course "Advanced Excel: advanced functions, pivot tables and Power Query" in the Central African Republic, at your premises for a group (in-house), or in a live virtual classroom with the trainer. The programme, objectives and method are the same as in all our sessions: a practitioner trainer, exercises on real cases and an Onarcle certificate of completion.
The price in the Central African Republic is FCFA 585,000 excl. VAT per participant. For a group or a session at your premises, we provide a quote in local currency stating the applicable taxes and schedule.
In the Central African Republic, this course is designed for NGOs, international agencies, institutions, banks and companies, in Bangui and in the provinces. It can be attended in a live virtual classroom or delivered at your premises in Bangui for a group. Materials are provided as downloads, which helps when the connection is unreliable, and several partner organisations can join a shared session.
Overview
Most users only tap a small part of Excel. This course saves you hours every week: make your files reliable, combine data, build dynamic analyses and automate repetitive imports with Power Query.
Objectives
- Use advanced functions: XLOOKUP, nested IF, SUMIFS
- Structure data as tables
- Analyse with pivot tables
- Create readable charts and dashboards
- Import and clean data with Power Query
Who is it for?
- Regular Excel users
- Assistants, administrators, controllers, sales staff
- Managers who produce tracking spreadsheets
Prerequisites
Excel basics: data entry, simple formulas, formatting, sorting and filtering.
Programme
Module 1
Advanced formulas
- Absolute references and names
- XLOOKUP, INDEX, MATCH
- Conditional and statistical functions
Module 2
Reliable data
- Structured tables
- Data validation and drop-down lists
- Conditional formatting
Module 3
Analysing
- Pivot tables
- Slicers and timelines
- Charts and a mini dashboard
Module 4
Automating
- Power Query: import, clean, combine
- One-click refresh
- Introduction to macros and Copilot in Excel
Teaching method
Exercises on real cases, on your own files if you wish. Groups of up to 10 participants, in a virtual classroom or at your premises, with a practitioner trainer. For 30 days after the course, you can email your questions to the trainer.
What you receive
- Corrected exercise files
- Advanced functions cheat sheet
- Dashboard template
Assessment and certificate
Initial assessment, hands-on exercises and a final quiz. Certificate of attendance; Onarcle certificate of achievement from a 70% score on the final quiz.
Price and funding
Public course price per participant, materials included. In-company (up to 10 participants, programme tailored to your needs): €2,690 excl. VAT per group. 10% discount from 3 participants from the same organisation. If your employer or a funding body will pay, contact us and we will find the right arrangement.
Frequently asked questions
How much does this course cost in the Central African Republic?
The price is FCFA 585,000 excl. VAT per participant in the Central African Republic. For a group, a session at your premises or a funding application, contact us and we will send you a quote in local currency.
Can I take this course from Bangui?
Yes. From Bangui, the course is available at your premises for a group (in-house), or in a live virtual classroom with the trainer. Materials are provided as downloads.
Can this course be organised for our team in the Central African Republic?
Yes. For a group, we adapt examples and exercises to your sector and tools, and run the session at your premises or in a virtual classroom, depending on your constraints in the Central African Republic.
Enrolment and quotes
Book a place, request a quote or a session for your teams. We reply within 2 working days.
Software and brand names mentioned belong to their respective owners. Onarcle is an independent training provider, not affiliated with their publishers; this course does not award an official vendor certification.