Coastal Soul Kenya Ltd
Role Overview
We are seeking a highly skilled Microsoft Excel Specialist to design, optimise, and automate a suite of Excel worksheets that support our booking, operations, sales, and reporting workflows.
This role is ideal for a detail-oriented problem solver who enjoys turning complex processes into clear, efficient, and user-friendly systems. In addition to building the sheets, the specialist will train our internal team to confidently use and maintain them.
This is a fully remote role, working closely with our management and operations teams.
Key Responsibilities
-
Design and build advanced Excel worksheets for:
-
Bookings and inquiry tracking
-
Guest and client databases
-
Sales performance and revenue tracking
-
Operations, transfers, and accommodation coordination
-
Automated reporting and dashboards
-
Implement smart automation using:
-
Formulas, logical functions, and lookups
-
Data validation, conditional formatting, and drop-downs
-
Pivot tables and dashboards
-
Basic to advanced macros (where necessary)
-
Ensure sheets are:
-
Intuitive and easy to use for non-technical staff
-
Well-structured, scalable, and documented
-
Test all workflows to ensure accuracy, reliability, and efficiency
-
Train staff through live sessions, walkthroughs, and clear user guides
-
Provide post-delivery support for refinements and improvements
Required Skills and Experience
-
Advanced proficiency in Microsoft Excel
-
Strong command of:
-
VLOOKUP/XLOOKUP, INDEX-MATCH
-
IF, COUNTIFS, SUMIFS, logical formulas
-
Data validation and conditional formatting
-
Pivot tables and charts
-
Experience designing Excel systems for business operations, sales, or bookings
-
Ability to translate real-world workflows into structured Excel solutions
-
Excellent documentation and training skills
-
Strong attention to detail and data accuracy
-
Ability to work independently and meet deadlines in a remote setup
Nice-to-Have Skills
-
Experience with:
-
Excel dashboards and performance tracking
-
CRM-style Excel databases
-
Google Sheets (bonus)
-
Previous work with travel, hospitality, real estate, or service-based businesses
-
VBA / Macros knowledge
What We Offer
-
Fully remote work arrangement
-
Clear project scope and collaborative working style
-
Opportunity for ongoing projects as our systems evolve
-
Competitive project-based remuneration
-
A chance to build systems used by a fast-growing premium travel brand
How to Apply
Interested candidates should apply with:
-
A brief introduction
-
Examples or screenshots of Excel systems you have built
-
Availability and expected project rate
To apply for this job please visit en-ke.whatjobs.com.