Author Archive for admin

The Five Best Things to Do This Easter Holiday

Published
by
admin
on April 9, 2020
in Other Articles
. 0 Comments

It’s Easter Easter EggsWeekend. The weather is shining but we’re all still on Lockdown. We can’t take a mini-break or even go to the park, so what are we going to do? The good news is there are still plenty of things to do to make this a real Bank Holiday weekend to remember.

 

Here are five things to do (with not a Box-Set in sight) to keep you in the Bank Holiday Spirit:

 

1. Tour Historic Buildings and Museums
You may not be able to get to them, but it’s still possible to virtually tour a large number of cultural venues, from the British Museum to the National Gallery and even the Houses of Parliament. It’s worth checking if your favourite venue has a virtual tour and even if it doesn’t, there is still something to suit every taste, such as the RAF Museum.

 

2. Create a virtual pub quiz for your friends and family
Virtual quizzes have become the new big thing. If you haven’t already had on, then host one for the Bank Holiday and invite your friends and family to join you on your preferred video app. The great news is that everyone brings their own bottle and washes their own glasses!

 

3. Take Some Virtual Tennis Lessons
If you are already a keen player, or even a complete novice, the LTA (Lawn Tennis Association) have put together a series of 12 videos with moves that can be practiced in your own garden. They are aimed at children, so will suit a complete beginner, but will also still help to keep that two-handed backhand as deadly as it ever was.

 

4. Bake Your Own Bread
Everyone’s baking bread in Lockdown, from Stephen Fry to Holly Willoughby. Here at Infero, we even have our own resident ex-baker. There are hundreds of recipes out there, including ones which only use what most of us already have in the back of our cupboards. Why not have a go yourself? Who knows, maybe you’re the next Paul Hollywood or Mary Berry!

 

5. Sit Down to Watch Some Stand-Up
Watch some of the UK’s best comedians without even paying an entrance fee. ‘The Stay at Home Festival’ runs from Friday 10th to Sunday 12th. There are live shows both during the day and later at night and acts include Isy Suttie and Josie Long.

 

Whatever you do have fun. The Easter Bunny had been designated as a Key Worker, so it will all be ok.

Microsoft Excel Tips: Absolute Referencing

Published
by
admin
on January 7, 2015
in Microsoft Excel Tips and Tips and Tricks
. 2 Comments

Absolute Referencing is a forgotten tool in your Toolbox called Excel. Daily you will probably find yourself using the fill handle on excel to automatically fill tables. This is called Relative Referencing and this will change the formula/function in a cell depending on which way you drag the cell.

 

So the example below we have a Product List at a made up computer company.Absolute Referencing 1

 

 

As you can see in the Total Quantity Price column I used the fill handle to drag my formula down the formula to the other rows to fill in the column. Because I dragged the fill handle down the numbers row numbers increased 1 at a time.
Absolute Referencing 2

 

 

Absolute Referencing allows us to lock a formula in a cell. Let’s see this in another example.

 

I’ve extended my table and added a Price After Tax column. This column uses the 20% (or 0.2) number in cell H1 to add the Tax onto the Price. Using the $ before both the H and the 1 you are able to “lock” this cell down. So when you use the fill handle the cell wont change.

 

Instead of typing the ‘$’ in the formula you could press the F4 key on your keyboard to automatically add the ‘$’ to that cell reference.

Microsoft Project Tips: How to Create a Milestone

Published
by
admin
on December 22, 2014
in Microsoft Project Tips and Tips and Tricks
. 0 Comments

Sometimes you may want to mark major event in a project, for example indicate the beginning and end of the project or display the end of a major phase. You can use milestones to do that. To create a milestone follow the steps:

 

  1. In Gantt Chart View, in the Task Name column, type the name of a milestone
  2. In the Duration column type 0 and press ENTER

 

In the Gantt Chart the task will be displayed as a black diamond symbol ♦.

 

Want more tips? Click on Microsoft Project Tips and Tricks

Microsoft Project Tips: How to Unhide Columns in a Gantt Chart

Published
by
admin
on September 9, 2014
in Microsoft Project Tips
. 16 Comments

Unlike Microsoft Excel, Project doesn’t have an unhide feature. When you hide a column in Microsoft Office Project, the column is only removed from view, not deleted from your plan. Also, hiding a column doesn’t remove any information from your plan.

 

To bring the column back again, you need to insert the column like you would with any new column. Any custom formatting that you applied to a previously hidden column will need to be re-applied to the inserted column.

 

  1. In a sheet view, select the column to the right of where you want to show the column.
  2. On the Insert menu, click Column.
  3. Select the Field name you would like to display.