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

Data Analysis

  • Data Series in Excel
  • Error Bars in Excel
  • What-If Analysis: Scenarios and Goal Seek in Excel
  • Managing Conditional Formatting Rules in Excel
  • How to calculate current stock or inventory in Excel

References

  • Count rows that contain specific values in Excel
  • How to use Excel MATCH Function
  • Offset in Excel
  • How to get last row in numeric data in Excel
  • Find Closest Match in Excel Using INDEX, MATCH, ABS and MIN functions

Data Validations

  • Excel Data validation specific characters only
  • Prevent invalid data entering in specific cells
  • Excel Data validation allow weekday only
  • Excel Data validation allow uppercase only
  • Excel Data validation must contain specific text

Tag: LOGEST function

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

by

What is LOGEST function in Excel? LOGEST function is one of Statistical functions in Microsoft Excel that r In regression analysis, calculates an exponential curve that fits your data and returns an array of values that describes the curve. Because this function returns an array of values, it must be entered as an array formula.The …

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

  • SWITCH function: Description, Usage, Syntax, Examples and Explanation
  • SWITCH function example in Excel
  • Return blank if in Excel
  • AND function: Description, Usage, Syntax, Examples and Explanation
  • How to use Excel NOT Function

Date Time

  • Convert date to month and year in Excel
  • Get week number from date in Excel
  • Get last working day in month in Excel
  • DAYS360 function: Description, Usage, Syntax, Examples and Explanation
  • Get day name from date in Excel

Grouping

  • If cell contains one of many things in Excel
  • How to randomly assign data to groups in Excel
  • How to randomly assign people to groups in Excel
  • Map text to numbers in Excel
  • Group times into unequal buckets in Excel

General

  • Delete Blank Rows at Once in Excel
  • Count cells that do not contain many strings in Excel
  • Check if multiple cells have same value in Excel
  • Basic numeric sort formula in Excel
  • How to calculate percentage discount in Excel
© 2023 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning