Excel 365 makes it incredibly easy to get past price and volume info for stock, fund and currency exchange data, then convert that into a professional-looking chart. Some may remember the days when stock prices were added manually from a newspaper. Now a single Excel cell formula can grab the history of thousands of traded […]
How to compare caffeine levels in coffee, tea, soda and other drinks from an Excel spreadsheet. The Guardian’s Datablog has interesting analysis of caffeine levels in different foods. Sounds boring until you read that: reduced sugar colas have almost double the caffeine of a regular, sugared, cola. 1 cup of coffee can have as much […]
Microsoft’s digital ink notetaking app, Journal, has grown up. It’s no longer ‘Garage’ trial software but part of Redmond’s official software line up. If you like scribbling or notetaking with a digital pen, you can try out Journal. Journal was a Microsoft Garage project which are trials of an app or technologies. Journal seemed like […]
Microsoft’s To Do app can now automatically add due dates, reminders and repeat tasks automatically based on what you type. It works quite well but there’s some traps for the unwary. Whatever you type in a new task is analyzed for hints of due dates, reminders and repeat tasks. Here’s Microsoft’s example: Office Watch has […]
Changing the case upper/lower for text through all of a Word document is easy because the default Find / Replace settings don’t need changing. We’ve already talked about the manual Change Case options in Word, now we’ll move onto bulk changes. Sometimes the spelling of a product or brand has peculiar case choices like iPad, […]
