Excel Weekly News from Contextures Feb 04, 2014

Fix imported dates + more Excel tips

In this week's Excel news, you'll see how to track projects online, fix imported dates, and other tips. Thank you for reading the Excel news!

 -  Debra ddalgleish@contextures.com

Project Tracking with Excel Web App

Excel files that are set as Shared can cause problems, so I stay away from using those. However, I'm now using the online Excel Web App to share a simple project tracking file with a client, and it's going well.

The Web App is a stripped down version of the desktop Excel, so you won't find all your favourite features. It's worth trying though, if you have a simple file that you want to share with other people..

Click here to see the details: Project Tracking with Excel Web App

Sort Pivot Table Left to Right

Usually you sort the values in a pivot table column, either largest to smallest or smallest to largest. You can also sort the values across a pivot table row, left to right. It's easy to sort the Grand Total row, and an item row can also be sorted, in a few more steps.

Click here to see the details: Sort Pivot Table Left to Right

Excel Dates Won't Change Format

If you import data to Excel, you might have problems when you try to change the date format, or sort by date. This problem occurs when Excel sees them as "text" dates instead of "real" dates. There are a couple of quick fixes that you can use, to solve the problem..

Click here to see the details: Excel Dates Won't Change Format

More Excel Tips

Here are a few of the Excel articles that I read last week, that you might find useful:

Video: Quick Search in AutoFilter Excel 2010

Instead of scrolling down the list of items in the filter drop down, you can use the Search box in the Excel 2010 AutoFilter drop down, to quickly filter items in a long list.

Covered With Ice

Things got pretty messy in the southeastern USA last week, where I was visiting. We're used to seeing lots of ice and snow during the Canadian winter, but these ice-covered trees were surprising to see in the south.


Contextures Products

Save time with our "Done For You" Excel products.


Note: I am an affiliate for some of the products mentioned in this newsletter, and earn a commission on the sales.




Privacy Policy


Contextures Inc., Copyright 2019
All rights reserved.