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
Convert Rows to Columns with Transpose in Excel 2013
Excel 2013 offers many of the same features as the 2010 edition, among them is the ability to transpose tables from rows to columns.
Setup Excel 2013 Drop-Down Lists with Data Validation
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.
Disable Protected View for Outlook Attachments
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.
How to Create Pivot Tables in Microsoft Excel
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 [...]
Microsoft Office: Install Only the Programs You Need
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 Analytics for Twitter Pulls Tweet Data Directly into Excel Spreadsheets
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 [...]