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 tryRead 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. OneRead 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 OfficeRead 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 featureRead More
What is Microsoft Delve?
What is Delve and what does it mean for Microsoft Office? At the recent Microsoft conference there was mention ofRead 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 theRead 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 toRead 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 inRead 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 mysteryRead 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 theRead 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 forRead 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 forRead 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 grabRead More
Picture problems in Office
How to find your pictures to insert into an Office document. Even a simple thing like adding a picture toRead More
Translation function in Excel
Can you call a Translation service to return results in Excel? After checking out the clever European word translator, weRead 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 oneRead 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 youRead 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 caffeineRead 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 ofRead 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 siteRead More
Office Watch
Office for Mere Mortals
Twitter
Facebook
Instagram