Recommended Free Tools
iTechGuides is reader-supported. When you buy through links on our site, we may earn an affiliate commission. As an Amazon Associate I earn from qualifying purchases. Learn more
In a short Excel crash course, learn to move from a blank worksheet to a useful summary: enter a formula, calculate order totals, organize records in a table, filter and look up data, then summarize and chart it. The examples below use a small order list; the sequence is a practical learning path, not an official Microsoft curriculum. Exact features and labels can vary by Excel version and platform.
1. Get oriented in the worksheet
An Excel worksheet is a grid of columns, rows, and cells. A cell reference combines its column letter and row number: A1 is in column A, row 1. A range names multiple cells, such as D2:D10. Formulas can refer to cells and ranges so they use the values stored there rather than requiring you to retype them. Microsoft explains formula basics and references in its overview of formulas in Excel.
Practice: calculate one order total
Create a small list with headings such as Date, Product, Quantity, Unit Price, and Customer ID. Put one sample order on row 2. If Quantity is in C2 and Unit Price is in D2, enter =C2*D2 in E2. The leading equals sign tells Excel to calculate the expression; changing either input updates the result.
The Tool Desk
Outbyte PC Repair FREERepair Windows errors before they cause bigger problemsFix Now →Outbyte Driver Updater FREEScan for outdated or missing drivers - takes under a minuteDriver Scan →2. Use formulas and common functions
Formulas start with = and can combine references, operators, constants, and functions. Functions save you from writing a calculation from scratch. Try these on your order totals in E2:E10:
#1 Best Overall
=SUM(E2:E10)adds the order totals.=COUNT(E2:E10)counts cells containing numbers.=AVERAGE(E2:E10)calculates the mean of the numeric values.
For a simple decision, an IF formula can label an order based on its total. For example, =IF(E2>100,"Review","Standard") returns “Review” when the total exceeds 100 and “Standard” otherwise. The threshold here is an example, not a business rule.
Keep assumptions easy to change
Instead of embedding a changing threshold directly in a formula, enter it in a separate cell, such as H1, and refer to it: =IF(E2>$H$1,"Review","Standard"). The dollar signs keep the reference fixed if you copy the formula to other rows. This makes assumptions visible and easier to update.
Rank #2
Microsoft offers a downloadable tutorial workbook for practicing common formulas, including SUM, COUNT, AVERAGE, and VLOOKUP: Excel formula overview and tutorial workbook.
Do these 3 things before closing this tab:
1Repair Windows errors before they cause bigger problems2Scan for outdated or missing drivers - takes under a minute3Clear out junk files and repair common Windows errors3. Turn the list into structured data
Keep one record per row, use a single header row, and avoid blank rows or columns inside the list. Select the data and use Excel’s table command—typically Insert > Table—to create a table. A table helps keep related records together as you add rows and makes sorting and filtering more manageable. Check the checkbox confirming that your data has headers if the first row contains the field names.
Sort and filter to answer a question
- Sort the Date column to arrange orders chronologically, or sort Unit Price to compare prices.
- Use the header filter to show only one Product or a date range.
- Clear the filter when you want to see the full list again.
For example, filter Product to one item, then inspect its dates and quantities. Microsoft groups tables, sorting, filtering, charts, PivotTables, and other analysis tools in its data analysis help.
4. Retrieve related information with a lookup
A lookup connects a key in one list to related information in another. For example, keep a separate product list with a unique Product ID and Product Name, then retrieve a name for an order using its ID. Unique IDs matter: if the key is missing or duplicated, the result may not identify the intended record.
Use XLOOKUP when your Excel version supports it
With Product ID in A2 of the order list, IDs in G2:G20, and names in H2:H20, use =XLOOKUP(A2,G2:G20,H2:H20,"Not found"). Microsoft describes XLOOKUP as searching in any direction and returning exact matches by default. The optional fourth argument supplies a readable result when there is no match. Microsoft’s formula overview lists applicability for Microsoft 365, Excel 2024, Excel 2021, Excel 2019, and Excel 2016; confirm your edition and platform before relying on a version-specific function.
Recognize older VLOOKUP workflows
VLOOKUP remains useful in workbooks built around it. It searches for a value in the first column of a table array and returns a value from a column to its right; for exact matching, specify FALSE as its final argument. Unlike XLOOKUP, this layout does not search to the left of the lookup column. Microsoft’s Excel formulas article, updated July 20, 2026, describes XLOOKUP as a newer alternative to VLOOKUP.
Best Value
- The Microsoft Office 365 Bible: The Most Updated and Complete Guide to Excel, Word, PowerPoint, Outlook, OneNote, OneDrive, Teams, Access, and Publisher from Beginners to Advanced
- ABIS BOOK
5. Summarize records with a PivotTable
A PivotTable groups and aggregates records so you can answer questions without manually writing a separate formula for every category. Select a cell in the order table, then choose Insert > PivotTable and confirm the data range. In the field list, place Product in Rows and Order Total in Values. If Values does not summarize as a sum, change its value-field setting to Sum. The result shows total sales by product; moving Date into Rows lets you explore the data by date instead.
Ask a specific question before arranging fields—for example, “Which products have the highest total order value?” After changing the source data, refresh the PivotTable so it includes the updated records. Microsoft’s Excel help and learning hub includes PivotTable and chart guidance.
6. Chart the summary
Use the PivotTable result rather than the raw order rows when the goal is to compare product totals. Select the product names and totals, then choose Insert and a chart suited to the comparison, such as a column or bar chart. Give it a specific title, such as “Order total by product,” and check that the category labels and values are clear. A chart should make the comparison easier to read, not replace the underlying figures.
Outdated Drivers Are Slowing You Down
One free scan finds every outdated or missing driver and matches the right update for your exact hardware.Free scan · exact hardware matchPC Slower Than It Used to Be?
A free scan shows the junk files, broken settings and background clutter dragging Windows down - then fixes them in one click.Free scan · Windows 10 & 117. Practice the complete workflow
- Create a small order list with dates, products, quantities, unit prices, and customer IDs.
- Add an order-total formula and use SUM, COUNT, and AVERAGE on the results.
- Convert the list to a table, then filter it to one product and sort by date.
- Use a unique ID to retrieve a related name from a second list; test what happens when the ID is absent.
- Build a PivotTable of total order value by product, then chart the summary.
Microsoft’s help resources also cover data models and Power Query. Power Query can connect to multiple data sources and shape data in Query Editor; it is a useful next topic when data needs repeatable cleanup or comes from outside the worksheet, rather than a prerequisite for this beginner workflow. See Import and analyze data.
For a guided next step, Microsoft’s Excel help and learning hub organizes additional help, and the Microsoft Excel for Beginners Professional Certificate listing describes a longer course covering formulas, tables, lookups, PivotTables, charts, and dashboards.
Quick Recap
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.
