Microsoft Excel is an excellent way to manage your home budget

Microsoft Excel is an excellent way to manage your home budget

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Microsoft Excel is an excellent way to manage your home budget. It has many different types of formulas to be use to help accurately calculate your budget. The auto sum formula is the best one to use when calculating your expense. If you are doing an annually budget using the average formula will help u get the average you gain or loss for the year. If I was creating my own budget I would use separate spread sheets for each month then consolidate all the monthly expense in a separate annual spread sheet. I would use the auto sum and average formula to accurately calculate my gains and losses for the month and year. I would compile all my monthly expenses on a pie chart. But I would use an x y (scatter) chart for the
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: year to see the fluctuation from month to month. There are many different types of charts that can be used with Microsoft Excel. Bar chart, pie chart, line chart, scatter chart, column chart, stock chart, doughnut chart just to name a few. Whatever you need to itemize far as expense Microsoft Excel has a chart to fit your needs. You may also need to use the word art to help you not forgot why and expense was more for that month then the others. Or if you want to point out which was your most costly expense for the month or year....
View Full Document

Ask a homework question - tutors are online