Microsoft Excel Intermediate is a MySkill credential dated February 2026 focused on working with and presenting more complex spreadsheet data. The listed topics include lookups and INDEX/MATCH, mathematical, logical, information, text, and date/time functions, error handling, dynamic arrays, tables, and PivotTables. Formatting, charts, interactive charts, visualization practices, and print/page setup complete the scope, connecting formula-driven analysis with readable reports. No particular workbook or business result is specified in the source.
This credential is officially authenticated by the issuing platform. You can verify the public records and cryptographic validity directly.
Lookup and Index Match
Covers retrieving matching values using lookup formulas and INDEX/MATCH. A lookup key identifies a corresponding row; INDEX/MATCH separates finding the row from returning a value.
Data Formatting
Addresses consistent formatting of spreadsheet values and cells. It considers how numeric, date, and text formats affect interpretation without changing the underlying value.
Data Visualization
Covers presenting spreadsheet data visually to reveal patterns. The choice of visual form depends on whether the goal is comparison, composition, or change over time.
Chart
Introduces choosing and creating charts from worksheet data. Axes, labels, and series should reflect the source range so the chart remains interpretable.
Pivot Table
Covers summarizing and regrouping data with PivotTables. Fields can be moved between rows, columns, and values to compare the same data from different angles.
Intermediate Math Function
Explores mathematical functions beyond basic arithmetic formulas. Functions can combine calculations across ranges while reducing repeated manual steps.
Error Handling
Covers handling formula errors and unexpected spreadsheet results. Checking error types and input assumptions makes formulas easier to diagnose and maintain.
Table Features
Addresses organizing data with Excel table features. Structured references and table expansion help formulas stay aligned as rows are added.
Date and Time Manipulation
Covers calculating with and formatting dates and times. Date arithmetic and component extraction support intervals, schedules, and grouped reporting periods.
Logical and Information Function
Introduces logical tests and information functions in formulas. Logical functions combine conditions, while information functions help inspect the kind or state of a value.
Dynamic Array Formulas
Covers formulas that return results across multiple cells. Spilled results can populate adjacent cells, making some multi-row transformations possible with one formula.
Printing and Page Setup
Addresses preparing worksheets for printing and adjusting page layout. Print areas, scaling, and page breaks determine whether a worksheet remains legible on paper or as a PDF.
Referencing Cell and Text Formulas
Covers cell references and formulas that transform text. Relative and absolute references control how formulas change when copied; text functions help split or combine strings.
Interactive Charts
Explores charts that respond to changes in the underlying data. Changing source values or selections can update the view without rebuilding the chart from scratch.
Data Visualization Best Practices
Addresses clear chart choices and presentation of visualized data. Clear labels and proportionate scales reduce the chance that a chart misrepresents its source data.