Skip to content
Free Excel Tutorials
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Data Analysis

  • What-If Analysis: Scenarios and Goal Seek in Excel
  • Randomize/ Shuffle List in Excel
  • Conditional Formatting Rules in Excel
  • Subtotal function in Excel
  • How to add Trendline to a chart in Excel

References

  • Create hyperlink with VLOOKUP in Excel
  • How to get last row in numeric data in Excel
  • How to use Excel VLOOKUP Function
  • How to use Excel INDIRECT Function
  • Basic INDEX MATCH approximate in Excel

Data Validations

  • Excel Data validation must contain specific text
  • Excel Data validation allow uppercase only
  • Excel Data validation exists in list
  • Excel Data validation date in specific year
  • Excel Data validation number multiple 100

Tag: Analysis ToolPak

How to calculate correlation coefficient Correlation in Excel

by

Find out how to calculate correlation coefficient between two data arrays in Microsoft Excel through the CORREL function. The correlation coefficient (a value between -1 and +1) tells you how strongly two variables are related to each other. We can use the CORREL function or the Analysis Toolpak add-in in Excel to find the correlation coefficient between two variables. – A correlation coefficient of +1 indicates a …

Continue Reading

Excel Frequency Function Example

by

The FREQUENCY function in Excel calculates how often values occur within the ranges you specify in a bin table. You can also use the COUNTIFS function to create a frequency distribution. 1. First, enter the bin numbers (upper levels) in the range C4:C8. 2. Select the range D4:D9 (extra cell), enter the FREQUENCY function shown below and finish by pressing …

Continue Reading

How To Load Analysis ToolPak in Excel

by

The Analysis ToolPak is an Excel add-in program that provides data analysis tools for financial, statistical and engineering data analysis. You provide the data and parameters for each analysis, and the tool uses the appropriate statistical or engineering macro functions to calculate and display the results in an output table. Some tools generate charts in addition to output tables. …

Continue Reading

How to do a t-Test in Excel?

by

To test null hypothesis for unequal variance This example teaches you how to perform a t-Test in Excel. The t-Test is used to test the null hypothesis that the means of two populations are equal. Steps in running a t-test in Excel I have Group 1 (female)  and Group 2 (male) test scores of a classroom. I need …

Continue Reading

Understanding Anova in Excel

by

How to Perform Analyses of Variance in Excel This example teaches you how to perform a single factor ANOVA (analysis of variance) in Excel. A single factor or one-way ANOVA is used to test the null hypothesis that the means of several populations are all equal. Below you can find the salaries of people who have a degree …

Continue Reading

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others

Logical Functions

  • IF function: Description, Usage, Syntax, Examples and Explanation
  • Extract multiple matches into separate rows in Excel
  • How to use Excel TRUE Function
  • SWITCH function example in Excel
  • Complete List of Excel Logical Functions, References and Examples

Date Time

  • Add days exclude certain days of week in Excel
  • How to get same date next month or previous month in Excel
  • YEARFRAC function: Description, Usage, Syntax, Examples and Explanation
  • Count birthdays by month in Excel
  • Get last working day in month in Excel

Grouping

  • Map inputs to arbitrary values in Excel
  • Group times into 3 hour buckets in Excel
  • If cell contains one of many things in Excel
  • Running count group by n size in Excel
  • Group times into unequal buckets in Excel

General

  • Find, Select, Replace and Go To Special in Excel
  • How to get original number from percent change in Excel
  • Flash Fill in Excel
  • Cell References: Relative, Absolute and Mixed Referencing Examples
  • Check if range contains a value not in another range in Excel
© 2026 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning