For IndividualsFor Analysts & FinanceFor Students & LearnersFor Teams & Automation
MENU
=DIRECTORY.OFFICIAL

Official Microsoft Excel documentation

Microsoft's own Excel pages — function references, support articles, Microsoft Learn modules, and the product documentation behind every feature.

96 resources / 1 sections / 5,123 words of notes

Some outbound links may be affiliate or sponsored, and those are labeled where they appear. Ordering is editorial either way — nothing here is placed for money. Full disclosure.

Official Microsoft96

Excel Help & Learning (opens in a new tab)

Structured into three sections: Help articles covering individual tasks, a function reference with syntax and argument-level detail for every worksheet function, and a Training section with free self-paced courses running from basic navigation to Power Query and Pivot Charts. The search covers all three and returns official Microsoft content rather than third-party answers, which makes it the right first stop before a forum.

Microsoft Excel (opens in a new tab)

The official Microsoft page to compare subscription plans, check what ships in Microsoft 365 Personal, Family, and Business tiers versus a standalone licence, and download the desktop application. It also links to the web and mobile apps, covers what is available on each platform, and explains what Microsoft 365 adds over the perpetual editions.

About Power Query in Excel (opens in a new tab)

Microsoft's introductory page explains what Power Query is, why it replaced older import methods, and how the Get & Transform feature fits into modern Excel data workflows. A useful first read before diving into queries, as it sets the context for when and why to use this data-transformation toolset inside Excel.

Add or Remove Add-ins in Excel (opens in a new tab)

Covers both COM add-ins, which are installed programs like Analysis ToolPak and Solver, and newer Office add-ins available from the store. Microsoft's instructions explain how to turn built-in add-ins on or off, troubleshoot ones that have gone inactive, and cleanly remove extensions you no longer need from within Excel settings.

Analyze Data in Excel (opens in a new tab)

Microsoft's guide to a lesser-known but powerful feature that lets you type plain-English questions about your data and receive suggested charts, summaries, and trend insights automatically. No formula knowledge or pivot setup is required, making it a surprisingly fast way to surface patterns and anomalies in a dataset you have just imported.

Basic Tasks in Excel (opens in a new tab)

Microsoft's official starting point for anyone new to Excel, walking through the complete beginner workflow from creating and saving your first workbook to entering data, writing formulas, applying cell formatting, and inserting a chart. If you have never used the application before, or want a structured refresher that comes straight from the source, start here.

Combine Text from Two or More Cells (opens in a new tab)

Merging first names with last names, joining city and country fields, or building dynamic labels from multiple columns all rely on text concatenation. This Microsoft reference explains the available approaches—the ampersand operator, CONCAT, and TEXTJOIN—including how to add separators, handle empty cells, and choose the method that best fits your formula logic.

Consolidate Worksheets into One PivotTable (opens in a new tab)

When your data is spread across several worksheets with the same structure, such as monthly sales tabs or regional breakdowns, this Microsoft guide shows how to consolidate them into one PivotTable report without stacking the data manually first. A time-saving technique for recurring reporting workflows where source data arrives in separate sheets each period.

Convert PivotTable Cells to Worksheet Formulas (opens in a new tab)

PivotTables are excellent for exploration but can be constraining when you need a specific layout or custom formatting for a final report. This Microsoft guide explains how to convert selected PivotTable cells into GETPIVOTDATA worksheet formulas, preserving the calculated values while freeing you to rearrange rows, merge cells, and apply whatever formatting the final presentation requires.

COUNTIF Function (opens in a new tab)

When you need a quick tally of how many cells in a range meet a single criterion, this function handles it in one argument pair. The official page covers syntax, shows how to use comparison operators, wildcards, and cell references as the criteria argument, and provides worked examples for text, numbers, and dates.

COUNTIFS Function (opens in a new tab)

