Fast forward 30+ years and it seems every app and OS is running away from black text / white backgrounds, and heading for monochrome graphics and oppressive white text on a black background again. Using Dark Mode, either in apps or in the operating system on your computer or phone, promises a variety of benefits – less noticeable flickering, reducing eye strain, avoiding bright lights in a dark environment, perhaps better readability and therefore productivity, and even lower energy costs. Dark Mode has existed in Windows for a while – but ultimately, apps need to support the theme, too, and more and more are doing so – like new Edge browser, or Office apps (where you can set the Office Theme). Microsoft recently put out a groovy video to highlight Dark Mode across a variety of apps and device types, and some commentary about why and when. It’s even come to Outlook.com as well. The announcement on Microsoft 365 functionality adds for August 2019 highlighted additional Dark Mode support coming to Outlook mobile apps and Outlook.com, saying, “Dark Mode is not only easier on the eyes and may extend battery life, it also enables you to comfortably continue using your device in places where the default bright mode isn’t appropriate, like darkened airplanes and movie theaters.”
So kids, next time you want to go and watch a movie & catch up on your email, make sure you’ve Dark Mode on! |
Tag: Office
Tip o’ the Week 483 – mobile OCR and Office
Near OCR functionality is also pervading the slew of freely available Office apps for Android tablets, phones and even Chromebooks, and similar versions for iPad and iPhone. A recent addition to the iOS version of Excel is the ability to scan a table of printed data and use OCR plus a bit of tweaking, to import the data into the spreadsheet. See more here. The same functionality was first made available on Android a couple of months earlier …
Then the OCR goes to work and tries to lay out the data as closely as possible to its source – obviously, your accuracy will be improved by having a well-lit and clear original document, and you’ll get to tweak the contents in context of seeing the OCR’d data and the scan at the same time, before committing to insert it. |
Tip o’ the Week 482 – Paste History
|
Tip o’ the Week 472 – Update Store & Office apps
The Windows 10 October 2018 is now being pushed to (nearly) everyone, though business users will have the option of pausing Windows Updates in case they want to enact a temporary delay for some particular reason – you’re about to go on a trip, for example – though it’s not meant as a centralised policy control: IT departments have other ways to do that. Windows 10 Homes users will soon get the ability to defer updates for up to 35 days, too. How often applications update themselves is largely down to the publisher,
Or check the View Updates option at any time, and it’ll take you to the web to see what the latest updates contain. |
Tip o’ the Week 468 – Get Office, My Office, Office app appears
Get Office became “My Office”, which was a lot more useful in the sense that it was showing documents you used etc, but its main aim appeared to still be to help you find and launch Office apps, or buy them if you’re not already using them.
The search bar also reaches across SharePoint sites you use, OneDrive locations you have and even brings in the global address list so you can get to people details really quickly, including a really fast org chart ability. The new Office app will be delivered automatically for a lot of people as it will replace the My Office and Get Office apps in due course; if you’d like to check it out sooner, go to the Store. |
Tip o’ the Week 437 – Mapping of Minds
Like writing a status report, the act of doing the report or compiling the map prompts valuable activity more than the resulting artefact which might never be read. Research has shown that more visually oriented people are likely to get more out of mind mapping, and using a mind map to try to remember stuff has a fairly short shelf life. If you’ve not tried mind mapping, the simplest way is to start with a blank sheet of paper and a pen. Read some more here about the concepts. Or here, realising that the site is basically trying to sell you mind mapping software. There’s a more balanced view of different software packages, here. You don’t need to pay for your mind mapping software, though… OneNote could be a great way of doing it, especially if you have a PC with a stylus. There are a few 3rd party addins to OneNote (desktop version) that provide additional functionality for mind mapping, though the same don’t necessarily work with the Modern App version – something that’s been picked up on the User Voice forums.
This functional approach can be a bit too structured and formal, some people preferring a much more freehand, flowing kind of mind map to basically do a brain dump. Maybe a good way of publishing an already-sketched mind map? Here’s a step-by-step guide (originally written for Visio 2010). Watch this 10-minute tutorial video if you’d like a more visual approach. There are some more brainstorming tips and tricks for Visio 2016 here.
The app has simple hierarchical mapping features, and some freehand support – including Ink – with easy additions of structure, auto-layout and the like – it’s a great way to creating a mind map on Windows. It can automatically sync your maps to OneDrive, too, and export to PDF/PNG. |
Tip o’ the Week 417 – Resolving aliases in bulk
This might be a very old-Microsoft culture thing, but alias names have always![]() Before enlightenment, Microsofties were emailed simply by sending to alias@microsoft.com – and still are, so even if the primary mail address is forename.surname@microsoft.com, you could still mail them at forenams@microsoft.com, or whatever their alias is.
In a company with a handful of people, it was easy to remember such a name for when you wanted to drop them an email, but with hundreds of thousands of mail addresses, you might need more room – when Exchange Server came out in 1996, it supported 64 characters in the alias name, though oddly, Microsoft has never embraced longer than 8-character aliases. Back in the day, your mailbox was a folder on a Xenix server, then an MS Mail postoffice, and the folder names were restricted by the 8.3 filename format. There are probably too many legacy systems that also have an employee name represented by their 8-letter alias, and it still kinda works. Aliases – and the cultural phenomenon of calling people not by their name, but by their alias… eg “we had a billg review” – were a central part of the 1995 Douglas Coupland book, Microserfs.
But the true “alias” lives on, even if the Skypey “Contact Card” UI in Outlook does its best to not show you what someone’s alias is (but you can usually still get to Open Outlook Properties, which shows you the traditional Outlook address book view, with alias in the very top section). Lots of reports from Microsoft’s internal systems will refer to an employee using their alias name, so it often helps if you can decipher an alias into the person behind it. Resolving an alias to a name one-at-a-time is all very well, but when looking at a column of alias names in some spreadsheet, it’s a bit of a palaver to turn each of the FORENAMS into something meaningful. Bulk alias resolver in Excel Fear not, worthy reader, for a solution is to hand.
This can be handy if you’re building Excel reports and want to add names to a table instead of aliases – you could sort the list of aliases alphabetically, run them through the resolver, and then reference the table with a VLOOKUP formula so you could hide the column of aliases from your report and show instead the derived real names. |
Tip o’ the Week 403 – Office Insiders and training
The Windows Insiders program is well known as an early-access scheme for Windows, with millions of users trialling out new versions regularly and getting new functionality ahead of general release. A new “fast ring” version of Windows 10 came out just the other day, in fact.
Did you know that Office has a similar programme? Office Insiders is geared towards Office 365 subscribers who want to opt-in to early releases.
Regardless if you are or are not in the Insiders group, you can see what’s new in the latest version of Office you’re running (assuming you’re on Office 2016 and subscribing to Office 365).
Try looking under File | (Office) Account menu, and check under the Office Updates section to make sure you’ve got the latest versions available to you.
Click on What’s New and you’ll see a pop-up of the latest features, with a “Learn More” link to find more. To see the latest for Office Insiders, check here.
One new feature that’s previewing for Insiders but available to anyone on the web is the new Office Training Center, which offers help in a number of features, templates and the like. There are short videos showing tips on how to use Office apps in conjunction with Office365 – check out some of the “try new things” category to see if they really are new to you.
Tip o’ the Week 396 – Handling dates in Office apps
In Outlook, any time there’s a date field (like when you’re setting a reminder, or In some date fields (like an appointment start time), if you say “4 days” then press enter or TAB, it will evaluate the new date; if you return and put “4 days” again, it may add those extra days to the last date. Try a few other things like “next Christmas”, “3rd Sunday in November”, “2mo” , “7d” or some special days – there are some surprising ones there, like “Lincoln’s birthday”, and other events with static dates … though nothing that might change the actual date from year to year (like Easter, or Thanksgiving).
Another way might be to insert the current date or time into the text: to do so, press SHIFT-ALT-D, or SHIFT-ALT-T for the current time, or SHIFT-ALT-F for the current date and time. The last one is really handy if you’re taking notes about a phone call, and want to quickly note the time that your insurance company said that everything was all fine, or when you started the indefinite call to the airline. The same shortcuts apply to the desktop OneNote 2016 application and also the OneNote store app.
Since Outlook uses Word as its text editor behind the scenes, the same shortcut keys will also insert date fields into the text of an Outlook email. |
Tip o’ the Week 373 – Copying Images for emails
![]() If you want to use someone else’s imagery, especially if it’s something you plan to disseminate, then you really ought to ask, or else pick imagery that’s appropriate licensed. One way is to source your image content from a pre-licensed source – like public domain (fill your boots) or Creative Commons, where some rights are reserved by the creator but others are often waived, meaning you’re free to use those images within certain constraints. Bing.com has some nice image searching tools which let you find content and then filter based on the license type – just click on the filter logo on the far right, and then choose the requisite license type from the drop-down box. Once you’ve found the image content and you’re happy that it’s OK to use it as per the license (or you don’t really care), then you can copy & paste in a number of ways.
See earlier comment. Whatever. Anyway. There are a few other ways of pasting in found content – in Facebook, for example, if you have a picture in the clipboard, you can paste it straight into a Post and it will be uploaded. The same thing is true of some online forums (watch nerds, look away now), whereas most will want you to find a URL for your photos before you can embed them in the post you’re making. There are some different approaches to grabbing the URL of an online photo, should you need to – Google’s Chrome browser lets you right-click on an image, and you can copy it to the clipboard, copy its URL or even search Google for similar or different-sized versions of the same thing. The Edge browser usually works a little differently, though – you could share the image to another app that supports
So, if you’re a good girl or boy, you can share your own content from your PC, easily uploading to appropriate services by copying the path to any file on your machine and pasting that path into the dialog to attach, upload or insert a file. In fact, that’s probably the most useful tip in this whole mail. Done. |