what is your background? how well do you know excel? give me examples of how to build a pivot table? what does the formula for VLOOKUP look like? if you could get someone to make any changes to excel what would it be? how have you handled a complex situation?

Behavorial Questions: 1. What is AWS? 2. Tell me about a time when you took on something significant outside your area of responsibility. 3. Tell me about a time when you made a hard decision to sacrifice short term gain for something that would create long term value for the business. 4. Tell me about a time when you gave a simple solution to a complex problem. 5. Tell me about a time when you worked against tight deadlines and didn’t have time to consider all options before making a decision 6. Tell me about a time when you had to gather information and respond immediately to a situation? 7. Tell me about a time when you realized you needed a deeper level of subject matter expertise to do your job well. 8. Give me an example of a tough or critical piece of feedback your received. 9. Tell me about a time when your team’s goals were out of alignment with another team you relied on to meet your goal. 10. Tell me about a specific metric you have used to identify a need for a change in your department. 11. Tell me about a time when you were trying to understand a complex problem on your team and you had to dig into the details to figure out. 12. Tell me about a time when you not only met a goal but considerably exceeded expectations 13. Give me an example when you were able to deliver an important project under a tight deadline. 14. Describe a difficult interaction you had with a customer. 15. Tell me about a time when you went above and beyond for a customer There was more but dont remember them. Technical Skills (HIGHLY WEIGHTED vs Behavorial) 1. Describe the formular of Vlookup. How do you use it? 2. Describe Index and Match. How do you use it? 3. How do you create a pivot table? Give me an example.