Microsoft Excel is one of the most useful tools for managing data, performing calculations, and organizing information. However, you don’t need to be an Excel expert to work faster. A few simple tricks can help you avoid repetitive tasks, organize data, and perform calculations in seconds. Here are 10 useful Microsoft Excel tricks for beginners, complete with practical examples you can try yourself.
1. Use Flash Fill to Automatically Complete Data
Have you ever needed to separate first names and last names from a list of full names? Instead of doing it manually, you can use Excel’s Flash Fill feature. This recognizes a pattern in your data and automatically fills the remaining cells to match it.
Suppose you have the following names in column A.
| A: Full Name | B: First Name |
|---|---|
| John Smith | John |
| Sarah Johnson | |
| David Wilson | |
| Emma Brown |
To extract the first names:
- Type “John” in cell B2.
- Select the column B’s header to select the entire column.
- Go to the “Data” tab and select “Flash Fill” option under “Data Tools” group. You can also use the keyboard shortcut Ctrl + E on Windows.
- Excel should automatically extract the first names from the remaining entries and fill the corresponding cells.

Flash Fill can recognize patterns for separating names, extracting numbers, combining text, and reformatting information.
2. Freeze Rows and Columns While Scrolling
When working with a large spreadsheet, you may scroll down and lose sight of the column headings. This can make it difficult to understand what each column represents. Excel’s Freeze Panes feature keeps selected rows or columns visible while you scroll.
Imagine you have a sales spreadsheet with hundreds of entries.
| Product | Quantity | Price | Total |
|---|---|---|---|
| Laptop | 2 | $800 | $1,600 |
| Keyboard | 5 | $30 | $150 |
| Mouse | 10 | $15 | $150 |
If you want the column headings to remain visible as you scroll down, simply go to “View” tab, click “Freeze Panes”, and select “Freeze Top Row” option. Now, the first row will remain visible as you scroll down. You can also freeze the first column by selecting “Freeze First Column”.

Note: If you want to freeze both a heading row and one or more columns, select the cell immediately below the rows and to the right of the columns you want to freeze. Then choose “View > Freeze Panes > Freeze Panes”. In the above example, click cell B2 and then freezing panes to freeze the first column and first row.
3. Use AutoSum to Calculate Totals Instantly
You don’t need to type a formula every time you want to add a column of numbers. Excel’s AutoSum feature can automatically identify a range of numbers and calculate their total. Suppose you want to calculate your monthly expenses.
| Expense | Amount |
|---|---|
| Rent | 1,200 |
| Groceries | 350 |
| Electricity | 100 |
| Internet | 50 |
| Total | ? |
To calculate the total:
- Click the cell below the last expense amount (B6 in our example).
- Go to the “Home” tab and click “AutoSum (Σ)”.
- Check that Excel has selected the correct range and press Enter.
- Excel will insert a
SUMformula and display the result.

For our example, the formula is =SUM(B2:B5) and the total is $1,700.
You can also use the keyboard shortcut Alt + = on Windows to insert AutoSum.
4. Highlight Important Data With Conditional Formatting
Conditional Formatting automatically changes the appearance of cells based on rules you define. It helps you identify important numbers without checking every entry individually. Suppose you have a list of student scores.
| Student | Score |
|---|---|
| Alex | 92 |
| Mia | 45 |
| Noah | 78 |
| Lily | 35 |
| Ethan | 88 |
Follow these steps if you want to highlight scores below 50 in red.
- Select your data under “Score” column.
- Open the “Home” tab, click “Conditional Formatting”, and select “Highlight Cells Rules”.
- Select “Less Than” option and enter 50 in the pop-up.
- Choose a formatting style like “Light Red Fill with Dark Red Text”.
- Click “OK” and Excel will automatically highlight scores below 50 in red color.

You can also use Conditional Formatting to identify duplicate values, highlight the highest numbers, display data bars, and create color scales.
5. Remove Duplicate Entries in Seconds
When working with large lists, the same name, email address, or product code may appear multiple times. Excel can remove duplicate entries automatically. For example, consider this customer list and you want each customer to appear only once.
| Customer Name |
|---|
| John |
| Sarah |
| John |
| David |
| Sarah |
| Emma |
Follow these steps:
- Select the column or table containing your data.
- Open the “Data” tab and click “Remove Duplicates” under “Data Tools” group.
- Select which columns Excel should check and click “OK”.
- Excel will remove duplicate records based on the columns you selected and report how many duplicates were removed.

For the example above, the resulting list will contain John, Sarah, David, and Emma.
Note: Remove Duplicates permanently removes duplicate rows from the selected data. Make a copy of your data first if you need to preserve the original list.
6. Use Ctrl + T to Turn Data Into a Table
Formatting data as an Excel table makes it easier to manage, filter, and analyze information. Instead of manually applying formatting and creating filters, you can turn a regular data range into a structured table. Let’s say, you maintain a list of products and their prices as shown below:
| Product | Category | Price |
|---|---|---|
| Laptop | Electronics | 800 |
| Chair | Furniture | 120 |
| Headphones | Electronics | 60 |
| Desk | Furniture | 250 |
To convert this data into a table:
- Click any cell inside your data and press Ctrl + T (in Windows version).
- Confirm the selected range and provide a name for your table.
- Check “My table has headers” if your first row contains column names.
- Click “OK” and your data will become a formatted Excel table.

