Collaborate with others with Excel online
Computers can make it easy to collaborate as a group on a project without having to be in the same room and Microsoft has provided an online version of Excel which is great for group projects. Unlike the desktop version of Excel which is installed and used on your computer, the simplified, free online version […]
Calculate a running balance
Running balances are useful for many things; cashbooks, credit card logs or any type of statement which has a running total or balance. Doing this in Excel is very simple and no special formula is needed. A running total in Excel is no different to a manual calculation on a printed ledger. Usually you have […]
Getting an Excel sheet ready to print
If your sheet has more columns than can fit on the width of a printed page, your information will be disjointed and difficult to read when printed. Thankfully Excel provides settings you can adjust so it prints out in a clear, professional and usable format. By default, Excel will print 9 columns and 50 rows […]
Fundamental Excel Formulas
Excel can be used for all sorts of things, but one thing it is very good at is calculations. This month we share some fundamental formulas so you never have to reach for your calculator again! The advantage of formulas is that they are live and automatically update if the information used in the calculation […]
Track Favorite Recipes in Excel
Excel is a handy tool for keeping track of your favorite recipes. You can use it to record recipe ingredients and instructions together with a photo of the dish. You can then easily find your favorite recipes at any time. This month we have a recipe tracking Excel worksheet for you. This worksheet helps you […]
Track Household Chores in Excel
If you like to keep track of household chores using a printed checklist, Excel can help. Using a simple chores list worksheet you can easily plan the week’s chores, print a copy and post it on the family noticeboard so everyone can see it. To help you out, we’ve located a handy Excel template for […]
Make Your Worksheets Look Great
Microsoft Excel is a handy tool for recording lists of items. Simply type your column headings and then type one item in each cell. The list will look neat and you will be able to see the items in it very clearly. Once you’ve typed your data, why not format the text to make the […]
Create a Diet and Exercise Journal in Excel
If you made a New Year’s resolution to get fit and healthy then a diet and exercise journal is a good way to go. Tracking your diet and exercise daily will help you stay on track and, over time, it will show you how far you have progressed. To help you out, we have created […]
Making Handy Conversions with Excel
Whether you want to know how many kilometres in mile or if you are trying to convert a recipe from imperial to metric you’ll often need assistance with the conversion. Excel has a convert function that makes it easy for you to make these calculations. This function can convert most of the values that you’re […]
How Much Will I Pay?
When you borrow to buy a house you’ll want to know how much you will have to repay each month. This month we’ll show you how to calculate mortgage repayments using Excel. When you are shopping for a new house you’ll want to know how much your loan is going to cost you each month. […]
