Question: please use Microsoft Excel to answer this question and give the answer with Microsoft Excel it's a request thank you Problem Topic #1: Job Searching

please use Microsoft Excel to answer thisplease use Microsoft Excel to answer thisplease use Microsoft Excel to answer this question and give the answer with Microsoft Excel it's a request thank you

Problem Topic #1: Job Searching Scenario: you work as an assistant in a human resources department supporting the recruitment and hiring of new staff. Your responsibility is to support the staff who prepare job postings. One day, your manager comes to you and says that they have noticed the job postings they place for administrative assistants yield many results of people who have qualifications beyond the bare minimum. They are curious to know if there are any knowledge, skills, and abilities they should be including on job postings that weren't included before. They are aware that there are many different types of administrative assistant positions and each comes with many useful qualifications. Task: You need to prepare an Excel Workbook that manages job-related data for Administrative Assistant positions. Your manager wants to know what jobs are currently available and what is said on the job postings. These positions can have the following job titles: administrative assistant, administrative clerk, accounting clerk, marketing assistant, HR assistant, administrative specialist, administrative coordinator, typist, data entry clerk, office manager, receptionist, executive assistant, secretary, administrative officer. Make sure you use advanced Excel functions to analyze and organize the data. You will have to perform google searches to find job postings of the positions listed above in the city you live in. New job postings can go up every day so make sure you check job search engines once a day. You should gather at least 10 different postings. TIP: subscribe to job alerts on job search engines to receive emails every time a related job is posted. You will have to perform google searches to find job postings of the positions listed above in the city you live in. New job postings can go up every day so make sure you check job search engines once a day. You should gather at least 10 different postings. TIP: subscribe to job alerts on job search engines to receive emails every time a related job is posted. You will have to make tables that compile all of the knowledge, skills, abilities, responsibilities, requirements, education, years of experience, technical proficiencies, duties, benefits, work schedule and status (full time, part time, days or evenings), location, pay (if listed), the name of the employer/company/organization, and the location. Include any other details that are provided in each job posting. Make sure you include the date of the posting and a hyperlink to where you found it. Hint: when analyzing the data, try to answer the following questions: 1. How often do some of the skills appear in the data? 2. Is there any data that is used in almost all of the postings, aka the most popular skills? 3. What is the average amount of years of experience for each position? 4. Is there a level of difficulty you would designate to certain jobs? 5. Are any of the skills, knowledge, and abilities taught in the BAA program? Page - 2

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!