PC ProSchools – TechTalk

Microsoft Excel is a popular application used by many companies for tracking and storing data. As a Help Desk Professional, you may be called to fix problems with Excel. Here is a list of problems and their solutions that you may find useful:

1. Remove Passwords on Excel Password Protected Sheets and Workbooks
   You may need to open an Excel spreadsheet that has a password. Passwords can be lost and forgotten. When that happens, you can follow the steps described in Remove Passwords on Excel Password Protected Sheets and Workbooks to help you open a password protected spreadsheet.
2. Solving Common Excel Setup Problems
   When you are having trouble getting Excel to open or working correctly, you have to fix a setup problem. Solving Common Excel Setup Problems describes a few setup problems and their solutions.
3. Removing Add-ins
   Microsoft Excel allows you to install Third Party Apps that extend the functionality of Excel. ASAP Utilities helps you to automate frequently used tasks in excel. You may be having a problem with an Add-In. Microsoft Excel doesn’t have an obvious way of deleting the Add-In. Excel.Tips.Net explains how to remove the Add-In.
4. Excel Formula Errors and How to Deal With Them
   When you create formulas in Excel, you can cause errors to occur. In order to fix an error, you need to know what it means. Learn what #NULL!, #DIV/0 and other error message mean and how to solve them.
5. Repairing corrupted files in Excel
   Files can become corrupt and require repairing. Microsoft Excel has an automatic recovery which attempts to repair that file. Sometimes, you may need to manually repair the file in order to get your data. Try to manually repair an Excel spreadsheet by following Microsoft’s tips.
6. Top ten ways to clean your data
   Sometimes a spreadsheet can have empty rows, misspelled words or extra spaces. You need to clean up the spreadsheet in order to get it to work correctly. Try this tips from Microsoft on cleaning your data.
7. Troubleshoot Errors When Saving Excel Files
   When you save an Excel spreadsheet, an error may occur and you can’t save the file. Microsoft provides common save errors and their solutions.

Bonus Tip

Cheat sheets or quick reference cards lists shortcuts and functions. Use a cheat sheet as a reference so that you work in Excel faster.

Trackback URI | Comments RSS