Expedio Blog
Advent Calendar 2018
A new advent calendar, and a competition It's that time of year again - and you know how much I love to make you a present of a spreadsheet advent calendar! This year, I'm in very celebratory mood and thought I'd add in a little competition too, my gift to...
World Cup 2018 Tracker Spreadsheet
World Cup Tracker Spreadsheet It's all kicking off today! As I said in my last article, I can’t claim to be the world’s biggest sports fan most of the time. You may recall that I created a tracker for the European Championships a couple of years ago, and I...
Why did the baseball player shut down his website?
Why did the baseball player shut down his website? … He wasn’t getting any hits! I’m not sure I could develop a passion for baseball. I’ve never really been much of a sports fan at all. However on Thursday I arrived, with my husband Richard, at a hotel in...
How to create a data entry form in Excel
How to Create a Data Entry Form in Excel A spreadsheet is a great place to enter tables of data, such as price lists, but to enter records a row at a time from left to right isn't always user friendly. Did you know that there's a handy form feature so you...
Where do your website users come from?
Where do your website users come from? How do you know where your website visitors come from? If you're posting links to your website on social media, or on other websites, do you know which source refers the most people? If you're using Google Analytics...
What are people searching for on your website?
What are people searching for on your website? Do you know how to find out what people are looking for once they're on your website? Today's tip is how to use Google Analytics to give you the answer. Firstly, you'll need to have a search facility on your...
Can I mention it now?
Anyone who knows me, knows how much I love Christmas, even though I probably won't get the time to ice my cake until Christmas Eve - something that's become a tradition of its own. Something else that's becoming a bit of a tradition here is our advent calendar. This...
How to create a dynamic drop down list in Excel
Today I'm going to show you how to create a drop-down list in Excel; and not just any old drop-down list but one where if you change the items in your list, then the drop-down that you've created will also change. You may be familiar with using Data...
What do you think about speedos?
One of the first things I’m often asked for when building a dashboard is “one of those speedo things – you know, a dial with a moving needle”. They’re not always the most useful chart to have on your dashboard as they only show you a single absolute value – but… well...
Valuing your time on Twitter
How do you know if your marketing activities are working? One I sometimes struggle with is Twitter. The content moves so fast and I don't feel I know if my short ramblings have just disappeared in the fast flowing action or if they're actually doing something. Many...