This section explains the basics of Excel. It is good to know the basic terminology explained in this section before you start using Excel.
1 Ribbon: Excel selects the ribbon's Home tab when you open it. Learn how to minimize and customize the ribbon. Also, find out how to add a command to the Quick Access Toolbar.
2 Workbook: A workbook is another word for your Excel file. Excel automatically creates a blank workbook when you open it.
3 Worksheets: A worksheet is a collection of cells where you keep and manipulate the data. By default, each Excel workbook contains three worksheets.
4 Format Cells: When we format cells in Excel, we change the appearance of a number without changing the number itself. We can apply a number format (0.8, $0.80, 80%, etc) or other formatting (alignment, font, border, etc).
5 Find & Select: Learn how to use Excel's Find, Replace and Go To Special feature.
6 Templates: Instead of creating an Excel workbook from scratch, you can create a workbook based on a template. There are many free templates available, waiting to be used.
7 Data Validation: Use data validation in Excel to make sure that users enter certain values into a cell. Also, learn how to create drop-down lists in Excel.
8 Keyboard Shortcuts: Keyboard shortcuts allow you to do things with your keyboard instead of your mouse to increase your speed.
9 Print: This chapter teaches you how to print a worksheet and how to change some important print settings in Excel.
10 Share: Learn how to share Excel data with Word documents and other files.
11 Protect: Encrypt an Excel file with a password so that it requires a password to open it. You can also protect the workbook structure and windows, worksheets and cells.