Excel Tips | Basic formulas, formatting, rows/columns, sorting

Microsoft Excel Tips & Basic Formulas

Learn essential Excel formulas, formatting, rows and columns, sorting, filtering, shortcuts and practical spreadsheet tips.

Welcome to Social Media Point!

Microsoft Excel is one of the most useful tools for students, teachers, office staff, accountants, MIS professionals, data entry operators and small businesses. This guide covers practical Excel skills that can save time and reduce errors in daily work.

1. 🔢 Basic Excel Formulas

```

Excel formulas always begin with an equal sign =. Formulas allow you to calculate totals, averages, percentages, differences and many other values automatically.

Addition

Add two or more cells together.

=A1+B1
Example: If A1 contains 100 and B1 contains 50, the result will be 150.

Subtraction

=A1-B1

Useful for calculating differences, balances and remaining amounts.

Multiplication

=A1*B1

Useful for quantity × price calculations.

Division

=A1/B1

Useful for calculating ratios, averages and unit values.

Percentage Calculation

=A1*10%

Calculates 10% of the value in A1.

=(B1/A1)*100

Calculates B1 as a percentage of A1.

SUM Function

=SUM(A1:A10)

Adds all values from A1 through A10.

AVERAGE Function

=AVERAGE(A1:A10)

Calculates the average of the selected values.

MIN and MAX

=MIN(A1:A10)
=MAX(A1:A10)

MIN finds the smallest value and MAX finds the largest value.

```

2. 🧮 Important Excel Functions

```
Function Formula Purpose
SUM =SUM(A1:A10) Adds numbers
AVERAGE =AVERAGE(A1:A10) Calculates average
COUNT =COUNT(A1:A10) Counts numeric cells
COUNTA =COUNTA(A1:A10) Counts non-empty cells
MIN =MIN(A1:A10) Finds smallest value
MAX =MAX(A1:A10) Finds largest value
IF =IF(A1>50,"Pass","Fail") Returns a result based on a condition
SUMIF =SUMIF(A:A,"Paid",B:B) Adds values matching a condition
COUNTIF =COUNTIF(A:A,"Yes") Counts cells matching a condition
Tip: Start with SUM, AVERAGE, COUNT, IF, SUMIF and COUNTIF. These functions are extremely useful for everyday office and MIS work.
```

3. 🎨 Excel Formatting Tips

```

Good formatting makes a spreadsheet easier to read, understand, print and share.

Bold Headings

Use Ctrl + B on Windows or Command + B on Mac to make headings bold.

Number Formatting

Format numbers as currency, percentage, date, decimal or other appropriate formats.

Cell Alignment

Use left, center or right alignment depending on the type of information.

Borders

Use borders to separate tables and important sections. Avoid excessive borders.

Wrap Text

Use Wrap Text when a cell contains long sentences or headings.

Merge Carefully

Merge cells mainly for titles. Avoid excessive merging inside data tables because it can make sorting and filtering difficult.

Recommended Formatting Structure

Data Type Recommended Format
Name Text
Date DD-MMM-YYYY or another consistent date format
Amount Number/Currency
Percentage Percentage format
Quantity Number
```

4. 📊 Rows & Columns

```

Insert a Row

Right-click the row number and select Insert.

Insert a Column

Right-click the column letter and select Insert.

Delete Rows or Columns

Select the row or column, right-click and choose Delete.

Adjust Column Width

Double-click the boundary between column letters to automatically fit the content.

Adjust Row Height

Double-click the boundary between row numbers to automatically fit the content.

Freeze Top Row

When working with large datasets, use the Freeze Panes feature to keep column headings visible while scrolling.

Professional Tip: Keep one clear header row at the top of your database. Avoid blank rows inside the main data table.
```

5. 🔍 Sorting & Filtering

