Excel & Google Sheets for Kenyan Accountants: Master Pivot Tables, VLOOKUP & Financial Dashboards to Land KES 80,000+ Bookkeeping Gig

Excel for Kenyan accountants is no longer optional — it is the single skill separating those stuck at KES 30,000 salaries from those earning KES 80,000 and above in freelance bookkeeping gigs across Nairobi, Mombasa, and beyond. If you graduated with a diploma or degree in accounting, commerce, or business from a Kenyan university or college, you already understand debits, credits, and trial balances. But when your employer or client hands you a messy dataset with 5,000 rows and asks for a financial dashboard by Friday afternoon, do you freeze? Do you still copy-paste figures manually, reconcile line by line, and spend entire weekends preparing VAT returns on Excel the hard way? You are not alone. Thousands of Kenyan accountants are trapped in junior roles because their spreadsheet skills never moved past basic SUM and AVERAGE formulas.

This book changes that completely. By the time you finish, you will be building dynamic Pivot Table reports that summarise an entire year's transactions in seconds. You will automate KRA iTax PAYE computations so accurately that your employer stops outsourcing payroll to expensive consultants. You will create a professional bookkeeping dashboard — complete with an income statement, balance sheet, and cash flow tracker — that makes SME owners in Industrial Area, Westlands, and Nyali want to hire you on the spot. And you will learn exactly how to package these skills into freelance bookkeeping gigs on Upwork, Fiverr, and Kenyan Facebook groups, charging anywhere from KES 15,000 per month for a small shop in Thika to KES 80,000+ for a mid-sized company in Nairobi's Upper Hill.

This book is written for you if you are the fresh CPA graduate in Juja wondering how to stand out in a flooded job market. It is for the junior accounts clerk in Nakuru earning KES 28,000 who knows there must be a faster way to prepare month-end reports. It is for the stay-at-home mum in Kitengela with an accounting background who wants to earn from home using just her laptop and Google Sheets. It is for the boda rider-turned-entrepreneur in Eldoret who manages his own books and wants to stop paying an external accountant KES 10,000 every quarter. And it is for the side-hustler in Ruiru who already has two bookkeeping clients but wants to triple that number without burning out.

Inside, you will master VLOOKUP, XLOOKUP, and INDEX-MATCH — the three functions that make senior accountants look like magicians. You will learn to build Pivot Tables and Pivot Charts that turn raw M-Pesa statements and bank exports into clear financial stories. You will create error-proof invoice templates with data validation and drop-down lists. You will automate KRA PAYE, NHIF, NSSF, and housing levy deductions in a single payroll sheet. And you will discover how Google Sheets collaboration features let you serve clients in Kisumu, Garissa, and Malindi without ever leaving your house.

Stop watching your peers land better-paying gigs while you struggle with spreadsheets the old-fashioned way. Download this book right now, pay KES 350 via M-Pesa, and get instant lifetime access on Virdap. Your next KES 80,000 bookkeeping client is one Pivot Table away.