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

LATEST NEWS
Sep 2016
   Pro Techniques - Lists & Data
   There is a better way to
   use Excel to manage lists
   and data.
   Learn techniques and tools
   to manage lists and tables
   of data, to generate
   flexible reports and to
   "slice and dice" all
   that information
   sitting in spreadsheets.
   Contact Us to arrange an
   in-house session, or
   to sign-up for a
   public session.

Aug 2016
   We just delivered a
   quotation tool for an
   electrical equipment
   supplier.
   What used to take hours
   now takes seconds.
   Cool features include
   client name and address
   auto-populate, version
   control, dynamic pricing,
   and quotation analytics
   What process is slowing
   your team down?
   Contact Us


Jun 2016
   We just automated a
   personality questionairre
   for a Mgmt Consultant.
   Created a fillable PDF
   and an Excel tool to
   extract the answers and
   automatically generate an
   analytics dashboard for
   presentation to the client.
   What would you like to
   automate today?
   Contact Us


Mar 2016
       We just delivered a
   client profitability
   tool to a marketing.
   Agency. Now they know
   which teams and which
   clients are profitable!
   Would you like to know
   which of your clients are
   profitable and which ones
   are costing you
   profits?
   Contact Us


Feb 2016
   Advanced Excel Training -    Sign up now for our public    course, to be held April    19-20 in downtown Toronto.
   This course is also available    forin-house and customized    to your needs.
   Call 416-479-0125 to sign    up or to arrange an    in-house session.

05 Jan 2016
   Our client, a caterer to    daycare centres, used to    spend 2-3 days per week    making sure no kids get    meals with ingredients    they are allergic to. With    the tool we built, that    process takes 10 minutes    And, invoicing is automated    labels are auto-printed,    client and process data is    available for analytics

  
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.

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
    10 Jul 2014

    An Operations Director who had his team of 8 take our Advanced Excel course reports that they have cut monthly reporting times from 3 days to 4 hours using techniques learned in the course.

    His training ROI < 2 months!

    15 Jun 2014
    We just delivered a forecast data gathering tool. Easy- to-use Excel front-end with Access database backend.

    YTD actuals are automatically fed to the Excel front-end, forecast data is automatically aggregated in the back-end.

    2 Jun 2014
    Yes! We can recover Excel
       passwords:
       Worksheets, Workbooks
       and VBA modules.
       All Office versions and file
       types.
     
      
    Contact Us