Excel Trainings



             


Thursday, October 30, 2008

Corrupt Excel File Recovery

Excel worksheets are used to create and manage financial transactions, performance reports, charts, business reports, accounting transactions, and other financial and diagrammatic records. The excel (.xls) files generally get corrupt due to registry corruptions, virus attacks, unexpected system shutdowns, power failures and media corruptions. To recover back the lost and deleted excel files and data you can utilize the inbuilt recovery measures provided in MS Excel which performs the recovery procedure effectively and repairs the corruption in almost every case.

Whenever an excel file gets corrupt due to unexpected system shutdown or power failure, the very next time when the application is launched, MS Excel displays a Document Recovery Window, where list of all the repaired files are listed. You can select the appropriate file and the last saved data will be recovered instantly.

But in case if MS Excel does not recovers the file, you can manually start the process of recovery:

1. Open New Excel worksheet

2. Click the File menu and select the Open option.

3. In the Open dialogue box, select the .xls file which you want to open. The Open button will get activated, click the arrow and select the Open and Repair option.

4. Click the Repair button to start the process of recovery and Extract Data button to extract data if excel was unable to repair a previous workbook.

The Excel workbook with corruptions can be easily recovered and repaired by using this method.

The additional methods which can be utilized to recover data from excel workbooks are, opening the file on different hard disk or on a different computer system, saving a backup copy, opening the file in ms word or notepad or otherwise using a third party utility.

Third party utilities prove beneficial in the cases where inbuilt recovery methods are not able to recover major corruptions like, the complete formulas or are unable to convert the excel values.

Kernel Recovery for Excel is advanced excel recovery software which efficiently recovers excel sheets, restores formatting, recovers password protected excel worksheets, data structures, OLE objects, headers and footnotes, hyperlinks, formulas and values. The software tool for excel is simple and easy to use which recovers and repairs the excel data and files in minutes.

Kernel Recovery for Excel supports recovery from almost every version of MS Excel including MS Excel 2003, 2000, 97, XP.

About Nucleus Data Recovery (P) Ltd.

Nucleus Data Recovery (P) Limited is the industry leader in data recovery products and hard disk recovery software tools, which includes file repair, file recovery, database recovery, backup recovery and email recovery products. The technologically advanced company provides world-class data recovery products and data recovery services to promote the data safe world.

The Kernel Recovery software range supports recovery from Windows (95, 98, ME, NT, 2000, 2003, XP), Apple Macintosh, Linux, Novell, Unix operating system and FAT, NTFS, NTFS5, HFS, HFS+, NWFS, JFS, EXT2, and EXT3 file systems.

Labels: , , , ,

Monday, October 20, 2008

5 Ways to Excel At Site Promotion

To excel at site promotion, you have to have the insight of the methods used in site promotion. Following are 5 ways to excel at site promotion -

Affiliate Marketing – For a lucrative site promotion, affiliate marketing is one of the best ways. Use affiliate marketing to get your site name across people many times that directly come to your site. Affiliate marketing makes your site name popular and increases the number of visitors to your site. More people get your name and so your site becomes popular.

Advertising – Advertising is another great tool for lucrative site promotion. Advertising carry your name to people, make them aware of your site’s existence, provides them knowledge about what your site is about and creates customers. You can advertise online or in the print media. Both have different audience who may become your customers.

Search engines – Use search engines to promote your site. Try to get best ranking in the search engines. With good content and SEO keyword use in the content, you can get a good rank in the search engines. A good rank ensures that your site is visible to the search engine users and it is used by them and trusted.

Ezines – ezines will help you in article marketing. It is essential for lucrative site promotion. Ezines will get you more visitors and links. More people will come to your site from the links available through the article marketing.

Referrals – Referrals will help you to promote your site and excel at site promotion. Referrals promote your site faster. Referrals from the visitors, friends, and affiliates will get your more name and fame and more visitors.

Do you want to learn more about how I do it? I have just completed my brand new guide to generating massive traffic ‘Triple Your Traffic Fast'

Download it free here: Triple Your Traffic Fast

Download a free article marketing guide here: Secrets of Article Writing

Do you want to learn how to build a massive list fast? Click here: Email List Building

Raymond Nesa is an experienced web marketer specializing in article marketing, traffic generation, and list building.

Labels: , ,

Monday, October 13, 2008

Excel Password Types

Have you ever wondered that there can be types of passwords just like types of files? Is it possible? Yes it is. MS Excel is equipped with five types of password locking with which you can protect your worksheets. This means you can secure your MS Excel worksheet with 5 different password security measures and prevent unauthorized access to the worksheet.

This article targets to those users who need to secure excel worksheets for various reasons. Beneficial for people in finance field as MS Excel is widely used tool by accountants, charted accountants, brokers, stenos and every other individual who need to store and display data in a hierarchical order.

The Excel password types are:

1. Password to open the Worksheet
2. Password for Modifications
3. VBA Modules
4. Worksheet Password
5. Workbook Password
 

1.) Password to open the Worksheet:

You can assign passwords to the excel worksheets and prevent any individual from accessing it. To assign password to your .xls file:

Open the .xls document, which you want to password protect.
• Select the Save As option from the File menu.
• Click the Tools tab on the top of the Save As window and select the General Options… option.
• The Save Options window will be displayed, where you can enter the desired password in the Password to open text box.
 

If any unauthorized individual tries to open the worksheet, Microsoft Excel will ask to enter the password. If the password is incorrect the sheet will not open.

2.) Password for Modifications:

This option works similarly as the first one. As the password was assigned to open the excel worksheet, password to modify the excel worksheet can also be assigned in the similar way.

Open the .xls document, which you want to password protect.
• Select the Save As option from the File menu.
• Click the Tools tab on the top of the Save As window and select the General Options… option.
• The Save Options window will be displayed, where you can enter the desired password in the Password to modify text box.
 

Only authorized individuals who know the password can modify the document otherwise he can only view the read-only copy of the password protected worksheet. This kind of protection helps to protect the document getting modified by other people, thus saving the original data which you had saved before leaving your desk.

3.) VBA Modules:

The excel worksheet can contain VBA modules with added macros in the file. This Visual Basic for Application module can also be password protected. To password protect, perform the following:

• Select the VBA module and right-click the mouse button.
• Select the VBA Project Properties… option.
• Click the Protection tab.
• In this window, check the Lock project for viewing option and assign password in the Password to view project properties dialogue box.
• Click OK.
 

The VBA module is now protected with password and secure from any unauthorized use.

4.) Worksheet Password:

There can be several worksheets in a single .xls file like Sheet 1, Sheet 2 and so on. You can password protect them too. To assign password to any current worksheet perform the following:

• Click the Tools menu
• Select the Protection > Protect Sheet option. The Protect Sheet window will be displayed.
• Select amongst the number of options for your worksheet. (These options depend on the working version of MS Excel; I am working in MS Excel 2003)
• After selecting the options you can assign password to the worksheet.
 

5.) Workbook Password:

Like Worksheets, excel workbooks can also be protected in the similar way of protecting worksheets.

• Click the Tools menu
• Select the Protection > Protect Workbook option. The Protect Workbook window will be displayed.
• Select both or appropriate option from Structure and Windows and assign the password.
 

You can also try this:

• Click the Tools menu.
• Select the Protection > Protect and Share Workbook… option. The Protect Shared Workbook window will be displayed. This enables you to share the workbook with track changes.
• Check the Sharing with track changes option. This would activate the Password text box. • Assign password in the Password text box.
 

This kind of password protection helps at the time of sharing the excel worksheets. This would restrict other user from making changes in the document and retains the track changes in the sheet.

As there are 5 different options to protect the excel worksheet with passwords, there can be times when you tend to forget or lose the assigned password or the excel document can get corrupt due to virus attacks, accidental deletions, power outages etc. There are many excel password recovery tools to recover the lost / forgotten passwords. These software tools can easily restore the forgotten passwords of excel files. But if in case the MS Excel file gets corrupt, you can try the FREE demo version of Kernel Recovery for Excel, a corrupt excel file recovery software which easily recovers and repairs the damaged worksheets and extracts cell data, formulas, charts, images, hyperlinks etc. If the Excel repair software displays your lost data then you can purchase Full version of the excel file repair software.

Neha Gupta is a technical writer for Nucleus Data Recovery – the provider of best data recovery software and data recovery services.

Labels: ,