BRIEF PROGRAM OVERVIEW

Are you a Professional involved in decision making, reporting, business forecasting, valuation; data analysis; interpretation and presentation of business, financial, accounting, economic data among others? These training will enable you to effectively use Excel (Spreadsheet) to organize unorganized data into a useful information for decision making. The training is going to be a hands-on for a wide range of practical situations.

Our analytics training lets you learn exactly what you need to know in becoming an expert in excel and E-view packages and usages especially as it concerns:         Data Analytics, Financial Modelling, and Dashboard Executives.

The course is led by highly experienced Excel and Econometrics trainers with many years of experience. Our hands- on courses mean that you will leave with practical experience as well as useful tips and tricks.

ABOUT FINANCIAL MODELING & DATA ANALYTICS

Financial Modeling is one the most fundamental and widely sought after skills in the finance industry. It is the art of building a model to depict financial statements and investment analysis using MS Excel. This helps arrive at optimal business solutions by analyzing various parameters. Financial models can be used to represent the performance of a business, a project or any other investment. In today’s world, all decisions made are based on quantitative analysis. This is why Investment Business Analyst, Bankers, Equity Research Analysts and Fund Managers find Financial Modeling indispensable.

Data Analysis – The ability to analyze data is a powerful skill that helps you make better decisions. Microsoft Excel is one of the top tools for data analysis and the built-in pivot tables are arguably the most popular analytic tool. This program will walk you through the entire data analysis process, which includes: Posing a question; Wrangling your data into a format you can use and fixing any problems with it; Exploring the data, finding patterns in it, and building your intuition about it; Drawing conclusions and/or making predictions and Communicating your findings

COURSE OBJECTIVES

  • Create flexible data aggregations using pivot tables
  • Represent data visually using pivot charts
  • Calculate margins and other common ratios using calculation on pivot table
  • Filter data using slicers in multiple pivot tables
  • Create aggregate reports using formula based techniques
  • Review accounting concepts; Income Statement, Balance Sheet and Cash Flow Statement, and understand the linkages between them so that modelers can accurately develop balanced multi-year financial projections.
  • Review finance concepts such as the Net Present Value, Weighted Average Cost of Capital, Terminal Value and the discounting of cash flows.
  • Develop Excel expertise with functions, formulas, layout, style and formatting so modelers can easily and quickly build scalable and robust financial models that are easy to use, extend, and incorporate into presentations as flexible tools for business decision-making.
  • Develop modeling instincts so modelers know what assumptions are reasonable and likely to result in dependable results, and what parameter ranges are realistic to account for invariable deviations of reality from models.
  • Develop a framework that allows modelers to build financial projections, perform discounted cash flow valuations, perform sensitivity analyses, build graphs and allow others to use their models without worrying about basic issues such as incorrect data input or “breaking” the model.
  • Provide a foundation for more advanced modeling are such as for Leveraged Buyout Analyses, Mergers & Acquisitions, Equity or Debt issuance and other complex financial applications

Who should attend?

  • Business and financial analysts
  • Business owners and entrepreneurs
  • Financial Modelers and Consultants
  • Individuals for personal finance
  • Accountants, Financial controllers and financial managers
  • Business development managers
  • Advisers of small, medium and fast growing enterprises (SMFEs)
  • Masters students in management and finance

Prerequisites

  • Basic knowledge of excel: participants are required to have practical experience in using Excel as a tool to analyze, present and support financial information and decisions.
  • A calculator that can handle basic arithmetic and a laptop equipped with MS Excel application

TRAINING PACK

  • Award of Certificate of Participation, Customized Training Materials
  • Case Studies and Activities Stimulation

DATA ANALYSIS

MODULE ONE: Getting Started

