Tip o’ the Week 396 – Handling dates in Office apps

Posted on September 19, 2017 by ewand

There are many times when you may need to deal with dates in ordinary applications – and there are a few shortcuts that you can make it easier.

In Outlook, any time there’s a date field (like when you’re setting a reminder, or entering the start date/time for an appointment) you can choose or enter a regular date, or put in an expression – like “2 days” or “next Tuesday” – and Outlook will figure out the offset from today, and will set the appropriate date.

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”, “3^rd 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).

In Excel, press CTRL+; to insert the current date into any cell – add a SHIFT key to insert the time instead. Excel are many date-oriented functions, but you don’t always need to write functions – simple maths can work on date fields – calculating the number of days’ difference between two dates, for example, or adding a number of days to a start date.

In the desktop OneNote app, if you want to edit the date and time at the top of a page, click on the field and you’ll see a clock or calendar icon appear next to it – click on that is set to, click on that to change the value; handy if you’re updating some reference material and want to make it clear that it’s recent.

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.

Word also supports SHIFT-ALT-D and SHIFT-ALT-T like OneNote, though inserts a date or time field rather than a simple bit of text, and is slightly different to the Date & Time command on the Insert tab, which gives a bit more control over the formatting at the point of insertion, rather than requiring the user to insert the field then go back in to edit the format.

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 395 – Resizing pictures in Windows 10

Posted on September 15, 2017 by ewand

As smartphone cameras get better, it’s very common to have snaps with dimensions of 4,000 x 3,000 pixels, sized in multi-megabytes – great for capturing a bit more detail, but potentially tricky when handling the photos given the file size as well as their width & height.

This is especially the case if you’re sharing pictures with others – though it does rather depend on how. Email programs usually have ways to reduce the size of images, varying in method but increasingly very integrated to the sending process, and often with little real control of what’s going on. Outlook, for example, lets you drag images around by resizing handles, or if you right-click on an inserted image, choose Size and Position then look on the Size tab, you can alter the scale of an image for display purposes.

This doesn’t make the image smaller in the number of bytes it takes up, however – so you might think you’ve made your massive picture a nice thumbnail, only to find it’s still actually 7MB in size. In order to make the image data size get smaller in Outlook, select it by left-clicking, then from the Picture Tools | Format menu, you’ll find a Compress Pictures com mand that lets you make this image (or every other one in the mail), smaller.

If you look on the File menu before doing so, you’ll see the size of the email before, and presuming you’ve hit “Save” after the compression, you can compare the size afterwards too.

The same thing happens in PowerPoints as well – tiny little watermarks on the background of a presentation making the file too big to ever email to anyone. A similar process can radically reduce the size of your presentations by compressing the size of images before saving.

Files

If you have pictures in the file system, there used to be a variety of ways for Windows to offer resize capabilities – one of which was to install the now-defunct Windows Live Photo Gallery, which had a nice wizard to resize images to standard sizes. Now, in Windows 10, there’s no easy, out-of-the-box way of doing it, as the Photos app doesn’t offer resizing and nothing shows up in the desktop / file system mode.

If you have a habit of uploading photos you’ve taken to online forums and the like, some of them will deal with resizing for you (as does Facebook, Yammer etc too), but if they don’t, you may find you’ll need to radically reduce the dimensions of your pic before you can share it.

One of the joys of writing Tip o’ the Week is that readers often send their tips just after the mail has gone out – welcome but not always practical to share on, as the same topic might not return for a while. In this example, there will no doubt be a plethora of fave image resizing methods, but a simple one for mortals with less time on their hands is to just go to @Brice Lambson’s site on http://www.bricelam.net/ImageResizer/ and install the quick & simple resizer tool.

Afterwards, right-click within Windows Explorer on your chosen image – or select several and do the same – and resize the image(s) to a given set of dimensions in a trice. Then you’re ready to upload the resulting new pics to your online forum of choice.

Remember another handy tip (as covered in ToW #373 and others) is the Copy as path command – hold SHIFT as you right-click on any file and you’ll see it appear in the drop down list. What this does is copy the exact file and pathname to the thing you’ve just right-clicked on (remember, kids, it works with any file, so uploading docs to a SharePoint is just as relevant) into the clipboard, so you can instantly point the File -> Open dialog on your other app or browser straight to the thing you want.

Tip o’ the Week 393 – Searching in OneNote

Posted on September 8, 2017 (Updated July 23, 2021) by ewand

Tip o’ the Week ❤ OneNote. Both the full-fat trad Windows app version (OneNote 2016), and the Store (just “OneNote”) application that has a portion of the functionality and a simpler UI. One side effect of using OneNote a lot, though, is that you might have a huge amount of old pages in your set of Notebooks, especially if you share notebooks with your team, and end up with a Notebook for each project you’re working on.

If you’re using the regular OneNote 2016 application, and go to search content (by entering the search term into the box on the top right, maybe by just pressing CTRL+E to jump straight to it), you may find that the results you get include a lot of old content which isn’t all that easy to parse – the name of the notebook occupies much of the column showing the location of the matching page or section, there’s no date of last update or any means of sorting – so it’s hard to know what’s recent and what might be years old.

If you click on “Pin Search Results” at the very bottom of the results list, or press ALT-O, then you’ll see the results appearing in a pane to the right of the OneNote window, where you can change sorting and filtering options, and see the date the pages were last modified.

Referring to this option as “Pin” may make you think it’s a bit more permanent (such as pinning to taskbar or Start, or pinning to a menu somewhere), but it’s as easy to dismiss the results pane as it is to invoke it in the first place – just click the X in the top right of the window pane, or the close option on the drop down arrow which also lets you resize the pane or even move/undock it from the main Outlook window altogether.

There’s no obvious equivalent of this search granularity in the OneNote store app. ☹

Tip o’ the Week 392 – distract with GIFs

Posted on August 18, 2017 by ewand

We’re all used to file formats being associated with programs and the data they work with. Some, like .TXT, have been around for so long and are so cross-platform, they transcend association with any one application, whereas .PPT will always be PowerPoint – though that app has gained notoriety in such phrases as “Death by PowerPoint” (which we’ve all been subjected to, even if not completely fatal), or “PowerPoint Karaoke” (reading out the words on slides without adding anything).

One long-used file type goes back to 1987, the GIF – standing for Graphics Interchange Format, predating the eventually prevalent JPEG format by 5 years. GIFs were relatively poor quality – only 256 colours could be used; 30 years ago, that wasn’t an issue but in recent decades, it’s more limiting. Most people, however, will be familiar with GIFs due to a sub-variant – the Animated GIF. This is a series of frames which are played like a simple video – with low frame rates & no sound, yet they have occupied a niche in the way people use the web.

Applications tend not to render animated GIFs well – Outlook, for example, simply inserts a static image, but browsers do show them properly. If you have an email in Outlook that you know has animated GIFs, look for the Actions submenu on the Message tab and select View in Browser.

Adding animated GIFs to chat applications is a good way of making a point more vociferously than with smilies… though it can be even more distracting. Skype (the consumer version) added some featured videos (with sound), but both Yammer and Teams have added GIF buttons to make it easy to seach for amusement from online animation repository, GIPHY.

Try pepping up boring Yammer groups or Teams sites, by looking for the GIF logo on the message box, then searching for a 2-3 second loop that underlines your point. Just make sure the content is suitably Safe For Work or you may find the consequences of sending jokey GIFs to be less than ideal.

Facebook has the same kind of thing on comments boxes, from a variety of sources and also not entirely SFW.

Finally, Outlook.com has unveiled a new beta mode that is available for some users (& rolling out to more – look for a “Try the beta” toggle switch on the top of your Hotmail/MSN/Outlook.com mailbox) – and one feature will be animations that can be easily embedded in mail.

The “expressions” feature lumps emojis & GIFs together to make it simpler to annoy your recipients.

Read what Thurrot has to say about the other bits of the beta.

Tip o’ the Week 391 – Smile, control your emoticons

Posted on August 11, 2017 (Updated August 26, 2021) by ewand

“Smileys” have been around in one form or another for a surprisingly long time. The use of the original 🙂 smiley goes back 35 years, but written symbolism to convey emotion goes back to the 17^th century, maybe even in the days of Lincoln.

In modern times, the smiley has evolved; after the grinning yellow dot being used in various waves of popular culture, the textual facial-expression-on-its-side became more common as people flocked online and started using email and instant messaging. Gradually, icons of a variety of smileys helped convey a wider range of meaning – becoming known collectively by the portmanteau, “emoticons”. Or the Japanese-based variant, emoji. If you’re bored sticking pins in your eyes, you could be watching a Turkey at the flicks, though you’re more likely just an end-user of the emoji symbols.

Over recent years, emoji have become more mainstream and therefore the interpretation of symbols across different platforms has grown in importance – if you enter 🙂 into many apps, you’ll get a – as configured in the AutoCorrect function in Office, and natively supported in lots of other applications, and if you send a text message with emoji in it, you’d hope that it gets interpreted correctly at the other end.

To insert emojis into your mail, IM or whatever, you could type the foundation characters – like 🙁 or 😀 – or copy & paste the relevant symbol from a source such as http://emojipedia.org/microsoft/.

If you’re using Skype (consumer, and Skype for Business), though, there’s a shortcut for each emoticon, that you can type to insert the relevant symbol – eg. (t) or (call) will insert the symbol to the left, or (c) or (coffee) will show the cup symbol. Just hover over the symbol and you’ll see the shortcut you can type.

Other handy shortcuts for Skype for Business include (b), (d), (y), (n), (cic), (!), (e), (run), (k) – careful, mind… Why not try them out on your colleagues next time you’re IMing?

The consumer Skype app has lots more emoji/emoticons than the Business version, as you might expect – generally speaking, there’s not a lot of business need for 💩 or dancing gran icons.

Well, unless you know differently? ‍✋

Tip o’ the Week 388 – Crossing Time Zones

Posted on July 28, 2017 by ewand

Another dip into the annals of ToW, dusted down and spruced up – this topic was first covered in #301, though the topic of time zones has also featured in #280, #244, #120, #26…

When moving between countries, one of the tricks the traveller needs to decide is how to handle the switch of time zone. Do you set your watch to the destination time as soon as you board the plane, or only when the pilot announces, in his or her ever-so distincive pilot tone, what the local time is on arrival?

Also, do you wait for your phone to pick up the destination time zone automatically, or do you set it manually? If you have a Fitbit or other wearable, do you want it to pick up the time from your phone or do you force it on departure? Decisions, decisions…

Frequent travellers tend to have pearls of wisdom on how to deal with jet lag – like get your mind in the destination time zone and keep it there (ie. If you’re out having dinner after arrival, do not keep saying that it’s really 4am; it’s 8pm now and you can’t go to bed for at least another two hours), or get the sun – or even a bright light – on the back of your knees. All we can cover is how to handle the crossing of time zones using your PC…

Outlook – whenever an appointment is created, its date and time are recorded as an offset from UTC, and the time zone it’s due to take place in is also noted. If you’re creating meetings or appointments which are in a different time zone, like travel times, then it may be worth telling Outlook by clicking the Time Zone icon in the ribbon, and then selecting the appropriate TZ – especially useful if you’re moving between time zones during the appointment itself, and don’t want to run the risk of horological befuddlement.

If you’re booking a load of appointments in another time zone – eg. you’re working in another country for a few days and creating appointments with people in that locale – then it’s even worth switching the TZ of your PC whilst you do the diary-work, to save a lot of clicking around in setting the appropriate time zone specific to each meeting.

The best way to do this would be to show your second time zone in the Outlook calendar – in the main Outlook window, go to File | Options | Calendar and select the second one to show; when you’re ready to switch between your local TZ and the remote one, just click the Swap Time Zones button to switch the PC (and Outlook) between the different zones.

Windows 10 – In the Settings | Date & time menu, there’s an option to tweak how Windows deals with time and time zones – some of which might be applied by policy and therefore greyed out for you. Like other phone OSes, Windows 10 – even on proper computers – has the option of setting time zone automatically.

If you’re going to use the time zone swapping in Outlook as per above, then it’s worth disabling the automatic mode as Windows can get itself properly confused; the default time zone will change, and Outlook will end up showing the same time zone for both primary and secondary.

Using the old fashioned Windows control panel time settings applet, you can choose to show a second time zone in the clock on the system tray – in the Date & time settings, look to the right and you’ll see Add clocks for different time zones.

There’s a nice Alarms & Clock app in Windows 10, that shows a map of the world with your choice of locations, and the moving daylight line so you can see what’s happening around the globe. A good alternative to that exec boardroom display nonsense, that you might expect to see gracing the wall of your average corporate hot shot.