Привет

Описание вот:

The successful candidate will be responsible for co-coordinating outsourcing repairs periodical quote process which includes: Preparing the quote data, verifying periodical invoices and preparing summary information for weekly/monthly reporting as well as assisting in month-end/quarter-end/ year-end accounting process using the SAP system and summarizing information and preparing reports. Other duties will include: Assisting in maintaining adequate warranty reserve for BlackBerry products and analyzing the usage and requirement of warranty reserve; Assisting in preparing periodical Revenue and Cost forecasts; Budgeting general ledger account report analysis; Cost center reporting, analysis and budgeting for Cost center Managers internally; Month End Costing/Inter-co Costing Activities; Detailed weekly/monthly reporting package for Directors and Senior level Managers; Reviewing and approving various transactions where necessary (ie Purchase Orders, (Employee Change Notifications - ECN); Maintaining signing authority matrix for internal Repairs Organization as well as other reporting and analysis as required.

ESSENTIAL SKILLS AND QUALIFICATIONS



New Grad opportunity - preferably with 1-3 years of overall related experience

Blend of Industry experience with progressive responsibilities in financial planning, analysis and management

University/College degree required in related field (Business or Accounting designation)

Strong financial analysis skills and ability to convert actions/recommendations

Strong Excel skills

Proven ability to define improvements in financial reporting

Multi-tasking and ability to work independently

Excellent listening, written and verbal communication skills

You should relate your experience as close as possible to description(you were preparing weekly reports for you previous manager, worked with large amounts of data, etc). Tell them than you know how to create graphs, pivot tables. vlookup, hlookup. Be prepared to answer behavioral questions as well.

Я не работала с vlookup and hlookup. Pivot tables знаю, graphs относительно. Гугл дал массу ссылок на hlookop and vlookup.Достаточно ли почитать будет. чтоб разобраться?
Про поведенческое понятно, сначал будет интервью с Fin.An, then with an HR

entry level position?

i don't think you will be asked about vlookups during your interview.. In my own experience, the questions were mainly behavioral- tell me about a situation when you had to work with a difficult manager/co-worker and how you handled it..

i recomend for you to have a few key examples prepared in advance so that you can tailor them to the questions as you go.

As far as job specific stuff, the questions weren't detailed enough to show your abilities with data manipulation or excel knowledge.. i think the intent is to see if you can think logically and communicate clearly..

oh, i forgot to mention, my experience comes from interviewing and getting a job with one of the fortune 100.

Best of luck to you!

Я тоже думаю т.к. позиция entry level, то будут спрашивать behavioral questions, что-нибудь типa:

Behavioral Based Questions

• Tell me about a time the last time you worked on a team and what happened.

• Describe a situation where you were in a leadership role.

• Give me an example that demonstrates your ability to organize.

• Tell me about a time when you dealt with a conflict situation.

• Tell me about a specific time where you had to work under pressure.

• Give me an example of a time when you had to motivate others.

• Tell me about a time when you had to use your analytical skills to solve a problem.

• Give me an example of a time when you had to adapt to a new situation.

• Tell me about a specific time when you exhibited your creativity.

• Tell me about a time when you had to persuade someone to do something they didn’t want to do.

• Give me the details of a time when you had to manage a group of people.

• Tell me about a time when you showed particularly good leadership.

• How have you successfully worked with a difficult person?

• Share with me a time when you worked in an unstructured situation.

• Give me the details of a time when you had to deal with a major change.

• Give me an example of a time you had direct supervisory responsibilities.

• Give me an example that demonstrates your assertiveness.

• Describe an experience where you had to resolve a difference in personalities.

• Give me an example of when you showed initiative and took the lead.

• Share with me a time that you had to sell a new idea to a group of individuals who preferred to keep things as they are. How did you convince them to adopt your idea?

• Tell me about a time when you had too many things to do and you were required to prioritize your tasks.

И просто вопросы (может кому пригодятся!):


Background Questions

-Tell me about your background, your interests and work experiences.
- How did you decide on your career path?
-Why did you pick your area of concentration?

Industry, company, job related questions

-Why did you decide to seek a job with us?

-What are you looking for in a job?

-Why do you want to work in the ______ industry?

-What qualifies you for this position?


Previous Experience or Employment

-If I were to pick up the phone and call your last employer what would they tell me?
-What is the most difficult assignment you have tackled?

Short and long range goals

- What are your short-term goals?
-Where do you plan to be in 3-5 years?
-What are your long-term goals?


Working in groups

• When working in a group, what factors do you think must be present for a group to accomplish its goal?

• Can you describe for me a group situation that you thought worked very well? Why? What role did you play?

• Can you describe for me a group situation that you thought did not work well? Why?


Personal traits, character, values & preferences

-What three things do you want me to know about you?

- What characteristics or qualities do you value most in people?

- In general, how do you react to conflict?



Challenges, strengths & weaknesses

• Describe the most difficult situation you have been in and how you handled it.

• Describe one goal for yourself and what you did to meet it.

• Can you give me an example of a time that you successfully dealt with conflict?

• Can you describe for me a situation in which you exemplified leadership?

• What were the frustrations and satisfactions of being a leader?

• What has been your greatest failure in life?

• What has been your greatest accomplishment?

• What have you learned from your mistakes?

• Give me an example of when you were assertive and took the initiative to achieve some goal--a business example.

• Give an example or situation where you had to convince someone to do something.

• Tell me what you consider to be your greatest assets. Weaknesses?

• Describe one goal for yourself and what you did to meet it.

• Can you describe for me a situation in which you failed to accomplish your objective?

• How will your major strengths help you in this position?

• Would you describe a few situations in which your work was criticized?

• What was the biggest mistake you made?

• What was your most satisfying success?

• What have been your most important rewards?

интервью на ентры левел самые мерзкие, задают кучу дурацких ненужных вопросов

Little-lion писал(а):Я не работала с vlookup and hlookup. Pivot tables знаю, graphs относительно. Гугл дал массу ссылок на hlookop and vlookup.Достаточно ли почитать будет. чтоб разобраться?
Про поведенческое понятно, сначал будет интервью с Fin.An, then with an HR

prosto posmotrite help v excele
Syntax
VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)
смотрите пример attached (wo tabs).
good luck!

Little-lion писал(а):Я не работала с влоокуп анд хлоокуп. Пивот таблес знаю, грапхс относительно. Гугл дал массу ссылок на хлоокоп анд влоокуп.Достаточно ли почитать будет. чтоб разобраться?
Про поведенческое понятно, сначал будет интервью с Фин.Ан, тхен шитх ан ХР

<vlookup> и <hlookup> полезно знать, они совсем простые, посмотрите эти функции в <Excel Help>. Но из своего опыта работы с большими массивами данных советую упомянуть, что вы знакомы с <Access>. Его обычно мало кто знает, а все эти <matches> гораздо быстрее делать именно в нем, чем с использование <vlookup>. Тем есть небольшие подводные камни, но я уверена, вы разберетесь.