Areas to be covered in this training include but not limited to the following:

  • Microsoft Excel Philosophy: understanding excel interface; work with ribbons; most powerful excel dialogue boxes; 20 hottest excel shortcuts.
  • Advanced Formulas 1: understanding excel cell references; work with name; work with date; data validation; IF and NESTED IF Functions for logical test.
  • Advanced Formulas 2: Count IF function; Text functions; Rept Function; work with Table. Forensic data auditing.
  • Advanced Formulas 3: index function; match function; Horizontal & Vertical Lookup function; index & match function; summing function.
  • Advanced Formulas 4: conditional formatting; work with data; pivot table; formula auditing; array formula; chart and chart techniques.

FINANCIAL MODELLING

MODULE TWO 

Areas expected to be covered in Dash Board Reporting include:

  • Flow Chart; Time line chart: this is used mainly in project management for task schedule.
  • Combo-Box Chart: Powerful chart used for reporting in different scenario.
  • Water flow Chart; Cash flow Chart: Powerful chart for reporting adjustments in revenue and cost. It shows the visualisation of revenue-cost movements
  • Option tab; List box: These are other charts used for reporting
  • Traffic Light chart: Highly dynamic chart to gauge sales, revenue, staff performance
  • Speedometer Dashboard: Another dynamic dashboard for presentation

DURATION:

WEEKDAY CLASS: 3 DAYS

DATE:

15th – 17th January 2018

TIME:

9:00am

ACCOUNT DETAILS:

Bank: First City Monument Bank Plc (FCMB)

Account Name: SuccessDrive Global Consult Ltd

Account Number: 246 809 3010

REGISTRATION PROCEDURE

  1. Pay the registration fee on or before registration deadline date(at least a week before class commencement date)
  2. Send your name, phone number, email address, training location, amount paid to training@successdrives.net or SMS to 08096662323, 08107922921
  3. Visit www.successdrives.net click on register now tab and complete Registration Form.
  4. Upon confirmation of your registration an electronic receipt will be sent to your mail.
  5. Pay the tuition on or before the tuition deadline
  6. Commence your training at SuccessDrives Training Facility

ACCOUNT DETAILS

Bank: First City Monument Bank Plc (FCMB)

Account Name: SuccessDrive Global Consult Ltd

Account Number: 246 809 3010

""
1
Fill the Fields below to register for a Course
First Name
Last Name
Phone Noyour full name
Organization
Organization Websiteyour full name
Organization Addressyour full name
Other Informationmore details
0 /
Previous
Next

Duration And Fee

WHAT IS DIGITAL MARKETING?

In simplistic terms, digital marketing is the promotion of products or brands via one or more forms of electronic media. Digital marketing differs from traditional marketing in that it involves the use of channels and methods that enable an organization to analyze marketing campaigns and understand what is working and what isn’t – typically in real time. Digital marketers monitor things like what is being viewed, how often and for how long, sales conversions, what content works and doesn’t work, etc. While the Internet is, perhaps, the channel most closely associated with digital marketing, others include wireless text messaging, mobile instant messaging, mobile apps, podcasts, electronic billboards, digital television and radio channels, etc

BRIEF OVERVIEW

This program is essential for all marketing professionals and business people, the program is designed to provide you with a comprehensive practical know-how of digital tactics and strategies across social media, mobile marketing, online analytics, and search engine marketing aimed at fully leveraging the power Internet for achieving business goals such as acquiring, converting, and retaining customers.

This program is intended for anyone interested in improving sales, brand visibility, brand penetration, website performance, online marketing campaigns, search engine marketing and web analytics skills.

This program will also interest those advancing a career in marketing by clearly defining the tactics and technologies integral to planning and implementing a successful digital marketing strategy from an organizational perspective.

Who should attend?

  • Business Developers
  • Marketing Executives
  • Individuals seeking “Work From Home” Opportunity
  • Online Marketing Professionals
  • Advisers of small, medium and fast growing enterprises (SMFEs)
  • Individual preparing for International Certification Program in Internet Marketing

TRAINING PACK 

  • Award of Certificate of Proficiency, on completion of a Project Work
  • Training materials
  • Case Studies and E-book on Digital Marketing Implementation
  • 30days On-going mentorship guide
  • Refreshment
  • Your Website Review and Recommendation for Optimizations
  • 10,000 Email Database and Nationwide GSM Number Database (up to 21Million)

