Microsoft Excel Level 1

Excel 1 Vocabulary

Tips and Tricks

Chapter 1 Creating and Navigating a Workbook .

Lesson 1-1 Opening, Saving, and Closing in excel

Lesson 1-2 Navigating an Excel workbook

Lesson 1-3 Entering data

Practice Creating your Excel Document.

Lesson 1-5 Moving and Copying Data – Practice Move, Copy, and Paste

Lesson 1-6 Select Cells, Rows, and Columns

Lesson 1-7 ADDING and deleting rows and columns

Practice Selecting Data, Adding and Deleting Rows and Columns

 Lesson 1-8 Using AutoFill  

Practice enter data, use auto fill and save as

Chapter 2 Sort and Filter.

Lesson 2-1 Sorting Data – Practice Sorting  

Lesson 2-2 Creating Filters- Practice Filtering

Lesson 2-3 Creating an Advanced Filter – Practice Advanced Filter

Chapter 3 Calculating Data

Lesson 3-1 Using Basic Formulas – Practice Add and Subtract Cells – Practice Multiply and Divide Cells

Lesson 3-3 Calculating with functions – Practice Calculating Functions

Lesson 3-4 Using Absolute and Relative References

Chapter 4 Formatting Cells

Lesson 4-1 Modifying Fonts – Practice Modifying Fonts

Lesson 4-2 Adding Borders and Colors to Cells.

 Lesson 4-3 Using the Format Painter – Practice Borders and Formatting

Lesson 4-4 Formatting Numbers – Practice Formatting Numbers

Lesson 4-5 Cell Alignment – Practice Text Alignment, Merge and Center

Lesson 4-6 Adjusting Column and Row Width –  Practice Column Width

Chapter 5 Workbook Management

Lesson 5-1 Excel Views

Lesson 5-2 Setting Page Breaks – Practice Page Breaks

 Lesson 5-3 Orientation

Lesson 5-4 Margins – Practice 5-4 Page Set Up

Lesson 5-5 Headers and Footers

Lesson 5-6 Freeze and Unfreeze Panes and Repeat Rows

 Lesson 5-7 Splitting a Worksheet – Practice Freezing pane and Splitting Worksheets

Lesson 5-8 Rename and remove sheets –  Practice Manipulating Worksheets

Lesson 5-9 Set Printing Options –  Practice Page Set up.