Skip to content
Tutorials Center
My learning

Topics

Microsoft Excel Tutorial

Learn Microsoft Excel step by step: 93 lessons in 14 chapters with examples, quizzes, diagrams and projects.

Start learning →

of lessons completed

Getting Started

  1. 1 What Is Excel and What Is It For Learn what Microsoft Excel is, how workbooks, worksheets and cells fit together, what people use it for, and how the desktop, web and Mac versions differ.
  2. 2 A Tour of the Excel Interface Find your way around Excel: the ribbon, Quick Access Toolbar, Name Box, formula bar, status bar, sheet tabs and views, plus the first shortcuts worth learning.
  3. 3 Entering and Editing Data Learn how Excel decides whether an entry is text, a number or a date, how to edit cells, use Autofill and Flash Fill, and avoid common data-entry surprises.
  4. 4 Workbooks, Worksheets and Navigation Manage worksheets (add, rename, move, copy, group, hide), freeze panes and split windows, and move quickly through big sheets with Ctrl+Arrow and Go To.
  5. 5 Formatting Cells Learn Excel cell formatting: number, currency, percent and date formats, custom formats, alignment, borders, fills, styles and why formats never change values.
  6. 6 Saving, File Formats and Sharing Choose the right Excel file format, understand what CSV loses, save as PDF, co-author in the cloud, use version history, and protect files with passwords.
  7. 7 Page Setup, Page Breaks and Printing Print Excel sheets cleanly: set the print area, use Page Break Preview, insert and move page breaks, repeat title rows, add headers and footers, scale to fit, and export to PDF.
  8. 8 Templates, Quick Analysis, Autofill and Small Time-Savers Use Excel templates, Quick Analysis and Autofill series, Insert Function, Scroll Lock, and quick fixes: swap columns, delete blank rows, delete rows below the active cell, wrap text and fractions.

