683 – OneNote Docking

Posted on May 26, 2023 by ewand

Since the OneNote desktop app is getting a reprieve from its previously-announced retirement, and the anointed successor UWP app is itself being put on notice, maybe it’s worth looking at a few tweaks which can make the old app a bit more useful. There were a load of updates announced about a year ago, and further improvements to the OneNote family are on the way too.

If you use OneNote to take meeting notes – especially if you’re meeting virtually and want to have your notes alongside the Teams/Zoom/Chime app – then it makes sense to arrange the windows side by side. Students of ToW past will know that in Windows 11, pressing WindowsKey+ ‎← or → will snap the current window to the sides of your display, and there are other ways to control window placement if you have especially complex desktop arrangements.

There is an old feature in OneNote which is worth revisiting; Dock to Desktop. Invoke it at any time by pressing CTRL+ALT+D or go to the View tab to select it.

You could also try pinning it to the Quick Access Toolbar on the very top left of the OneNote window. The QAT in Office apps was covered way back in ToW #321, from March 2016.

Docking has the effect of minimizing the UI for OneNote and sending it to a (horizontally resizable) section of your screen, on right-hand-side.

Usefully, it also means other apps respect that space, so even if you maximize another window, it will only grow to appear alongside your docked OneNote.

If you don’t like the position of the docked window, drag it using the “…” at the top of the pane, and position it on the top, bottom or the left side of the screen instead. If you press CTRL+ALT+D again while docked, it will fill the entire screen – maybe useful if you have a 2^nd monitor.

The rest of the minimal UI lets you access the pen menu, restore back to the full UI or you can use a somewhat obscure feature called Linked Notes. This will add a link back to another document that you could also be working on; you’ll see an icon showing the source document when you select text that has been linked.

Hover over the icon and you can get a summary or thumbnail of the document, and left-click the icon to open the document.

The original intent with Linked Notes was that you could use it across Office apps and also when browsing the web; how useful to be able to make notes on a specific web page and then jump back to the source when revisiting the notes you took! Sadly, the feature was integrated only to the dearly departed Internet Explorer, and it is not available in modern browsers. The topic of Edge support has been raised in online forums but thus far, responses have been less than forthcoming.

Even the Help page on Linked Notes talks about how it works with Word 2013, PowerPoint 2013 and other OneNote 2013 pages… no mention of Excel either.

If you do find yourself going back in time and using Linked Notes, you’ll see an additional icon (when un-docked and back in full OneNote mode) in the top right of any page where you have links, allowing you to go straight to the source docs or to manage the links themselves.

671 – Excel-lent

Posted on March 3, 2023 by ewand

Even old dogs like Excel have some new tricks up their sleeves. The spreadsheet application category was defined by VisiCalc in the late 1970s, and was a driving force behind the success of personal computers; accountants and finance managers and the like could quickly do their own sums instead of waiting for a report from the Data Processing department which fed and watered the big iron. When the PC came out, Lotus 1-2-3 was king of the hill and Microsoft’s Multiplan was an also-ran, until Windows arrived and the new Excel program moved from underdog to top enchilada.

First off, if you’re going to use Excel to create a table of some sort, start by Formatting as Table. It makes it so much easier to manage the data later – sorting, filtering, formatting are straightforward.

If you choose that your table has headers, the name of the top row will also be marked with an arrow to filter the list, and also appears in any formulae you might develop.

Rather than referencing cells in a formula by A2 etc, you could put the cursor onto the field you want to reference, and the name of the column will be used, and when you enter that formula, it can be easily copied to every row.

Excel has other smarts, though – let’s forget about formulae in this case, and just type the First name in column B; dragging the bottom right corner of that cell all the way to the bottom of the table, will fill every cell with “Mary” but a little Auto-Fill Settings prompt will appear at the bottom. Click that and you can change it to Flash Fill.

Et voila! Excel has figured out the relationship between the text and applied the same pattern to all the other rows in the table. Repeat the exercise in this case by filling Green in the Last name and MG in initials. A quicker way of applying auto-fill is to put the cursor in column C and press CTRL-E, then repeat on column D.

