Excel: Extract number from text string
This tutorial demonstrates how to extract numbers from various text strings within Excel using formulas and the Extract tool. Excel offers the Left, Right, and Mid substring functions for extracting text of a specific length, but lacks a dedicated f
Apr 08, 2025 am 10:29 AM
How to hide and unhide rows in Excel
This tutorial explores three methods for concealing and revealing rows in Excel worksheets. It also covers techniques for copying only visible rows and troubleshooting common unhiding issues. Need to restrict user access to specific worksheet sectio
Apr 08, 2025 am 10:20 AM
COUNT and COUNTA functions in Google Sheets with formula examples
The COUNT function in Google Sheets is one of the easiest to learn and extremely helpful to work with. Even though it looks simple, it's capable of returning interesting and useful results, especially in combination with other Google Shee
Apr 08, 2025 am 10:19 AM
How to hide sheets in Excel
Master Excel's Sheet Hiding Techniques: A Comprehensive Guide Excel's default view displays all worksheets. However, for data protection or a cleaner interface, hiding unnecessary sheets is crucial. This guide details multiple methods for hiding ind
Apr 08, 2025 am 10:17 AM
Excel IFERROR & VLOOKUP - trap #N/A and other errors
This tutorial demonstrates how to combine the IFERROR and VLOOKUP functions in Excel to handle errors effectively. You'll also learn how to perform sequential VLOOKUPs using nested IFERROR functions. Excel's VLOOKUP and IFERROR functions, while powe
Apr 08, 2025 am 10:11 AM
Add, delete, and resize columns in Google Sheets
Google Sheets Columns: A Comprehensive Guide Columns are fundamental building blocks in Google Sheets. Mastering column manipulation is crucial for efficient spreadsheet management. This guide covers selecting, deleting, adding, and resizing columns.
Apr 08, 2025 am 09:56 AM
How to make Excel worksheet very hidden and unhide it
This tutorial explains the difference between hidden and very hidden Excel worksheets, how to create very hidden sheets, and how to unhide them. Ever lost a worksheet referenced in a formula? It might be very hidden. Understanding Very Hidden Work
Apr 08, 2025 am 09:54 AM
How to unhide sheets in Excel: show multiple or all hidden sheets
This tutorial shows you how to unhide worksheets in Excel 2016, 2013, 2010, and earlier versions. Learn quick methods using right-clicks and VBA code to reveal hidden sheets. Scenario: You open a spreadsheet, and formulas reference a missing sheet.
Apr 08, 2025 am 09:53 AM
Currency conversion in Google Sheets
Master Google Sheets' GOOGLEFINANCE Function for Currency Conversions Google Sheets offers a powerful tool for currency conversion – the GOOGLEFINANCE function – unavailable in most other spreadsheet programs. This tutorial explores its capabilities,
Apr 08, 2025 am 09:44 AM
How to randomize a list in Excel: sort randomly cells, rows and columns
This tutorial demonstrates two efficient methods for randomizing data within Microsoft Excel: utilizing formulas for random sorting and employing a specialized tool for data shuffling. Excel offers various sorting options, but lacks a built-in random
Apr 08, 2025 am 09:37 AM
Split names in Excel: separate first and last name into different columns
This tutorial demonstrates how to efficiently separate first and last names in Excel using formulas, the "Text to Columns" feature, or the "Split Names" tool. It addresses the common need to divide a column of full names into sep
Apr 08, 2025 am 09:35 AM
IF VLOOKUP in Excel: Vlookup formula with If condition
This tutorial demonstrates how to combine the VLOOKUP and IF functions in Excel to perform lookups with conditional logic. You'll also learn how to handle #N/A errors using IF ISNA and IFNA with VLOOKUP. This assumes familiarity with the syntax of
Apr 08, 2025 am 09:05 AM
How to delete every other row or every Nth row in Excel
This tutorial shows you how to efficiently delete every other row, or any Nth row, in Microsoft Excel. We'll cover two methods: filtering and VBA code. There are many scenarios where removing specific rows is necessary. For instance, you might need
Apr 08, 2025 am 09:03 AM
Calculate number of days between two dates in Excel
This tutorial provides several methods for calculating the number of days between two dates in Microsoft Excel. Need to know the difference between today and a past or future date? This guide covers various scenarios. Quick Calculation with an Onli
Apr 08, 2025 am 09:02 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
Hot Topics
1664
14
1423
52
1321
25
1269
29
1249
24