current location:Home > Technical Articles > Software Tutorial > Office Software

  • How to create a line chart in Excel
    How to create a line chart in Excel
    1. Open Excel and create a new table. 2. Enter the table content that needs to be set. 3. Click [Insert] in the tab, then select the content that needs to be set, and click the settings button in the lower right corner of [Icon]. 4. You can see the setting interface as shown in the figure, select [Line Chart], then click on the style you want to set, and finally click the [OK] button to save the settings. 5. The effect is as shown in the figure. 6. If you need to change the chart title, you can double-click and click Edit, and then you can also change the chart style, color and other settings.
    Office Software 1257 2024-04-25 10:43:13
  • Word2013 calls up the operation content of the formula editor
    Word2013 calls up the operation content of the formula editor
    Install MathType software. Pay attention to its installation path. Find the MathPageMathPage.wll and OfficeSupportMathTypeCommands6ForWord.dotm files from the installation path of the MathType formula editor. In this step, you should pay attention to whether the Office 2013 version you installed is 32-bit or 64-bit. If you forget your Office version, you can choose 32-bit to try first, because most software will be backward compatible. Put the two files found above into the Office2013 path Office15STARTUP. At this time, click the MathType option in word2013 to send
    Office Software 852 2024-04-25 10:40:27
  • Introduction to how to set a background image in Word
    Introduction to how to set a background image in Word
    1. Click [Page Layout] ==> Click [Page Color]. 2. Click [Fill Effect] in the pop-up window. 3. Click [Picture] ==> Click [Select Picture]. 4. Find the picture you want to set here. 5. After selecting the picture, click [OK].
    Office Software 385 2024-04-25 10:40:19
  • How to use round function in excel
    How to use round function in excel
    1. First, let’s take a look at the ROUND function: Syntax: ROUND (number, num_digits) Parameters: number is required. The number to be rounded. num_digits required. The number of digits by which the number parameter is rounded. Return value: Returns a value rounded to the specified number of digits. Usage example: Enter [=ROUND(2.15,1)] in the EXCEL cell, which means rounding 2.15 to one decimal place, and the result return value is 2.22. First, we open the Excel worksheet and select the cell that displays the result. , click the button to insert a function in the toolbar. 3. After entering the function selection page, find ROUND
    Office Software 1246 2024-04-25 10:40:10
  • How to use draft fonts in draft and outline view in word 2010
    How to use draft fonts in draft and outline view in word 2010
    Open the word2010 document window, click the [File] → [Options] button, open the [Word Options] dialog box, and switch to the [Advanced] tab. In the [Show document content] area, select the [Use draft font in draft and outline view] checkbox, and set the draft font and font size respectively. After completing the settings, click the [OK] button.
    Office Software 815 2024-04-25 10:37:14
  • How to make the flowchart connection line move with the graphics in word - How to make the flowchart connection line move with the graphics in word
    How to make the flowchart connection line move with the graphics in word - How to make the flowchart connection line move with the graphics in word
    The first step is to open the word presentation. Create a presentation and create a slideshow. In the second step, delete the text box, and go to [Page Setup], adjust the height and width, and set the slide to portrait. The third step, as shown in the figure, is a flow chart we need to make. The fourth step is to select the corresponding shape in the [Insert] option to create a flow chart. The fifth step is to make connecting lines. Step six, the effect is as shown in the figure. The seventh step is to set the shape fill to [No Fill Color] in the "Drawing Tools" [Format]. Step 8: Set the [Alignment] method in [Drawing Tools] [Format]. Step 9: The effect is as shown in the figure. You can see that the connecting lines move with the movement of the graphics. Then enter content in each text box.
    Office Software 532 2024-04-25 10:34:20
  • Word2019 revision color setting method
    Word2019 revision color setting method
    1. First, after opening the document with Word2019, click the menu [Review]. 2. Then, under the Review menu item, click the arrow in the lower right corner. 3. At this time, a revision options window will pop up. Click [Advanced Options] in this window. 4. After opening the Advanced Revision Options window, click the drop-down arrow to modify the color of the specified item according to your needs. For example, here we change the color of [Delete Content] from red to blue. After modifying the color, click [OK] to close the advanced revision options window. 5. Then, click [OK] again to close the previously opened revision options window. 6. Later, when we revise the document, we will find that the revision color has changed and taken effect.
    Office Software 584 2024-04-25 10:31:06
  • How to use Excel array formulas
    How to use Excel array formulas
    1. Prerequisites for correct use of array formulas: To ensure the use of array formulas, you need to first select the result cell area to be generated, and make this area the same or equal to the area obtained by the entire calculation result. "2. The array formula is marked with a pair of curly braces. Therefore, after entering the formula, the array formula can be generated normally only after pressing [Ctrl+Shift+Enter] at the same time." 3. The array formula can only be used with other functions Only by working together can its powerful advantages be brought into play. In the process of using array formulas, relative cell references and absolute cell references must be used correctly to ensure the correctness of the calculation results. 2. Example introduction 1. For the table as shown in the figure, if you want to calculate A*B, first select [C1] to [
    Office Software 942 2024-04-25 10:30:46
  • How to use a form to create a lottery mini program in WPS - How to use a form to create a lottery mini program in WPS
    How to use a form to create a lottery mini program in WPS - How to use a form to create a lottery mini program in WPS
    1. Prepare a lottery list and set the winners and winning numbers. 2. Enter the function =RANDBETWEEN(1,8) in the winning number cell, and the value is from 1 to the number of participants. 3. Enter the function in the winner’s cell: =VLOOKUP(F5,A1:B9,2,FALSE). Enter a value based on the cell. 4. Then, click on the winner's cell, press and hold F9 to start the lottery, and release it to stop.
    Office Software 520 2024-04-25 10:28:37
  • How to create dynamic charts in Excel_Specific methods to create dynamic charts in Excel
    How to create dynamic charts in Excel_Specific methods to create dynamic charts in Excel
    First, copy the header of our table to the bottom, select the bottom of the name, click [Data] - [Data Validity], select [Sequence] in the Validity Condition Allowed, and then select the name column in the first row. After pressing Enter, click OK, so that we have a drop-down menu in the dynamic table below, and you can click to select the name of the character inside. Then we enter the vlookup search function in the sales data column below to find the sales data in the corresponding column based on the name. Here is a brief introduction to how to fill in the function. =VLOOKUP (search condition, search range, number of columns where the target value is located, precise search or fuzzy search) After filling in the function, we can fill the data to the left and fill in all sales data. In this way, we can follow
    Office Software 1218 2024-04-25 10:28:29
  • How to set up a PPT file to automatically jump to the last reading position_How to set up an automatic jump to the last reading position
    How to set up a PPT file to automatically jump to the last reading position_How to set up an automatic jump to the last reading position
    1. There is a shortcut key combination Shift+F5 in Word to return to the last editing location, but in PPT it starts playback from the beginning. Does PPT have a shortcut key with the same function? not at all. Nowadays, many PDFs and Words have built-in storage of the last reading position. If you just read it by yourself and don’t need to demonstrate or edit, you can convert it into a PDF file and that’s it. 2. When it comes to converting pdf, it is quite simple. First, print the PPT. 3. Select adobepdf as the printer, and the PDF file will be generated after confirmation. 4. Open the file with PDF-related software, I use Adobe acrobat, then set the save reading function and select edit. 5. Select Preferences from the Edit drop-down menu. 6. In the document
    Office Software 814 2024-04-25 10:25:34
  • How to quickly merge graphics in wps_wps merge graphics tutorial steps
    How to quickly merge graphics in wps_wps merge graphics tutorial steps
    1. After opening the interface, click the Insert menu above and select a shape graphic 2. Draw a black outline rectangle without fill 3. Then use the same steps to insert a diamond in the lower middle of the rectangle 4. Hold down the Ctrl key on the keyboard Select the rectangle and rhombus at the same time, find and click the combine button under the merge shape column to complete the merge and combination of graphics.
    Office Software 1199 2024-04-25 10:25:27
  • Detailed steps to insert built-in formulas into word 2010 documents
    Detailed steps to insert built-in formulas into word 2010 documents
    Step 1, open the word2010 document window and switch to the [Insert] ribbon. Step 2: Click the [Formula] drop-down triangle button in the [Symbol] group, and select the required formula (such as [Quadratic Formula]) in the built-in formula list that opens. Tip: When the computer is currently connected to the Internet, if the formula that the user needs cannot be found among the built-in formulas provided by word2010, you can point to the [Other formulas in Office.com] option in the formula list, and open the From Office Select the desired formula from the list of more formulas on .com.
    Office Software 1292 2024-04-25 10:22:44
  • How to use the shortcut key prompt function in word2010
    How to use the shortcut key prompt function in word2010
    1. Open word2010. Press the alt key and a prompt will appear. 2. Press the [N] key, and then press the [T] key to start the table insertion action.
    Office Software 988 2024-04-25 10:22:31
  • How to open et file in wps
    How to open et file in wps
    Double-click to open the wps form and proceed to the next step. In the opened wps table file, click the [WPS Table] button in the upper left corner of the interface, click [Open] in the pop-up drop-down box, and proceed to the next step. Find and select the et file you want to open, and click the Open button. This is the content of the et file that will be displayed.
    Office Software 530 2024-04-25 10:22:17

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.

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