How to Use Microsoft Excel: Complete Beginner’s Guide (60+ Practical Tips)

Microsoft Excel is a spreadsheet program for storing organized information, performing calculations, building budgets and trackers, analyzing data, and presenting results in tables and charts. The fastest way to learn it is not to memorize the entire Ribbon. Create one small workbook, enter clean data, convert it to a table, add formulas, filter and validate the entries, then build a chart and a PivotTable.

By the end, you will be able to create a clean sales-style spreadsheet that also demonstrates household budgets, expense trackers, inventory lists, and project plans: a named Excel table with formulas, appropriate number formats, a drop-down list, conditional formatting, a chart, and a simple PivotTable. You will also know how to save, share, print, protect, recover, and troubleshoot it.

#	Preview	Product	Price
1		Logitech M185 Compact Ambidextrous Wireless Mouse with Rubber Grips - Blue	$14.99	Buy on Amazon
2		Logitech M240 Compact Silent Bluetooth Wireless Mouse - Graphite	$21.99	Buy on Amazon
3		Afaartcci Rechargeable Wireless Mouse, Silent Bluetooth Mouse (Black)	$5.99	Buy on Amazon
4		Logitech M510 Full Size Ambidextrous 2.4 GHz Wireless Mouse	$27.99	Buy on Amazon
5		Acer Wireless Mouse for Laptop, 2.4GHz Computer Mouse 3 Adjustable 1600 DPI	$9.98	Buy on Amazon

1. What Excel is—and when to use it

A spreadsheet is a grid in which information is arranged in rows and columns. Each intersection can hold text, a number, a date, or a formula. Excel adds tools for calculations, sorting, filtering, data entry controls, charts, PivotTables, importing, collaboration, and automation.

Excel is a good fit for a household budget, savings tracker, debt-payoff schedule, invoice list, sales report, inventory, school gradebook, project tracker, calendar, or one-off analysis. It is especially useful when you need to change an input and see related results update immediately.

#1 Best Overall

Sale

Logitech M185 Compact Ambidextrous Wireless Mouse with Rubber Grips - Blue

• Compact Mouse: With a comfortable and contoured shape, this Logitech ambidextrous wireless mouse feels great in either right or left hand and is far superior to a touchpad
• Durable and Reliable: This USB wireless mouse features a line-by-line scroll wheel, up to 1 year of battery life (2) thanks to a smart sleep mode function, and comes with the included AA battery
• Universal Compatibility: Your Logitech mouse works with your Windows PC, Mac, or laptop, so no matter what type of computer you own today or buy tomorrow your mouse will be compatible
• Plug and Play Simplicity: Just plug in the tiny nano USB receiver and start working in seconds with a strong, reliable connection to your wireless computer mouse up to 33 feet / 10 m (5)
• Better than touchpad: Get more done by adding M185 to your laptop; according to a recent study, laptop users who chose this mouse over a touchpad were 50% more productive (3) and worked 30% faster (4)

$14.99

Buy on Amazon

Excel is not automatically the best choice for a large relational database, a multi-user transaction system, highly regulated records requiring a detailed audit trail, or a workflow built primarily around approvals, dependencies, notifications, and ownership. A database or dedicated business application may handle permissions, concurrent updates, relationships, and transaction integrity better. Excel worksheets also have official limits of 1,048,576 rows and 16,384 columns, with the last column named XFD; a cell can contain up to 32,767 characters. Those limits are boundaries, not a recommendation to put every record into one sheet. See Microsoft’s Excel specifications and limits.

Microsoft 365, Excel 2024, web, and mobile

Excel for the web can be useful without an installed desktop application, but saying simply that Excel is free is misleading: browser access, desktop licensing, subscription features, and mobile capabilities differ by account and plan. For financial workbooks containing sensitive information, also consider where the file is stored and who has access.

2. Excel vocabulary in five minutes

The selected cell is called the active cell. The Formula Bar shows the cell’s underlying entry: the cell may display 101.50, while the Formula Bar shows a formula such as =[@Units]*[@[Unit Price]].

3. Create and save your first workbook