If you find yourself working with tables and the columns aren’t wide enough to show the data fully, you can quickly widen one column by double-clicking on the bar to the side of the column heading; select several colums at the same time and double-click on one of the width adjustors and they’ll all be resized to fit. The same trick works on rows, by double-clicking on the height adjustor on the far left of the row.

If you want to select all the table, put the cursor in the very top left corner of cell A1 and you should see it change shape to a diagonal pointing arrow; click once to select the whole table. Another way would be to put your cursor in the table and press CTRL-A; that selects the entire data portion. Press CTRL-A again if you want to include the header row too.

If you have the table selected, press ALT and release it – you’ll see a load of letters appear over the menus, which jump to specific functions. Press and release H to go to the Home tab, then O to jump to the Format menu, then I for auto-width or A for auto-height.

The final magic Excel trick for today is autocomplete.

If you start typing a text value in a cell, Excel might look at others in the rows above and offer you an autocomplete option – just press tab or downarrow and it will fill in that value for you. Another option is to press ALT and and down arrow ↓ when you first enter or select the cell; it will show a drop-down list of all the previous values, and you can either use mouse or up/down/enter keys to select the one you want. Excellent!

643 – Wireless extensions

Posted on August 12, 2022 by ewand

“A computer on every desk and in every home”; that original Microsoft motto, all the way back from a time when any sane person would have said it was nuts. Looking back now, though – hands up, who has only the one computer at home?

The WindowsKey+P shortcut key has been used since Windows 7, for sending your screen output to another device. At one point, this was maybe a meeting room’s projector – hence “+P”. You’d plug it into the VGA port on your laptop, press Win+P and you’re away. These days, does anyone “project”? Or just mirror or extend their desktop to another connected display or monitor?

You’ll commonly be able to wirelessly “project” to a large screen on the wall in a meeting room nowadays, rather than having to faff about with ceiling-mounted projectors, with all their bulb issues, noisy fans and the multitude of connectors required.

Windows 10 and 11 has a nice wireless projection UI, used to “Cast” to a wirelessly-available device, such as a TV which uses the somewhat messy Miracast standard. Either through native support, or by adding a media stick like Roku, Chromecast or FireTV, most TVs can be made to receive the display output of your laptop.

One somewhat underappreciated feature, though, is the ability to set your PC to be the recipient of wireless projection from another machine. This could be used to show something to a nearby colleague, displaying your desktop on their PC, or to share your PC screen to a room where someone else is currently plugged into the screen / projector, and you can project to their machine rather than unplugging them.

Lesser known is the ability to wirelessly extend your desktop to another PC, effectively using it as a 2^nd monitor.

To kick off proceedings, press Start and type project to find the shortcut to Projection Settings.

If you haven’t set it up previously, you’ll need to add the Wireless Display optional feature; have a look through the others in the same dialog to see if there’s anything else that takes your fancy.

After adding Wireless Display, you’ll be able to set various options about how and when to receive connections. Start the “Connect” app on the destination PC and you can run a source desktop in a window or make it full-screen.

This projection feature can be used to extend the desktop of your main machine onto a second PC.

If you have a spare laptop or a home desktop PC which has Wi-Fi capability, you could set it up to be the recipient of projection from your main work machine, as long as they’re both on the same wireless network, and without the need to join in domains or have the icy grip of corporate control extended to your own hardware.

Select the option to extend your desktop to the remote machine and you can use it just like an additional monitor.

As many of us are used to having multiple screens in our home office, it could be worth carrying a second laptop if you go into an actual office where decent 2^nd screens might not be available.

Having better kit at home than in the office is just one thing to deal with when going back to a workplace

623 – What’s .new pussycat?

Posted on March 25, 2022 by ewand

Many products evolve due to exposure to their competitors – adopting and refining the best features, and sometimes that evolution even starts to overtake the original. Many traditional desktop applications moved to online variants or were supplanted by newer concepts, such as shifting to mobile apps. Experiences that were clunky – like banking – moved to sometimes lower-functionality but more convenient apps, just as consumers adopted mobile payments and contactless cards.

Having blazed a trail with email in Hotmail and later Outlook Web Access, in 2010 Microsoft launched the first version of the Office web applications, meaning you could run lightweight Word, Excel and PowerPoint in your browser, as a companion or even as an alternative to the full-fat desktop versions.

A few years earlier, Google Docs released as an online word processor (and later, other types of productivity apps, rebranding as G Suite and now Google Workspace). There are pros and cons of the browser-only experience; you tend to sacrifice some functionality compared to the desktop applications in favour of ubiquitous availability, though web clients can be updated more easily and sometimes new features appear there first – as ToW #605 covered, with snoozing email.

Check out What’s new in Excel for the web or look for the summary covering Visio, Forms, Words and more, here.

Not sure about living in a browser? Modern-living afficionados can get by, using only web apps like Outlook, OneNote, To-Do and more.

If you like being browser based rather than desktop bound, you could start a new document from the address bar by simply entering word.new, excel.new or powerpoint.new. Others include docx.new, ppt.new, teams.new, sway.new …

You could add such links to your browser favourites; therefore, a new doc is but a single click away. There are many more .new shortcuts – Google’s in-house domain registry launched the service a few years ago, so not unsurprisingly, Mountain View hoovered up a lot of the relevant ones if you’re of a Googly persuasion. See docs.new, sheets.new or slides.new, mail.new …

612 – New Year, New You (someday/maybe)

Posted on January 7, 2022 by ewand

“The years go by so fast, let’s hope the next beats the last”– a sentiment that rings so true over the last couple of new year celebrations. Whether setting resolutions to do new things, read more, lose weight, be a better human etc, we all tend to reflect, even if just trying to do the same things as before but a bit better. Steve Clayton’s Friday Thing for the end of December had some great tips on things to do and try in the coming year.

If we can’t reduce volume of professional communications (be that emails, Teams messages, whatever – just look at Steve cleaning his mailbox and removing >100,000 Sent Items from a single year), then maybe we could do a better job of managing the stuff that we have to deal with. Much ink has been spilled on how to be more effective and how to get things done, but one useful time/focus management principle to revisit is sometimes known as Eisenhower’s Matrix, of which a variety of depictions exist:

The premise is that any task has separate degrees of importance and urgency; we tend to prioritize urgent and overdue things versus things that are actually important. Discipline in task management can give us the clarity to not worry about seemingly urgent yet non-important tasks, and to stay focussed on things which are important, regardless of their urgency.

Carve out 75 minutes if you can – because this stuff is important – to watch Randy Pausch’s lecture on Time Management, with the context that when it was recorded, he knew he only had weeks left to live: talk about prioritizing important vs urgent.

How you put time and focus management into practice will differ depending on your own style and what tools you want to use. For the Windows / Microsoft 365 user, there are a few quick wins to consider:

If you use flags in Outlook to mark messages needing your attention, think about setting a “Follow Up” search folder as the top of your list of Favorites. You can even make the Follow Up folder the default one so Outlook always opens that instead of your Inbox. You could try setting up a scheduled task to open your Follow Up folder every day (since most of us don’t restart our PCs very often, Outlook will typically stay running; this way will make sure you’ve got Follow Up open first thing every day)
Take better notes – remember that you can quickly create a OneNote notes page from an Outlook appointment; we’ll see some improvements coming to the original OneNote client in 2022, so if you’ve switched to using the ~~Metro~~ ~~Modern~~ Store app “OneNote for Windows 10”, then it’s worth revisiting the original. Do check out the fantastic OneCalendar addin to desktop OneNote, which helps you look back on notes you took.
Remember that Outlook Tasks and Microsoft To Do integrate with each other; see the Ignite session for how to use them more effectively. You can also highlight action items (from your meeting notes?) in OneNote, and quickly create Outlook tasks. While Tasks and To Do items don’t quite have full interop, there are 3^rd party solutions out there and there are lots of templates in PowerAutomate which can do groovy things with Tasks, notifications and so on.
The Windows 11 Clock app has a nice new “Focus sessions” time management feature, to help you concentrate on important tasks, and it now supports signing in with Microsoft 365 credentials so you can see your corporate Tasks / To Do items in the list.

To help maintain focus, you can quickly set your Teams status to Do Not Disturb by hovering over the application icon on your Taskbar and clicking the appropriate status.

