What's the difference between buying a documentary and a documentary clerk? What do you mainly do? A little urgent, thank you!

What's the difference between buying a documentary and a documentary clerk? What do you mainly do? A little urgent, thank you! There is not much difference. Every company is different.

Mainly purchasing accounts and daily contact with suppliers.

What functions does a printing clerk need to learn from excel? And what forms do you make? First, let different types of data be displayed in different colors.

In the payroll, if you want to display the total wages of more than 2000 yuan in red, the total wages of more than 1500 yuan in blue, the total wages of less than 1000 yuan in brown, and others in black, we can set it like this.

1. Open the payroll workbook, select the payroll column, and execute the format → conditional format command to open the conditional format dialog box. Click the drop-down button on the right side of the second box, select the "greater than or equal to" option, and enter the value "2000" in the following box. Click the Format button to open the cell format dialog box and set the font color to red.

2. Press the "Add" button, and other conditions are set as above (1500 or above, and the font is set to "blue"; Less than 1000, and the font is set to "brown").

3. After setting, press the "OK" button.

Look at the payroll and see if the data of total wages are displayed in different colors according to your requirements.

Secondly, create a category drop-down list to fill in the project.

We often need to enter the company name into the form. In order to keep the names consistent, we use the "data validity" function to build a category drop-down list to fill in the entries.

1. In Sheet2, enter enterprise names into different columns according to categories (such as "industrial enterprises", "commercial enterprises" and "individual enterprises") to establish an enterprise name database.

2. Select column A (where the name of "industrial enterprise" is located), enter the character of "industrial enterprise" in the "Name" column, and press Enter to confirm.

Imitate the above operation and name columns B and C as "commercial enterprises" and "individual enterprises" respectively.

3. Switch to Sheet 1, select the column (such as column C) that needs to be entered into the enterprise category, and execute the data → validity command to open the data validity dialog box. In the Settings tab, click the drop-down button to the right of Allow, select the "Order" option, and in the "Source" box below, enter the order of "Industrial Enterprise", "Commercial Enterprise" and "Individual Enterprise" (the elements are separated by English commas), and confirm to quit.

Select the column (such as column D) where the enterprise name needs to be entered, and then open the data validity dialog box. After selecting the series option, enter the formula = indirect (C 1) in the source box and confirm to exit.

4. Select any cell in column C (such as C4), click the drop-down button on the right, and select the corresponding "enterprise category" to fill in the cell. Then select the cell corresponding to this cell in column D (such as D4), click the drop-down button, select the required enterprise name from the list of enterprise names in the corresponding category, and fill it in this cell.

Tip: If you don't need to print the column of "Enterprise Category" in the future, you can select the column, right-click and select the "Hide" option to hide the column.

Third, establish a new "Common Documents" menu.

Create a new "Frequently Used Files" menu on the menu bar, and add frequently used workbook files to it for easy calling at any time.

1. Click the right mouse button in the blank space of the toolbar and select the Customize option to open the Customize dialog box. In the Commands tab, select the new menu item under Category, and then drag the new menu item under Commands to the menu bar.

Press the "Change Selection" button and enter a name (such as "Public File") in the "Naming" box of the pop-up menu.

2. Select an item under the category (such as insert option) and an item under the command on the right (such as hyperlink option), drag it to the new menu (common file), and name it as above (such as payroll) to create the first workbook file list name.

Repeat the above operation and add several file list names.

3. Select an item (such as payroll) in the common file menu, click the right mouse button, and select Assign Hyperlink → Open option in the pop-up shortcut menu to open the Assign Hyperlink dialog box. By pressing the drop-down button on the right side of the "query range", locate the corresponding workbook folder (such as "salary". Xls "and so on. ) and select the workbook file.

Repeat the above operation to hyperlink the menu item with its corresponding workbook file.

4. When you need to open the workbook file in the Public File menu in the future, just expand the Public File menu and click the corresponding option.

Tip: Although we dragged the Hyperlink option to the Common Files menu, it did not affect the function of the Hyperlink menu item in the Insert menu and the Insert Hyperlink button on the Standard Toolbar.

Fourth, make a "professional symbol" toolbar.

When editing professional tables, we often need to input some special professional symbols. In order to facilitate input, we can make our own "professional symbols" toolbar.

1. Execute the command "Tools → Macro → Record New Macro" to open the "Record New Macro" dialog box, and enter the macro name? Like "fuhao 1"? And save the macro in your personal macro workbook, and then click OK to start recording. Select the "relative references" button on the "Record Macro" toolbar, then enter the required special symbol in the cell, and then click the "Stop" button on the "Record Macro" toolbar to complete macro recording.

Imitate the above operation and record the input "macros" of other special symbols one by one.

2. Open the custom dialog box, click the New button in the toolbar tab, and the new toolbar dialog box will pop up. Enter the name-professional symbol, and a toolbar will appear in the workspace.

Switch to the Commands tab, select Macros under Category, and then drag the Custom Button item under Commands to the professional symbol bar (drag any number of special symbol buttons).

3. Select one of the "custom buttons" and name it after the 1 point of the second secret skill.

4. Right-click a naming button, and select "Specify Macro" in the shortcut menu to open the "Specify Macro" dialog box, and select the corresponding macro (such as fuhao 1, etc.). ) and confirm the exit.

