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 is on it's own row, you can delete every other row easily with the … [Read more...]
VLOOKUP Price Ranges in a Table
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 total student manual cost by multiplying by the number of students, … [Read more...]
10 Excel Tips For Increased Productivity
Microsoft Excel has tons of uses available to its users. But not everyone knows all the features that Excel has to offer. Some Excel tips will help you instantly become more productive, or use Excel more efficiently. Click through to see our top 10 Excel tips. … [Read more...]
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 an American keyboard needing to type the British Pound (£), or Euro (€) … [Read more...]
7 Excel Formatting Tricks
Microsoft Excel, like any other Office product offers it's users simple and intuitive ways to format your data. Many of these formatting options are great for using once or twice, but what if you find yourself needing the same format dozens of times, or need a format that doesn't exist? The following Excel formatting tricks will help you work more efficiently. … [Read more...]