1. Open Excel and select File > New > Blank workbook, or choose a template for a budget, invoice, schedule, or tracker.
2. Rename the file immediately. Choose File > Save As and use a descriptive name such as 2026_Sales_Tracker.xlsx or Household_Budget_2026.xlsx.
3. Choose a location. A local folder gives you direct offline control. OneDrive, OneDrive for Business, or SharePoint makes version history and co-authoring easier.
4. Rename the first sheet by double-clicking its tab or using its tab menu. Names such as Raw Data, Lists, Summary, and Charts are more useful than Sheet1.
5. Save again after the first meaningful change. During learning, saving a copy before a major cleanup, deletion, or redesign is a good habit.

Choose the right file format

Microsoft documents the formats Excel supports and warns that saving in another format can cause data, formatting, or feature loss. Use .xlsx unless macros require .xlsm. Never enable macros merely to view a workbook; enable them only when the source is trusted and the functionality is necessary. See Microsoft’s file-format guide and macro-security guidance.

AutoSave is helpful, but not a substitute for judgment

For Microsoft 365 files saved to OneDrive, OneDrive for Business, or SharePoint, AutoSave may save changes every few seconds. That is excellent for collaboration and crash recovery, but it also means a temporary filter, an accidental deletion, or a dashboard experiment can be saved immediately. Use File > Info > Version History to inspect or restore earlier cloud versions, or use Save a Copy before a risky structural change. Microsoft explains the behavior of AutoSave and Version History.

4. Build the practice workbook

Use this small sales list as a learning project. The same structure works for expenses: Date, Category, Payee, Description, Quantity, Unit Cost, and Amount. Enter the headings in row 1 and each sale in its own row.

The expected total Revenue is $101.50. East contributes $69.00, West contributes $32.50, and the average sale is approximately $33.83.

5. Enter data that Excel can understand

Good spreadsheet design prevents many formula, sorting, chart, and PivotTable problems. Follow this simple data model:

• Use one header row.
• Put one complete record in each row.
• Put one variable or field in each column.
• Keep dates in a date column, amounts in a numeric column, and identifiers in their own column.
• Avoid blank rows and blank columns inside the data set.
• Do not put subtotals, titles, decorative notes, or merged cells inside raw data.
• Store categories such as Region, Status, or Priority in columns instead of communicating them only through color.
• As a workbook grows, separate Raw Data, Lists, calculations, and report sheets.

Microsoft’s guidelines for organizing worksheet data recommend a clean, contiguous range and tables for related data.

Convert the list into a table

1. Click any cell in the practice data.
2. Press Ctrl+T on Windows, or use Insert > Table.
3. Confirm My table has headers, then select OK.
4. With the table selected, open Table Design > Table Name and change Table1 to tblSales.

An Excel table is not merely a colored range. It gives you filter buttons, automatic expansion when you type beneath it, calculated columns, a Total Row, and readable structured references such as =SUM(tblSales[Revenue]). Those features make tables particularly useful for recurring budgets and trackers. Microsoft’s guides cover creating and formatting tables and structured references.

Rank #2

Logitech M240 Compact Silent Bluetooth Wireless Mouse - Graphite

• Pair and Play: With fast, easy Bluetooth wireless technology, you’re connected in seconds to this quiet cordless mouse —no dongle or port required
• Less Noise, More Focus: Silent mouse with 90% reduced click sound and the same click feel, eliminating noise and distractions for you and others around you (1)
• Long-Lasting Battery Life: Up to 18-month battery life with an energy-efficient auto sleep feature, so you can go longer between battery changes (2)
• Comfortable, Travel-Friendly Design: Small enough to toss in a bag; this slim and ambidextrous portable compact mouse guides either your right or left hand into a natural position
• Long-Range: Reliable, long-range Bluetooth wireless mouse works up to 10m/33 feet away from your computer (3)

$21.99

Buy on Amazon

6. Format without damaging the data

Formatting normally changes how a value is displayed, not the underlying value. Use the number format that matches the meaning of the field:

• General: Excel’s default interpretation.
• Number: quantities or measurements, often with thousands separators and selected decimal places.
• Currency or Accounting: money such as Unit Price, Revenue, or an expense amount.
• Percentage: rates such as savings percentage or interest rate.
• Date and Time: calendar dates and times.
• Text: identifiers that must remain exactly as entered.