Where COUNTIF handles a single condition, COUNTIFS extends the concept to two or more simultaneously. Microsoft's reference details how each criteria range and criteria pair must match the same row, explains wildcard and operator usage within each criterion, and shows practical examples for segmenting and auditing dataset records with layered conditions.

Create a Chart from Start to Finish (opens in a new tab)

Walk through every step of chart-making in Excel, from selecting the right chart type for your data to adding titles, legend formatting, and axis labels. Microsoft's official tutorial covers common chart types and customization options, making it suitable whether you're building a simple bar chart or a more polished business presentation visual.

Create a Drop-down List (opens in a new tab)

Restricting cell entries to an approved list improves consistency and prevents typos in shared workbooks. This official Microsoft page walks through every method for setting up drop-down lists—from a simple range of values to dynamic named ranges and table-based sources—and explains how to configure error messages when someone enters something outside the allowed options.

Create a PivotTable to Analyze Worksheet Data (opens in a new tab)

The hands-on starting point for PivotTables on Microsoft Support, walking through how to select source data, insert a PivotTable, drag fields into the rows, columns, and values areas, and apply slicers or filters. Also covers starting from a data model rather than a flat range, which is the foundation for multi-table analysis in Excel.

Create and Format Tables (opens in a new tab)

Turning a plain data range into a structured table unlocks automatic filtering, banding, and dynamic formula references that grow with your data. This official walkthrough covers how to create and style tables, adjust the header row, add total rows, and work with the sorting and filter tools that become available the moment you apply a table format.

Create Your First Budget (opens in a new tab)

Taking control of your personal or household finances often starts with a single spreadsheet. Microsoft walks beginners through picking a budget template, entering income and expense categories, tracking actuals against a plan, and using built-in formulas so totals update automatically each time you record a new transaction.

Create, Load, or Edit a Query (opens in a new tab)

Step-by-step instructions from Microsoft covering the core mechanics of working with Power Query: starting a new query from an external or internal data source, loading the resulting table to a worksheet or data model, and reopening the editor whenever transformations need to be adjusted. The practical hands-on companion to any Power Query overview.

Define and Use Names in Formulas (opens in a new tab)

Assigning meaningful names to cells, ranges, or constant values transforms cryptic formulas into readable ones and makes spreadsheet logic easier to share with colleagues. This official reference explains how to create names in the Name Box and Name Manager, scope them to a worksheet or workbook, and apply them in formulas to replace hard-to-follow cell address references.

Download Free Pre-built Templates (opens in a new tab)

A Microsoft Support article that explains how to locate, download, and open the free prebuilt templates available across Office applications, including Excel. Practical for users who are not yet familiar with the template gallery workflow or who need guidance on where to find the right starting-point file for a particular task or document type.

Examples of Commonly Used Formulas (opens in a new tab)

Rather than defining every function abstractly, Microsoft has assembled a practical example collection organized around real-world calculation scenarios. Formulas for conditional logic, lookup operations, date arithmetic, financial calculations, and statistical summaries are shown with actual data examples that you can adapt directly to your own spreadsheets without having to build from scratch.

Excel Add-in Quickstart (opens in a new tab)

A fast-path introduction for developers who want to see a working Excel add-in in their browser within minutes. This Microsoft Learn quickstart uses Visual Studio to scaffold the project, walks through the manifest structure, and demonstrates the basic JavaScript interaction with the workbook, giving developers a functional baseline they can modify into a real add-in.

Excel Add-ins Documentation (opens in a new tab)

For developers building task panes, custom functions, or contextual commands that extend Excel's capabilities, this Microsoft Learn section is the authoritative reference. It covers the full add-in development lifecycle from project scaffolding and manifest configuration through to JavaScript API patterns that read and write workbook data, respond to user events, and interact with ranges.

Excel Blog - Microsoft Tech Community (opens in a new tab)

The official Excel team blog, published on Microsoft's Tech Community platform, where product managers and engineers announce new features, explain design decisions, and share tips for recent releases. Following this feed is one of the most reliable ways to learn what is coming to Excel before the formal documentation and help articles catch up.

