Have you ever had the need to type the same data in multiple cells in your Excel spreadsheet? If so, you know it can be quite the time consuming process if you have to manually type the data in a lot of cells. Even copying and pasting can be time consuming. Luckily there is an easy way to type same data in multiple cells. How to type same data in multiple cells Select all … [Read more...]
Use Silk to convert your Excel Files into an interactive online database with visualizations
Do you have an Excel file with information that you would like to publish on the Internet or share with co-workers? Maybe addresses you want to put into a map? A directory of partners and contacts? Or just a gallery of your favorite restaurants? For free? Then you might like Silk. Silk is a data publishing platform that lets you convert a spreadsheet into a live interactive … [Read more...]
How to Format Numbers as File Sizes
Have you ever had a list of files with accompanying file sizes that you wanted to use in some sort of calculation such as adding up the file sizes, averaging them, using them in some sort of chart or other calculation? The way we usually read file sizes is with the appropriate size abbreviation such as B (bytes), KB (kilobytes), MB (megabytes), etc. However, this makes it … [Read more...]
Microsoft Excel for iPhone
In today's increasingly mobile world, it seems like the productivity we have grown to associate with our desktop environments should start to migrate over to our mobile world. The Microsoft Excel app for the iPhone, iPad, and iPod touch appears to bridge this gap. Microsoft Excel for iPhone The Microsoft Excel app allows users to view, create and edit spreadsheets in this … [Read more...]
Excel Search Tips
Most programs have a common search shortcut, CTRL+F. This shortcut pops open a search window for you to use in searching through the entire document. Often times, depending on the program, there are specific options. Excel search is no different. Excel Search Tip #1: Find All If you are working with a large set of data, and you need to find all cells containing a particular … [Read more...]