Excel for Marketing Training
January 23, 2021 2021-04-01 13:35Excel for Marketing Training
Excel for Marketing Training
Course Details
- Modules : 6
- Projects : 10
- Eligibility : HSC/SSC
- Learning Mode : Online / Classroom
Enroll Now
ONLINE COURSE
CLASSROOM COURSE
INTRODUCTION
It will help you learn about Sales Productivity Dashboard, Restaurant Billing System using Microsoft Excel VBA, Creation of Basic CRM by using Microsoft Excel, Microsoft Excel for Business Professionals and Managers.
CURRICULUM
Marketing has a lot of data because without data marketing can’t improve its deliverable. As a result, it’s imperative that we learn MS Excel so very well that there’s no room for error.
And that’s why we brought you this Excel for Marketing Course. Just have a look at the curriculum and we will realize that learning these will help you master the data analysis part of marketing and your effort and initiative would produce better results –
Sr. No. | Course Name | Duration | Course Description |
1 | Microsoft Excel 2016 – Beginners | 4 | This is the first module of this Excel for Marketing Course. And as we always start with the basics, this module is no exception. You will learn about a brief overview of MS Excel 2016. Then, we will take a case study and you will learn about data entry, populating the case study in Excel, calculations, formulas, formatting, updating a calculation, percentages & absolute references, conditional formatting in excel, IF function in excel, count-if & sum-if function, graphs, charts, common errors etc. You need to watch 37 videos in total to cover this module. |
2 | Microsoft Excel 2016 – Advanced | 5 | This Excel for Marketing Course module is the extension of the previous one. In this module, we will teach you about the advanced excel functions, data functions, what-if analysis, pivot tables, auditing & troubleshooting formulas, advanced charts, important excel tools etc. This entire module will need you to watch 47 videos in total. |
3 | Attendance Register using Microsoft Excel VBA | 2 | In this Excel for Marketing Course, we will first start with a brief introduction to the attendance register using Excel VBA. Then, we will talk about creating the project interface, generating student ID in the attendance register, and displaying date & save mark. This entire module will need you to watch 24 videos. |
4 | Sales Productivity Dashboard – Beginners Training | 7 | In this Excel for Marketing Course module, you will start with a brief overview of sales productivity dashboard. Then, we will talk about database creation, formatting, index, business analysis, zone state, consolidation, tenure, age group, CAGR, moving average, standard deviation, exit analysis, growth ratios & scenarios etc. You will also learn about advanced filter & hyperlinks. This entire module will need you to watch 49 videos. |
5 | Sales Productivity Dashboard – Advanced Training | 7 | This module is the advanced version of the previous module. You will learn about data formulas, formatting, macro, sigma analysis, budget, pivot table & chart, consolidation & trend analysis, Monte-Carlo simulation, null matrix, active vis-a-vis, inactive analysis, histogram & regression analysis, rank & percentile & descriptive statistics, index & headers etc. This entire module will need you to watch 59 videos in total. |
6 | Restaurant Billing System using Microsoft Excel VBA | 3 | In this Excel for Marketing Course, we will start with a project introduction session. Then, we will learn how to create an interface, how to create billing calculator, how to activate currency, how to create checkbox & text box, and finally, how to create tax & home delivery button. This entire module will need you to watch 20 videos in total. |
7 | Creating an Interactive Dashboard using VBA | 2 | In this Excel for Marketing Course, you will learn about raw data, how to use them, how to add buttons, how to hyperlink buttons and savings workbook. You will also learn what are sales by product, what are sales by region, and what is a scroll bar. This entire module will need you to watch 22 videos in total. |
8 | Creation of Basic CRM by using Microsoft Excel VBA and SQL Express | 4 | In this Excel for Marketing Course module, we will give a brief overview of the CRM using Powerpoint. Then, we will give you a basic demo of running CRM, VBA Books learning process & access DB, VBA coding, and the admin module. This entire module will need you to watch 30 videos in total. |
9 | Interactive Dashboards using Microsoft Excel VBA | 2 | In this module, we will first give you an overview of the interactive dashboard of VBA. Then, we will go in detail on the quality check dashboard and a login compliance dashboard. This entire module will need you to watch 12 videos in total. |
10 | Creating a Sales Dashboard using Microsoft Excel | 2 | As we always do, at the beginning we will give you a brief overview of the excel dashboard. Then, we will go in detail about what an excel dashboard is, how to create a pivot table, pivot chart, and slicer. This entire module will need you to watch 13 videos in total. |
11 | Microsoft Excel Dashboard Training | 6 | This is an extension of the previous Excel for Marketing Course module. You will learn about the creation of excel dashboard, how to use formulas and formatting. You will also understand the types of filters, graph & formatting, demographics, how to create the compensation button, and import access & export access. You need to watch 55 videos in total to cover the module. |
12 | Microsoft Excel for Business Professionals & Managers | 1 | In this last Excel for Marketing Course, we will start with a brief overview of the excel for business professionals & managers. You would also know how to deal with client data & function and text & function. You need to watch 12 videos in total to cover the entire module. |
TARGET AUDIENCE
- Students of marketing/business management: If you are an undergraduate or a graduate student of marketing or business, this Excel for Marketing Course is a perfect for you. You would be able to learn so much from this course and as a result, you would be able to showcase the same skills during your interviews with corporate.
- Marketing Professionals: This Excel for Marketing Course would be a great value addition if you are working as a marketer in a company. This course would help you brush up your MS Excel so that you can take out the data and analyze them using all the advanced functions and formulas.
- Entrepreneurs: If you’re an entrepreneur, marketing is a big part of your activity. And having knowledge in MS Excel will help you excel at marketing. And as a result, you would be able to measure the ROI better.