Ms Excel Essentials for Data Analysis: Foundational Analytics, Functions & Productivity Techniques
Venue: Sarova Woodlands Hotel, Nakuru-Kenya
Date: 23rd - 28th November 2026
Cost: Kshs. 86,000 / USD 850
CPD points: 10
Overview
Build a solid foundation in spreadsheet analysis with this Ms Excel essentials for data analysis training. The program takes participants from basic data entry to confident use of formulas, functions, sorting, filtering, charts and PivotTables. Participants will learn to organize data, perform calculations, summarize information and present results clearly. Through step-by-step hands-on exercises, attendees will save time on everyday tasks and produce accurate reports. This program is essential for administrative staff, junior analysts and anyone who works with data in Excel.
Objectives
- Navigate Excel efficiently using shortcuts and tools
- Enter, format and organize data correctly
- Use core functions such as SUM, IF, COUNTIF and XLOOKUP
- Sort, filter and validate data
- Apply conditional formatting to highlight trends
- Create and format charts that communicate clearly
- Summarize data with PivotTables
- Protect and share workbooks securely
- Apply productivity techniques to everyday reporting
Target Audience
- Administrative and clerical officers
- Junior analysts and assistants
- Finance and accounts assistants
- HR and records officers
- Project and programme officers
- Anyone new to Excel analysis
Methodology
- Step-by-step hands-on Excel exercises
- Instructor demonstrations
- Real workplace data practice
- Formula building drills
- Chart and PivotTable labs
- Productivity tips sessions
- End-of-course practical assessment
