Microsoft Excel Tips & Basic Formulas
Learn essential Excel formulas, formatting, rows and columns, sorting, filtering, shortcuts and practical spreadsheet tips.
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.
📚 Excel Tips – Quick Navigation
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.
Subtraction
Useful for calculating differences, balances and remaining amounts.
Multiplication
Useful for quantity × price calculations.
Division
Useful for calculating ratios, averages and unit values.
Percentage Calculation
Calculates 10% of the value in A1.
Calculates B1 as a percentage of A1.
SUM Function
Adds all values from A1 through A10.
AVERAGE Function
Calculates the average of the selected values.
MIN and MAX
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 |
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.
5. 🔍 Sorting & Filtering
```Sorting
Sorting helps organize data in ascending or descending order.
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.
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
```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:
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.
```© Social Media Point | Practical Excel & Technology Tips
