Category Archives: Office 2010

How to Select Visible Cells in Excel

If you have every copied cells in a range that has some hidden rows our columns you soon discover that the hidden data gets copied too. Same applies to other features including subtotals. What would help is a command or … Continue reading

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

Add Video to a PowerPoint Presentation

Whenever you go to a presentation it seems that most of the time they are using PowerPoint to help get their message across and adding video can certainly help. Video has certainly become easier to create even using your phone … Continue reading

Posted in Microsoft Office, Office 2010, PowerPoint, video | 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

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

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