# Insert a Picture into a Comment

Excel was created for the use of calculating and analysing huge amounts of data. Because of this it has never been great for storing large amounts of text or pictures. Inserting images into a cell would make the spreadsheet even larger and more awkward in its daily use.

Comments are fantastic for leaving notes for other users, but they can also be used to store pictures. These pictures can then be made visible when required rather than permanently displayed on screen within a cell.

# Troubleshooting Formulas

Written by Mynda Treacy of My Online Training Hub.

Writing formulas can have you tearing your hair out especially when you start nesting them. Here are 4 tips to help you troubleshoot when things go wrong.

This Excel badminton league table can be used to track team or player positions real time as results are entered into the spreadsheet.

This spreadsheet uses a few excellent Excel techniques for its functionality. These include;

To use the spreadsheet. Simply add the team or player names to the table on the Teams sheet and fixtures sheet (Find and Replace helps here), and then enter the results into the fixtures sheet.

# PowerPoint – Display Pop Up Text on Mouse Over

Display pop up text on mouse over of an image or some other object in your PowerPoint presentation. This creates a nice effect similar to what you experience on the web when you hover the mouse over an image.

By creating this pop up text window, the text is only displayed when the user hovers the mouse pointer over the image, rather than displaying it permanently on the slide. This will save space and can be great for interactive presentations such as quizzes.

# Using SUMPRODUCT Function to Count Records using Multiple Conditions

There are many ways to count records using multiple conditions in Excel. These can range from using the COUNTIFS function, PivotTables or by simply filtering the data. However neither of them are as flexible as the SUMPRODUCT function.

The SUMPRODUCT function is used to multiply the values of multiple arrays and then sum the totals. However it is capable of so much more amazing feats. It truly is one of those hidden gems waiting to be discovered.

# MS Project: View Resource Workload using the Team Planner

The team planner view was introduced in MS Project 2010. The view makes it easier to see your resources workload over time and to make changes.

Resources are shown in rows across a timescale just like in the Gantt Chart. You can see which team member does what and when at a quick glance. The task names are displayed inside the task bars.

Problems such as overallocations can be quickly identified. These problems can then be rectified usually by just clicking and dragging the task to a different resource, or to a different start date.

The fact that the team planner looks like a Gantt Chart for resources, and it allows you to make changes in the same way that you may already do so in MS Outlook, helps make this view easy to relate to.

# The New Eyedropper Tool in PowerPoint 2013

A brilliant new feature to PowerPoint 2013 is the eyedropper tool. The eyedropper tool allows you to match colours between objects on your slides. This could mean copying a colour from a picture and applying it to text on your slide.

This tool makes it easier to create fantastic looking cohesive presentations. Matching the colours of your fonts, images and other objects has never been so easy.

# Using the Eyedropper Tool

The example below shows the title slide in Slide Master View (Find out more about working with slide masters). Using the eyedropper tool we will copy the colour used for the text in the NST logo, and apply it to the slide title text currently in black.

# Macro in Excel – Loop Through all Files in a Folder using VBA

One of the main reasons to create a macro in Excel is to make a repetitive task easier and quicker. Such a task may be to loop through all files in a folder and perform an action on each one.

The code below will display the folder picker dialog box to allow the user to specify the folder (directory) that they want to use. It will then loop through all the files within that folder. It will open the workbook, perform an action and then close it saving the changes made.

Comments have been used to explain different areas of the code.

# Compare Two Lists in Excel to Highlight Matched Items

In this post we will look at how you can compare two lists in Excel to highlight matched or unmatched items. We will first identify the items that appear in both lists, and then look at how to highlight the items that appear in the first list but are missing from the second list.

The Match function will be used to compare both lists and will return if a record is found or is missing. The Match function returns the relative position of an item in a list. If it cannot find the item it will return the #N/A error message (learn more about the Match function).