Bespoke training design and production
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 …
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 …
…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 …
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 …
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 …
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 …
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 …
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 …
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 …
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 …