Help Wiki - User contributions [en]

Finding and Applying Templates

2011-10-26T16:32:10Z

Grojoh24: /* Additional Resources */

<div class="intro">[[File:Excel_logo.jpg‎ |left|75px]]Excel templates provide a pre-made framework for specific spreadsheet applications, like budgets, receipts, calendars, schedules, etc. This is useful if you know what you want your spreadsheet to do, but are not sure, or do not have the time to set it up.</div>
====Finding a Template====
Excel has a large number of built-in templates. You are given an option to use a template when you create a new spreadsheet. In addition, Microsoft keeps a sorted and searchable database online with thousands of templates.

====Applying a Template====
Once you select a template that is built into Excel, it will automatically apply that template to your new spreadsheet. If you choose to download a template from Microsoft's database, you can opt to use it in the New Spreadsheet dialog.

====Additional Resources====
*[http://office.microsoft.com/en-us/templates/CT010152732.aspx?av=ZXL Sorted Excel Template Database]
*[http://office.microsoft.com/en-us/templates/ Searchable Office Template Database]
*[http://www.youtube.com/watch?v=t7l0HW2NxGc How to Apply an Excel Template] (Video Tutorial)
*Feel free to contact [http://rails.evergreen.edu/contact/?site=ac-computing-help&recipient=acadcomphelp&tt=true&subject=Email%20from%20the%20Moodle%20Assignments%20Help%20Page Academic Computing] should you need additional help.
[[category:Excel]]

Working between Keynote and Powerpoint

2011-10-26T16:31:44Z

Grojoh24: /* Additional Help */

<div class="intro">[[File:Ppicon.gif‎ |left|75px]]Powerpoint is installed on all of the Windows and Macintosh machines in the computer center. Another presentation software, Keynote, is installed on all of the Macintosh machines in the center. Both of these programs are easy to use and make excellent slideshows.

It can be useful to transition between these two programs.</div>

====Powerpoint to Keynote====
If you have a Powerpoint presentation that you would like to modify in Keynote, most .ppt files can be opened directly with Keynote, automatically converting them in the process. You can do this on a Macintosh computer by choosing Keynote from the "Open With..." menu on a Powerpoint file, or by selecting a Powerpoint file from the File > Open... dialog.

====Keynote to Powerpoint====
If you have a Keynote presentation that you need to run on a Windows computer, this can also be easily done. You can simply export the file as a .ppt (Powerpoint Presentation) from the File menu and choosing the Export button.

====Additional Help====
*[http://www.keynoteuser.com/tips/exportingppt.html Exporting: From Keynote to PowerPoint]
*[http://www.youtube.com/watch?v=uupUkO2FTh0 Importing: From PowerPoint to Keynote] (Video Tutorial)
*Feel free to contact [http://rails.evergreen.edu/contact/?site=ac-computing-help&recipient=acadcomphelp&tt=true&subject=Email%20from%20the%20Moodle%20Assignments%20Help%20Page Academic Computing] should you need additional help.
[[category:Powerpoint]]

Working between Keynote and Powerpoint

2011-10-26T16:31:34Z

Grojoh24: /* Additional Help */

<div class="intro">[[File:Ppicon.gif‎ |left|75px]]Powerpoint is installed on all of the Windows and Macintosh machines in the computer center. Another presentation software, Keynote, is installed on all of the Macintosh machines in the center. Both of these programs are easy to use and make excellent slideshows.

It can be useful to transition between these two programs.</div>

====Powerpoint to Keynote====
If you have a Powerpoint presentation that you would like to modify in Keynote, most .ppt files can be opened directly with Keynote, automatically converting them in the process. You can do this on a Macintosh computer by choosing Keynote from the "Open With..." menu on a Powerpoint file, or by selecting a Powerpoint file from the File > Open... dialog.

====Keynote to Powerpoint====
If you have a Keynote presentation that you need to run on a Windows computer, this can also be easily done. You can simply export the file as a .ppt (Powerpoint Presentation) from the File menu and choosing the Export button.

====Additional Help====
*[http://www.keynoteuser.com/tips/exportingppt.html Exporting: From Keynote to PowerPoint]
*[http://www.youtube.com/watch?v=uupUkO2FTh0 Importing: From PowerPoint to Keynote] (Video Tutorial)
*Feel free to contact [http://rails.evergreen.edu/contact/?site=ac-computing-help&recipient=acadcomphelp&tt=true&subject=Email%20from%20the%20Moodle%20Assignments%20Help%20Page Academic Computing] if you need additional help.
[[category:Powerpoint]]

Finding and Applying Templates

2011-10-26T16:29:47Z

Grojoh24:

Finding and Applying Templates

2011-10-26T16:29:12Z

Grojoh24:

<div class="intro">[[File:Excel_logo.jpg‎ |left|75px]]Excel templates provide a pre-made framework for specific spreadsheet applications, like budgets, receipts, calendars, schedules, etc. This is useful if you know what you want your spreadsheet to do, but are not sure, or do not have the time to set it up.</div>
====Finding a Template====
Excel has a large number of built-in templates. You are given an option to use a template when you create a new spreadsheet. In addition, Microsoft keeps a sorted and searchable database online with thousands of templates.

====Applying a Template====
Once you select a template that is built into Excel, it will automatically apply that template to your new spreadsheet. If you choose to download a template from Microsoft's database, you can opt to use it in the New Spreadsheet dialog.

====Additional Resources====
*[http://office.microsoft.com/en-us/templates/CT010152732.aspx?av=ZXL Sorted Excel Template Database]
*[http://office.microsoft.com/en-us/templates/ Searchable Office Template Database]
*[http://www.youtube.com/watch?v=t7l0HW2NxGc How to Apply an Excel Template] (Video Tutorial)
*Contact [http://rails.evergreen.edu/contact/?site=ac-computing-help&recipient=acadcomphelp&tt=true&subject=Email%20from%20the%20Moodle%20Assignments%20Help%20Page Academic Computing] if you need additional help.
[[category:Excel]]

Sorting Data

2011-10-26T03:12:36Z

Grojoh24: /* Extra Help */

Sorting Data

2011-10-26T02:43:54Z

Grojoh24: /* Extra Help */

Sorting Data

2011-10-26T02:42:35Z

Grojoh24:

Adding Clip Art

2011-10-21T23:23:06Z

Grojoh24:

==Inserting Clip Art==

===Why?===

Clip Art is an incredibly useful tool for Powerpoint users and presenters. This tool will allow you to add clip art not just from your personal library, but Microsoft Office Online as well. All you need to do is search for your desired image in the Clip Art pane on the right side of your slides, specify your search options (where to search and for what type of file) and then click OK.

===How?===

Step one is to move from Home to Insert in the top of the Powerpoint window. Next, click on the Clip Art icon to bring up the Clip Art side pane. First, enter the topic of your search, like Ponies, Hot Air Balloons, or Forest Scenery. Then, as described above, specify that you would like to search in My Collections, Office Collections, Office Web, or just search Everywhere. Next you'll need to specify the file type you're searching for, by selecting Clip Art, Photographs, Movies or Sounds. Or, you could just leave everything checked. After that, all you need to do is double click on the picture you want to insert into your slideshow. It should be right on top of the slide you were just working on.

===Happy Presenting!===

[[category:Powerpoint]]

Sorting Data

2011-10-21T23:22:01Z

Grojoh24: /* Sorting Multiple Columns */

Sorting Data

2011-10-21T23:21:47Z

Grojoh24: /* Sorting By Row */

Sorting Data

2011-10-21T23:21:20Z

Grojoh24: /* Sorting By Row */

Sorting Data

2011-10-21T23:21:04Z

Grojoh24:

Sorting Data

2011-10-21T23:20:37Z

Grojoh24:

Sorting Data

2011-10-21T23:20:15Z

Grojoh24:

Sorting Data

2011-10-21T23:19:57Z

Grojoh24:

Sorting Data

2011-10-21T23:19:46Z

Grojoh24:

Sorting Data

2011-10-21T23:18:55Z

Grojoh24:

Sorting Data

2011-10-21T23:18:16Z

Grojoh24:

Sorting Data

2011-10-21T23:14:05Z

Grojoh24:

<div class="intro">[[File:Excel_logo.jpg‎ |left|75px]]Sorting data is useful for organizing long or short lists of data, from largest to smallest, smallest to largest, making use of custom options, or by column, row, or any combination of these factors.</div>

==Quick Sort==
The easiest, and quickest, way to sort data in Excel is to use the Quick Sort button in the Data tab. However, there are certain conditions that need to be filled first: whatever selection you have made for sorting, you must ensure there are no blank cells. Blank cells will royally screw up any data sorting you want to do. Once you have ensured this is not the case for your data set, select the column you want to sort and click on either the AZ or ZA shortcut keys (smallest to largest or largest to smallest, resp.) as shown below. This method works best when sorting a single column or sorting a series of columns according to whatever is in the first one of the series.

[[File:Excelsort01.png]]

==Sorting Multiple Columns==

There are two ways to sort multiple columns: using a prescribed sorting method (preloaded conditions) or using a custom sorting method (conditions you enter yourself). They are both fairly simple, but lets start with using what is already at your fingertips. Go to the Data tab and select the Sort macro key (shown below). This will Bring up the Dialogue Box.

[[File:Excelsort02.png]]

Next you'll need to change the Sort By option to suit what you want your data to be sorted by first. You can also choose what to sort the data on (Values, Cell Color, Font Color or Cell Icon) and whether to go from A to Z (for text), Largest to Smallest (for numbers), or vice verse. Once you have this figured, you can start to Add Levels to your sorting options, for example:

[[File:Excelsort03.png]]

Now that all your filters are set, your data will be sorted as you see below:

[[File:excelsort04.png]]

The gender column was sorted first (1) so all females are at the top of the list (A to Z). The next filter was for State (2) from A to Z, so girls from Alaska come first. Finally, we sorted by Birth Year (3) from Smallest to Largest, so the girls with the smallest numerical birth year (older girls) will be put to the top of the series.

==Custom Sort==

As stated above, you can also use your own custom sorting methods. To do this, we need simply select Custom List from the Order drop down menu in the Sort Dialogue Box (discussed above). Once here, you can access some premade custom lists (like Days and Months) or create your very own and save it to Excel's database! That way you will be able to access that same custom sorting option again later.

==Sorting By Row==

This is a simple procedure, with one or two very important minor details. First, get back into the Sort Dialogue Box, and go to the Options button.

[[File:excelsort05.png]]

Then, simply select 'Sort left to right'. This will enable sorting by column. Now press OK. Only one more step.

[[File:excelsort06.png]]

You should be back in the Sort Dialogue Box now, with some different options. In the Sort By drop down, you should be able to select rows (Row 1, Row 2, etc.) instead of other designators. Make sure you select the correct row. If you don't, your data won't be sorted correctly!

[[category:Excel]]

Sorting Data

2011-10-21T04:25:22Z

Grojoh24:

<div class="intro">[[File:Excel_logo.jpg‎ |left|75px]]Sorting data is useful for organizing long or short lists of data, from largest to smallest, smallest to largest, making use of custom options, or by column, row, or any combination of these factors.</div>

==Quick Sort==
The easiest, and quickest, way to sort data in Excel is to use the Quick Sort button in the Data tab. However, there are certain conditions that need to be filled first: whatever selection you have made for sorting, you must ensure there are NO BLANK CELLS. Blank cells will royally screw up any data sorting you want to do. Once you have ensured this is not the case for your data set, select the column you want to sort and click on either the AZ or ZA shortcut keys (smallest to largest or largest to smallest, resp.) as shown below. This method works best when sorting a single column or sorting a series of columns according to whatever is in the first one of the series.

[[File:Excelsort01.png]]

==Sorting Multiple Columns==

There are two ways to sort multiple columns: using a prescribed sorting method (preloaded conditions) or using a custom sorting method (conditions you enter yourself). They are both fairly simple, but lets start with using what is already at your fingertips. Go to the Data tab and select the Sort macro key (shown below). This will Bring up the Dialogue Box.

[[File:Excelsort02.png]]

Next you'll need to change the Sort By option to suit what you want your data to be sorted by FIRST. You can also choose what to sort the data on (Values, Cell Color, Font Color or Cell Icon) and whether to go from A to Z (for text), Largest to Smallest (for numbers), or vice verse. Once you have this figured, you can start to Add Levels to your sorting options, for example:

[[File:Excelsort03.png]]

Now that all your filters are set, your data will be sorted as you see below:

[[File:excelsort04.png]]

The gender column was sorted first (1) so all females are at the top of the list (A to Z). The next filter was for State (2) from A to Z, so girls from Alaska come first. Finally, we sorted by Birth Year (3) from Smallest to Largest, so the girls with the smallest numerical birth year (older girls) will be put to the top of the series.

==Custom Sort==

As stated above, you can also use your own custom sorting methods. To do this, we need simply select Custom List from the Order drop down menu in the Sort Dialogue Box (discussed above). Once here, you can access some premade custom lists (like Days and Months) or create your very own and save it to Excel's database! That way you will be able to access that same custom sorting option again later.

==Sorting By Row==

This is a simple procedure, with one or two VERY important minor details. First, get back into the Sort Dialogue Box, and go to the Options button.

[[File:excelsort05.png]]

Then, simply select 'Sort left to right'. This will enable sorting by column. Now press OK. Only one more step.

[[File:excelsort06.png]]

You should be back in the Sort Dialogue Box now, with some different options. In the Sort By drop down, you should be able to select rows (Row 1, Row 2, etc.) instead of other designators. MAKE SURE YOU SELECT THE CORRECT ROW. If you don't, your data won't be sorted correctly!

[[category:Excel]]

File:Excelsort07.png

2011-10-21T04:17:04Z

Grojoh24:

File:Excelsort06.png

2011-10-21T04:16:57Z

Grojoh24:

File:Excelsort05.png

2011-10-21T04:16:50Z

Grojoh24:

Sorting Data

2011-10-21T04:15:10Z

Grojoh24:

<div class="intro">[[File:Excel_logo.jpg‎ |left|75px]]Sorting data is useful for organizing long or short lists of data, from largest to smallest, smallest to largest, making use of custom options, or by column, row, or any combination of these factors.</div>

==Quick Sort==
The easiest, and quickest, way to sort data in Excel is to use the Quick Sort button in the Data tab. However, there are certain conditions that need to be filled first: whatever selection you have made for sorting, you must ensure there are NO BLANK CELLS. Blank cells will royally screw up any data sorting you want to do. Once you have ensured this is not the case for your data set, select the column you want to sort and click on either the AZ or ZA shortcut keys (smallest to largest or largest to smallest, resp.) as shown below. This method works best when sorting a single column or sorting a series of columns according to whatever is in the first one of the series.

[[File:Excelsort01.png]]

==Sorting Multiple Columns==

There are two ways to sort multiple columns: using a prescribed sorting method (preloaded conditions) or using a custom sorting method (conditions you enter yourself). They are both fairly simple, but lets start with using what is already at your fingertips. Go to the Data tab and select the Sort macro key (shown below). This will Bring up the Dialogue Box.

[[File:Excelsort02.png]]

Next you'll need to change the Sort By option to suit what you want your data to be sorted by FIRST. You can also choose what to sort the data on (Values, Cell Color, Font Color or Cell Icon) and whether to go from A to Z (for text), Largest to Smallest (for numbers), or vice verse. Once you have this figured, you can start to Add Levels to your sorting options, for example:

[[File:Excelsort03.png]]

Now that all your filters are set, your data will be sorted as you see below:

[[File:excelsort04.png]]

The gender column was sorted first (1) so all females are at the top of the list (A to Z). The next filter was for State (2) from A to Z, so girls from Alaska come first. Finally, we sorted by Birth Year (3) from Smallest to Largest, so the girls with the smallest numerical birth year (older girls) will be put to the top of the series.

==Custom Sort==

As stated above, you can also use your own custom sorting methods. To do this, we need simply select Custom List from the Order drop down menu in the Sort Dialogue Box (discussed above). Once here, you can access some premade custom lists (like Days and Months) or create your very own and save it to Excel's database! That way you will be able to access that same custom sorting option again later.

==Sorting By Row==

[[category:Excel]]

Sorting Data

2011-10-21T04:04:57Z

Grojoh24:

File:Excelsort04.png

2011-10-21T04:04:44Z

Grojoh24:

Sorting Data

2011-10-21T04:03:51Z

Grojoh24:

File:Excelsort03.png

2011-10-21T04:02:16Z

Grojoh24:

File:Excelsort02.png

2011-10-21T03:55:29Z

Grojoh24:

Sorting Data

2011-10-21T03:52:05Z

Grojoh24:

File:Excelsort01.png

2011-10-21T03:51:08Z

Grojoh24: uploaded a new version of "File:Excelsort01.png"

Adding Clip Art

2011-10-14T23:40:58Z

Grojoh24: Created page with '==Inserting Clip Art== ===Why?=== Clip Art is an incredibly useful tool for Powerpoint users and presenters. This tool will allow you to add clip art not just from your perso…'

==Inserting Clip Art==

===Why?===

Clip Art is an incredibly useful tool for Powerpoint users and presenters. This tool will allow you to add clip art not just from your personal library, but Microsoft Office Online as well! All you need to do is search for your desired image in the Clip Art pane on the right side of your slides, specify your search options (where to search and for what type of file) and BAM! Instant satisfaction.

===How?===

Clip Art is a snap! First step is to move from Home to Insert in the top of the Powerpoint window. Next, click on the Clip Art icon to bring up the Clip Art side pane. First, enter the topic of your search, like Ponies, Hot Air Balloons, or Forest Scenery. Then, as described above, specify that you would like to search in My Collections, Office Collections, Office Web, or just search Everywhere. Next you'll need to specify the file type your searching for, by selecting Clip Art, Photographs, Movies or Sounds. Or, you could just leave everything checked. After that, all you need to do is double click on the picture you want to insert into your slideshow, and BAM! It's right on top of the slide you were just working on.

===Happy Presenting!===

[[category:Powerpoint]]