Basics of Excel 365 Part 2

1.5 Formatting Cells

Cell Formatting:

  • Font: Change the font style, size, and color.
  • Alignment: Align text within a cell (left, center, right).
  • Borders: Add borders to cells or ranges of cells.
  • Fill Color: Change the background color of cells.

Exercise:

  • Select cell A3.
  • Change the font to bold and the size to 12.
  • Change the text color to blue.
  • Select cells A3 and B3, then add a bottom border.
  • Fill cell B3 with a light yellow color.

1.6 Managing Worksheets

Working with Worksheets:

  • Adding a Worksheet: Click the “+” button next to the sheet tabs at the bottom.
  • Renaming a Worksheet: Double-click the sheet tab and type the new name.
  • Moving a Worksheet: Click and drag the sheet tab to a new position.
  • Deleting a Worksheet: Right-click the sheet tab and select “Delete”.

Exercise:

  • Add a new worksheet and name it “Data”.
  • Move the “Data” worksheet to the first position.
  • Delete the empty worksheet.

1.7 Basic Charts

Creating Charts:

  • Select Data: Highlight the data range you want to chart.
  • Insert Chart: Go to the “Insert” tab and choose a chart type (e.g., bar, line, pie).

Exercise:

  • In your current worksheet, select cells A3

    .

  • Go to the “Insert” tab and choose a “Column Chart”.
  • Customize the chart by adding titles and changing colors if desired.

1.8 Sorting and Filtering Data

Sorting Data:

  • Select the data range.
  • Go to the “Data” tab and choose “Sort A to Z” or “Sort Z to A”.

Filtering Data:

  • Select the data range.
  • Go to the “Data” tab and click “Filter”.
  • Use the drop-down arrows in the headers to filter the data.

Exercise:

  • Add more rows of names and ages under A4

    .

  • Sort the data by age in ascending order.
  • Apply a filter to show only rows where age is greater than 25.

1.9 Basic Data Analysis

Analyzing Data:

  • SUM: Add up a range of cells. Example: =SUM(B4:B10).
  • AVERAGE: Calculate the average of a range of cells. Example: =AVERAGE(B4:B10).
  • MIN/MAX: Find the smallest/largest value. Example: =MIN(B4:B10) or =MAX(B4:B10).

Exercise:

  • In cell B11, calculate the sum of the ages.
  • In cell B12, calculate the average age.
  • In cell B13, find the minimum age.
  • In cell B14, find the maximum age.

1.10 Saving and Sharing Workbooks

Saving Workbooks:

  • Go to “File” > “Save As”.
  • Choose a location and file format (e.g., .xlsx).

Sharing Workbooks:

  • Go to “File” > “Share”.
  • Choose an option to share via email, OneDrive, or other methods.

Exercise:

  • Save your workbook as “Excel_Practice.xlsx”.
  • Share the workbook with a friend or colleague via email or OneDrive.

This concludes the basic curriculum for MS365 Excel for beginners. Would you like to delve deeper into any of these topics, welcome to comment below🦌