Typing underscores in Excel

Select the area

Press Ctrl + 1 (or right click, choose Format Cells)

Under Category, Go to Custom

Under Type, remove General, type #*_,click ok

Enter number and see the result

Excel Consolidate Data

Click Product (red)

Go to Data Tab > Consolidate

Add reference tables One-by-One

At the window of Consolidate

Under Reference, click on the blank

1) Choose the area of two column with multiple row

2) Then, click Add

Repeating step 1 & 2

After done add reference, click the box of Top row & Left column

Click OK

Excel Spin Button

to quickly increase or decrease numbers in Excel

Developer > Insert > Spin Button (Form Control)

Right-click the Spin Button > Format Control

At the window of Format Control, at the blank of Cell link: choose the Quantity cell

Excel 下拉菜单

一级下拉菜单

Choose the area of State B3:B13 (including title)

Click Data > Data Validation (Data Tools) > Data Validation 

At the window of Data Validation,

Allow: List

Source: E3:G3 (state category)

Click OK

二级下拉菜单

Choose the area of E3:G9 (including title)

Click Ctrl + G (or Home > Editing > Find & Select > Go to Special)

Click Special

Click Constants, then click OK

Go to Formulas > Define Name > Create Names from Selection

Make sure only Top row was click, then click OK

Choose the area of City C3:C13 (including title)

Click Data > Data Validation (Data Tools) > Data Validation 

At the window of Data Validation,

Allow: List

Source: =indirect(B3)          <Remove $>

Excel lookup functions: VLOOKUP (Vertical Lookup), XLOOKUP (Modern Lookup), HLOOKUP (Horizontal Lookup) & "INDEX & MATCH"

=VLOOKUP(B13,$B$25:$D$33,2)

=VLOOKUP(B15,B$25:D$33,2,0)

=XLOOKUP(B14,B25:B33,C25:D33,"No Data")

vlookup 一不小心会导致导入错误

XLOOKUP 比较安全，不会导入错误

VLOOKUP 漏掉了最后一个参数（最核心原因）

公式：=VLOOKUP(B13, B23:D31, 2)

导致的问题：你没有写第四个参数，Excel 会默认以为你要进行模糊匹配。而在模糊匹配下，如果你的工号序列没有严格按“从小到大”升序排列，Excel 就会彻底罢工，直接找错人或者返回错误值。

解决办法：必须加上 ,0 或 ,FALSE 来强制精确匹配。

___________________________________________________________________________

=HLOOKUP(B41,C49:G51,2)

=HLOOKUP(B42,C$49:G$51,2,0)

HLOOKUP 漏掉了最后一个参数（导致模糊匹配报错）

问题所在：公式末尾没有写 ,0 或 ,FALSE。Excel 默认进行模糊匹配，而你的数据横向并没有按字母顺序严格升序排列，所以必错无疑。

解决办法：必须在末尾加上 ,0 确保精确匹配。

________________________________________________________________________________

=INDEX(C64:F73,MATCH(D57,C64:C73,0),MATCH(C58,C64:F64,0))

=INDEX(Choose the area of reference table with title,MATCH(student name,student name list with title,0),MATCH(subject,subject list with title,0))

=INDEX(Choose the area of reference table with title,MATCH(student name,student name list column with title,0),MATCH(subject,subject list row with title,0))

美式英语

生活

有一段时间了 It's been a while

好久不见 Long time no see

我就不打扰你了 I'll get out of your hair

太巧了吧！What a coincidence

我信你个鬼 I don't buy it

别乌鸦嘴 Don't jinx it

去小便 go number one

去大便 go number two

我要尿尿 I need to pee

在这吃还是带走？For here or to go?

开吃吧 Dig in

晚饭好了 Dinner's on

钱不是问题 Money is no object

不麻烦，举手之劳 It's no bother

介意我坐下吗 Mind if I sit

慢慢来 Take your time

我突然明白了 It just hit me

谢谢你，还是算了吧 Thanks, but no thanks

问要不要某个东西时 I'm good/okay = 不用了，谢谢

老婆开心，日子舒心 Happy wife happy life

免费的 On the house

低调一点 Lay low

关心

你有什么烦恼？What's eating you?

活在当下 Seize the day

平安无事 Hunky-dory

没什么大不了 No biggie

不要轻看自己 Don't sell yourself short

祝你成功 Break a leg

坚持下去 Stay the course

别放在心上（没事）No hard feelings

你只能活一次 YOLO (You only live once)

活在当下，抓住现在 Carpe diem

你人真好 You are a peach

工作

你可以走了 You're excused

你不能逼我 You can't make me

我不是故意的 I didn't mean it

我都准备好了 I'm all set

我马上就到 I'm on my way

你有空吗？You got a second?

不要为难我 Go easy on me

收到 Ten-four

细节决定成败 The devil is in the details

重要的事先做 First things first

你先忙 Don't let me keep you

那我就不打扰你了 I don't want to keep you

注意安全 Stay safe

我会处理的 I'll see to it

重要的事先做 First things first

开会

开免提 Put it on speaker

直接说，讲重点 Cut to the chase

长话短说 Long story short

有话尽管说 Fire away

我说了算 I call the shots

我同意 I second

同意的举手 All those in favor

我反对 Objection

