Spreadsheets Tutorials

This tutorial discusses the purpose and syntax of the XLOOKUP Excel function, its advantages concerning its predecessors, the two main ways of using XLOOKUP with multiple criteria including their pros and cons, extending functionality through the optional parameters, and the way of running a similar search in older Excel versions.

Learn to calculate factorials in Excel with ease. Discover FACT, FACTDOUBLE, GAMMA functions, and more to solve mathematical and real-world problems.

In this tutorial, we'll explore what percentiles are, what they are used for, the ways of calculating them in Excel, simple examples of such calculations, and possible errors to be aware of when computing percentiles in Excel.

A beginner-friendly, comprehensive tutorial in mastering the HLOOKUP function in Microsoft Excel.

A step-by-step guide on performing linear regression in Excel, interpreting results, and visualizing data for actionable insights.

Learn how to add arithmetic, string, time series, and complex formulas in Microsoft Excel.

Discover the power of Regular Expressions (RegEx) for pattern matching in Excel. Our comprehensive guide unveils how to standardize data, extract keywords, and perform advanced text manipulations.

Boost your data analysis skills with our step-by-step guide on how to analyze, manipulate and write back data in Google Sheets using Python.

Learn about Excel's various data visualization options that can help you analyze and interpret your data.

In this article, learn how import excel files into R with the readxl library.

Learn how to read and import Excel files in Python, write data to these spreadsheets, and find the best packages to do this.

Learn everything you need to know about how to create a dashboard in Excel, with tips and examples.