If you’re easily distracted, you could also switch Outlook to Offline mode so you don’t get any new email whilst you focus – a good alternative to closing Outlook down altogether, since you may need it for whatever work you’re doing.

Go into Outlook, under the Send / Receive menu, click the Offline button on the taskbar and you won’t get any more email until you click the Offline button again to reverse the process and re-emerge later.

595 – Emoji reboot

Posted on August 27, 2021 by ewand

Emojis can trace their roots back to the first 🙂 from September 1982. Originally knows as emoticons or simply smileys, many of us have adopted these icons like a form of punctuation, especially in social media / Yammer / Teams type comments. This topic was last visited 4 years ago in ToW 391.

Emojis are mostly agreed and defined by the Unicode Consortium, which controls the Universal Coded Character Set, adopted by many systems to maintain compatibility between each other. When a user sends a symbol in a text message, the phone of its recipient needs to know which character was being sent or confusion may occur. Interpreting what the actual emoji symbol means is still down to the end user, and there are many pitfalls to avoid.

Once both sender and recipient of a message or comment agree which emoji to display, the application or platform they’re each using still has to decide what it will look like, and sometimes the iconography – and therefore the subtext – will have changed over time; see the Pistol Emoji (emojipedia.org) as just one example.

Microsoft decided to adopt a “flat” emoji look in the Windows 10 timeframe, but that is starting to change again with the upcoming release of Windows 11 and the evolution of Microsoft 365 – as Art Director and “Emojiologist” Claire Anderson previewed, we’re going 3D and Fluent, due late this year. Oh, one more thing…

ToW reader Paul Robinson draws attention to the shortcut way of inserting emojis in Windows – it’s been a feature for a while now – just press WindowsKey + . and it will allow you to insert emojis into pretty much anywhere that accepts text.

The UI for the emoji panel is changing in Windows 11 too, with GIFs and other types of symbol being included and the whole thing is easier to search. A useful tooltip shows you what the symbol represents, though as said before, be careful with the potential interpretation of some of them. Peachy.

In Windows 10, the same keystroke brings up a simpler yet slightly more confusing UI. Both old and new (under the Symbols grouping) provide a neat way of finding and inserting other special characters; arguably quicker than fishing about in the Office menu, and certainly better than faffing around with typing in ANSI codes.

Paul likes to start Teams channel names with an emoji, and if you want to illustrate one difference between old world and new, try using them in email subject lines and see just how they appear in Outlook versus Outlook Web App…

575 – Who’s meeting?

Posted on April 9, 2021 (Updated July 14, 2022) by ewand

Organising a meeting in Outlook means sending out requests to participate – effectively you’re creating an appointment or event in your own calendar, then converting into a meeting by inviting other people to join you. If you’re putting something in your diary and want other people to know about it, but without expecting them to join you (eg you’re going on vacation and presumably don’t want your teammates to tag along), simple tricks can reduce the annoyance you might foist onto your co-workers…

Create a separate appointment for sharing (rather than forwarding one already used to block out your own calendar)
Under Response Options, clear the default “Request Responses” option, so they don’t need to respond
Set Reminder to None so people don’t get a notification fired, unless you think you’re important enough to make sure they know at the time, that you’re away
Show As: Free, so your appointment doesn’t block out their calendar and get in the way of other people who are trying to book proper meetings with them. Think of this as an FYI for colleagues’ calendars.

Who has responded? Have most people declined?

When you open a meeting you’re organising and which you do want people to respond to, you’ve always been able to see (in the Tracking tab) how many people have accepted or declined etc. A couple of years back, Outlook added the feature of Tracking if you’re an attendee, so anyone in the same tenant as the organizer can see who else has accepted etc.

If you are organising or attending a large business meeting with lots of attendees, it’s useful to be able to slice and dice the attendees more effectively – have most people declined and should I move the date, for example – click on the big Copy Status option at the top of the list.

It’s now easy to paste the info into a blank Excel sheet, and before even changing selection, hit the Format as Table option on the Home tab; confirm the selection area is OK, tell it you want to add a header row and choose a style that suits.

