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 excel conditional sum function_How to use excel conditional sum function
- Step 1: Find the function ifs, as shown in the figure, enter [ifs] in the [Insert Function] dialog box, you can also find it one by one, but this is a waste of time, so just enter it directly, and finally click [ OK], this article uses students’ grades as an example. Step 2: Click the first parameter that needs to be tested in [Test Condition 1]. Take this chapter as an example, that is, [E3]. If [E=100], [True Value 1] is [Full Score]. After inputting, click [OK]. Step 3: After calculating the result of the first parameter, pull down the data directly in the lower right corner of the cell of the first parameter. You will get all the results with one click, and you can check whether the data has errors.
- Office Software 1182 2024-06-01 22:12:52
-
- 4 ways to encrypt Word documents
- When we are dealing with Word documents, sometimes we cannot let others view them at will, or we are not allowed to change them at will when viewing them. If you have these needs, you can take a look at the following four encryption protection methods for Word documents. 1. The document can be edited, but the format cannot be modified. Allow others to edit the document, but cannot modify the format. We can do this by setting a "restriction password": First, after opening the Word document, click on the menu tab [Review] list [Restrict Editing]; after the [Restrict Editing] interface appears, check [Restrict formatting to the selected style], and then click [Yes, start forced protection]. When the dialog box pops up, enter the password you want to set in the password field. , and finally click [OK] to set it up. After the setting is completed, you can see that the follow pattern
- Office Software 569 2024-06-01 21:51:33
-
- How to fix the position of Word pictures_Text box helps you
- 1. First, we insert a text box where we want to insert the picture. 2. Then delete the style text in the text box and make it a blank text box. 3. Next, select the text box, right-click and select [Format Text Box], select [Fill Effect] in Fill, select the image in it, and check Lock Image Aspect Ratio after inserting it. 4. Finally click OK, and the picture will be inserted into the text box, and it can be adjusted as the size of the text box is adjusted. You can also set the shape outline in the text box to have no outline, which is perfect.
- Office Software 1441 2024-06-01 21:45:52
-
- How to set the language for Tencent Documents_How to set the language for Tencent Documents
- 1. First open the Tencent Documents APP on your phone and click My in the lower right corner. 2. Then in the My interface, click on Language Settings. 3. Finally, just select the appropriate language, as shown below.
- Office Software 608 2024-06-01 21:44:21
-
- What to do if WIN10 has a blue screen and prompts you to restart
- If your computer starts slowly and usually takes 20 seconds to start the system, then press and hold the power button for 10 seconds after the system starts to force the system to shut down. If it starts quickly, it usually takes about 10 seconds to start the system. , then press the power button to turn off the system after 4-6 seconds. Restart your computer again and you will see an interface like this. After the repair detection is completed, you will be prompted with two buttons to choose between restarting or entering advanced options. Click [Advanced Options] here. After entering the advanced options, select the [Troubleshooting] option. Then select [Reset this PC] on the subsequent interface. Because the original win10 system is broken, I choose to delete all content in this step. In this step, select [Only drives with Windows installed]
- Office Software 1226 2024-06-01 21:16:26
-
- How to deal with no sound in Tencent meetings
- Enter Tencent Meeting, click on the avatar above and select Settings. Check whether the option to turn on the microphone when joining the meeting is unchecked. If you still can't hear it after checking it, select the audio on the left. Check the speakers and microphones, and then turn up the volume of the speakers and microphones.
- Office Software 460 2024-06-01 21:14:44
-
- How to set up meeting barrage in Tencent Meeting How to set up meeting barrage in Tencent Meeting
- Step 1: First open Tencent Meeting, enter and select the settings icon in the upper right corner, as shown in the figure. Step 2: After entering settings, select General Settings on the left and click, as shown in the picture. Step 3: Finally find the new chat message reminder, click on the barrage, and select it, as shown in the picture.
- Office Software 1177 2024-06-01 20:45:39
-
- How to extract zodiac sign based on birthday in Excel_A function can help you
- First of all, you need to remember the following formula, which is the functional formula for zodiac conversion. =MID("Rat, Cow, Tiger, Rabbit, Dragon, Snake, Horse, Sheep, Monkey, Chicken, Dog, Pig", MOD(YEAR(A1)-4,12)+1,1) Please note that A1 here is not a fixed cell, which means that you In the form, fill in whichever box the birthday date is in. Let's take the table below as an example. We enter the formula in the zodiac table and change A1 to B2. Finally, press Enter and the zodiac sign will be displayed. Finally, we can hold down CTRL to fill in the form. Isn't it very simple, so that you don't have to take the calculator to calculate one by one? It doesn't take too much effort! If you are interested, please go and try it out.
- Office Software 585 2024-06-01 20:18:39
-
- A simple tutorial for inputting traditional Chinese characters in word
- For example, if you want to choose a name with traditional Chinese characters, commonly used input methods include QQ Pinyin, Sogou, Quanpin and other input methods. If you need to input Traditional Chinese characters, you only need to switch to Traditional Chinese characters. When the input is completed, you can also switch to Simplified Chinese characters. Method 2: Use the Traditional-Simplified switching tool in word. If it is the word 2003 version, right-click the [Tools-Language-Chinese Simplified and Traditional Conversion] option on the menu bar. You can convert the text you have entered and the text you enter later into Traditional Chinese characters. If it is also the word2007 version, click the [Review] tab on the menu bar, and you will see the button option [Convert Simplified to Traditional Chinese] in the drop-down list.
- Office Software 470 2024-06-01 20:12:42
-
- What to do if Win11vmware is not compatible_How to solve compatibility issues
- 1. According to user testing, the official VMware16 version is compatible with win11 system. Method 2: 1. If it still doesn’t work, then we open the [C:$WINDOWS.~BTSourcesPanther] location of the c drive. (There may be hidden folders) 2. Then delete the [compatscancache.dat] folder and restart the software to solve the problem.
- Office Software 716 2024-06-01 20:10:55
-
- ppt2013 steps to search online templates and themes
- Open ppt2013 software. If you open the software itself directly, the page you open will be as shown below, where you can search and select directly. If a PPT has been opened, select the file in the menu bar, and then click New. You can enter the template search and selection page. Enter the keywords as needed in the search box, such as [resume], and press the Enter key; or directly in it Select from the several keywords provided, such as [Business] under the search box, etc. Wait for search results. You can see that there are many templates under the business keywords. Click on a template you think is good to enlarge the preview. If you think it suits your work needs, you can click Create and apply the template directly. After clicking Create, it will be downloaded quickly, and then you can create PPT according to your needs.
- Office Software 790 2024-06-01 20:02:28
-
- How to make PPT show only odd-numbered or even-numbered page slides
- Note that in the same way, you can set it to play only even-numbered slides, or you can set it to play only certain slides.
- Office Software 632 2024-06-01 20:02:04
-
- How to restore Tencent documents to the previously edited version
- Enter any document--click the upper right corner of the editing interface--"File"--"View revision history". Click on the version you want to restore. Click "Restore" in the upper right corner. Come and learn the operation process of restoring Tencent documents to the previously edited version in this article today. I believe it will be handy in future use.
- Office Software 681 2024-06-01 18:44:49
-
- How to import pictures in batches in Excel_A few steps to insert them in a regular manner
- 1. First, we select the entire table and adjust the column width and row height of the table. 2. Then click [Insert]-[Picture] to select and insert all the imported pictures. 3. Then set the size and width of the image in the image settings bar above. 4. Then insert the picture first in the last unit. And select all the pictures again, select [Align]-[Left Align] in the [Arrange] column, so that all the pictures will be arranged neatly. 5. In the last step, click [Align] - [Vertical Distribution] again. In this way, all the pictures will be neatly moved to their own cells, without you having to manually drag them one by one. Isn’t it very simple? Friends, go and try it. With this method, even if there are thousands of pictures, you won’t be able to trouble yourself. It’s half a point.
- Office Software 493 2024-06-01 18:08:21
-
- How to filter data in Tencent Documents_How to filter content in batches in Tencent Documents
- 1. Open the table in Tencent Documents. 2. Select the cells that need to be filtered. 3. Click Filter Data in the toolbar. 4. The filtering conditions will appear on the header. 5. Click the button on the table header to filter the data. 6. You can also sort the data.
- Office Software 922 2024-06-01 18:01:54
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
