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:
-
- How to share Outlook calendar with Google
- This article details three methods for sharing your Outlook calendar with your Google account: sharing via invitation, publishing the calendar online, and importing an iCalendar file. While seemingly straightforward, syncing between Outlook and Goog
- excel 614 2025-04-02 09:56:10
-
- Excel XLOOKUP function with formula examples
- This tutorial introduces XLOOKUP, Excel's new function for vertical and horizontal lookups. Previously complex tasks, like left lookups, finding last matches, and VLOOKUPs with multiple criteria, are now simplified. When performing Excel lookups, yo
- excel 187 2025-04-02 09:49:14
-
- Excel formulas to count cells with text: any, specific or filtered cells
- How to count cells containing text in Excel? Excel was originally designed to process numbers, but today we also often use it to store and process text. Want to know how many cells are in the worksheet that contain text? Microsoft Excel provides several functions to achieve this. Which function should be used? It depends on the situation. In this tutorial, you will find various formulas and the best time to use each formula. Statistics cells containing any text Ignore empty strings and spaces and count cells containing text Statistics of cells containing specific text Statistics filtered cells containing text How to count the number of cells containing text in Excel There are two basic formulas
- excel 998 2025-04-02 09:48:10
-
- How to export Outlook contacts
- Mastering Outlook Contact Export: CSV, PST, and More! Need to move your Outlook contacts to another email service or create a backup? This comprehensive guide shows you how to export your Outlook contacts to CSV or PST files—easily importable into Ex
- excel 489 2025-04-02 09:43:08
-
- INDEX MATCH MATCH in Excel for two-dimensional lookup
- The tutorial showcases a few different formulas to perform two dimensional lookup in Excel. Just look through the alternatives and choose your favorite :) When searching for something in your Excel spreadsheets, most of the time you'd loo
- excel 816 2025-04-02 09:41:09
-
- VLOOKUP across multiple sheets in Excel with examples
- This tutorial demonstrates how to use the VLOOKUP function to retrieve data from different worksheets or workbooks within Excel. It covers scenarios ranging from simple lookups between two sheets to more complex, dynamic lookups across numerous shee
- excel 852 2025-04-02 09:39:10
-
- INDEX MATCH in Google Sheets – another way for vertical lookup
- Mastering Google Sheets INDEX MATCH: A Superior Alternative to VLOOKUP When searching for data linked to a specific key record in your Google Sheet, VLOOKUP is often the first choice. However, VLOOKUP's limitations quickly become apparent. This is w
- excel 482 2025-04-02 09:32:11
-
- Excel INDEX MATCH with multiple criteria - formula examples
- The tutorial shows how to lookup with multiple criteria in Excel using INDEX and MATCH and a few other ways. Although Microsoft Excel provides special functions for vertical and horizontal lookup, expert users normally replace them with I
- excel 1035 2025-04-02 09:29:09
-
- Excel Personal Macro Workbook: how to create, use and share
- This tutorial explains how to create and utilize the Personal.xlsb file to make Excel macros accessible across all workbooks. Normally, Excel macros are workbook-specific. This guide demonstrates how to centralize commonly used VBA code in the Pers
- excel 572 2025-04-02 09:27:10
-
- How to record a macro in Excel
- This comprehensive guide simplifies Excel macro recording for beginners. Learn to automate repetitive tasks, saving time and effort. We'll cover recording, viewing, running, and saving macros, plus essential VBA mechanics. Recording Excel Macros M
- excel 786 2025-04-02 09:22:10
-
- How to use Google Sheets QUERY function – standard clauses and an alternative tool
- This comprehensive guide unlocks the power of Google Sheets' QUERY function, often hailed as the most potent spreadsheet function. We'll dissect its syntax and explore its various clauses to master data manipulation. Understanding the Google Sheet
- excel 830 2025-04-02 09:21:10
-
- Excel: count cells containing specific text (exact and partial match)
- The tutorial shows how to count number of cells with certain text in Excel. You will find formula examples for exact match, partial match and filtered cells. Last week we looked at how to count cells with text in Excel, meaning all cells
- excel 960 2025-04-02 09:20:10
-
- How to use Google Sheets FILTER function
- Unlock the Power of Google Sheets' FILTER Function: A Comprehensive Guide Tired of basic Google Sheets filtering? This guide unveils the capabilities of the FILTER function, offering a powerful alternative to the standard filtering tool. We'll explo
- excel 1076 2025-04-02 09:19:09
-
- Import Outlook contacts to Gmail and export Google contacts to Outlook
- This tutorial provides a step-by-step guide on seamlessly transferring contacts between Microsoft Outlook and Google Gmail. Many users switch between these platforms, and this guide simplifies the process of migrating contact lists without manual re
- excel 1005 2025-04-02 09:15:10
-
- How to import contacts to Outlook (from CSV and PST file)
- This tutorial demonstrates two methods for importing contacts into Outlook: using CSV and PST files, and also covers transferring contacts to Outlook Online. Whether you're consolidating data from an external source, migrating from another email pro
- excel 919 2025-04-02 09:09:10