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:
Featured
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
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
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
All posts
How to Combine VLOOKUP() with IF() in Excel
Combine VLOOKUP() with IF() for efficient data analysis, including conditional lookups, error handling, and dynamic column indexing.
Laiba Siddiqui
July 18, 2024
Conditional Formatting in Excel: A Beginner’s Guide
Explore conditional formatting in Excel with simple to advanced examples and their best practices.
Joleen Bothma
July 8, 2024
How to Create Data Models in Excel: A Comprehensive Guide
We create data models by formatting data, creating relationships, using Power Query, and leveraging Power Pivot for seamless data integration and analysis.
Vikash Singh
July 5, 2024
How to Create and Customize a Box and Whisker Plot in Excel
To create a box and whisker plot in Excel, select your data, open the Insert tab, click on Recommended Charts, choose the Box & Whisker chart, and press OK.
Elena Kosourova
June 30, 2024
A Comprehensive Guide to Calculating Frequency Distributions in Excel
Follow our step-by-step guide to create frequency distributions in Excel by using the FREQUENCY() function with just two arguments: data_array and bins_array.
Arunn Thevapalan
June 28, 2024
Data Types in Excel and Their Uses: A Complete Guide
Learn to identify and format all types of data in Excel, then explore valuable tips on converting between data types to make your spreadsheet more functional.
Laiba Siddiqui
June 21, 2024
How to Calculate Cube Roots in Excel: A Step-by-Step Guide
There are three easy ways to calculate cube roots in Excel: the caret ^ operator, the POWER() function, and custom VBA functions.
Laiba Siddiqui
June 14, 2024
How to Create and Format a Combo Chart in Excel
To create a combo chart in Excel, select your data, go to the "Insert" tab, go to the "Charts" group, and choose "Combo Chart."
Elena Kosourova
June 12, 2024
A Comprehensive Guide to Calculating Skewness in Excel
Calculating skewness in Excel is a straightforward process: we use either the SKEW() or SKEW.P() function.
Arunn Thevapalan
June 12, 2024
A Comprehensive Guide to Using ANOVA in Excel
Learn the simplified process of conducting ANOVA in Excel, and interpreting the results with clear, step-by-step instructions.
Arunn Thevapalan
June 7, 2024
How to Clean Data in Excel: A Beginner's Guide
Learn essential data cleaning techniques in Excel, including removing duplicates, handling missing values, and maintaining consistent formatting.
Laiba Siddiqui
July 19, 2024
What is Data Validation in Excel? A Comprehensive Guide to Add, Edit, and Remove Data Validation Rules in Excel
Applying data validation in Excel is simple: Open the 'Data' tab. Go to the 'Data Tools' group. Click on the 'Data Validation' button.
Elena Kosourova
May 31, 2024