Excel Calendar Templates (opens in a new tab)

Planning monthly events, tracking deadlines, or building a yearly schedule becomes faster when you start from a ready-made layout. This Microsoft Support page walks through locating calendar templates in Excel and the web-based version, customizing dates and colors, and adapting the design for your particular scheduling or personal productivity needs.

Excel Custom Functions Overview (opens in a new tab)

When Excel's built-in function library doesn't cover a specialized calculation, custom functions let developers define their own. This Microsoft Learn overview explains how custom functions work within the add-in framework, how to declare them in a metadata JSON file, handle asynchronous data fetches, stream live values into cells, and debug function logic during development.

Excel Functions Alphabetical (opens in a new tab)

When you know a function's name but need to verify its syntax, required arguments, or return behavior, this straight-from-Microsoft A-to-Z index gets you there in seconds. The full function catalog is organized alphabetically so you can scan quickly and jump directly to the official documentation page for any worksheet function.

Excel Functions by Category (opens in a new tab)

Browsing the official function library by topic rather than name makes it easier to discover the right tool when you know what you need to calculate but not which function handles it. Organized into groups such as lookup, statistical, financial, text, and date functions, this Microsoft reference is the fastest path from a task to the right formula.

Excel JavaScript API Overview (opens in a new tab)

Building a task pane or content add-in for Excel requires understanding how the JavaScript API exposes workbook objects. This Microsoft Learn overview explains the request-response model, how to batch multiple operations for performance, and how to work with worksheets, ranges, tables, charts, and events inside a custom Excel add-in.

Excel JavaScript API Reference (opens in a new tab)

Building a custom Excel add-in means working through the Excel JavaScript API, and this Microsoft Learn reference documents every object, method, property, and event available at each API requirement level. Developers can look up workbooks, worksheets, ranges, tables, charts, and dozens of other objects to understand the exact interfaces available before writing or reviewing their add-in code.

Excel Keyboard Shortcuts (opens in a new tab)

Spending less time on the mouse translates directly into faster work, and this comprehensive Microsoft reference catalogs shortcuts for navigation, formatting, formulas, selections, and more across Windows, macOS, and the browser version of Excel. Everything is organized by category so you can scan quickly for the combinations most relevant to your workflow.

Excel Stocks and Geography Data Types (opens in a new tab)

Rather than manually looking up current stock prices or capital cities, Excel's linked data types pull live information directly into your cells from Microsoft's data sources. This guide explains how to tag cells as Stocks or Geography data types, extract specific properties, and refresh the data so your worksheets stay current without any external imports.

FILTER Function (opens in a new tab)

Rather than using AutoFilter to hide rows, this dynamic array function returns only the rows that meet your criteria into a separate spill range, updating automatically when the source data changes. Microsoft's reference covers single and multiple conditions, what to return when no matches are found, and combining it with other array functions.

Filter Unique Values or Remove Duplicates (opens in a new tab)

Two related but distinct operations are covered on this official page: temporarily surfacing only distinct values through the Advanced Filter, and permanently deleting exact-duplicate rows using the Remove Duplicates tool. Understanding the difference helps you choose the right approach when cleaning imported datasets or auditing lists before analysis.

Find and Correct Errors in Formulas (opens in a new tab)

#VALUE!, #REF!, #NAME?, #DIV/0!—each error code points to a specific underlying problem, and tracking it down can be time-consuming without the right approach. This official Microsoft guide walks through every major formula error, explains what causes each one, and demonstrates the auditing tools and tracing features built into Excel to help you pinpoint and fix the issue.

Free Excel for the Web Templates (opens in a new tab)

Anyone with a Microsoft account can access these no-cost starting points directly in the browser without installing desktop Excel. The guide points you to Microsoft Create's template gallery and explains how to open, personalize, and save the templates within the online version of Excel for immediate use.

Freeze Panes to Lock Rows and Columns (opens in a new tab)

