There’s a quirk with Microsoft Excel 2010 (and possibly other versions) where custom number formats don’t get applied to existing data. This quick fix can save you from the tedium of re-entering thousands of rows of data.
Tag Archives | excel
Excel 2013 offers many of the same features as the 2010 edition, among them is the ability to transpose tables from rows to columns.
Here’s how to set up Excel 2013 drop-down lists with data validation. Data Validation is an effective tool when sharing spreadsheets with unified content.
Tired of Microsoft Office getting having a fit every time you open a downloaded Outlook email attachment? Here’s how to disable protected view for Outlook email attachments in this groovy tip.
One of the most useful features of Microsoft Excel is Pivot Tables. But many people don’t know how to use it properly. Pivot Tables are used to summarize, analyze and present your data in a user friendly way. For example, if you have a database of student marks for a semester and want to display [...]
Whether you’re a fan or not, MS Office is the most dominant set of office tools available. However, do you need to install Access when all you need is Word? Sounds like a waste of space doesn’t it. Here’s how to selectively install only the Office programs you need. Here I’m using Office 2007 Professional, [...]
Microsoft Excel is a groovy tool for creating statistical charts, so why not use it to track Tweets? “Analytics for Twitter” is a Microsoft created spreadsheet that fully automates the process of tracking search queries, tweets, retweets, and top-posters across the Twitter network. It has multiple features, and it does what the name advertises. The [...]