Category
Technologies
Spreadsheets Tutorials
Learn more about spreadsheets for data analysis, visualisation, and processing. Our spreadsheet tutorials include tips & tricks for various spreadsheets applications.
Other technologies:
How to Calculate Confidence Intervals in Excel
A beginner-friendly, comprehensive tutorial on understanding Confidence Interval calculations in Microsoft Excel.
Arunn Thevapalan
April 26, 2024
How to Use the XLOOKUP Excel Function with Multiple Criteria
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.
Elena Kosourova
April 12, 2024
How to Calculate Factorials in Excel: A Complete Guide
Learn to calculate factorials in Excel with ease. Discover FACT, FACTDOUBLE, GAMMA functions, and more to solve mathematical and real-world problems.
Elena Kosourova
March 26, 2024
How to Calculate Percentiles in Excel
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.
Elena Kosourova
March 21, 2024
How to Use HLOOKUP in Excel
A beginner-friendly, comprehensive tutorial in mastering the HLOOKUP function in Microsoft Excel.
Arunn Thevapalan
March 7, 2024
Linear Regression in Excel: A Comprehensive Guide For Beginners
A step-by-step guide on performing linear regression in Excel, interpreting results, and visualizing data for actionable insights.
Natassha Selvaraj
March 7, 2024
The 15 Basic Excel Formulas Everyone Needs to Know
Learn how to add arithmetic, string, time series, and complex formulas in Microsoft Excel.
Abid Ali Awan
December 15, 2023
Excel Regex Tutorial: Mastering Pattern Matching with Regular Expressions
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.
Chloe Lubin
December 14, 2023
How to Analyze Data in Google Sheets With Python: A Step-By-Step Guide
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.
Filip Schouwenaars
May 18, 2023
Visualizing Data in Excel
Learn about Excel's various data visualization options that can help you analyze and interpret your data.
Jess Ahmet
April 27, 2023
Reading and Importing Excel Files Into R With readxl
In this article, learn how import excel files into R with the readxl library.
Vidhi Chugh
March 10, 2023
Python Excel Tutorial: The Definitive Guide
Learn how to read and import Excel files in Python, write data to these spreadsheets, and find the best packages to do this.
Natassha Selvaraj
March 3, 2023