Amazing Excel Tutorials

Watch the latest videos on

YouTube.com

How to merge cells in microsoft excel?

This document explains how to merge cells in Excel.

Merging cells is often used when a title is to be centered over a particular section of a spreadsheet. When a group of cells is merged, only the text in the upper-leftmost box is preserved.

To merge a group of cells:

1. Highlight or select a range of cells.
2. Right-click on the highlighted cells and select Format Cells....
3. Click the Alignment tab and place a checkmark in the checkbox labeled Merge cells.

To merge a group of cells and center the text, you can also use the Merge and Center button on the Excel tool bar. Again, this will only preserve the text in the upper-leftmost cell.

1. Highlight or select a range of cells.

2. 

3. Click the Merge and Center button on the toolbar.

   
   

How to sort data in excel?

In this simple tutorial I will teach you on various ways to sort data in excel, so as to make your work more easy and time saving.

Sort by One Column

1. Select all the cells in the list.
This is the safest approach to sorting. In most cases, you can select one cell and Excel will correctly detect the rest of the list -- but it's not 100% certain. Some of the data may be missed.
2. Choose Data>Sort
3. From the Sort by dropdown, select the column you want to sort. Note: If the dropdown is showing Column letters instead of headings, change the setting for My list has, from No header row to Header row.
4. Select to sort in Ascending or Descending order
5. Click OK


Sort by Two or Three Columns

1. Select all the cells in the list.
2. Choose Data>Sort
3. From the Sort by dropdown, select the first column you want to sort.
4. Select to sort in Ascending or Descending order
5. From the Then by dropdown, select the second column you want to sort.
6. Select to sort in Ascending or Descending order
7. From the Then by dropdown, select the third column you want to sort.
8. Select to sort in Ascending or Descending order
9. Click OK


Using the Sort Buttons

In Excel, it's easy to sort your data by using the Sort buttons on the toolbar. But, be careful, or one column may be sorted, while others are not.

1. Select one cell in the column you want to sort.
2. Click Sort Ascending (A to Z, smallest to largest) or Sort Descending (Z to A, largest to smallest)
3. Before you do anything else, check the data, to ensure that the rows have sorted correctly. If things look wrong, click the Undo button on the toolbar.

Sort by Four or More Columns

Occasionally, you may need to sort by more than three columns. For example, in a mailing list, you may want to sort by Country, Region, City, and Name. To do this, you can sort the list multiple times, starting with the least important sort.

In the mailing list, there are four columns to sort. Name and City are the least important fields in the sorting process, so they can be sorted first.

1. Select all the cells in the list.
2. Choose Data>Sort
3. From the Sort by dropdown, select City.
4. From the Then by dropdown, select Name.
5. Click OK

Excel will retain what it can of this sort while you sort by the remaining fields.

1. With all the cells still selected, choose Data>Sort
2. From the Sort by dropdown, select Country.
3. From the Then by dropdown, select Region.
4. Click OK

What exactly is microsoft excel 2003?

Microsoft Office is considered to be one of the leading application software in the world of computers. This is a widespread application among businesses. Microsoft Office consists of applications like Word, Excel, PowerPoint, Outlook, etc. Major applications that are used are Microsoft Word and Excel. Let us see the various features available in Excel and how to learn them. Read along!

If you think that Microsoft Excel is only for business purposes, you are wrong. Many use it for various personal needs at home too. Some of the features that you should understand about Microsoft Excel to unlock the potentiality of this application are working with spreadsheets, cell formatting, various menus and toolbars, entering of data and editing the same, navigating between various spreadsheets, formula calculation, inserting various functions like date/time, mathematical functions, using of various charts that are available, inserting, editing and deleting comments on cells, etc.

Read further to understand the various options available to you to master Microsoft Excel. You can learn the tricks of Microsoft Excel through CD, CBT or videos. Let us learn about each option one after the other.

Mastering Microsoft Excel through CD:

With the help of CDs, you can learn Excel at your own pace and need not spend time in attending classes. Microsoft Excel CD would contain screenshots of various commands, how to create professional looking spreadsheets, how to insert charts, diagrams, formulas, create tables, etc. You would also get hands-on training as it would be more interactive. One of the main advantages of learning Microsoft Excel using CD is that you can read at your own convenience.

Unlocking the potential of Microsoft Excel through CBT:

Computer Based Training (CBT) is yet another way where you take your own time to master the application. With the help of CBT, you get realistic, interactive and complete training. You get to learn right from what a beginner should learn to advanced level. Once the training is over, you would have mastered Microsoft Excel. You get to see simulations of Microsoft Excel application software. Some CBT also offer review quiz questions to gauge your understanding. CBT generally offer interactive, complete and comprehensive training. As it offers practice questions, you will be able to understand better and gain confidence in using the application. According to me, this is one of the best ways to learn Microsoft Excel.

Using tutorials to learn Microsoft Excel application:

Microsoft Excel tutorials are another best way to master the application. You get to learn the application in detail as there are various simulations available that are realistic and interactive. Like CDs, videos and CBT, you can learn the application at your convenience.

Why are you waiting? Grab either a CD, video, CBT or a tutorial and start mastering Microsoft Excel and unlock the power this application has got.

In this blog we will help you understand this amazing application, with the help of simple tutorials

All the best!

