Excel-Skills.com

100% UNIQUE EXCEL TEMPLATES

Sales, Marketing & Free Templates

This page lists all of our Sales, Marketing & Free templates. Use the links in the template list to view the templates that are included in the other template categories.

44 AdWords - Monthly Statistics Template

Use this Google Adwords report template to analyze monthly ad data on an overall, campaign, ad group and device level. The template can be used for any AdWords account by adding all the relevant campaigns & ad group names to the template and copying the monthly AdWords data from an Excel extract of their AdWords account. The template includes a lot of automated calculations & charts which make it easy to spot trends in the data.

  • Suitable for any Google AdWords account
  • Easy to copy AdWords data into the template
  • Automated comparison of campaign & ad group performance
  • Automated analysis of individual campaigns & ad groups
  • Easy to add data & roll automated reports forward
  • View analysis by desktop, mobile & tablet
  • Automated charts of key monthly measurements
  • Much easier to analyze AdWords data with our templates!

45 AdWords - Search Term Analysis Template

Use this Google AdWords planning template to identify the search terms which are the most effective for converting customers who are searching for your products or services on Google. Highlight exact match keywords and add invoicing if not incorporated into the user's AdWords account. The template results can be used to measure the profitability of individual search terms or phrases and to then adjust keywords on AdWords.

  • Suitable for any Google AdWords account
  • Easy to copy AdWords data into the template
  • Analyze all search terms & their performance
  • Automated matching to exact match keywords
  • Automated matching to invoicing
  • Filter search terms to evaluate performance of phrase matching
  • Filter search terms to find negative keywords
  • Much easier to analyze AdWords data with our templates!

46 AdWords - Ad Position Analysis Template

Use this Google positions template to analyze Google AdWords online marketing performance by ad position to determine which ad positions are optimal. Copy daily AdWords statistics by campaign, ad group and device into the template and the automated analysis can then be viewed for any user defined period. All ad position calculations are based on the daily average position for each device.

  • Suitable for any Google AdWords account
  • Easy to copy AdWords data into the template
  • Analyze account performance by ad position
  • Filter by campaign, ad group & device
  • Automated comparison between 3 user defined date ranges
  • Determine optimal ad positions based on maximum profitability
  • Much easier to analyze AdWords data with our templates!

47 Sales Commission Template

Use this sales commission template to calculate sales commission for up to 5 levels of sales agents. Simply create a unique agent code for each sales agent, specify the appropriate commission percentages, copy & paste the appropriate sales data into the template, link each sales transaction to an agent code and all the commission amounts are automatically calculated. Includes an automated sales commission calculation for any user defined date range.

  • Suitable for any business
  • Create unique sales agent codes for all sales agents
  • Specify the sales commission percentages for each agent
  • Add sales transactions and link to sales agent codes
  • Automated calculation of all sales commissions
  • Automated commission report for any user defined date range
  • Accommodates up to 5 levels of sales commission

48 Sales Analysis Charts Template

Use this sales analysis template to produce a daily and monthly sales analysis chart for any user defined period by simply entering or copying basic sales data. The daily sales chart includes a 60 day period and the monthly sales chart includes a 12 month period which can be adjusted. The date range that is included in each chart can be adjusted by simply changing the start date in a single input cell.

  • Includes daily and monthly sales analysis charts
  • Change chart date range by editing only one input cell
  • Includes 60 days on daily chart and 12 months on monthly chart
  • Default date ranges can be customized

49 Gross Profit & Sales Mark-up Template

Use this margin & markup calculator template to calculate the gross profit percentage of any single product based on a specified sales markup percentage and calculate the sales markup percentage of any single product based on a specified gross profit percentage. The template also includes two additional sheets which can be used to calculate the gross profit & sales mark-up percentages of multiple products.

  • Calculate gross profit & sales mark-up percentages
  • Includes two calculators for individual product calculations
  • Includes sheet for multiple product gross profit percentage calculations
  • Includes sheet for multiple product sales mark-up percentage calculations

50 Debt Calculator Template

Free debt calculator in Excel. This template assists consumers in determining whether they are over indebted. Specify your monthly income, salary deductions, expenses and debt repayments and a simple calculator will determine whether you are over-indebted.

51 Sales Forecast Template

Use this free sales forecast template to create a monthly sales forecast for a three year period. Includes 5 default product categories (you can add more) and user input is limited to specifying the monthly sales volumes, selling prices and gross profit percentages for each product category.

52 Loan Amortization Template

Use this free loan amortization template to create amortization schedules for multiple loans and to review interest, capital repayments and outstanding balances based on any user defined date. The template is suitable for any loan which is repaid on a monthly basis and accommodates variable monthly interest rates.

53 Home Loan Calculator Template

Free home loan calculator! Comprehensive set of home loan calculations such as monthly loan repayments, increased instalment savings, home loan affordability, interest rate sensitivity and monthly & annual amortization table.

54 Net Disposable Income Template

This free net disposable income calculator template enables users to calculate their monthly net disposable income by simply entering the appropriate values in the yellow input cells on the Income sheet.