Written by Shahzaib Ali

Excel Tips for Beginners

Excel is easy to start using.

You enter data into cells, add a few formulas, format the sheet, and you’re ready to go. But there’s a big difference between knowing how to enter information into Excel and actually knowing how to work efficiently with it.

The good news is that you don’t need to learn hundreds of advanced features.

A small collection of shortcuts, formulas, and spreadsheet habits can make everyday Excel work considerably faster and less error-prone.

Here are 10 useful tips worth learning if you’re just getting started.

Tip 1: Freeze Your Header Row

If you’re working with a spreadsheet that contains hundreds or thousands of rows, scrolling down can quickly become confusing.

Once the header disappears, you have to scroll back up repeatedly to remember what each column represents.

Freezing the header row solves this.

How to do it

1. Click the row immediately below your header row.
2. Go to View → Freeze Panes.
3. Select Freeze Panes.

Your header remains visible while you scroll through the data.

You can also freeze columns. If your first column contains names or IDs that you always want visible, select the column immediately to its right and use View → Freeze Panes → Freeze Panes.

It’s a small feature, but it makes large spreadsheets much easier to navigate.

Tip 2: Use Ctrl + Z Without Being Afraid to Experiment

One of the most useful keyboard shortcuts in Excel is also one of the simplest:

Ctrl + Z

It undoes your most recent action.

Accidentally deleted something? Undo it.

Changed formatting you didn’t intend to change? Undo it.

Pasted information into the wrong location? Undo it.

You can step backward through multiple recent actions, although the exact undo behavior and limits can vary depending on the operation and Excel environment.

There are exceptions. Certain actions, particularly some macro-related operations, may not behave like normal worksheet edits.

Still, for ordinary spreadsheet work, knowing that you can usually undo mistakes makes it much easier to experiment and learn.

Tip 3: Learn These Five Keyboard Shortcuts First

Excel has an enormous number of keyboard shortcuts. You don’t need to memorize all of them.

Start with these:

Ctrl + C / Ctrl + V

Copy and paste.

One Excel-specific detail is important: when you copy a formula, Excel normally adjusts its cell references based on the new location.

If you want to paste only the results rather than the formulas, use Paste Special → Values.

Ctrl + Arrow Keys

Jump to the edge of a contiguous data region.

For example, pressing Ctrl + Down Arrow can quickly take you to the bottom of a column of data.

Hold Shift while navigating to select the cells along the way.

Ctrl + Shift + End

Selects from your current cell to the last used cell in the worksheet.

This can be useful when working with a large dataset.

F2

Puts the selected cell into edit mode.

It’s especially useful when you need to make a small change to a formula without using the mouse.

Ctrl + Home / Ctrl + End

Ctrl + Home takes you toward the beginning of the worksheet, normally cell A1.

Ctrl + End takes you toward the last used cell.

These shortcuts are particularly useful when you’re working with large spreadsheets.

Tip 4: Understand Values, Formulas, and Cell References

A number typed directly into a cell is a value.

A formula such as:

=A1+B1

is an instruction that calculates a result.

This distinction becomes important when you copy formulas.

For example, if you enter:

=A2+B2

and copy it one row down, Excel normally changes it to:

=A3+B3

This is called a relative reference.

Sometimes, however, you need a reference to stay fixed.

That’s when absolute references are useful:

=$A$2

The dollar signs tell Excel not to adjust that reference when the formula is copied.

View formulas instead of results

You can also switch the worksheet into formula view with:

