How would you like to MASTER graphic design by next week?
Click here to find out how
Featured Photoshop templates - professional ready to use designs for your next project
View all templates
3 Special Excel Functions to Amaze You - Excel tutorial
Want to up your Microsoft Excel game? This article will show you how to master three functions that will bring your skillset to the next and make you an Excel Wizard!
More cool Excel tutorials:
This technique enables excel to copy text/data into multiple cells. You can't work in Excel without knowing this basic procedure.
Fill All Blank Cells in a List
Many of Excel's functions are designed to be used on lists. For most of these functions to work correctly, lists should not contain any blank cells, and column headings should be formatted differently from the data in the list.
Copy Forumulas: Fill Down
Often we have several cells that need the same formula (in relationship) to the location it is to be typed into. There is a short cut that is called Fill Down.
Excel’s concatenate function is used to combine character strings from multiple cells. This function can be extremely useful if you need to perform a manual task on a large list of data. The example is this tutorial will demonstrate how to combine an area code in column "A" with a phone number in column "B." We will also be including the dash mark
In this tutorial, you'll learn more about what, exactly, a structured table is, how to create one, and how to make use of all its features.