Last week’s ToW was the six-hund Other numbers attract a certain amount of superstition – some tall buildings don’t have a thirteenth floor, for example, and even big companies like Microsoft have been known to
But look at the hamburger menu on the top left and you’ll see so much more – from Programmer functions to convert numbers from There’s a neat date calculator too, so you don’t need to resort to using an Excel formula to count how many days there are between two dates. Back in Standard mode, you’ll see the history of your calculations on the right side, and you can use the Memory functions to store multiple numbers for future use; much better than the old one-and-done M- If you have a full-sized keyboard, you’ll also probably have a NumLock key – that turns the numerical keypad on the right side on and off. In the early days of the PC, smaller keyboards didn’t have separate cursor keys, so these were sited on the keypad. In order to use these cursor functions – and the others, often doubled-up PgUp / PgDn etc – you’d switch NumLock off. And then swear when you went to use the numerical pad to quickly enter a number into some DOS application, only to find you’ve moved the blinking cursor around instead. *convert each of the 8-bit binary numbers in the t-shirt to decimal; assuming the decimal number is the ASCII code corresponding to a letter, open a new blank doc in Word, and holding down the ALT key, enter the decimal number on your numeric keypad. Oh, if you’ve only got a laptop with no separate Numlock/keypad, bad luck. |
Tag: Office
649 – Exploring SharePoint libraries
SharePoint is now old enough that it could walk into a bar and buy itself a beer. It has changed a lot over the versions; starting out as a server product that would produce “portals” (or “digital dashboards”) it grew quickly to being rather more document-centric. SharePoint became the back-end for OneDrive for Business storage, and both have evolved a long way.
Two years ago, SharePoint was said to be used by over 200 million users. The following year, the Gartner MQ had it way out in front on the “Ability to Execute” Y-axis and slightly behind only one other supplier on the “Completeness of Vision” X-axis. It won’t be long now for the next MQ report to appear.
Nowadays, SharePoint underpins quite a lot of Microsoft 365 functionality, such as apps like Lists which provide a groovier UI over the top of the base web services, and the document oriented collab in Teams.
If you look at a file library in Teams, you’ll see a bunch of SharePoint-y options – you can Sync the content offline and it will be held offline, using OneDrive to sync it (and if you like, syncing only the files you’ve opened rather than the whole shebang).
The Sync’ed libraries show up in the Windows Explorer app, and in any number of applications’ File | Open / Save dialog boxes, so you can access and interact with the files through the apps you use rather than browsing to SharePoint.
You’ll see a collection of folders that have been set up to Sync, shown with your organization name, alongside any personal OneDrive and OneDrive for Business synced libraries.
The Download option (next to Sync on the Toolbar in Teams), creates a single ZIP file your computer, with the entire contents of the folder you’re looking at, so use it carefully.
One somewhat overlooked option further to the right of the toolbar (or may be on the ellipsis (“…”) menu): Add shortcut to OneDrive. This creates a shortcut link to the current SharePoint folder within your main OneDrive for Business storage, making it easy to find that SharePoint folder in the future, even though it’s not synced offline. The Add shortcut option is also visible on the ellipsis to the right of sub-folders when viewed in SharePoint or Teams.
Don’t add shortcuts to libraries – or sub-folders – which are already being Synced offline. That would be bad.
One downside to the OneDrive shortcut approach is that it just dumps the link into “My Files”, which is the root folder in OneDrive. The shortcut is named the same as the original source – so if you have lots of Teams folders with the same name (eg “Documents”), they will clash with each other as adding a new link would try to create a shortcut with the same name as one that exists already.
One solution would be to create a subfolder in OneDrive, called Sites (or similar), and after creating the shortcut to your latest Teams/SharePoint site, go to the root OneDrive folder and move your new shortcut – maybe renaming it too, so you can see what its parent site was (since the shortcut doesn’t make it clear what the source SharePoint site is) – you’d then have a Sites folder with lots of Shortcuts like Project Team – Documents etc.
Another side benefit of using shortcuts rather than Syncing offline, is that if you have multiple PCs – or feel like accessing OneDrive through a browser on a different machine altogether – you will always have access to the same collection of shortcuts, whereas the Sync offline capability is configured separately on each machine.
#639 – Macros, Ghosts and GALs
Since the early days, Microsoft always kept an eye on what its competitors were doing. It was once de rigeur to produce “battlecards” which would show feature-by-feature how one product is better than its competitor, thus assuring the customer they should buy this one. Thankfully, times have mostly moved on to just building as good a product as possible and then let customers and the markets decide – sometimes, they get improved and honed over time to be the best out there, and sometimes they get dispatched to the boneyard as times move on.
In the late 1990s, Office and Exchange (and later, SharePoint) Server were seen as Microsoft’s entrants into the burgeoning “Groupware” market, which became subsumed into “Knowledge Management” c2000. Key competitors to Exchange & Outlook were Lotus Notes and Novell GroupWise, both of which came from being collab tools and gained email functions. Notes was arguably much more mature and feature rich even if the UI was sometimes clunky, GroupWise was much leaner but found a niche in several industries. Amazingly, GroupWise is still a thing and Notes evolved first into IBM Notes/Domino and was eventually sold off to now be HCL Notes and HCL Domino.
One of the early moves Microsoft made to elevate Office apps to more than just writing documents, was to try to make the docs more capable through adding Macros, and later, Visual Basic for Applications. This allowed a moderately skilful user to dabble in programming to make smarter applications centered around documents; what seemed like a good idea at the time unwittingly unleashed a wave of malware, where bad actors wrote macros to do undesirable things. Following the “Melissa” worm in 1999, Office stopped Macros running without asking the user for permission. Using Macros for anything more than tinkering never really took off.
Macros disabled entirely
Microsoft announced in February 2022 that all Office Macros in content received online would be disabled completely; this was temporarily rolled back in some test builds for some changes to be made in how it works, but for many, the warning will still be there if you open a Macro-enabled file that you’ve downloaded or been sent.
There are still some very useful Office macros out there, and if you do need to run one that you know is from a trustworthy source, there is a workaround – save the file to your PC locally, then right-click on it to look at the file’s properties, tick the “Unblock” option and apply that. You’ll now be able to choose to run the macro unencumbered.
One such handy macro was discussed back in December 2021 in ToW 611, and is used to find Ghost meetings – ie ones you have arranged but everyone has declined (or at least not accepted). The macro spins through all future meetings in your calendar and lists the ones you’ve organised but where you’re likely to be the only attendee who shows up. Particularly useful at this time of year if lots of people are about to take time off over the summer, and may have declined a few recurring meetings but you – as organiser – still have them in your calendar.
For the latest version of the macro, download the ZIP file to your machine and expand it (or just copy the XLSM file that’s within and put it somewhere else), do the property Unblock thing as above, open in Excel, click the button to allow content, then the Scan Calendar button and you’re all set. You still need to go into Outlook and look at the appropriate date then decide if you want to cancel those meetings or not.
Another more powerful macro – though a little more esoteric – is one which does bulk resolution against the Global Address List, so if you give it a list of display names and/or alias names, it will show the full name, title, department, office, email, and alias name of that person. Handy if you want to get the full details of everyone who is going to attend a meeting, but if you just have a longish list of names then you could just paste them in and see how it goes. This was covered back in ToW 575. One usage scenario recently was to estimate the number of people who were attending a group meeting, but were based at other offices and would therefore need accommodation.
Here’s an example output of over 500 names who were invited to a large meeting; by just providing their display names in column A, it took the sheet about 30 seconds to complete, with 10 identified as distribution lists and 50 unknowns who couldn’t be resolved, either due to no longer being in the GAL or because there were more than one possible name listed.
If you can manually find the unknown person/people in the GAL, then get their alias name and paste that into column 1 instead of the ambiguous display name, then try to run it again.
632 – New Old Things
OneNote has featured plenty in ToW previously, including a mention in the recent Journaling tip, with a nod in SteveSi’s ongoing historical missive which described members of the development team unhappy with the change of name from its code-name “Scribbler”, referring to the new “OneNote” app as “Onay-No-Tay”. A few years ago, OneNote was dropped from the Office suite and was due to be replaced by the new “modern” version in the Windows (now Microsoft …) Store. For a while at least, that shiny new one got all the innovation, even if its brand-new architecture meant it missed a lot of the old app’s functionality. In a somewhat surprising but welcome turn-around, old OneNote was reprieved, and both apps are going to converge at some later point – ie the desktop one will pick up features that only exist in the Store app, and eventually that version will cease to be.
There’s a more prominent “Add Page” button More is to come, including improved sharing capabilities and a neat dictation functionality that would allow you to record a spoken explanation for something while using Ink to highlight or illustrate; when another user plays back your monologue, the ink will be synchronised too. For more info on what’s coming, see here.
Copying screen-grabs when someone is doing a demo in a browser, so you can get the long and complex URL for the thing they’re showing is a particularly useful way of using this feature. |
625 – Journaling now and then
Turning to technology and looking back to relatively near-term history brings up all kinds of product that was ahead of its time or was ultimately overtaken by other developments that nobody saw coming. Sometimes, the perfect blend of genius, timing, execution and luck combines and creates a durable and wildly successful category – like the Smartphone and the plethora of services and apps that were created. Inversely, one of those tech innovations that was just a bit ahead of its time was the Tablet PC; a fully-functional Windows PC that was blessed with a pen and touch screen so you could take notes by hand just like on paper, yet by flipping it around it could be used to run Office apps and all the other stuff you’d need a PC for, 20 years ago.
One new app that was built for the Tablet PC to take advantage of its pen, was Windows Journal, a relatively simple yet effective note-taking app, with surprisingly good handwriting recognition built in. To read more from someone who was in the room – figuratively and, at times, literally – around the time of Tablet PC, the Journal software and the Office app originally called Scribbler which went on to become OneNote, check out Steven Sinofsky’s Hardcore Software post. It’s a fairly long but fascinating read. Using pen and paper for taking meeting notes might be less popular now, but many of us will still jot down reminders or lists on Post-it notes, perhaps doodling on paper to help creativity and flow. If you have a pen-capable computer now, the newly released Microsoft Journal app is worth a look. Billed as an app for digital ink enthusiasts, this new Journal presents a modern take on the original Windows Journal idea – an infinitely scrollable canvas for jotting down anything, though with AI capabilities in the app providing quiet yet powerful functionality. Journal started as a research project (from the “Garage”), but has now graduated into a fully-fledged, supported app. Read more about it here.
|
623 – What’s .new pussycat?
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.
If you like being browser based rather than desktop bound
|
602 – re-drawing Whiteboard
Fortunately, there are digital equivalences – you could be in a Teams meeting and co-authoring a document, where multiple people are editing at the same time and marking up comments. You could be watching someone share their 4K screen so they can walk through only a few dozen PowerPoint slides, or you might even have had a play with the shared Whiteboard app that’s been around and been part of Teams for a while now.
The whole UI has been given an overhaul in line with the latest colourful design ethos, and there are lots of neat new features like the automatic shape recognition for mouse-driven drawing. Hold the Shift key down while you’re drawing with a mouse pointer or a Surface pen, and it’ll straighten lines for you. It’s available in a variety of guises; there’s a web UI (app.whiteboard.microsoft.com) and it shows up in the menu on the top left of Office 365 web applications, such as subscribers would find by going to office.com and signing in with your ID. It’s on iOS and Android, though updates may flow through at different rates to other platforms.
You can pin whiteboards to Teams channels or chats too; just add a Tab, select Whiteboard from the app list, and the content will persist within that context rather than a point-in-time meeting. |
595 – Emoji reboot
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.
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.
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 |
593 – It’s a Date
On the Insert tab / Quick Parts, look under Field, then pick the doc property and format you’d like to show. It is worth pointing out that showing a date as 10/1/21 (or similar) is ambiguous given that a few hundred million people will expect it be month-day-year while many of the remaining 7 billion will assume the day comes first, with a couple of billion presuming the format should normally start with the year, such as yyyy-mm-dd (which is arguably the most sensible of all; and it sorts properly, too). A more daily usable short format like dd-mmm-yy (ie 13-Aug-21) should perhaps be the norm, especially when the date is appearing as text in a document. Pressing SHIFT+ALT+D in Word will insert the current Date as a field (so you can edit the format to remove ambiguity) and SHIFT+ALT+T inserts the current time too. In PowerPoint, both of these combos bring up the “Date & Time” dialogue to add the chosen content and format as plain text.
While in Excel, it’s worth learning the short cut key to insert the date and time – CTRL+; and SHIFT+CTRL+; respectively (no doubt there’s a reason why Excel has a different shortcut to other Office apps – some legacy of Lotus 1-2-3 perhaps?). OneNote fans will want to remember that SHIFT+ALT+D / T combo as it inserts the date/time into the notebook; really handy when taking notes of a phone call or similar. SHIFT+ALT+F puts both day and time, something that Word doesn’t offer. In both Desktop OneNote and users of the Windows Store version, it’s just plain text that gets added, so you’re on your own when it comes to formatting. OneNote pages will typically have a date & time showing under their title – on the Desktop version, it’s possible to change that so as to mark a page as having been recently updated. No such luck on the lame duck Store version.
At least when stalwarts insist on writing – or worse, saying – a short-form date as something like “ten one”, there’s more than half of each month where one number in the date could only mean “day” – starting with the thirteenth (as in, 8/13 can never by the 8th of a month, but 8/12 could be a few days before Christmas to Europeans, or the date when tweedy Americans start looking for grouse in the Yorkshire moors and Scottish Highlands). |
578 – Let’s talk about fonts
![]()
Yet, there is a lot of thought which goes into creating a font, especially when considering how it’s likely to be used. Typeface design goes back to the earliest days of printing, with fashions changing from heavy and elaborate block type to lighter and perhaps easier to read lettering. To serif or to sans? The author Simon Garfield has written extensively on the subject of typography, including articles on What’s so wrong with Comic Sans? or The 8 Worst Fonts In The World and his really excellent book, Just My Type, which delves into the history behind lots of common typefaces and how or why they came about. It really is fascinating. Even the design of the text used on road signs was a hot topic in the 1950s, with the UK facing a need to choose a standard for the upcoming motorway network, which could be easily read at speed. Designers Jock Kinneir and Margaret Calvert came up with many road signs and the typeface design still used today (theorising that at 70mph, a driver looking for Birmingham won’t actually read the letters, but will recognise the shape of the word). Trials were done by fixing words to the top of a Ford Anglia and driving it past a group of seated, bemused volunteers, to test the fonts’ efficacy. A lot of technology we take for granted today has its roots in the 1970s at Xerox’s PARC research establishment or was materially advanced there – ethernet, bitmapped displays, laser printers, the mouse, the GUI, object orientation, distributed computing and so much more – and the two founders of Adobe, who went on to define PostScript, started their work together there. This font-rendering software – along with the Apple Macintosh & LaserWriter and the Desktop Publishing software PageMaker – laid the way to revolutionise the printing industry.
“Cloud Fonts” are available to Microsoft 365 subscribers (more info here) – in Word, go to File / Account and look for the optional settings. Five of the Cloud Fonts collection are being considered to be the new default font for Office apps in the future… which would you choose?
|