 
|
Remember the old days, when only the kids belonged to Facebook, and they used it to plan parties, and post embarrassing photos? Well, now almost everybody has signed up, and the kids have probably moved somewhere else, and they're hoping that we don't discover where. I have a personal account, and also created a page [...] Moved to the Excel Twitters archive: Excel Twitters 20090625 Here's a favourite message from my mailbox this week: Subject: help me in excel Dear sir, I have a problem in excel i requesting to you solve this. I am sending the data of excel sheet pls look in to thatIf you have want any information on that please get back to meI am waiting [...] "Help!" said the familiar voice, when I picked up the phone at 10 PM. "I have a list of orders in an Excel sheet. I want to compare it with the list from last week, and delete all the orders that were in the old list." It was my daughter, still at the office, trying [...] Moved to the Excel Twitters archive: Excel Twitters 20090619 Have you ever had trouble trying to count items based on two criteria? Don't worry – it's Underdog to the rescue! Note: There's a short sound clip in the video, so turn down your speakers if your co-workers are napping. Underdog Comes to the Rescue in Excel Use SUMPRODUCT to CountAs Underdog mentioned, [...] Yes, the weekend is over, but another one is just five days away! To make it easier to keep track of weekends in Excel, you can use conditional formatting to highlight the rows where the date is a Saturday or Sunday. For example, our Excel file has a list of product sales for the first [...] Moved to the Excel Twitters archive: Excel Twitters 20090612 Well, I should have been working all day, but decided to take a bit of time to relax and catch up on some reading (of RSS feeds). At the Lost in Technology blog, was a link to XtraNormal, where you can write, cast and direct an animated movie. That sounded like more fun than working, [...] In a pivot table, you might want to see all the orders that were shipped on a specific date. To do that, you'd move the Ship Date field to the Page area, and select a date from the drop down list.
Sometimes though, you'd like to show the orders shipped in a date [...]  |
|
|
Copyright © 2012 Contextures Blog - All Rights Reserved |
||
