current location：Home > Technical Articles > Software Tutorial > Office Software
- Direction：
- All web3.0 Backend Development Web Front-end Database Operation and Maintenance Development Tools PHP Framework Daily Programming WeChat Applet Common Problem Other Tech CMS Tutorial Java System Tutorial Computer Tutorials Hardware Tutorial Mobile Tutorial Software Tutorial Mobile Game Tutorial
- Classify：
-
- How to use the vlookup function How to use the vlookup function
- If there is duplicate data in the table, conditions must be added to limit the query. The formula used to find Class 2 Li Bai in the picture is [=VLOOKUP(F5&G5,IF({1,0},A3:A11&B3:B11,D3:D11),2,FALSE)]. 3. Reverse search We want to use VLOOKUP to query Li Bai’s job number, which is a reverse search. We use the known name to find the job number on the left. The formula is [=VLOOKUP(F5,IF({1,0},B3 :B11,A3:A11),2,FALSE)]. 4. One-to-many query: One information matches multiple employees, and the employees’ names are viewed according to the section. The picture below takes the marketing department as an example to query all the employees in the marketing department.
- Office Software 871 2024-06-02 14:12:04
-
- How does Excel prompt that table highlighting is disabled when importing web data?
- When importing data again, select [Data] - [Get Data] - [Traditional Wizard] - [From Web (W) (old version)] to import web page data. Import weather data here and you can see that it is imported normally.
- Office Software 1223 2024-06-02 13:58:45
-
- How to merge cells in Tencent documents_How to merge cells in Tencent documents
- First, click on the cell on the Tencent document page. Then drag to select the area you want to merge. Then on the toolbar, click Merge Cells. Finally, click Yes, and the cells will be merged successfully.
- Office Software 601 2024-06-02 13:55:44
-
- How to set up the presenter view in ppt_How to set up the presenter view in ppt
- 1. Open the ppt document and click [Show]. 2. Check [Show Presenter View].
- Office Software 1121 2024-06-02 13:54:31
-
- How to align table of contents page numbers in Word_No need to teach you how to quickly align them in a minute
- First, we select the entire table of contents text, then right-click the menu, select the paragraph in it, and click the tab stop below. The tab position is filled with 38, which is where the table of contents page is. If the page size is not the default, please use the ruler above your page to determine it. Then select right alignment for alignment, select 2 for leader, and finally click OK. Next, position the cursor in front of the table of contents page number, and then press the TAB key to align the table of contents to the far right.
- Office Software 2400 2024-06-02 13:40:19
-
- Introduction to how to set background images in word2003
- Step 1: Word documents have powerful processing functions. In order to demonstrate more clearly, I will create a new blank 03 document. The name is [Hi everyone]. Step 2: Open the [hi everyone.doc] document and click the [Format] option in the menu below the word title. Step 3: After opening the [Format] option, move the mouse pointer to [Background] in the format, and then a secondary option will appear, then click [Fill Effect] in this option. Step 4: After opening [Fill Effect], a new window will pop up with the name of [Fill Effect]. Click [Picture] inside -> [Select Picture]. Step 5: In the pop-up [Select Image] window, browse to the image folder you want to use as the background.
- Office Software 542 2024-06-02 13:39:51
-
- How to set the alignment of multiple pictures in Power Point2003
- Create a new blank slideshow PPT file, and then execute the Picture - From File command in the File menu to import the picture. The Insert Picture dialog window will pop up. In this window, find the computer location where the pictures are stored, then select multiple pictures at the same time and click Insert. After importing the four pictures into the PPT slide page, click to select two of the pictures and move the two pictures to the left and right sides of the slide. Move the mouse outside the slide page, then drag the mouse to select all the photos. Release the mouse to select all the photos. Find [Alignment and Distribution] in the drawing toolbar, find the [Horizontal Distribution] command in Alignment and Distribution, click to execute, then all pictures will be aligned left and right.
- Office Software 1056 2024-06-02 13:32:43
-
- How to adjust row height in Microsoft Excel table How to adjust row height in Microsoft Excel table
- 1. First, we open the Microsoft Excel table, as shown in the figure below. 2. Then we right-click [Row Height], as shown in the figure below. 3. Then enter the appropriate size, as shown in the figure below. 4. Finally, the adjustment is successful, as shown in the figure below.
- Office Software 777 2024-06-02 13:27:01
-
- Tutorial on converting Word text tables to each other_convert however you want after reading it
- First select all the text, then click [Insert]-[Table]-[Convert text to table]. Then set the number of columns of the table in the pop-up window, and select comma in the text separation position. If it is other characters, click on other characters and enter the corresponding characters. Finally, click OK and the text will be converted into a table. Then choose a color you like, save it and give it to the boss. But your boss asks you to convert the data in the table into text again, so what should you do? It doesn't matter. First, we select all the content in the table, click [Layout] in the table tool above, and then click Convert to Text. Select [Tab Character] in the window that comes out, click OK, and the table is converted into text again. Isn’t it very simple? Let’s try it quickly, friends.
- Office Software 1076 2024-06-02 13:25:46
-
- How to set password protection for word2003 documents
- Use Word2003 to open the Word document that needs to be encrypted. Click the [Tools] column-select [Options]. In the pop-up [Options] window, click the [Security] tab. Fill in the set password in the box behind [Password when modifying the document], and then confirm. When the document is edited, a password will be required before it can be edited, to avoid accidental messing up the document format and layout. Fill in the password you set in the box behind [Password when opening the document], and then confirm. When the document is opened, a password will be required before it can be opened, improving the security of the text in the document. In addition, in the [Options] window there are [Digital Signature], that is, copyright information and [Document Protection] functions.
- Office Software 939 2024-06-02 13:20:49
-
- Detailed operation process of finding and swapping text in Word 2013
- We need to open the Word2013 software first. As shown in the figure: Then we switch to the [Start] panel and click the [Find] button in the [Edit] option. As shown in the figure: After performing the operation, the [Navigation] pane pops up on the left side of the document. As shown in the figure: Then we click the [Search] drop-down list box in the [Navigation] pane. As shown in the figure: Enter the text you want to find in the [Search] drop-down list box. As shown in the figure: Press the [Enter] key to automatically search for the desired content in the document. As shown in the figure: Click the lower triangle button on the right side of the [Search] drop-down list box, and select the [Replace] option in the pop-up list box. As shown in the figure: After performing the operation, the [Find and Replace] dialog box pops up. In the [Replace with] text box, enter [of
- Office Software 662 2024-06-02 13:14:26
-
- How to automatically update serial numbers in Excel_One function to do it
- 1. First, we set the starting position of the serial number. 2. Delete the serial number and enter =row()-13. Finally, press Enter and a normal serial number will appear. Then we can directly drop down to fill all the cells. In this way, no matter how we delete the middle cell, the serial number will still remain normal. 4. Of course, this method only applies to column numbers. If it is row numbers, the formula is =COLUMN()-1, and other operations are the same. Isn't it very simple? Those friends who are still worried about the serial number should try it quickly. Don't be stupid and re-fill it over and over again.
- Office Software 541 2024-06-02 13:14:02
-
- How to appeal if a Tencent document is reported_How to appeal if a Tencent document is reported
- 1) Computer: ① Open the document--click "three" in the upper right corner of the interface--"Help and Feedback"--"Feedback". ②After entering, click "Say a few words" on the right side of the page to submit feedback. 2) Mobile version: ① Enter the document list - click the avatar in the upper left corner of the interface - click "Help and Feedback" - "Feedback" ② After entering, click "Say a few words" to submit feedback. 3. It is recommended to create copies of important documents. How to create copies of Tencent documents? Enter any document - click "three" in the upper right corner of the interface - "Generate a copy".
- Office Software 614 2024-06-02 13:10:16
-
- An easy way to use contextual spell checking in word 2010 documents
- Open the Word2010 document window, click the [File] → [Options] button, open the [Word Options] dialog box, and switch to the [Proofing] tab. In the [When correcting spelling and grammar in Word] area, select the [Use contextual spelling check] checkbox and click the [OK] button.
- Office Software 634 2024-06-02 13:03:37
-
- How to quickly preview in Word2010
- Open the Word2010 document, then select the [File] option in the upper left corner of the interface and click. Select the [Options] column. After entering the [Word Options] window, switch to the [Quick Access Toolbar], and pull down the option [Common Commands] in the left window to the [Print Preview Tab] in the menu. Then add one of the commands named [Print Preview and Print] to the [Customize Quick Access Toolbar] in the right window. Click the [Confirm] button. After exiting the settings window, return to the Word2010 operation interface. You will see a small magnifying glass icon for viewing paper in the upper left corner of the interface. This is the function key for [Print Preview and Print]. Click this icon and the document will enter the print preview window.
- Office Software 1119 2024-06-02 13:02:41
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
