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

Data Analysis

  • Calculate Conditional Percentile ‘IF’ in table in Excel
  • Conditional Formatting Color Scales Examples in Excel
  • Understanding Pivot Tables in Excel
  • How To Load Analysis ToolPak in Excel
  • Data Series in Excel

References

  • How to get relative row numbers in a range in Excel
  • Lookup entire row in Excel
  • MATCH function: Description, Usage, Syntax, Examples and Explanation
  • Multi-criteria lookup and transpose in Excel
  • CHOOSE function: Description, Usage, Syntax, Examples and Explanation

Data Validations

  • Excel Data validation whole percentage only
  • Excel Data validation only dates between
  • Excel Data validation must begin with
  • Excel Data validation specific characters only
  • Excel Data validation date in next 30 days

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

  • Excel If, Nested If, And/Or Criteria Examples
  • Return blank if in Excel
  • IF with boolean logic in Excel
  • SWITCH function: Description, Usage, Syntax, Examples and Explanation
  • How to use Excel FALSE Function

Date Time

  • Basic Overtime Calculation Formula in Excel
  • Roll back weekday to Friday base on a particular date in Excel
  • MONTH function: Description, Usage, Syntax, Examples and Explanation
  • Get project end date in Excel
  • TIMEVALUE function: Description, Usage, Syntax, Examples and Explanation

Grouping

  • How to randomly assign people to groups in Excel
  • Map inputs to arbitrary values in Excel
  • Group times into 3 hour buckets in Excel
  • Group times into unequal buckets in Excel
  • If cell contains one of many things in Excel

General

  • Excel Ribbon Quick Overview For Beginners
  • Check if multiple cells have same value in Excel
  • How to calculate percent of goal in Excel
  • Basic numeric sort formula in Excel
  • Zoom Worksheet in Excel
© 2025 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning