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.
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
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."
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.