Technical Softwares
Data Analysis Mastery with Microsoft Excel: Advanced Formulas, Functions and Pivot Tables
Data Analysis Mastery with Microsoft Excel: Advanced Formulas, Functions and Pivot Tables
Data Analysis Mastery with Microsoft Excel: Advanced Formulas, Functions and Pivot Tables is a 5 Days executive education programme delivered in Bangkok, Thailand. Practical frameworks, case studies, and facilitator-led workshops help participants apply learning at work.
Start date
5 April 2027
Duration
5 Days
Location
6 venues
Rating
0.0 / 5
Technical Softwares
Data Analysis Mastery with Microsoft Excel: Advanced Formulas, Functions and Pivot Tables
Dates & venues
14 scheduled deliveries from the live catalogue · 10 upcoming, 4 past
Upcoming dates
Open for registration5 April 2027
5 April 2027
19 April 2027
10 May 2027
10 May 2027
7 June 2027
7 June 2027
28 June 2027
26 July 2027
4 October 2027
Past dates
Already completedThese deliveries have already taken place and are shown for catalogue history only.
6 April 2026
Past dateBangkok, Thailand5 Days · $1,590
11 May 2026
Past dateBangkok, Thailand5 Days · $1,590
22 June 2026
Past dateBangkok, Thailand5 Days · $1,890
27 July 2026
Past dateBangkok, Thailand5 Days · $1,890
Programme essentials
Level
Professional
Language
English
Certificate
BCTCI Certificate of Completion
Group size
Up to 12
Need help registering?
About this course
Data Analysis Mastery with Microsoft Excel: Advanced Formulas, Functions and Pivot Tables is a 5-day professional programme designed for specialists and managers working in Technical Softwares. The course builds practical capability in Data Analysis Mastery with Microsoft Excel, Advanced Formulas, Functions, and Pivot Tables, using consultant-led workshops, real organisational cases, and tools you can apply immediately after the classroom. Participants leave with a structured implementation plan aligned to their role and to organisational priorities.
Learning objectives
What participants will be able to do after the programme.
- Explain the core principles, standards, and decision points that underpin Data Analysis Mastery with Microsoft Excel: Advanced Formulas, Functions and Pivot Tables.
- Configure, operate, and troubleshoot the core components covered in Data Analysis Mastery with Microsoft Excel: Advanced Formulas, Functions and Pivot Tables.
- Diagnose performance gaps and select the right tools for Advanced Formulas, Functions.
- Design an implementation roadmap that connects Lunch & Refreshment with measurable results.
- Communicate recommendations clearly to colleagues, executives, and external partners.
- Evaluate risks, trade-offs, and quality criteria related to Pivot Tables.
Personal impact
How this programme develops the individual professional.
- Gain confidence handling complex data analysis mastery with microsoft excel issues without waiting for specialist support.
- Strengthen your professional credibility when advising managers and stakeholders on lunch & refreshment.
- Expand your toolkit for advanced formulas, functions with methods you can use in the next working week.
- Build a personal action plan that links new skills to your current responsibilities and career goals.
Organizational impact
Benefits your organisation gains from this training.
- Improve consistency and quality of data analysis mastery with microsoft excel practice across teams and units.
- Raise system reliability, security, and operational readiness of technical teams.
- Enable knowledge transfer so technical softwares capability does not sit with a single individual.
- Support organisational strategy with practical tools for pivot tables and performance follow-up.
Programme outline
Day-by-day structure of the classroom sessions.
- 1
Day 1
Foundations of Data Analysis Mastery with Microsoft Excel
- 1Context, challenges, and success criteria for Data Analysis Mastery with Microsoft Excel: Advanced Formulas, Functions and Pivot Tables
- 2Core concepts and language of Data Analysis Mastery with Microsoft Excel
- 3Diagnostic exercise using participants’ real work situations
- 2
Day 2
Advanced Formulas, Functions
- 1Tools and methods for Advanced Formulas, Functions
- 2Applying Lunch & Refreshment and Accommodation in a facilitated case
- 3Group exercise, feedback, and translation to your organisation
- 3
Day 3
Pivot Tables
- 1Tools and methods for Pivot Tables
- 2Applying Lunch & Refreshment and Accommodation in a facilitated case
- 3Group exercise, feedback, and translation to your organisation
- 4
Day 4
Pivot Tables
- 1Tools and methods for Pivot Tables
- 2Applying Lunch & Refreshment and Accommodation in a facilitated case
- 3Group exercise, feedback, and translation to your organisation
- 5
Day 5
Integration, practice, and workplace action planning
- 1Integrated case or simulation drawing on the full programme
- 2Peer review of draft workplace solutions
- 3Personal and organisational action plans, next steps, and certification briefing
Training methodology
How learning is delivered in the classroom.
- Consultant-led briefings that connect concepts to live systems and decision contexts
- Guided demonstrations and structured hands-on practice
- Scenario labs based on typical organisational constraints
- Peer troubleshooting and structured debriefs
- Workplace application planning with checklists and reference templates
- Classroom delivery with collaborative activities and direct facilitator coaching
Main takeaways
Key outcomes participants leave with.
- Takeaway 1A practical working knowledge of Data Analysis Mastery with Microsoft Excel: Advanced Formulas, Functions and Pivot Tables
- Takeaway 2Ready-to-use approaches for Lunch & Refreshment and Accommodation
- Takeaway 3Applied competence in Exposure Visit
- Takeaway 4Applied competence in Accommodation
- Takeaway 5Applied competence in Lunch & Refreshment
- Takeaway 6Templates, checklists, or decision aids for data analysis mastery with microsoft excel
- Takeaway 7A 30–90 day implementation plan agreed during the programme
Course essentials
Key facts for planning attendance and registration.
- Duration
- 5 Days
- Format
- Classroom
- Level
- Professional
- Location
- Bangkok, Thailand
- Language
- English
- Certification
- BCTCI Certificate of Completion
- Prerequisites
- Open to professionals with relevant experience
- Class size
- 12
- Delivery
- Classroom
Course Brochure
Not available yetThis course does not have a brochure PDF uploaded yet. Leave your details and our team will follow up.
No brochure file is available for this programme yet. Request one and our team will prepare and send the details to you.
We will contact you by email (and WhatsApp if provided) once it is ready.
Training Materials
Download course handouts, slides, and reference documents shared by your trainer.
Course Questionnaire
Assess your learning progress