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