Sade bir dille her Excel kavramı. Bir terimin ne anlama geldiğinden emin değil misiniz? Sadece yapay zekaya sorun.
Pivot Table
Büyük tabloları, alanları sürükleyerek yeniden düzenleyebileceğiniz gruplanmış toplamlara özetleyen bir araç.
VLOOKUP
Bir tablonun ilk sütununda bir değer arayan ve aynı satırdaki başka bir sütundan değer döndüren işlev.
XLOOKUP
Herhangi bir sütunda arama yapıp eşleşme döndüren modern bir arama işlevi — varsayılan olarak tam eşleşme, sola veya sağa arama yapabilir.
Absolute Reference
Formülü kopyaladığınızda kaymaması için dolar işaretleriyle ($A$1) kilitlenmiş bir hücre başvurusu.
Conditional Formatting
Hücreler bir kuralı karşıladığında otomatik olarak uygulanan biçimlendirme (renkler, simgeler, çubuklar).
Named Range
Formüllerin koordinatlar yerine kelimeler gibi okunması için bir hücreye veya aralığa verilen okunabilir ad.
Dynamic Array
Birden çok sonuç döndüren ve bunların komşu hücrelere otomatik olarak "taştığı" bir formül.
Spill Range
Tek bir dinamik dizi formülünün doldurduğu, # son ekiyle başvurulan hücre bloğu.
Power Query
Verileri tekrarlanabilir ve yenilenebilir adımlarla içe aktarmak, temizlemek ve yeniden şekillendirmek için Excel'in yerleşik aracı.
Power Pivot
Milyonlarca satırı ve ilişkiyi DAX ölçüleriyle işleyen bir Excel veri modeli.
Macro (VBA)
Tekrarlayan Excel görevlerini otomatikleştiren, kaydedilmiş veya kodla yazılmış bir eylem dizisi.
Cell Reference
Bir hücrenin değerini almak için formülde kullanılan hücre adresi (B3 gibi).
Slicer
Bir pivot tabloyu veya tabloyu görsel olarak filtreleyen, tıklanabilir bir düğme paneli.
Data Validation
Açılır listeler dahil, bir hücreye nelerin yazılabileceğini kısıtlayan kurallar.
CSV File
Her satırın bir kayıt olduğu ve sütunları virgüllerin ayırdığı düz metin dosyası.
Workbook vs Worksheet
Çalışma kitabı tüm Excel dosyasıdır; çalışma sayfası ise içindeki bir sekmedir (sayfadır).
INDEX / MATCH
MATCH ile satır bulup INDEX ile değer döndüren, iki işlevli bir arama bileşimi.
Array Formula
Tek bir hücre yerine birden çok değer üzerinde aynı anda hesaplama yapan bir formül.
Pivot Chart
Verileri yeniden düzenlediğinizde, filtrelediğinizde veya ayrıntıya indiğinizde güncellenen, pivot tabloya bağlı bir grafik.
Goal Seek
Hedeflenen bir formül sonucuna ulaşmak için gereken giriş değerini bulan bir durum çözümleme aracı.
Solver
Kısıtlar altında birden çok girişi değiştirerek bir hedef hücreyi optimize eden bir eklenti.
Sparkline
Bir eğilimi bir bakışta göstermek için tek bir hücreye sığan minik bir grafik.
Circular Reference
Doğrudan ya da bir zincir üzerinden kendi hücresine başvuran ve bu yüzden çözülemeyen bir formül.
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.