TL;DR
- Learn the layout first: a workbook holds worksheets, a worksheet is a grid of rows and columns, and every cell has an address like A1.
- Start formulas with =, point at cells instead of typing numbers, and learn SUM, AVERAGE and COUNT before anything else.
- Put your data in a table so sorting and filtering take one click.
- Build a chart from a clean range, and match the chart type to the question you are answering.
- LogicExcel is free to start: the Excel test and the first two practice lessons are free, and the rest sits in All-Access.
Table of Contents
Get oriented: workbooks, worksheets and cells
An Excel file is a workbook. Inside it sit one or more worksheets, the tabs along the bottom. According to the University of Minnesota's digital literacy text, each worksheet is a grid where rows run horizontally and are numbered, columns run vertically and are lettered, and the point where they meet is a cell named like A1. A group of cells, such as A1:C5, is called a range.
Microsoft's own basic tasks guide adds that a cell can hold a number, text or a formula. That last point matters more than it looks. A cell that shows 120 might contain a typed 120, or it might contain a formula that produced 120. Click the cell and look at the Formula Bar above the grid to see which. The University of Minnesota text notes that the Formula Bar shows the underlying formula even when the cell displays only the result.
The ribbon at the top is organized into tabs. The same Minnesota guide lists them: File for managing files, Home for formatting, Insert for adding objects like charts, Formulas for calculations, Data for analysis tools, Review, View and Help. You do not need to memorize them. You will use Home, Insert and Formulas for most of your first month.
If you want a deeper explanation of how the program thinks about cells, calculation and recalculation, our guide on how Excel works covers it in plain language.
Enter, edit and format data
Data entry is simple. Select a cell, type text or a number, and press Enter to move down or Tab to move right. That is the method Microsoft Support describes for beginners, and it is faster than reaching for the mouse.
A few habits save you trouble later:
- One fact per cell. Do not put "Smith, 4 units" in one cell. Use a column for the name and another for the quantity.
- One header row. Give every column a short, unique label in the first row.
- No blank rows or columns inside your data. Excel treats a blank row as the end of a dataset, which breaks sorting, filtering and charts.
To change what is in a cell, double-click it or edit in the Formula Bar. The
University of York spreadsheet guide points out that pressing Delete clears a cell's contents but leaves its formatting in place, so a cell you clear may still display values as a date or a percentage when you type into it again.
That same guide separates two kinds of formatting. Cell style covers fonts, colors, borders and background. Number formatting changes how a value is displayed: decimals, dates, percentages and currency. The underlying value does not change. A cell holding 0.25 can display as 0.25, 25% or $0.25, and any formula using that cell still sees 0.25.
Number formats are worth practicing early, because they are the fastest way to make a sheet look professional. Try the number formatting shortcuts exercise to build the keyboard habits.
Your first formulas
Every formula starts with an equals sign. Type =5+3 in a cell, press Enter, and the cell displays 8. Microsoft's guide lists the four basic operators: + to add, - to subtract, * to multiply and / to divide.
Typing numbers into formulas is rarely what you want, though. The better habit is to point at cells. OpenStax's workplace software text explains that a formula can use constants, cell references or both, for example =A1+4 to add 4 to whatever is in A1. When A1 changes, the result updates by itself. That is the whole reason spreadsheets exist.
The first three functions to learn
A function is a named shortcut for a calculation. A Wayne State University Excel guide demonstrates three that cover most beginner work:
| Function | What it does | Example |
| SUM | Adds a range | =SUM(A1:A3) |
| AVERAGE | Returns the mean of a range | =AVERAGE(A1:A3) |
| COUNT | Counts the cells that hold numbers | =COUNT(A1:A3) |
If you want the fastest route to a total, use AutoSum. Microsoft explains that you select the cell below or beside your numbers, choose AutoSum on the Home tab, and press Enter. Excel guesses the range and writes the SUM for you. Always check that the highlighted range is the one you meant.
Once these feel natural, the next functions to add are IF (make a decision), MIN and MAX, ROUND, and later the lookup functions. Our Excel functions cheat sheet is a quick reference you can keep open while you work.
Relative and absolute references
When you copy a formula down a column, Excel shifts the references. A formula =B2C2 in row 2 becomes =B3C3 in row 3. That is a relative reference, and it is what you want most of the time.
Sometimes you want one reference to stay put, such as a tax rate stored in a single cell. Adding dollar signs, as in $F$1, locks it. Press F4 while the cursor sits on a reference to add them. Beginners who skip this lesson produce sheets where the total looks right in row 2 and wrong everywhere below it, so it is worth an afternoon of practice.
A worked example
Imagine a small sales sheet. Column A holds product names, column B units sold, column C price per unit. In D2 you write =B2*C2 for revenue, then copy it down. Below the last row you write =SUM(D2:D20) for total revenue and =AVERAGE(D2:D20) for the average per product. Change one price in column C, and every figure that depends on it updates. If you can build that sheet without looking anything up, you have the foundations.
Sort, filter and summarize with tables
Raw ranges work, but tables work better. Microsoft Support describes tables as a practical way to get at Excel's power, because each column header gets controls for quick sorting and filtering. Click anywhere in your data, choose Insert, then Table, and confirm that your data has headers.
From there, the header arrows let you sort A to Z or Z to A, or filter to only the values you select. Want only orders from one region, or the ten largest invoices? Two clicks. You can practice exactly this in our table filters exercise.
A realistic beginner workflow looks like the one in the University of Minnesota's hiring data project: prepare a dataset, add calculated columns, sort and filter, apply conditional formatting and an IF formula, then move on to charts and PivotTables. That order is a good model for your own projects, because each step builds on a clean table.
Learning this takes steady repetition more than long sessions. If you struggle to keep a routine, an editable study plan template can help you block out short daily practice sessions around the tables and formulas you are learning.
Build your first chart
Charts turn a table into something a manager reads in five seconds. The steps are short. Microsoft's guide to creating charts says to select the data including the headers, open Insert, pick a chart type or Recommended Charts, then customize it from Chart Design. The Journal of Accountancy gives the same sequence and adds naming the chart and applying optional formatting.
The harder decision is which chart. Microsoft's chart guidance recommends:
| Question you are answering | Chart type |
| How do categories compare? | Column or bar |
| What share does each part hold? | Pie or doughnut |
| How does a value change over time? | Line or area |
Two practical tips. First, give the chart a title that states the point, such as "Revenue by region", rather than leaving the default. Second, if a chart looks wrong, the cause is almost always the data: a blank row, a header missing from the selection, or numbers stored as text.
What to learn in Excel, in order
Beginners often ask for a roadmap because Excel feels endless. Here is a sequence that keeps you useful at every stage.
| Stage | Topics | Goal |
| 1. Basics | Cells, ranges, entering data, number formats | Build a tidy sheet without help |
| 2. Core formulas | +, -, *, /, SUM, AVERAGE, COUNT, relative and absolute references | Calculate totals and averages that update |
| 3. Organizing data | Tables, sorting, filtering, conditional formatting | Answer questions from a list |
| 4. Logic and lookups | IF, nested logic, lookup functions | Pull values from one list into another |
| 5. Summaries and visuals | Charts, PivotTables | Produce a report |
| 6. Advanced tools | Power Query, Power Pivot, dynamic arrays | Clean and model larger data |
This ordering mirrors a
workplace-skills perspective from The FP&A Guy, which puts common formulas, tables, PivotTables and charts ahead of Power Query, Power Pivot and dynamic arrays. Most office jobs live in stages 2 to 5. Do not rush to stage 6 before stage 3 feels automatic.
How to practice so it sticks
Reading a tutorial is the easy part. Skill arrives when you type the formulas yourself, get them wrong, and see why. Three approaches work well together.
Use your own data. The University of Minnesota text suggests that budgets, survey responses and public data make good beginner projects, with totals, charts and reports as the output. If you track spending, start there.
Work on one dataset end to end. The Minnesota hiring project uses New York City job-posting data to compare salaries, timelines and hiring patterns. The lesson is to apply several tools to one meaningful dataset: prepare it, calculate, inspect, summarize, visualize.
Get instant feedback. This is where a practice site beats a video. On LogicExcel you type real formulas into a sheet in your browser and every answer is marked straight away, with an explanation for each mistake. We mark what the formula actually produces, cell by cell, so a different route to the right answer still counts.
A simple weekly plan for a new learner:
- Days 1 to 2: layout, data entry and number formats.
- Days 3 to 4: SUM, AVERAGE, COUNT and cell references.
- Day 5: turn a dataset into a table and filter it.
- Weekend: build one chart and one small report from your own numbers.
If you are preparing for a job interview, take the Excel test first. It shows which of these stages you already handle and which need work. Our page of
Excel exercises for beginners lays out what to practice at each level, and our
Excel learning guides cover formulas, functions and tips in more depth.
Start practicing with LogicExcel
LogicExcel is free to start. Only the Excel test is free: 12 real tasks, marked, with answers. Only the first two practice lessons are free as well. If you work in finance, only the 5-day accounting course by email is free.
The rest of LogicExcel is in All-Access: the 95 practice lessons, the Excel I, II and III courses that end in a timed exam and a certificate, Academy Essentials, the Excel for Accounting course and the template library. See the All-Access plans: $29 a month, $99 a year ($8.25 a month), or a lifetime plan at a founding price of $249 one-off. Lessons you have finished stay open. A sensible first step is the free Excel test, then the plans once you know what to work on.
Our perspective
> We built LogicExcel on a simple belief: nobody learns a formula by watching someone else type it. You learn it when you type it yourself, see the wrong result, and find out exactly why it is wrong.
>
> That is why every answer in our sheets is marked on what the formula produces, not on whether it matches one model answer. A beginner who reaches the right total through a slightly different route should be told they are right. A beginner who is wrong should be told which part failed.
>
> We also think the order of learning matters more than the amount. Master the grid, references and tables before chasing advanced tools, and the advanced tools become easy to pick up. Our lessons and the Excel I to III courses follow that order, and lessons you have finished stay open so you can return to them whenever a job task needs a refresher.
>
> Start with the Excel test, see where you stand, and let All-Access take you from there.
>
> Thomas Houza
FAQ
How long does it take to learn Excel basics?
Most beginners can handle data entry, simple formulas and a basic chart after a few weeks of short, regular practice. The time depends on how often you practice and whether you work on real tasks. Daily sessions of 20 to 30 minutes usually beat one long weekend session.
Which Excel functions should I learn first?
Start with SUM, AVERAGE and COUNT, then add IF, MIN, MAX and ROUND. After that, move to lookup functions and PivotTables. Our functions guide lists them by purpose.
Do I need to memorize keyboard shortcuts?
No, but a handful pay off quickly: Enter and Tab to move through data, F4 to lock a reference, and the shortcuts for number formats. Practicing them in a data shortcuts exercise turns them into habit faster than reading a list.
What should I practice before an Excel test for a job?
Focus on formulas with cell references, sorting and filtering a table, simple IF logic and one or two charts. Our Excel test gives you 12 real tasks, marked, with answers, so you can see your gaps before the interview.
Is Excel hard for a complete beginner?
The basics are approachable because you build on a few ideas: cells, references and formulas. Difficulty rises with lookups and PivotTables, which is why the path above introduces them in order.
Sources
- Basic tasks in Excel, Microsoft Support
- Navigating Microsoft Excel, University of Minnesota
- Spreadsheet basics, University of York
- Microsoft Excel Basics, OpenStax
- Guide to Microsoft Excel, Wayne State University
- Excel Project 4: Making Sense of Hiring Data, University of Minnesota
- Create charts and insert sparklines, Microsoft
- Create and select a chart in Excel, Microsoft Support
- 10 types of Excel charts for data visualization, Journal of Accountancy
- From Excel to Power BI and Beyond, The FP&A Guy
Recommended