Select a range and use the Number group on the Home tab, or press Ctrl+1 to open Format Cells. Use Home > Format Painter to reuse a format. Double-click the boundary between two column headings to AutoFit a column; this often fixes ##### caused by a column being too narrow. Use Wrap Text for long headers and adjust row height when needed.

Excel commonly stores dates as sequential serial values. A date can display as Jan-26, 1/5/2026, or January 5, 2026 while remaining a date value that can be sorted and used in arithmetic. A date-looking text string may not behave the same way. See Microsoft’s explanation of date systems and formatting.

For ZIP codes, employee IDs, account numbers, and SKUs that begin with zeros, format the cells as Text before entering the values, or use a carefully chosen custom format. A value such as 00127 may otherwise be converted to 127.

7. Formulas: Excel’s calculation language

Every formula begins with =. Excel uses + for addition, - for subtraction, * for multiplication, / for division, and ^ for powers. Parentheses control the order of calculation.

=A2+B2
=A2*B2
=(A2+B2)/C2

A reference can point to one cell, a range, or another sheet:

• A1 refers to one cell.
• B2:B10 refers to a vertical range.
• Sheet2!A1 refers to cell A1 on Sheet2.

Your first calculated column

In the Revenue column of tblSales, enter:

=[@Units]*[@[Unit Price]]

Excel fills the table’s calculated column automatically. For a normal range, the equivalent first-row formula is:

=E2*F2

Copy it down with the fill handle—the small square at the lower-right corner of the selected cell—or double-click the fill handle when adjacent data provides a continuous range.

Relative, absolute, and mixed references

Relative references change when a formula is copied. =E2*F2 becomes =E3*F3 one row lower. Absolute references use dollar signs and remain fixed:

=E2*$H$1

Here, $H$1 might contain a tax rate or commission rate that every row should use. Mixed references lock only one dimension: $A1 locks column A but allows the row to change, while A$1 locks row 1 but allows the column to change. Microsoft’s formula overview explains these reference types.

Rank #3

Afaartcci Rechargeable Wireless Mouse, Silent Bluetooth Mouse (Black)

• 【Dual Mode Wireless Bluetooth Mouse】: Switch easily between two devices—connect one via Bluetooth (BT5.2/3.0) and the other using a 2.4G USB receiver. No drivers needed; just plug and play. Enjoy a reliable connection up to 33 feet. Note: You can't use both modes simultaneously; the USB receiver is stored in the mouse.
• 【Rechargeable Wireless Mouse】: Equipped with a 500mAh lithium-ion battery, it charges in 2 hours for over 7 days of use and 30 days on standby. The mouse sleeps after 5 minutes of inactivity to save power and can be woken with any click.
• 【Colorful LED Breathing Light】: Features 7 colorful LED lights that change randomly, adding a fun atmosphere to your workspace.
• 【Portable Mouse】Compact size (4.4 x 2.3 x 1.1 inches) makes it easy to fit in your laptop bag. Lightweight and ergonomic, it's perfect for travel. Contact us anytime for support.
• 【Wide Compatibility】: Works with laptops, PCs, tablets, and smartphones across various operating systems, including Android, Windows, and Mac. Ideal for home, office, and travel.

$5.99

Buy on Amazon

Beginner functions worth learning

Microsoft’s function catalog includes these and more. Current Excel versions also feature functions such as LET, TEXTBEFORE, FILTER, and UNIQUE.

XLOOKUP versus VLOOKUP

For a lookup demonstration, create a second table named tblProducts with columns SKU, Product, and Price. Then use:

=XLOOKUP(H2,tblProducts[SKU],tblProducts[Price],"Not found")

XLOOKUP can return a value from a column to either side of the lookup column and uses exact matching by default. It is preferable for new workbooks when compatibility allows, but Microsoft notes that it is not natively available in Excel 2016 or Excel 2019. A compatibility formula is:

=VLOOKUP(H2,A2:D100,4,FALSE)

In that older formula, FALSE requests an exact match. See Microsoft’s documentation for XLOOKUP and VLOOKUP.

Dynamic-array formulas and the #SPILL! error