MODULE ONE: DIGITAL MARKETING FUNDAMENTALS

  • Overview of Digital Marketing For Business
  • Understanding the Digital Marketing TREE
  • Working with AECM/RACE Strategy Framework
  • Strategic Digital Positioning & Digital Value Creation for Business
  • Online Presence Analysis & Introduction to Digital Intelligence
  • Developing an Effective Digital Marketing Strategy Plan

 MODULE TWO: EMAIL MARKETING

  • Introduction to Email Marketing and Why it’s a Winning Key
  • Understanding Why People Will Open Your Newsletter & Primary Recipe For Success
  • Effective Newsletters: The Objectives, Effective Subject, Signature Line and Personalization
  • Managing the Pitfall holes: Getting Permission, Delivering into INBOX and Spamming Rules
  • Metric Monitoring: Total Open Rate, Bounce Rate, Click Through Rate(CTR) and Conversion Rate
  • Database Mining and Management (Practical Illustration)
  • Creating, Scheduling and Sending a Winning Newsletter (PRACTICALS)

 MODULE THREE: SOCIAL MEDIA MARKETING

  • Social Media Marketing Fundamentals
  • Developing Effective Social Media Engagement Plan
  • Facebook Marketing for Business
  • Instagram Marketing For Business
  • Twitter Marketing for Business
  • LinkedIn Marketing for Business
  • YouTube Marketing for Business
  • Exploring other Social Networks (Google+, Skype, Whatsapp and SnapChat, etc)

 MODULE FOUR: CONTENT MARKETING FOR BUSINESS

  • Activating the Power of Content Marketing
  • Working with the 4C Content Marketing FrameworkTM
  • Managing Content Marketing Challenge, Process and Planning
  • Content Marketing Effectiveness Monitoring Metric & KPI
  • Case Study – Review & Analysis

MODULE FIVE: SEARCH ENGINE MARKETING FOR BUSINESS

  • Search Engine Marketing Importance & Fundamentals
  • Search Engine Essentials– Type, Process, Ranking Factor and Keyword Analysis
  • Step-by-Step Search Engine Optimization (on-page SEO) Process/Methodology
  • Implementing Off-Page SEO (Directory Listing, Classified AD, Google MyBusiness Listing, etc)
  • Implementing Search Engine Advertisement (Google SE and Yahoo SE) – PRACTICAL
  • Case Study – Review & Analysis

MODULE SIX: MOBILE MARKETING FOR BUSINESS

  • Understanding the Fundamentals of Mobile Marketing and Mobile Marketing Strategy
  • Mobile Marketing Channels: Text Message, Flash Message, Voice Message, Short Code Services, USSD Service, QR Code, Mobile Web/APP
  • Executing Mobile Broadcasting Marketing (WhatsAPP, Telegram and SnapChat)

 MODULE SEVEN: ONLINE ADVERTISEMENT FOR BUSINESS

  • Understanding the Fundamentals – PPC/PPM/PPA/PPP/BTO/SSC and CTR
  • Type of Campaign – Search Engine (Text), Display Banners, Video, Shopping and Mobile Engagement
  • Online Advertisement (Google Adwords, Yahoo Gemini, Social Media & Classified Adverts) Network
  • Effective Landing Page and Conversion Rate Optimization
  • Google Advertising Fundamentals (Placement & Remarketing Discuss) – PRACTICALS

MODULE EIGHT: BRAND REPUTATION MANAGEMENT & ONLINE PR

  • Brand Reputation Management
  • Online Brand Reputation Monitoring
  • Blogging, Viral Marketing, Sponsored Story and Forum Management
  • Case Study – Review and Analysis.

 MODULE NINE: GRAPHIC FOR DIGITAL MARKETER (100% practicals)

  • Graphic Designs Essentials
  • Creating Beautiful Logo and Banners with Canva.com
  • Introduction to Fireworks/Photoshop

 MODULE TEN: WEB ANALYTICS  

  • Web Analytics Importance and Fundamentals
  • Web Analytics – Parlance, Categories and Majors Tools
  • Understanding and Working with Google Analytics – PRACTICAL

 

