This topic is one that often baffles spreadsheet users. As beginners, our first priorities are learning to set up and format a spreadsheet but, eventually, there comes a time when we actually want to know how many times a particular value occurs. If we run a supermarket, someone might ask “how many different types of dairy product do we stock?” You know the information is there, on the stock list, but how can you get it out efficiently?
Visit this page to discover how to use the status bar for simple counts, averages and other numerical data values, and also how to use the COUNTIF function to count those elusive text data items.
You can make simple spreadsheets to keep records of stock, to add up figures, or to track household expenses. But, actually, spreadsheets are powerful tools, and you can do much more if you know a few simple skills. For me, some of the most useful techniques are filtering and sorting your data. Visit this page to discover how to do it.
How to Format an Excel Spreadsheet
If you know how to make simple spreadsheets, you are ready to find out how to improve the presentation of your data. Knowing how to format your spreadsheet, using number, financial and other formats, improves the way the spreadsheet looks, and can also increase it’s accuracy. You can format individual cells to show real dates and currency, as well as text. Visit this page to discover how to do it.
How to make a Household Expenses Spreadsheet
You can keep track of household or business expenses with a simple spreadsheet. Lots of people don’t know how much money they’ve got in the bank or how much they are spending. This can lead to debt, so tracking your expenses with a spreadsheet is a useful exercise for lots of us.
If you want to practice making spreadsheets, or to make a functional Household Expenses Spreadsheet, this page will show you how to do it. Later, you could adapt the spreadsheet to include other things, like income and taxes.
If you have never used spreadsheet software, first visit my page Spreadsheets for beginners where I show the basics of spreadsheets.
Spreadsheets for Beginners
Spreadsheets are computer programs that can be used for storing information, organizing it, and working with it. One example is a household budgeting worksheet that could be used to keep track of household expenses, like food and heating costs, and help with managing budgets.
Microsoft Excel is a spreadsheet program. The information and exercises in Spreadsheets for Beginners are designed for beginners who want to learn to use Excel, but can also be applied to other spreadsheet programs like Open Office Calc and Google Docs Spreadsheets.