FILTER, SORT, and UNIQUE can return multiple cells from one formula. Excel calls the output area the spill range. If any cell in that area contains data, the formula returns #SPILL!. Clear the blocking cells or move the formula to an empty area. Do not place a spilling formula inside an Excel table’s data body unless the version and design specifically support what you are trying to do.

8. Sort, filter, validate, and highlight data

Sorting and filtering

Use the filter arrows in the table headers to show only East-region records, products containing a word, dates in a selected period, or Revenue above a threshold. Filtering hides records; it does not delete them. To sort several levels, choose Data > Sort > Add Level, such as Region, then Salesperson, then Date. Excel supports up to 64 sort columns in one operation.

Mixed text and numbers, blank rows, and numbers stored as text can produce surprising sort orders. Standardize the column, remove unintended blank separators, and use a table. See Microsoft’s sorting and filtering guidance.

Drop-down lists with Data Validation

1. Create a Lists sheet containing approved values such as East, West, and Central, or values such as Planned, In progress, and Complete.
2. Select the cells where users will enter the value.
3. Choose Data > Data Validation.
4. Set Allow to List, then select or enter the source values.
5. Add an input message and an error alert where useful.

Use a table or a named range for the source list so adding an item can update the choices. Data Validation improves consistency but is not a complete security barrier: some copy-and-paste operations can bypass validation behavior. Review imported and pasted data. Microsoft’s instructions cover drop-down lists and Data Validation limitations.

Conditional formatting

Select the Revenue column and use Home > Conditional Formatting to highlight values below $50, duplicates, dates due soon, or unusually large transactions. You can use:

• Highlight Cells Rules, such as greater than or less than.
• Duplicate Values.
• Color Scales for a range of values.
• Data Bars for a quick magnitude comparison.
• Icon Sets for status or performance indicators.
• A formula-based rule such as =$B2="East" to format an entire record when its Region is East.

Use color as a visual aid rather than the only way to communicate meaning. Include the underlying Status, Region, or Priority field so the workbook remains understandable when printed, viewed by someone with color-vision limitations, or read by assistive technology.

Rank #4

Logitech M510 Full Size Ambidextrous 2.4 GHz Wireless Mouse

• Your hand can relax in comfort hour after hour with this ergonomically designed mouse. Its contoured shape with soft rubber grips, gently curved sides and broad palm area give you the support you need for effortless control all day long.
• You’ve got the control to do more, faster. Flipping through photo albums and Web pages is a breeze, especially for right-handers—with three standard buttons plus Back/Forward buttons that you can also program to switch applications, go full screen and more. And side-to-side scrolling plus zoom gives you the power to scroll horizontally and vertically through your music library, maps and Facebook feeds, and zoom in and out of photos and budget spreadsheets with a click.* * Requires Logitech SetPoint software (Windows) or Logitech Control Center software (Mac OS X)
• Two years of battery life practically eliminates the need to replace batteries. ** The On/Off switch helps conserve power, smart sleep mode extends battery life and an indicator light eliminates surprises. ** Battery life may vary based on user and computing conditions.
• The tiny Logitech Unifying receiver stays in your laptop. There’s no need to unplug it when you move around, so there’s less worry of it being lost. And you can easily add compatible wireless mice and keyboards to the same wireless receiver.

$27.99

Buy on Amazon

9. Create a useful chart

A normal chart visualizes selected worksheet data. A PivotTable summarizes data first; a PivotChart visualizes that summary. A chart should answer a question—such as Which product generated the most revenue?—rather than decorate the sheet.

1. Click inside tblSales, or select the Product and Revenue columns for a simple product comparison.
2. Choose Insert > Recommended Charts.
3. Preview the suggested column, bar, or line charts and select OK.
4. Give it a meaningful title, such as Revenue by Product.
5. Check that the product names are the category labels and Revenue is the data series.
6. Add axis titles when the audience may not know the units. Remove unnecessary decoration and verify the chart after filtering or adding rows.

For the practice table, a column chart of Product versus Revenue is a reasonable comparison. A line chart of Date versus Revenue is useful for a time trend once you have more dates. For only three precise values, the table may be clearer than either chart. Microsoft’s chart guide provides the current creation path.

10. Create a PivotTable summary

