Learning the ropes of Microsoft Excel is equally as important as learning the basics of Word and Outlook. These essential tips will give you a jumpstart on tapping the data crunching potential of Excel.
Tag Archives | excel
If you use Microsoft Office 2016 products such as Word, Excel, and PowerPoint to prepare sensitive information; did you know Office has a built-in encryption feature? Let’s review the details and how to protect your documents.
There are times when you need to print out data from Excel. But often times you don’t need to print out the entire report which wastes paper, ink, and time.
When working through Excel in Microsoft Office during the day you might find it necessary to copy existing worksheets in to another workbook. Here’s how.
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.
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 […]