Todos os conceitos do Excel em linguagem simples. Não tem certeza do que um termo significa? Basta perguntar à IA.
Pivot Table
Uma ferramenta que resume tabelas grandes em totais agrupados que você reorganiza arrastando campos.
VLOOKUP
Uma função que procura um valor na primeira coluna de uma tabela e retorna um valor de outra coluna na mesma linha.
XLOOKUP
Uma função de pesquisa moderna que examina qualquer coluna e retorna uma correspondência — exata por padrão e capaz de pesquisar à esquerda ou à direita.
Absolute Reference
Uma referência de célula bloqueada com cifrões ($A$1) para que não se desloque ao copiar a fórmula.
Conditional Formatting
Formatação (cores, ícones, barras) aplicada automaticamente quando as células atendem a uma regra.
Named Range
Um nome legível atribuído a uma célula ou intervalo para que as fórmulas se leiam como palavras em vez de coordenadas.
Dynamic Array
Uma fórmula que retorna vários resultados que se "derramam" automaticamente nas células vizinhas.
Spill Range
O bloco de células que uma única fórmula de matriz dinâmica preenche, referenciado com o sufixo #.
Power Query
A ferramenta integrada do Excel para importar, limpar e remodelar dados com etapas repetíveis e atualizáveis.
Power Pivot
Um modelo de dados do Excel que lida com milhões de linhas e relações, com medidas DAX.
Macro (VBA)
Uma sequência de ações gravada ou programada que automatiza tarefas repetitivas do Excel.
Cell Reference
O endereço de uma célula (como B3) usado em uma fórmula para obter o valor dela.
Slicer
Um painel de botões clicáveis que filtra visualmente uma tabela dinâmica ou tabela.
Data Validation
Regras que restringem o que pode ser digitado em uma célula, incluindo listas suspensas.
CSV File
Um arquivo de texto simples em que cada linha é um registro e as vírgulas separam as colunas.
Workbook vs Worksheet
Uma pasta de trabalho é todo o arquivo do Excel; uma planilha é uma guia (folha) dentro dele.
INDEX / MATCH
Uma combinação de pesquisa de duas funções que encontra uma linha com MATCH e retorna um valor com INDEX.
Array Formula
Uma fórmula que realiza cálculos em vários valores de uma vez, em vez de uma única célula.
Pivot Chart
Um gráfico vinculado a uma tabela dinâmica que se atualiza ao reorganizar, filtrar ou detalhar os dados.
Goal Seek
Uma ferramenta de teste de hipóteses que encontra o valor de entrada necessário para atingir um resultado de fórmula desejado.
Solver
Um suplemento que otimiza uma célula de destino alterando várias entradas sob restrições.
Sparkline
Um gráfico minúsculo que cabe em uma única célula para mostrar uma tendência rapidamente.
Circular Reference
Uma fórmula que se refere à própria célula, diretamente ou por uma cadeia, e por isso não consegue ser resolvida.
Excel Table
A structured data range that enables automatic formatting, filtering, and dynamic referencing.
Structured Reference
A syntax used in Excel tables that refers to table data by name rather than cell coordinates.
LAMBDA Function
A function that allows you to create and name custom, reusable formulas without using VBA.
LET Function
The LET function assigns names to calculation results, allowing you to store intermediate values within a formula.
Flash Fill
A feature that automatically fills data in a column by detecting patterns in your manual entries.
Fill Handle
The small green square at the bottom-right corner of a selected cell used to copy data or extend a series.
Format Painter
A tool that copies formatting from one cell or range and applies it to another.
Name Box
The Name Box is the input field located to the left of the formula bar that displays the address of the currently selected cell or the name of a selected range.
Range
A range is a collection of two or more cells in a worksheet.
Mixed Reference
A cell reference that locks either the row or the column using a single dollar sign.
R1C1 Reference Style
A reference system where both rows and columns are identified by numbers instead of the standard A1 column-letter format.
3D Reference
A 3D reference allows you to analyze data across the same cell or range of cells on multiple worksheets.
Volatile Function
A function that recalculates every time any change is made to the worksheet.
Scenario Manager
A what-if analysis tool that allows you to save and switch between different sets of input values for a model.
Data Table (What-If)
A range of cells that shows how changing one or two variables in a formula affects the results.
Trace Precedents
A feature that draws arrows to show which cells provide data to a selected formula.
Wildcard
Special characters used to represent one or more unknown characters in search, filter, and function criteria.
Delimiter
A delimiter is a character used to specify the boundary between separate, independent regions in data.
Gridlines
Gridlines are the faint horizontal and vertical lines that appear between cells in an Excel worksheet to help distinguish them.
Active Cell
The currently selected cell in a spreadsheet that is ready to receive data or commands.
AutoSum
A feature that automatically detects and sums a range of adjacent cells.
AutoFilter
A feature that adds dropdown arrows to column headers to filter or sort data in a table or range.
Subtotal Feature
A data analysis tool that automatically inserts summary rows and calculates subtotals for grouped data in a list.
Custom Number Format
A set of codes used to define how numeric values appear in a cell without changing the underlying data.
Cell Comment
A cell comment is an annotation or note attached to a specific cell to provide additional context or instructions.
Hyperlink
A clickable connection in a cell that directs users to a URL, file, or specific location within a workbook.
Watch Window
A floating panel that allows you to monitor the values of specific cells across different worksheets or workbooks in real-time.
Pivot Cache
A Pivot Cache is an internal, memory-resident snapshot of the source data used to power a PivotTable.
Calculated Field
A custom data field created within a PivotTable using a formula based on other existing fields in the data source.
Defined Name
A descriptive label assigned to a cell, range, constant, or formula to make it easier to reference in calculations.
Dynamic Named Range
A named range that automatically expands or contracts to include new data as it is added or removed.
Add-in
An add-in is a supplemental program that adds custom commands and specialized features to Excel.
Combo Chart
A visualization that combines two or more different chart types into a single display.
Waterfall Chart
A visualization that shows the cumulative effect of sequentially introduced positive or negative values.
Histogram
A chart that displays the frequency distribution of a dataset by grouping values into continuous intervals called bins.
Freeze Panes
A feature that locks specific rows or columns in place so they remain visible while scrolling through a worksheet.
Table Header Row
The top row of an Excel table that contains descriptive labels for each column.
Absolute vs Relative Reference
Relative references adjust when copied to new cells, while absolute references remain fixed using dollar signs.
XLOOKUP if_not_found
An optional argument in the XLOOKUP function that specifies a custom value to return when no match is found.
Spill Error
A #SPILL! error occurs when a dynamic array formula cannot return its results because the destination range is obstructed.
Cell
A cell is the fundamental rectangular unit in a worksheet formed by the intersection of a specific row and column.
Worksheet
A single grid of cells within an Excel workbook used for data entry and analysis.
Formula Bar
The Formula Bar is the input field located above the worksheet grid used to view, enter, and edit data or formulas in the active cell.
Function Argument
An argument is a value, cell reference, or expression provided to an Excel function to perform a calculation.
Nested Function
A nested function is a function that is placed as an argument within another function.
Operator
An operator is a symbol that specifies the type of calculation or comparison to perform within a formula.
Boolean Value
A logical data type that represents one of two states: TRUE or FALSE.
Error Value
A special value displayed in a cell when Excel cannot correctly calculate a formula.
Text String
A sequence of characters treated as text data rather than numeric or logical values.
Concatenation
Concatenation is the process of joining two or more text strings into a single cell.
Exact vs Approximate Match
A setting in lookup functions that determines whether to search for an identical value or the nearest value in a sorted list.
Sort
Sort is the process of reordering rows in a dataset based on the values in one or more columns.
Filter
A feature that hides rows in a dataset that do not meet specified criteria.
Data Bar
A conditional formatting feature that displays a horizontal bar within a cell to represent the relative magnitude of its value.
Color Scale
A conditional formatting tool that applies a color gradient to a range of cells based on their numeric values.
Icon Set
A conditional formatting feature that displays specific icons in cells based on their numerical values.
Trendline
A visual line added to a chart that represents the general direction or pattern of data points over time.
Data Series
A data series is a group of related data points plotted in a chart.
Chart Axis
A chart axis is the reference line along the side or bottom of a chart that defines the scale and categories of the plotted data.
Legend
A chart element that identifies the data series represented by specific colors, patterns, or markers.
Data Label
A text element attached to a specific data point or series in a chart that displays its exact value or category name.
Secondary Axis
A second vertical axis added to a chart to display data series that use different scales or units.
Scatter Plot
A chart type that displays paired numeric data as individual points on an X and Y axis to show relationships or correlations.
Heat Map
A data visualization technique that uses color gradients to represent values within a grid or table.
Paste Special
A feature that allows you to paste specific elements of copied data, such as values, formulas, or formatting, rather than the entire cell content.
Transpose
A feature that converts vertical data ranges into horizontal ones, and vice versa.
Text to Columns
A feature that splits the contents of a single column into multiple columns based on a specified delimiter or fixed character width.
Outlier
An outlier is a data point that differs significantly from other observations in a dataset.
Normalization
The process of scaling numerical data to a common range, typically between 0 and 1, to allow for fair comparison.
Aggregation
Aggregation is the process of combining multiple rows of data into a single summary value.
Group By
A data transformation operation that organizes rows into categories based on a common key to perform aggregate calculations.
Cross Tabulation
A two-dimensional table that displays the joint frequency distribution of two categorical variables.
Descriptive Statistics
A set of summary measures that describe and interpret the main features of a dataset.
Regression Analysis
A statistical method used to estimate the relationship between a dependent variable and one or more independent variables.
Correlation
A statistical measure ranging from -1 to 1 that indicates the strength and direction of the relationship between two variables.
Variance
Variance measures how far a set of numbers are spread out from their average value.
Standard Deviation
A measure of how spread out a set of numbers is from their average value.
Percentile
A measure indicating the value below which a given percentage of observations in a group of data falls.
Moving Average
A calculation used to analyze data points by creating a series of averages of different subsets of the full data set.
Forecast
A function that predicts future values based on existing historical data using linear regression.
Time Series
A sequence of data points indexed in chronological order, typically at successive uniform intervals.
KPI
A measurable value that demonstrates how effectively a company or individual is achieving key business objectives.
Dashboard
A dashboard is a visual interface that consolidates key metrics and charts into a single view for monitoring performance.
Data Model
A Data Model is a collection of related tables integrated within an Excel workbook to enable complex data analysis.
DAX
DAX is a library of functions and operators used in Power Pivot and Power BI to build custom calculations and data models.
Measure
A dynamic calculation created using DAX that aggregates data based on the current context in a report.
ETL
A data integration process used in Power Query to move data from source systems into Excel for analysis.
Join
A join is an operation that combines rows from two tables based on a common key column.
Primary Key
A primary key is a column in a table where each value is unique and identifies a specific row.
Wide vs Long Format
Wide format stores data across many columns, while long format organizes data into key-value rows.
Spreadsheet
A digital grid-based document composed of cells used for organizing, analyzing, and calculating data.
Row
A row is a horizontal series of cells in a spreadsheet, identified by a unique number on the left side of the interface.
Column
A column is a vertical series of cells in a spreadsheet, identified by a letter at the top.
Cell Address
A unique identifier for a cell, composed of its column letter and row number.
Sheet Tab
A clickable label at the bottom of the Excel window used to navigate between different worksheets in a workbook.
Page Break
A separator that dictates where a worksheet is split into separate pages during the printing process.
Print Area
A specific range of cells designated to be printed instead of the entire worksheet.
Split Panes
A feature that divides the worksheet window into separate, independently scrollable sections.
AutoComplete
A feature that automatically suggests and completes text entries based on existing data in the same column.
Track Changes
A feature that records edits made to a shared workbook, allowing users to review and accept or reject modifications.
Version History
A feature that tracks and saves previous iterations of a cloud-based workbook, allowing users to restore earlier states.
Co-authoring
Co-authoring allows multiple users to edit the same Excel workbook simultaneously in real-time.
Cell Style
A predefined collection of formatting attributes that can be applied to a cell or range in a single click.
Theme
A theme is a predefined set of colors, fonts, and graphic effects applied to an entire workbook to ensure a consistent professional appearance.
Format Cells
A comprehensive dialog box used to customize the appearance and data representation of selected cells.
Alignment
Alignment refers to the horizontal and vertical positioning of content within an Excel cell.
Number Format
A setting that controls how a cell's value appears visually without altering the underlying data.
Currency Format
A number format that displays a currency symbol alongside numeric values with a fixed number of decimal places.
Percentage Format
A display format that multiplies a cell value by 100 and appends a percent sign.
Scientific Notation
A numeric format that represents very large or very small numbers as a mantissa multiplied by a power of ten.
Thousands Separator
A formatting symbol, typically a comma, used to group digits in large numbers to improve readability.
Date Serial Number
A unique integer representing a specific date, calculated as the number of days elapsed since January 1, 1900.
Custom List
A user-defined sequence of data used for consistent sorting and AutoFill operations.
Advanced Filter
A data tool that filters lists using complex criteria defined in a separate range, with the option to extract results to a new location.
Consolidate
A data tool used to summarize and merge data from multiple ranges or worksheets into a single master worksheet.
Outline
A feature that allows you to group rows or columns into collapsible levels to summarize data.
Input Message
An Input Message is a pop-up tooltip that appears when a user selects a cell configured with data validation.
Error Alert
A dialog box that appears when a user enters data that violates defined data validation rules.
Form Control
Interactive objects placed directly on a worksheet to simplify data entry and user interaction.
Developer Tab
A specialized ribbon tab in Excel used for advanced tasks like macros, VBA, and form controls.
User Defined Function
A custom function created using VBA to perform calculations or tasks not available in standard Excel functions.
Linked Data Type
A rich cell value that connects to an online service to retrieve and display multiple related data points.
Analyze Data
An AI-powered feature that automatically generates charts, pivot tables, and insights from your data range.
Forecast Sheet
A feature that creates a visual forecast chart based on historical time-series data with a single click.
Quick Analysis
A context-aware tool that provides instant access to common data analysis features like formatting, charts, and totals.
Unpivot
A Power Query transformation that converts wide data with multiple columns into a long, normalized format with key-value pairs.
Merge Query
A Power Query operation that combines two tables by matching rows based on a common key column.
Append Query
An operation in Power Query that combines multiple tables by stacking their rows on top of each other.
Data Type Detection
The process where Power Query automatically analyzes column values to assign appropriate data types like text, number, or date during data import.
Smart Fill
A feature that automatically detects patterns in your data to complete a column or range based on your initial entries.