When a spreadsheet extends far enough that headers scroll off screen, freeze panes keeps them in view no matter how far down or across you navigate. This official guide covers every option: locking the top row, locking the first column, or fixing both at a custom position using the split-pane technique.

Fundamentals for Office Scripts in Excel (opens in a new tab)

Before writing complex automation, it helps to understand how TypeScript interacts with Excel's core objects. This Microsoft Learn guide walks through the fundamental building blocks of Office Scripts, covering how to access and modify workbooks, navigate worksheets, read and write range values, and manipulate charts and tables with code.

Get an Office Add-in for Excel (opens in a new tab)

A user-oriented walkthrough from Microsoft explaining how to browse the add-in store from directly within Excel, install an add-in with a few clicks, and then launch it from the ribbon or task pane. Useful if you have heard about a specific Excel extension but are unsure how to locate and activate it without leaving the application.

How Power Query and Power Pivot Work Together (opens in a new tab)

Two of Excel's most powerful features complement each other rather than compete: Power Query handles the messy work of connecting, cleaning, and reshaping data, while Power Pivot lets you build relationships between tables and write DAX measures. This official page clarifies when to use each tool and how they hand off data.

How to Avoid Broken Formulas (opens in a new tab)

Prevention is easier than debugging, and this official Microsoft guide focuses on habits and practices that keep formulas working reliably as worksheets change. Topics include avoiding hard-coded values, using absolute references correctly, keeping cell types consistent, and understanding how Excel recalculates so modifications to one part of a workbook don't silently break formulas elsewhere.

IF Function (opens in a new tab)

Branching logic sits at the heart of most practical spreadsheets, and this official reference covers the IF function in full: how to structure the logical test, what to return when it evaluates to true or false, and how to nest multiple IFs or combine them with AND and OR for more complex conditions.

Import and Analyze Data in Excel (opens in a new tab)

A hub in Microsoft Support that groups together the essential techniques for getting data into Excel and making sense of it afterward. Topics span connecting to external sources, cleaning raw data, sorting and filtering records, building charts, and structuring data models, making it a useful starting point for any data-focused worksheet workflow.

Learn Power Query and Power Pivot (opens in a new tab)

Power Query and Power Pivot are most effective when used together, and this Microsoft article explains how they complement each other: Power Query for importing and shaping data, Power Pivot for modeling and writing DAX measures. A useful orientation for Excel users ready to move beyond single-table analysis into relational data workflows.

LET Function (opens in a new tab)

Long, repetitive formulas that recalculate the same sub-expression multiple times can be simplified with this function, which assigns a name to a calculation and then reuses it. Microsoft's reference covers the syntax for defining multiple name-value pairs, how scoping works, and how LET improves both performance and readability in complex nested formulas.

Make Excel Documents Accessible (opens in a new tab)

Spreadsheets used by people with disabilities require thoughtful structure, and this official Microsoft page covers the specific changes that make the biggest difference: adding alt text to charts and images, checking reading order, improving worksheet tab names, choosing accessible color contrasts, and running the Accessibility Checker to find and address potential barriers before sharing a file.

Manage Your Household Budget in Excel (opens in a new tab)

Tracking what comes in and what goes out at the household level gets easier with an Excel template built for the purpose. This official guide covers entering regular income, categorizing everyday expenses, spotting overspending with conditional formatting, and using PivotTables or charts to review your financial picture at a glance.

Microsoft AppSource Excel Add-ins (opens in a new tab)

The curated app store for Excel extensions, hosted by Microsoft, where publishers list add-ins that have passed review and are available for one-click installation from within Excel. Filtering by category helps narrow down tools for specific needs, from analytics and reporting integrations to specialized industry tools built on the Office add-in platform.

Microsoft Balance Sheet Templates (opens in a new tab)

Ready-to-use Excel workbooks for presenting a company's assets, liabilities, and equity in a standard financial format are organized here by Microsoft. Whether you are preparing statements for a small business, learning accounting principles, or producing a formatted summary for stakeholders, these templates give you the structural scaffolding so you can focus on entering actual figures.

