Facebook LinkedIn
Menu

Training art

Bespoke training design and production

Training art

Primary Menu

Skip to content
  • About Dave
  • Contact Dave
  • Portfolio
    • 365 Train-the Trainer – NHS SCW
    • Dynamics 365 – NHS Property Services
    • Office 365 rollout – Ei Group
    • Dynamics 365 – Cambridge Enterprise
    • Dynamics 2015 CRM – Ei Group
    • PowerPoint eLearning – Eversheds Sutherland
    • Global Web App Rollout – ByBox
    • Microsoft Excel – LEVC
  • The QRG
  • The Demo
  • The Simulator
  • Experience
Search

Category: Tips

Time to get Quizzing!

Posted on09/08/202109/08/2021Leave a comment

Creating a Quiz in Microsoft Forms is a useful skill… In Forms you can create either a Survey or a Quiz. A Survey is there to gather information – the answers come from the respondents. But a Quiz contains the answers and so this is Read More …

CategoriesOffice 365, TipsTagsForms, Office 365, Quiz

Excel logo

Make a map in Excel

Posted on19/05/202019/05/2020Leave a comment

One of the recent additions to Excel has been the “Map” chart type. It enables you to relate your data in your spreadsheet to geographical regions and this gives you a really good graphic that you can share with others. But it’s not just a Read More …

CategoriesExcel, Office 365, TipsTagsChart, Excel, Map, Population

Windows 10 logo

Shut your lid!

Posted on08/11/201908/11/2019Leave a comment

How do I work on my laptop with the lid closed? By that, I mean connected to an external monitor, keyboard and mouse – like a kind of docking station. In this situation, it’s nice to have the lid closed so that it’s not distracting Read More …

CategoriesTips, WindowsTagsClose, docking station, external monitor, laptop, lid, shut, Windows 10

Bloated iPhone

iPhone spacebar tip for editing texts

Posted on03/05/201903/05/2019Leave a comment

How do you go back a character at a time in a text message on an iPhone? Sounds like this should be easy, but of course it only seems to let you go back a word at a time when you tap. This tip is Read More …

CategoriesiOS/Apple Mac, TipsTagsediting, iPhone, Messages, messaging, spacebar

Screen sharing icon

Sharing your screen on a Mac

Posted on15/04/201915/04/2019Leave a comment

Sometimes you need to see someone’s Mac screen! When my Mum has a problem with her Mac the most difficult issue is not solving it, but just understanding what the actual problem is! It can be very difficult for anyone to explain their computer issue Read More …

CategoriesiOS/Apple Mac, TipsTagsApple, Mac, MacOS, Messages, screen, screen sharing

Excel logo

Changing the way cells look based on their values

Posted on11/04/201911/04/2019Leave a comment

…otherwise known as “Conditional Formatting” Often in a spreadsheet you want to highlight your numbers to emphasise their value. So how do you make the magic happen? With as little work as possible, so this is where Conditional Formatting can help… 1. Highlight Top/Bottom Values Read More …

CategoriesExcel, Office 365, TipsTagsConditional Formatting, Excel, Formatting, Icons

iOS e-mail App icon

How to attach a file to a mail using an iPhone

Posted on04/04/201915/04/2019Leave a comment

Sounds obvious – don’t you just look for a paper clip icon? The problem is, unlike the iPad, there is no paper clip icon… Luckily Apple’s interface is simple (if you know how), so by just simply tapping the e-mail screen you get a menu Read More …

CategoriesBasic IT, Fundamentals, iOS/Apple Mac, TipsTagsApple, attachments, e-mail, iOS, iPhone

Projector - featured image

Emergency presenting!

Posted on02/04/201909/10/2020Leave a comment

…or “s**t! I forgot my laptop!” It’s every presenters nightmare. You’re in a hurry, you get to the venue but then you realise you’ve left your laptop at home! How do you get out of this emergency? In short, a bit of planning up front. Read More …

CategoriesBasic IT, PowerPoint, Presentations, TipsTagsiPhone, PowerPoint, presentation, Presentations, presenting, projector

Share icon

Using the Share button

Posted on29/03/201929/03/2019Leave a comment

Sometimes you do want to share things! I’m not just talking about funny cat videos. I’m talking about your Office 365 documents. In Office 365 applications you can use the Share button on any file to give someone else access. Here it is in PowerPoint… Read More …

CategoriesExcel, Office 365, PowerPoint, Tips, WordTagsExcel, Office 365, PowerPoint, share, sharing, Word

Excel logo

Data Validation in Excel

Posted on27/03/201927/03/2019Leave a comment

How do you limit entries to spreadsheet cells? So you have a list of people in your spreadsheet and you want to note their knowledge level on a particular skill. How do you restrict entry to that column to a number between 1 and 5? Read More …

CategoriesExcel, Office 365, TipsTagsData Validation, Excel, Office 365

Post navigation

← Older posts

About this Blog

1

This blog is by Dave Beresford, a freelance training designer based in the UK. Use the menu above to find out more about Dave and how he could help you in your IT projects... Read More

Search

Posts by Tag

Animation Apple Data database Design Desktop Do Not Disturb e-mail emphasis entrance Excel exit Files Gmail Google Graphics iCloud Icons iOS iOS11 iPad iPhone Mac MacOS Mail Messages Microsoft motion path Office 365 Office Online OneDrive Outlook PowerPoint presentation Presentations screenshots share SharePoint sharing signature Storage Time saver Windows Windows 10 Word

Recent Posts

  • XLOOKUP is here! 15/03/2022
  • Time to get Quizzing! 09/08/2021
  • Apple Mac OS Desktop Tour 07/02/2021
  • Creating a Document from a Template in Word 03/02/2021
  • Google Apps and how to get them… 19/01/2021

Posts by Category

Facebook LinkedIn
Copyright © 2025 Training art. All Rights Reserved | Clean Magazine Pro by Catch Themes
Scroll Up
  • About Dave
  • Contact Dave
  • Portfolio
    • 365 Train-the Trainer – NHS SCW
    • Dynamics 365 – NHS Property Services
    • Office 365 rollout – Ei Group
    • Dynamics 365 – Cambridge Enterprise
    • Dynamics 2015 CRM – Ei Group
    • PowerPoint eLearning – Eversheds Sutherland
    • Global Web App Rollout – ByBox
    • Microsoft Excel – LEVC
  • The QRG
  • The Demo
  • The Simulator
  • Experience