current location：Home > Technical Articles > Topics > excel
- Direction：
- All web3.0 Backend Development Web Front-end Database Operation and Maintenance Development Tools PHP Framework Common Problem Other Tech CMS Tutorial Java System Tutorial Computer Tutorials Hardware Tutorial Mobile Tutorial Software Tutorial Mobile Game Tutorial
- Classify：
-
- Excel: How to find broken links and get them fixed
- Are non-working links causing havoc to your worksheets? Do not worry! This tutorial will teach you 3 easy ways to find and fix broken Excel links, plus our own one-click solution as an extra bonus :) Excel cells may often link to other w
- excel 1031 2025-03-31 12:42:10
-
- Extract data from Google Sheets: certain text from strings, URLs from links, and more
- This next bit of our operations with text in spreadsheets is devoted to extraction. Find out ways to extract various data — text, characters, numbers, URLs, email addresses, date & time, etc. — from various positions in mu
- excel 843 2025-03-31 12:17:09
-
- Excel SMALL function to find and highlight lowest values
- In this short tutorial, we'll talk about Excel SMALL function, how it works and how to use it to find the Nth smallest number, date, or time. Need to find a few lowest numbers in a worksheet? This is quite easy to do with the Excel Sort f
- excel 584 2025-03-31 11:56:10
-
- Outlook email template: 10 quick ways to create and use
- This article explores ten powerful Outlook email template methods to streamline your email workflow. If repetitive emails consume significant time, these techniques offer efficient alternatives to manual composition. - Outlook .oft Templates New Ou
- excel 843 2025-03-31 11:35:08
-
- Implicit intersection: use of @ sign in Excel formulas
- Excel's implicit intersection operator @ symbol details Excel's implicit intersection feature has been around for many years, but is little known. It wasn't until Excel 365 no longer used it as the default behavior that many questions arise. This tutorial aims to explain the meaning of the "@" symbol (called the implicit intersection operator) in Excel formulas. You may feel like you know your workbook well, and then a "@" character suddenly appears at the beginning of the formula. What does this mean? How exactly does it work? In short, it is an implicit intersection operator that disables the new default array behavior of the formula and instructs Excel to return a single value. For more details, please continue reading. Excel implicit intersection In Excel
- excel 764 2025-03-31 11:25:15
-
- Attach files to Outlook drafts and use them as email templates
- Mastering Outlook Drafts as Reusable Email Templates: A Step-by-Step Guide Many of us rely on Outlook drafts for efficient email management. Outlook conveniently prompts you to save unsent emails, allowing you to finish composing later. But did you
- excel 242 2025-03-31 09:53:09
-
- Dependent drop down list for multiple rows using Excel dynamic arrays
- This tutorial demonstrates how to create expandable, multi-row dependent dropdown lists in Excel using dynamic arrays. This method significantly simplifies the process compared to traditional approaches. The solution is only compatible with Excel f
- excel 419 2025-03-31 09:50:12
-
- How to add the same text to multiple cells in Google Sheets: efficient techniques
- This tutorial will teach you to add text in Google Sheets cells at the same position. You will insert symbols and text strings at the beginning & the end of Google Sheets cells, after any N-th character, and even before or after specified
- excel 486 2025-03-31 09:25:09
-
- Regex to extract strings in Excel (one or all matches)
- In this tutorial, you'll learn how to use regular expressions in Excel to find and extract substrings matching a given pattern. Microsoft Excel provides a number of functions to extract text from cells. Those functions can cope with most
- excel 375 2025-03-28 12:19:09
-
- Split Google sheet into multiple sheets or files
- Managing large Google Sheets can be challenging. This article explores efficient methods for splitting a large Google Sheet into multiple sheets within the same file, or even into entirely separate files in Google Drive. This improves organization
- excel 575 2025-03-28 12:03:12
-
- Converting CSV to Excel: solutions for common issues
- This tutorial tackles common CSV import issues in Excel and offers effective solutions. CSV (Comma Separated Values) files are frequently used for data exchange between spreadsheet applications. While commas are theoretically the standard separator
- excel 861 2025-03-28 11:55:10
-
- How to delete special / unwanted characters in Excel
- This article demonstrates how to effectively remove unwanted characters from text strings within Excel, addressing common issues like invisible characters and those not readily available on a standard keyboard. We'll explore several methods, caterin
- excel 489 2025-03-28 10:50:13
-
- Excel CONCAT function - string concatenation examples
- This tutorial explores the Excel CONCAT function, a streamlined way to combine text strings from multiple cells. It also highlights key differences from its predecessor, CONCATENATE. Learn to concatenate with various delimiters (spaces, commas, line
- excel 759 2025-03-28 10:27:10
-
- Excel Data Validation using regular expressions (Regex)
- The tutorial shows how to do data validation in Excel using regular expressions with the help of a custom RegexMatch function. When it comes to restricting user input in Excel worksheets, Data Validation is indispensable. Want to allow on
- excel 463 2025-03-28 10:25:13
-
- How to convert table to normal range in Excel and vice versa
- This article explains how to quickly convert a cell range into an Excel table using a chosen table style, and how to revert a table back to a standard range. Excel tables simplify data management, calculation, and updates. However, sometimes a table
- excel 264 2025-03-28 10:19:11
Recommended Articles
Tool Recommendations
jQuery enterprise message form contact code
jQuery enterprise message form contact code is a simple and practical enterprise message form and contact us introduction page code.
form button
2024-02-29
HTML5 MP3 music box playback effects
HTML5 MP3 music box playback special effect is an mp3 music player based on HTML5 css3 to create cute music box emoticons and click the switch button.
Player special effects
2024-02-29
HTML5 cool particle animation navigation menu special effects
HTML5 cool particle animation navigation menu special effect is a special effect that changes color when the navigation menu is hovered by the mouse.
Menu navigation
2024-02-29
jQuery visual form drag and drop editing code
jQuery visual form drag and drop editing code is a visual form based on jQuery and bootstrap framework.
form button
2024-02-29
Organic fruit and vegetable supplier web template Bootstrap5
An organic fruit and vegetable supplier web template-Bootstrap5
Bootstrap template
2023-02-03
Bootstrap3 multifunctional data information background management responsive web page template-Novus
Bootstrap3 multifunctional data information background management responsive web page template-Novus
backend template
2023-02-02
Real estate resource service platform web page template Bootstrap5
Real estate resource service platform web page template Bootstrap5
Bootstrap template
2023-02-02
Simple resume information web template Bootstrap4
Simple resume information web template Bootstrap4
Bootstrap template
2023-02-02
Cute summer elements vector material (EPS PNG)
This is a cute summer element vector material, including the sun, sun hat, coconut tree, bikini, airplane, watermelon, ice cream, ice cream, cold drink, swimming ring, flip-flops, pineapple, conch, shell, starfish, crab, Lemons, sunscreen, sunglasses, etc., the materials are provided in EPS and PNG formats, including JPG previews.
PNG material
2024-05-09
Four red 2023 graduation badges vector material (AI EPS PNG)
This is a red 2023 graduation badge vector material, four in total, available in AI, EPS and PNG formats, including JPG preview.
PNG material
2024-02-29
Singing bird and cart filled with flowers design spring banner vector material (AI EPS)
This is a spring banner vector material designed with singing birds and a cart full of flowers. It is available in AI and EPS formats, including JPG preview.
banner picture
2024-02-29
Golden graduation cap vector material (EPS PNG)
This is a golden graduation cap vector material, available in EPS and PNG formats, including JPG preview.
PNG material
2024-02-27
Home Decor Cleaning and Repair Service Company Website Template
Home Decoration Cleaning and Maintenance Service Company Website Template is a website template download suitable for promotional websites that provide home decoration, cleaning, maintenance and other service organizations. Tip: This template calls the Google font library, and the page may open slowly.
Front-end template
2024-05-09
Fresh color personal resume guide page template
Fresh color matching personal job application resume guide page template is a personal job search resume work display guide page web template download suitable for fresh color matching style. Tip: This template calls the Google font library, and the page may open slowly.
Front-end template
2024-02-29
Designer Creative Job Resume Web Template
Designer Creative Job Resume Web Template is a downloadable web template for personal job resume display suitable for various designer positions. Tip: This template calls the Google font library, and the page may open slowly.
Front-end template
2024-02-28
Modern engineering construction company website template
The modern engineering and construction company website template is a downloadable website template suitable for promotion of the engineering and construction service industry. Tip: This template calls the Google font library, and the page may open slowly.
Front-end template
2024-02-28
