Skip to content
xlsoffice. All Rights Reserved
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Lookup and Reference Examples

  • How to use Excel OFFSET function
  • Complete List of Excel Lookup and Reference Functions, References and Examples
  • Find Closest Match in Excel Using INDEX, MATCH, ABS and MIN functions
  • Last row number in range
  • Two-column Lookup in Excel

Data Analysis Examples

  • How to create a Histogram in Excel
  • Reverse List in Excel
  • How to count table columns in Excel
  • Create Scatter Chart in Excel
  • Everything about Charts in Excel

Data Validation Examples

  • Excel Data validation exists in list
  • Excel Data validation whole percentage only
  • Excel Data validation no punctuation
  • Excel Data validation date in next 30 days
  • Data validation must not exist in list

Tag: Analysis ToolPak

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

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

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

How to perform 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 Below you can find the study hours of 6 female students and 5 male students. H0: …

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
  • How to create email address with name and domain in Excel
  • How to get last word in a cell in Excel
  • Split numbers from units of measure in Excel
  • How to compare two text strings in Excel
  • Remove text by position in a cell in Excel
  • Get first Monday before any date in Excel
  • Assign points based on late time in Excel
  • MONTH function: Description, Usage, Syntax, Examples and Explanation
  • Check If Two Dates are same month in Excel
  • TIMEVALUE function: Description, Usage, Syntax, Examples and Explanation
  • Bond valuation example in Excel
  • YIELDDISC function: Description, Usage, Syntax, Examples and Explanation
  • ODDLPRICE function: Description, Usage, Syntax, Examples and Explanation
  • YIELDMAT function: Description, Usage, Syntax, Examples and Explanation
  • How to calculate compound interest in Excel
© 2022 xlsoffice . All Right Reserved. | Teal Smiles