Here’s a quick look at some of the modest Excel tricks we used to make the Schengen Visa Calculation worksheet. Table Making the itinerary list an Excel Table lets us make use of some features. Formatting It’s a lot easier to format as a table with banded rows. We’ve turned off the Table | Filter […]
A large security risk has appeared in Microsoft Word, a zero-day security problem which can infect even fully updated Word. Microsoft has taken at least 14 months and still hasn’t fixed the security hole. We’ll explain the problem and what you can do. It’s a relatively simple hack which takes advantage of gaps in Word, […]
Sometimes you need to convert a date from the Excel cell saved format to a particular format. There are at least five ways to do that. DateValue(), Date() or converting Unix dates to Excel. Simply typing dates into a cell also works but there are traps for the unwary. Excel’s trap when typing in dates […]
Excel has some nifty and simple options for color highlights the extremes in a list of values. It’s called Conditional Formatting and you can do all sorts of clever things with it. First let’s look at the simple presets that Microsoft has given us, some of the obvious choices they’ve left out and how to […]
It’s easy to share appointment details with other people, whether they use Outlook or not. No need to type in appointments when you can send and receive the details right in your calendar. We’ll explain how it works for both sender and receiver (organizer and invitees) on various platforms, including Outlook.com and Gmail plus the […]
