Microsoft 365
Advanced Excel: advanced functions, pivot tables and Power Query in Cameroon
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: Cameroon, Central African Republic, Chad, Côte d'Ivoire, France, Gabon, Republic of the Congo, Senegal
- In a virtual classroom: Cameroon, Central African Republic, Chad, Côte d'Ivoire, France, Gabon, Republic of the Congo, Senegal
This course in Cameroon
Onarcle offers the course "Advanced Excel: advanced functions, pivot tables and Power Query" in Cameroon, 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 Cameroon is FCFA 175,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 Cameroon, this course is designed for companies, institutions and professionals, in Douala, Yaoundé and across the country. It can be attended in a live virtual classroom or delivered at your premises for a group, with examples adapted to your sector.
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.
Frequently asked questions
How much does this course cost in Cameroon?
The price is FCFA 175,000 excl. VAT per participant in Cameroon. 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 Douala?
Yes. From Douala, 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 Cameroon?
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 Cameroon.
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.