Excel CHOOSEROWS function to extract certain rows from array
In this tutorial, we'll take an in-depth look at the Excel 365 function named CHOOSEROWS and its practical uses. Suppose you have an Excel worksheet with hundreds of rows from which you want to extract some specific ones, say, all odd or
Mar 25, 2025 am 09:43 AM
Excel CHOOSECOLS function to get columns from array or range
This tutorial will introduce you to a new Excel 365 dynamic array function named CHOOSECOLS and show how you can use it to extract any specific columns from an array. Imagine that you are working with a dataset of hundreds or thousands of
Mar 25, 2025 am 09:40 AM
Convert column / row to array in Excel: WRAPCOLS & WRAPROWS functions
The fastest way to transform a column or row of values into a two-dimensional array is using the WRAPCOLS or WRAPROWS function. Since the earliest days of Excel, it has been very good at calculating and analyzing numbers. But manipulating
Mar 25, 2025 am 09:36 AM
How to sort mixed numbers and text, multilevel numbers in Excel
The tutorial explains common problems with ordering alphanumeric strings in Excel and provides working solutions to sort numbers as text and text as numbers. Sorting text and numbers separately in Excel is as easy as ABC or 123 :) But re-
Mar 25, 2025 am 09:33 AM
Excel NOW function to return current date and time
In this tutorial, you will learn how to use a NOW formula in Excel to insert the current date and time as a dynamic value and how to make the NOW function static without auto update. To insert the current date and time in your worksheet,
Mar 25, 2025 am 09:32 AM
Excel AVERAGE function with examples
The tutorial will teach you the most effective formulas to average numbers, percentages and times in Excel and avoid errors. In Microsoft Excel, there exist a handful of different formulas for calculating average. This tutorial focuses on
Mar 25, 2025 am 09:28 AM
Color scales in Excel: how to add, use and customize
This tutorial will teach you how to conditionally format cells in Excel using gradient color scales to visually compare values in a range. Excel conditional formatting is all about visualizing data with colors. You can use contrasting co
Mar 25, 2025 am 09:21 AM
How to insert current time in Excel: timestamp shortcut, NOW formula, VBA
In this tutorial, you will learn how to quickly insert current time in Excel using a shortcut, formula, or VBA macro. Also, we'll look at how to convert timestamp to date and get hours, minutes or seconds from a timestamp. There are a num
Mar 25, 2025 am 09:07 AM
Find all combinations of numbers that equal a given sum in Excel
3 ways to find all combinations from a set of numbers that sum to a specific total. Finding combinations of values that add up to a given sum is a common problem in data analysis. For example, you may want to know all possible combinatio
Mar 25, 2025 am 09:05 AM
What hash sign means in Excel and how to remove #### from cell
In this article, we will explore various ways in which the number sign can be used in Excel and provide solutions for the #### error. The # symbol, also known as the number, hash or pound sign, is a versatile character with multiple meani
Mar 25, 2025 am 09:02 AM
How to select multiple cells in Excel: non adjacent, visible, with data
Discover effective techniques, shortcuts and VBA macros for selecting multiple cells in Excel, including non-adjacent cells, current range, visible cells, and cells with data. Whichever task you undertake in Excel, be it data analysis, mo
Mar 24, 2025 am 10:31 AM
How to customize Google Docs: guide on styles & formatting
In this blog post, we delve into the various techniques and features available to customize your Google Docs. Follow these tips and tricks to be well on your way to creating documents that convey your content effectively and look polished
Mar 24, 2025 am 10:24 AM
#NUM error in Excel - fixing number error in formulas
In this tutorial, we'll break down the causes of the Excel #NUM error and show you how to fix it. Are you staring at your computer screen, sipping on your coffee, and wondering why your Excel spreadsheet is suddenly showing a strange erro
Mar 24, 2025 am 10:15 AM
Status bar in Excel: how to customize and use
In this tutorial, we will explore the significance of the status bar in Excel, explain how to customize it for optimal productivity, and unveil its hidden powers to conquer data tasks like a pro. Microsoft Excel offers an array of powerfu
Mar 24, 2025 am 10:11 AM
Hot tools Tags
Undress AI Tool
Undress images for free
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
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
