It touches on examples for calculating a salespersonâs commission, looking up a table to retrieve employeeâs details such as contact number, salary, age, etc., analyzing the best mode of delivery for a package, retrieving supplierâs credit limit, and performing data validation for a given range or list. Yes, all this is possible using Microsoft Excelâs built-in functions, the main focus of this book.
The book assumes that the reader is already familiar with the basics of Microsoft Excel such as copying, editing, formatting, and performing basic calculations. It is highlighted with visual graphics wherever possible to enhance the understanding of the reader further.
Â