• 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, VBA automation of workbooks 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 2013

    Formulas

    More Formulas

    Combinations

    Misc

    Support of Excel 1997-2003

    Microsoft will end its support of Office 2003 on the 8th of April 2014. At this time all security upgrades for this version will cease.

    The improvements made to Excel in 07, 10 and 13 are considerable and will greatly improve your reporting process and any use you make of Excels new big grid.

    If you are running Office 2003 after support ends you should ensure that you upgrade so that you continue to 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 quickly.

  • VBA

    Visual Basic Application

    1.1

    Helpful Code

    More Examples

    Helpful Sites

    Misc

    What is VBA?

    VBA is the 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) each macro is started by 'Sub'.

    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