Step 1: Set Up Your Transaction Table

1. Create headers: In row 6, add columns for Date, Description, Category, and Amount.
2. Populate transactions: Enter your income (positive values) and expenses (negative values) in the Amount column.
3. Convert to a table:
   1. Select your data range (including headers).
   2. Press Ctrl+T or go to Insert > Table.
   3. Check “My table has headers” and click OK.
   4. Rename the table Transactions in the Table Design tab.
4. Format currency: Select the Amount column and apply the Accounting format from the Home tab.

Step 2: Build Your Summary Section

1. Starting balance: In A1, type Starting balance. In B1, enter your initial balance.
2. Income summary: In A2, type Income. In B2, enter:
   =SUMIF(Transactions[Amount],”>0″)
3. Expenses summary: In A3, type Expenses. In B3, enter:
   =SUMIF(Transactions[Amount],”<0")
4. Final balance: In A4, type Final balance. In B4, enter:
   =B1+B2+B3

Result: Your sheet now updates automatically as you add new transactions. No manual recalculations needed.

Step 1: Create Your Task Table

1. Headers: In row 1, add columns for Task, Due, Priority, and Status.
2. Populate tasks: Fill in your tasks and due dates.
3. Convert to table: Select your data, press Ctrl+T, name it Tasks, and check “My table has headers.”

Step 2: Add Data Validation for Priority and Status

1. Priority:
   1. Select the Priority column (excluding headers).
   2. Go to Data > Data Validation.
   3. Set Allow: List and Source: High,Medium,Low.
2. Status: Repeat the process for the Status column with Not Started,In Progress,Complete.

Now, you’ll see dropdown menus to quickly update priorities and statuses.

Step 3: Highlight Overdue Tasks

1. Select the Due column (excluding headers).
2. Go to Home > Conditional Formatting > New Rule.
3. Choose Only format cells that contain.
4. Set Cell Value <= and enter:
   =TODAY()
5. Click Format, select a red fill, and click OK.

Result: Tasks due today or in the past will automatically turn red, making them impossible to miss.

Step 1: Build Your Inventory Table

1. Headers: In row 1, add columns for Item, Category, Stock, and Minimum.
2. Populate data: List your items, current stock levels, and the minimum quantity you want to maintain.
3. Convert to table: Select your data, press Ctrl+T, and name it Inventory.

Step 2: Add an Automatic Stock Check

1. Insert a new column named Status (Excel will auto-expand the table).
2. In the first Status cell, enter:
   =IF([@Stock]<[@Minimum],"Restock","OK")
3. Drag the formula down to apply it to all rows.

Result: Cells will display “Restock” if stock is below the minimum threshold.

Step 3: Add a Slicer for Quick Filtering

1. Click anywhere in the table and go to Table Design > Insert Slicer.
2. Check Status and click OK.
3. Click Restock in the slicer to view only low-stock items.
4. Click Clear Filter to reset.

Result: Instantly switch between full inventory and “restock only” mode with one click.

Step 1: Build Your Expense Table

1. Headers: In row 1, add columns for Item, Cost, and Buyer.
2. Populate expenses: Enter shared costs and who paid for each.
3. Convert to table: Select your data, press Ctrl+T, name it Expenses, and format the Cost column as Accounting.

Step 2: Create a Balances Table

1. New columns: Insert headers for Name, Paid, and Balance to the right of your Expenses table.
2. Populate names: List all participants in the Name column.
3. Convert to table: Select the range, press Ctrl+T, and name it Balances.
4. Calculate paid amounts: In the first Paid cell, enter:
   =SUMIF(Expenses[Buyer],[@Name],Expenses[Cost])

   Format as Accounting.

5. Enable totals: In the Table Design tab, check Total Row.

Step 3: Calculate Who Owes Money

1. In the first Balance cell, enter:
   =[@Paid]-Balances[[#Totals],[Paid]]
2. Format as Accounting.

Interpretation:

• Positive balance: The person paid more than the average and is owed money.
• Negative balance: The person owes money to the group.