Advanced Excel Training in Kubwa, Abuja
Go from everyday Excel user to the person everyone asks for help. This course covers the advanced formulas, analysis tools and reporting techniques used in finance, operations and management roles.
About this course
Go from everyday Excel user to the person everyone asks for help. This course covers the advanced formulas, analysis tools and reporting techniques used in finance, operations and management roles.
You finish by turning raw data into an interactive dashboard.
What you'll learn
- Use advanced functions such as XLOOKUP, INDEX/MATCH, IFS and nested formulas
- Analyse data with PivotTables, slicers and what-if tools
- Clean and combine data with Power Query
- Build interactive dashboards and professional charts
- Protect and share workbooks safely
Course outline
1 Advanced formulas
- Lookup functions
- Logical and nested formulas
- Text and date functions
2 PivotTables
- Building and grouping PivotTables
- Calculated fields
- Slicers and timelines
3 Data analysis tools
- Power Query basics
- Goal Seek and scenarios
- Data validation
4 Dashboards and charts
- Dashboard design
- Dynamic charts
- Conditional formatting
5 Final project
- Build an interactive dashboard from raw data
Who this course is for
- Accountants, analysts and admin staff
- Managers who report on figures every week or month
- Anyone who already uses Excel and wants to go further
Tools you'll use
Requirements
Comfortable with basic Excel: entering data, simple formulas and formatting.
Frequently asked questions
Which version of Excel should I use?
Microsoft 365 or Excel 2019 and later work best, because some newer functions such as XLOOKUP are not in older versions.
How is this different from the Data Analysis courses?
This course goes deep into Excel. The Data Analysis courses go further into SQL, Power BI and Python.
How much does the Advanced Excel Training cost?
Send us a message on WhatsApp and we'll reply with the current fee for the Advanced Excel Training, the available class times and the next start date.
Can I take this course online?
Yes. We offer both in-person classes at our Kubwa centre and live online classes, so you can choose what suits your schedule and location.
Will I get a certificate?
We issue certificates for most of our courses. Ask us when you enrol and we will confirm the certificate for this course.
Ready to start Advanced Excel Training?
Message us on WhatsApp and we'll send you the current fee, class times and the next start date.