Pivot tables are really very easy to create, but very powerful. By using Excel pivot tables, one can get very interesting and valuable business intelligence from your data in very little time. This short session aims to give you the techniques to use this valuable Excel tool creatively. It is enough time to learn a lot about Excel Pivot Tables, but there is very little time for other questions.
Develop true Digital Marketing Strategy expertise with DMI Specialist. Learn digital communications, analytics, marketing automation and budget & strategy formulation from Industry Skills Experts. Course Overview This dynamic online Diploma in Digital Strategy & Planning course covering topics in digital communications, analytics, marketing automation and budget & strategy formulation giving you the skills, know-how, strategy and techniques to be that change. Here is power. The power to influence. To speak to billions of people. Specialization is for when you don’t just want to play the digital marketing game anymore, you want to drive it. To change it. the DMI SPECIALIST online Digital Strategy and Planning certification is perfect for you to become an online digital marketer. Become a member and connect to the industry and white-hot opportunities. Here is power. The power to influence. To speak to billions of people. What’s New? Develop true Digital Marketing Strategy expertise with DMI Specialist. Learn digital communications, analytics, marketing automation and budget & strategy formulation from Industry Skills Experts. Learn every aspect of Digital Marketing Strategy across 9 modules of interactive learning to give you a highly relevant and deep knowledge of digital strategy, all wrapped up with the world’s most recognized digital marketing certification on completion. Program learning outcomes and content: WHAT WILL I LEARN? We give you the thinking and tools to become a leading player on the digital stage. Create powerful and dynamic digital strategy. See it manifest into real world, business-changing action. The modules are building blocks – of knowledge, of your vision, of the leading Certified Digital Marketing Specialist – Digital Strategy & Planning that is you. Here is what you need to know. Course Content: Introduction: We bring science to thought. We have created the 3i Framework which is designed to help you select the best digital strategy for your organisation and make it happen. The 3i is smart and rigorous. It’s transformative. And you shall be impressed. This module introduces this nifty piece of brainwork. Later modules expand on it. • The fundamental concepts underpinning the DMI 3i Methodology. • The how-to’s of business strategy development. • Key components in an effective digital strategy. • Strategic management, a long-sighted look at lasting, growing success Traditional Communications: In this model, we explore how the marketing classics still anchor any campaign – yet the contemporary digital campaign is a far more fantastical vessel. We look deep into how our tech is changing the consumer experience, and how we must respond. Digital Communications: We are living through extraordinary times. The opportunities are as big, sprawling and diverse as the World Wide Web. The challenge too is bigger. Markets are sophisticated and fragmented. Now, more than ever, thy most know thy consumer (and thy digital channels). Here we look at: the fundamentals of digital communications planning, improving ROI, understanding your audience. Where can they be found? How to engage them? Budgeting for your digital strategy and effective resources reviewing, measuring, and analysing your digital strategy. Digital Channels: Facebook, Linkedin, Instagram, Twitter, Snapchat and so on. They multiply and they proliferate. Yet in this great distraction and fragmentation, there is also great opportunity. This module covers: inbound and outbound strategies, cross media planning, the digital channel mix, and mobile marketing social media marketing. Content marketing that is relevant, timely and riveting the what, how and why of search engine marketing email marketing, affiliate marketing, and marketing automation display and video advertising best practice. Because we have eyes to see. Marketing Automation: Automation doesn’t beat inspiration but it sure makes a marketeer’s life easier and more exciting. Here is superpower, working quieting and perfectly under your orders, night and day. See how smart businesses are sharpening their edge with CRM software for better sales enablement, lead nurturing and way more. Budget & Resourcing: Money makes marketing go round. But value is where it’s at. This model goes deep on how to hit max ROI for any given budget. Then some consideration for that other precious resource, human talent. Explore: • Key factors to consider when planning a marketing budget. • Setting that marketing budget. • How to monitor and optimize a budget during campaign, execution. • The human element. • Recruit, train and keep top people. Big Data & Analytics: The Big Data & Analytics module will provide you with a broad understanding of Big Data, Advanced Analytics and Artificial Intelligence. You will learn the fundamental frameworks and understand how cutting-edge analytics tools are being used to help businesses succeed wildly. Digital Leadership: We are living in extraordinary times, which call for extraordinary leaders. That means you. You shall lead the transition from the remnants of traditional marketing and into the brave, new digital marketing world which you are helping to invent. And you shall lead with razor-sharp thought and strategy. You shall take your brand and your organisation to places yet undreamed of. Strategy Formulation & Plan: By now, you’ll have come a long way. You are (almost) ready to go forth, carve out new and unexplored neural pathways and digital markets. You are standing on the very edge of the leading-edge, and you are just about ready to spread those new digital super-wings and soar. But first, the ultimate strategy module; the ultimate in strategy. DURATION 8-10 Weeks WHATS INCLUDED Course Material Case Study Experienced Lecturer Refreshments Certificate
This advanced certification drills deep into the latest thinking to develop true digital marketing expertise. Course Overview This advanced certification drills deep into the latest thinking to develop true digital marketing expertise. Learn about Digital Strategy, CX, Search Marketing, Social Media, Leadership and more. Get world class, knowledge and insight: DMI EXPERT is our postgraduate level 140-hour course with an advanced, professional certification. It delivers breadth and depth of understanding of digital marketing and provides the learner with the digital and research skills to work at a management or strategic level. This certification is credit rated at level 11 on the Scottish Credit and Qualifications Framework and awarded 120 credit points by the SQA (Scottish Qualifications Authority), which is comparable to a postgraduate diploma awarded by a UK university. Program learning outcomes and content: What Will I Learn? We give you the thinking and tools to become a leading player on the digital stage. Create powerful and dynamic digital strategy, and access modern, career-defining training covering all key digital marketing disciplines. Course Content: Social Media Marketing: Learn how to create engaging content on social media and how to plan, execute, optimize and report on social media marketing campaigns across the key social platforms. • Social Research • Social Content • Facebook, Instagram, Pinterest • Twitter • LinkedIn • YouTube & Social Video • Social Apps • Social Commerce & Affiliate Marketing • Social Customer Service • Social Strategy Strategy and Planning: Gain all the key skills and practices associated with planning a successful digital strategy. Everything from digital channels, marketing automation, budgeting, analytics and digital leadership. • Digital Communications v Traditional Communications • Marketing automation and CRM • Budget and Resourcing • Big Data & Analytics • Strategy Formulation and Plan • Digital Communications & Channels • Omnichannel tactics CX, eCommerce and CRO: Learn the key concepts underpinning website optimization, conversion rate optimization and effective e-commerce for every business requirement. Build highly effective user experiences for your customers. • Website Optimization • UX Research & Design • E-Commerce Strategy • Applied E-Commerce • Graphic Design Essentials for Marketers Search and Digital Channels: Plan, implement, refine and report on search marketing campaigns. Drive traffic across all digital channels. Taught directly by Neil Patel and DMI’s experts, you’ll gain knowledge from people who actually use these tactics in the field. • SEO Setup & Content • SEO Workshop • Paid Search & Display Advertising • Measurement with Google Analytics • Email Marketing Strategy • Applied Email Marketing • SEO for ecommerce Digital Selling: Recognize the value of social selling and incorporate digital techniques to better engage with customers and prospects to drive increased conversion rates. • Fundamentals of Social Selling • Finding & Targeting Prospects • Attracting Customers • Closing & Retaining • Increasing Engagement Essential Skills: Gain all the essential skills all marketers, professionals and business leaders need to work effectively, productively and professionally in a collaborative business environment. • Project Planning • Creativity Skills • Personal Skills • Working With Others Leadership and Management: Develop practical skills and techniques that you can use to think strategically, build effective teams, deal with conflict and crisis and persuade and influence others. • Thinking Strategically • Building Effective Teams • Dealing with Conflicts and Crises • Persuading and Influencing DURATION 52 Weeks WHATS INCLUDED Course Material Case Study Experienced Lecturer Refreshments Certificate