Using Microsoft Excel
Microsoft Excel is a spreadsheet application used to organize, analyze, and visualize data.
Creating a New Spreadsheet
- Open Microsoft Excel.
- Click Blank Workbook to start a new spreadsheet.
Basic Features
- Entering Data:
- Click on a cell and type to enter data.
- Press Enter to move to the next cell.
- Saving a Spreadsheet:
- Click File > Save As.
- Choose a location and name your file.
- Formatting Cells:
- Use the toolbar to change font, size, and color.
- Apply borders and background colors to cells.
Using Formulas
Formulas perform calculations on data:
- Addition:
=A1 + B1 - Average:
=AVERAGE(A1:A5) - Sum:
=SUM(A1:A5)
Creating Charts
- Select the data you want to visualize.
- Click Insert > Chart and choose a chart type.