Formulas Fundamentals

  1. 9 Your First Formulas Write your first Excel formulas: the equals sign, arithmetic operators, order of operations, parentheses, cell references and what happens when a formula is wrong.
  2. 10 Cell References: Relative, Absolute, Mixed Understand Excel cell references: relative, absolute and mixed references, the F4 key, how formulas change when copied, and the R1C1 style.
  3. 11 Ranges and Named Ranges Learn Excel ranges (B2:B9, whole columns and rows, 3D references) and how to create named ranges and named constants with the Name Manager.
  4. 12 SUM, AVERAGE, COUNT, MIN and MAX Master the everyday Excel summary functions: SUM, AVERAGE, COUNT, COUNTA, COUNTBLANK, MIN, MAX, MEDIAN and MODE, and how they treat text and blanks.
  5. 13 Formula Errors and How to Fix Them Learn what every Excel error means (#DIV/0!, #N/A, #VALUE!, #REF!, #NAME?, #NUM!, #NULL!, #SPILL!, ####), why it appears and how to fix or handle it.
  6. 14 Auditing and Debugging Formulas Learn to debug Excel formulas: trace precedents and dependents, Show Formulas, Watch Window, F9 and Evaluate Formula, circular references and calculation modes.
  7. 15 Percentages, Rounding and Number Precision Calculate percentages in Excel, round with ROUND, ROUNDUP, MROUND, CEILING, FLOOR, INT and TRUNC, and understand floating-point surprises and precision as displayed.

Logical and Conditional Formulas

  1. 16 IF and Nested IF Learn how the Excel IF function makes decisions, how comparison operators work, how to nest IF safely, and when IFS is a clearer choice.
  2. 17 AND, OR, NOT and XOR Combine several conditions in Excel with AND, OR, NOT and XOR, use TRUE and FALSE as numbers, and avoid the errors AND and OR can cause.
  3. 18 IFS, SWITCH and Choosing Between Many Cases Choose between many outcomes in Excel with IFS, SWITCH and CHOOSE, set default values, and know when a lookup table beats a long formula.
  4. 19 SUMIF, COUNTIF, AVERAGEIF and Their IFS Versions Total, count and average only the rows that match: Excel criteria syntax, wildcards, operators, and the multi-condition SUMIFS, COUNTIFS and MAXIFS.
  5. 20 SUMPRODUCT and Array-Style Calculations Learn SUMPRODUCT in Excel: multiply and add ranges, compute weighted averages, count with several conditions, and use boolean arrays and the double negative.
  6. 21 Handling Errors and Blanks in Formulas Learn how to handle errors and blank cells in Excel formulas with IFERROR, IFNA, ISBLANK, ISNUMBER and ISERROR without hiding real mistakes in your data.

Lookup and Reference

  1. 22 VLOOKUP and Its Limits Learn how Excel's VLOOKUP works, why exact match matters, what causes #N/A, and the limits that make INDEX/MATCH and XLOOKUP better choices.
  2. 23 HLOOKUP and Approximate-Match Lookups Learn HLOOKUP and approximate-match lookups in Excel: sorted ranges, grade bands, tax brackets, and how the binary search behind them can go wrong.
  3. 24 INDEX and MATCH Learn how to combine INDEX and MATCH in Excel for left lookups, two-way lookups and lookups that survive inserted columns, with live examples.
  4. 25 XLOOKUP and XMATCH Learn every argument of Excel's XLOOKUP and XMATCH: not-found values, match modes, search modes, wildcards and multi-column results, and how they replace VLOOKUP.
  5. 26 Lookups with Multiple Criteria Look up a value in Excel using two or more conditions: helper-column keys, INDEX/MATCH arrays, XLOOKUP, FILTER and the SUMIFS trick, with live examples.
  6. 27 OFFSET, INDIRECT and Dynamic References Build references from numbers and text with OFFSET, INDIRECT, ADDRESS, ROW and COLUMN, and learn why these volatile functions should be used sparingly.
  7. 28 ROWS, COLUMNS, TAKE, DROP, CHOOSECOLS and Reshaping Data Cut, pick, stack and reshape ranges with ROWS, COLUMNS, TAKE, DROP, CHOOSECOLS, CHOOSEROWS, HSTACK, VSTACK, WRAPROWS and TOCOL, with runnable stand-ins.

Text, Date and Time

  1. 29 Text Functions: LEFT, RIGHT, MID, LEN, TRIM Extract, measure and clean text in Excel with LEFT, RIGHT, MID, LEN, FIND, SEARCH, TRIM, CLEAN, UPPER, LOWER, PROPER, SUBSTITUTE and REPLACE.
  2. 30 Joining and Splitting Text Join cells with &, CONCAT and TEXTJOIN, split them with TEXTSPLIT, TEXTBEFORE and TEXTAFTER, and choose between formulas, Text to Columns and Flash Fill.
  3. 31 TEXT, VALUE, NUMBERVALUE and Number-as-Text Problems Format numbers and dates with TEXT, convert text back with VALUE and NUMBERVALUE, and fix numbers stored as text, lost leading zeros and locale problems.
  4. 32 Dates and Times in Excel Learn how Excel stores dates and times as serial numbers, build dates with DATE, read parts with YEAR, MONTH and DAY, and avoid the 1900 and 1904 date traps.
  5. 33 Date Calculations: DATEDIF, EDATE, EOMONTH, NETWORKDAYS Calculate with dates in Excel: differences with DATEDIF, adding months with EDATE and EOMONTH, workdays with NETWORKDAYS and WORKDAY.INTL, age and fiscal periods.

Statistics and Math

  1. 34 Statistics for Analysts: Averages, Spread and Rank Describe data in Excel: AVERAGE, MEDIAN, STDEV.S vs STDEV.P, VAR, PERCENTILE, QUARTILE, RANK.EQ, LARGE, SMALL and z-scores, with runnable stand-ins.
  2. 35 Frequency Distributions, Cumulative Frequency and Contingency Tables Build frequency tables with FREQUENCY and COUNTIFS, cumulative frequency and histograms, contingency (cross-tab) tables with PivotTables, conditional probability, CAGR and point-biserial correlation.
  3. 36 Outliers, Normalization and Linear Interpolation Find outliers with the IQR rule, LARGE/SMALL and z-scores, scale data with min-max and STANDARDIZE, and interpolate missing values with FORECAST.LINEAR, TREND, XLOOKUP and LINEST.
  4. 37 Financial Functions: PMT, NPV, IRR and More Use Excel financial functions PMT, IPMT, PPMT, FV, PV, RATE, NPER, NPV, IRR, XNPV and XIRR correctly, including sign conventions and a loan schedule.
  5. 38 Correlation, Regression and Forecasting Measure relationships and predict values in Excel with CORREL, SLOPE, INTERCEPT, RSQ, LINEST, FORECAST.LINEAR, TREND, the Forecast Sheet and moving averages.
  6. 39 Random Numbers and Simple Simulations Generate random numbers in Excel with RAND, RANDBETWEEN and RANDARRAY, freeze them, draw random samples and run a simple Monte Carlo simulation.

Tables, Sorting and Filtering

  1. 40 Excel Tables Turn a range into an Excel Table with Ctrl+T: structured references, calculated columns, auto-expansion, the total row, table styles and slicers, step by step.
  2. 41 Sorting Data Learn to sort data in Excel: single and multi-level sorts, custom lists, sort by color, the partial-range trap, and the SORT and SORTBY functions.
  3. 42 Filtering Data Learn to filter data in Excel: AutoFilter text, number and date filters, filter by color, the Advanced Filter criteria range, and the FILTER function.
  4. 43 Data Validation and Dropdown Lists Learn Excel data validation: dropdown lists, whole number, date and custom rules, input messages, error alerts, dependent dropdowns and circling invalid data.
  5. 44 Finding and Removing Duplicates Find, highlight and remove duplicates in Excel with Remove Duplicates, the UNIQUE function, COUNTIF flags and conditional formatting, and avoid the risks.
  6. 45 Grouping, Outlines, Subtotals and Consolidate Group and ungroup rows and columns, use outline levels, insert subtotals with Data > Subtotal, expand and collapse sections, and combine ranges with Consolidate by position or category.

Dynamic Arrays

  1. 46 Dynamic Arrays and Spilling Understand Excel dynamic arrays: how a formula spills into many cells, the # spill operator, #SPILL! causes, implicit intersection, legacy CSE and versions.
  2. 47 FILTER, SORT, SORTBY and UNIQUE Combine the FILTER, SORT, SORTBY and UNIQUE functions in Excel to build live reports, dropdown lists and top-N ranking lists that update by themselves.
  3. 48 SEQUENCE, RANDARRAY and Array Arithmetic Generate number grids and calendars with SEQUENCE, understand row and column arrays, array arithmetic and MMULT, with JavaScript and NumPy stand-ins.
  4. 49 LET, LAMBDA and Reusable Formulas Name values with LET, build your own functions with LAMBDA, and process arrays with MAP, REDUCE, SCAN, BYROW, BYCOL and MAKEARRAY, with runnable stand-ins.

Charts and Visualization

  1. 50 Creating Your First Chart Lay out data for a chart, insert one in Excel, and learn the chart elements: title, axes, legend and data labels, with a runnable text-chart stand-in.
  2. 51 Choosing the Right Chart Type Pick the right Excel chart for your question: column, bar, line, pie, scatter, area, histogram, waterfall, box and whisker and combo, with Python examples.
  3. 52 Formatting and Improving Charts Improve Excel charts: axis scale and honest axes, gridlines, colors, labels, secondary axis, trendlines, templates and alt text, with runnable stand-ins.
  4. 53 Gantt, Timeline and Milestone Charts Build a Gantt chart in Excel with a stacked bar chart, a conditional-formatting Gantt that follows your dates, a dynamic progress Gantt, and a milestone timeline.
  5. 54 Tornado, Funnel, Waffle, Pictograph and Actual-vs-Target Charts Build business charts Excel does not offer as one click: tornado, funnel, waffle, pictograph, actual vs target, goal line, trend arrows and step charts, with the data layout for each.
  6. 55 Dynamic and Interactive Charts Make Excel charts that update themselves: dynamic titles, Tables and named ranges, drop-down driven charts, rolling last-N charts, multi-sheet sources, overlapping bars and percent stacks.
  7. 56 Scatter, Bubble, Frequency Polygon, Ogive and Statistical Plots Create scatter and bubble charts with three variables, frequency polygons, ogives, stem-and-leaf plots, Bland-Altman and forest plots, plus two trendlines and their intersection.
  8. 57 Flowcharts, Org Charts, SmartArt and Infographics Draw flowcharts with shapes and connectors, build SmartArt and organization charts, keep an org chart in step with data, make a Pareto chart, and design simple infographics in Excel.
  9. 58 Sparklines, Data Bars and Icon Sets Add tiny charts and visual cues inside cells with sparklines, data bars, icon sets and color scales, with a runnable text-rendering stand-in.
  10. 59 Conditional Formatting Use Excel conditional formatting to highlight values, top and bottom items, whole rows and deadlines with formula rules, rule order and Stop If True.
  11. 60 Building an Interactive Dashboard Build an interactive Excel dashboard: plan the layout, show KPIs, link charts to PivotTables, add slicers and timelines, protect the sheet and refresh data.

PivotTables and Data Analysis

  1. 61 PivotTable Basics Learn Excel PivotTables from scratch: field areas, value field settings, source data rules, refreshing, GETPIVOTDATA and a pandas pivot_table equivalent.
  2. 62 Grouping, Calculated Fields and Show Values As Group dates and numbers in a PivotTable, show percent of total, running totals and differences, and add calculated fields and items, with pandas stand-ins.
  3. 63 Slicers, Timelines and PivotCharts Filter PivotTables with slicers and timelines, connect one slicer to several reports, build PivotCharts and tune layout options, with a pandas stand-in.
  4. 64 The Data Model, Power Pivot and DAX Overview Learn Excel's Data Model: relationships, one-to-many tables, measures vs calculated columns, basic DAX (SUM, CALCULATE, DISTINCTCOUNT) and when to leave pivots.
  5. 65 The Analysis ToolPak Install and use the Excel Analysis ToolPak: descriptive statistics, histogram, regression, t-test, ANOVA, correlation matrix, moving average and exponential smoothing, with formula equivalents.
  6. 66 What-If Analysis: Goal Seek, Scenarios and Data Tables Learn Excel What-If Analysis: Goal Seek, Scenario Manager, one- and two-variable data tables and Solver, with JavaScript and Python stand-ins.

Data Cleaning and Import

  1. 67 Importing Data from CSV, Text and the Web Learn to import CSV and text files into Excel safely: delimiters, encodings, locale and date pitfalls, leading zeros, web and folder imports, with pandas.
  2. 68 Cleaning Messy Data Step by Step Clean messy Excel data step by step: trim spaces, fix case, split columns, convert numbers stored as text, handle blanks and errors, plus a repeatable checklist.
  3. 69 Power Query: Get and Transform Learn Power Query in Excel: queries, applied steps, merge vs append, unpivot, refresh and privacy levels, with pandas melt, merge and concat stand-ins.
  4. 70 Power Query M Language Basics Learn the basics of Power Query's M language: let/in steps, records, lists, tables, common functions, custom columns, parameters and query folding.
  5. 71 Checkboxes, Checkmarks, Hyperlinks, Pictures and Data Entry Forms Add Excel checkboxes linked to cells, insert checkmark symbols, create or remove hyperlinks, use HYPERLINK and IMAGE, enter line breaks, use the built-in Data Form and sign a workbook.

Automation and Collaboration

  1. 72 Macros and the Macro Recorder Learn Excel macros: show the Developer tab, record and run a macro, absolute vs relative recording, the Personal Macro Workbook, macro security and xlsm files.
  2. 73 VBA Basics Learn VBA for Excel: the editor, Sub and Function, variables, Range and Cells, loops, If, MsgBox, custom worksheet functions and error handling.
  3. 74 VBA Loops, If/ElseIf, Select Case and Procedures Go deeper with VBA control flow: For, For Each, Do While and Do Until loops, nested If, Select Case, operators, Sub versus Function, ByVal and ByRef, and Exit statements.
  4. 75 VBA Objects: Application, Workbook, Worksheet and Range Learn the Excel VBA object model: Application, Workbooks, Worksheets, Range, Cells, Offset, CurrentRegion, Find, reading values and formulas, and finding the last row.
  5. 76 VBA Arrays, Collections and Strings Learn VBA arrays (static, dynamic, ReDim Preserve, 2D), Collection and Dictionary objects, removing duplicates, string and date functions, and constants for fast macros.
  6. 77 VBA Events, UserForms and Controls Make Excel react with VBA events: Worksheet_Change, Workbook_Open, BeforeSave, UserForms, form controls versus ActiveX, buttons, InputBox, MsgBox and auto-run macros.
  7. 78 VBA for Charts, PivotTables and User-Defined Functions Automate Excel charts and PivotTables with VBA, write user-defined functions (UDFs) with volatile behavior, speed up macros, and protect or share code with the Personal Macro Workbook.
  8. 79 Office Scripts, Power Automate and Python in Excel Compare modern Excel automation: Office Scripts in TypeScript, Power Automate flows and Python in Excel with the PY function, and learn which one to pick.
  9. 80 Collaboration, Comments and Protecting Work Work with others in Excel: co-authoring, threaded comments and notes, version history, locked cells, protecting sheets and workbooks, and external links.
  10. 81 Copilot and AI Features in Excel Learn what Copilot in Excel can do, how to enable it, how to prompt for formulas, charts, analysis and forecasts, how Analyze Data differs, and the accuracy, limits and privacy rules to follow.

Real-World Projects

  1. 82 Project: Monthly Budget Tracker Build a monthly budget tracker in Excel: an income and expense table, SUMIFS summaries, data validation, conditional formatting and a budget chart.
  2. 83 Project: Sales Analysis Report Turn messy sales transactions into a report: clean the data, add product and region lookups, summarize with a PivotTable and list the top sellers.
  3. 84 Project: Invoice and Quote Template Build a reusable Excel invoice and quote template: clean layout, price-list lookups, discount and tax formulas, numbering, print setup and protection.
  4. 85 Project: Inventory and Reorder Tracker Build an Excel inventory sheet with reorder alerts, order quantities, conditional formatting, XLOOKUP item search and dashboard totals, step by step.
  5. 86 Project: Loan and Savings Planner Build an Excel loan and savings planner: a PMT amortization schedule, extra payments, FV savings goals and a what-if table, with runnable stand-ins.
  6. 87 Project: Gradebook or Employee Attendance Sheet Build two practical Excel sheets: a gradebook with weighted scores and grade bands, and an attendance tracker using NETWORKDAYS and COUNTIFS.

Practice and Review

  1. 88 Formula Exercises with Solutions Practice Excel formulas with 15 graded exercises on references, IF logic, SUMIFS, lookups, text and dates, each with a worked solution and a checker.
  2. 89 Data Analysis Exercises with Solutions Ten Excel data analysis exercises on cleaning, duplicates, PivotTables, charts and dynamic arrays, each with a worked answer and a runnable pandas stand-in.
  3. 90 Performance and Spreadsheet Best Practices Make Excel workbooks fast and trustworthy: volatile functions, recalculation cost, lookup speed, input-calculation-output structure, checks and the FAST standard.
  4. 91 Keyboard Shortcuts and Productivity Tricks Work faster in Excel: navigation, selection, editing, formatting and formula shortcuts, Paste Special, Quick Analysis and Go To Special, explained with examples.
  5. 92 Excel Interview Questions and Answers Forty common Excel interview questions, from cell references and IF to VLOOKUP, XLOOKUP, PivotTables and Power Query, with short answers and runnable demos.
  6. 93 Excel Cheat Sheet A one-page Excel quick reference: formulas by task, a lookup chooser, text and date patterns, error meanings and shortcuts, with links to the full lessons.