DURATION:

WEEKDAY CLASS: 3 DAYS

DATE:

15th – 17th January 2018

TIME:

9:00am

REGISTRATION PROCEDURE

  1. Pay the registration fee on or before registration deadline date(at least a week before class commencement date)
  2. Send your name, phone number, email address, training location, amount paid to training@successdrives.net or SMS to 08096662323, 08107922921
  3. Visit www.successdrives.net click on register now tab and complete Registration Form.
  4. Upon confirmation of your registration an electronic receipt will be sent to your mail.
  5. Pay the tuition on or before the tuition deadline
  6. Commence your training at SuccessDrives Training Facility

ACCOUNT DETAILS

Bank: First City Monument Bank Plc (FCMB)

Account Name: SuccessDrive Global Consult Ltd

Account Number: 246 809 3010

""
1
Fill the Fields below to register for a Course
First Name
Last Name
Phone Noyour full name
Organization
Organization Websiteyour full name
Organization Addressyour full name
Other Informationmore details
0 /
Previous
Next

WHAT IS DIGITAL MARKETING?

In simplistic terms, digital marketing is the promotion of products or brands via one or more forms of electronic media. Digital marketing differs from traditional marketing in that it involves the use of channels and methods that enable an organization to analyze marketing campaigns and understand what is working and what isn’t – typically in real time. Digital marketers monitor things like what is being viewed, how often and for how long, sales conversions, what content works and doesn’t work, etc. While the Internet is, perhaps, the channel most closely associated with digital marketing, others include wireless text messaging, mobile instant messaging, mobile apps, podcasts, electronic billboards, digital television and radio channels, etc

BRIEF OVERVIEW

This program is essential for all marketing professionals and business people, the program is designed to provide you with a comprehensive practical know-how of digital tactics and strategies across social media, mobile marketing, online analytics, and search engine marketing aimed at fully leveraging the power Internet for achieving business goals such as acquiring, converting, and retaining customers.

This program is intended for anyone interested in improving sales, brand visibility, brand penetration, website performance, online marketing campaigns, search engine marketing and web analytics skills.

This program will also interest those advancing a career in marketing by clearly defining the tactics and technologies integral to planning and implementing a successful digital marketing strategy from an organizational perspective.

Who should attend?

  • Business Developers
  • Marketing Executives
  • Individuals seeking “Work From Home” Opportunity
  • Online Marketing Professionals
  • Advisers of small, medium and fast growing enterprises (SMFEs)
  • Individual preparing for International Certification Program in Internet Marketing

TRAINING PACK 

  • Award of Certificate of Proficiency, on completion of a Project Work
  • Training materials
  • Case Studies and E-book on Digital Marketing Implementation
  • 30days On-going mentorship guide
  • Refreshment
  • Your Website Review and Recommendation for Optimizations
  • 10,000 Email Database and Nationwide GSM Number Database (up to 21Million)

MODULE ONE: DIGITAL MARKETING FUNDAMENTALS

  • Overview of Digital Marketing For Business
  • Understanding the Digital Marketing TREE
  • Working with AECM/RACE Strategy Framework
  • Strategic Digital Positioning & Digital Value Creation for Business
  • Online Presence Analysis & Introduction to Digital Intelligence
  • Developing an Effective Digital Marketing Strategy Plan

 MODULE TWO: EMAIL MARKETING

  • Introduction to Email Marketing and Why it’s a Winning Key
  • Understanding Why People Will Open Your Newsletter & Primary Recipe For Success
  • Effective Newsletters: The Objectives, Effective Subject, Signature Line and Personalization
  • Managing the Pitfall holes: Getting Permission, Delivering into INBOX and Spamming Rules
  • Metric Monitoring: Total Open Rate, Bounce Rate, Click Through Rate(CTR) and Conversion Rate
  • Database Mining and Management (Practical Illustration)
  • Creating, Scheduling and Sending a Winning Newsletter (PRACTICALS)

 MODULE THREE: SOCIAL MEDIA MARKETING

  • Social Media Marketing Fundamentals
  • Developing Effective Social Media Engagement Plan
  • Facebook Marketing for Business
  • Instagram Marketing For Business
  • Twitter Marketing for Business
  • LinkedIn Marketing for Business
  • YouTube Marketing for Business
  • Exploring other Social Networks (Google+, Skype, Whatsapp and SnapChat, etc)

 MODULE FOUR: CONTENT MARKETING FOR BUSINESS

  • Activating the Power of Content Marketing
  • Working with the 4C Content Marketing FrameworkTM
  • Managing Content Marketing Challenge, Process and Planning
  • Content Marketing Effectiveness Monitoring Metric & KPI
  • Case Study – Review & Analysis