Microsoft Business Spreadsheet Templates (opens in a new tab)

A broad collection of professionally formatted Excel workbooks covering common business needs such as profit and loss statements, expense reports, invoices, project timelines, and operational trackers. Accessing these official Microsoft templates saves considerable time when standing up standard business documents without the overhead of building formatting and formulas entirely from scratch.

Microsoft Community Excel (opens in a new tab)

The community support forum where everyday Excel users post questions and receive answers from peers and Microsoft-certified community agents. Browsing existing threads often surfaces solutions to formula errors, compatibility issues, and feature-behavior questions faster than searching documentation, and discussions cover all skill levels from basic spreadsheet setup to complex workbook troubleshooting scenarios.

Microsoft Create Excel Templates (opens in a new tab)

Templates ready to open directly in Excel are organized here across dozens of categories, from personal budgets and home planners to business-focused spreadsheets. Each file is made by Microsoft and opens in your browser or desktop app without a separate download step, giving you a fully formatted starting point instead of a blank workbook.

Microsoft Excel Add-in Tutorial (opens in a new tab)

Aimed at developers who want hands-on experience building their first Office add-in, this Microsoft Learn project tutorial walks from initial project creation in Visual Studio through writing JavaScript that reads and writes worksheet data, finishing with a fully functional task-pane panel embedded inside Excel. The recommended starting point before reading the broader add-in documentation.

Microsoft Excel Add-ins Help (opens in a new tab)

Not all of Excel's most powerful analytical tools are visible by default, and this Microsoft guide explains the range of built-in add-ins that extend the application's capabilities. Covers tools like Analysis ToolPak for statistical functions, Solver for optimization problems, and Power Pivot for large-scale data modeling, with instructions for enabling each one.

Microsoft Excel Cloud Templates (opens in a new tab)

Prebuilt Excel files spanning personal finance, operations, scheduling, and business administration are available from this official Microsoft gallery. Templates open directly in Excel for the web or desktop, with structured layouts and formatting already in place so you can add your own data rather than spending time on design from scratch.

Microsoft Excel Credentials (opens in a new tab)

The certification pathway for Excel proficiency runs through Microsoft Learn, and this page lists the exams and credentials that include Excel as a core subject. Whether preparing for a Microsoft Office Specialist exam or exploring broader Microsoft 365 certifications, this is where to find official credential requirements and their associated learning paths.

Microsoft Excel Dashboard Tutorial (opens in a new tab)

Building a dashboard in Excel involves more than just charts, and this official Microsoft walkthrough covers combining multiple visual elements, designing a layout that communicates at a glance, and sharing the finished file with a Microsoft 365 group. Practical for anyone who has learned individual Excel features and wants to bring them together into a polished reporting view.

Microsoft Graph Excel Workbooks (opens in a new tab)

Applications that need to read or modify Excel workbooks stored in OneDrive or SharePoint without running Excel locally can do so through the Microsoft Graph API. This reference covers available operations for workbooks, worksheets, tables, ranges, charts, and named items—along with authentication requirements and endpoint examples for developers building integrations with Microsoft 365 data.

Microsoft Inventory Templates (opens in a new tab)

A focused collection from Microsoft of ready-made spreadsheets designed for tracking stock levels, supplies, and physical assets. Whether you are managing a small business stockroom, a home office supply list, or equipment records, these official templates provide the column structure, pre-built formulas, and formatting needed to start recording and monitoring inventory levels right away.

Microsoft Inventory Tracker (opens in a new tab)

Specifically oriented toward building a running inventory log rather than just downloading a static template, this Microsoft page walks through the key elements of an effective stock-tracking spreadsheet. Useful if you want to understand how to structure and maintain inventory data in Excel, with guidance that goes beyond simply handing you a bare template file.

Microsoft Marketplace Excel Apps (opens in a new tab)