Use formulas when you need calculations tied to individual rows or dashboard cells. Use a PivotTable when you want a quick summary by categories and measures.

1. Click inside the clean tblSales table.
2. Choose Insert > PivotTable and select New Worksheet.
3. In the PivotTable Fields pane, drag Region to Rows.
4. Drag Revenue to Values. Excel should summarize it by Sum.
5. Drag Product to Columns or Filters to compare categories.
6. Format the values as currency and give the report a clear title.
7. After changing source data, select the PivotTable and choose Refresh.

For the sample, the PivotTable can show East at $69.00 and West at $32.50. If the source is a fixed range, new rows may not be included; using a table as the source helps the source expand, but the PivotTable can still require a refresh. Microsoft’s PivotTable instructions explain the field layout.

11. Navigation, shortcuts, printing, and sharing

Navigation and view

• Use the Name Box, to the left of the Formula Bar, to jump to a cell or range. Type A500 and press Enter.
• Use Ctrl+F to find and Ctrl+H to replace. Review the search scope—current sheet, workbook, formulas, values, notes, or comments—before choosing Replace All.
• Use Ctrl+Z before manually repairing an accidental deletion or overwritten formula. Excel documents up to 100 undo levels under its stated limits.
• Freeze headers in a long list. Select A2 and choose View > Freeze Panes > Freeze Panes to freeze the top row. Select B2 to freeze the top row and first column together.
• Rename and reorder worksheet tabs by dragging them or using the tab menu. Hide rows or columns when appropriate, but do not hide important assumptions without documenting them.
• Keep the Formula Bar visible while learning. The grid shows the result; the Formula Bar shows the formula or original entry.

Essential Windows and Mac shortcuts

Mac function-key settings, browser shortcuts, language settings, and Excel versions can change the exact keystroke. Use Microsoft’s current Excel shortcut reference when a shortcut does not work.

Print and export a readable result

1. Select the relevant area and use Page Layout > Print Area > Set Print Area when you do not want to print the entire sheet.
2. Use Page Layout > Orientation to choose Portrait or Landscape.
3. Open Page Layout > Page Setup > Scaling > Fit to to fit the width or height to a specified number of pages.
4. Use print preview through File > Print. Check margins, page breaks, headers, and whether row labels repeat on later pages.
5. Export to PDF when the recipient needs a fixed, presentation-ready copy rather than an editable workbook.

Fitting a very large worksheet onto one page can make the text unreadably small. It is usually better to fit the width to one page while allowing multiple pages vertically. Microsoft documents fit-to-page scaling and Page Setup.

Share and co-author safely

For simultaneous editing, save a supported modern workbook such as .xlsx, .xlsm, or .xlsb to OneDrive, OneDrive for Business, or SharePoint Online. Select Share, choose View or Edit permissions, and send the link. Legacy .xls and some special formats are not suitable for modern co-authoring. See Microsoft’s co-authoring requirements.

Use threaded Comments for discussions and replies. Use Notes for static annotations or reminders. Before sharing, run Review > Check Accessibility. Fix missing headers, poor contrast, missing alternative text, meaningless sheet names, and layouts that rely only on color. Microsoft lists Excel accessibility practices.

Protection is not the same as security

Worksheet protection can prevent ordinary editing of locked cells, but Microsoft says it is not intended to secure sensitive information. For confidential financial records, use appropriate file permissions and, where available, file-level encryption with a strong password. Do not distribute a workbook containing sensitive data simply because the worksheet is protected. See Microsoft’s worksheet-protection guide and Excel protection and security guidance.

12. 62 practical Excel tips

Use these as a compact checklist while building your own workbook.

Best Value

Sale

Acer Wireless Mouse for Laptop, 2.4GHz Computer Mouse 3 Adjustable 1600 DPI

