In Windows 8.1 for Microsoft Office users we have an entire chapter on the OneDrive features – the good and the bad. We include the policy and registry settings necessary to disable OneDrive entirely in Windows 8.1. But is it a good idea to entirely remove OneDrive features? Microsoft does
Eventually we all need to find a deleted document or a past version of an existing document. You never know when it’ll be needed or for which document. There’s many options available for keeping older versions of a document or file, most of them you have to setup in advance.
A few months ago we told you about Office Mix, a way to put PowerPoint presentations online. Microsoft has given us several attempts at sharing presentations online. Office Mix is probably the best integration of PowerPoint slides and some features only possible online. For a plain showing of PowerPoint slides
One of the September 2014 updates has us scratching our heads because it doesn’t make a lot of sense. The download is a fix for a problem caused by a previous bug patch, but what else? Under the bland title “September 9, 2014 update for Excel 2010” you’ll discover that
Choosing the sort type is really important and Word doesn’t always guess correctly. Office-Watch.com reader Peter M. reminds us that choose the sort type is really important: Text, Number or Date. “I just thought it worth pointing out that, for example 8, 70, 600 would sort in one order as
The last man on the moon is missing from Microsoft Office. Let the conspiracy theories begin! The last man to walk on the moon, Captain Eugene Cernan, is a notable omission from the Microsoft Office dictionary. Update: as of November 2015 we’re delighted to see that Gene Cernan is now
Microsoft adds the Ruble symbol to Windows 8.1 and we show you how to add it to earlier versions of Windows. Part of the Windows 8.1 August 2014 update is the addition of the new Russian Ruble currency symbol. All Microsoft will say about this change is “This feature adds
Why Excel PivotTables get messed up and how to stop it. Time and again we’ve heard from people who try PivotTables and only get nonsense tables. That’s understandable since Microsoft’s hype about PivotTable ignores the basics that we’ll cover in this article. You’ve probably seen a Microsoft demonstration of PivotTables
How to add and remove data from a PivotTable. Thanks for the great feedback from our article on PivotTables. One concern some of you have is about adding or removing source data after the PivotTable has been created. That’s understandable because the original PivotTable releases where unclear and curiously sensitive
Microsoft needs to play ‘catch up’ with email encryption. Yahoo is going to join Google is supporting not just email encryption but the same type of email encryption. Sadly we’ll have to wait until sometime in 2015 for Yahoo to release their version of OpenPGP. That’s good news … but
Some programs let you email documents directly – here’s now. Microsoft Office for iPad has an ‘Email as attachment’ as one of its limited options for sharing a document. Here’s some clever ways to make use of that and workaround the Office for iPad limitations. Some cloud services offer an
Microsoft celebrates 25 years of the software suite. Microsoft quietly celebrated the 25th anniversary of their Office suite on 1 August 2014 but were they being a little ‘previous’ in their celebrations? While Word, Excel and PowerPoint for Windows were around on 1 August 1989, were they sold as ‘Microsoft
The Insert | Symbol feature in Office is overdue for an overhaul. Our venture into the new Unicode symbols and symbol fonts highlighted how much work Microsoft needs to do on this part of Office. Insert | Symbol has changed for a long time and many versions of Office. Here’s
A simple, practical and non-scary example of how Excel PivotTables can work for you. Excel’s PivotTables are a great feature but one that seems way too hard for most of us … so here’s a simple and practical example of how PivotTables can help. A little fear of PivotTables is
The two procedures will let you easily clear up redundant Word documents, and alphabetize lists of declarations. Access versions: 2007-2013 Level: Intermediate Introduction The two procedures described in this article will let you easily clear up redundant Word documents, and alphabetize lists of declarations. When working on the 3rd edition
Word: how to find the character code used for a particular letter or symbols. Last week we talked about the Unicode v7.0 symbols and how to use symbols in Word. With over 100,000 characters in the Unicode specification, it’s important to know the character code number for the symbol you
A funny example of how you can’t trust the spelling and grammar checks in Word. We laughed at this sign, seen in a Tesco’s supermarket in the UK. Guess what – according to Word 2013 that entire document has no grammar mistakes at all! Even ‘incontinence’ doesn’t get a contextual
What is Delve and what does it mean for Microsoft Office? At the recent Microsoft conference there was mention of Microsoft Delve. But what the ?^%$ is ‘Delve’? It’s an enhanced search tool for your documents and online info. Not just standard Office documents but also videos, audio, links to
How can you get the new Unicode symbols in Office documents? There’s plenty of new symbols included in the Unicode 7.0 standard, here’s how to get them into your Office documents. Most fonts do NOT have all the Unicode characters, after all, there are over 133,000 of them. There are
Unicode adds more characters to an already large list. Unicode has added another 2,834 new characters in the Unicode 7.0 specification, mostly support for 23 new scripts. That takes the total to a whopping 113,021 characters! But we’ll have to wait for these new characters to appear automatically in Office,
Back in Access 2003, you could easily change the font name and size for a datasheet form by clicking the square in the upper-left corner of the datasheet (in datasheet view), and selecting the font and size from the selectors on the Formatting toolbar, or by selecting Font from the
If you need to create a filter string for filtering by a person’s name, or a city name, you may run into this error: This is because single quotes are used as the delimiter for Text strings, and there is a single quote in the city name. To get around
Microsoft makes a ‘one stop’ page for the latest Office update details. Figuring out what are the latest updates for Microsoft Office isn’t easy which is why we’re delighted to see Update center for Office, Office servers, and related products from Microsoft. It’s been a long time coming but as Sam
Plenty of free ebooks about Office 2013, Office 2010, Office 365 and more. Microsoft has released another 130 free ebooks for anyone to download. It includes titles about Windows 8, Office 2013, Office 2010 and Office 365. A list of the Office related titles with links is below. Free ebooks