Browse and discover third-party applications and extensions that integrate directly with Excel through this Microsoft-hosted marketplace. Each listing has been submitted through Microsoft's official channel, so you can find add-ins spanning data visualization, financial modeling, project management, and database connectivity while having reasonable confidence about compatibility and the review process behind publication.

Microsoft Q&A for Office (opens in a new tab)

A more technical peer support space on Microsoft Learn where developers, IT professionals, and power users ask and answer specific questions about Microsoft 365 applications. Questions that go deeper than typical user forum posts, such as API behavior, licensing edge cases, and integration issues, tend to get more detailed and technically precise responses here.

Office Add-in Code Samples (opens in a new tab)

Working code is often the fastest way to understand how an API fits together, and this Microsoft Learn collection provides ready-to-run samples covering task panes, custom functions, data access, event handling, and more for Excel and other Office applications. Each sample includes source code and setup instructions so developers can study or adapt real patterns directly.

Office Add-ins Platform Overview (opens in a new tab)

Understanding the architecture of Office add-ins before writing the first line of code saves considerable time later. This Microsoft Learn overview explains how web-based task panes, content add-ins, and custom functions plug into Excel through the add-in manifest, how the JavaScript API handles communication, and how add-ins are deployed, tested, and distributed to end users.

Office JavaScript API Reference (opens in a new tab)

The top-level reference hub on Microsoft Learn that links out to the full JavaScript API documentation for each Office application, including Excel. Developers looking for object schemas, method signatures, property descriptions, and version availability flags for Excel add-in development will use this as their entry point to the complete API reference tree.

Office Scripts API Reference (opens in a new tab)

Every object, method, and property available when writing TypeScript-based Office Scripts is documented here on Microsoft Learn. Whether you need to manipulate ranges, iterate through worksheets, or work with charts and tables programmatically, this reference tells you exactly what the API exposes and how each member behaves in your scripts.

Office Scripts Dev Center (opens in a new tab)

Aimed at developers and power users building automation around Excel, this Microsoft hub aggregates code samples, API documentation, and guidance for connecting Office Scripts to Power Automate flows. A central starting point if you are building reusable automation patterns rather than one-off macros, or exploring what the scripting platform can do at scale.

Office Scripts Documentation (opens in a new tab)

The complete technical documentation for Office Scripts lives here on Microsoft Learn, covering everything from scripting fundamentals and the Excel object model to advanced topics like passing data between scripts and integrating with Power Automate. Bookmark this if you are actively writing or debugging scripts rather than just exploring the concept.

Office Scripts in Excel (opens in a new tab)

Microsoft's introduction to a modern, TypeScript-based approach to Excel automation that runs in the browser and integrates with Power Automate. Unlike VBA, Office Scripts are platform-independent and can be triggered by cloud workflows, making them a better choice for teams using Excel on the web or in Microsoft 365 environments.

Office Scripts Samples (opens in a new tab)

Learning by example is often the fastest path to writing your own automation. This Microsoft Learn page gathers ready-to-run script samples organized by scenario, covering tasks like formatting worksheets, combining data from multiple sheets, integrating with Power Automate flows, and performing common spreadsheet operations without opening the workbook manually.

Overview of Formulas in Excel (opens in a new tab)

Understanding how Excel evaluates formulas requires knowing how references, operators, and nested functions interact, and this official Microsoft guide lays out all of it in one place. An excellent foundation for anyone who writes formulas beyond simple arithmetic and wants to understand why a formula behaves the way it does before troubleshooting or optimizing calculations.

Overview of PivotTables and PivotCharts (opens in a new tab)

Before building your first PivotTable or PivotChart, reading Microsoft's conceptual overview helps you understand what these tools are doing with your data. The page explains how PivotTables group and aggregate values, how PivotCharts stay synchronized with their underlying pivot, and when each tool is the better choice for communicating a particular analytical insight.

Pivot Columns in Power Query (opens in a new tab)

