How to Format Numbers as File Sizes

Format Cells with Data Formatting

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 […]

Microsoft Excel for iPhone

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 […]

Excel Search Tips

Excel Search Find All

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 […]

Four Excel Tips to Increase Productivity


Often times we think we know enough about Excel, or any program for that matter, and get set in our ways while preforming a particular task. Sometimes though, we are scratching our heads looking for an easier way to accomplish some of these tasks than what we have always done. Here are four Excel tips […]

Sum Values In A Month

Sum Month

Sometimes we get data in Excel that makes it somewhat difficult to look at the big picture. For example, you might get a list of transactions with a date and sale price. Let’s say you need to sum values in a month to use in some other analysis. With that example, it isn’t easy to […]

How to Use Solver in Excel

Solver Add-In Menu

Solver is an add-in tool that lets you find solutions to various problems. You can use solver in Excel to run through “what-if” scenarios that might help you determine the best course of action. The “best” answer will be different for each problem, and might include maximizing profits, reducing cost, or producing the best use of […]

Delete Every Other Row in Excel

VBA Insert Module

Sometimes you will copy and paste data into a worksheet from another file, a web page, or some other source that isn’t formatted the way you want it. Often times there is extra irrelevant data like row numbers or other miscellaneous information that gets added in when you paste the data. If the unneeded data […]

VLOOKUP Price Ranges in a Table

VLOOKUP Price Ranges

Recently, I was working on a budget for a class that I was putting together. Most of the expenses that would be incurred were fairly straightforward and would increase in proportion to the number of students that were in the class. For example, student manuals cost $11 per student. Easy enough to find out the […]

Return all Characters in a Font

Return all characters in a font

When you use a regular keyboard, you get plenty of options when it comes to the characters you get to type. In most cases the upper and lowercase letters, 0-9, and all of the symbols available to you will provide plenty of flexibility in your typing. On occasion though you might find yourself stuck on […]