```

Sorting

Sorting helps organize data in ascending or descending order.

Example: A list of employees can be sorted alphabetically by name, by department, salary or joining date.

Common Sorting Options

  • A to Z — alphabetical order
  • Z to A — reverse alphabetical order
  • Smallest to Largest — numerical order
  • Largest to Smallest — reverse numerical order
  • Oldest to Newest — dates
  • Newest to Oldest — dates

Filtering

Filters allow you to display only the records you need without deleting other information.

Example: If a database contains 5,000 beneficiaries, you can filter the Department column to show only one department.

Important Filtering Tips

  • Always keep a clear header row.
  • Avoid blank rows within the dataset.
  • Use consistent spellings.
  • Check that dates are stored as actual dates.
  • Remove unnecessary duplicate records.
```

6. 📝 Excel Data Entry Tips

```

Use Consistent Names

Do not use different spellings for the same person, organization or location.

Use Data Validation

Create dropdown lists for fields such as Gender, Status, District, Province or Department.

Remove Duplicates

Use Excel's Remove Duplicates feature when appropriate, but always keep a backup of the original data.

Keep Backups

Save important work using meaningful file names and keep backup copies.

```

7. ⌨️ Useful Excel Keyboard Shortcuts

```
Action Windows Mac
Copy Ctrl + C Command + C
Paste Ctrl + V Command + V
Cut Ctrl + X Command + X
Undo Ctrl + Z Command + Z
Save Ctrl + S Command + S
Bold Ctrl + B Command + B
Find Ctrl + F Command + F
Select All Ctrl + A Command + A
```

8. ⚠️ Common Excel Mistakes to Avoid

```
1. Inconsistent Data: Avoid entering the same category with different spellings.
2. Too Many Merged Cells: Merged cells can cause problems when sorting and filtering.
3. No Backup: Always maintain a backup before making major changes to important datasets.
4. Hard-Coding Results: Where appropriate, use formulas instead of manually typing calculated results.
5. Unclear Headers: Every column should have a meaningful heading.
```

9. 🚀 Daily Excel Productivity Tips

```

Tip 1 — Convert Data into a Table

Excel Tables make filtering, formatting and managing datasets easier.

Tip 2 — Use Ctrl/Command + F

Quickly search for names, IDs, codes or other information instead of manually scrolling through thousands of rows.

Tip 3 — Use Autofill

Drag the fill handle to copy formulas, numbers, dates and patterns.

Tip 4 — Keep Raw Data Separate

Maintain the original/raw data separately from cleaned, analyzed or summarized data.

Tip 5 — Use Clear File Names

Instead of names such as Book1.xlsx, use names such as:

Beneficiary_Data_September_2026.xlsx

Tip 6 — Check Before Sharing

Before sending an Excel file, check formulas, spelling, filters, hidden rows, hidden columns and totals.

Tip 7 — Protect Important Sheets

Use worksheet protection when you want to prevent accidental changes to formulas or important cells.

```

📌 Excel Quick Reference

```
Task Formula / Feature Use
Total =SUM(A1:A10) Add values
Average =AVERAGE(A1:A10) Find average
Highest =MAX(A1:A10) Find maximum
Lowest =MIN(A1:A10) Find minimum
Count =COUNT(A1:A10) Count numbers
Conditional Result =IF(A1>50,"Pass","Fail") Apply condition
Sort Sort A–Z / Z–A Organize records
Filter AutoFilter Show selected records
```

🎯 Why Learn Excel?

```

Excel skills are valuable for office administration, accounting, finance, MIS, monitoring and evaluation, project management, education, business, research and data analysis.

Beginners should first master basic formulas, formatting, rows and columns, sorting, filtering and keyboard shortcuts. After that, you can move to advanced topics such as VLOOKUP/XLOOKUP, Pivot Tables, Conditional Formatting, Charts, Power Query and Excel Dashboards.

Social Media Point will continue providing practical technology and productivity tips to help students, professionals and office users improve their digital skills.

```
🏷️ Tags: Microsoft Excel Tips, Excel Formulas, Basic Excel Formulas, Excel Formatting, Excel Rows and Columns, Excel Sorting, Excel Filtering, Excel Shortcuts, Excel for Beginners, Excel Data Entry, Excel Functions, Excel Training, Microsoft Office Tips, Excel Tutorial, Social Media Point

© Social Media Point | Practical Excel & Technology Tips

Previous Post Next Post