Month: April 2009

Microsoft Excel password types

Posted by cloud – April 28, 2009

Have you ever questioned yourself there can be types of passwords like the types of files? Yes it is. MS Excel has five types of lock password that will allow you to protect your work. This means you can secure your spreadsheets MS Excel password with 5 different security measures and prevent unauthorized access to the spreadsheet.

Objectives of this section for users who need to get Excel spreadsheets for various reasons. Beneficial for people in the area of finance such as MS Excel is widely used by accountants, charted accountants, brokers, and others who need to store and display data in a hierarchical order.

Excel passwords works like this:

1. Password to open the worksheet:

You can assign passwords to the spreadsheet Excel and prevent anyone from accessing it. To assign a password for your .xls file

1. Open the file .xls document to be protected by a password.

2. Select Save As from the File menu.

3. Click the Tools tab at the top of the Save As window and select Options… General

Save window option window will be displayed, where you can enter the password in the password to open the box.

If an unauthorized person tries to open the spreadsheet, Microsoft Excel asks you the password. If the password is incorrect the sheet will not open.

2. Password changes:

This option works the same way as the first. As the password was assigned to the opening of the Excel worksheet, password to modify the Excel spreadsheet can also be affected similarly.

1. Open the file. Xls document to be protected by a password.

2. Select Save As from the File menu.

3. Click the Tools tab at the top of the Save As window and select Options…. General

Save Options window will be displayed, where you can enter the password in the text box to edit.
Only authorized persons who know the password can edit the document can not see otherwise read-only copy of the spreadsheet protected with a password. This type of protection helps to protect the amended document obtained by others, thus saving the original data; you had saved before leaving your desk.

3. VBA modules:

The Excel spreadsheet can contain VBA modules with the addition of macros in the file. This Visual Basic for Applications module can also be password protected. A password protection, follow these steps:

1. Select the VBA module and right click the mouse button.

2. Select the VBA Project Properties….

3. Click the Security tab.

In this window, select the Lock project for viewing option and assign the password for the password to display the Properties dialog box for the project.

4. Click OK.

VBA module is password protected and secure from unauthorized user.

4. Worksheet password:

You can have multiple worksheets in one file. As Xls Sheet 1, sheet 2 and so on. You can password protect too. To set the password of any spreadsheet underway to do the following:

1. Click the Tools menu

2. Select the Protecting; Protect Sheet option. Protect Sheet window.

3. Select the number of options for the worksheet. (These options depend on the version of MS Excel; I work in MS Excel 2003)

After selecting the options you can assign a password to the spreadsheet.

5. Book Password:

As Excel spreadsheets can also be protected in similar ways to protect the worksheets.

1. Click the Tools menu

2. Select the Protection >Protect Sheet option >Protect Sheet window.

3. Select the appropriate option or both structural and Windows and assign the password.

You can also try the following:

4. Click the Tools menu.

Select the Protection; Protect Sheet… and sharing. Protect the shared workspace window. This allows you to share the book with the track changes.

5. Check the possibility to share with the changes. This allows the text box.
6. Assigning a password in the text box.

These password protections protect Excel spreadsheets at the time of sharing and restrict other users from making changes to the document at the time of transferring file from one pc to another.

  • Share/Bookmark

Finding right Microsoft Excel tutorials

Posted by cloud – April 21, 2009

If you are looking for the best tutorials for Microsoft Excel, which could improve their skills with this fantastic tool, then you want to read this article. A wide range of courses there, introducing the basis for excellence, more intermediate skills, such as keyboard shortcuts and formulas, and advanced modeling and complex analysis, macro and the automation. When you finish reading this article, you’ll have a better idea of what kind of Microsoft Excel tutorials available for your skill set and price range.

There are three types of tutorials available

1. Basic Microsoft Excel Tutorials
2. Intermediate Microsoft Excel and tutorials
3. Advanced Microsoft Excel Tutorial

1. Basic Microsoft Excel Tutorials

A basic tutorial for Excel starts the novice user to walk through all the functions available in the application and how to navigate the interface and menus. In addition to the navigation of the spreadsheet, work as an introduction to spreadsheets should also be included. A beginner should understand that the spreadsheet is made up of cells on a grid composed of rows and columns, and all cells in a spreadsheet can be trained to interact with each other through the introduction of formulas in the cells. Finally, a tutorial guides you through the basic input data and using simple formulas.

2. Intermediate Microsoft Excel Tutorial

Intermediate tutorial assumes you have already been established in the grounds of the application and knows how to open and create new files, navigate the menus and, in general, to find their place in the program. Intermediate skills to develop at this level may include saving features such as time using keyboard shortcuts. You can also wait to see how excel can be included into other application programs, such as the ability to paste from a spreadsheet into a Word document. In addition, the most advanced cellular functions should be introduced, such as against absolute references.

3. Advanced Microsoft Excel Tutorial

An advanced tutorial assumes the user is very familiar with Excel and has probably already been used extensively in their work. Most people who need the highest level of training in Excel are in accounting or finance fields, and use the tool for building complex models and advanced financial analysis. An advanced tutorial in depth examples of using the high level of excellence, such as Pivot Tables, advanced sorting and filtering, and automation of the spreadsheet using VBA and pivot tables.

If you are just starting to use Excel and want to know how to use quickly and efficiently, a tutorial of basic or intermediate is your best bet. More advanced users seeking to maximize computing power and analysis of this tool definitely want to find a tutorial way.

People can choose from the above discussed courses depending on their level of competence and they can define what type of course to begin.

  • Share/Bookmark

Microsoft excel secret revealed

Posted by cloud – April 6, 2009

Microsoft Excel training capacity Excel reveals that most people never imagined. The biggest thing to learn the details of this powerful training program in MS Excel is that you do not need to know something about programming languages or technologies to create such an interactive spreadsheet is automatically update information later.

This article has the surface of an ingenious Excel increased capacity has the potential to revolutionize the way their work – a Web query in Excel.

A web query Excel is fair to say that you quit Excel and retrieve the latest information on a website.

There is no complicated formula that takes hours to training in Microsoft Excel. It’s as simple navigation and a Web page and clicks the mouse. Really, just click on "data" from the dropdown menu in Excel, and then mouse over "import external data" and select "new query on the Web." This opens a window where you can navigate to the page where you want get information.

For a test, type "stock prices" and choose a page. You will notice a series of yellow arrows to the left of the data block that are not normally visible. Just click on the arrow in the block of data to import the entire table and is immediately imported into your Excel spreadsheet. Not only the data from the spreadsheet, each time that data on the website is updated, you can update the data by clicking on the red exclamation icon in the new Data Import "in the Toolbar. This little information taught in the training of Microsoft Excel, you can change your way of doing business and increase your productivity to new levels.

You can create a spreadsheet that compares the prices of its competitor’s ads next to yours. You can track the percentage variation between the prices advertised every day and adjust accordingly – to help "the hope of its competitors have been training through Microsoft Excel!

Most people are surprised by the power of Excel after taking a training course in Microsoft Excel. See how Microsoft Excel can completely change the way you do business.

  • Share/Bookmark