• 【Plug and Play for Home/Office/School】The wireless computer mouse features 2.4GHz connectivity, delivering a stable, interference-free connection up to 32ft. Designed for 𝐦𝐞𝐝𝐢𝐮𝐦 𝐭𝐨 𝐥𝐚𝐫𝐠𝐞 𝐬𝐢𝐳𝐞𝐝 𝐡𝐚𝐧𝐝𝐬, it ensures comfortable use all day. Simply plug in the USB-A receiver for instant pairing—no drivers needed. 📌📌 If the mouse isn’t suitable, place the USB receiver in the battery compartment and return both.
• 【3 Levels Adjustable DPI】This travel USB mouse offers 3 adjustable DPI settings (800, 1200, 1600), allowing you to customize sensitivity for precise design work. Effortlessly switch to match your task and elevate your productivity. 📌 Please remove the film at the bottom of the mouse before use.
• 【Effortless Browsing】Equipped with forward and backward buttons, this computer mice streamlines your workflow, making it easy to navigate through web pages and files with a simple click. 📌Side button does not work on Mac.
• 【Visible Indicator Light】 The pc mouse features a visual indicator for DPI levels and low battery alerts. The red light flashes once for 800 DPI, twice for 1200 DPI, and three times for 1600 DPI. When the battery level is below 10%, the light flashes red until the mouse is completely out of power.
• 【Click to Wake】With smart sleep mode, it saves power by standby after 10 inactive minutes, just 2-3 clicks to wake. This efficient design delivers 3x longer battery life than motion-wake mice. Engineered for durability, its buttons and scroll wheel are tested for 10 million clicks, ensuring long-term reliability and consistent performance.

$9.98

Buy on Amazon

Getting started and navigation

1. Start with a blank workbook or template. Choose File > New > Blank workbook, or choose a budget, schedule, invoice, or tracker template.
2. Rename the workbook immediately. Use 2026_Sales_Tracker.xlsx, not Book1.xlsx.
3. Rename worksheet tabs by purpose. Use Raw Data, Lists, Summary, and Charts.
4. Use the Name Box to jump. Type A500 in the box left of the Formula Bar and press Enter.
5. Use Find and Replace. Press Ctrl+F to find and Ctrl+H to replace, after checking the scope.
6. Use Undo first. Press Ctrl+Z before trying to reconstruct a deleted row, column, or formula.
7. Keep the Formula Bar visible. It shows the underlying formula or value rather than only the displayed result.
8. Freeze headers early. Select A2 for the top row or B2 for the top row and first column, then choose View > Freeze Panes.
9. Use Ctrl+1 for Format Cells. It is faster than hunting through Ribbon groups.
10. AutoFit columns. Double-click the boundary between column headings when text is cut off or you see #####.

Entering and cleaning data

11. Use one header row and one record per row. Keep titles, subtotals, blank separators, and merged cells outside the raw data.
12. Turn raw data into a table with Ctrl+T. Confirm that the first row contains headers.
13. Give tables meaningful names. Rename Table1 to tblSales or tblExpenses.
14. Do not use color as your only category. Store Status, Region, or Priority in a field.
15. Format identifiers as Text before entry. Preserve leading zeros in ZIP codes, employee IDs, SKUs, and account numbers.
16. Use real dates. Date values sort and calculate correctly; date-looking text may not.
17. Check that numbers are numbers. Numbers stored as text can sort incorrectly and fail in calculations. Try the warning icon, VALUE, or Text to Columns.
18. Back up before removing duplicates. Data > Remove Duplicates deletes duplicate records from the selected range.
19. Use TRIM for imported text. =TRIM(A2) removes unwanted extra spaces.
20. Use Find and Replace carefully. Review the result on a copy before selecting Replace All.

Formatting

21. Format by meaning. Use Currency for money, Percentage for rates, Date for dates, and Text for identifiers.
22. Keep numeric values numeric. Apply currency and percent formats instead of typing inconsistent symbols into cells.
23. Use Wrap Text for long headers. Avoid excessive manual line breaks that can complicate sorting and accessibility.
24. Use consistent heading styles. Make headers bold and distinct without covering every cell in heavy decoration.
25. Reuse formats with Format Painter. Choose Home > Format Painter, then select the destination.
26. Remember display versus value. Formatting a serial date as Jan-26 does not turn the stored value into text.

Formulas and functions

