Category Archives: Excel

Useful Site of Excel Functions

Excel is such a useful program but many people using it only scratch the surface. One of the most useful things about Excel are its functions for doing calculations. They are basically built in formula to work out everything from … Continue reading

Posted in Excel, Excel Functions, Microsoft Office | Tagged , , , , | Leave a comment

Mail Merge Using Microsoft Word and Excel

We see it everyday, personalised emails, letters and brochures sent to us. It makes it feel like someone has made the extra effort to write to us. As it happens this is quite easy to do using a feature in … Continue reading

Posted in Excel, Microsoft Office, microsoft word, Office 2010, word, word 2010 | Tagged , , | 1 Comment

How to Use the SUMPRODUCT Function in Excel

Many people will have at least two columns or rows of numbers that first need multiplying together and then totalling up. In most cases they will create a formula that multiplies them together and then use the SUM function to … Continue reading

Posted in Excel, Excel Functions, Microsoft Office | Tagged , , , , , | Leave a comment

Using the SUMIFS Function in Excel

I would say one of the first things people learn in Excel is how to total up a column or row of numbers. This is done very simply by using the SUM function. The AutoSum button in most cases does … Continue reading

Posted in Excel, Microsoft Office, Office 2010 | Tagged , , , , | Leave a comment

Counting Empty Cells in Excel Using the COUNTBLANK Function

So you might be aware of some useful functions that allow you to count up how many cells have text or a value in it using the COUNT function, you can also count cells based on specific criteria using COUNTIF … Continue reading

Posted in Excel, Microsoft Office, Office 2010 | Tagged , , , | Leave a comment

Open Favourite Documents Quickly in Word, Excel, PowerPoint and Access

We all have documents we use regularly and even though they conveniently appear on our recent file list we can make them even more prominent. This can be done by pinning these files in the recent files list. This is … Continue reading

Posted in Excel, Microsoft Access, Microsoft Office, microsoft word, Office 2010, PowerPoint, windows 7, word, word 2010 | Tagged , , , , | Leave a comment

Excel: How to Create a Custom Function

Excel has lots of built-in functions that do everything from summing up a column or row of numbers to loan repayments, statistics, engineering, trigonometry and so much more. Every now and again someone asks how they can create their own … Continue reading

Posted in Excel, VBA, Visual Basic for Applications | Tagged , | Leave a comment