Adding and subtracting time in Excel is something that people often times have a difficult time figuring out how to do correctly. Often times you are doing it right, but the results don't seem to be displaying correctly. Other times you may give up doing it the "correct" way and set up an hours column and a minutes column. Then add the minutes, divide by 60, and add it to the … [Read more...]
Count Cells Meeting Certain Criteria
Whenever you are dealing with lists it seems like you always are looking to count how many of a certain item is in the list. Maybe you want to count how many cars were sold by a certain salesperson, or how many times an employee called out sick. Luckily Excel makes it easy to count cells meeting certain criteria just like this. Count cells meeting certain criteria with Excel's … [Read more...]
Type Same Data In Multiple Cells
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...]