When row data needs to be restructured so each unique value in a column becomes a separate column header, Power Query's Pivot Column feature handles the transformation cleanly. This Microsoft page covers selecting the column to pivot, choosing an aggregation method such as Sum or Count, and reviewing the reshaped output table.

Power Pivot Overview and Learning (opens in a new tab)

The gateway into Excel's in-memory analytical engine, this Microsoft resource explains how Power Pivot extends what standard PivotTables can do by letting you relate multiple tables, work with millions of rows, and write DAX measures for calculations that would be impossible with ordinary formulas. Essential reading before tackling serious data modeling inside Excel.

Power Query Applied Steps (opens in a new tab)

Every transformation in Power Query is recorded in the Applied Steps panel, creating an audit trail you can review, reorder, rename, or delete at any time. This Microsoft Learn guide explains how to insert or modify steps mid-sequence and how to read the M code each step generates—useful for debugging transformations or merging queries built by different people.

Power Query Connectors (opens in a new tab)

Power Query's value depends on what data sources it can reach, and this Microsoft Learn connector reference documents every supported connection: databases, cloud services, files, APIs, and more. Each connector entry covers authentication options, supported query folding capabilities, and any platform-specific limitations—essential reading before building a data pipeline that pulls from an unfamiliar or enterprise source.

Power Query Documentation (opens in a new tab)

The full technical documentation for Power Query lives on Microsoft Learn, covering everything from connecting to data sources and applying transformations to writing M code and understanding how query evaluation works. Whether you use Power Query inside Excel, Power BI, or another Microsoft product, this is the authoritative reference for all platform features.

Power Query M Formula Language (opens in a new tab)

When the visual editor in Power Query is not enough, the M formula language gives you full programmatic control over your transformations. This Microsoft Learn reference documents M syntax, the full function library, type system, and combiners in detail, making it the essential resource for anyone writing or debugging custom M code beyond what the editor generates automatically.

Power Query Query Folding (opens in a new tab)

When Power Query can translate your transformations into a query the source database executes natively, the data engine handles the heavy lifting rather than pulling everything into memory first. This Microsoft Learn guide explains what query folding is, why it dramatically improves performance for large datasets, how to verify whether a step folds, and which transformations tend to break folding.

Power Query User Interface (opens in a new tab)

Before writing any M code or building complex transformations, getting comfortable with the Power Query editor itself pays dividends. This Microsoft Learn guide tours the ribbon, the Queries pane, the data preview, the Applied Steps panel, and the formula bar, explaining what each part does so you can navigate confidently and spot where to make changes without hunting through menus.

QuickStart: Learn DAX Basics (opens in a new tab)

DAX can feel intimidating at first, but this half-hour Microsoft tutorial breaks it down by walking through calculated columns, measures, and evaluation contexts with real examples from a data model. If you understand Excel formulas and want to start writing meaningful DAX expressions for Power Pivot, this is the right place to begin.

Save a Workbook as a Template (opens in a new tab)

Once you have built a workbook with the right structure, formulas, and formatting, saving it as a template means every future file can start from that foundation. This Microsoft guide covers the file-type settings and storage location needed to make your custom template appear in the New workbook menu alongside Microsoft's own templates.

Share a Power Query (opens in a new tab)

Power Query logic does not have to stay locked inside one workbook. This Microsoft Learn guide explains the options for exporting, sharing, and reusing queries across files or with colleagues, covering connection-only queries, template files, and dataflow options so that data-cleaning work done once can benefit multiple spreadsheets or team members going forward.

SORT Function (opens in a new tab)

Unlike the Sort button, this formula-based approach places a sorted copy of your data anywhere in the worksheet and updates automatically when the source changes. Microsoft's reference covers sorting by one or multiple columns, specifying ascending or descending order for each sort key, and sorting rows instead of columns when needed.

Split Text into Different Columns (opens in a new tab)

