A Simple Formula for Answering "Tell Me About Yourself"

Now, this is not an invitation to recite your entire life story or even to go bullet by bullet through your resume. Instead, it’s probably your first and best chance to pitch the hiring manager on why you’re the right one for the job.

A formula I really like to use is called the Present-Past-Future formula. So, first you start with the present—where you are right now. Then, segue into the past—a little bit about the experiences you’ve had and the skills you gained at the previous position. Finally, finish with the future—why you are really excited for this particular opportunity.

example:

If someone asked, “tell me about yourself,” you could say:

“Well, I’m currently an account executive at Smith, where I handle our top performing client. Before that, I worked at an agency where I was on three different major national healthcare brands. And while I really enjoyed the work that I did, I’d love the chance to dig in much deeper with one specific healthcare company, which is why I’m so excited about this opportunity with Metro Health Center.”

Remember throughout your answer to focus on the experiences and skills that are going to be most relevant for the hiring manager when they’re thinking about this particular position and this company. And ultimately, don’t be afraid to relax a little bit, tell stories and anecdotes—the hiring manager already has your resume, so they also want to know a little more about you.

read more

香港海關 助理貿易管制主任

文職執法人員，部門為香港海關其中一個bureau，早期工作主要是管制出入口產地來源，紡織品配額，冒牌貨，是由一班海關軍裝分支出來成立的，由於現時無紡織品配額，主要工作是做商品說明，戰略物資……

要執行調查，取口供，拘捕，上庭，檢控，近年還要駐守邊境管制站，軍裝截車，交俾你follow

雖然不是紀律部隊，但是under C&E，所以紀律要求比一般部門高

要on call ，不用輪更，無需槍械訓練

最高職位是SPTCO，即AD級

2012年有過萬人申請，筆試有8800人

得500人可以獲得interview 機會爭取35 個空缺

interview係大部份用英文答
(主要問 個人問題 & 處境題)
............................           
模擬問題：
早前新聞報導：
"有關太陽燈的監管，衛生署說是產品安全問題，所以應由海關監管；海關說太陽燈不是消費品，所以應由機電工程署監管；機電工程署說，這是健康產品，所以應由衛生署監管。" 如果你是海關的發言人，被傳媒問及時你會如何闡述、解釋海關的立場和和提出論證？

你試試搜集資料試答一下。未必問中呢條，但相信你如果答到，其他tricky問題都應該對你零難度。

被問到,有否曾經使用翻版軟件,或非法下載MP3,買翻版碟等?
我相信香港都有很多人有這些經驗...
會如何應對呢?

ans1. 
you may say in the past you had, but after you see the website of c and e you understand the importance of property rights, you never do it again, it demonstrate your integrity and the facts

you should not reply yes or no, because you do not know the fact either by customer council, c and e or e and m dept, you may say still be investigate

those responsibilities are excuted by c and e with different division

ans2.
Please note that your proposed question is related to trade controls, not under the purview of the c&e service.  only relevant to those who wish to apply for a job of assistant trade control officer.

...............................
Look at:

http://www.customs.gov.hk/chi/major_c.html
海關真係忙到呢:
進 ／ 出 口 清 關
保 障 消 費 者 權 益
應 課 稅 品
牌 照 及 許 可 證 之 申 請
進 ／ 出 口 報 關
保 護 知 識 產 權 工 作
毒 品 管 制

其中"保障消費者權益"應教多人忽略，包:

                                                --  度 量 衡 之 執 行 條 例
-- 商 品 說 明 [ ( 標 記 ) ( 黃 金 及  黃 金 合 金 ) ( 白 金 ) ] 令 之 執 行
--玩 具 及 兒 童 產 品 安 全 管 制
--消 費 品 安 全 管 制

要做資料搜集，唔好單憑commonsense打天才波。
仲有留意多D海關o既新聞，同埋留意就海關工作咁多個範疇同其他不同o既部門o既合作，有D 工作看似overlap，但其實有唔同，準備好點答就唔駛怕俾人問到口啞啞。
....................

睇下政府新聞稿啦
除左基本野外, 新聞稿可以學到好多野

read more

Excel Sales Forecasting For Dummies

From Excel Sales Forecasting For Dummies by Conrad Carlberg

For confidently and quickly forecasting your sales, Excel is an effective tool. Use some simple rules for establishing your baseline (past data); and then the Excel sales forecasting toolpak, forecast functions, or LINEST function will help you predict your sales with ease.

The Analysis ToolPak in Excel Sales Forecasting

The Analysis ToolPak in Excel sales forecasting figures out what's going on with your data without your having to enter formulas. Excel's Analysis ToolPak has three useful tools for directly forecasting — Moving Average, Exponential Smoothing, and Regression — along with others that can help. Here's a list of some tools that are part of the Analysis ToolPak:

Tool	What It Does
ANOVA	There are actually three different ANOVA tools. None is specifically useful for forecasting, but each of the tools can help you understand the data set that underlies your forecast. The ANOVA tools help you distinguish among samples — for example, do people who live in Tennessee like a particular brand of car better than those who live in Vermont?
Correlation	This tool is an important one, regardless of the method you use to do your forecast. If you have more than one variable, it can tell you how strongly the two variables are related (plus or minus 1.0 is strong, 0.0 means no relationship). If you have only one variable, it can tell you how strongly one time period is related to another.
Descriptive Statistics	Use the Descriptive Statistics tool to get a handle on things like the average and the standard deviation of your data. Understanding these basic statistics is important so you know what's going on with your forecasts.
Exponential Smoothing	I hate this tool's name — it sounds ominous and intimidating, which the tool is not. When you have just one variable — something such as sales revenue or unit sales — you look to a previous actual value to predict the next one (maybe the previous month, or the same month in the previous year). All this tool does is adjust the next forecast by using the error in the prior forecast.
Moving Average	A moving average shows the average of results over time. The first one might be the average for January, February, and March; the second would then be the average for February, March, and April; and so on. This method of forecasting tends to focus on the signal (what's really going on in the baseline) and to minimize the noise (random fluctuations in the baseline).
Regression	Regression is closely related to correlation. Use this tool to forecast one variable (such as sales) from another (such as date or advertising). It gives you a couple of numbers to use in an equation, like Sales = 50000 + (10 * Date).

Excel Sales Forecasting Functions

Give these sales forecasting functions in Excel a good baseline and you can get a handle on future sales business. Some Excel forecast functions and their actions appear in the following chart — keep it handy:

Function	What It Does
CORREL	The worksheet version of the Analysis ToolPak's Correlation tool. The difference is that CORREL recalculates when the input data changes, and the Correlation tool doesn't. Example: =CORREL(A1:A50, B1:B50). Also, CORREL gives you only one correlation, but the Correlation tool can give you a whole matrix of correlations.
LINEST	You can use this function instead of the Analysis ToolPak's Regression tool. (The function's name is an abbreviation of linear estimate.) For simple regression, select a range of two columns and five rows. You need to array-enter this function. Type, for example, =LINEST(A1:A50, B1:B50,,TRUE) and then press Ctrl+Shift+Enter.
TREND	This function is handy because it gives you forecast values directly, whereas LINEST gives you an equation that you have to use to get the forecast. For example, use =TREND(A1:A50,B1:B50,B51) where you're forecasting a new value on the basis of what's in B51.
FORECAST	The FORECAST function is similar to the TREND function. The syntax is a little different. For example, use =FORECAST(B51,A1:A50,B1:B50) where you're forecasting a new value on the basis of the value in B51. Also, FORECAST handles only one predictor, but TREND can handle multiple predictors.

The LINEST Function in Excel Sales Forecasting

The LINEST (or linear estimate) function in Excel sales forecasting uses formulas to calculate a regression equation and related statistics. This chart shows the information the Excel LINEST function will give you:

	Column 1	Column 2
Row 1	The coefficient you multiply times the X values	The intercept
Row 2	The standard error of the coefficient	The standard error of the intercept
Row 3	The R-squared value, or coefficient of determination.	The standard error of estimate
Row 4	The F-ratio	The degrees of freedom
Row 5	The sum of squares for the regression	The sum of squares for the residual

Setting Up Your Baseline in Excel Sales Forecasting

You need to provide a solid baseline (history) in order for your Excel forecast functions to work accurately in Excel sales forecasting. This chart shows you some ways to arrange data for your baseline:

The Issue	How to Deal with the Issue
Order	Put your historical data in chronological order, earliest to latest.
Time periods	Use time periods of approximately equal length: all weeks, all months, all quarters, or all years.
Same location in time	If you're sampling, then sample from the same place. Don't take January 1, February 15, March 21. Instead, use January 1, February 1, March 1, and so on.
Missing data	Missing data is not allowed. If you have every month except, say, June, find out what June's sales were. If you can't, get the best estimate possible — or start your forecasting with July.

Source: http://www.dummies.com/how-to/content/excel-sales-forecasting-for-dummies-cheat-sheet.html

read more