advertisement

05 ms excel

42 %
58 %
advertisement
Information about 05 ms excel

Published on August 31, 2011

Author: fosterstac

Source: slideshare.net

advertisement

Microsoft ® Office Excel ® 2003 Training How to use lists Peace River Distributing presents:

Course contents Overview: Lists in Excel 2003 Lesson 1: Create a list Lesson 2: Sort and filter a list How to use lists Each lesson includes a list of suggested tasks and a set of test questions.

Overview: Lists in Excel 2003

Lesson 1: Create a list

Lesson 2: Sort and filter a list

Overview: Lists in Excel 2003 How to use lists There’s a new List command in Excel 2003 that makes it easy to create orderly rows of data such as addresses, names of clients or products, and quarterly sales amounts. The new List command also makes it easy to total up values and to sort and filter data.

Course goals Create a list using the List command. Add up values in lists using the List toolbar. Use the AutoFilter arrows to sort and filter list data. How to use lists

Create a list using the List command.

Add up values in lists using the List toolbar.

Use the AutoFilter arrows to sort and filter list data.

Lesson 1 Create a list

Create a list Using the new List command to enter list data has several benefits. For example, AutoFilter arrows are applied automatically in a convenient way (more on that in Lesson 2). How to use lists The new List command is on the Data menu. Also, you can use the new Toggle Total Row button to total the last column in the list.

Using the new List command to enter list data has several benefits.

For example, AutoFilter arrows are applied automatically in a convenient way (more on that in Lesson 2).

Use the List command Imagine that you've already entered some data for salespeople into Excel. To have Excel see this data as a list, click any cell within the data, and then: How to use lists Creating a list Point to List on the Data menu. Click Create List . (Continued on next slide.)

Imagine that you've already entered some data for salespeople into Excel.

To have Excel see this data as a list, click any cell within the data, and then:

Point to List on the Data menu.

Click Create List .

Use the List command, cont’d. How to use lists Creating a list The Create List dialog box appears. You confirm that your data has headers (column headings), and that the indicated data is what you want included in the list. Then the data becomes a list.

Now you have a list Now that the data is a list: How to use lists AutoFilter arrows are automatically added in the header row. A dark blue border appears around the list. (Continued on next slide.)

Now that the data is a list:

AutoFilter arrows are automatically added in the header row.

A dark blue border appears around the list.

Now you have a list, cont’d. How to use lists The dark blue border indicates the range of cells in your list. You can have more than one list on a worksheet when you use the List command. The blue border distinguishes one list from another and helps you to tell list data from other worksheet data.

Add a row or a column to the list The row that contains an asterisk at the bottom is the insert row—the row you use to insert additional data. How to use lists List with an insert row (Continued on next slide.) As soon as you enter data to the insert row, another empty insert row is added to the list, so that you can continue to add data.

The row that contains an asterisk at the bottom is the insert row—the row you use to insert additional data.

Add a row or a column to the list, cont’d. How to use lists List with an insert row If you click outside the list, the insert row and asterisk disappear, and the list border moves up one row. (Continued on next slide.) When another name, Callahan, is added to Cell A8… … a new insert row is added in cell A9.

When another name, Callahan, is added to Cell A8…

… a new insert row is added in cell A9.

Add a row or a column to the list, cont’d. How to use lists List with an insert row You can add a column to the list by typing in the empty column to the right. The list automatically expands to include that column.

Add up values The Toggle Total Row button on the new List toolbar totals the last column in the list. To get a total in column C of the example: How to use lists Click the Toggle Total Row button on the List toolbar... ... to add a Total row to the list. The Toggle Total Row button on the new List toolbar

The Toggle Total Row button on the new List toolbar totals the last column in the list.

To get a total in column C of the example:

Click the Toggle Total Row button on the List toolbar...

... to add a Total row to the list.

Suggestions for practice Create a list. Add a total to a list. Add a row and a column. How to use lists Online practice (requires Excel 2003)

Create a list.

Add a total to a list.

Add a row and a column.

Test 1, question 1 On which menu is the List command? (Pick one answer.) How to use lists On the Tools menu. On the Data menu. On the List menu.

On which menu is the List command? (Pick one answer.)

On the Tools menu.

On the Data menu.

On the List menu.

Test 1, question 1: Answer On the Data menu. How to use lists On the Data menu in Excel 2003, point to List , and then click Create List .

On the Data menu.

Test 1, question 2 How do you add a column to a list? (Pick one answer.) How to use lists Type in the empty column to the right. On the Data menu, point to List , and then click Resize List . Right-click the empty column to the right, click Insert , and then click Entire Column .

How do you add a column to a list? (Pick one answer.)

Type in the empty column to the right.

On the Data menu, point to List , and then click Resize List .

Right-click the empty column to the right, click Insert , and then click Entire Column .

Test 1, question 2: Answer Type in the empty column to the right. How to use lists The list will automatically expand to include that column.

Type in the empty column to the right.

Lesson 2 Sort and filter a list

Sort and filter a list When you create a list with the List command, you automatically add AutoFilter arrows to the list. You can use the AutoFilter arrows for sorting and filtering your list data. The List command also lets you work with several lists on a single worksheet. How to use lists AutoFilter arrows

When you create a list with the List command, you automatically add AutoFilter arrows to the list.

You can use the AutoFilter arrows for sorting and filtering your list data.

The List command also lets you work with several lists on a single worksheet.

