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

Data Analysis

  • Get column name from index in Excel Table
  • How to sum a total in multiple Excel tables
  • Everything about Charts in Excel
  • Chart Axes in Excel
  • Randomize/ Shuffle List in Excel

References

  • Count unique text values with criteria
  • How to get address of named range in Excel
  • How to get last row in numeric data in Excel
  • Create hyperlink with VLOOKUP in Excel
  • How to use Excel VLOOKUP Function

Data Validations

  • How To Create Drop-down List in Excel
  • Excel Data validation must not contain
  • Excel Data validation with conditional list
  • Excel Data validation allow weekday only
  • Excel Data validation exists in list

Tag: FILTERXML function

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

by

What is FILTERXML function in Excel? FILTERXML function is one of Web functions in Microsoft Excel that returns specific data from the XML content by using the specified XPath. Notes: Microsoft introduced three new functions in Excel 2013 that will return data from a webservice. The FILTERXML function is not available in Excel Online, and it is …

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

  • How to use Excel FALSE Function
  • SWITCH function example in Excel
  • IF with boolean logic in Excel
  • OR function Examples in Excel
  • Check multiple cells are equal in Excel

Date Time

  • How to calculate months between dates in Excel
  • Add business days to date in Excel
  • Get days between dates in Excel
  • Convert text to date in Excel
  • Check If Two Dates are same month in Excel

Grouping

  • Calculate conditional mode with criteria in Excel
  • How to randomly assign people to groups in Excel
  • Map text to numbers in Excel
  • Group times into 3 hour buckets in Excel
  • Categorize text with keywords in Excel

General

  • Basic numeric sort formula in Excel
  • How to calculate percent of goal in Excel
  • How to generate random date between two dates in Excel
  • How to get original price from percentage discount in Excel
  • Excel Default Templates
© 2025 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning