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
I ♥ or I Love signs or logos can be made in Word or PowerPoint to liven up a document or presentation. We’ll show how to make something similar to the famous and much copied logo. The official ‘I ♥ NY’ logo complete with registered trademark. The original ‘I Love
Oh what a tangled web Microsoft weaves …. a patch for Office has caused another bug in all versions of Access (365, 2019 back to 2010). The bug is the latest in a series of blunders for Office updates. It’ll take until next month for all customers to get a
Here’s how to block .IQY web queries in Excel that are being used to infect machines with Buran ransomware. Yet again, a mostly forgotten part of Office is being used by hackers to get inside computers and networks. Suspicious Link (great name) found this nasty in an email. It pretends
If you have a slide that you want to keep in your PowerPoint deck but don’t want to show them in a presentation, you can hide those slides. Go to the strip of slide thumbnails down the side of your project and select the slide you want to hide. You
OneNote for Windows has a better future after some reverse-course announcements from Microsoft. OneNote desktop program gets extended life and a promotion. The desktop and app versions merging into a single codebase. We’ll also explain the strange case of two OneNote for Windows. The announcements amount to a 180° reversal
Word is very clever dealing with Hidden text, perhaps a bit too clever at times. Here’s some tricks for positioning and formatting with Hidden text. Students quiz (left) and Teachers version (right) from the same document. The answer text is hidden in the student version but there’s still space for
Make your worksheets look more compact and focused by hiding unwanted columns or rows. Hidden rows/columns still work in calculations, they can be referenced in formulas etc. It’s pretty straightforward. Select the columns or rows, right-click and choose Hide. Keyboard shortcuts Type Control + 9 to hide a row. Control
The Microsoft Whiteboard app can now import pages from Word documents or selected slides from a PowerPoint deck. The new feature is better than it’s promoted because you can select pages/slides not just entire documents or decks. Start from the Insert menu where there are now options for Word document
3D Formulas in Excel allow you to make calculations using data from many different worksheets, including ones that don’t exist yet. This can be incredibly useful, when you have similar figures for different periods across worksheets and want to use data from all of those periods. For our example, we have a file with expenses for a number of
A new Windows 10 bug patch has some fixes for Microsoft Outlook. Microsoft’s documentation is typically brief, so we’ll fill in some details. The time zone changes are too late to help some customers … why? KB4520062 has many Windows 10 fixes but a few affect some Outlook users and
Over time there’s been a change in the way email programs login to your mail host. It’s mostly hidden from us mere humans but important to understand. Here’s how to use oAuth and how to bypass it, if your email program doesn’t support it. Older versions of Outlook don’t know
Excel has a huge range of charts available and endless ways to customize them, but after working to get it just right, you don’t want to have to go through the whole process again next time you want to make a similar chart. Fortunately, you don’t have to because Excel
It’s time again for the monthly drop of security updates for Windows and Office. Here’s what caught our eye; two Excel security bugs and a Windows update which kills VMWare Workstation. Commentators are calling this a ‘light’ month for security patches because there are a mere 59 patches instead of
There are many situations where you need to split up text into separate columns. Names, phone numbers, dates, addresses and lot’s more can be managed with Excel’s Text to Columns, Text to Columns allows you take data from one column, and split it out into multiple columns. This can be
Outlook on the web is now blocking another 38 email attachments because they can be carriers of viruses. But Microsoft doesn’t block the most commonly used files for infecting computers. Far and away the most common infected email attachment is old-style Word documents, with .doc extensions. Excel .xls worksheets and
Here’s a complete, searchable and sortable list of all the email attachments that are or soon will be blocked by various types of Microsoft Outlook. There’s confusion and inconsistencies in the Microsoft documentation and application of these new blocks. They have a list of blocked attachments for Outlook in “Office
As we suspected, there are more holes in the Office Document Inspector. Our clever readers came up with some possibilities for revealing secrets in documents, worksheets and presentations. Document Inspector is good but could be better. As you’ll see, there really should be a warning about objects with multiple layers.
PowerPoint has many choices for printed/PDF handouts to go with a presentation. Here’s a guide to the options spread in different places on the PowerPoint ribbon and menus. Quick PowerPoint Handouts Under File | Print is the basic handouts option to print slides and lines for people to handwrite notes.
There’s no direct ‘watermark’ option for PowerPoint Handouts which is a shame because it would be very useful to add ‘Confidential’, ‘Draft’, ‘Private’ or other very obvious notices. You can fake it with a little PowerPoint trickery. Add a Watermark Picture In short, make an image with the watermark text.
Here’s this months non-security bug fix updates.for Office 2016 and Office 2013. They are only for .msi installs, not ‘Click to Run’ modern installations. For most systems, they’ll be applied automatically. This is the full list with extra notes on a few fixes which caught our eye. Office 2016 updates
Just as there is a Handout Master to control how slide printouts look, there is also a Notes Master which has more control over how PowerPoint printed notes with slides will look. If you’ve used the Handouts Master, Notes Master will be warmly familiar to you. Notes Master is like
While printing PowerPoint handouts for your audience with just the slides can be useful, sometimes you may want to give them your notes as well as the slides, which is where Notes Print comes in. Contrary to its name, Notes Print includes slides as well as your notes underneath them.
Handout Master lets you customize your presentation handouts more than the basics; changing the position and formatting of headers/footers, adding a background color or gradient. Maybe you can help uncover some unexplained mysteries of Handout Master, see below? Our Quick PowerPoint Handouts article showed you how to go to File
