Microsoft Excel
Introduction (Row, Column, Cell, Sheet):
Launch Microsoft Excel.
Excel documents consist of rows (numbered) and columns (lettered), creating cells at their intersections.
Each Excel file is called a "workbook" and contains multiple "sheets" (also known as tabs).
Merge & Center, Wrap Text, Border:
Select the cells you want to format.
Click on the "Merge & Center" button in the Home tab to merge selected cells and center the content.
To wrap text within a cell, select the cell(s) and click on "Wrap Text" in the Home tab.
To add borders, select cells, and choose "Border" options in the Home tab.
Insert & Delete (Row & Column):
To insert a row, right-click on a row number and select "Insert" or use the "Insert" command in the Home tab.
To insert a column, right-click on a column letter and select "Insert" or use the "Insert" command in the Home tab.
To delete a row or column, right-click on the row or column and choose "Delete" or use the "Delete" command in the Home tab.
Adjustment of Column Width & Row Height:
To adjust column width, place your cursor on the right edge of the column header until it turns into a double-headed arrow. Drag to resize.
To adjust row height, place your cursor on the bottom edge of the row header and drag to resize..
Increase/Decrease Decimal Number:
Select the cell(s) containing numbers.
Use the "Increase Decimal" or "Decrease Decimal" buttons in the Home tab to adjust decimal places.
AutoSum, Total, Average, Ranking:
Click on a cell where you want the result.
Use the "AutoSum" button in the Home tab to quickly calculate sum, average, count, or other functions.
You can also manually enter formulas (e.g., "=SUM(A1:A10)") for custom calculations.
To rank data, use the "RANK" function (e.g., "=RANK(A1, A1:A10)").
Sort & Filter:
Select the range of data you want to sort or filter.
Use the "Sort" and "Filter" buttons in the Data tab to organize and filter data based on specific criteria.
Charts:
Select the data you want to chart.
Go to the Insert tab and choose the type of chart you want to create (e.g., bar chart, pie chart).
Customize the chart using the Design and Format tabs.
Freeze Panes, Protect Sheet:
To freeze panes (keep rows/columns visible while scrolling), select the cell below/right of what you want to freeze.
Click on "View" and then "Freeze Panes" in the ribbon.
To protect a sheet, go to the Review tab and click on "Protect Sheet." Set a password if needed.
Print Setup, Page Setup, Mail Merge:
To set up printing options, go to the File tab and select Print.
Use Page Setup to adjust margins, orientation, and paper size.
For mail merge, use the "Mail Merge" feature in Word, which can connect to Excel for data.
Revision