Digital Media for Business

Digital Marketing can be defined as promoting of brands or products and services using all forms of digital advertising. The core is online marketing and all web related technologies; and Digital marketing uses Internet, mobile and any form of digital media to reach customers in a timely, relevant, personal and cost-effective manner. 

Course Outline:

Session 1: Company Website
1. Course Structure - How we work together to go through the course
2. Web Technology - the fundamentals about internets you need know
3. Website installation - have your website setup in 30 mins
4. Content Management - we focus on content, not the technology
Session 2: Basics of HTML
2. CSS
3. Firebug 
4. Deploy Web Application
Session 3: Work with Google
1. How Google works
2. Google Adword
3. Google Webmaster
4. Google Analytics
Session 4: Online Marketing
1. On Page SEO
2. Off Page SEO
3. Social Media Marketing
4. Email Marketing
Session 5: Graphic Designing Tools
1. Adobe Photoshop
2. More on Photoshop
3. Adobe Illustrator
4. More on Illustrator

Practical Business Reporting & Analysis 

Session 1: Analyzing Financial Statement 1
1. Income Statement 
2. Balance Sheet
3. Reference(Absolute, Relative and Mixed), Named Range ( Book, Sheet), and 3D Reference
4. Paste Special, Transpose, IF Operations and Array Operations
Session 2: Analyzing Financial Statement 2
1. Inventory Management
2. Cash Flow Analysis | SLN
3. Excel Table, Dynamic Named Range(Offset Function)
4. Pivot Table | Creation, Update and Filtering, Format / Paste Special
Session 3: Financial Planning and Control
1. Budgeting and Planning
2. Forecasting and Projections
3. Measuring Quality
Session 4: Sales and Marketing 
1. Importing Business Data
2. Exporting Business Data 
3. Analyzing Contributions and Margins
Session 5: Sales and Marketing (continue)
1. Pricing Analysis
2. Costing Analysis
3. Investment Analysis

本页最后更新: | -- | 网站设计和虚拟主机服务 CMS