Category Archives: Excel

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

VBA: Using the IF Statement

The IF statement is one of the most important concepts to use when programming, it is simply used all the time. The IF statement helps the program make decisions based on criteria you have set. So it can decided on … Continue reading

Posted in Excel, Microsoft Access, Microsoft Office, microsoft word, Office 2010, PowerPoint, VBA, Visual Basic for Applications | Tagged , , , , | 1 Comment

VBA: Understanding Variables

If you are getting into macros then you need to know about programming in Visual Basic for Applications (VBA) and with that you need to know about variables. VBA is a great tool for automating so many tasks in Microsoft … Continue reading

Posted in Excel, Microsoft Access, Microsoft Office, microsoft word, PowerPoint, Uncategorized, VBA, Visual Basic for Applications, word, word 2010 | 1 Comment

Syncing Office for iPad with Your Mac

If you have got Office for iPad you’ll have soon realised how useful it is and in my opinion better than the other programs that try and use Office files like Word, Excel and PowerPoint. You’ll also have noticed it … Continue reading

Posted in Excel, iPad, Microsoft Office, PowerPoint, word | Tagged , , , , | Leave a comment

Excel: Inserting, Editing and Deleting Comments

Excel can contain lots of information and sometimes it would be handy to add a note to various cells within the worksheet as reminders, things to check, how you created a formula or even where you got the resources for … Continue reading

Posted in Excel | Tagged , , , , , | 1 Comment

Protecting Worksheets in Excel

Protecting worksheets in Excel allows you to stop anything being changed on a worksheet or specifying that particular cells can be changed whilst others cannot. This is very useful if you want to make sure that certain cells are not … Continue reading

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