# Excel Mini-Course in 4 Minutes

Each of these short video tutorials covers an essential skill needed to make simple Excel budgets and charts.

You can watch all the videos to see how to create a budget and chart from start to finish or just watch the ones you need. Expand videos to full screen mode for better viewing.

Total Time = 4 minutes

## Example Budget with Expense Chart you can Make with These Tutorials:

1) First, type a title at the top, (Amy's Shopping Budget).

2) Then type your data in column A: (Allowance, Expense items)

3) Next, type your numbers in column B as shown below. No need to add dollar signs now, we'll do that later.

# Begin:

## 1) How to Adjust the Column Widths to Make More Room

Once all your data is entered, you may need to widen the columns to make room for long words or numbers. Here is how you do it.

## 2) How to Merge and Center the Spreadsheet Title

Spread your title across several cells and merge all the cells into one while centering the title.

## 3) How to Format the Budget Numbers with Dollar Signs

When you work with budgets, you need to change the numbers into the accounting format of dollars.

## 4) How to Calculate the Total Expenses or Money Spent using Autosum

Budgets need to show the total amount of all money spent (expenses) with accuracy. Use autosum to calculate these totals.

## 5) How to Calculate any Profit or Money Left Over in a Budget

Budgets show how much money you had, how much you spent and how much is left over (profit), if any.

## 6) How to Create the Chart with Your Data and Numbers

Charts are visual aids to help you analyze numbers or trends. Create a chart showing your expenses to see where the money went.

## 8) Improve Your Chart with a New Layout and Design

Add titles and labels to your charts with a new layout or design.