Jerts Productivity Consulting
About Us Spreadsheet Risk Management Services Modelling and Analysis Services Modelling and Analysis Knowledge Library Contact Us
Jerts Consulting & Services
 

LATEST NEWS
Mar 2019
   Salesperson Statements
   Expanding on the comm-
   ission calculator we
   built 6 years ago,
   we integrated an
   automated statement
   generator.
   It generates monthly
   statements for more than
   30 sales persons.
   Data is stored in a
   backend database that we
   are now using to develop
   a dynamic, web-based
   sales dashboard.
   Chat, email or call
   to find out how Jerts
   can ennhance, automate    and webify your sales
    reporting processes
   Contact Us


Feb 2019
   Onsite Speedup!
   We just spend a day
   reviewing a client-
   developed market analysis
   tool.
   It now opens 500% faster,
   recalculates instantly,
   and has some cool, new
   features.
   Contact us
   to find out how Jerts
   can make your spreadsheets    quicker and more robust.
   Contact Us


Jan 2019
   Quotation Software - CPQ Tools
   We just delivered an
   internal quote management
   tool to a manufacturing
   client. It manages
   mulitple users, multiple
   production scenarios,
   version control, and quote
   generation.
   All data is sync'd with
   a database for reporting,
   and analysis
   Is your quote process
   painful? Contact us
   to take the pain way
   Contact Us


Jan 2019
   Sales Tools
   We just enhanced an
   order-taking tool
   we built for a top
   Toronto equipment
   distributor.
   It now automatically
   and securely
   transfers shipping data to
   their 3rd party shipper.
   Full auditing, loggging
   and backup functionality
   that is transparent to
   the end-user.
   What do you need to
   automate today?    Contact us
   to make it happen!
   Contact Us






Share Jerts Toronto Excel Expert Spreadsheet

















 
Microsoft Excel Specialist

Jerts Consulting is a Toronto Excel expert dedicated to better spreadsheets and databases.

We build Excel spreadsheets and Access and SQL databases.  We improve them, audit them and train your staff on how to make more efficient spreadsheets.

Our services include building process automation tools (e.g. data aggregation and reporting tools, commission and fee calculators, budget and reporting packages, dynamic dashboards), VBA/macro development, Excel training, spreadsheet auditing, Microsoft Access/SQL Server database design and Access macros/VBA programming.

We build professional Excel and Access based tools that save time, money and reduce the potential for errors.

The tools we build are user-friendly, robust and flexible. The code is developed according to best programming practices and can be digitally signed to enhance your security.

Our reporting packages and dashboards cut prep time by 75% or more, are impressive looking and incredibily effective. Further, you will be amazed at the enhancements we can make to your existing reporting packages and dashboards.

We train employees on spreadsheet skills and provide more specialized Excel training such as No-macro Process Automation, No-macro Dynamic Dashboards, How to Audit Spreadsheets and Building Standards-compliant Spreadsheets.

We are partnered with ClusterSeven, the leading Enterprise Spreadsheet Risk management software provider with a focus on the Canadian marketplace and we are partnered with Potter Communications for our public relations and communications needs.

Here are some real case studies demonstrating our services:

Excel consultant built process automationCase 1: Process Automation in Excel

Excel consultant built dashboard for operationsCase 2: Excel Dynamic Operations Dashboard

Spreadsheet expert built Excel tool to generate client statementsCase 3: VBA Generated Client Statements in PDF

toronto excel expert built process automation toolCase 4: Annual Compensation Process using Excel

Contact us to discuss your requirements and to learn how we can help.

More Information?



This is a list  of alternative titles for the services we provide

Toronto Excel Consultant Toronto VBA Programming

Toronto Excel Macro Help Toronto Microsoft Excel Expert

Toronto Microsoft Excel Expert Toronto Microsoft Excel Help

Toronto Excel Developer Toronto Excel Professional

Excel Programmer Excel Macro Programmer

VBA Programer Microsoft Excel Guru

Spreadsheet Risk Training Spreadsheet Consultant

MS Excel Developer MS Excel Consulting

Canada Excel Expert Canada Spreadsheet Risk

Excel Advanced Training Excel Sharepoint Consultant

Excel Sharepoint Integration Toronto Spreadsheet Professional

Spreadsheet Modelling Excel Financial Models

Excel Dashboards Excel Visualizations

Copyright 2007-2016 Jerts Consulting Inc. All rights reserved.
Excel and Access are registered trademarks of the Microsoft Corporation
 Contact Us | Privacy

  • Contact Us
  • Jerts Productivity Consulting
    Microsoft Excel Specialist

    Jerts Consulting is a Toronto Excel expert dedicated to better spreadsheets and databases.

    We build Excel spreadsheets and Access and SQL databases.  We  improve them, audit them and train your staff on how to make more efficient spreadsheets.

    Our services include building process automation tools (e.g. data aggregation and reporting tools, commission and fee calculators, budget and reporting packages, dynamic dashboards), VBA/macro development, Excel training, spreadsheet auditing, Microsoft Access/SQL Server database design and Access macros/VBA programming.

    We build professional Excel and Access based tools that save time, money and reduce the potential for errors.

    The tools we build are user-friendly, robust and flexible. The code is developed according to best programming practices and can be digitally signed to enhance your security.

    Our reporting packages and dashboards cut prep time by 75% or more, are impressive looking and incredibily effective. Further, you will be amazed at the enhancements we can make to your existing reporting packages and dashboards.

    We train employees on spreadsheet skills and provide more specialized Excel training such as No-macro Process Automation, No-macro Dynamic Dashboards, How to Audit Spreadsheets and Building Standards-compliant Spreadsheets.

    We are partnered with ClusterSeven, the leading Enterprise Spreadsheet Risk management software provider with a focus on the Canadian marketplace.

    Here are some real case studies demonstrating our services:

    Excel consultant built process automationCase 1: Process Automation in Excel

    Excel consultant built dashboard for operationsCase 2: Excel Dynamic Operations Dashboard

    Spreadsheet expert built Excel tool to generate client statementsCase 3: VBA Generated Client Statements in PDF

    toronto excel expert built process automation toolCase 4: Annual Compensation Process using Excel

    Contact us to discuss your requirements and to learn how we can help.

    More Information?

    LATEST NEWS
    Mar 2019
    Salesperson Statements
       Expanding on the commission calculator we built 6 years ago, we just delivered and integrated an automated statement generator.
       It generates dynamic monthly statements for more than 30 sales persons.
       Data is stored in a backend database that will form the basis of a dynamic, web-based sales dashboard.
       Chat, email or call to find out how Jerts can enhance, automate and webify your sales reporting processes
       Contact Us


    Feb 2019
    Onsite Speedup!
       We just spend a day reviewing a client-developed market analysis tool.
       It now opens 500% faster, recalculates instantly, and has some very cool, custom UI features.
       Contact us to find out how Jerts can make your spreadsheets more user friendly, responsive and more robust.
       Contact Us