Basics

 

This section explains the basics of Excel.

1 Ribbon: Excel selects the ribbon's Home tab when you open it. Learn how to minimize and customize the ribbon.

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.

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.

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.