27. Start every formula with =. Multiplication uses *, not the letter x.
28. Use SUM for totals. =SUM(F2:F100) is easier to audit than manually adding cells.
29. Use AutoSum. Select the cell below a numeric column and choose Home > AutoSum, or press Alt+= on Windows.
30. Use quick summaries. =AVERAGE(F2:F100), =MIN(F2:F100), and =MAX(F2:F100) answer common questions.
31. Understand relative references. =E2*F2 becomes =E3*F3 when copied down.
32. Lock constants with dollar signs. =E2*$H$1 keeps the input in H1 fixed.
33. Use the fill handle. Drag it to copy formulas or continue a series such as 1, 2, 3.
34. Use IF for decisions. =IF(G2>=1000,"Target met","Below target").
35. Use SUMIFS for conditional totals. =SUMIFS(tblSales[Revenue],tblSales[Region],H2).
36. Use COUNTIFS for conditional counts. It supports multiple range-and-criteria pairs.
37. Use IFERROR only for expected errors. Do not use it to conceal a broken lookup or bad input that needs investigation.
38. Prefer XLOOKUP when supported. It supports exact matching by default and can return from either side of the lookup field.
39. Know VLOOKUP for compatibility. Use FALSE when an exact match is required.
40. Use FILTER for a live subset. =FILTER(tblSales,tblSales[Region]=H2,"No matches") spills results into empty cells.
41. Use SORT and UNIQUE for dynamic lists. =SORT(UNIQUE(tblSales[Product])).
42. Understand #SPILL!. Clear cells blocking a dynamic-array result.
43. Use TEXT when joining formatted values. ="Due: "&TEXT(A2,"mmmm d, yyyy") preserves the intended date display.
44. Name important inputs. Name a tax rate TaxRate and use =A2*TaxRate instead of an opaque address.

Data tools

45. Filter instead of deleting. Filtering hides records without removing them.
46. Sort multiple levels. Use Data > Sort > Add Level to sort Region, Salesperson, and Date in sequence.
47. Add controlled drop-downs. Use Data > Data Validation > Allow: List.
48. Highlight exceptions. Use conditional formatting for low revenue, duplicate invoice numbers, or overdue dates.
49. Use a table as a validation source. A table-backed list can update when items are added or removed, especially when used through an appropriate named reference.
50. Add a Total Row. Table totals can calculate Sum, Average, Count, Minimum, or Maximum and can behave appropriately when rows are filtered.
51. Check the chart range. Use Insert > Recommended Charts, then verify the series and categories.
52. Use a PivotTable for category summaries. Put categories in Rows and numbers in Values, then refresh after source changes.

Saving, sharing, security, and recovery

53. Use .xlsx unless macros are required. Use .xlsm for VBA and treat macro files cautiously.
54. Never enable macros just to view a file. Enable them only for a trusted source and a needed function.
55. Use OneDrive or SharePoint for co-authoring. Select Share and choose View or Edit permissions.
56. Understand AutoSave before collaborating. Temporary filters and dashboard edits may become persistent changes for everyone.
57. Recover an unsaved workbook. Try File > Info > Manage Workbook > Recover Unsaved Workbooks when available.
58. Use Version History. It is safer than relying only on Undo for cloud files and major changes.
59. Distinguish protection from security. Locked worksheet cells do not make sensitive information secure.
60. Use comments and notes correctly. Comments are for threaded discussions; notes are for static annotations.
61. Run the Accessibility Checker. Use Review > Check Accessibility before sharing.
62. Print a preview. Check print area, orientation, scaling, repeated headings, and page breaks in File > Print.

13. Troubleshooting: what went wrong and how to recover

For a formula that is not calculating, follow this order:

1. Confirm the entry begins with =.
2. Check whether the cell is formatted as Text.
3. Check whether Formulas > Show Formulas is enabled.
4. Check parentheses, quotation marks, and cell references.
5. Remember that examples here use the United States comma convention. Your locale may require semicolons between function arguments.
6. Confirm that calculation is set to Automatic.
7. Check whether a referenced row, column, sheet, or named range was deleted.
8. Check whether numeric-looking values are actually stored as text.
9. Clear a blocked dynamic-array spill range.
10. Check whether your Excel edition supports the function, particularly when opening a newer workbook in an older edition.

Microsoft’s references for formula errors, broken formulas, and recalculation settings provide additional recovery details.

14. Formula, PivotTable, Power Query, or database?