Imported data often arrives with multiple pieces of information crammed into one cell—names, addresses, or codes separated by commas, spaces, or fixed widths. This official walkthrough shows how the Convert Text to Columns wizard handles both delimited and fixed-width text, letting you cleanly separate values before starting any analysis or formatting work.

SUM Function (opens in a new tab)

Totaling a column of numbers is one of the first things new Excel users learn, and SUM is the function behind it. Microsoft's reference page covers the full syntax, explains how to sum ranges, individual cells, or mixed arguments, and demonstrates the difference between SUM and simply chaining addition operators together.

SUMIFS Function (opens in a new tab)

When totaling data based on more than one condition, SUMIFS gives you precise control over which rows contribute to the result. Microsoft's reference explains the required arguments, how to use comparison operators and wildcards within criteria, and how to apply date ranges or text patterns to filter the values you want to add.

Switch Between Relative, Absolute, and Mixed References (opens in a new tab)

Whether a cell reference moves with the formula or stays anchored to a fixed location is determined by dollar signs that most beginners overlook. This official Microsoft page explains when to use relative, absolute, and mixed references, how to toggle between them with F4, and why getting this right is essential for building formulas that copy correctly across rows and columns.

UNIQUE Function (opens in a new tab)

Extracting a deduplicated list from messy data used to require complex workarounds; this dynamic array function does it in a single formula that spills results automatically. Microsoft's reference explains both exact-duplicate and distinct-occurrence modes, how to apply the function to columns instead of rows, and how to combine it with SORT for clean output.

Use Conditional Formatting to Highlight Information (opens in a new tab)

Visual cues applied directly to cells can surface patterns and outliers that raw numbers hide. This official Microsoft page covers the full range of conditional formatting tools—from simple highlight rules and top-N rankings to multi-tone color scales, data bar comparisons, and icon sets—plus how to write custom formula-based rules for more nuanced conditions.

Use Multiple Tables to Create a PivotTable (opens in a new tab)

Going beyond a single flat table unlocks much more powerful analysis, and this Microsoft guide explains how to load multiple related tables into the Excel data model and build a PivotTable that spans all of them. The key technique for anyone whose data lives across separate sheets or sources that share a common linking key.

Use Sparklines to Show Data Trends (opens in a new tab)

Compact visualizations that live inside a single cell can reveal trends without taking up space on your dashboard. This official page explains how to insert line, column, and win/loss sparklines, control their appearance, and group or ungroup them to highlight patterns across rows or columns of worksheet data.

Using Structured References with Excel Tables (opens in a new tab)

Once data lives in an Excel table, formulas can reference it by column name rather than by cell address—making them far easier to read and maintain as the table grows. This Microsoft guide explains the structured reference syntax, how to refer to entire column, header, and totals rows, and how these references behave when copied across the table.

VLOOKUP Function (opens in a new tab)

One of the most widely used functions in Excel, VLOOKUP searches the first column of a table for a value and returns data from a specified column in the same row. Microsoft's official page covers syntax, the critical difference between exact and approximate matching, and common causes of errors like #N/A.

What Is Power Query (opens in a new tab)

A conceptual introduction on Microsoft Learn that explains the problem Power Query solves, how it fits into the broader ETL landscape, and what kinds of transformations it handles well. Reading this before diving into tutorials gives you a clearer mental model of how queries work, what applied steps represent, and why the tool is structured the way it is.

When to Use Power Query or Office Scripts (opens in a new tab)

Both tools automate Excel tasks, but they suit different situations. Microsoft Learn explains the key tradeoffs: Power Query works best for repeatable data-transformation pipelines, while Office Scripts is better suited for procedural logic, UI interactions, and Power Automate integration. Read this before committing to one approach for your next automation project.

XLOOKUP Function (opens in a new tab)

A more flexible replacement for VLOOKUP and HLOOKUP, this function searches any range or array and returns a matching result without being limited to leftmost columns or exact match behavior. Microsoft's reference page covers all six arguments, including the optional match mode and search mode for approximate, wildcard, and binary search scenarios.