Using Rehearse Timings in Powerpoint

After all your hard work developing your slides, it’s definitely worth running through the whole presentation to see how long the whole presentation takes.  This is the opportunity to edit down the slides if you find you are over-running or finetune your speaker’s notes to help you run to time.

With your presentation open, select the Slide Show tab.

Slide-show-tab-advanced-powerpoint
The Slide Show tab has everything you need to make your presentation run to time.

Select the Rehearse Timings in the Set up section of the Slide Show tab.  This function will run the presentation in full screen view, recording the timings.  So when you click N for the next slide, the timer will start afresh for the next slide.  When you reach the end of your presentation, you can view the timings for each of the slides.

slide-show-with-rehearse-timings-listed-advanced-powerpoint
The individual timings for the slides are shown underneath each one.

It is a really useful tool to help you prepare your presentation and feel more confident with your delivery on the day. To build on these tips, there are more functions detailed in our  PowerPoint intermediate/advanced course part of our range of PowerPoint training courses London.

 

 

 

 

How to add months to a date in Excel 2010 using a simple formula

In one of my earlier blog posts, I looked at how an Excel formula can add working days to a date.  This was for a manager who wanted to set up deadlines for the tasks to be completed within the team’s appraisal meetings.

I want to build on this and find out how to add a number of months to a date.  I was feeling brave, but despite my best efforts, I spent ages trying to figure it out, and then resorted to asking the trainer for advice via our forum.

So back to my example of the manager who wants to add follow up meeting dates.

  • He has conducted the appraisal meetings with each team member, and at that meeting he has agreed a review date for each team member.
  • He has decided to sets their review date in 3 months.

Here is the worksheet ready for the formula:

appraisal-follow-up-one-day-excel-course-london
The appraisal meeting date is set, and now the manager wants to add a follow up meeting in three months.

The easiest way to add three months to the meeting date is to use a formula with the months expressed as number of days (3 x 31 days = 93).

So the formula will be = the meeting date in column F + 93 days.

The manager can add the formula to the first team member’s details, and then copy the formula down the column for the remaining staff.  The first row will be =F3+93

add-three-months-to-date-one-day-excel-course-london
The manager has added the formula so the follow up meeting dates are automatically updated.

If the manager has to reschedule the appraisal meeting date, the formula will automatically update the follow up meeting date.  Phew.

If you are looking to get more out Excel formulas and functions, these are included for all levels in our one day course Excel London.  https://www.stl-training.co.uk/microsoft/excel-training-london.php