Microsoft Office, especially PowerPoint and Word, have simple and easy ways to ‘jazz up’ a simple image, flag or logo with one of the many framing options. Instead of just copying a graphic into a document or slide, try one of these variations. They retain the original image but give
If Office for Windows shows Unlicensed Product errors, there’s a bewildering range of errors and prompts appearing. Here’s what to do, and in what order, to solve the problem. Starting Office for Windows and you’re greeted with various warnings like this. Subscription Expired may or may not be true. This
One of the sillier online debates is an argument about the usefulness of algebra and other maths skills in a world where Excel is available on almost any screen. To us this is silly because it’s not a simple either/or choice. It’s about balance, a concept that’s not fashionable these
Microsoft has updated their Online Services Terms to clarify some privacy issues but concerns remain. They’ve also added yet another document to the confusing mix of legalese customers are expected to understand. Back in August 2019 the Dutch Ministry of Justice released a report that recommended against using Office online
The US National Security Agency (NSA) discovered a serious security bug in Windows and, for the first time, told Microsoft so the company could fix it. That bug could also affect Microsoft Office or other programs. It’s important to update your Windows 10 asap, that’s not our opinion, it’s the
Here are two options to stop Microsoft Office for Windows from automatically updating itself and why you might want to do that. Office for Windows All versions of Office that have current support (currently Office 2010 and later) get: updates to fix bugs in the software patches to stop security
He’s done it again, David Peel has quickly made up a new version of his Excel Year Planner that starts the year from any month you choose. Great for academic years (start in August) or financial years (e.g. Aussie start in July). The year selector is top left of the
Here’s the bug fixes and changes in Office 2016 just released by Microsoft with a summary of what caught our eye. Outlook 2016 – secure email changes KB 4484212 The default hash algorithm for S/MIME changes. The default is SHA1 except when a new registry key is present. Details in
The second Access memory leak has finally been patched by Microsoft, almost a year after a very similar problem was discovered. These bugs have been around since 2002 and the effects are still in some Access files. Both are faults in the way Access saves data to memory locations in
PivotTables and PivotCharts from scratch in a new edition strips away the techobabble so you can make your own PivotTables and make sense of any list of numbers or information. We do that with plenty of step-by-step instructions and, crucially, Excel worksheets you can open and try for yourself. Understand PivotTables by looking at expert examples,
It’s possible to apply individual cell formatting in Word consistently using a little VBA code. In effect it makes styles for cells in a way that Word itself won’t do. Reuse this code to apply the same formatting to many cells. Cell Format Special We’ve made two VBA functions for
Nested IF statements can be hard to understand and manage but there are alternatives which can be easier to handle, fix and change. We’ll start with the relatively simple example we used for demonstrating IF and nested IF. =IF(C2>89,"HIGH DISTINCTION",IF(C2>79,"DISTINCTION",IF(C2>69,"CREDIT",IF(C2>49,"PASS","FAIL")))) This example has only five levels of nesting, we’ve seen
Time is running out before the end of support for Windows 7. Here’s what’s happening, what to do, what not to do and the way some Office 365 users can still use Win7 with Microsoft support. The end of Win7 support affects many people and businesses. Even in late 2019,
If you want to take the plunge to Solid State Drives, here are some comments from our experience. Mostly for portable computers SSD’s are usually installed on portable computers to take advantage of the lower power usage. That means your laptop can run longer on the same battery charge. ALWAYS
Are there any advantages to getting an Solid State Drive (SSD) when running Microsoft Office? We have some advice from actual use. Solid State Drives are faster and power saving drives that are now less expensive and more available, but are they worth the trouble for Office users? YES —
Criminals don’t even respect Santa and the festive season with malware infested emails pretending to be holiday schedules or the Christmas party. Is nothing sacred? Cofense Labs report that Emotet botnet is being spread via Word documents with timely emails for the end of the year. All these dangerous emails
It would be great to share draft emails between Outlook on different devices including iPhone, iPad and Android. You can start a message or reply on a smartphone and finish it later on a computer. Sharing drafts between Outlook for Windows or Mac has been possible for many years, only
The latest ebook from Office-Watch.com is a little different, it’s a heartfelt ‘Thank You’ to our Office Watch donors. Peter and Victor have again been quite astonished and humbled by the generosity of readers to our reader appeal. Both the money and kind remarks have been a considerable morale boost
Microsoft has added Dynamic Array functions to Excel for iOS (iPhone and iPad) and done it in an uncharacteristically low-key way. Dynamic Arrays are now available across all Office 365 platforms; Excel 365 for Windows and Mac, Excel for Android, Excel Online (web) and now Excel for Apple devices. That’s
An Office 2019 offer that looks like a good deal for just $39.99 or maybe a scam? Microsoft seems to endorse the seller with a mention and link from Microsoft.com so how could it be wrong? We’ll explain why we know it’s not a proper offer, so you can judge
The Office apps on Windows 10 Mobile devices have now ended main support and will end security updates, hotfixes and support in 2021. It’s an unsurprising announcement and another death notice for the failed Windows 10 Mobile platform and phones. Source: Microsoft, from happier days when Win10 phones were ready
In a recent blog post Microsoft explained some of their thinking behind the redesigned Office mobile apps like the new ‘all in one’ Office app. The company has done a lot of research into the way people use their mobile devices, including the many people who only use a smartphone
Pantone has announced its Color of the Year for 2020 here’s how to get it in Microsoft Office – Word, Excel, PowerPoint, Outlook etc. The color of 2020 is … Classic Blue Source: Pantone As usual what’s more amazing than the color is the description from the ‘Pantone Institute’. Classic
Outlook’s Groups support is improving with ways to filter Group emails and let you control which emails appear in the Inbox. Admins can manage the names given to new groups, enforcing prefix/suffix and stop specific words from appearing in Group names. This is new in Outlook 365 for Windows v1912
