Scribd
Upload
8 views1 page

Excel Basics: Data Entry & Formatting Guide

Uploaded by

Suraj Kumar Raj
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
8 views1 page

Excel Basics: Data Entry & Formatting Guide

Uploaded by

Suraj Kumar Raj
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

Basic Operations in Microsoft Excel

This guide explains the fundamental operations in Excel, including data entry, editing, formatting
cells, and working with rows, columns, and ranges. It also includes a simple exercise for practice.

Data Entry and Editing


• Enter text, numbers, and dates into cells.
• Edit cell content by double-clicking or using the formula bar.
• Use AutoFill to quickly copy or extend data patterns.

Formatting Cells
• Change font style, size, and color.
• Apply number formats (currency, percentage, date).
• Use alignment options: left, center, right.
• Add borders and shading for better presentation.

Working with Rows and Columns


• Insert and delete rows or columns.
• Resize rows and columns by dragging the boundary.
• Hide or unhide rows and columns for better visibility.

Ranges
• Select multiple cells to create a range (e.g., A1:C10).
• Use ranges for applying formatting or formulas.
• Name ranges for easy reference in formulas.

Exercise
• Create a simple expense sheet:
• 1. Enter items and their costs in two columns.
• 2. Format the cost column as currency.
• 3. Apply bold formatting to headers.
• 4. Use SUM function to calculate total expenses.

You might also like