Blog: Upskill in Lockdown – Week 3 of Isolation

Week 3 of Isolation

So, we’re coming up to week 3 now – men are going for the Brittney 2007 look and resorting to shaving their own heads, and women are having to taking their own acrylic nails off, in any way possible. However, I hope you are all keeping healthy and happy still, in spite of these ‘first world problems’!

Thank you to everyone who attended our last training session. We’ve had such amazing feedback from the virtual sessions and so many questions, so thank you all for your input – keep it coming! We’re glad the sessions have been so useful to you all. If you missed out on the last session, would like to watch it back or even send it to a colleague, you can access the recording here:  Top 10 Tips for Microsoft Outlook and Word.

Once again, I’m bringing you the goods with our next session of Upskill in Lockdown that will be focusing on Excel. Julie and I will be taking you through our Top 10 Tips for Microsoft Excel when working from home. We all know how painful and monotonous dealing with data can be, especially in isolation! However, Excel has so many functions and capabilities, there seems to be a tool to do almost anything in it and our little hacks could save you hours of repetitive tasks.

This free training session will be held on Wednesday 8th April 2020 at 2pm. If you are unable to attend at this time, you can sign up and we will send you a link to a recording of the session.

Register here

What we will cover:

Working with lists

  • Format as table
  • Sort and Filter
  • Remove duplicates
  • Insert Slicer

Formulas

  • Using AutoSum to total and average
  • Use Concatenate to string cells together
  • Use formulas to change the case of text in cells
  • Copy and Paste Value
  • Show formulas in cells

Create a simple chart

Printing

  • Print titles
  • Headers and Footers
  • Gridlines

We have more training sessions coming up in the next few weeks, but if there is anything you would like us to cover, pop us an email with the subject ‘suggestions for virtual training sessions’ and we will take a look. Also, if you have any questions about any of our sessions or would like more in-depth one-to-one training, please email me at Danielle.John-Charles@tikit.com or my colleague Julie, Julie.McCarthy@tikit.com.

See you next time on our journey to Upskill on Lockdown, stay safe and well!

Danielle