Monthly Archive for July, 2021

National Picnic Month

As July is National Picnic Month, it encourages you to get out and about  and celebrate the warm summer days outdoors while enjoying some great food.

Throughout the history of civilization, there has always been something special about leaving  your home and eating a meal outdoors. We know there’s a beautiful world out there waiting for us to come and visit it, and when summer comes around, we all can’t wait to go out  and spend time outside.

Picnics have been used for many things throughout the centuries, from a simple family gathering spent enjoying the outdoors, to a peaceful protest in the  famous Pan-European Picnic, which was a peace demonstration held on the Austrian-Hungarian border near Sopron, Hungary on 19 August 1989.

Picnic Month celebrates the history of this activity and the way it has been used to bring families, countries, and all humanity together.

Picnic month is exceptionally easy to celebrate! All you need to do is just  to get outside and enjoy all the wonderful sights together with delicious food, which tastes much better outdoors.

Get your family and friends together at a nearby park and bring your favourite foods that can be eaten cold for a traditional picnic or bring a small grill and cook some delicious food on the spot.

Get the Children Involved

As summer arrives, a lot of parents may feel a little uneasy and not sure  how to keep their kids entertained.

A picnic is a perfectly easy, and  no fuss  activity to add some excitement  to the long summer days.

Whether you are a parent, carer or teacher, picnics are an ideal opportunity for learning and development. Simple tasks, such as buttering a slice of bread, or wrapping food and cutting up food can benefit children and contribute to their growth and further their skills

Positive Impact on Mental Health and Wellbeing

Science proved that nature and spending time outside has a positive effect on mental health and wellbeing. Nature has a calming influence and provides a longing and much-needed escape from the everyday pressures. 

Planning a picnic and having something to look forward to also has a fantastic impact on mental health. The social interaction which is a part of picnics has also a positive influence on mental health and wellbeing as humans tend to  thrive on positive, real communications with others.

In 2021, picnics are still a much-loved and popular pastime which provide a welcome relief from the everyday routine.

Microsoft Excel: Dashboards Course

Excel dashboards are one-page (or rather one worksheet) summaries that contains important information which allows managers to track key KPIs, metrics and other data points in one visual, central place. They may be used in almost any industry, for almost any purpose. It is possible to have a Dashboard to track finances, for marketing or to show the progress of a key project.

Dashboards are made up of tables, charts, gauges and other visualisations. Able to display a high-level view of an organisation, a good dashboard will aid in making business decisions and can also provide a portal to keep everyone up to date, giving a real time view of current status or performance.

If you want to be able to extract useful, actionable organisational information from your raw data, and present it in a visually compelling format that will enable key trends to be seen and decisions to be made, then Infero Training’s Microsoft Excel: Dashboards Course will help you do this. 

Creating an Excel Dashboard is a multi-step process and our course takes you through all of these in an easy-to-follow manner. As well as all of the technical aspects, the course covers the key things you need to keep in mind when creating a dashboard and how you need to be clear about the objectives of the dashboard, before you even start using Excel.

The course also looks at simple Excel dashboard design rules, such as the simple use of colours, easily read, clean design and other considerations.

Excel Dashboard design should be:

  • Understandable with no confusion over what each of the metrics mean.
  • Interactive so that the Dashboard can be changed for different areas of an organisation, or to answer different questions.
  • Clearly labelled, with all of the charts and tables on the dashboard displaying a clear message.
  • Organised into a symmetrical grid that aligns sections into blocks of data.

Course Content

 

Lesson 1: Data Analysis Fundamentals

Topic A: Introduction to Data Science

Topic B: Create and Modify Tables

Topic C: Sort and Filter Data

 

Lesson 2: Visualizing Data with Excel

Topic A: Visualize Data with Charts

Topic B: Modify and Format Charts

 

Lesson 3: Analysing Data with Formulas and Functions

Topic A: Analyse Data with Formulas and Named Ranges

Topic B: Analyse Data with Functions

 

Lesson 4: Analysing Data with PivotTables

Topic A: Create a PivotTable

Topic B: Analyse PivotTable Data

 

Lesson 5: Presenting Visual Insights with Dashboards in Excel

Topic A: Visualize Data with PivotCharts

Topic B: Filter Data Using Slicers and Timelines

Topic C: Create a Dashboard in Excel

To learn more about this course, contact us today.

Use MS Outlook to Delay or Schedule Emails

It is possible to delay the delivery of an individual message or messages using Microsoft Outlook, after you have clicked Send.

To delay the delivery of an individual message, follow these steps:

  1. When you have composed the message, on the Message Tab select the Launch Dialog-Box arrow in the bottom right of the Tags group.



  1. In the Dialog-Box that appears, in the Delivery options section, tick the Do not deliver before check box, and then choose the date and time when you want your message to be delivered.
  1. Close the Dialog-Box.
  1. Once you’ve finished composing your email message, click Send.

The message will remain in Outlook’s Outbox until your chosen delivery time.

If you later decide you want to send the message earlier than scheduled time, follow these steps:

  1. Locate the Outbox folder, in the Folders Pane at the left-hand side of the Outlook window and double-click it to view any messages it contains.

2. Find and open the delayed message.

3. On the Message Tab select the Launch Dialog-Box arrow in the bottom right of the Tags group.

4. In the Dialog-Box that appears, in the Delivery options section, untick the Do not deliver before check box

5. Close the dialog box and click Send.

NB: For this feature to work, Outlook must be online and connected.

There are many other options that you can use in Outlook, including setting a rule to delay all messages being sent by a specific amount of time. Contact us to find out more about our Outlook courses at all levels.

Yorkshire Day

Yorkshire Day is a yearly celebration on the 1st August to promote the historic English county of Yorkshire.  Initially marked in 1975, the Yorkshire Ridings Society started the day as “a protest movement against the local government re-organisation of 1974”. The date was not chosen at random, but has historical significance being the anniversary of the emancipation of slaves in the British Empire in 1834. It was William Wilberforce, a Yorkshire MP, who had been one of the campaigners for this emancipation.

Many people travel to Yorkshire on Yorkshire Day to enjoy the good food, the amazing attractions and the incredible scenery of England’s biggest county and, after months of being shut, many Yorkshire attractions will be hopefully be open or re-opening on August 1st

Events

Tapton Hall  – Tapton Hall in Sheffield has usually celebrated this holiday with traditional music from local bands and a themed afternoon tea. Hopefully something similar will occur this year

There are sometimes Yorkshire Day Chocolate Workshops in Scarborough. This may happen again this year, but please check closer to the time. – What would Yorkshire Day be without a chocolate fountain or at least a proper Yorkshire Tea Cup.

Barnsley Museums – A number of museums and historic sites in around Barnsley. There are usually a number of Yorkshire Day activities planned. In the past these have including a Yorkshire pudding competition, a digital jigsaw and a Yorkshire sonnet, and more. Keep an eye on the website. 

Attractions

York Castle Museum – This museum covers hundreds of years of York’s social history in one place. Check on the Museum’s website closer to the date.

The Hepworth Wakefield – The Hepworth Wakefield is an award-winning art gallery in the heart of Yorkshire, set within Wakefield’s historic waterfront overlooking the River Calder. 

North Yorkshire Moors Railway – A preserved historic railway stretching for 18 miles through the heart of the North York Moors National Park. It is one of the largest preserved heritage railway in the UK.

York Art Gallery – Housed in an impressive historic building with an impressive collection, providing tickets are purchased in advance online. 

Rievaulx Abbey – Set in a valley in the North York Moors National Park with the impressive ruins of one of England’s most powerful Cistercian monasteries. The Abbey has a new visitor experience which looks at Rievaulx Abbey’s fascinating past. There is also a museum which will hopefully be open.

York itself is a great city to visit, with many attractions including the Jorvik Viking Centre. And of course, there are amazing walks in Yorkshire, including on the famous Ilkley Moor, with or without a hat.

Enjoy Yorkshire Day.