Description

Microsoft Excel is the most widely used professional software tool in Kenya’s offices, businesses, banks, hospitals, and NGOs. Yet most people use barely 10% of what it can actually do. Excel Formulas & Functions For Dummies, 5th Edition by Ken Bluttman — the author of every edition of this definitive guide — is the book that finally closes that gap.

Whether you are a complete beginner intimidated by formulas or an intermediate user who wants to unlock Excel’s full potential, this step-by-step, jargon-free guide makes it genuinely easy to learn, apply, and master the functions that make Excel the most powerful tool in any professional’s arsenal.

What This Book Covers:

How formulas and functions actually work — explained in plain, clear language
The most essential and widely used Excel functions: SUM, AVERAGE, IF, VLOOKUP, INDEX/MATCH, COUNTIF, SUMIF, and dozens more
How to build formulas that calculate, analyse, and automate your spreadsheet work
Financial functions for evaluating investments, budgets, loans, and expenses
Date and time functions for project management and scheduling
Text functions for cleaning, formatting, and manipulating data
Logical functions for building smart, conditional spreadsheets
How to troubleshoot formula errors and fix broken spreadsheets with confidence
Statistical and lookup functions for data analysis at every level
How to evaluate and forecast investments and expenses using built-in Excel tools

Who This Book Is For:

Office professionals, administrators, and PAs who use Excel daily but want to use it better
Accountants, finance officers, and bookkeepers managing budgets and financial reports
Business owners tracking inventory, sales, and expenses in Excel
Students studying business, finance, IT, or data analysis
Job seekers wanting to add advanced Excel skills to their CV
Healthcare workers managing patient data, rotas, and clinical records in Excel
Anyone who has ever been frustrated by a formula that refuses to work

Why Excel Skills Matter in Kenya Right Now: In Kenya’s competitive job market, advanced Excel proficiency is one of the most in-demand and highly valued skills across every industry — from banking and finance to healthcare, NGOs, government, and entrepreneurship. Employers routinely list Excel as a requirement, and those who can go beyond basic data entry to build powerful formulas and automated reports command better opportunities and better pay.

At Ksh 100, this is the most affordable Excel upgrade your career will ever get.

Book Details: