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

Data Analysis

  • How to combine 2 or more chart types in a single chart in Excel
  • Understanding Anova in Excel
  • Number and Text Filters Examples in Excel
  • How to do a t-Test in Excel?
  • Excel Line Chart

References

  • INDEX function: Description, Usage, Syntax, Examples and Explanation
  • How to use Excel ROW Function
  • How to get first column number in range in Excel
  • How to get relative row numbers in a range in Excel
  • How to get relative column numbers in a range in Excel

Data Validations

  • Excel Data validation must begin with
  • Data validation must not exist in list
  • Excel Data validation exists in list
  • Excel Data validation date in specific year
  • Excel Data validation no punctuation

Tag: TIMEVALUE function

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

by

What is TIMEVALUE function in Excel? TIMEVALUE function is one of  Date and Time functions in Microsoft Excel that returns the decimal number of the time represented by a text string. The decimal number is a value ranging from 0 (zero) to 0.99988426, representing the times from 0:00:00 (12:00:00 AM) to 23:59:59 (11:59:59 P.M.). Syntax of TIMEVALUE …

Continue Reading

Convert date string to date time in Excel

by

This tutorial shows how to Convert date string to date time in Excel using example below. To convert a date string to a datetime (date with time) you can parse the text into separate components then build a proper datetime. When date information from other systems is pasted or imported to Excel, it may not …

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
  • How to use Excel AND Function
  • IFNA function: Description, Usage, Syntax, Examples and Explanation
  • How to use Excel OR Function
  • Check multiple cells are equal in Excel

Date Time

  • Display Days until expiration date in Excel
  • Roll back weekday to Friday base on a particular date in Excel
  • DATEDIF function: Description, Usage, Syntax, Examples and Explanation
  • Convert text date dd/mm/yy to mm/dd/yy in Excel
  • Custom weekday abbreviation in Excel

Grouping

  • How to randomly assign data to groups in Excel
  • Group arbitrary text values in Excel
  • Categorize text with keywords in Excel
  • Calculate conditional mode with criteria in Excel
  • Group numbers at uneven intervals in Excel

General

  • How to calculate percent of students absent in Excel
  • Find, Trace and Correct Errors in Excel Formulas using ‘Formula Auditing’
  • AutoRecover file that was never saved in Excel
  • Convert column letter to number in Excel
  • Delete Blank Rows at Once in Excel
© 2023 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning