A sales book in Excel is a tool to track all sales transactions. It records details like dates, customers, products or services, prices, and payments, making it easier to manage and analyze sales data for better decision-making.