How to sort You can sort any column in a list, just by clicking its AutoFilter arrow and choosing one of the sort commands on the menu that appears. How to use lists (Continued on next slide.)

You can sort any column in a list, just by clicking its AutoFilter arrow and choosing one of the sort commands on the menu that appears.

How to sort, cont’d. How to use lists To sort the Date column in the example in descending order, so that you could see the most recent orders first: Click the AutoFilter arrow on the Date header… … click Sort Descending .

Click the AutoFilter arrow on the Date header…

… click Sort Descending .

How to filter Filtering list data is as simple as sorting. Excel will automatically show only the data you specify. To see only sales made by Peacock, instead of everyone’s sales: How to use lists Click the AutoFilter arrow on the Name column. Select Peacock.

Filtering list data is as simple as sorting. Excel will automatically show only the data you specify.

To see only sales made by Peacock, instead of everyone’s sales:

Click the AutoFilter arrow on the Name column.

Select Peacock.

More than one list on a worksheet When you use the List command, you can have more than one list on a worksheet. You can add or delete a row in one list without adding or deleting a row in a list next to it, an ability new in Excel 2003. How to use lists You can add a row to the list on the right without adding a row to the list on the left. You can also sort those lists separately, because using the List command automatically gives each list its own AutoFilter arrows.

When you use the List command, you can have more than one list on a worksheet.

You can add or delete a row in one list without adding or deleting a row in a list next to it, an ability new in Excel 2003.

Suggestions for practice Sort a list Filter a list. How to use lists Online practice (requires Excel 2003)

Sort a list

Filter a list.

Test 2, question 1 How do you sort list data in descending order? (Pick one answer.) How to use lists Click Sort on an AutoFilter arrow in the list. Click Sort Descending on an AutoFilter arrow in the list. Click Sort Descending on the List toolbar.

How do you sort list data in descending order? (Pick one answer.)

Click Sort on an AutoFilter arrow in the list.

Click Sort Descending on an AutoFilter arrow in the list.

Click Sort Descending on the List toolbar.

Test 2, question 1: Answer Click Sort Descending on an AutoFilter arrow in the list. How to use lists

Click Sort Descending on an AutoFilter arrow in the list.

Test 2, question 2 You can have more than one list on a worksheet, and you can add or delete a row in one list without adding or deleting a row in the list next to it . (Pick one answer.) How to use lists True. False.

You can have more than one list on a worksheet, and you can add or delete a row in one list without adding or deleting a row in the list next to it . (Pick one answer.)

True.

False.

Test 2, question 2: Answer True. How to use lists

True.

Quick Reference Card For a summary of the tasks covered in this course, view the Quick Reference Card . How to use lists

For a summary of the tasks covered in this course, view the Quick Reference Card .

USING THIS TEMPLATE See the notes pane or view the full notes page ( View menu) for detailed help on this template.

Add a comment

Related pages

Modul 05 MS-Excel (15 Tage, 120 Stunden) - frs-institut.de

August 2010 Modul 05 MS-Excel (15 Tage, 120 Stunden) _____ Der Teilnehmer lernt die Anwendungsbereiche ...
Read more

Excel2010 - Runden??? auf 0.05 - MS-Office-Forum

Runden??? auf 0.05 Microsoft Excel ... sorry, leider nein. warum dividiere ich durch 0,05? weil ich auf 0,05 runden will??
Read more

MS Excel 2007 / Excel 2010 / Excel 2013 / Excel 2016 ...

MS Excel 2007 / Excel 2010 / Excel 2013 / Excel 2016 - Formeln und Funktionen - Seminare Schulungen Kurse und Trainings in Deutschland Österreich und in ...
Read more

Ms Excel #05- Format Cell Part 2/2 End - YouTube

In Ms Excel it is very importance for all of you understanding about all type of number (Format Cell) because it can effect to result when you ...
Read more

MS Excel 2007 / Excel 2010 / Excel 2013 / Excel 2016 - VBA ...

MS Excel 2007 / Excel 2010 / Excel 2013 / Excel 2016 - VBA - Programmierung Grundkurs - Grundlagen Schulung, ... 05.12. - 07.12.16: 3 Tage
Read more

Microsoft Office - Microsoft Download Center

Microsoft Office Compatibility Pack für Dateiformate von Word, Excel und PowerPoint Öffnen, Bearbeiten und Speichern ... 05 Word Viewer ...
Read more

Microsoft Download Center: Windows, Office, Xbox und mehr

Die neuesten Downloads für Windows, Windows-Apps, Office, Xbox, Skype, Windows 10, Lumia Smartphone, Edge und Internet Explorer, Dev Tools und mehr.
Read more

Excel: Aus Geburtstag das Alter berechnen - CHIP

So ermitteln Sie mit Excel das Alter. Alter berechnen mit Formel In unserem Beispiel gehen wir von einer kleineren Firma aus, die zehn Mitarbeiter hat.
Read more

Bei der Achsenformatierung in Excel 2010 kommt es ver ...

Bei der Achsenformatierung in Excel 2010 kommt es ver verschiedenen Computern in der Firma zu ... Uns wurde von MS ein Script zur Verfügung ...
Read more

Office-Schulungscenter - Office-Support

Hier finden Sie Schulungen und Lernprogramme zu Office 365 und den Office-Apps, darunter Outlook, OneNote, Word, Excel, PowerPoint, Skype for Business und ...
Read more