Looking for 2022 FIFA World Cup, Qatar calendar info? … click here The upcoming Football World Cup (soccer) is a little more complicated than usual. There are 64 matches playing across three time zones in Russia which makes it hard to figure out what time the live broadcast will be
Continuing our tutorial on making a parallax slide transition in PowerPoint. In Parallax Effect in PowerPoint, part one we setup the extended slide with the image and text boxes needed. We showed how to add text boxes outside the visible slide area, the vital selection pane, renaming objects so they
Excel has three PercentRank() functions to give you the percent ranking of a value in a list of numbers. It’s different from the Excel rankings we’ve discussed before, because this is a percentage or percentile ranking Let’s start with a simple example. There’s a list of values from 1 to
Microsoft is now previewing the next version of Office for perpetual licence/one-time payment customers. The changes in how Office is sold and updated mean this isn’t the big news it once was. We have info on what’s in Office 2019, release date and reduced support. Most people now buy Office
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
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
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
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.
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
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
Outlook has a really annoying and inconsistent physical address glitch that Microsoft has ignored for years while it’s rival at Google got it right from the start. The problem comes when you paste an address into the Location field of an appointment. Very often, addresses are formatted across two or
Timeline was a new feature in Windows 10. It was a way to see which documents and files you’ve opened across all your devices. What you won’t hear is that Office already has a similar feature. The Office team has already synchronized the Open / Recent Documents lists across Word,
Here’s some better VBA code for converting a private document (contract etc) into one with anonymous words. A useful trick if you’re trying to fix a Word formatting problem but can’t share the document. Legal numbering problems is a common issue that this macro can help with. Office-Watch.com has already
Last week we got a peek at the current White House notepaper and could not resist trying to make our own in Microsoft Word. White House notepaper in the President’s hands – 21 Feb 2018 It’s a simple, classic look that anyone can use and adapt to their needs. We’re
Here’s a manual method of replacing text with filler or anonymous words in Microsoft Word Use this when you need help with a Word document formatting problem but can’t share the troublesome .docx because it contains confidential information. Our head honcho, Peter Deegan, had this problem himself. A friend asked
Microsoft has an unstated policy of degrading perpetual licence Office in favor of the annual payments for Office 365. This is happening in lots of little steps. Nothing major to alienate customers but enough incremental changes to shift the balance in favor of annual Office 365 payments. It’s a form
Here’s how to stop Office Watch, or other newsletters, from being moved from the Gmail Inbox to the ‘Spam’ folder or their ‘Promotions’ tab. At the moment neither Office Watch nor our friends at Popbitch are considered ‘spam’ by Gmail, but that can change. Any changes you make to Gmail’s
Many of the Office 2019 assumptions and rumors don’t account for the changed business model at Microsoft. Redmond’s dirty little secret is they’d prefer not selling Office 2019 at all. Office 2019 is the ‘perpetual licence’, single payment, fixed feature version of Microsoft Office. Microsoft will release it later this
Here’s how to stop Outlook.com/Hotmail from wrongly marking email as spam. These are messages that end up in the Junk Email folder. We’ve already explained how to move messages from the Junk Email folder to your Inbox. But that doesn’t stop future messages from the same sender going to the
Here’s how to share Microsoft Office documents (Word, Excel or PowerPoint) for viewing or editing via Dropbox. Document collaboration works a little differently in Dropbox compared to OneDrive. There are different methods and limitation for sharing on Dropbox. We’ve already shown how to install Dropbox, enabled the Microsoft Office Online
Dropbox Badge is their document collaboration option that provides Dropbox specific features inside Microsoft Office programs, It works with a refreshingly wide range of Office version. Microsoft Word, Excel and PowerPoint for Windows and Macintosh. Office 2007 to 2016 for Windows. Office 2011 and 2016 for Mac. It only works
