* * * A picture is worth a thousand words * * *
* Short cut keys that work with Excel 2003, also works with Excel 2007 and 2010
* Though there is no help menu in Office 2007, hitting F1, will pop up the help menu window
Step 1: Select the Menu icon on the top left corner and choose the circled Excel Option
Step 3: Type "A,B,C,D,....... Z" in the left side of the "List Entries" and then click the "Add" button
2. While inserting comment in Excel / Power point / Word, by default it adds the name / emp no. of the person during registration. How to change it ??
In the below given example To change the user name from Ranjith
 | ||||||
Step 2: Select the Menu icon on the top left corner and choose the circled Excel Option
Step 3: Change the highlighted name name from Ranjit to, as you wish...
3. To count the no. of words in excel, we can use =count( ), =counta( ). To count the no. of words, lines, paragraphs, character with/without space in a word file
4. To add a transparent background text / image (Watermark) in a word file
5. How to create a password to Protect your Excel sheet and File.
To protect a sheet, Open an excel file, Go to Tools -> Protection ->and type the password to
enable it
To protect an Excel file. Open an excel file, Go to File -> Save as -> Tools ->General options and create a password
6. How to view unread messages in Outlook 2010
Choose View -> Change View-> Manage Views
Choose the option New
Click the Filter box
Go to More Choices and check Only Items that are: Unread
Click Ok thrice… and you will be back to the main Outlook Window
Now, you will get one more option for Unread mails in your Views
7. (Organize button not found in Outlook 2010)??????? How to Organize Outlook 2010, using Colour.
Watch out daily... and many more to come...
Thanks for sharing the Excel formulas.Very Useful information indeed.
ReplyDelete