Alt Q Instructions search box

Alt F Open "File"

Alt H Open "Home"

Alt N opens "Insert"

Alt P opens Page Layout

Alt M opens Formulas

Alt A opens "Data"

Alt R Open Review

Alt W Open View

AIt or F10 select the key that activates access

Alt F4 close Excel

Shift F8 selects non-adjacent areas

Shift F2 inserts comments into cells

Shift F3 insert function

Shift F11 insert new worksheet

Shift F5 "Find"

Shift F4 Find empty cells and move

Shift + Spacebar selects an entire row in the table

Shift + Arrow keys Select all areas in this direction

Shift Ctrl O Select all cells with comments

Shift Tab moves focus to the ribbon

Shift Enter selects the cell above

Ctrl A select all

Ctrl B Bold

Ctrl C copy

Ctrl D fill down

Ctrl E quick fill

Ctrl F Find

Ctrl G Go to page

Ctrl H Replace

Ctrl I italics

Ctrl J newline

Ctrl K hyperlink

Ctrl L insert table

Ctrl N New file

Ctrl Shift (—) cancel borders

Ctrl Shift: Enter the current time

Ctrl Shift Space Select All

Ctrl Shift End Select the last used cell

Ctrl Shift ~Apply "normal" number format

Ctrl Shift 1 Set value format

Ctrl Shift 2 sets time format

Ctrl Shift 3 Set date format

Ctrl Shift 4 Set currency format

Ctrl Shift 5 sets to percentage format

Ctrl Shift 6 sets the two decimal counting format

Ctrl Shift 7 selected cells

Ctrl Shift 8 Select used area

Ctrl 0 hides columns

Ctrl 1 displays the Format Cells window

Ctrl 2 to add/cancel bold

Ctrl 3 to add/cancel font italic

Ctrl 4 to add/cancel underline

Ctrl 5 to add unstrikethrough

Ctrl 6 switch

Ctrl 8 shows/hides outline symbols

Ctrl 9 hides rows

Ctrl F1 expand/collapse the ribbon

Ctrl F4 close selected window

Ctrl F5 restores the window size of the selected window

Ctrl F6 switches to the next workbook window

Ctrl F8 executes the "size" command

Ctrl F9 minimize window to icon

Ctrl F10 maximize/restore selected window

Max maximum value

Min minimum value

Sum Sum

Average

Int number rounding

Round rounding

IF judges based on conditions

And multiple conditions are true at the same time

Or one of multiple conditions is true

Vlookup looks up from another table based on conditions

Left intercepts characters from the left

Right intercepts characters from the right

Mid intercepts characters from the middle

Countif counts the number according to conditions

sumf sums by condition

Sumifs sums based on multiple conditions

Len string credit amount

lserror error value returned by the conversion formula

Substitute replaces old characters with new characters

Sumproduct sum count of single or multiple conditions

Number of old customers = repurchase rate × number of customers

Repurchase rate = number of repeat purchase customers/number of customer samples

New customers = number of customers - old customers

Conversion rate = (transaction) number of customers / UV

Click-through rate = number of clicks/page impressions

PV utilization rate = (transaction) number of customers/PV

Monthly customer growth rate = number of customers in the current month/number of customers in the current month-1

Price per customer = Alipay transaction amount/Number of Alipay transactions

Page open rate = number of clicks from the homepage to the baby page/number of homepage views

Number of pages visited per person = PV/UV (number of viewers/total number of page visitors)

Per capita time spent in the store = total visit time/UV

Collection rate = number of collections on the day/UV

Baby bounce rate = the number of visits that only visit a certain page of a product and then leave/the total number of visits to the baby

Inventory turnover rate = annual cost of products sold/average inventory value for the year

Moving sales rate = number of moving sales varieties/total number of store operating varieties × 100

CPC = financial cost/number of clicks

Period-on-month = (data of this stage - data of the previous stage) / data of the previous stage

Year-on-year = (data for the same period this year - data for the same period last year) / data for the same period last year

Through train fee = (next place’s bid × next place’s quality score)/your own quality score 0.01

Crowd tag deduction formula = key words bid price x crowd tag premium

Cost/Clicks = PPC (average clicks)

Conversion rate × customer unit price = UV value

UV price / average visitor cost = RO (production ratio)

Conversion rate × customer unit price / average visitor cost = ROI (production ratio)

Sales/Fantasy = ROI (production ratio)

Bid × Premium Bid = Bid ​​after Premium

I/gross profit margin (profit margin) = profit and loss production ratio line

UV value × gross profit margin (profit margin) = profit and loss average click price

Through train profit = (profitable average click unit price - actual average click unit price) × click volume

Average click price / conversion rate = conversion per order

Cost promotion cost/number of transactions = conversion cost per order