Certificate in Microsoft Excel for Business ProfessionalsRapid Skillz
Price on request
- Short course
- 4 hours of study
What you'll learn on the course
IT Project Management
Microsoft excel training
This Course Consist of the following contents- 1.INTRODUCTION TO MICROSOFT EXCEL -Introduction to Microsoft Excel, How to format cells to make them look more professional, How to manipulate rows and columns, How to format numbers, How to format currency and date, How to perform calculations in Excel - Add, Subtract, Multiply, divide, How to use the Max, Min and IF functions, How to use Filter and Sort to work with large data sets, How to combine multiple cells using Concatenate, How to locate values in a table using VLOOKUP, How to generate graphs to make data more presentable. 2.MICROSOFT EXCEL FOR HR PROFESSIONALS -Structure a hiring and compensation plan, Calculate salaries and departmental costs, Generate graphs to depict hiring and compensation plan. 3.MICROSOFT EXCEL FOR MARKETING PROFESSIONALS -Marketing Plan framework and Budget Allocation, Customer acquisition funnel and Customer Acquisition Cost (CAC), Offline marketing plan, Marketing plan summary, Analyzing the marketing plan, Generate graphs to depict marketing data, Structure a Customer Analytics plan to identify customer metrics and identify trends, Make decisions using customer data. 4.MICROSOFT EXCEL FOR PROJECT MANAGEMENT PROFESSIONALS -Structure a Project Management Plan with tasks, owners, deadlines, Tracking Status, Structure a MIS / Operations Dashboard to track the status of various projects, Compare project status to budgets. 5.MICROSOFT EXCEL FOR SALES PROFESSIONALS -Structure a sales plan, Structure an account plan with ownerships, deadlines and status.
This Course is made for Students and The biggest advantage of this course - is you get to interact with world class faculty - just by interacting with them you learn a lot - whenever you have any doubts or need guidance – you can post your questions in the Discussion Forum and the faculty shall answer your questions.