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

Lookup and Reference Examples

  • Extract data with helper column in Excel
  • CHOOSE function: Description, Usage, Syntax, Examples and Explanation
  • How to use Excel COLUMN Function
  • How to calculate two-way lookup VLOOKUP in Excel Table
  • Get nth match with INDEX / MATCH in Excel

Data Analysis Examples

  • How to combine 2 or more chart types in a single chart in Excel
  • Conditional Formatting Rules in Excel
  • Conditional Formatting New Rule with Formulas in Excel
  • Excel Frequency Function Example
  • How to create running total in an Excel Table

Data Validation Examples

  • Excel Data validation whole percentage only
  • Excel Data validation allow uppercase only
  • Data validation must not exist in list
  • Excel Data validation allow weekday only
  • Excel Data validation only dates between

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
  • Remove line breaks in a cell in Excel
  • Change Case: Uppercase, Lowercase, Propercase in Excel
  • How to check if cell contains number in Excel
  • How to strip protocol and trailing slash from URL in Excel
  • Convert text to numbers using VALUE function in Excel
  • SECOND function: Description, Usage, Syntax, Examples and Explanation
  • Sum race time splits in Excel
  • Steps to create Dynamic calendar grid in Excel
  • How to get Holiday Date from Year in Excel
  • Create date range from two dates in Excel
  • Calculate loan interest in given year in Excel
  • How to set check register balance in Excel
  • TBILLYIELD function: Description, Usage, Syntax, Examples and Explanation
  • MDURATION function: Description, Usage, Syntax, Examples and Explanation
  • PRICEMAT function: Description, Usage, Syntax, Examples and Explanation
Acronyms, Abbreviations, Initialism & What They Stand For
© 2021 xlsoffice. All Rights Reserved | Teal Smiles