Learn excel the best way

Neha Bagri (CA FInal Year Student ) (148 Points)

28 February 2012  

Basics:

This section is for Excel users who have just started using Excel. It explains some Excel Basics.

 

1 Excel Workbook: A workbook is another word for your Excel file. Learn how to open a workbook, create a workbook from a template and view multiple workbooks at the same time.

2 Excel Worksheets: A worksheet (or spreadsheet) is a collection of cells where you keep and manipulate the data. This chapter teaches you how to select, rename, insert, move, delete and copy a worksheet.

3 Excel Ranges: A range in Excel is a collection of two or more cells. This chapter gives an overview of some very important range basics.

4 Format Excel Numbers: When we format numbers, we change the appearance of a number without changing the number itself.

5 Find & Replace in Excel: You can use Excel's find feature to quickly find specific text. You can use Excel's replace feature to quickly find specific text and replace it with other text.

6 Excel Cell Comments: You can add a comment to a cell to give feedback about the content of the cell.

7 Excel Data Validation: You can use data validation to make sure that users enter certain values into a cell.

8 Drop-down Lists in Excel: Drop-down lists are helpful if you want to be sure that users select an item from a list, instead of typing their own values.

9 Excel Calendar: Making a calendar in Excel is easy. Instead of creating your own calendar from scratch, you can create a calendar from a template.

10 Quick Access Toolbar: If you use an Excel command frequently, you can add it to the Quick Access Toolbar.

11 Printing in Excel: This chapter teaches you how to print the entire worksheet or just a selection and how to change some important print settings.

12 Keyboard Shortcuts: Keyboard shortcuts allow you to do things with your keyboard instead of your mouse to increase your speed.

13 Password Protection: This chapter teaches you how to password protect an Excel workbook or worksheet.