AI for Quick Excel & Data Entry Skills
Automate Excel tasks, clean messy data, create formulas and build dashboards using AI. Learn prompts for pivot tables, VLOOKUP, conditional formatting and data validation — with workflows for accounting, inventory management and reporting in Kenyan businesses.
What you will learn
Data entry and spreadsheet management are essential skills for any office worker. This course teaches you how to use AI to automate Excel tasks, clean messy data, create formulas, and build dashboards. You will learn prompts for common business tasks — pivot tables, VLOOKUP, conditional formatting, and data validation. The course covers both basic and intermediate Excel skills, with specific workflows for accounting, inventory management, and reporting. You will also learn how to use AI to troubleshoot formula errors and optimise spreadsheet performance.
2 sample prompts from this course
I need an Excel formula to [describe task, e.g. total sales per day from a column]. Give me the formula and explain each part in plain language.
My spreadsheet has [describe mess, e.g. names and phone numbers in one column]. Give me steps to split and clean it using Excel, with the formulas.
Unlock the full course for all 28 prompts, structured across 4 guided chapters.
Frequently asked questions
I barely know Excel. Is this beginner-friendly?
You describe what you want — 'totals in column D, split names into two columns' — and the AI writes the formula, VLOOKUP or pivot table instruction. You paste it in and see it work.
Can it help with business records like stock or payroll?
Yes, workflows cover accounting, inventory and reporting, with prompts for cleaning messy data and building simple dashboards.
Does it only work in Microsoft Excel?
Most guidance transfers to Google Sheets as well; where a function differs, the course notes the equivalent.
Related courses
This course is yours for KSh 550
Pay once via M-Pesa and the full course with 28 prompts lands on your WhatsApp within minutes, including free lifetime updates.