Calculate the Week Number in Excel February 17, 2009
Posted by computertrainer in Excel Tips.Tags: Excel, Week Number, WeekNum
add a comment
To calculate a week number: Use the WEEKNUM function.
Note: This function is included in the Analysis ToolPak add-in for
Excel 97 – 2003. The function is built into Excel 2007.
1. From the Tools menu, select Add-Ins.
2. Select the Analysis ToolPak check box, and then click OK.
In the WeekNum function, the second argument, Return_type, determines on which day the week begins, for example, 1 for Sunday, 2 for Monday. See the examples below:
Example of WeekNum Function
PowerPoint Presentation Basics February 2, 2009
Posted by computertrainer in PowerPoint Tips.add a comment
Sheryl Forkey of the Web Action Group (my website designers) has suggested the following tip. I can’t help but agree with her!
- Tell them what you are going to tell them (Introduction)
- Tell Them (Body of presentation)
- Tell them what you told them (Conclusions)
Thanks, Sheryl!
Create and Use Custom Dictionaries February 2, 2009
Posted by computertrainer in Word Tips.Tags: custom dictionary, dictionaries
add a comment
To prevent Microsoft Word from flagging the spelling of words that aren’t in the main dictionary and are not misspelled, you can use a custom dictionary. Word shares custom dictionaries with other Microsoft programs, such as Excel, PowerPoint, and Outlook.
Create or add a custom dictionary
Create a new custom dictionary
1. On the Tools menu, click Options, and then click the Spelling & Grammar tab.
2. Click Custom Dictionaries.
3. Click New.
4. In the File name box, type a name for the custom dictionary.
5. Click Save.
6. In the Dictionary list box, select the new custom dictionary.
7. Activate the custom dictionary.
A. In the Custom Dictionaries dialog box, make sure the check box beside the dictionary’s name is selected.
B. On the Spelling & Grammar tab, clear the Suggest from main dictionary only check box.
Edit a custom dictionary
Add, delete, or edit words in a custom dictionary
1. On the Tools menu, click Options, and then click the Spelling & Grammar tab.
2. Click Custom Dictionaries.
3. Select the dictionary you want to edit. Make sure you do not clear its check box.
4. Click Modify.
5. Do one of the following:
To add a word, type it in the Word box, and then click Add.
To delete a word, select it in the Dictionary box, and then click Delete.
To edit a word, delete it, and then add it with the spelling you want.
Add words to a custom dictionary during a spelling check
1. On the Standard toolbar, click Spelling and Grammar .
2. In the Not in Dictionary box, make sure you see the word you want to add to a custom dictionary.
3. To select the custom dictionary you want to add words to, click Options, and then click Custom Dictionaries. Select the check box next to a dictionary in the Dictionary list box, and then click OK twice.
Note If you don’t see your custom dictionary in the list, you need to select the check box next to the dictionary to activate it.
4. Click Add to Dictionary.
Tip: If you’re using automatic spell checking, here’s an even faster way to add a word to the default custom dictionary: Right-click a word with a wavy red underline, and then click Add to Dictionary on the shortcut menu.
