Basics

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. Share workbooks and import / export files.

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 Numbers: When we format numbers in Excel, we change the appearance of the number without changing the number itself.

5 Find and Replace: 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 Templates: Instead of creating an Excel workbook from scratch, you can create a workbook from a template. There are many free templates available, waiting to be used.

7 Data Validation: You can use data validation in Excel to make sure that users enter certain values into a cell. Drop-down lists in Excel are helpful if you want to be sure that users select an item from a list, instead of typing their own values.

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

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