Ctrl + `

The backtick key is usually located near the top-left of the keyboard, below the Escape key.

Press the shortcut again to return to the normal view.

This is particularly helpful when you’re auditing a spreadsheet and want to understand how the calculations work.

Tip 5: Learn SUMIF, COUNTIF, and AVERAGEIF

SUM, AVERAGE, and COUNT are essential beginner formulas.

But their conditional versions are even more useful for many real-world spreadsheets.

SUMIF

Adds values that meet a condition.

=SUMIF(B2:B100, "North", C2:C100)

This adds the values in column C where the corresponding cell in column B contains “North.”

COUNTIF

Counts cells that meet a condition.

=COUNTIF(D2:D100, "Completed")

This counts how many cells in column D contain “Completed.”

AVERAGEIF

Calculates an average only for values that meet a specified condition.

These formulas are useful for reports, budgets, project tracking, sales data, and many other situations where you need calculations based on categories or statuses.

Instead of manually filtering a spreadsheet and counting the results, you can often let Excel perform the calculation automatically.

Tip 6: Format Your Data as a Table

If you’re working with a structured dataset, Format as Table is one of the most useful Excel features to learn.

Click inside your data and go to:

Home → Format as Table

Choose a style and confirm the data range and header settings.

An Excel Table provides several useful features:

• Filter buttons on headers
• Consistent formatting
• Automatic expansion when new rows are added
• Structured references
• Formulas that can automatically fill down a column

For example, instead of:

=SUM(C2:C100)

a table formula can reference the column by name, making the formula easier to understand.

Tables aren’t necessary for every spreadsheet, but they’re an excellent choice when you’re regularly sorting, filtering, calculating, or adding rows to structured data.

Tip 7: Use Conditional Formatting to Spot Patterns

Large columns of numbers can be difficult to scan.

Conditional formatting makes important values stand out automatically.

For example, you can select a range and use:

Home → Conditional Formatting → Color Scales

A color scale can help you quickly identify higher and lower values.

You can also create rules that highlight cells above or below a certain threshold.

For example:

Conditional Formatting → Highlight Cell Rules → Greater Than

Enter your threshold, choose the formatting, and Excel will automatically highlight values above that number.

Other useful applications include:

• Highlighting overdue dates
• Flagging values above budget
• Identifying duplicate entries
• Highlighting unusually high or low numbers
• Showing performance against a target

The major advantage is that the formatting updates when the underlying data changes.

Tip 8: Be Careful With Merged Cells

Merged cells can make spreadsheet headings look clean, but they’re usually a poor choice inside structured data.

Merging cells can interfere with:

• Sorting
• Filtering
• Selecting ranges
• Formula operations
• Data organization

If you need text to appear centered across several columns without actually merging the cells, Excel provides Center Across Selection.

To use it:

1. Select the cells.
2. Right-click and choose Format Cells.
3. Open the Alignment tab.
4. Set Horizontal alignment to Center Across Selection.

The text appears visually centered across the selected cells while the individual cells remain separate.

For structured datasets, keeping cells separate is generally much safer.

Tip 9: Understand VLOOKUP

VLOOKUP has a reputation for being complicated, but the basic concept is straightforward.

It looks for a value in the first column of a selected range and returns a related value from another column in the same row.

The basic syntax is:

=VLOOKUP(what_to_look_for, where_to_look, which_column_to_return, 0)

Suppose:

• Column A contains employee IDs
• Column B contains names
• Column D contains salaries

If cell A2 contains an employee ID and you want to find that employee’s salary, you could use:

=VLOOKUP(A2, Sheet1!A:D, 4, 0)

This means:

• Look for the value in A2
• Search columns A through D on Sheet1
• Return the value from the fourth column
• Use an exact match

The final 0 is important because it tells VLOOKUP to look for an exact match.

One important limitation

The lookup value must be in the leftmost column of the lookup range, and VLOOKUP can only return information from columns to its right.

If you need more flexibility, newer Excel versions support XLOOKUP, which can search in either direction and is often easier to use.

Tip 10: Save a Backup Before Major Changes

Undo is useful, but it shouldn’t be your only safety net.

Before making a major change to a spreadsheet—such as restructuring data, deleting large sections, or performing a significant sort—consider creating a separate copy first.

For example:

Client_Data_Backup.xlsx

If you’re using Microsoft 365 with OneDrive, AutoSave and version history can also provide additional protection, depending on your setup.

A separate backup is especially useful when you may not notice a mistake immediately. By the time you discover a problem, you may have already made many additional changes.

Creating a backup takes seconds and can save a lot of trouble later.

A Few Excel Habits Worth Building

Beyond individual features, a few habits can make your spreadsheets easier to manage.

Keep headers clear.
Use descriptive column names so you know what each field represents.

Avoid unnecessary formatting.
Formatting should make information easier to understand, not make the spreadsheet harder to maintain.

Use tables for structured data.
They make filtering, formulas, and expanding datasets easier.

Keep formulas understandable.
If a complicated formula becomes difficult to troubleshoot, consider breaking the calculation into smaller steps.

Use backups for important files.
Don’t rely entirely on memory or undo history when working with valuable data.

Final Verdict

You don’t need to become an Excel expert overnight.

Start with a few features that solve common problems: freeze your headers, learn essential shortcuts, understand relative and absolute references, use conditional formulas, format structured data as tables, and become comfortable with lookups.

Once those basics feel natural, you can move on to more advanced features such as XLOOKUP, PivotTables, Power Query, dynamic arrays, and more complex formulas.

The important part is to learn Excel around real problems.

Whenever you catch yourself repeatedly copying, filtering, counting, formatting, or reorganizing data manually, stop and ask whether Excel has a feature that can automate it.

Very often, it does.

Any Question? Contact Us