- HubPages»
- Technology»
- Computers & Software»
- Computer How-Tos & Tutorials
Microsoft Excel - 29 undiscovered tips for troubleshooting
Below are some undiscovered tips for the Microsoft Excel troubleshooting
1. Go ahead and join text in multiple columns.
2. Now set the print area.
3, You should exclude some duplicate items in the list.
4. Now multiply all text values by 1 to change all text to numbers.
5. You can also use the Text Import Wizard to change text to numbers.
6. Sort all decimal numbers in an outline.
7. Use a data form to add records to the list.
8. Now enter the current date or time.
9. Now view all the arguments in a formula.
10. Now enter the same text or formula in a range of cells.
11. Link one text box to data in one cell.
12. Now you can link a picture to a cell range.
12. You can also troubleshoot some long formulas.
13, You can also view a graphical map of the defined name.
14. Now fill blank cells in a column with contents from a previous cell.
15. You can also switch from a relative reference to an absolute reference.
16. Go ahead and use the OFFSET function to modify data in cells that are inserted.
17. Use the Advanced Filter command option.
18. Now use some conditional sums to total data.
19. Use some conditional sums to count the data.
20. Go ahead and use the INDEX and MATCH functions to lookup data.
21. Drag the fill up handle to create a number series.
22. You can also automatically fill data.
23. Now, use VLOOKUP function for unsorted data.
24. Return every 3rd number.
25. Make a round to the nearest penny.
26. Now install and use Microsoft Excel Help.
27. Always remeber to not open and save directly from a floppy disk.
28. Use just one keystroke to create a new work sheet or chart.
29. You can also set up multiple print areas on the same worksheet.
http://support.microsoft.com/default.aspx?scid=kb;en-us;843504
Microsoft products on amazon
Microsoft Support Knowledge Base Resources
- microsoft support knowledge base Resources | TechRepublic
White papers, case studies, technical articles, and blog posts relating to microsoft support knowledge base - Frequently asked questions about the Office Activation Wizard and about reduced-functionality mode i
Contains the answers to frequently asked questions about the Office Activation Wizard and about reduced-functionality mode in 2007 Office suites and programs. - http://windowshelp.microsoft.com/Windows/en-us/help/334c6e6c-9289-49e3-8a81-c3981f5f42dc1033.mspx
- Microsoft Knowledge Base monitoring
- http://www.microsoftfrontpage.com/content/KBarticles/KBarticles.htm
- How to query the Microsoft Knowledge Base by using keywords and query words
Describes and lists keywords and query words that you can use to search Microsoft Knowledge Base articles. - Microsoft Help and Support
The Microsoft Help and Support home page is your portal to help and support for Microsoft products. Download the latest updates and find top issues, error messages, and troubleshooting tips for Windows XP, Windows Vista, the 2007 Microsoft Office sys - http://www.microsoft.com/downloads/details.aspx?FamilyID=254eb128-5053-48a7-8526-bd38215c74b2