Module 2: Creating and Formatting Worksheets

A workbook in Excel is essentially a file that can contain one or more worksheets. It's like a digital notebook where you can organize and manage various types of information. Workbooks have a file extension ".xlsx" and serve as containers for your data and calculations.

• Creating a New Workbook:

There are multiple ways to create a new workbook in Excel:

Using the Menu:

  - Go to the "File" tab in the Ribbon.

  - Select "New" and choose "Blank Workbook."

Keyboard Shortcut:

  - Press `Ctrl + N` to create a new workbook quickly.

Excel Startup:

  - Upon launching Excel, a new, blank workbook is automatically created.

• Navigating Rows, Columns, and Cells:

Understanding the grid structure of a worksheet is fundamental:

Rows and Columns:

  - Rows are numbered horizontally, and columns are labeled with letters vertically.

  - The intersection of a row and a column forms a cell.

Selecting Cells:

  - Click on a cell to select it.

  - Use the keyboard arrow keys for precise cell selection.

  - Click and drag to select a range of cells.

Moving Around:

  - The scroll bars allow you to navigate vertically and horizontally.

  - Utilize the sheet tabs at the bottom to switch between multiple worksheets.

• Inserting and Deleting Rows and Columns:

Being able to manipulate the structure of your worksheet is crucial:

Inserting Rows and Columns:

  - Right-click on a row or column header, then choose "Insert."

  - Use the "Insert" option in the Ribbon.

Deleting Rows and Columns:

  - Right-click on a row or column header, then choose "Delete."

  - Use the "Delete" option in the Ribbon.

• Practical Exercise:

Creating a New Workbook:

  - Open Excel and follow the steps to create a new workbook.

  - Experiment with the different methods mentioned.

Navigating Through Rows, Columns, and Cells:

  - Practice selecting cells and moving around the worksheet using the keyboard and mouse.

Inserting and Deleting Rows and Columns:

  - Insert a few rows and columns to see how it affects the structure.

  - Delete them and observe the changes.

• Homework:

Workbook Creation:

  - Create a new workbook with multiple worksheets.

  - Rename the sheets and explore their interactions.

Advanced Navigation:

  - Practice navigating through large datasets using keyboard shortcuts and sheet tabs.

• Key Takeaways:

- Workbooks are files containing one or more worksheets.

- Creating a New Workbook can be done via the menu, keyboard shortcut, or upon Excel startup.

- Navigating involves understanding rows, columns, cells, and utilizing scroll bars and sheet tabs.

- Inserting and Deleting Rows and Columns allows for dynamic adjustments to your worksheet's structure.