Scribd
Upload
2 views2 pages

Excel Basic Tools Guide-1

This guide provides an overview of basic tools in Microsoft Excel for beginners, including the concepts of workbooks, worksheets, cells, rows, and columns. It covers essential formatting tools, basic formulas, sorting and filtering options, common shortcuts, and useful tools like AutoFill and Freeze Panes. The document serves as a foundational resource for new users to navigate and utilize Excel effectively.

Uploaded by

mglwinko27
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
2 views2 pages

Excel Basic Tools Guide-1

This guide provides an overview of basic tools in Microsoft Excel for beginners, including the concepts of workbooks, worksheets, cells, rows, and columns. It covers essential formatting tools, basic formulas, sorting and filtering options, common shortcuts, and useful tools like AutoFill and Freeze Panes. The document serves as a foundational resource for new users to navigate and utilize Excel effectively.

Uploaded by

mglwinko27
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Microsoft Excel – Basic Tools Guide

This short guide explains common basic tools used in Microsoft Excel for beginners.

1. Workbook and Worksheet


• A Workbook is the Excel file.

• Worksheets (Sheets) are the pages inside the workbook where you enter data.

2. Cells, Rows, and Columns


• A Cell is a single box where you type data (e.g., A1).

• Rows run horizontally and are numbered (1,2,3…).

• Columns run vertically and are labeled with letters (A,B,C…).

3. Basic Formatting Tools


• Font: Change text style and size.

• Bold, Italic, Underline.

• Cell color and text color.

• Alignment (left, center, right).

4. Basic Formulas
• SUM: Add numbers. Example: =SUM(A1:A5)

• AVERAGE: Calculate average value.

• COUNT: Count cells containing numbers.

• Basic math: =A1+A2, =A1-A2, =A1*A2, =A1/A2

5. Sorting and Filtering


• Sort: Arrange data A–Z or Z–A.

• Filter: Show only selected data in a table.

6. Common Shortcuts
• Ctrl + C: Copy

• Ctrl + V: Paste

• Ctrl + Z: Undo

• Ctrl + S: Save
7. Useful Tools
• AutoFill: Drag the corner of a cell to copy formulas or numbers.

• Table tool: Convert data into a structured table.

• Freeze Panes: Keep header rows visible when scrolling.

You might also like