Category: Excel Guides

shape
shape
shape
shape
shape
shape
shape
shape
Standard

How to Make an Attendance Sheet in Excel: Monthly Tracker With Formulas

An attendance sheet records who was present, absent or on leave on each day, and calculates totals and percentages for you. Teachers, managers and small business owners use it for classes, shifts and projects. In Excel you can build one in under an hour: a row of dates across the top, a list of names

Standard

How to Collapse Rows in Excel: Group, Outline and Hide Rows

Collapsing rows lets you hide the detail in a long worksheet and show only the headings or totals, then expand the detail again when you need it. Excel does this with the Group feature, which adds small plus and minus buttons next to the row numbers. It is ideal for financial statements, project plans, budgets

Standard

Excel Formula Not Calculating? 9 Fixes for Formulas That Show Text or Do Not Update

You type a formula, press Enter and nothing useful happens. Either the cell shows the formula as text, or it shows an old result, or it returns zero, or it refuses to update when you change a number. These problems have a small number of causes, and each has a quick fix. This guide lists

Standard

How to Make an Inventory Tracker in Excel: Stock Levels, Reorder Alerts and Value

An inventory tracker tells you what you have in stock, what is running low and what the stock is worth. Small shops, online sellers and workshops can run a reliable system in Excel without buying special software. This guide shows how to build an inventory tracker step by step, using a small product list that