Repeat this step to link the button with the corresponding macro.

5. Close the "Customize" dialog box, and you can use the "Professional Symbol" toolbar to quickly enter professional symbols in cells like a normal toolbar in the future.

5. Use View Manager to save multiple printed pages.

Some worksheets often need to print different areas, so use the View Manager.

1. Open the worksheet that needs to be printed, drag the line (or line) that does not need to be printed with the mouse, select it and click the right mouse button. In the shortcut menu that appears, select the "Hide" option to hide the lines (or lines) that don't need to be printed.

2. Execute the command View → View Manager to open the View Manager dialog box, click Add to open the new view dialog box, enter a name (such as uploading a report), and click OK.

3. Show the hidden rows (or columns) and repeat the above operation to "add" other print views.

4. When you need to print a form in the future, open the View Manager, select the name of the form to be printed, and click the "Display" button, and the worksheet will be displayed immediately according to the preset interface. Simply set the typesetting, press the "print" button on the toolbar, and everything will be OK.

Sixth, let the data be sorted by demand.

What if you want to sort employees by department, and the information of these department names is not sorted in pinyin order or stroke order? You can sort by using a custom sequence.

1. Execute the "Format → Options" command, open the "Options" dialog box, enter the "Custom Series" tab, and enter the series sorted by department (such as "Agency, Team, Workshop 1, Workshop 2, Workshop 3", etc.). ) in the box below, and click the Add and OK buttons.

2. Select any cell in the "Department" column, execute the "Data → Sort" command, open the "Sort" dialog box, click the "Options" button to pop up the "Sort Options" dialog box, press the drop-down button in it, select the series just defined, and press the "OK" button twice to return. All data will be sorted as required.

Seven, completely hide the information.

The contents of some cells in the worksheet don't want to be seen by visitors, so we must hide them.

1. Select the cell (range) that needs to be hidden, execute the command format → cell, open the cell format dialog box, select the custom option under category in the number tab, and then enter "; ; ;" (English three semicolons).

2. Switch to the Protection tab, select the Hide option, and then press the OK button to exit.

3. Execute the "Tools → Protection → Protection Table" command to open the "Protection Table" dialog box. After setting the password, click OK to return.

After this setting, the contents of the above cells are no longer displayed, and even the transparent function of Excel cannot make them visible.

Tip: Under the "Protection" tab, please do not clear the "∨" sign in the check box before "Lock" to avoid others deleting your hidden information.

Eight, let Chinese and English input methods appear intelligently.

When editing a table, some cells need to enter English and some cells need to enter Chinese. It is really inconvenient to switch input methods repeatedly. Why not set it up and let the input method adjust intelligently?

Select the range of cells that need to input Chinese, execute the data → validity command, open the data validity dialog box, switch to the tab of input method mode, press the drop-down button on the right side of the mode, select the open option, and click OK to exit.

The Chinese input method (Chinese input methodNo. 1 in the input method list) will automatically open when any cell in the cell area where Chinese is to be input is selected in the future, and will automatically close when other cells are selected.

Nine, let AutoCorrect input unified text.

Do you often worry about typing some fixed words, such as computer newspaper? Then look down.

1. Execute Tools → AutoCorrect to open the AutoCorrect dialog box.

2. Enter "pcw" in the box below "Replace" (it can also be other characters, and "pcw" is lowercase), enter "Computer Newspaper" in the box below "Replace with", and then click "Add" and "OK" buttons.

3. If you need to input the above words in the future, just input the character "pcw"? Can we ignore the case of "pcw" at this time? , and then just confirm it.

X. customizing functions in Excel

Excel is rich in functions, but it can't meet all our needs. We can customize a function to perform some specific operations. Next, we will define a function to calculate the trapezoidal area:

1. Execute the menu command Tools → Macros →Visual Basic Editor (or press the shortcut key Alt+F 1 1) to open the Visual Basic editing window.

2. In the window, execute the "Insert → Module" menu command to insert a new module-Module 1.

3. Enter the following code in the code window on the right:

Function V(a, b, h)V = h*(a+b)/2End function

4. Close the window to complete the customization function.

In the future, you can use custom functions just like built-in functions.

Tip: Functions customized by the above methods can usually only be used in the corresponding workbook.

XI。 Insert a picture under the header.

The background added to the worksheet is arranged in a row under the whole worksheet. Can it only be ranked below the header?