If you right-click the table and select Table > Totals Row then if you filter the headings – like the responses, for example, you’ll be able to quickly see how many Accepted, Declined and so on.

What could be interesting, too, is showing attendees names alongside their role, department, which office they’re from, their actual email address etc…

Well, thanks to the magic of macros, use this Address Book Resolver spreadsheet, and just paste the responses from the Copy Status… step into cell A1, then hit the Resolve button.

Some attendees might be external users (so won’t be known to your address book), and some of the names in the first column might not be unique enough to resolve, and will be highlighted (alongside external users) by a red Unknown in the Job Title column.

If you manually look up an unresolved internal user in the Outlook address book, and find the correct alias name for that person, paste it into the first column instead of their name, and re-run the Resolve function.

To use this sheet for resolving any list of bulk display names or alias names, just paste them into column A (and hide Columns B and C if you’re not using the output from a meeting invite tracking list).

To prepare the spreadsheet for use, download the Address Book Resolver file as above (here it is again). Open the ZIP file and open the enclosed XLSM file or save it somewhere on your machine, then open it. Make sure you Enable Editing, then Enable Content so you can run the Macro that does the lookups.

This is an evolution of the Alias resolver sheet posted back in ToW 417.

566 – Who’s Better, Who’s Best?

Posted on February 5, 2021 by ewand

A little over 10 years ago, a then-Microsoftie called Philip Su rolled up his sleeves and wrote a website that helped him – and others – to traverse the corporate organisational structure; over time, other people and teams added functionality and even depended on the service, to the extent that it was eventually picked up by the IT function and supported as a corporate tool.

“Dr Whom” (sic) showed profile pictures of people along with reporting hierarchy and other contact info gleaned from the corporate directory, alongside self-provided stuff like what projects you were working on or what interests you.

There are plenty of other ways to look at corporate structure and profile information, assuming they’re correctly defined in the directory – there’s the /who app in Teams, for example, as featured in ToW #487, and there’s also a quick way of looking at someone’s Org chart by entering /org in the search bar on Teams – the quick way being to press CTRL+E to jump to the Search bar, then type /org [TAB] name (or enough of the name to have your target showing at the top of the list) then [ENTER] to jump straight to the Organisation tab of their contact.

You can find the same information in desktop Outlook by opening someone’s contact or profile card, or in the Microsoft 365 “People” web app. Outlook & People bring together both a corporate directory and your own personal contacts list. Did you know, incidentally, that the silhouette shown in Outlook 2010 for a new contact (if you didn’t provide a photo) was based on an infamous photo of a well-known business leader?

But inside MS now, Dr Whom has been succeeded by Who+ (accessible to FTEs), which brings much tighter connections with LinkedIn, giving more of an emphasis to discoverability for networking internally, finding new career options and the like.

One question not listed in the Who+ FAQ is, “Will Who+ be available to customers?” – and the answer is: no, not yet – it’s just a Microsoft internal tool for now.

One reason may be the recent announcement of Microsoft Viva – an employee experience platform, which appears to be an amalgam of existing Microsoft 365 services (Teams, SharePoint, Yammer…) with LinkedIn, and a load of forthcoming new functionality plus 3^rd-party services and tools.

Back in September, it was announced that Microsoft was working to try to help employee burnout during the pandemic, and partnering with mindfulness experts Headspace was one example bringing in external content. Satya talked with Headspace’s Andy Puddicombe during the Ignite 2020 keynote.

Most of the Viva platform is still in development, but some applications – like Insights – are being repackaged as part of the initiative.

Check out the Viva Insights app which should already be visible in Teams – click the Apps icon in the Teams bar on the lower left, and search for Insights to add it. Insights helps to surface things from your email, and also identifies time that you could protect as Focus Time – so you don’t get interrupted.

Thinking about naming, make sure you don’t confuse Viva with the 1970s saloon from Luton (as El Reg pointed out) or its revived but short-lived modern snooze-box cousin. Or with paper Mexican donkeys. Or that song by the well-known crooner. Just visit http://aka.ms/viva to find out more.

529 – To Do: Switch off Wunderlist

Posted on May 13, 2020 by ewand

