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
1. 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
（更多资料和具体参加方法）
