Creating a Simple Budget in Excel with a Pie Chart
Six Minutes. Smarter. Six Minutes. Smarter.
54.2K subscribers
2,250 views
0

 Published On May 18, 2023

I'm sorry about the audio. I didn't notice that my recording was using the webcam mic.

In this tutorial video, Ralph walks you through the process of creating a budget using Microsoft Excel. This tutorial is specifically designed for #CIS101 IT Orientation and #CIS120 Computer Concepts. Ralph starts by showing a screenshot of a college student budget and explains that he will guide you in creating a similar budget in Excel. He emphasizes the importance of saving the worksheet in a location that is easily accessible. Ralph then proceeds to input the necessary labels and values for income and expenses, demonstrating how to use formulas to calculate the totals. He formats the cells and applies accounting style to the numbers. Ralph also explains how to create a pie chart to visualize the expense categories. He discusses formatting options for the chart and shows how to add data labels and customize their appearance. Lastly, he mentions the concept of a zero-based budget and encourages including savings as an expense category. Ralph concludes by providing tips on what to include in the budget and reminds viewers to save their work. Follow along with Ralph's instructions to create your own college student budget in Excel.

Don't forget to like and subscribe for more helpful tutorials in IT and computer concepts!

show more

Share/Embed