Free tools Windows power users keep installed
One-click scans. No signup required.
Microsoft Excel is a spreadsheet app for organizing information, calculating results, and turning data into tables, charts, and reports. You can use it for a household budget, expense tracker, invoice, schedule, inventory list, sales report, grade book, or project plan. The free browser version, Excel for the web, is enough for many beginners; desktop Excel is the better choice for complex files, macros, advanced analysis, and extensive offline work.
This guide takes you from creating your first workbook to building a practical expense tracker, while explaining the data-structure habits that prevent common Excel problems.
As an Amazon Associate I earn from qualifying purchases.
What is Microsoft Excel?
Excel is built around a simple hierarchy:
- Workbook: The complete Excel file.
- Worksheet: An individual sheet inside a workbook.
- Cell: The intersection of a row and a column, such as
B4. - Row: A horizontal line identified by numbers.
- Column: A vertical line identified by letters.
- Cell reference: A cell’s address, such as
A1. - Range: A group of cells, such as
A1:D20. - Formula: An expression beginning with
=. - Function: A built-in formula such as
SUMorIF. - Ribbon: The command area organized into tabs such as Home, Insert, Data, Formulas, and View.
- Formula Bar: The area that displays or edits the selected cell’s contents.
- Table: A structured data range with headers, filters, and automatic expansion.
- PivotTable: A summary report built from source data.
Excel’s main strength is not merely arithmetic. It keeps related information organized so formulas, filters, summaries, and charts can update as the underlying data changes. Microsoft’s overview of Excel explains these workbook and worksheet concepts.
Do these 3 things before closing this tab:
1Scan for outdated or missing drivers - takes under a minute2Repair Windows errors before they cause bigger problems3Fix the driver behind crashes, sound loss and screen glitchesWhat can you use Excel for?
- Personal budgets and expense tracking
- To-do lists, calendars, and schedules
- Inventory and stock monitoring
- Customer and contact lists
- Sales reports and dashboards
- Invoices and quotations
- Grade books and attendance records
- Project timelines
- Data cleaning and analysis
- Charts and financial summaries
How to create and save a workbook
- Open Excel and choose Blank workbook. You can also use File > New > Blank workbook.
- On Windows, press
Ctrl+N; on Mac, pressCommand+N. - Click a cell, such as
A1, and enter a heading or value. - Press
Enterto confirm orTabto move across the row. - Choose File > Save As, select a location, enter a filename, and click Save.
Use Ctrl+S on Windows or Command+S on Mac for later saves. For ordinary work, choose .xlsx.
| Format | Use and limitation |
|---|---|
.xlsx |
Modern Excel workbook format. |
.xls |
Older Excel format used for compatibility. |
.csv |
Plain-text table format. It does not preserve multiple worksheets, formulas, charts, or most formatting. |
.xlsm |
Macro-enabled workbook. Never enable macros from an unknown or untrusted source. |
Enter, edit, and fill data
Type text, numbers, dates, or formulas into the selected cell and press Enter. To edit a cell on Windows, press F2 or double-click it; the formula bar is useful for long entries. Press Delete to remove contents, and use Ctrl+Z or Command+Z to undo.
Excel can extend patterns. Enter two starting values—such as January and February, or 2014 and 2015—select them, and drag the fill handle. Excel may continue the sequence. Microsoft documents this and other basic tasks in its Excel beginner guide.
The most important data rule
Before formatting or analyzing anything, keep raw data in a clean rectangle:
What’s actually slowing this PC down?
Pick the symptom - the matching free tool is one click away.
- One header row.
- One field per column.
- One record per row.
- No blank header cells.
- No merged cells in the data area.
- Do not mix totals, titles, or notes into the raw records.
This structure makes sorting, filtering, charts, formulas, and PivotTables far more reliable.
Format a worksheet without damaging the data
Select cells and use the Home tab to apply currency, percentage, date, decimal, font, alignment, and border formats. Formatting changes how a value appears; it does not necessarily change the underlying value.
- Use Wrap Text for long descriptions.
- Double-click a column boundary to AutoFit its width.
- Use Format Painter to copy appearance without copying content.
- Use Cell Styles for consistent headings and totals.
- Use borders to clarify sections rather than outlining every cell.
- Use conditional formatting to highlight duplicates, deadlines, negative values, or amounts above a threshold.
- Use data bars or color scales to show relative values.
- Use custom number formats when you need labels or units without changing numeric values.
Conditional formatting can apply to ranges, tables, and, in Excel for Windows, PivotTable reports. See Microsoft’s conditional-formatting guidance.
How to write Excel formulas
Every formula starts with an equal sign. Prefer cell references—=B2*C2—over hard-coded calculations such as =25*4. References allow a result to change when the source data changes.
Assume an expense tracker has dates in A2:A20, categories in B2:B20, descriptions in C2:C20, and amounts in D2:D20.
| Task | Formula |
|---|---|
| Total spending | =SUM(D2:D20) |
| Average transaction | =AVERAGE(D2:D20) |
| Largest transaction | =MAX(D2:D20) |
| Smallest transaction | =MIN(D2:D20) |
| Number of transactions | =COUNT(D2:D20) |
| Nonblank descriptions | =COUNTA(C2:C20) |
| Food spending | =SUMIF(B2:B20,"Food",D2:D20) |
| Food spending from January 2026 | =SUMIFS(D2:D20,B2:B20,"Food",A2:A20,">="&DATE(2026,1,1)) |
| Flag a large expense | =IF(D2>100,"Review","OK") |
| Avoid division errors | =IFERROR(D2/E2,0) |
| Look up a value | =XLOOKUP(A2,F:F,G:G,"Not found") |
| Extract the month | =TEXT(A2,"mmmm") |
| Remove extra spaces | =TRIM(C2) |
| Join names | =TEXTJOIN(" ",TRUE,A2,B2) |
| Current date | =TODAY() |
| Running total | =SUM($D$2:D2) |
Relative and absolute references
When you copy =D2*E2 downward, the references usually become =D3*E3. This is a relative reference. Add dollar signs to lock a reference: $A$1 locks both the column and row, $A1 locks only the column, and A$1 locks only the row.
Newer functions such as XLOOKUP, FILTER, SORT, UNIQUE, LET, and dynamic-array behavior may differ or be unavailable in older Excel versions. Microsoft describes formula fundamentals and functions by category. XLOOKUP is generally the better starting point where available: it can look left or right, returns exact matches by default, and supports a not-found result. VLOOKUP remains useful when working with older files.
Rank #3
- 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
Turn a range into a table
- Select the complete data range.
- Press
Ctrl+Ton Windows, or choose Insert > Table. - Confirm My table has headers.
- Give the table a meaningful name, such as
Expenses.
A table adds filter arrows, expands as new records are entered, and supports readable structured references such as =SUM(Expenses[Amount]). Use Table Design > Total Row when you need built-in totals.
Crashes, No Sound, or Screen Glitches?
Random freezes, missing sound and display glitches usually trace back to one bad driver. Find and replace yours safely.Free scan · under a minutePC 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 & 11Sort, filter, and clean data
- Use filter arrows to show selected categories, dates, or amounts.
- Use Data > Sort for multi-level sorting, such as region and then date.
- Use Data > Remove Duplicates after deciding which columns define a duplicate.
- Use Data > Text to Columns to split one column into several.
- Use Data > Data Validation to create drop-down lists or restrict dates and numbers.
- Use
TRIMto remove extra spaces that can break lookups. - Use
UPPER,LOWER, orPROPERto standardize text where appropriate. - Check that date-looking values are real dates, not text.
- Keep an untouched copy before cleaning imported data.
Create charts that answer a question
- Select a clean summary range, not necessarily the entire raw dataset.
- Choose Insert and select a chart type, or use Quick Analysis after selecting data.
- Use a line chart for a trend, a bar or column chart for comparisons, and a pie chart only for a simple part-to-whole view.
- Add a descriptive title, units, and labels where necessary.
A chart should make a particular comparison easier. Avoid decorative effects, confusing scales, and too many categories.
Create a PivotTable
- Start with clean tabular data, preferably an Excel table.
- Select a cell in the source data and choose Insert > PivotTable.
- Place categories such as Category in Rows.
- Place numeric measures such as Amount in Values.
- Use Filters or Columns for additional dimensions.
- Right-click the PivotTable and choose Refresh after the source changes.
- Use PivotTable Analyze > Insert Slicer for clickable filters where supported.
If new rows do not appear, convert the source to a table or use PivotTable Analyze > Change Data Source.
55 smart Excel tips and shortcuts
Navigation and organization
- Rename a sheet by double-clicking its tab.
- Add a sheet with the
+button. - Right-click a tab to use Move or Copy.
- Right-click a tab and choose Tab Color to group sheets visually.
- Drag tabs left or right to reorder them.
- Use
Ctrl+Gon Windows to jump to a cell. - Click a column letter to select the whole column.
- Click a row number to select the whole row.
- Press
Ctrl+Ato select current data; pressing it again may select the sheet. - Use View > Freeze Panes to keep headings visible.
- Use View > Split to compare distant worksheet sections.
- Hide unused rows, columns, gridlines, or the Ribbon when presenting a finished sheet.
Faster data entry
- Drag the fill handle to copy formulas or extend patterns.
- Double-click the fill handle to fill beside a continuous neighboring column.
- Use Flash Fill from Data > Flash Fill or
Ctrl+Eon Windows after providing an example. - Use Paste Special > Values to replace formulas with their results.
- Use Paste Special > Transpose to switch rows and columns.
- Use
Ctrl+Hon Windows for Find and Replace. - Select blank cells through Go To Special, enter a value, and press
Ctrl+Enterto fill selected blanks—only after checking that this is safe. - Use
Ctrl+C,Ctrl+X, andCtrl+Vfor copy, cut, and paste. - Use
Ctrl+Enterto place the same entry into selected cells where supported.
Formatting and presentation
- Use Currency for monetary values rather than typing currency symbols into text.
- Use Percentage for rates and proportions.
- Control visible precision with Increase Decimal and Decrease Decimal.
- Apply one consistent date format to a column.
- Wrap long text instead of widening a column excessively.
- AutoFit columns by double-clicking their boundary.
- Use Format Painter for repeat formatting.
- Use Cell Styles for consistent headings and totals.
- Use conditional formatting for thresholds and duplicates.
- Use data bars or color scales for quick visual comparisons.
Formula and analysis habits
- Start formulas with
=. - Use cell references instead of hard-coded numbers.
- Use
SUM,AVERAGE,MIN, andMAXfor basic summaries. - Use
COUNTfor numbers andCOUNTAfor nonblank cells. - Use
COUNTIFandCOUNTIFSfor conditional counts. - Use
SUMIFandSUMIFSfor conditional totals. - Use
IFto label results or apply a rule. - Use
IFERRORonly when the replacement result is meaningful. - Press
Ctrl+`on Windows where supported, or use Formulas > Show Formulas, to inspect formulas. - Use Formulas > Trace Precedents and Trace Dependents to investigate relationships.
- Create named ranges such as
TaxRatefor important fixed values. - Use structured references such as
=SUM(Sales[Amount])in tables.
Data quality and safety
- Use drop-down lists with Data Validation.
- Restrict quantities to valid numbers and dates to valid ranges.
- Highlight duplicate values before deleting anything.
- Check for hidden spaces with
TRIM. - Check whether dates and numbers are stored as text.
- Keep summary rows outside raw records.
- Protect formulas with Review > Protect Sheet after unlocking input cells.
- Keep an untouched source copy.
- Use OneDrive or SharePoint version history when available.
- Never enable unknown macros.
Printing and sharing
- Preview through File > Print before printing.
- Set a controlled range through Page Layout > Print Area > Set Print Area.
- Use Page Layout > Print Titles to repeat heading rows.
- Fit a report to one page wide only after checking that text remains readable.
- Export through File > Export or save as PDF.
- Store a shared workbook in OneDrive or SharePoint and use Share.
- Choose view-only permission when recipients should not edit.
- Use comments or notes to explain assumptions.
- Avoid emailing multiple conflicting copies when collaboration matters.
Windows shortcuts do not always work identically on Mac, the web, iPad, or Android. On Mac, many Ctrl shortcuts use Command, but check the platform-specific behavior in Microsoft’s Excel shortcut reference.
Practical project: build an expense tracker
1. Create the data
In row 1, enter Date, Category, Description, Payment Method, and Amount. Add at least 10 records with different dates, categories, and amounts.
2. Convert it to a table
Select the range, press Ctrl+T on Windows, confirm the headers, and name the table Expenses.
3. Format and validate it
- Format Date as a date and Amount as currency.
- Apply a table style.
- Freeze the header row if the list is long.
- Use Data > Data Validation to create a Category list containing Housing, Food, Transport, Utilities, Entertainment, and Other.
4. Add calculations
=SUM(Expenses[Amount])
=SUMIF(Expenses[Category],"Food",Expenses[Amount])
=AVERAGE(Expenses[Amount])Add conditional formatting to highlight transactions above a threshold such as $100.
5. Summarize and share
Create a category summary and insert a bar or column chart. Then create a PivotTable with Category in Rows and Amount in Values. Group Date by month if your version supports it. Add a title, check formulas, set the print area, preview the report, save a backup, and share a view-only version if appropriate.
Independent reader supportYour contribution helps us test, update, and keep practical guides available for everyone.Print and share an Excel file
Use File > Print to check page breaks, orientation, scaling, margins, and whether columns are cut off. Set a print area and repeat header rows for multi-page reports. Export to PDF when the recipient needs a fixed layout rather than an editable workbook.
For collaboration, save the file in OneDrive or SharePoint and select Share. Set edit or view-only permissions deliberately. A shared cloud file is generally safer than circulating several email attachments with unclear versions.
Common Excel errors and fixes
| Problem | Likely cause | Fix |
|---|---|---|
##### |
The column is too narrow, or a date/time or negative date cannot display. | Widen the column, AutoFit it, and check the number format or date calculation. |
#DIV/0! |
A formula divides by zero or a blank cell. | Use =IFERROR(A2/B2,0) or test the denominator with =IF(B2=0,"",A2/B2). |
#N/A |
A lookup value is missing, has extra spaces, or has a mismatched data type. | Clean with TRIM, standardize types, check the range, and use =XLOOKUP(A2,F:F,G:G,"Not found"). |
| Formula appears as text | The cell is formatted as Text, begins with an apostrophe, or Show Formulas is enabled. | Change the format to General, press F2, press Enter, and check Formulas > Show Formulas. |
| Sorting is incorrect | Only one column was selected, data types are inconsistent, or blank rows or merged cells divide the range. | Use a table, select the full dataset, standardize types, remove separator rows, and avoid merged cells. |
| PivotTable misses new rows | The source was an ordinary range that did not expand. | Use an Excel table, then right-click the PivotTable and choose Refresh or change its data source. |
| Dates sort alphabetically | Date-looking values are stored as text. | Use Text to Columns with the correct date format, or use DATEVALUE, then apply date formatting. |
| CSV loses formulas or formatting | CSV is plain text and stores one table. | Keep the working file as .xlsx; create CSV only when another system requires it. |
Excel for the web versus desktop Excel
Excel for the web is a good fit for basic formulas, tables, charts, browser access, and collaboration. It is available free with a Microsoft account and includes browser-based Excel plus 5 GB of OneDrive storage. It is not the full desktop application.
Desktop Excel is preferable for complex workbooks, extensive offline work, macros and VBA, specialized add-ins, and more advanced Power Query or Power Pivot workflows. Feature availability varies by version, operating system, plan, and organizational policy. Microsoft notes, for example, that Excel for the web does not expose every desktop capability and that workbooks over 100 MB cannot be viewed from SharePoint Online through Excel for the web. See Microsoft’s Excel for the web service description.
Mac, Windows, web, and mobile editions are not identical. Excel for mobile is best for reviewing, entering, and making light edits rather than building complex workbooks. Power Query and Power Pivot support also varies; Microsoft summarizes platform differences in its Power Query and Power Pivot documentation.
Quick wins for a faster PC:
Repair Windows errors before they cause bigger problemsFix Now →Scan for outdated or missing drivers - takes under a minuteDriver Scan →Clear out junk files and repair common Windows errorsFree Scan →Microsoft 365, Office 2024, or an alternative?
- Choose free Excel for the web for occasional budgets, lists, schoolwork, basic formulas, and browser-first collaboration.
- Choose Microsoft 365 Personal if one person needs installed Excel, continuing updates, cloud storage, and other Office apps.
- Choose Microsoft 365 Family if several people in a household need the subscription and its separate storage allowances.
- Choose Office 2024 or another one-time purchase if you prefer a single payment and do not need ongoing major feature upgrades.
- Consider Google Sheets for browser-first collaboration, LibreOffice Calc for a non-Microsoft desktop office suite, or Apple Numbers for an Apple-focused setup.
Microsoft’s U.S. page showed Microsoft 365 Personal at $99.99 per year or $9.99 per month and Microsoft 365 Family at $129.99 per year when checked on August 18, 2026. Prices, bundles, promotions, currencies, and plan benefits vary by country and can change; check the live Microsoft Excel page before buying. Microsoft’s Microsoft 365 and Office 2024 comparison says subscriptions receive continuing feature, security, and bug-fix updates, while one-time purchases do not include upgrades to future major releases.
What to learn next
Once you can structure data, write formulas, and use tables, move to Power Query (also called Get & Transform in some interfaces), PivotCharts, Power Pivot, macros and VBA, or Power BI. Copilot in Excel can also be a next step where the feature, account, plan, usage limits, and organizational settings make it available; those conditions can change.
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.
