Table of contentIntroduction to Microsoft ExcelIntroduction to Microsoft ExcelHow to format cells to make them look more professionalHow to manipulate rows and columnsHow to format numbersHow to format currency and dateHow to perform calculations in Excel – Add, Subtract, Multiply, divideHow to use the Max, Min and IF functionsHow to use Filter and Sort to work with large data setsHow to combine multiple cells using ConcatenateHow to locate values in a table using VLOOKUPHow to generate graphs to make data more presentableMicrosoft Excel for HR ProfessionalsStructure a hiring and compensation planCalculate salaries and departmental costsGenerate graphs to depict hiring and compensation planMicrosoft Excel for Marketing ProfessionalsMarketing Plan framework and Budget AllocationCustomer acquisition funnel and Customer Acquisition Cost (CAC)Offline marketing planMarketing plan summaryAnalyzing the marketing planGenerate graphs to depict marketing dataStructure a Customer Analytics plan to identify customer metrics and identify trendsMake decisions using customer dataMicrosoft Excel for Project Management ProfessionalsStructure a Project Management Plan with tasks, owners, deadlinesTracking StatusStructure a MIS / Operations Dashboard to track the status of various projectsCompare project status to budgetsMicrosoft Excel for Sales ProfessionalsStructure a sales planStructure an account plan with ownerships, deadlines and statusProduct DescriptionICWA CMA INTER – Cost and Management Audit consists Complete Video Lecture + eBooks + Test Paper Package consists of top quality video lectures of around 85 hours duration, exhaustive notes and Test Paper. The full eCourse Package along with the required software is delivered on 16GB Pendrive. The eCourse is suitable for consumption on Windows PC/Laptop or Android Tablet/Smartphones.
Raj K Agarwal
Applicable For November 2014