It’s easy to get mixed up between two seemingly similar Excel functions – Vlookup() and Choose() . Here’s how to, er, choose between the two. Choose( index_num, value1, [value2], [value3].. ) lets you select one item from a list within the function. For example: Choose(2, “High”, “Middle”, “Low”) will return
In an entirely predictable move, Microsoft is dropping the full OneNote desktop program from their lineup. OneNote 2016 for Windows, the traditional Windows program is being killed. It’ll be a slow death but it’ll still be dead. OneNote 2016 for Windows will be supported with security patches until October 2025
It’s a simple question – How can I delete a blank page in Microsoft Word? The answer isn’t so simple because there are many reasons for Word to add another page and various tricks to getting rid of them. The most common type of extra page is at the end
An infected email supposedly from the UK government appeared in our Outlook Inbox. It’s a good example of what to be careful of in emails and how some Outlook settings protect you from harm. Here’s the message that got through our mail hosts checks and Outlook’s. Many things in this
Jeff Bezos doesn’t like PowerPoint or any other slideshow system at Amazon meetings. That’s what leapt out at us from his 2017 Letter to Amazon shareholders (published in April 2018). “We don’t do PowerPoint (or any other slide-oriented) presentations at Amazon. Instead, we write narratively structured six-page memos.” Those memos
Talk about being behind the times. Google is reportedly about to release an SMS Replacement called Chat. Chat is an attempt to modernize SMS beyond simple text messaging. It will have group texts, videos and images, typing indicators and read receipts. Chat isn’t an app, it’s part of the Android
A KPMG team in Florida, USA are embarrassed and lost an important client all because of a slip of the keyboard and Outlook’s email AutoComplete feature. Miami Today has the story of the proposed new Miami-Dade courthouse and a mistake by the courthouse consultant’s KPMG. A confidential proposal and evaluation
In the UK there’s been a lot of laughs and some red faces about a money raising letter ‘signed’ by the Conservative Prime Minister to a ” Mr Youmustbe F*ckingjoking ” and sent to a pensioner. It’s easy to laugh but anyone who has done large mailings knows that it’s
Will Dormann in exposing the half-measure Outlook patch also shows that more complex passwords with mixed-case letters plus digits and symbols is better than a simple long password. The highest length of time to crack an 8 character password from NTLMv2 hash with a mere single mid-range GPU. Longer passwords are
Microsoft’s half-hearted attitude to security matters is demonstrated yet again with a new patch for Outlook. The patch has taken over a year to be released and doesn’t properly block the security lapse. It all started back in November 2016 when Microsoft was informed of a problem with RTF documents
Will R. an Office-Watch.com reminded us of a trap when dealing with .doc and .docx files. “I opened a command prompt and did a del *.doc. Imagine my surprise when it deleted both .doc and .docx files (I have backups). ” Firstly, a teacher’s gold star plus wise owl stamp to Will
Last Friday, Office 365 customers in Europe and especially the UK had to stop working as the Microsoft hosting servers stopped working. When trying to use email online, users only saw an ‘AADSTS90033’ error, and the message: “Service is temporarily unavailable. Please retry later.” As usual, Microsoft’s communications were mixed.
The April 2018 (aka Spring Creators) update to Windows 10 is coming this week. Windows 10 April 2018 update for Microsoft Office users edition is ready now. Past purchasers of Windows 10 for Microsoft Office users get a free update to the new edition. Be ready for the major changes to Windows before it
Remember that court case where Microsoft sued the US government over a warrant to collect someone’s cloud data? Well, it’s over and the result isn’t good for anyone who likes to keep their documents, databases, photos or emails private. The case was about data saved on Microsoft’s cloud service in
Options to easily import live data about stocks and locations into Excel are coming. Microsoft is uncharacteristically quiet about these new features and not using their usual hype. Microsoft is soft pedaling these features by talking about ‘new data types’ which sounds very dry and complicated. It looks more interesting
Should you even bother bulk converting old documents (.doc .xls .ppt) into the newer Office formats (.docx .xlsx .pptx etc.)? It’s tempting to look at your older documents (doc etc) and think about converting them into the newer Office formats. There’s some advantages to conversion but it’s more difficult than
Apple’s announcement of special ‘education’ prices for iPad and Macbook Air opens an opportunity for almost anyone to get the cheaper prices. Not that we’d suggest lying to Apple. No, never. Telling fibs to a gigantic company is wrong. It’s not as if big companies like Apple have ever lied
If we’ve said it once, we’ve said it a thousand times … ignore or delete any .DOC .XLS .PPT files you get via email or shared. The main carrier of virus infection is Microsoft Office documents, a fact that Microsoft doesn’t like to talk about. What Microsoft doesn’t say is
What should you do when Microsoft asks to see one of your documents? Submit the files or not? There’s no easy answer when Microsoft asks to see a file from your computer for their anti-virus system, Windows Defender. Do you send the files or not? This can happen with Defender
The Microsoft To Do app hasn’t got near customer expectations, let alone Microsoft’s promises. Now there’s some hints about why. To Do was born from Wunderlist, a popular app that was bought by Microsoft. Redmond summarily closed Wunderlist, to the annoyance of the apps many fans. Microsoft promised the app
Microsoft is updating the rules which govern use of their services including Office 365, OneDrive, SharePoint, Cortana and Xbox. Despite what you might have heard, there’s nothing really new or changed, just some clickbait headlines. There are reasons to be concerned about the Microsoft Terms and Conditions, but they are
One thing we can rely on a Office-Watch.com is the regular flow of emails asking about Winmail.dat attachments to emails. What they are and what to do about them. Winmail.dat is part of Microsoft’s own Rich Text Format for emails. RTF has been mostly superseded by the more open HTML
A recent New York Times article about Microsoft Word has good information but the headline is quite wrong. The article is called “How to Format Documents While Barely Lifting a Finger” so we expected a piece about how to reformat a document using themes or styles. Instead it’s about dictation
It’s been a busy few weeks for Richard Appiah Akoto the Ghanaian teacher who taught Microsoft Word with only a blackboard. Mr Akoto was flown to Singapore for a Microsoft Education conference where he received a standing ovation. Quite something for his first trip outside Ghana. “I wanted to teach
