Excel Tips for Beginners: Shortcuts, Formatting, Basic Formulas, Tables, Sorting, Filters, Charts and Common Mistakes

Excel is one of the most useful skills for jobs, studies and personal finance. You do not need advanced formulas to benefit; a handful of habits and functions solve most everyday problems. This guide takes a beginner from the interface to charts, with examples you can try straight away.

Menu names and shortcuts below refer to desktop Excel for Windows. Mac and web versions differ slightly. Google Sheets works similarly for most items.

Know the basics

• A workbook is the file; it contains worksheets (tabs). Each sheet has columns (A, B, C) and rows (1, 2, 3). A cell such as B3 is where column B meets row 3.
• Type text, numbers or formulas in cells. A formula always begins with an equals sign: =A1+B1.
• Press Enter to confirm and move down, Tab to move right, Esc to cancel.
• Double-click the border between column headers to auto-fit the width.

Shortcuts that save hours

• Ctrl+C / Ctrl+V / Ctrl+X: copy, paste, cut.
• Ctrl+Z / Ctrl+Y: undo and redo.
• Ctrl+S: save. Save often, and consider AutoSave with cloud storage. See cloud storage comparison.
• Ctrl+Arrow keys: jump to the edge of data.
• Ctrl+Shift+Arrow: select to the edge of data.
• Ctrl+A: select all. Ctrl+Home: go to A1.
• Ctrl+T: convert a range into a table.
• F2: edit the active cell. F4: toggle absolute references while editing a formula, and repeat the last action otherwise.
• Alt+=: AutoSum.
• Ctrl+; inserts today date. Ctrl+Shift+: inserts the current time.
• Ctrl+1: open Format Cells.

Essential formulas

1. SUM: =SUM(B2:B10) adds a range.
2. AVERAGE: =AVERAGE(B2:B10). Try the average calculator to verify results.
3. MIN and MAX: lowest and highest values.
4. COUNT and COUNTA: count numbers, or non-empty cells.
5. IF: =IF(B2>=40,"Pass","Fail"). Useful for marks. See marks percentage calculator.
6. ROUND: =ROUND(B2,2) to control decimals.
7. Percentage: =B2/C2 formatted as a percentage. Check with the percentage calculator.
8. TODAY: returns the current date.

Absolute and relative references

When you copy a formula, relative references (A1) shift. Use dollar signs ($A$1) to lock a reference. Example: if the GST rate is in cell F1, a formula =B2*$F$1 can be copied down without the rate cell moving. Press F4 to add dollar signs quickly. You can compute taxes with the GST calculator to cross-check.

Formatting that makes data readable

• Use bold headers and a fill colour. Keep fonts consistent.
• Format numbers as currency, percent or date through Home > Number. In India you can display lakhs-style commas with a custom format for your region settings.
• Align numbers to the right and text to the left.
• Use borders sparingly. Avoid merging cells in data tables because it breaks sorting and filters.
• Wrap text for long labels.

Tables, sorting and filtering

1. Click inside your data and press Ctrl+T to create a table with headers.
2. Use the dropdown arrows to sort A to Z, smallest to largest or by colour.
3. Filter to show only the rows you need, such as one month or one category.
4. Tables expand automatically as you add rows and keep formulas consistent.

Keep data clean: one header row, no blank rows or columns inside the data, one type of data per column.

Freeze panes and printing

• View > Freeze Panes keeps headers visible as you scroll.
• Page Layout > Print Titles repeats header rows on each printed page.
• Use Page Break Preview and set orientation and scaling (fit to one page wide) before printing.

Data validation and conditional formatting

Data > Data Validation lets you restrict entries to a list, number range or date, preventing typos. Conditional Formatting highlights values automatically: for example, red for overdue payments or green for scores above a threshold. These make trackers and budgets much clearer.

Charts in minutes

1. Select your data including headers.
2. Insert > Recommended Charts, or choose column, line or pie.
3. Use column or bar charts for comparisons, line charts for trends, pie charts only for few categories.
4. Add a clear title and axis labels, remove clutter and keep colours simple.

Practical projects to practise

• Monthly budget: income, categories, totals and a savings percentage. See budgeting methods and the budget planner.
• Loan or SIP schedule: compare your formulas with the EMI calculator and SIP calculator.
• Study tracker or marks sheet with averages and grades.
• Expense sharing sheet for trips. See tip split calculator.

Common mistakes

1. Typing numbers as text (for example with spaces or apostrophes), so formulas ignore them.
2. Hardcoding numbers inside formulas instead of using cells.
3. Merging cells in data ranges.
4. Not saving versions. Keep a backup copy before big changes.
5. Ignoring errors such as #DIV/0! and #REF!. Use IFERROR sparingly, after you understand the cause.
6. Sorting only one column and breaking row relationships. Always select the whole table.

When you are comfortable, move on to advanced Excel formulas.

Frequently asked questions

What is the first Excel skill to learn?

Entering data cleanly and using SUM, AVERAGE and IF formulas.

What does F4 do in Excel?

It toggles absolute references in a formula and repeats the last action.

Why do I avoid merged cells in data?

They break sorting, filtering and formulas.

How do I keep headers visible?

Use View > Freeze Panes.

Is Google Sheets similar to Excel?

Yes, most basic formulas and shortcuts work similarly.

How do I fix numbers stored as text?

Convert them using Text to Columns or multiply by 1, after checking the format.

Last reviewed 8 November 2026. Rates, limits and rules change, so confirm figures with the official source before you act.