Power Query is available across Windows, Mac, and the web, but connectors and capabilities vary. It is not only for experts: start with one repeatable import or cleanup task, then refresh it instead of repeating manual edits.

15. Excel desktop versus web, and Excel versus alternatives

Choose desktop Excel when you need macros, advanced data connections, complex printing, extensive Power Query work, full workbook control, or dependable offline use. Choose Excel for the web when browser access, easy sharing, and multi-device work matter more than advanced desktop features.

Google Sheets is convenient for browser collaboration and simple sharing. Excel generally offers a broader desktop feature set, mature tables and PivotTables, Power Query, Power Pivot, and enterprise compatibility. A database is preferable for normalized data, many concurrent users, strong permissions, and transactional updates. A project-management tool is preferable when workflow, dependencies, assignments, reminders, and audit history matter more than calculation. None of these tools is universally best; choose based on the job, scale, security, and collaboration requirements.

16. What to learn next

Once you can build the practice workbook without help, learn these in roughly this order:

1. Named ranges: make important assumptions such as TaxRate easier to understand.
2. PivotTable filters and slicers: let users interact with summaries without editing formulas.
3. Power Query: automate recurring imports and cleanup.
4. Data Model and Power Pivot: connect multiple tables and create measures.
5. What-If Analysis and Goal Seek: test the input needed to reach a target.
6. Analyze Data: ask questions about a table and receive suggested summaries where the feature is available. Availability depends on Microsoft 365 subscription, language, and region, and some natural-language functions are rolled out gradually; do not assume every installation has it. See Microsoft’s Analyze Data documentation.
7. Macros and VBA: automate trusted, repetitive tasks only after understanding macro-security risks.
8. Copilot in Excel: availability depends on the relevant Microsoft 365 plan, tenant settings, rollout, and region; treat its suggestions as drafts that require checking.

The most valuable advanced habit is to keep raw data clean, calculations explainable, and reports separate from inputs. That structure makes every later feature easier to use and safer to audit.

Frequently Asked Questions

Is Excel free for beginners?

Excel for the web may be available through a Microsoft account and OneDrive, while desktop Excel and some premium capabilities require a subscription or license. The web version also does not support every desktop feature. Check Microsoft’s OneDrive and Excel web information and the browser-versus-desktop comparison.

Should a beginner learn XLOOKUP or VLOOKUP first?

Learn XLOOKUP for new workbooks when your version supports it because it supports exact matching by default and can return from either side of the lookup column. Learn exact-match VLOOKUP as a compatibility skill for older workbooks. XLOOKUP is not natively available in Excel 2016 or Excel 2019.

Why is Excel showing my formula instead of the answer?

Check whether the cell is formatted as Text, whether the formula begins with =, and whether Formulas > Show Formulas is enabled. Change the cell to General, press F2, and press Enter. Also confirm that calculation is set to Automatic.

Is worksheet protection enough to secure financial information?

No. Worksheet protection mainly limits ordinary editing of locked cells and is not intended to protect sensitive information. Use appropriate file permissions and file-level encryption where available, and share only with people who should have access.

The Bottom Line

The beginner’s winning Excel workflow is simple: create a clearly named .xlsx workbook, keep one record per row, convert the range to a named table, use formulas instead of manual arithmetic, validate important inputs, filter rather than delete, build charts only to answer a question, refresh PivotTables, and keep a recoverable copy. Once that foundation is reliable, Power Query, dashboards, automation, and advanced analysis become much easier—and much less likely to corrupt your budget or business data.

Quick Recap

SaleBestseller No. 1

Logitech M185 Compact Ambidextrous Wireless Mouse with Rubber Grips - Blue

Product carbon footprint: 3.97 kg CO2e

$14.99

Bestseller No. 2

Logitech M240 Compact Silent Bluetooth Wireless Mouse - Graphite

$21.99

Bestseller No. 3

Afaartcci Rechargeable Wireless Mouse, Silent Bluetooth Mouse (Black)

$5.99

Bestseller No. 4

Logitech M510 Full Size Ambidextrous 2.4 GHz Wireless Mouse

$27.99

SaleBestseller No. 5

Acer Wireless Mouse for Laptop, 2.4GHz Computer Mouse 3 Adjustable 1600 DPI

$9.98

Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.