Great addin for excel: filter assistant

Filter Assistant

Makes filtering data easy. You can filter multiple columns at a time. "Un-filter" capability.

Filter Assistant is an add-in for Microsoft Excel 2007, Excel 2003, Excel 2002 (XP), Excel 2000, and Excel 97.

Filter Assistant in detail

The Filter Assistant for Microsoft Excel makes filtering data easy!

And, it eliminates many of the annoying features of Excel's data filter feature. With the Filter Assistant, all you do to filter data is to select the cells containing the values you want filtered and just click on the button on the Filter Assistant toolbar. Instantly, your data is filtered so that only those matching rows are displayed!

You can filter multiple columns at a time.
Just click on the first cell whose value will be used as a filter. Then, hold the Control key down and click on other cells in other columns. When you then click on the Filter Assistant toolbar button, all the columns are filtered based on the cells you selected!

One of the nice features of the Filter Assistant is that the screen does not "jump" when you filter it.

Another very useful feature is the "Un-filter" capability of the Filter Assistant. If you select a cell in filtered column and click on the Filter Assistant button, the column will be un-filtered. And, if you select a cell in the top row of an un-filtered column and click the button, this turns off data filtering.

What are the Fun uses of microsoft excel 2003?

Microsoft Excel might just be the most versatile application ever created. If you are still using Excel just for number crunching, a MS Excel course can open up a whole new world of possibilities. Let me give you just a few examples of some of the offbeat ways, both at work and at home, I have used Excel over the years.

Numerical solution of differential equations

A Microsoft Excel course can introduce you to macros which can allow you to take calculations to the next level-to the point of writing your own statistical functions. However, Excel macros are written in a language that is interpreted rather than compiled (for you non-programmers out there, read that as "slow rather than fast") so complex numerical models seem impossible.

I used to use a complex numerical code to model contaminant transport in groundwater. The calculations were fast, but it was clumsy to get data in and out of the applications. A MS course had turned me on to macros, and I realized that I could call this fast code from a macro by turning it into a DLL. The Excel interface provided an easy way to create scenarios, to view the data, and to tweak on settings to see how the model changed. The compiled code provided fast results that Excel couldn't match. The combination created a powerful and unique tool.

Wine tasting

I've recently become a bit of an oenophile, and I've started a database of wines I've tasted. I track wines by type, country, vineyard, and year. As the information grows, I examine trends. I've noticed my highest rated wines are generally Australian, something I might not have otherwise noticed.

An Excel course will illustrate techniques in sorting and filtering that allows you to pull important kernels of information out of a mass of data.

Computer game statistics

I am an avid computer gamer and Excel has been a vital tool. I can provide complex demographic data on my population in The Sims 2. I can calculate engine efficiency of the different locomotives in Railroad Tycoon 3. In Oblivion I can track quests, merchant prices, and trainers.

I can also list my alchemical ingredients and have it tell me which potions I can make. I can track the changing economy in Sid Meier's Pirates, color coding prices so I can easily see the best ports to sell my plunder. A course in Excel can teach you about features such as conditional formatting or database functions that make these kinds of workbooks possible.

Learn more fun uses from a Microsoft Excel course

Excel is not just about numbers, as these examples are meant to illustrate. The techniques picked up in a MS Excel course can inspire you to use Excel for tasks you may have never considered. There is more to this software than you think, so get ready to explore its full potential in a Excel course.

How to concatenate data easily in excel?

First of all, what the heck is concatenation anyway? We think of Excel as being only able to perform arithmetic functions on data. Wrong. Excel has many features that allow you to work with text data as well.

In Excel, the Concatenate function allows you to join 2 or more strings together.

The syntax for the Concatenate function is:

Concatenate( text1, text2, ... text_n )

There can be up to 30 strings that are joined together.

Let me tell you the easiest way to CONCATENATE:

Let's take a look at an example:

I have written "alpha" in cell number A1 ane "bet" in cell A2

Based on the Excel spreadsheet description above:

=Concatenate(A1, A2)	would return "Alphabet"
=Concatenate("Tech on the ", "Net")	would return "Tech on the Net"
=Concatenate(A1, "bet soup")	would return "Alphabet soup"

whatever is written in the inverted commas will be shown as it is.

There is another way to use concatenate function: *psst* the hard way:

Lets suppose that cell A1 contains Mary and B1 contains Brown

Another cell, say, C1 contains the concatenation formula: =A1&B1

F132 will display: MaryBrown

The simple definition was to add two or more cells together that contained text. To add to the definition, you can add text cells and/or text strings together.

The next logical question in the MaryBrown case is that you probably want a space to separate the first and last name. In English you are saying add A1 to a specific text character not found in the cells, and then add B1 to that. The specific character just happens to be a space. So here it is:

The new concatenated formula: =A1&" "&B1

The concatenated cell with the space: Mary Brown

Now, let's add the prefix "Ms" in front of Mary's name. Since "Ms" is not in cell, we'll attach the text string in front of the concatenated name.

The completed concatenated formula: ="Ms "&A1&" "&B1

The cell would now display Ms Mary Brown

Note that when concatenating "Ms" that the formula still starts with a equal (=) sign, the text is surrounded by double quotes and the space needed to separate Ms from Mary was included inside the double quotes.

Now, I think the concatenate ghost is running far far away from you =D