Learning Excel – 5 Awesome Date Functions in Excel

Do you want to advance your skills by learning Excel? Performing date calculations can sometimes be troublesome. Trying to calculate the number of working days between two dates, or automatically finding the date in two months’ time is not as straight forward as formulas with general numbering can be.

Fortunately Excel has a full repertoire of fantastic date functions. Here are five of the best.

Continue reading

Top 5 Essential Microsoft Powerpoint Tips and Tricks

Microsoft PowerPoint has revolutionized the delivery of presentations so much so, that it even has its own epidemic – ‘death by PowerPoint’.  This is not so much a result of using it to support presentation but relates to how people use it.  There can be no argument that if used correctly, PowerPoint can turn the most amateur of presentations into ones that are sleek, modern, and digitally useful.

Although PowerPoint training is recommended, here are some essential tips and tricks for anyone using PowerPoint 2010.

Continue reading

Basic Excel – 7 Buttons You Must Add to your Quick Access Toolbar

In the latest version of Excel it has become your responsibility (if you choose to) to create your own toolbar, and in our basic Excel series we show you how.

The Quick Access Toolbar at the top of your screen begins with just the Save, Undo and Redo buttons. If you require fast access to any other Excel commands you are able to add them yourself. You can add almost any functionality to the toolbar including those not found on the Ribbon.

As part of our basic Excel series, this post explores 7 incredible additions to the toolbar that are sure to improve the way you work.

Continue reading

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.

Continue reading

Excel Badminton League Table

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

Download the Excel badminton league table.

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.

Continue reading

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.

Continue reading

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.

Continue reading