1. Getting to know Excel

2 Topics | 1 Quiz
2. Working with Cells

3 Topics | 1 Quiz
3. Modifying Columns, Rows, and Cells

2 Topics | 1 Quiz
4. Formatting Cell

5 Topics | 1 Quiz
5. Understanding Number format in Excel

5 Topics | 1 Quiz
6. Using Find & Replace

2 Topics | 1 Quiz
7. Formulas and Functions

6 Topics | 1 Quiz
On the home tab of the ribbon, you’ll find a menu of build-in number formats. Below this menu to the right, there is small button to access all number formats, including custom formats:

This button opens the Format Cells dialog box. You’ll find a complete list of number formats, organized by category, on the Number tab:

*Note: you can open Format Cells dialog box with the keyboard shortcut Control + 1.*