<

Here are five little-known Excel tips you can use every day to make the time you spend in Excel more efficient and productive.

But you may need them combined, so you can have the full name in one cell. This is easy with the "&" symbol. Make a formula showing each part you want in ...

CONCATENATE really comes in handy when you have text from a bunch of different columns that you want to piece together into one long string.

Now most importantly and our concern is with excel formulas and functions . Alternatively referred to as a formula box, it shows the contents of the current ...

Instead of manually looking in the income table for June and copying it over, you can use the VLOOKUP function to do it. excel hack 12

Now we have a problem. We can't do the little down arrow trick here. Why? Well, suppose we position the cursor in cell A1 and try the previous script; ...

Just grab the lower right corner of the PMT cell you just created, and drag it down so it calculates the payment total for all of the loan terms listed in ...

As you can see, when you can compare loan terms side-by-side, some stark realities show forth. For example, for a car loan of $19,500, if you take the time ...

This How-To Geek School class is intended for people who use Excel, or try to use Excel, but are intimidated by the concept of formulas and functions.

Spreadsheets are one of the most mystifying pieces of software you'll encounter in your adult life. As scary as they can be, though, you can do an awful lot ...

If you want to see how many times a person's name shows up in the list, you can combine the COUNT formula with an IF formula. So, first create a column to ...

One caveat: Use the box idea sparingly. If you create more than one box on the page, readers might get confused about which one to read first and maybe even ...

Select the style of formatting you want to apply, and Live Preview will show how the formatting will look on your data. Nice.

When you open a blank Excel spreadsheet, it is known as a “workbook” The top of the portion is called “ribbon”; it's again divided into the “tabs” ...

Get your start by mastering these six basic Excel tricks, and you'll be on the path to becoming a total Excel whiz in no time!

There you have it! Without having to manually sift through all of those transactions, you now know exactly those times when you've overspent in a certain ...

The type of Excel chart you select for your analysis and reporting depends upon the type of data you want to analyse and report and what you want to do with ...

If you are working with a large PDF and/or dataset, those steps may take a little while, but overall the process should be swift. Once complete, click the “ ...

Right now as you lay on your couch reading my amazing fact filled answer you have at least 2,000 calories of stored glucose in your ...

In the desktop version of Excel, Autofill is activated by clicking on the bottom-right corner of a selected cell and dragging downward/sideways.

Here's a simple SPLIT formula we could use in cell B2 to divide these into first name and last name:

If you already have a spreadsheet set up, you're ready to go! If not, import your data into Excel and continue on to the next step.

By the way, on that “Borders and Shading” menu, check out all of the other cool things you can do, ...

If you do not like these formatting options, Excel has many different new Conditional Formatting options that you can use from. For example, you can insert ...

Your readers will know a comment exists at that point in your worksheet because a small red triangle appears in the upper-right corner of the cell.

Few apps have made a more valiant effort to rescue us from indolence than Things, the to-do list app for Mac and iOS from German software developer Cultured ...

To accomplish these same things in a standard Excel sheet would require all sorts of functions and re-formatting data. PivotTables automatically do the ...

So now Excel will create the chart based on the data and dump it somewhere on your sheet. That's it! You have created your first graph/chart in Excel and it ...