Awaz Apni

Excel is often used as a database to hold information and not necessarily calculate numbers. One example is a mailing list. On campus, you only need to include the four-digit extension for the postal code. My mailing address would look like this: Ranelle Maltas 104 ARCH CC 0104 Here it is in Excel: But how did I get the leading zero to stay? Usually when you type a number, such as 0104, it is formatted as a number, becomes right-aligned and drops the zero. You can format the cell as text instead, but that doesn't always help. What you need to do is type an apostrophe (') first. Don't worry, it will disappear like the image above. Here it is again in edit mode: Share Buzz it

Thanks to @MrExcel for sharing! View recording of Whats New In Excel 2010 webinar at http://www.safaribooksonline.com/Corporate/DownloadAndResources/webcasts.php .

I get asked this question a lot. There are several chart types I use just because my particular data fits the type, but I have to admit that I don't use them all. If you need help to determine which chart is best for your data, Chandoo  ( @r1c1 ), Pointy Haired Dilbert blog, has the answer for your chart selection process .

Tired of using Excel for just number crunching? Here's an idea for you. All I have to say is, "wow."

Let me just get this off my chest. "I don't do math in my head." I really hate math, but Excel is a dream as it makes math so easy. I used to have to really think how old my family members are. It is a really bizarre thought process for me, so I won't bore you with that. Instead, I'll show you how I made an Excel spreadsheet that will tell me. I have since used it to calulate days, months or years between two dates (such as time between start and end dates of a project). Here is the formula's syntax. (BTW, don't go looking this up in the Help section as it is a "secret" formula.) =DATEDIF(Earliest_Date, Latest_Date, UnitOfMeasure) Here's how it works... 1st argument: A2 is the cell reference for the early date. 2nd argument: For the late date, I used the TODAY() formula so it is dynamic for whenever I open the spreadsheet to have the current date. 3rd argument: The unit of measure can be either "Y" for years, "M" for mont...

This week Microsoft released a new concept test prototype for Office called Ribbon Hero . It's a new approach to Office training that’s designed to deliver a fun, engaging experience to help people explore the features available in Office…whether it’s to help you learn how to do things faster, or uncover features you never knew existed. Unlike traditional training, Ribbon Hero presents a game-like environment for learning and lets people compare their scores and feature usage on Facebook. It currently works with Excel, PowerPoint and Word. Download it here .