Certificate in Microsoft Excel for Business Professionals

Rapid Skillz
Online

Price on request

Important information

  • Short course
  • Beginner
  • Online
  • 4 hours of study
  • Duration:
    Flexible
  • When:
    Flexible
Description

This course teaches you about basics of Microsoft Excel, how excel is used in the field of HR, Project management, sales and marketing.

Important information
What are the course objectives?

The course aims to enable understudies to: Get Job ready, by mastering MS Excel as a business tool. Generate professional, presentable work efficiently using MS Excel. Make a data based marketing plan using MS Excel. Make a hiring and compensation plan using MS Excel. Make a Project Management Plan and a MIS (Management Information System) tracking plan. Make a data based sales plan using MS Excel.

Requirements: There is no such eligibility criteria required - this course assumes you have no background in Microsoft Excel. This course starts from the basics and slowly builds into advanced topics. You need an internet connection to access the course.

Venues

Where and when

Starts Location
Flexible
Online

What you'll learn on the course

Management
Excel
IT Project Management
IT
Microsoft Excel
Marketing
Sales
Project
Project Management
Microsoft excel training
MS Excel
IT Management
Sales Training

Course programme

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.

Additional information

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.