Business Finance

Certificate in Microsoft Excel for Business Professionals (Online)

Certificate in Microsoft Excel for Business Professionals Complete Video Lectures from Dezyre

Overview of Certificate in Microsoft Excel for Business Professionals (Online)

Certificate in Microsoft Excel for Business Professionals Complete Video Lectures from Dezyre consists of top quality video lectures of around 23 hours duration. This course is offered online. The eCourse is suitable for consumption on all kind of devices with internet connection.

Table of contents

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

Microsoft Excel for HR Professionals

Structure a hiring and compensation plan

Calculate salaries and departmental costs

Generate graphs to depict hiring and compensation plan

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

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

Microsoft Excel for Sales Professionals

Structure a sales plan

Structure an account plan with ownerships, deadlines and status

 

About faculty of Certificate in Microsoft Excel for Business Professionals (Online)

Binny Mathews
"Binny's expertise is in Corporate Finance, Online Education and Entrepreneurship. He is currently the Co-founder of DeZyre.com. Prior to DeZyre, Binny was a Senior Analyst in the Investment Banking Division at Credit Suisse (New York & San Francisco) working with clients in Media and Technology. At Credit Suisse he worked on transactions over US$25 billion including the SBC-AT &T Merger, Dice.com IPO and First Solar IPO apart from advising clients such as Comcast, Tribune, Global Crossing, eBay, Yahoo, Comcast and Level 3."

About institute

Dezyre, Bangalore
Dezyre is an online academy that provides training in job related skills. We are a passionate bunch of people, who believe that the right kind of exposure and knowledge can be life changing. We build Dezyre to bring together world class faculty and students. Our faculty have premier backgrounds and teach industry relevant topics in an easy to understand manner. Since all of this teaching is through the internet, we provide you with quality, convenience and value for money.

Reviews of Certificate in Microsoft Excel for Business Professionals (Online)

Rating - 4.6
5 stars 1
4 stars 0
3 stars 1
2 stars 0
1 stars 0

Have you used
Certificate in Microsoft Excel for Business Professionals (Online)?

Rate Now:
OR
WRITE A REVIEW
Loading
Refer Your Friends
How to refer?

1 Click link below to share on facebook

OR

2 Enter your friends email address and invite them to join cakart (comma seperated)

Buy India's Best CA, CS, CMA Faculty Video Classes only at CAKART
Set up a call back request
Let us call you back

Any Question on video classes & books for your exam?

Set up a call back request