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 email@example.com
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
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
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
Here are a few of the Excel articles that I read last week, that you might find useful:
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.
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.
In addition to all the free
Excel tips and tutorials, there are other Excel tools that you can
invest in. To learn more about the products listed below, click
on the links to take a look at their features, and decide if they're
right for you.
Note: I am an affiliate for some of the products mentioned in this newsletter, and earn a commission on the sales.
Contextures Inc., Copyright ©2017
All rights reserved.