干得好 Way to go 干得漂亮

真是好消息 Music to my ears

照章办事 By the book

你知道规矩的 You know the drill

我是无名小卒 I'm nobody

你得靠你自己 You're on your own

我说不出哪里不对劲 I can't put my finger on it

我言出必行 I'm a man of my word

说到做到 Talk the talk walk the walk

我说话算话 My word is my bond

久仰大名/闻名不如见面 Your reputation precedes you

对我有什么好处？What's in it for me?

我怎么会知道 How was I supposed to know

干得好/好样的 Way to go

你可以走了 You're excused 

处事

刀子嘴豆腐心 His bark is worse than his bite

关我屁事 I don't give a shit

关你什么事 What's it to you

你管得着吗 Bite me

你有什么不满 What's your beef

你别得寸进尺 Don't push your luck

你还好意思说 You're one to talk

你欺人太甚 You are way out of line

胡说八道 Poppycock

日复一日，一天又一天 Day in and day out

我要改变了/我要重新开始了 I'm moving on

当面撒谎 Lie to my face

停止抱怨 Stop whining

不劳您费心了 Thanks for nothing

处境

进退两难/自相矛盾 It's a Catch-22

不成功便成仁 Go big or go home 要么出众 要么出局

机不可失，时不再来 It's now or never

只要开始，虽晚不迟 Better late than never

时间不等人 The clock is ticking

大器晚成 A late bloomer

改变永远不会太迟 It's never too late to change

扫兴/泼冷水 Rain on your parade

团结一致 Solidarity

我命由我不由天 I am the master of my fate

我持观望态度 I'm on the fence

一切顺利 Right as rain

最好的还没来 The best is yet to come

我懂你 I feel you

感情

不是我的菜 Not my type

我对你一见钟情 You had me at hello

缘分 Kismet

无人及你，你是唯一 No one but you

祝福

祝你成功 Break a leg

OFFSET PRINTING DEFECT

1. Hickeys 墨屎 / 脏点: A hickey occurs when a piece of dust or random mote sticks to either the plate or blanket of the offset printing press or the printing medium, which causes an imperfection on the printed page 当灰尘、杂质或其他微小颗粒附着在胶印机的印版、橡皮布（Blanket）或承印材料上时，会造成印刷品表面出现不规则的脏点或缺陷。
2. Roller Mark 墨辊痕 / 辊痕: Roller Mark means the unwanted transfer of ink from equipment to a printed sheet. Can occur due to roller setting, pressure setting, blanket condition and subtrate. 指印刷设备上的墨辊在印刷过程中产生的不正常油墨转移，在印刷品表面形成痕迹。可能由**墨辊调整、压力设定、橡皮布状态及承印材料（Substrate）**等因素造成。
3. Pilling 掉毛 / 纸毛堆积: A printing problem characterized by the accumulation of paper fibers 一种印刷问题，主要表现为纸张纤维或纸毛在印版、橡皮布或印刷表面上不断积聚，从而影响印刷质量。
4. Paper Dust 纸粉 / 纸尘: Dusting is a defect that appears during offset printing, resulting from fine particles of paper being extracted by the blanket. Caused by the paper fiber condition and trimming process 胶印过程中，由于橡皮布将纸张表面的细小纸屑、纸粉或纤维带起并转移，从而形成的印刷缺陷。主要与纸张纤维状况及裁切工艺有关。
5. Ghosting Mark 鬼影 / 鬼影痕: Ghosting in sheet-fed offset printing refers to the phenomenon in which glossy darker areas are visible on the back of otherwise even-ly colored surfaces with high ink concentration. The image on the front side reappears in the ghosting area.  在单张纸胶印中，当印刷区域存在较高的油墨覆盖率时，纸张另一面可能出现与正面图像相对应的较暗或较亮的影像。这种由正面图像在背面隐约重现的现象称为 Ghosting（鬼影）。
6. Mottling 斑驳 / 墨色不均: Print mottle is usually the result of uneven ink lay or non-uniform ink absorption across the paper surface, especially visible in mid-tone imagery or areas of uniform color such as solids and continuous-tone screen builds. 通常由于油墨铺展不均匀，或纸张表面对油墨的吸收不一致所造成的印刷缺陷。特别容易出现在中间调图像、实地色块及连续调网点区域，表现为颜色深浅不均或表面呈现斑驳状。
7. Scumming 起脏 / 非图文区上墨: A generic term for the presence of ink on non-image areas of the printing plate, which can be caused by a variety of press conditions. The symptoms occur when ink randomly appears on non-image plate areas and scum cannot be washed off easily. 指印版的非图文区域出现不应有的油墨。通常与印刷机的运行条件有关。当非图文区域随机出现油墨，并且不容易通过正常润版或清洗去除时，即称为 Scumming（起脏）。
8. Set-Off 背印 / 沾脏: The reduction or discharge of a debt by setting against it a claim in favor of the debtor / ink transfer to other printed sheet (over density can cause this issue - ink transfer to other sheet @ not enough sprayed powder) 指印刷完成后，尚未完全干燥的油墨从一张印刷品的正面转移到另一张印刷品的背面，造成背面沾墨或污染。常见原因包括油墨量过高、油墨密度过高、喷粉不足或干燥不充分。