Nearly 5 years ago, Microsoft acquired a German developer called 6wunderkinder, who built a cool, cross-platform task management tool, Wunderlist. Over the half-decade since, the back-end of Wunderlist was basically rebuilt so it could run on Azure (instead of its previous cloud platform), and many of the team who had developed Wunderlist moved to working on the Microsoft To Do app suite.

The ~~To-Do~~ To Do apps have evolved hugely over the last couple of years, and collectively are being positioned as the natural successor to Wunderlist.

This week, Wunderlist was finally closed down. If you still have the app, you can carry on using it but the data won’t be backed up or synced and you won’t be able to migrate it. You can export the data from the service, and To Do has built-in Wunderlist migration tools that bring more-or-less everything across. Other task managers are also available.

The Microsoft To Do service has integration with PowerAutomate (previously known as Flow).

The To Do team also updated the mobile apps (as announced on their blog), with a collection of new features and views of tasks, and the Windows app has also been tweaked lately too. New features include new Smart Lists, such as “All”, which shows everything in one huge list, grouped by category.

“Tasks” across different apps are being integrated more and more – To Do now lets you create tasks from flagged emails, or integrate tasks from Planner. Teams is going to rationalise tasks into a single UI too.

See here for more tips on using To Do.

512 – Sticky Notes and Glancing

Posted on January 20, 2020 by ewand

Happy New Year! Whether it’s a way of keeping up with the NY resolutions you haven’t broken yet, or just a casual way to remind yourself to do stuff, Post-It Notes or the more generic “sticky notes” can be a useful tool. ToW # 446 talked about a handy Windows app that is now installed by default on Windows 10.

Sticky Notes has been through a number of iterations, and now in v3.7 it’s looking pared back yet really functional. Sure, you can use Outlook Tasks and To Do to track significant actions, long-term projects and the like, but sometimes you just want a simple list to get you through the morning or to take shopping.

If you open Sticky Notes, and click on the body of a note itself (to set focus to that window and start editing the text), then you’ll see the menu and close controls; clicking the menu lets you quickly change the colour of your note (so if you have several open, you can tell them apart, maybe) or jump to the Notes list that shows a summary of all the stickies you have lying around.

Another quick way of getting to the notes you have is to right-click the Sticky Notes icon on your taskbar.

You can type, write (with your finger, or a stylus), or grab pictures from camera or existing files, all into a note, then share and make sense of it later.

You can sync your sticky notes to other devices: just go to the settings icon (from the taskbar context view or within the Notes list) to configure syncing using either an Office 365 or Microsoft Account.

Sticky Notes has even replaced the venerable “Notes” function in Outlook, which has been around since 1997 – go to the Wunderbar in Outlook and you may need to click the ellipsis to see the Notes pages; it’s very old-school looking and not everything is carried over quite the same, but it’s a welcome integration that replaces another duplicate way of doing the same thing. It’s part of a long-term plan, so it seems.

Multi-device

Sticky Notes show up on the web and are also accessible on iOS and Android devices via the OneNote app…

If you set up sync between devices, it’s quite amusing to open the web client, the PC app, and then on your phone, add a new note… and see the other two update within seconds. Technology #ftw – far more useful than the kind of toot being peddled at CES in Las Vegas this week.

On an Android phone, though, the best way to use Sticky Notes is through the integration with the Microsoft Launcher – if you’re not a phone tech geek, you might not realise that with Android, you can supplant the entire home screen UI of the phone with any number of variants.

Microsoft has a mature and highly regarded launcher, that has an average review score of 4.6 across over 1 million reviews – how many apps in the Windows store can beat that…? See more tips on using Launcher.

When you have the Launcher installed, the “Glance” screen is only a swipe away – on the home screen, swipe from left to right to flick over to this summary that lets you see a customisable list (click the stack on the top right) of important or interesting info.

The Calendar summary lets you jump straight into a Teams meeting, you can show “screen time” stats, or scroll to the bottom to add more widgets from any number of apps you have installed on your phone.

Cortana integration featured in the Launcher at one point, though it’s planned to disappear for many of us.

In a “for your comfort and safety” type announcement, news came that Cortana will disappear from the phone in favour of being part of other M365 apps in time. More to follow, no doubt…