AJ Training

Home - SCC Opportunities 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.

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)

www.ajtraining.net

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)

www.ajtraining.net

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)

www.ajtraining.net

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.

www.ajtraining.net

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.

www.ajtraining.net

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.

www.ajtraining.net

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

www.ajtraining.net

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

www.ajtraining.net

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

www.ajtraining.net

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

www.ajtraining.net

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.

www.ajtraining.net