Course Objective
To empower you with skills required to use Excel as a better planning tool for various marketing activities
Course Description
Over the time, Excel has proven to be of great help for the Marketing Professionals. Therefore, Our Marketing Excel Guru, a Marketing domain specific training helps you to use the Excel as a better planning tool for various marketing activities. It also serves as a powerful Analytical tool for rational Decision Making. The course covers basis to advanced Excel coupled with Application of Excel in Marketing.
Course Features
  • Domain Specific Training
  • Comprehensive Course Coverage
  • Expert Trainers
  • 30 days access to Online Excel Help - View Demo
  • One-To-One Training
  • Flexible Schedule
  • 30 days Post Training Support (E-mail)
  • Access to Excel Chat Facility
Additional Freebies
  • 20+ Essential Excel Templates for Marketing
plus
Finance
Excel Introduction : Duration 5 hours
Excel Overview
• A overview of the screen, navigation and basic spreadsheet concepts
• Understanding workbooks, worksheets, rows, columns, cells
• Various selection techniques
Entering Data
• Entering, Editing and Deleting Text, Numbers, Dates
• Using Auto Lists
• Moving and Copying data
• Inserting, Deleting and Hiding Rows & Columns
• Inserting, Deleting, Moving and Copying Sheets
• Using navigation techniques
Creating and Editing Formulae
• Concept of Formulae
• Creating Formulae, Editing Formulae
• Bodmas : Mathematical Order
• Copying Formulae
• Using Functions - Sum, Average, Max,Min, Count, Counta
• Applying Absolute (Fixed) Referencing
Formatting and Proofing
• Formatting Cells with Number formats, Font formats, Alignment, Borders, etc
• Basic conditional formatting
• Copying and Clearing Formats
• Working with Styles
• Spell Check, Find & Replace and AutoCorrect
Excel Intermediate Training : Duration 5 hours
Range Names
• Concept and Purpose
• Naming individual or range cells
• Deleting and amending named ranges
• Using named cells/ranges in formulae
Conditional Functions & Formats and Date Calculations

• Benefits and purpose
• If Statements , Nested If
• And, Or, Not
• Combining If, And, Or, Not
• Sumif , Countif
• Conditional Formatting
• Entering Dates and Times
• Different date/time formats
• How dates are stored
• Calculating working days
• Using the DAY(),MONTH(),YEAR() functions
Formulae Auditing
• Formula Auditing Tools
• Revealing Formulae
• Tracing Precedents/Dependents
• Goto Special
Worksheet Management & Linking
• Linking sheets in the same file
• Linking different Excel files
• Using Edit, Links
• Viewing different files at once
• Saving a workspace
• Viewing different sheets at once
• Window Split
• Data consolidation
Basic List Management
• Sorting Data
• Adding Subtotals
• Autofilter
• Freeze Panes
• Group and Outline
• Data Form
Excel Charts / Graphs
• Using the Chart Wizard
• Editing and Formatting charts
• Saving custom chart types
• Setting a default chart type
Excel Advanced Training : Duration 5 hours
Lookup & Information Functions
• Vertical Lookup (Vlookup)
• Horizontal Lookup (Hlookup)
• Match and Index
• IsText, IsValue, IsDate , IsNull , IsErr, Is Error, IsNa
Advanced List Management

• Advanced Filters
• Using List Features
• Dynamic Lists
Pivot Tables
• Using the Pivot Table Wizard
• Changing the pivot table layout
• Formatting
• Grouping items
• Inserting calculated fields
• Pivot Table Options
• Display and hide data in fields
• Lay out reports directly on worksheet
• Pivot Chart
What If Analysis
• Scenarios
• Goal Seek
• Solver
Protecting & Sharing Files
• Sharing a file
• Tracking changes
• Accepting or rejecting changes
• Applying Data validation rules
• Inserting comments
Introduction to Macros
• Purpose of Macros
• Recording macros
• Where to save macros
• Running macros:
• Custom buttons, menu items, keyboard shortcuts
Domain Specific Training : Duration 4 hours
Annual sales Forecast
Marketing Budget
• Online Media Budget
• Offline Media Budget
     • Print Media - Newspaper & Magazines
     • TV media
Effectiveness of Marketing activities
• Monthly Ads expenses Analysis
• Online Media Effectiveness
     • ROI on CPM
Offline Media Effectiveness
• Direct Mail Analysis
• Direct Marketing Analysis
Sales Pipe Analysis
• Sales Chart
Sales Analysis-Dashboard
Online Instructor Led Training on Excel - How it works ?
You can listen to our instructor, interact with him on a one-to-one basis, access his computer screen from your desktop, make changes on his excel sheet, and get your doubts clarified instantly.
US$ 275 / Person
SPECIAL OFFER FOR CHENNAI CUSTOMERS
Please call +91 9176633246 for more information
For Corporate
We offer private hands-on training courses that can be held at your company's site. Our Onsite Corporate Training Packages go beyond the standard excel training and can be tailored according to the needs of the organisation and knowledge level of the employees.
Minimum Batch Size : 10
Click Here to request for quote

For Colleges and Universities
Our Services are now available on demand at Colleges and Universities
Minimum Batch Size : 25
Click Here to request for quote
  • Windows OS
  • Internet Speed of 512 kbps or higher
  • Internet Explorer
  • Headsets With Mic
  • JavaScript Enabled
Keywords
Copyright © ExcelGoodies Software Private Limited . All Rights Reserved