1. Execute the command Format → Worksheet → Background to open the Worksheet Background dialog box. After selecting the picture to use as the background, press the Insert button to arrange the picture under the whole worksheet.

2. While holding down the Ctrl key, drag the cells (regions) that don't need to be lined with pictures with the mouse and select them at the same time.

3. Press the drop-down button to the right of Fill Color on the Formatting toolbar, and then select White in the color palette that appears. After this setting, the cell on the left has the line of the picture, but the selected cell (area) has no line of the picture (in fact, the picture is covered with "white").

Hint? Printing pictures under cells is not supported.

Twelve, use the hyphen "&"to merge the text.

If we want to combine the contents of multiple lines into one line, we can do it with a small hyphen "&"without using a function (assuming that columns B, C and D are combined into one column).

1. Insert two empty columns (column E and column F) after column D, and then enter the formula in cell D 1: = b1&; C 1。 D 1 .

2. Select cell D 1 again, and use "fill handle" to copy the above formula to the cell under column D, and the contents of columns B, C and D will be merged into the corresponding cell of column E. ..

3. Select column E, perform copy operation, then select column F, execute Edit → Paste Special command, open the Paste Special dialog box, select numerical option, and press OK to copy the contents of column E (not formula) to column F. ..

What are the main responsibilities of PMC in hardware and plastic factory? Mainly assist the planner and material engineer of PMC department to complete the document entry, document printing and signing.

What is the main job of the documentary clerk in the decoration company? The great gods helped to follow up. No matter which industry, the job is similar. The so-called follow-up is to work around the order. Responsibilities are generally: 1. Receive customer orders and confirm the requirements in the orders (such as delivery date and some special requirements ...) 2. Communicate with the production department to confirm the production cycle and reply to the customer delivery date. 3. Place an order with the production department and deliver the goods according to the order. 4. If the delivery can't be made on time, track the production progress.

What does the shoe clerk mainly do? Have you ever touched a computer at work? Civil work, computers will definitely be exposed.

Documentary clerks are responsible for tracking and supervising the business and avoiding flying orders.

That is to say, after receiving the order, we should manage all raw materials, auxiliary materials and products, and trace back whether the production situation can meet the customer's delivery date.

What are the responsibilities of being a documentary clerk and a personnel clerk in a small electronics factory? (Be more specific) Thank you! Documentary clerk: mainly assist business personnel to carry out follow-up work, count sales reports at various stages, collect and count effective market information, and sometimes handle customer objections; The departments you mainly contact are Sales Department, PMC, Finance Department, Purchasing Department, R&D Department and Production Department. Generally speaking, the documentary clerk is mainly responsible for a series of work of order follow-up;

Personnel clerk: mainly responsible for publishing and sorting out recruitment information, then screening qualified personnel and informing them to come for an interview; Sometimes you need to do your first interview, especially in a small factory; The other is the handover of the resignation of the person in charge and so on.

I hope the above information is helpful to you.

What is the main business documentary? See if this is pre-sale or after-sale. As far as I know, if it's a pre-sale, after the salesman finishes using it, the merchandiser is responsible for the follow-up customer tracking, confirming the customer's demand for products, collecting money, and delivering goods for inspection. If it is after-sales, it may be dealing with a lot of after-sales work such as coordinating customer relations, responding to customer complaints and maintenance.

Are you doing this now? Are you okay?

Have a place to live!

Then you should study this knowledge well ~

Look online when you are free ~

What is the documentary clerk of Shenzhen Henghuizhong Group? Documentary clerk of Shenzhen Henghuizhong Group, responsible for the follow-up of the company's existing customers, responsible for business contact and communication with customers, and maintaining customer relations. This is office work. You don't need to go out, it's not field work.

Documentary clerk refers to a full-time person who tracks products and services according to customer orders during the operation of an enterprise. The merchandiser is a salesman. His job is not only to passively accept orders, but also to actively carry out business development, target customers to implement sales follow-up, with orders as the goal, not just to carry out business documentary.

Documentary is a business assistant: Documentary often plays the role of assistant to business manager. They help business managers to receive, manage and follow up customers, so merchandisers should:

Reply (1) letter:

(2) Calculate the quotation

(3) Check and sign the form

(4) Fill in the reconciliation form

(5) Classification, sending and registration of samples

(6) Customer file management

(7) Customer reception

(8) Handling matters assigned by supervisors.

(9) Business contact with relevant departments

The merchandiser is the coordinator: the merchandiser tracks the delivery of products ordered by customers, that is, tracks production. The focus of tracking is production progress, goods declaration and shipment. Therefore, in a small enterprise, the merchandiser holds several positions, not only in the back office, but also as a production planner, material controller and possibly a buyer. In large enterprises, on behalf of the business department of the enterprise, urge the manufacturing department to ask for goods and follow up the delivery.