Microsoft 365 – the subscription / annual fee plan for Microsoft Office on Windows, Mac, iPhone, iPad and Android.
Includes Word 365, Excel 365, PowerPoint 365, Outlook 365 and many other ‘365’ programs, apps and services.
Extra linked data types in Excel 365
Excel 365’s Linked Data Types have gone beyond the original Stocks and Geography feeds. Now there are more Linked Data Types to pull more public information into Excel 365 workbooks about diverse topics as Anatomy, Chemistry, Plants, Movies and more. It’s a massive extension of the existing Stock and Geography data types like AnatomyAnimalsFoods: calories, […]
Windows 11 has a better way to clone an existing file
There’s a quick way to clone or duplicate an existing file in Windows 11 so you can make a new, similar document. Quite often a new document is based on an existing one, for example a fresh invoice for the same things each month. Or a proposal to a new client, which is similar to […]
Why Word treats the top and side number pad keys differently
Why are the numbers on the numeric keypad are different from the number keys on the top row of the keyboard? How to use either set of number buttons in Microsoft Word. “I don’t understand why pressing a number on the main keyboard is different from the number pad (assuming you have one). Aren’t they […]
Outlook Time Zone for London and UK
“I’m confused. In Outlook there are two choices for a UK/London time zone. UTC or London. Both are zero meridian (+00:00). What’s the difference and why isn’t an entry for GMT?” Oscar R, Missouri. The quick answer is to always choose the time zone entry that matches the city or country (near enough). Ignore the […]
Unhappy G Suite customers can save 60% on Microsoft 365
Sensing a big opportunity to poach Google customers, Microsoft is offering a 60% discount starting deal to unhappy G Suite customers. Here’s the details and inevitable conditions. Google has angered many G Suite customers with their plan to ‘upgrade’ free plan customers to a paid account. Microsoft has moved quickly (by Redmond standards) to take […]
Understand the Show All markers in Word
Here are the major marks Microsoft Word displays with the Show All option on. There’s common ones like Paragraph Mark, Tab and Space and lesser known such as optional hyphen and hidden text. Show All will also display the seven different types of break in Word. Paragraph Mark, the symbol is called a Pilcrow. It’s the symbol used for the ‘Show All’ button on […]
Reveal Hidden Characters and Word’s secrets with Show All
If you are working on a Word document with complex formatting, sometimes you need to see the hidden characters and unseen workings. It helps figure out Word’s secrets or what’s going on when the layout doesn’t behave. That’s where ‘Show All’ becomes essential. Microsoft Word was designed to hide all the formatting and technicalities (WYSIWYG). […]
Add current date or time into PowerPoint
There are limited options for entering the current date and time into PowerPoint slides, notes and handouts. PowerPoint doesn’t have field codes like in Word, so Microsoft seems to have shoehorned in some field like features. Insert Date and Time in slide On the Insert Tab, right side there’s an Insert Date & Time button. […]
COUNTIF for Excel
The COUNTIF worksheet function in Microsoft Excel has a simple format that provides a quick and easy way to count the number of times a certain condition is met in a data set. By Kara Monroe That sounds imposing but it isn’t. Most likely you already use COUNT to count the number of cells that […]
Excel how to remove both items if a duplicate
Excel has an in-built feature to remove duplicates from a list but what if you want to delete both items if they are duplicated or more than two? Remove Duplicates Remove Duplicates is tucked away on the Data tab, Data Tools | Remove Duplicates. It will ensure that an Excel list/table has only unique values […]
Changing Caption look in Word or hiding captions completely
The appearance of all your captions in Microsoft Word can be changed by modifying the style that is applied to them or selecting the text and formatting manually. See Adding Captions in Word Caption Style All captions use the ‘Caption’ style, so modifying that style will modify the format of all past and future captions. Style […]
Adding Captions in Word
Captions let you add autonumbered labels under most Word objects including pictures (figures), tables or equations. Captions can be combined into a list of all the figures/tables/equations in the document, along with their page numbers. As usual in Word, there are many options beyond the simple adding of captions and some ‘gotchas’ as well. See Changing […]
Three ways to add EPS graphics into Microsoft Office
Three ways to insert or import an EPS (Encapsulated PostScript) graphic into Word, Excel, PowerPoint or Outlook. There are two a ‘quick and dirty’ options and a way that allows some editing. Microsoft Office did support EPS files for many years but dropped them in 2017/2018 because the EPS format is a security risk. EPS […]
Draw with Touch in OneNote Web
Draw with Touch is available for users with a touch-enabled device. Simply draw with your mouse, digital pen, or even your finger on your OneNote page. You might be familiar with Draw with Touch on OneNote for Windows desktop. Great news, this feature has recently been added to OneNote for web browser. Simply go to […]
OneNote can now sort pages!
At long last, OneNote can sort the pages (tabs) either alphabetically or by date. Previously in OneNote, if you wanted to sort out your pages, had to do it manually by dragging and dropping the tabs. Microsoft has now added an automatic Sort Pages option. Right-click on a page tab to see the sort options. […]
Fix the buggy patch that stops Access databases from opening
The latest patch for Microsoft 365 has a serious bug that’s stopping Access from opening many local database files. Here’s what’s happening and two ways to fix it. There’s been no official acknowledgement from Microsoft of the bug or workaround but there are online reports from affected users. Some of those same people have figured […]