MODULE FIVE: SEARCH ENGINE MARKETING FOR BUSINESS

  • Search Engine Marketing Importance & Fundamentals
  • Search Engine Essentials– Type, Process, Ranking Factor and Keyword Analysis
  • Step-by-Step Search Engine Optimization (on-page SEO) Process/Methodology
  • Implementing Off-Page SEO (Directory Listing, Classified AD, Google MyBusiness Listing, etc)
  • Implementing Search Engine Advertisement (Google SE and Yahoo SE) – PRACTICAL
  • Case Study – Review & Analysis

MODULE SIX: MOBILE MARKETING FOR BUSINESS

  • Understanding the Fundamentals of Mobile Marketing and Mobile Marketing Strategy
  • Mobile Marketing Channels: Text Message, Flash Message, Voice Message, Short Code Services, USSD Service, QR Code, Mobile Web/APP
  • Executing Mobile Broadcasting Marketing (WhatsAPP, Telegram and SnapChat)

 MODULE SEVEN: ONLINE ADVERTISEMENT FOR BUSINESS

  • Understanding the Fundamentals – PPC/PPM/PPA/PPP/BTO/SSC and CTR
  • Type of Campaign – Search Engine (Text), Display Banners, Video, Shopping and Mobile Engagement
  • Online Advertisement (Google Adwords, Yahoo Gemini, Social Media & Classified Adverts) Network
  • Effective Landing Page and Conversion Rate Optimization
  • Google Advertising Fundamentals (Placement & Remarketing Discuss) – PRACTICALS

MODULE EIGHT: BRAND REPUTATION MANAGEMENT & ONLINE PR

  • Brand Reputation Management
  • Online Brand Reputation Monitoring
  • Blogging, Viral Marketing, Sponsored Story and Forum Management
  • Case Study – Review and Analysis.

 MODULE NINE: GRAPHIC FOR DIGITAL MARKETER (100% practicals)

  • Graphic Designs Essentials
  • Creating Beautiful Logo and Banners with Canva.com
  • Introduction to Fireworks/Photoshop

 MODULE TEN: WEB ANALYTICS  

  • Web Analytics Importance and Fundamentals
  • Web Analytics – Parlance, Categories and Majors Tools
  • Understanding and Working with Google Analytics – PRACTICAL

 

REGISTRATION PROCEDURE

  1. Pay the registration fee on or before registration deadline date(at least a week before class commencement date)
  2. Send your name, phone number, email address, training location, amount paid to training@successdrives.net or SMS to 08096662323, 08107922921
  3. Visit www.successdrives.net click on register now tab and complete Registration Form.
  4. Upon confirmation of your registration an electronic receipt will be sent to your mail.
  5. Pay the tuition on or before the tuition deadline
  6. Commence your training at SuccessDrives Training Facility

ACCOUNT DETAILS

Bank: First City Monument Bank Plc (FCMB)

Account Name: SuccessDrive Global Consult Ltd

Account Number: 246 809 3010

""
1
Fill the Fields below to register for a Course
First Name
Last Name
Phone Noyour full name
Organization
Organization Websiteyour full name
Organization Addressyour full name
Other Informationmore details
0 /
Previous
Next