Shulou(Shulou.com)06/03 Report--

This article mainly introduces in detail the steps for the use of the basic functions of excel, which is very suitable for beginners. Interested friends can refer to it and hope to be helpful to you.

Apply table format: start-- > apply table format

Template provided by EXCEL: file-- > New

Make template: file-> Save-- > template

Show hidden worksheet: right-click Workbook-> Show Hidden

Out of print: page layout-> Page setup-> Zoom ratio-> Ctrl + P print

Select print: region selection-- > Page layout-- > print area

Title printing: region selection-> page layout-- > print title

Set up printing paper: select table-- > page layout-- > paper size-- > paper direction

Print on one page: page layout-- > print area-- > Page setup-- > Page-- > adjust to one page width

Print comments: page layout-- > Page setup-- > worksheet-- > Annotation-- > end of worksheet

Print the title row per page: page layout-- > Page setup-- > worksheet-- > Top title row-- > Select area

Zoom in and print: page layout-- > Page setup-- > Page-- > modify the zoom scale

Import txt text into excel table: data-- > get external data-- > from text-- >

Split the contents of the excel table cell: insert a new column first-- > enter a space in the cell to separate-- > data-- > split-- > check the fixed width-- > drag the line.

Fixed table bar: view-> freeze window-- > freeze the first row

Import data from a web page into a cell: data-- > get external data-- > from website-- > enter URL-- > check

Auto-adjust cell: start-- > format-- > automatically adjust row height

Set the row height of the table: select cell-> start-- > cell-- > format-- >

Adjust cell: insert table-- > Select cell-- Design shading-- > start-- > numbering Library-- > define New numbering format-- > layout adjust Table height and width

Hide rows and rows: cell-- > Select right-click-- > hide

Highlight the conditional data: start-- > conditional format-- > greater than-- > fill in the value

Apply theme scheme: page layout-- > theme

Set background: page layout-- > background

Show edit bar: view-- > check-- > edit bar, title

Worksheet label color: worksheet-- > right-click-- > worksheet label color

Merge cells encounter numbering-- > start-- > numbering library-- > none

Display function formula: select cell-> formula-> display formula

Alt + =: summation formula

Alt + enter: force line wrapping

Ctrl + Shift + numbers (1 numeric format; 2 time; 3 date; 4 currency; 5 percentage)

F2: rename

Quickly enter data in the drop-down list: select cells-> data-- > data validity-- > Settings-- > sequence-- > enter "male, female"

Enter scores and negative numbers: cell input (88)-- check-- > Enter

Keep the last few decimal places: cell-- > right-click-- > format cell-- > numerical value

Enter a numeric value beginning with 0: single quotation mark-- > enter a numeric value (text)

Input isometric sequence 1mem3jue 5: cell input 1mi-> 3Mel-> drag

Start-- > fill-- > Series-- > step size

Limit input value: data-- > data validity-- > Settings-- > Integer-- > fill in the value

Ctrl + 1: automatic line wrapping; reducing the font in the cell

Convert numbers to uppercase: cell-- > checked-- > Ctrl + 1-- > Special-- > Type-- > Chinese capitalization

Sort data by multiple keywords: start-> sort and filter-> Custom sort-> add criteria

Sort by multiple strokes: start-- > sort and filter-- > Custom sort-- > options-- > check

Sort by multiple cell colors: start-> sort and filter-> Custom sort

Data filtering: cell area-- > Select-- > data-- > filter-- > text filter

Create a mini-image: insert-- > mini-- > select a cell

Delete Mini Picture: design-> clear

Function formula: click on the cell to be summed-- > start-- > function-- > Sum-- > drag the summed cell

Highlight cells: select the value area-- > start-- > conditional formatting-- > highlight cell rules-- >

If (mid (selected cell value), which value to start with) = "01", "Class one" assignment, if (mid)

Set document time: insert-- > date and time

Import data table: data-- > from text-- > 54936 simplified Chinese

RANK.EQ ranking function

Calculate the number of working days: NETWORKDAYS excluding Saturday

Quickly calculate the day of the week: WEEKDAYS

Division: Quotient

Convert RMB: RMB (numberi) Decimals specifies the number of decimal places

Report whether pass = IF (B12, cell value, ""): comment value cell value is greater than 2, take cell value, otherwise take null value

= TEXT (cell value 1,) & "/" & IF (cell value 2 > 2, cell value 2, "): merge cell values

= MID () take the middle value

First define numeric values, define arrays, then define text, and define arrays in and vlookup, select arrays and values, need to be fixed, select the second column

Double quotation marks are the definition text and $is a fixed value

= "int vlan" & VLOOKUP (I1thecontrol, "Fleur", "GMagne2")

= "ip add" & VLOOKUP (I2thecontrol,) & "& VLOOKUP (i2recractioncence, Crane, BPhone2)

= RANK.EQ (G1ZHINGLING1VOLING DINGULING 21JORE0) descending order

Vlookup auto-fill: formula-- > insert function-- > vlookup-- > first parameter selection (value cell)-- > second parameter selection (value table)-> third parameter (get the column values in the table)

Selective summation: sumif-- > first parameter selection (summation region)-> second parameter selection (condition region)-> third parameter input (value content text)-> fourth parameter (time date table)-> fifth parameter (judged to be greater than)

Highlight through color: select the numerical cell that needs to be highlighted-- > start-- > style-- > conditional format-- > other rules-- >

= if (mid (cell, 3Power2,) = "01", "set a value", if (mid (cell, 3Power2,) = "01", "set a value"))

Numerical arrangement: select the numerical cells to be arranged-- > start-- > Edit-- > sort and filter-- >

Calculate the average by classification: select all-- > data-- > hierarchical display-- > classified summary-- > classified field-- > summary method-- >

Display through the chart: select all-- > data-- > hierarchical display-- > hide detail data-- > selected data-- > insert-- > Chart

Ranking: rank.eq (cell, $A$1:$A$20)

Merge tables: data-- > data tools-- > merge calculation-- > function (summation)-- > reference location-- > browse (selected table)-- > add-- > check the first row and leftmost column

Display the day of the week by date: select date cell-- > format cell-- > customize "yyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyy

Judgment sentence: if (or (weekday function for judging date, selecting cell, 2 represents value) = 6 function for judging date, selecting cell, 2) = 7), "Yes", "No")

Calculated age: int ((today ()-date of birth) / 365)

Calculate the date of birth: MID (B7 ~ 7 ~ 7 ~ 4) & "year" & MID (B7 ~ 7 ~ 11 ~ 2) & "month" & MID (B7 ~ 13 ~ 10 ~ 2) & "Day"

Identify gender by × ×: IF (MOD (MID (B7jin17jin1), 2) = 1, "male", "female")

Ranking calculation function: = "No." & RANK.EQ (A2, recording, 2, 14, and 21) & "name"

If (A2 > = 90, "excellent", if (A2 > = 80, "good", if (A2 > = 60, "pass", "fail")

Enter cell R Wingdings-> start-- > font-- > Font 2

Segment display mobile phone number: select mobile phone number-- > Ctrl + 1-- > Custom-- > enter 000-0000-0000

Modify the number of undo 50 times: file-- > options-- > Advanced-- > maximum number of cancelable operands

Ctrl + F1 display Ribbon

Add project number: start-- > above paragraph-- > project number

After reading the contents of the appeal, have you mastered the basics of excel? If you want to know more related content, welcome to follow the industry information channel, thank you for reading!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.