How to group columns in Excel
This tutorial explains how to manually group columns in Excel and utilize the Auto Outline feature for automatic column grouping. Managing large worksheets can be simplified by grouping columns, allowing for easy hiding and showing of data sections.
Mar 26, 2025 am 10:58 AM
Excel: SUMIF multiple columns with one or more criteria
This tutorial demonstrates several methods for summing multiple columns in Excel based on single or multiple criteria. Conditional summing is straightforward when values are in a single column, but summing across multiple columns presents a challeng
Mar 26, 2025 am 10:47 AM
Extract text between two characters in Excel and Google Sheets
This comprehensive guide demonstrates how to extract text nestled between two characters or words within Excel and Google Sheets. Working with extensive strings often necessitates isolating specific segments for detailed analysis. This article outl
Mar 26, 2025 am 10:45 AM
Excel TOCOL function to convert range to single column
Excel's New TOCOL Function: Reshape Your Data with Ease Excel's data manipulation capabilities just got a significant boost with the introduction of the TOCOL function. This powerful tool effortlessly transforms arrays or ranges of cells into a sing
Mar 26, 2025 am 10:44 AM
Excel IF between two numbers or dates
This tutorial demonstrates how to use Excel's IF function to determine if a number or date falls within a specified range. To check if a value lies between two numbers, combine the AND function with two logical tests. Nest the AND function within th
Mar 26, 2025 am 10:02 AM
Combine ranges and arrays in Excel: VSTACK & HSTACK functions
This tutorial demonstrates how to effortlessly merge multiple Excel 365 arrays vertically and horizontally using the powerful VSTACK and HSTACK functions. Previously a complex task, these functions simplify the process significantly, even handling d
Mar 26, 2025 am 09:26 AM
Excel if match formula: check if two or more cells are equal
This Excel tutorial demonstrates various methods for comparing cell values, returning logical results, custom text, or data from other cells. We'll explore solutions beyond the simple A1=B1 comparison, addressing scenarios where this basic approach
Mar 26, 2025 am 09:23 AM
5 ways to merge Google sheets while adding extra columns and rows
This article demonstrates several methods for merging Google Sheets, including updating existing data, adding related columns, and incorporating non-matching rows. We'll explore VLOOKUP, INDEX/MATCH, QUERY functions, and the Merge Sheets add-on. Pre
Mar 26, 2025 am 09:20 AM
TEXTSPLIT function in Excel: split text strings by delimiter
This tutorial demonstrates the powerful new TEXTSPLIT function in Excel 365, enabling efficient string splitting using custom delimiters. Excel offers various cell-splitting methods, including Text to Columns and Fill Flash, but TEXTSPLIT provides a
Mar 26, 2025 am 09:15 AM
Excel TEXTBEFORE function - extract text before character (delimiter)
This tutorial explores Excel's TEXTBEFORE function, a powerful tool for quickly extracting text preceding a specified character or substring. Prior to its introduction, this task required complex formulas combining SEARCH/FIND and LEFT. TEXTBEFORE
Mar 26, 2025 am 09:13 AM
Excel: How to sum largest numbers in a range
Six efficient methods for summing the largest N values in Excel. Adding numbers is a common task, and while Excel offers SUM, SUMIF, and SUMIFS, directly summing the top N values requires a different approach. Method 1: SUM and LARGE for Top N Numb
Mar 26, 2025 am 09:10 AM
Excel conditional formatting for blank cells
Excel conditional formatting: a complete guide to empty cells It seems simple, but using conditional formatting to highlight empty cells is quite tricky. The main reason is that people's understanding of empty cells is not always consistent with Excel's understanding. As a result, empty cells may be formatted incorrectly and vice versa. This tutorial will take a closer look at the scenarios, share some useful information about what is happening behind the scenes, and show how to make the conditional formatting of empty cells work exactly as you wish. - Why does conditional formatting highlight empty cells? Why doesn't conditional formatting highlight empty cells? How to highlight empty cells Conditional formatting formula for empty cells If the cell is empty, stop conditional formatting Ignore empty using conditional formatting formula
Mar 26, 2025 am 09:08 AM
Excel IMAGE function - quickly insert picture in cell with formula
Excel's IMAGE Function: A Revolutionary Way to Embed Pictures For years, inserting images into Excel worksheets was cumbersome. Now, the new IMAGE function simplifies this process dramatically. Using a simple formula, you can embed images directly
Mar 26, 2025 am 09:03 AM
Excel AVERAGEIF function to average cells with condition
The tutorial shows how to use the AVERAGEIF function in Excel to calculate an arithmetic mean with condition. Microsoft Excel has a few different functions to calculate an arithmetic mean of numbers. When you are looking to average cells
Mar 25, 2025 am 10:44 AM
Hot tools Tags
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!
Hot Article
Hot Tools
vc9-vc14 (32+64 bit) runtime library collection (link below)
Download the collection of runtime libraries required for phpStudy installation
VC9 32-bit
VC9 32-bit phpstudy integrated installation environment runtime library
PHP programmer toolbox full version
Programmer Toolbox v1.0 PHP Integrated Environment
VC11 32-bit
VC11 32-bit phpstudy integrated installation environment runtime library
SublimeText3 Chinese version
Chinese version, very easy to use
