• Home

    Welcome !

    This is the website for Black Tor Consulting Ltd, we would like to offer you some help with your technology issues.

    Mainly on this site we focus on Microsoft Excel formulas, pivots and the automation of workbooks via VBA.

    p

    We are also interested in graphic and website design.

    Cross Browser Support

    This site has been tested in all major browsers.

    Compatible Browsers

    • Internet Explorer
    • Firefox
    • Opera
    • Chrome
    • Safari
    • What else ?
  • Excel

    Microsoft Excel 1997 to 2016/365

    Formulas

    More Formulas

    Combinations

    Misc

    Support of Excel 2007-2010

    Microsoft will ended its support of Office 2007 on the 10th of October 2017, and support for Office 2010 will end on the 13thsup> of October 2020

    At this time all security upgrades for this version will cease. The improvements made to recent versions of Excel are considerable and will greatly improve your reporting process.

    If you are still running Office 2007 (or Office 2010) after support ends you should ensure that you migrate to ensure you receive security upgrades.

    Users often find that they are disorientated when they first move to new versions of Excel. However in only 2-3 weeks you will be working faster and more efficiently.

  • VBA

    Visual Basic Application

    1.1

    Helpful Code

    More Examples

    Helpful Sites

    Misc

    What is VBA?

    VBA is an abbreviation for Visual Basic for Applications. It is the language used by office applications such as Access & Excel to perform tasks for you.

    Atlhough VBA is a computer language you do not need to sit down with a book to use it. Using the recorder on the Developer tab you can create your own macros.

    Each section of code which starts and finishes is called a macro or subroutine. Within the VBA Editor (Alt + F11 to show it).

    Although these recorded macro's will not adjust to changes to your workbook or data they are an excellent place to start if you want to learn code.

  • Webdesign

    Design and Maintenance

    Some Links

    Examples

    Other Stuff

    Design Help

    Bespoke Design

    We do not attempt to compete with the multitude of agencies that will offer to produce a template based site for you from a stock layout and palette.

    At Black Tor we believe in a bespoke design for each site which is tailored to fit the customers requirements and their requests, building your site together.

    We will discuss with you the best colours and font to use and also any images that need to be included in the design that suites you.

    Establishing a direct contact with our customers is important to us so that we can be a real source of help and advise as we develop and maintain your website.

  • Other Stuff

    Pages of Interest

    Book Covers We Have Created

    Ghosts from Afghanistan: A complex cover combining eight different images each layered onto a smokey background. Additional images were wrapped around the mannequin to give an interesting perspective.
    Read more...

    The Escape of Jack the Ripper: This cover has a more modern appearance. Colour washes and again multiple images were required to build the final cover image which can be seen here.
    Read more...

  • Contact

    Contact Us

    Please fill in the following form to contact us






  • +A
  •  A
  • -A
Black Tor

Welcome to BLACK TOR consulting

Why A Site map?

Help

It is another way of laying out what is on the site and some people prefer it as a way to understand what is on the site. Brief descriptions of what is on each page will follow.

Site Contents

Our site is made of a number of pages (and it is growing) so below is a list of the pages we currently maintain on the site:

  • Home
  • Excel
  • VBA
  • Design
  • Us
  • Terms
  • Site map