Excel tutorials: learn Excel online, then practice it free

Step-by-step Excel guides on formulas, lookups, data cleaning, dashboards and interview preparation. Every tutorial links to free online Excel practice on Cellgrids, so you can try each formula in a live spreadsheet. For more, see the Excel knowledge hub, the complete Excel formulas list and Excel keyboard shortcuts.

• How to Use the XMATCH Function in Excel as a Better Version of MATCHLearn the XMATCH function in Excel: find a position with exact, wildcard or last-to-first search, and combine it with INDEX.
• How to Use the TEXTSPLIT Function in Excel to Split Text into ColumnsLearn the TEXTSPLIT function in Excel to split text by a comma, space or other character into columns or rows, with a formula that updates by itself.
• How to Use Data Validation in Excel to Stop Wrong EntriesLearn data validation in Excel: limit numbers and dates, create custom rules, add input messages and circle invalid data.
• How to Calculate a Running Total in ExcelLearn how to build a running total or cumulative sum in Excel with a simple SUM formula, and how to restart it for each category.
• How to Calculate Percentage Change in Excel (Increase and Decrease)Learn the percentage change formula in Excel for growth, decline and month-on-month reports, and how to handle zero and negative values.
• How to Look Up Data from Another Sheet or Workbook in ExcelLearn how to use VLOOKUP and XLOOKUP across sheets and workbooks, with correct sheet references and fixes for common errors.
• How to Remove Blank Rows in Excel Without Deleting Good DataLearn three safe ways to remove blank rows in Excel: Go To Special, filter and sort, plus how to avoid deleting rows with partial data.
• Excel Date Functions Explained: YEAR, MONTH, DAY, WEEKDAY and TEXTLearn the Excel date functions YEAR, MONTH, DAY, WEEKDAY and TEXT with examples to group sales by month, find the day of the week and build date columns.
• How to Sum Values by Month in Excel with SUMIFSLearn how to total sales by month in Excel using SUMIFS with start and end dates, so monthly reports update automatically.
• How to Use the SUBTOTAL Function in Excel to Total Only Visible RowsLearn the SUBTOTAL function in Excel to sum, count or average only the rows left visible after filtering, and how it differs from SUM.
• How to Compare Two Lists in Excel and Find What Is MissingLearn how to compare two lists in Excel with COUNTIF, XLOOKUP and conditional formatting, to find matches, missing items and differences.
• Excel Tables (Ctrl+T): 7 Reasons to Turn Your Data into a TableLearn why Excel Tables are better than plain ranges: automatic expansion, structured references, easy filtering and cleaner formulas.
• Excel Charts for Beginners: How to Pick the Right ChartLearn which Excel chart to use for trends, comparisons, shares and relationships, and how to make a clean chart in a few clicks.
• How to Use XLOOKUP to Return Multiple Columns at OnceLearn how XLOOKUP returns several columns with one formula, with a spill example, column pick and the errors to avoid.
• How to Use the UNIQUE Function in Excel to Get a List Without DuplicatesLearn the UNIQUE function in Excel: pull a clean list of distinct values with one formula, count unique items, and combine it with SORT and FILTER.
• How to Use the SORT Function in Excel to Sort Data AutomaticallyLearn the SORT and SORTBY functions in Excel to sort a table with a formula, sort by several columns, and keep the result updating when data changes.
• How to Use the IFS Function in Excel Instead of Nested IFLearn how the IFS function replaces long nested IF formulas in Excel, with grading, commission and status examples and the mistakes to avoid.
• IFNA vs IFERROR in Excel: How to Handle #N/A Errors SafelyLearn the IFNA function in Excel, how it differs from IFERROR, and why IFNA is the safer choice for lookup formulas.
• How to Use MAXIFS and MINIFS in Excel to Find the Highest or Lowest by ConditionLearn MAXIFS and MINIFS in Excel to find the highest or lowest value that meets one or more conditions, with simple examples.
• How to Use the WORKDAY Function in Excel to Add Business Days to a DateLearn WORKDAY and WORKDAY.INTL in Excel to calculate due dates that skip weekends and holidays, for SLA and delivery tracking.
• How to Use the EDATE Function in Excel to Add or Subtract MonthsLearn the EDATE function in Excel to add or subtract whole months from a date, for renewals, EMIs, contracts and subscriptions.
• How to Use LARGE and SMALL in Excel to Find the 2nd, 3rd or Nth ValueLearn the LARGE and SMALL functions in Excel to get the nth highest or lowest value, and build a top 5 or bottom 5 list.
• How to Use the NPV Function in Excel to Check if an Investment Is Worth ItLearn the NPV function in Excel step by step, including the common mistake with the first cash flow, with a simple project example.
• Absolute vs Relative References in Excel: What the $ Sign DoesUnderstand relative, absolute and mixed cell references in Excel and when to press F4, with examples that stop formulas breaking when copied.
• How to Convert Text to Numbers in Excel When SUM Shows 0Fix numbers stored as text in Excel using the green triangle, Paste Special, VALUE and Text to Columns, so SUM and lookups work again.
• How to Use the MATCH Function in Excel to Find the Position of a ValueLearn the MATCH function in Excel: find the row or column position of a value, with exact match, approximate match and INDEX MATCH examples.
• How to Use the OFFSET Function in Excel for Dynamic RangesLearn the OFFSET function in Excel to build moving ranges, rolling 3-month totals and dynamic drop-downs, and know when to avoid it.
• COUNT vs COUNTA vs COUNTBLANK in Excel: Which One to UseLearn the difference between COUNT, COUNTA and COUNTBLANK in Excel, with examples for counting filled, empty and numeric cells.
• How to Create and Use Named Ranges in ExcelLearn how to create named ranges in Excel, use them in formulas, and manage them in Name Manager so formulas are easier to read.
• How to Use Flash Fill in Excel to Split, Join and Clean Data in SecondsLearn Flash Fill in Excel with Ctrl+E: split names, join text, change case and extract numbers without writing formulas.
• How to Use a Formula in Conditional Formatting to Highlight Entire RowsLearn conditional formatting with a custom formula in Excel: highlight whole rows, overdue dates and duplicates with simple examples.
• How to Use VLOOKUP in Excel: Step-by-Step Beginner TutorialLearn how to use VLOOKUP in Excel step by step: lookup value, table array, column index and exact match, with examples and fixes for #N/A errors.
• XLOOKUP vs VLOOKUP: Which One Should You Use and Why?XLOOKUP vs VLOOKUP compared: syntax, left lookups, exact match by default and error handling, with side-by-side examples so you can pick the right one.
• How to Use INDEX and MATCH in Excel (With Real Examples)Learn INDEX MATCH in Excel with simple examples: look up values to the left, do two-way lookups and avoid the limits of VLOOKUP.
• Top 25 Excel Interview Questions for MIS ExecutivesTop Excel interview questions for MIS executives with short answers: VLOOKUP, pivot tables, SUMIFS, IF, data cleaning, dashboards and reporting tasks.
• How to Calculate Percentage in Excel: Formulas and FormattingHow to calculate percentage in Excel: percent of total, percentage increase and decrease, and how to format cells as percent so results show correctly.
• How to Use SUMIFS with Multiple Criteria Across ColumnsLearn SUMIFS with multiple criteria: sum by text, dates and numbers across columns, with clear examples and the most common mistakes explained.
• Top 15 Excel Practical Test Tasks for Data Analyst JobsThe 15 most common Excel practical test tasks in data analyst interviews, from cleaning data and lookups to pivot tables, with tips to finish on time.
• How to Combine First and Last Name in Excel (3 Easy Methods)Combine first and last name in Excel with the ampersand, CONCAT or TEXTJOIN. Includes how to add a space and handle middle names and blank cells.
• How to Use COUNTIFS in Excel with Dates and Text ValuesLearn the COUNTIFS formula in Excel: count rows that meet several conditions using text, dates, numbers and wildcards, with clear examples.
• How to Remove Duplicates in Excel Without Losing Original DataHow to remove duplicates in Excel using the Remove Duplicates button, the UNIQUE function and conditional formatting, without losing your original data.
• VLOOKUP with Approximate Match: How to Calculate Tax Brackets and GradesLearn VLOOKUP approximate match (TRUE) with real examples: grades, tax slabs and commission tiers. Know when to use TRUE vs FALSE and why sorting matters.
• How to Use IF Function with AND/OR Conditions in ExcelLearn the IF function with AND and OR in Excel: test multiple conditions, build nested IF formulas and avoid bracket mistakes, with simple examples.
• How to Extract Text Before or After a Specific Character in ExcelExtract text before or after a character in Excel with TEXTBEFORE, TEXTAFTER and the older LEFT, RIGHT and FIND formulas. Examples with emails and SKUs.
• How to Fix #N/A, #VALUE!, and #REF! Errors in ExcelFix common Excel formula errors: #N/A, #VALUE!, #REF!, #DIV/0! and #NAME?. Learn what causes each one and how to use IFERROR and IFNA properly.
• What Is Dynamic Array in Excel? FILTER, SORT, and UNIQUE ExplainedUnderstand dynamic array formulas in Excel: spill ranges, the # operator, and how FILTER, SORT, UNIQUE and SEQUENCE replace complex manual work.
• How to Use the FILTER Function in Excel with Multiple ConditionsUse the FILTER function in Excel with AND and OR conditions. Learn the syntax, how to show a message when there are no results, and common errors.
• How to Create an Excel Drop-Down List Using Data ValidationHow to create a drop-down list in Excel with data validation: from a typed list or a range, dynamic lists and dependent drop-downs, step by step.
• 20 Excel Shortcuts Every Data Analyst Needs to Know20 Excel keyboard shortcuts every data analyst needs: navigate, select data, add filters, auto-sum and edit formulas faster, with Windows key combinations.
• How to Use TEXTJOIN in Excel with Delimiters and Ignore BlanksLearn the TEXTJOIN formula in Excel: join text with commas or any delimiter, skip blank cells, and build comma-separated lists from ranges or filters.
• How to Highlight Duplicates in Excel Using Conditional FormattingHighlight duplicates in Excel with conditional formatting: use the built-in rule, a COUNTIF formula, and highlight the entire duplicate row.
• How to Calculate Age from Date of Birth in Excel (DATEDIF Formula)Calculate age from date of birth in Excel using DATEDIF and TODAY: get years, months and days, and understand common errors and leap year behaviour.
• How to Freeze Panes in Excel (Rows and Columns Simultaneously)How to freeze panes in Excel: lock the top row, first column or both so headers stay visible while you scroll. Includes how to unfreeze.
• How to Transpose Data in Excel: Paste Special vs TRANSPOSE FormulaHow to transpose data in Excel: switch rows to columns with Paste Special or the TRANSPOSE function, and learn which method suits static or live data.
• How to Use Wildcards (* and ?) in Excel FormulasLearn Excel wildcards: use * and ? in COUNTIF, SUMIF, VLOOKUP and XLOOKUP to match partial text, plus how to search for a real asterisk with the tilde.
• Excel Test for Employment: What Hiring Managers Look ForWhat to expect in an Excel test for employment: skills hiring managers check, typical tasks, scoring, and how to prepare with timed online practice.
• How to Split Text into Columns in Excel (Delimited Data Cleanup)Split text into columns in Excel using Text to Columns or the TEXTSPLIT function. Clean CSV exports with commas, pipes and spaces in a few steps.
• How to Use the SEQUENCE Function to Generate Number ListsLearn the SEQUENCE function in Excel: create serial numbers, repeating patterns and date lists that update by themselves, with simple examples.
• How to Calculate Working Days Between Dates in Excel (NETWORKDAYS)Calculate working days between two dates in Excel with NETWORKDAYS and NETWORKDAYS.INTL. Exclude weekends and holidays, and set custom weekends.
• How to Find the Top 3 Values in Excel (LARGE and SORT Functions)Find the top 3 values in Excel with LARGE, and return matching names using INDEX MATCH, SORT or TAKE. Works for top 5, top 10 and bottom values with SMALL.
• How to Protect Formulas in Excel While Allowing Data EntryProtect formulas in Excel while still letting people type in input cells: unlock input cells, lock formulas, protect the sheet and hide formulas if needed.
• How to Use the SUMIF Function in Excel (With Examples)Learn the SUMIF function in Excel: add numbers that meet one condition using text, numbers, dates and wildcards, with clear examples and common mistakes.
• AVERAGEIF and AVERAGEIFS in Excel: Average With ConditionsLearn AVERAGEIF and AVERAGEIFS in Excel: find the average of values that meet one or many conditions, with examples for text, numbers and dates.
• How to Use the COUNTIF Function in Excel (With Examples)Learn COUNTIF in Excel: count cells that equal, contain or exceed a value, count duplicates and blanks, with simple examples and common mistakes.
• How to Use the IFERROR Function in ExcelLearn the IFERROR function in Excel: replace errors like #N/A and #DIV/0! with a clean value, with examples for VLOOKUP and division, and when not to use it.
• LEFT, RIGHT and MID Functions in Excel: Extract Text EasilyLearn LEFT, RIGHT and MID in Excel: pull characters from the start, end or middle of text, with examples for codes, phone numbers and dates.
• How to Remove Extra Spaces in Excel (TRIM Function)Remove extra spaces in Excel with the TRIM function: fix leading, trailing and double spaces, plus non-breaking spaces that TRIM misses.
• How to Use the SUBSTITUTE Function in Excel (Replace Text)Learn SUBSTITUTE in Excel to replace text inside a cell: remove characters, replace the nth match, and clean phone numbers and codes, with examples.
• ROUND, ROUNDUP and ROUNDDOWN in Excel: Rounding Numbers CorrectlyLearn how to round numbers in Excel with ROUND, ROUNDUP, ROUNDDOWN, MROUND and CEILING, and why formatting is not the same as rounding.
• TODAY and NOW Functions in Excel: Insert the Current Date and TimeLearn the TODAY and NOW functions in Excel: show the current date and time, calculate days left, and keep a static date with a shortcut.
• How to Use the EOMONTH Function in Excel (End of Month Dates)Learn EOMONTH in Excel to find month-end dates, the first day of a month and due dates, with examples for reports and billing cycles.
• How to Rank Values in Excel (RANK, RANK.EQ and Ties)Learn how to rank values in Excel with RANK, RANK.EQ and RANK.AVG, rank within groups, and handle ties for leaderboards and sales reports.
• MAX, MIN, MEDIAN and MODE in Excel: Find the Highest, Lowest and MiddleLearn MAX, MIN, MEDIAN and MODE in Excel, plus MAXIFS and MINIFS to find the highest or lowest value with conditions, with examples.
• How to Use the HLOOKUP Function in ExcelLearn HLOOKUP in Excel: look up a value across the top row and return a value from a row below, with syntax, an example and when to use XLOOKUP instead.
• How to Use the INDIRECT Function in Excel (With Examples)Learn the INDIRECT function in Excel: turn text into a cell reference, pull data from sheets by name, and build dependent drop-down lists.
• How to Use the CHOOSE Function in ExcelLearn the CHOOSE function in Excel: pick a value from a list by number, convert numbers to names, and build simple scenario switches.
• How to Use the PMT Function in Excel to Calculate Loan EMILearn the PMT function in Excel to calculate monthly loan EMI and payments: interest rate, number of periods and loan amount, with a worked example.
• XLOOKUP with Multiple Criteria in Excel: Match on Two or More ColumnsHow to use XLOOKUP with multiple criteria in Excel: match on two or more columns using the multiplication method or a combined key, with examples.
• How to Use the SUMPRODUCT Function in Excel (With Examples)Learn SUMPRODUCT in Excel: multiply and add arrays, calculate weighted averages, and count or sum with multiple conditions without helper columns.
• How to Use the TEXT Function in Excel to Format Numbers and DatesLearn the TEXT function in Excel: format numbers, dates and times inside a formula, such as month names, leading zeros and currency, with examples.
• How to Count Characters in Excel (LEN Function)Count characters in Excel with the LEN function: total characters in a cell, specific letters, words and characters in a range, with examples.
• Excel Interview Questions for Data Analyst Roles (With Answers)Excel interview questions for data analyst roles with short answers: lookups, pivot tables, data cleaning, dynamic arrays and analysis scenarios.
• Excel Interview Questions for Business Analyst Roles (With Answers)Excel interview questions for business analyst roles: reporting, KPIs, lookups, pivot tables, forecasting and dashboards, with short sample answers.
• Excel Interview Questions for Accountants and Finance RolesExcel interview questions for accountants and finance roles: reconciliation, VLOOKUP, SUMIFS, pivot tables, PMT, NPV and financial reporting tasks.
• Excel Interview Questions for Freshers: Basic to IntermediateExcel interview questions for freshers with simple answers: basic formulas, formatting, sorting, filters, lookups and pivot tables for entry-level jobs.
• How to Create a Pivot Table in Excel: Step-by-Step for BeginnersLearn how to create a pivot table in Excel step by step: prepare data, drag fields, group dates, add filters and slicers, and fix common problems.
• How to Make a Dashboard in Excel: Beginner GuideLearn how to make a dashboard in Excel: plan KPIs, prepare data, build pivot tables and charts, add slicers and keep a clean, readable layout.
• VLOOKUP Not Working in Excel? 8 Reasons and FixesVLOOKUP not working in Excel? Fix #N/A and wrong results: extra spaces, numbers stored as text, wrong column index, approximate match and more.
• Excel vs Power BI: Which Should You Learn First?Excel vs Power BI compared for data analytics and business analytics careers: strengths, limits, learning curve and the best order to learn them.
• SQL vs Excel for Data Analysis: When to Use WhichSQL vs Excel for data analysis: compare size limits, speed, ease of use and typical tasks, with a simple guide to choosing and combining them.
• How to Learn Excel Fast for a Job: A Step-by-Step PlanA step-by-step plan to learn Excel fast for a job: what to learn first, how to practice online, formulas to master and how to prepare for tests.

Start free Excel practice →