An IF statement might sound like a complicated thing that programmers do, but it’s actually fairly easy to do in Excel. An IF statement basically puts something into a cell depending on certain conditions – if A is true, put X in this cell. You can even use what’s called a nested IF statement if you have […]
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 important milestone that Microsoft […]
Here’s just one example of Office 2019 offer that looks like a good deal for just $39.99 or maybe a scam? We’ll explain why we know it’s not a proper offer, so you can judge similar offers. Keith H, an Office-Watch.com reader sent us a link asking “Is this a ripoff or is this a […]
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 to take over the world […]
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 with no laptop or desktop […]
The red ribbon and bow design from the movie, Love Actually, is widely copied emulated, we’ll show how to make a version in Microsoft Office, Word or PowerPoint. You’ll often see Christmas designs inspired by the poster. On the same day Peter saw two different ads at a train station, both using the same look. […]
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 Blue is: reassuring thought-provoking dependable […]
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 build 12325.20012. ‘Insiders’ first and […]
At last! The clutter of right-hand panes in Microsoft Word is ending and we’re getting tabbed panes. Very welcome news for laptop users with less screen real estate. This is new in Outlook for Windows v1912 build 12325.20012. ‘Insiders’ first and later for general release, with a proviso mentioned below. According to Microsoft: “ Now […]
Sometimes we want to change the margins around a Word document, either to change the way the page looks, or to get the text to fit onto the page. To do this, go to Layout > Margins or use the Ruler to drag the margins. There are several default options that you can choose from. […]
Yet again, a bad deal for Office 365 is being offered on Amazon and it’s even worse than last time. In March there was an offer on Amazon for Office 365 Home (retail $99.99) plus an Amazon gift card $50 for a total of $149 – a ‘massive’ saving of 99 cents. It’s on again […]
There are several ways for an Excel table to be transposed (rows and columns) but none of the online suggestions work very well with tables. We’ve found a solution which transposes one table into a ‘swapped’ table i.e headers become column A and column A becomes the headers. Along the way we’ll explain a clever […]
Now rolling out to Insiders is a preview of a new look in Outlook for Mac. Here’s what’s on offer and how to get it. Limitation There’s an important limitation on the new interface that’s not given enough warning by Microsoft. It’s only available if one of the email accounts is Office 365, Outlook.com or […]
You can make it easier to see your current place in a workbook by dynamically highlighting the selected row, column, cell or headings. Here’s obvious and more subtle highlighting options plus the downside of highlighting, real world tips and debugging tricks if you’re having trouble. There are many different variations on this method; two colors, […]
The Office apps for Android are getting some interesting new features. Excel for Android has better sort and filtering. Galaxy Watch can now link to the Outlook app. At first for preview ‘Insiders’ and later to the publicly available Word, Excel, PowerPoint and Outlook apps. Here’s Microsoft announcement of the new features with their images: […]
Microsoft is ending their Delve blog service starting later this month. It’s being done with little notice and in a very round-about way. Delve blogs aren’t widely used and their end has been anticipated by some network admins. Even so, Microsoft has badly handled the announcement. Instead of a Microsoft blog post or some official […]
Just one of the many tricks to get people to giveaway their password is a bogus ‘system delay’ email, supposedly from your network administrators. The fake login page is given extra credibility being hosted on a Microsoft server! It starts with a fake message from the ‘Excel Team’ saying you can’t ‘Open Excel or any […]
Excel is getting a clever new way to quickly analyse your worksheets and pull out useful ideas or insights to quickly make PivotTables, PivotCharts and Charts. It’s now available in Excel 365 for Windows and Mac, Insiders and will eventually make it to public releases. It’s now called ‘Ideas’, previously known as ‘Insights’ (a more […]
There are two different year-round Microsoft Office 365 discount offers available to US and Canadian military in all branches. Office-Watch.com talked about these Military Appreciation offers before, going back more than a decade. There are TWO different military related discounts – the Military Appreciation Edition and the Home Use Program. Military Appreciation Edition The MAE […]
OneDrive Personal Vault is limited to 3 files for anyone with a free OneDrive account with a 100GB quota. It’s very easy to bypass that limitation and store as many files as you like. See OneDrive Personal Vault, deep inside and tricks There are several ways to store multiple files inside a single files. Use one […]
