What are the opening hours?

Monday 9am - 5pm Tuesday 9am - 5pm Wednesday 9am - 5pm Thursday 9am - 5pm Friday 9am - 5pm

AJ Training

Name: AJ Training
Address: Moorgate Crofts, Rotherham, S602DH, GB
Telephone: 01709 352307
Price range: $$

AJ Training provides a comprehensive range of IT and Soft Skills training services.

Our computer training ranges from introduction through to advanced - Microsoft Office ( 2003 to 2016 ), Word, Excel, Access, Visio, Project etc, to high end development. AJ Training - Courses delivered on a single or group basis & scheduled or tailored around individual needs. All courses can be provided from our on-site training suite based in Rotherham, South Yorkshire or on-site at your locatio

n of choice. Computer Training:

Microsoft Office
SQL Server
ASP.NET
Photoshop
Plus more...

Soft Skills Training Categories:

Training Courses
Customer Facing Courses
Management Courses
Train The Trainer Course
People Management
Forward Thinking
Time Management
Minute Taking

For further information regarding course availability and pricing please contact Alison or Liz on 01709 352307.

18/07/2023

Hello and Welcome! If you want to advance your career or develop your business team, you will find an impartial selection of fully funded courses to help develop specific digital skills from introductory to advanced levels.

25/01/2021

How to use the CHOOSE formula?

If you want to select an item from a list based on an index number, then why not try the CHOOSE formula. For example, if you had a list of days starting with Monday and you asked excel to return the day that corresponded with index number 3 then excel would return Wednesday.The syntax for the CHOOSE function is =CHOOSE(index_num, value 1, [value 2],...)Index Number – the number excel is going to use to find the correct item from the listValue 1 – the first value on your listValue 2 – the second value on your list (optional)

18/01/2021

How to use the FIND formula?

If you want to search for a string of text within a larger string of text, then use the FIND function. This function will return the character number of where the string of text is located. For example, if you wanted to find the letter O in laptop, the FIND function would return 5 as O is the fifth character along.The syntax for this formula is =FIND(Find Text, Within Text, [Start Number])Find Text – The text you want Excel to findWithin Text - the string of text you want to find something inStart Number – the character that you want Excel to start searching from (optional)

14/01/2021

How to use the SEARCH formula?

If you want to search for a string of text within a larger string of text, then use the SEARCH function. This function will return the character number of where the string of text is located. For example, if you wanted to find N in phone, the SEARCH function would return 4 as N is the fourth character along.The syntax for this formula is =SEARCH(Find Text, Within Text, [Start Number])Find Text – The text you want Excel to findWithin Text - the string of text you want to find something inStart Number – the character that you want Excel to start searching from (optional)

11/01/2021

How to create a table in excel

If you want to make your data easier to work with then why not place it into a table format. To do this select the data and go to the Insert tab. Next, select Table on the Ribbon and this will open the Create Table window. In this window it will have the range of cells you want to convert to a table and a box that says My Table has Headers. If your table has headers, make sure that box is ticked. Then click ok.

07/01/2021

Naming multiple range using the Create from Selection tool

If you want to create multiple named ranges from a selection of cells, then a quick way of doing this is using the Create from Selection tool. Select the multiple rows and columns you want to name and then go to the formula tab and select Create from Selection. The Create Names from Selection options box will then appear. Choose the option of where the name for your range is located. For example, if you want to create named ranges based on the headers at the top and the first column then select Top row and Left column.

04/01/2021

Naming a single range using the Create from Selection tool

If you want to create a named range from a selection of cells, then a quick way of doing this is using the Create from Selection tool. Select the cells you want to name and then go to the formula tab and select Create from Selection. The Create Names from Selection options box will then appear. Choose the option of where the name for your range is located. For example, if the name for your range is in the first column, choose Left Column.

31/12/2020

How to use the ROUNDDOWN function in Excel?

If you want numbers to always round down, then use the ROUNDDOWN function in excel. The Syntax for this formula is =ROUNDDOWN(num, num digits).Num – the cell that you want to roundNum digits – the number of decimal places you want to round down to, for example 1 would round down to one decimal place

30/12/2020

How to replace text with new text in Excel?

If you want to replace a section of text, then give the REPLACE function a go. This function allows you to replace a specified amount of characters with new text.The syntax for the REPLACE function is =REPLACE(old text, start num, num chars, new text)Old text – the text that you want to replaceStart num – the first character that you want to replaceNum chars – the amount of characters you want to replaceNew text – The new text you want to replace the old text with

24/12/2020

How to use the ROUNDUP function in Excel?

If you want numbers to always round up, then use the ROUNDUP function in excel. The Syntax for this formula is =ROUNDUP(num, num digits).Num – the cell that you want to roundNum digits – the number of decimal places you want to roundup to, for example 1 would round up to one decimal place

21/12/2020

How to use the ROUND function in Excel?

If you want numbers in excel to round up or down to a specified number of decimal places, then use the ROUND function in Excel. The Syntax for the ROUND function is =ROUND(num, num digits).Num – the cell that you want to roundNum digits – the number of decimal places you want to round to, for example 2 would round to two decimal places

17/12/2020

How to check if a value is text in Excel?

If you want to check if a value is text, then use the ISTEXT function. To apply it, type =ISTEXT( and then reference the cell you want to check. When you hit return you will either get a TRUE or FALSE answer. If you get TRUE returned, it means the cell you have referenced is a text value. If FALSE is returned, then you have a numerical value in the cell you referenced, for example, a number, date or time. A blank cell will also return FALSE.

Address

Moorgate Crofts
Rotherham
S602DH

Opening Hours

Monday	9am - 5pm
Tuesday	9am - 5pm
Wednesday	9am - 5pm
Thursday	9am - 5pm
Friday	9am - 5pm

Telephone

01709 352307

Website

http://www.ajtraining.net/

Alerts

Be the first to know and let us send you an email when AJ Training posts news and promotions. Your email address will not be used for any other purpose, and you can unsubscribe at any time.

Contact The Business

Send a message to AJ Training:

Shortcuts

Address
Telephone
Opening Hours
Alerts
Contact The Business
Claim ownership or report listing