It IS possible for Outlook 2013 (and earlier Outlook 2010 and Outlook 2007) to connect with Google Gmail accounts, despite what you may have heard. We’ll explain what’s happened, why and how login is still available for older Microsoft Outlook’s. There’s a lot of misinformation about changes in Gmail’s login
When Microsoft Word was first released, all those years ago, it had a Paste feature but it was dumb and literal. These days Word’s Paste (Word for Windows and Word for Mac) is a lot smarter and does very useful things that you may not realize or appreciate. Before the
Type the three different types of Ellipsis … marks in Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Ellipsis … symbol is used for a gap or break in some text, usually to drop out some irrelevant text or speech. The same applies
Like it or loath it but the comma ellipsis has arrived ,,, as an alternative to the more common ellipsis with dots. Here’s how to use it in Word and Office. The comma ellipsis is a modern, more casual version. It’s used as a more dramatic, even annoyed trailing off
How can you change the Author name in an Office document? How can you know that the name in a Microsoft Word document is the actual person not an imposter? It’s easy enough to go to File | Info to see and change the document Author name. We did that
Combine or divide adjacent Microsoft Word or PowerPoint table cells into a merged single cell or split a cell in two. Welcome to ‘Merge Cells’ where you can combine adjacent cells into a single cell. It’s very handy for table formatting tricks and other unusual situations like a longer than
The simple and easiest way to convert text dates to Excel dates is using Text to Columns on the Data tab. It’s a simple ‘one off’ method that works well and takes you through the steps. If you need something more automated, for new text dates entered from time-to-time use
Type the Yen ¥ currency symbol into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Yen is used for Japanese currency and the Chinese Renminbi / Yuan. Microsoft Excel also offers the Yen symbol for Mongolia even though the tögrög currency uses another
More ideas and a wish list for ending a PowerPoint presentation with a different slide. After our article on the ending slide options for PowerPoint, Vivian from the UK writes: “… it’s really very easy to do what I always do at the end of PPT presentations. Just add a
The blank black slide which appears usually at the end of a slideshow is a default setting in PowerPoint. But it can be changed. The blank black slide which appears usually at the end of a slideshow is a default setting in PowerPoint. But it can be changed. Open PowerPoint
Recreate the Murphy Brown TV show’s look as a design inspiration for Word and PowerPoint – the fonts, colors and lines. You may not want to use the exact look of the Murphy Brown title card, but it’s a starting point for design variations of your own. We’ll show how
How to change the PowerPoint slide numbering to a different start number. In PowerPoint, slides are numbered by default from 1 but that’s not always what you need. For example, you’re working on some slides which are just part of a set of slides eg. working on slides from number
In PowerPoint you can record narration and comments during or after a slideshow. This makes the presentation more interesting and interactive. This feature is especially useful when you convert presentation to video. With narration the video would seem complete and the process of doing this is quite simple and easy.
Excel Array formulas are useful for getting the result from a filtered list quickly with a single, simple formula. Continuing our series on Excel array formulas. Here’s a list of stocks with industries aka Table3. How many stocks are in the ‘Shop’ industry? The array formula in G5 has the
Array formulas are an important part of Excel and they are a lot more important now that dynamic array formulas are around. Don’t ignore arrays because they’re an unavoidable part of Excel for everyone. This is the start of a series to help you understand arrays in Excel. At the
Word can generate a list of all the tables in a document. Like a Table of Contents, this list of tables or Table of tables can include page references or links to each table. A Table of tables can be useful for creating a proper appendix or reference within more
Outlook can handle more than one calendar and has three options for easily viewing them, either individually or combined. Calendars can be displayed side-by-side or the more useful Overlay option. There’s also the ‘New Window’ option. Choosing the Outlook calendars to view In Outlook calendar view, use the check boxes
Outlook can link to external, shared, calendars and copy any updates to that calendar using either a .ics tile or a webcal link. An Internet calendar can be for public events, holidays, sporting fixtures etc. They can be a one-time copy of event details or you can setup Outlook
Type the Pilcrow Sign ¶ into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Pilcrow Sign ¶ is a typographical symbol sometimes called a paraph, or blind P In typography ¶ marks the start of a paragraph but in Microsoft Word the Pilcrow Sign ¶ marks
Here’s a better Excel formula for converting a number of days into text for year, months and days. This formula leaves out zero values and proper singular/plural (e.g. not “1 Year 0 Months 27 Days” but “1 Year 27 Days”). And we’ll show an even better way to write the
Anyone can view a Microsoft Visio file, once you know at least one of two tricks available. One is free software, the other is a workaround via OneDrive. “I’ve been sent a .vsdx file to view and I’ve figured out it’s a Visio file – but how can I view
A Word document and a floppy disk caught a serial killer back in 2010. There are still lessons for anyone wanting to keep their personal or business data confidential. Known as the ‘BTK killer’, he murdered 10 people in Kansas between 1974 and 1991. The murderer was finally caught in
Occasionally you’ll get someone who sends lots of messages you don’t want to see. Outlook has a few options for refusing or politely ignoring messages from certain email senders – either individually or automatically. Most commonly these are enthusiastic zealots on some subject and are trying to ‘spread the word’
If you look in folders that contain Office documents (Word, Excel, PowerPoint) you might see the occasional .tmp file. What are they? Could they be useful? How to look inside. Can they be safely deleted? The quick answers are: probably Word or Office document remnants, could be handy to recover
