Category Archives: Microsoft Office

The Trick to Moving PowerPoint Presentations from a Mac to a Windows PC

I hear this all to often “I’m not getting a Mac again as I can’t use my PowerPoint presentations on a Windows PC”. Well yes you can and the same applies from Windows to a Mac. I usually hear this … Continue reading

Posted in mac os x, Microsoft Office, PowerPoint | Tagged , , | Leave a comment

Creating an Index in Word

An index is an important way to reference key words or phrases in a Word document. It compliments a table of contents and allows your readers to look for something specific n Thankfully you do not need to type out … Continue reading

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

Creating a Table of Contents in Word

You know that feeling where you need to type up some instructions and you think it is not going to be too extensive but ends up being pages and pages, well that was one of the tasks when I recently … Continue reading

Posted in Microsoft Office, microsoft word, word, word 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

Selecting Data in Non-Adjacent Cells to Create Excel Chart

Creating charts in Excel is pretty straightforward and you can see how to that in this video, getting started with charts. What normally happens is you select a group of cells and then insert a chart but what do you … Continue reading

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

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