|
TSU Program Web Issues Internet Activities Links Readings |
Excel Review
Home | Main Tutorials | Excel Tutorials | Excel Excercises
Over the years I have taught spreadsheet classes by the hundreds. I have had participants in those classes tell me they would like to take the class again as they haven't used Excel for a long time and find themselves with little recall of what they were successfully able to do months or years earlier. This section is intended to address those issues.
For those with a more recent Excel training experience, the review exercises are suggested. For those with a faint memory of what a spreadsheet might do, the movie clips are suggested. Choose whichever you wish. I have been told that the movies also make excellent introduction activities for someone just getting started with Excel.
Movie Clips
This collection of movie 'snippets' was created with the idea that each might help review some of the Excel features you may have experienced in an earlier Excel class. Perhaps you don't need to invest the time in a full review course. Perhaps you could watch a few movies and put you back at the skill level you left in an earlier Excel class. If a picture is worth a 1000 words, then a short movie clip may be worth millions!
The left column describes an action which needs reviewing. If you click on the file in the middle column, you will begin loading the movie to your computer to be launched for viewing. Some of the movie files are larger than others - be patient. None are very large.
The movie clips are categorized to help you find the movie type you are seeking. It will be important for you to set your monitor resolution for viewing. The minimum recommended screen resolution is 800 x 600, but higher is better. If you appear to get some of the movies cut off the bottom, your display is probably set too small. You may change your monitor's resolution by: (Using either Win 98/00/XP)
- Open the Control Panels (Open My Computer on the Desktop) Open the Display control panel Click on the settings tab Adjust the screen resolution to 800 x 600 (or higher)
- Select OK
Most of the movie files are .wmv and require a movie player such as Windows Media Player.
Most versions of Windows and Mac will allow you to either view OR save each movie for viewing later. A quick 'work-around' for either browser (without changing anything) is to right-click on the movie link and save the movie to your hard drive. Then double-click on the downloaded file. This will launch the movie in a movie viewer that can play movies in the wmv format.
| If You Want To: | Launch the File Below | Size |
| |
||
| Launch Excel from menu | launch excel | |
| Select which toolbars to display | select toolbars | |
| |
||
| Format text in an Excel cell | format a cell | |
| Change the font from the menu | fonts-menu | |
| Change the font from the toolbar | fonts-toolbar | |
| Align text within a cell horizontally | align-horizontal | |
| Align text within a cell vertically | align-vertical | |
| Adjust the width of a spreadsheet column | column widths | |
| Adjust the height of a spreadsheet row | adjust row height | |
| Change several columns at one time | multiple columns | |
| |
||
| Format a number in an Excel cell | format a cell | |
| Format numbers from the toolbar | number format | |
| |
||
| Quickly create headings for columns | auto headings | |
| |
||
| Create a formula in Excel | formula | |
| Manage the order of operations | order of operations | |
| Using exponents | exponents | |
| Create a formula with exponents | exponents & formulas | |
| Create a formula with radicals & roots | radicals and roots | |
| Use the SUM function to add a range | sum function | |
| |
||
| Insert a picture in your spreadsheet | insert picture | |
| Use the Drawing Tools in Excel | Draw |
|
| |
||
| Create a graph of your data | graph | |
| |
||
| Copy using the fill technique | fill down and right | |
| View sections of sheet simultaneously | split screen | |
| Convert rows to columns and vise-versa | transpose | |
| Copy and paste cells in Excel | ||
| Insert Rows and Columns | insert | |
| Sort data alphabetically or numerically | sorting | |
| Align text vertically | vertical align | |
| Create multiple text rows in a single cell | wrap text | |
| |
||
| Preview your document without printing | preview file | |
| Control the margins of your document and print gridllines | page setup | |
| Put Borders around your cells | borders | |
| Print a small portion of the spreadsheet | print area | |
| Change the orientation of your printing | print orientation | |
| Print headings on multiple pages | ||
| Use Help (contents) to control gridlines | help with gridlines | |
| |
||
| Merge multiple cells into a single cell | Merge and Undo Merge | |
| Use Hyperlinks to move within a sheet | goto | |
| Undo an edit in Excel | undo | |
| Check spelling of words in Excel | spell | |
| Toggle between view of formulas or values | see formulas | |
| |
||
| Simulate dice roll | random numbers | |