 Using a Symbol or Special Character
|
Summary: In Excel you are not restricted to the standard numerals, letters and punctuation marks on your keyboard. You can also select from hundreds of Special Characters, such as foreign letters and Currency Characters, such as the Euro. Here is how to access these special characters.
- Select the cell where you want to insert a symbol.
- Click on the Insert tab.
- Click on Symbol in the Symbol Group and the Symbol and Special Character dialog box will appear.
- Click on the Symbol Tab
- Select the Symbol you want.
- Click Insert and it will appear in the cell.
To insert a Special Character repeat the process. In Step 4 click on the Special Character tab and select your Special Character. Click on Insert and the Special Character will appear in the cell.
|
Read Back Your Data
|
Summary: If you have a large amount of data to enter you may want to check the accuracy of your data entry by having the data read back to you while you check it against a printed list. Here is how to do this.
Before Excel can read your data, you must add the following buttons to your Quick Access Toolbar: Speak Cells, Speak Cells - Stop Speaking Cells, Speak Cells by Columns, Speak Cells by Rows, and Speak Cells on Enter. After you have done this you can hear the data in selected cells by doing the following:
- Select the cells that you want Excel to read.
- Click on either the Speak by Columns or Speak by Rows icon in the Quick Access Toolbar.
- Click Speak Cells by Columns if you want Excel to read down the columns.
- Click Speak Cells by Rows if you want Excel to read across the rows.
- Click on the Speak Cells icon in the Quick Access Toolbar and Excel will read the selected data.
- To stop Excel reading the cells, click on the Speak Cells - Stop Speaking icon in the Quick Access Toolbar.
If you click on the Speak on Enter button the cell contents will be read each time you hit the Enter key.
|
Changing Your Name
Summary: When you first install Excel, it asks you for your name so it can personalize the registration for your program. It also writes your name in the User Area. If you need to change your name, here is how to do this:
-
Display the Excel Options dialog box.
(In Excel 2007 click on the Office Button and then click Excel Options. In Excel 2010 and 2013 click on the File tab of the ribbon and then click on Options)
- Make sure the Popular Option (Excel 2007) or General Option (Excel 2010 and Excel 2013) is selected at the left of the dialog box.
- Change the information in the User Name box.
- Click on OK.
This change will only affect new workbooks. In a new workbook the name you changed will end up in the workbook property. It will not affect the Author property for any existing workbook.
|
|
Save Changes to all Open Word Documents at Once
Summary: When you are working with multiple documents it is useful to save them all at once. Here is how to do this:
To do this you need to add an icon to the Quick Access Toolbar.
- Select the Office Button (File in 2010 and 2013).
- Select Word Options (Options in 2010 and 2013).
- Select Customize (Quick Access Toolbar in 2010 and 2013)
- Select Commands Not in the Ribbon.
- Scroll down and select Save All.
- Press the Add button.
- Press OK.
When you want to save all your open Word files click on the Save All button on the Quick Access Toolbar.
Back to top
|
|
Summary: Setting Up your PowerPoint Presentation is the key to delivering a successful presentation. Here are some great tips to follow when you are starting to design your presentation.
You need the following sections in your presentation:
The Introduction
- Use a Title Page with your Presentation Topic and your Name
- Then have an attention getting slide
-
Then in the order that makes sense to you
-
Your thesis
-
Your expertise
- How the topic connects to your audience
The Body
- Create slides that cover the items that you need to support and address your thesis
- Include pictures and videos
- Include interesting supporting material and well documented points
Conclusion
- Create slides that cover the items that you need to support and address your thesis
- Sum up
- Explain the usefulness of the material you have presented
- Provide closure by connecting back to your attention getter
- Include a blank slide for questions
Back to top
|
