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

Tag: Excel

Excel 365 logo

XLOOKUP is here!

Posted on15/03/202215/03/2022Leave a comment

VLOOKUP has limitations… When you have a piece of information you know and want to lookup something else in a column to its right in a large data table, VLOOKUP has always been the “go to” function to use! But there are problems with VLOOKUP… Read More …

CategoriesExcelTags365, Excel, Office 365, VLOOKUP, XLOOKUP

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

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

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

Excel logo

Splitting columns of data up in Excel (and Flash Fill)

Posted on12/03/201914/03/2019Leave a comment

What happens when you have a spreadsheet like this… And you want to split the first column (Full Name) into 2 separate columns, like this… How do you do that, the easy way? First of all, you need to create 2 new columns… Then, name Read More …

CategoriesExcel, Office 365, TipsTagsdatabase, Excel, Flash Fill, Office 365, Text to Columns

Excel logo

“Scraping” data from the Web to Excel

Posted on28/02/201928/02/2019Leave a comment

Sounds revolting, but apparently it’s a jargon term for taking some data from a web page and putting it into an Excel spreadsheet. In fact, that process is pretty easy. 1. Visit the web page of interest… Start on a web page that contains some Read More …

CategoriesExcel, Office 365, Tips, VideoTagsData, Excel, Office 365, scraping, webpages

Excel logo

Using the LARGE function in Excel

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

There’s more to Excel formulas than SUM! When I’m training on Excel, the one formula that people seem to be able to do is add cells up with SUM (often by using the AutoSum button). The thing is, often that’s the only formula a lot Read More …

CategoriesDemo, Excel, Office 365, TipsTagsExcel, Formula, Function, Large, Office 365

Excel logo

Cleaning up text in Excel with PROPER

Posted on10/02/201910/02/2019Leave a comment

Sometimes you have text in Excel that just hasn’t been entered very well! Don’t fancy re-typing it all? You can use a function in Excel called PROPER() to make it all nice. In other words… From this: To this: Joy warren Joy Warren april bulman Read More …

CategoriesDemo, Excel, Office 365, TipsTagsclean up, database, Excel, Proper case

Office 365 logo

Get Office 365 from someone else’s computer!

Posted on17/09/2018Leave a comment

So there you are, doing a presentation and you’ve forgotten your computer! What can you do? You can borrow a computer or use one there, but how do you get that presentation up there? Office Online could be the answer! You’ll need 3 things to Read More …

CategoriesOffice 365, OneDrive, PowerPointTagsExcel, Office 365, Office Online, OneDrive, PowerPoint, Word

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