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

Data Analysis

  • Filter Data Based on Date in Excel
  • Conditional Formatting Color Scales Examples in Excel
  • Error Bars in Excel
  • Chart Axes in Excel
  • Randomize/ Shuffle List in Excel

References

  • VLOOKUP function: Description, Usage, Syntax, Examples and Explanation
  • Offset in Excel
  • Basic INDEX MATCH approximate in Excel
  • Extract all partial matches in Excel
  • Find Closest Match in Excel Using INDEX, MATCH, ABS and MIN functions

Data Validations

  • Data validation must not exist in list
  • Excel Data validation require unique number
  • Excel Data validation allow weekday only
  • Excel Data validation number multiple 100
  • Excel Data validation must contain specific text

Tag: SLOPE function

SLOPE function: Description, Usage, Syntax, Examples and Explanation

by

What is SLOPE function in Excel? SLOPE function is one of Statistical functions in Microsoft Excel that returns the slope of the linear regression line through data points in known_y’s and known_x’s. The slope is the vertical distance divided by the horizontal distance between any two points on the line, which is the rate of change …

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

  • AND function: Description, Usage, Syntax, Examples and Explanation
  • IFERROR function: Description, Usage, Syntax, Examples and Explanation
  • IF with wildcards in Excel
  • IFS function: Description, Usage, Syntax, Examples and Explanation
  • Complete List of Excel Logical Functions, References and Examples

Date Time

  • Convert date string to date time in Excel
  • How to get same date next month or previous month in Excel
  • DATE function: Description, Usage, Syntax, Examples and Explanation
  • Sum race time splits in Excel
  • How to get year from date in Excel

Grouping

  • How to randomly assign data to groups in Excel
  • Categorize text with keywords in Excel
  • Map text to numbers in Excel
  • Calculate conditional mode with criteria in Excel
  • How to randomly assign people to groups in Excel

General

  • 3D SUMIF for multiple worksheets in Excel
  • How to generate random date between two dates in Excel
  • Count cells that do not contain many strings in Excel
  • Excel Default Templates
  • How to fill cell ranges with random text values in Excel
© 2026 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning