Mastering Excel

This book walks you through Excel step by step, from opening the program and learning its interface to building, formatting and printing complete tables. It starts with the core skills: entering text, numbers and formulas, copying and pasting, and freezing rows and columns. Then it moves on to cell formatting, number formats and conditional formatting.

Next it covers working with databases, including sorting, filtering, removing duplicate records and building scenarios, followed by functions such as Sum, Average, Max, Min, Count and IF, plus financial, math, text, and date and time functions. It closes with charts, macros and procedures.

The book suits beginners and needs no previous experience with Excel. By the end you will be able to design a payroll sheet, summarize your data with functions, present it in a chart, and record repeated actions as a macro.