Certificate in Microsoft Excel for Business Professionals

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.