Category: Excel Guides

shape
shape
shape
shape
shape
shape
shape
shape
Standard

How to Make a RACI Chart in Excel: Template With Checks

A RACI chart is a simple table that shows who does what in a project. RACI stands for Responsible, Accountable, Consulted and Informed. Each task is a row, each person or team is a column, and each cell holds one of the four letters or stays empty. The chart removes confusion, because everybody can see

Standard

How to Make a Sales Forecast in Excel: FORECAST.LINEAR, Growth Rate and Moving Average

A sales forecast is an estimate of how much you will sell in the coming weeks, months or quarters. It helps you plan stock, staff, cash and targets. Excel is a good tool for it, because it can apply simple, well-known methods to your past sales in a few formulas. This guide shows three methods:

Standard

How to Make a Petty Cash Log in Excel: Template With Running Balance

Petty cash is a small amount of cash that a business keeps for minor expenses such as stationery, courier fees, tea and snacks. Because it is cash, it is easy to lose track of, so every payment and every top-up should be written down. A petty cash log in Excel does this simply. It lists

Standard

How to Make a Leave Tracker in Excel: PTO Balance With Formulas

A leave tracker, also called a PTO tracker, records how many days of paid time off each employee has, how many they have taken, and how many remain. Small businesses and teams often keep this in Excel because it is free, flexible and easy to share. A good tracker has two parts: a log where