Why PivotTables get confused and how to fix them
Why Excel PivotTables get messed up and how to stop it. Time and again we’ve heard from people who try Read More
Microsoft Excel
PivotTables: selecting and changing data sources
How to add and remove data from a PivotTable. Thanks for the great feedback from our article on PivotTables. One Read More
Some Excel worksheets should not be shared
A bad example of Excel and document sharing online. Over on Reddit there’s a sad example of sharing an Office Read More
Simple and useful PivotTables
A simple, practical and non-scary example of how Excel PivotTables can work for you. Excel’s PivotTables are a great feature Read More
What is Microsoft Delve?
What is Delve and what does it mean for Microsoft Office? At the recent Microsoft conference there was mention of Read More
Clearer table formatting than Microsoft auto-format
Some great tips on table formatting. Joey Cherdarchuk has a nice posting on a very different table styling to the Read More
A faster way to copy pictures into Office documents
Another easy way to get images into Word and other Office documents. Last week we mentioned a faster way to Read More
Scanning from within Microsoft Word
Can you scan a picture or document directly into Word? Back in the day, you could click a button in Read More
Excel Online - changing date format
How to change the date format in Excel Online The default date format in Excel has always been a mystery Read More
Excel for iPad - a tour
The features in Excel for iPad. Here’s a look at the major features in Excel for iPad, looking over the Read More
Excel for iPad - Formula Keyboard
A close look at the new Formula Keyboard in Excel for iPad. One of the highlighted innovations in Excel for Read More
Office ScreenTips in other languages
A free way to show Microsoft Office help in other languages Office Screentips is a way to show tooltips for Read More
Capture full size images from video
Grab high-res pictures from movies to insert into Office documents or emails. We’ll show you how to capture or grab Read More
Picture problems in Office
How to find your pictures to insert into an Office document. Even a simple thing like adding a picture to Read More
Translation function in Excel
Can you call a Translation service to return results in Excel? After checking out the clever European word translator, we Read More
The Clinton’s special Excel worksheet
How the Clinton ‘Saints and Sinners’ spreadsheet might look. Excel has many uses and an upcoming book talks about one Read More
Removing words from the Word dictionary
Why and How to remove words from the main Microsoft Office dictionary. Sometimes the supplied Office dictionary has words you Read More
Caffeine levels in Excel
Comparing caffeine levels in drinks from an Excel spreadsheet. The Guardian’s Datablog has another interesting analysis, this time of caffeine Read More
Putting Health Data into Excel
Examine US public health data in Excel. One of the great things about the recent Internet is the availability of Read More
Import Best Buy prices into Excel
An example of web scraping from BestBuy.com into Excel. We’ve already talked about getting prices from the Amazon.com web site Read More