Bespoke training design and production
…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 …
This is the effect of entering data into Excel for the average human being… Are there any cool ways to save some time on data entry? It hides out of the way a bit, but if you look hard enough you can find something really Read More …