Category Archives: Microsoft Office

Useful Site of Excel Functions

Posted on December 11, 2014 by garysch

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

Posted on November 2, 2014 by garysch

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

Posted on October 19, 2014 by garysch

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

Posted on September 16, 2014 by garysch

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

Posted on September 15, 2014 by garysch

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

Showing the Last Saved Date of a Word Document

Posted on September 12, 2014 by garysch

There are things that are handy in Word that we can get to display automatically in the body text of a document, header and/or footer like the current date, page number, author, file location etc. This week I was asked … Continue reading →

Posted in Microsoft Office, microsoft word, word, word 2010 | Tagged , , , | Leave a comment

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

Posted on August 12, 2014 by garysch

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

Posted on May 29, 2014 by garysch

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

Posted on May 27, 2014 by garysch

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

Removing Timings from PowerPoint Slides

Posted on May 13, 2014 by garysch

One of the nice things about PowerPoint is that you can add timings to your slides so that  they can change automatically. This is great if you just want to leave it running or if you have rehearsed your presentation … Continue reading →

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