The tabular data has lot of benefits like you can apply filter and sort data using the dropdown arrows in the column headings, expand the table easily when adding new rows, and use structured references in formulas.
7. Use IF to Make Excel Decisions Automatically
The IF function allows Excel to return different results depending on whether a condition is true or false. You can use it to classify scores, check payment status, identify sales targets, and much more. For example, suppose you want to determine whether students have passed or failed based on their scores with the following data with a score of 50 or higher is a pass.
| Student | Score | Result |
|---|---|---|
| Alex | 85 | |
| Mia | 42 | |
| Noah | 67 | |
| Lily | 38 |
Enter this formula in cell C2 (below the “Result” cell) and press Enter.
=IF(B2>=50,"Pass","Fail")
Excel will display “Pass” if the score in B2 is at least 50 and “Fail” otherwise. To apply the formula to the remaining students, drag the fill handle, the small square at the bottom-right corner of the selected cell, down the column.

You can also use IF for everyday tasks. For example, to check whether a payment has been completed:
=IF(B2="Paid","Completed","Pending")
This formula displays “Completed” when B2 contains “Paid” and “Pending” otherwise.
Note: Once you understand IF, you can combine it with other Excel functions to automate more complicated tasks.
8. Use Text to Columns to Split Data
Sometimes, information is stored in a single column even though you need it separated into multiple columns. Excel’s Text to Columns feature can split text based on a delimiter, such as a comma, space, or tab. Let’s say, column A contains the entries in your Excel sheet with full names and you want to separate first names and last names to Column B and Column C respectively.
| A: Full Name | B: First Name | C: Last Name |
|---|---|---|
| John Smith | ||
| Sarah Johnson | ||
| David Wilson |
Follow these steps:
- Select all full name cells under “A: First Name” column (from A2 to A4).
- Open the “Data” tab and click “Text to Columns”.
- Select “Delimited” and click “Next”.
- Select “Space” as the delimiter and click “Next”.
- Click the up arrow in the “Destination” box and select B2 to C4.
- Finally, click “Finish” and Excel will split each full name into separate columns.

You can also split data using commas, semicolons, and other delimiters.
9. Use Keyboard Shortcuts to Work Faster
Keyboard shortcuts allow you to perform common actions without repeatedly navigating Excel’s menus. Learning a few shortcuts can save time when editing spreadsheets. Here are 10 useful Excel shortcuts for beginners on Windows.
| Shortcut | What it Does |
|---|---|
| Ctrl + C | Copy selected cells |
| Ctrl + V | Paste copied content |
| Ctrl + Z | Undo the last action |
| Ctrl + S | Save the workbook |
| Ctrl + F | Find text or numbers |
| Ctrl + H | Find and replace |
| Ctrl + T | Create a table |
| Ctrl + E | Use Flash Fill |
| Ctrl + Shift + L | Turn filters on or off |
| Alt + = | Insert AutoSum |
Imagine you need to find the word “Laptop” in a spreadsheet containing hundreds of product records. Instead of scrolling through the entire sheet, press Ctrl + F, type “Laptop”, and press Enter to find the matching entries. You can use Ctrl + H if you want to replace every occurrence of one word with another.
Note: These are Windows shortcuts. Some shortcuts differ on Mac, and their behavior can depend on your keyboard layout and Excel version.
10. Learn Basic Excel Formulas
Once you are comfortable with the tricks above, learning a few basic formulas will make Excel even more useful.
| Formula | Purpose | Example |
|---|---|---|
| =SUM(A1:A10) | Adds numbers | Calculates total expenses |
| =AVERAGE(A1:A10) | Calculates the average | Finds the average score |
| =MAX(A1:A10) | Finds the largest value | Identifies the highest sale |
| =MIN(A1:A10) | Finds the smallest value | Identifies the lowest score |
| =COUNT(A1:A10) | Counts cells containing numbers | Counts recorded scores |
| =COUNTA(A1:A10) | Counts non-empty cells | Counts entries in a list |
For example, if cells A1 through A5 contain the numbers 10, 20, 30, 40, and 50, the formula =AVERAGE(A1:A5) returns 30. Remember that Excel formulas generally begin with an equals sign (=). The colon in a reference such as A1:A10 represents a range of cells from A1 through A10.
Final Thoughts
Microsoft Excel becomes much easier to use when you know a few practical shortcuts and features. You don’t need to memorize hundreds of formulas or understand advanced data analysis to get started. The best way to learn Excel is to practice with real examples. Create a small budget data, organize a product list, or track your monthly expenses. Try each trick on your own spreadsheet, and you’ll gradually discover how much time Excel can save you.





