PIKTOCHART

https://magic.piktochart.com/infographic/saved/19873962#

In PowerPoint, you can use hyperlinks to link to resources that are not online. To create a quick way to refer to another slide in your presentation, you can create a hyperlink to that slide. If you need to access a file stored on your computer, you can create a hyperlink to it. Additionally, PowerPoint allows you to format pictures and shapes as hyperlinks.

To insert a hyperlink to another slide:

1.      Right-click the selected text or image, then click Hyperlink.

2.      The Insert Hyperlink dialog box will appear.

3.      On the left side of the dialog box, click Place in this Document.

4.      A list of the other slides in your presentation will appear. Click the name of the slide you want to link to.

5.      Click OK. The text or image will now be a hyperlink to the slide you selected.

To insert a hyperlink to another file:

1.      Right-click the selected text or image, then click Hyperlink. The Insert Hyperlink dialog box will appear.

2.      On the left side of the dialog box, click Existing File or Webpage.

3.      Click the drop-down arrow to browse for your file.

4.      Select the desired file.

5.      Click OK. The text or image will now be a hyperlink to the file you selected.

If you plan on displaying your presentation on a different computer than you used to create it, your hyperlink to another file may not work. Make sure you have a copy of the linked file on the computer you are using to present, and always test hyperlinks before giving a presentation.

Using shapes and pictures as hyperlinks

Sometimes you might want to to format objects—including shapes, text boxes, and pictures—as hyperlinks. This is especially helpful if you want the object to act like a button. To do this, right-click the desired object and select Hyperlink from the menu that appears. Click the object during the presentation to open the hyperlink.

5 simple steps on How to use Hyperlinks

To insert a hyperlink to another slide:

1. Right-click the selected text or image, then click Hyperlink.
2. The Insert Hyperlink dialog box will appear.
3. On the left side of the dialog box, click Place in this Document. Creating a hyperlink to another slide.
4. A list of the other slides in your presentation will appear. ...
5. Click OK.

20 common Microsoft Excel Formulas

1) ADDRESS function 

The ADDRESS function is a built-in function in Excel that is categorized as a Lookup/Reference Function. It can be used as a worksheet function (WS) in Excel. As a worksheet function, the ADDRESS function can be entered as part of a formula in a cell of a worksheet.

Syntax

The syntax for the ADDRESS function in Microsoft Excel is:

ADDRESS( row, column, [ref_type], [ref_style], [sheet_name] )

2)AREAS function

The AREAS function is a built-in function in Excel that is categorized as a Lookup/Reference Function. It can be used as a worksheet function (WS) in Excel. As a worksheet function, the AREAS function can be entered as part of a formula in a cell of a worksheet.

Syntax

The syntax for the AREAS function in Microsoft Excel is:

AREAS( reference )

3)CHOOSE function

The CHOOSE function is a built-in function in Excel that is categorized as a Lookup/Reference Function. It can be used as a worksheet function (WS) and a VBA function (VBA) in Excel. As a worksheet function, the CHOOSE function can be entered as part of a formula in a cell of a worksheet. As a VBA function, you can use this function in macro code that is entered through the Microsoft Visual Basic Editor.

Syntax

The syntax for the CHOOSE function in Microsoft Excel is:

CHOOSE( position, value1, [value2, ... value_n] )

4)COLUMN function

The COLUMN function is a built-in function in Excel that is categorized as a Lookup/Reference Function. It can be used as a worksheet function (WS) in Excel. As a worksheet function, the COLUMN function can be entered as part of a formula in a cell of a worksheet.

Syntax

The syntax for the COLUMN function in Microsoft Excel is:

COLUMN( [reference] )

5)COLUMNS function

The COLUMNS function is a built-in function in Excel that is categorized as a Lookup/Reference Function. It can be used as a worksheet function (WS) in Excel. As a worksheet function, the COLUMNS function can be entered as part of a formula in a cell of a worksheet.

Syntax

The syntax for the COLUMNS function in Microsoft Excel is:

COLUMNS( reference )

6)HLOOKUP function

The HLOOKUP function is a built-in function in Excel that is categorized as a Lookup/Reference Function. It can be used as a worksheet function (WS) in Excel. As a worksheet function, the HLOOKUP function can be entered as part of a formula in a cell of a worksheet.

Syntax

The syntax for the HLOOKUP function in Microsoft Excel is:

HLOOKUP( value, table, index_number, [approximate_match] )

7)HYPERLINK function

The HYPERLINK function is a built-in function in Excel that is categorized as a Lookup/Reference Function. It can be used as a worksheet function (WS) in Excel. As a worksheet function, the HYPERLINK function can be entered as part of a formula in a cell of a worksheet.

Syntax

The syntax for the HYPERLINK function in Microsoft Excel is:

HYPERLINK ( link, [display_name] )

8)INDEX function

The INDEX function is a built-in function in Excel that is categorized as a Lookup/Reference Function. It can be used as a worksheet function (WS) in Excel. As a worksheet function, the INDEX function can be entered as part of a formula in a cell of a worksheet.

Syntax

The syntax for the INDEX function in Microsoft Excel is:

INDEX( table, row_number, column_number )

9)INDIRECT function

he INDIRECT function is a built-in function in Excel that is categorized as a Lookup/Reference Function. It can be used as a worksheet function (WS) in Excel. As a worksheet function, the INDIRECT function can be entered as part of a formula in a cell of a worksheet.

Syntax

The syntax for the INDIRECT function in Microsoft Excel is:

INDIRECT( string_reference, [ref_style] )

10)LOOKUP function

The LOOKUP function is a built-in function in Excel that is categorized as a Lookup/Reference Function. It can be used as a worksheet function (WS) in Excel. As a worksheet function, the LOOKUP function can be entered as part of a formula in a cell of a worksheet.

There are 2 different syntaxes for the LOOKUP function:

LOOKUP Function (Syntax #1)

In Syntax #1, the LOOKUP function searches for value in the lookup_range and returns the value in the result_range that is in the same position.

The syntax for the LOOKUP function in Microsoft Excel is:

LOOKUP( value, lookup_range, [result_range] )

11)MATCH function

The MATCH function is a built-in function in Excel that is categorized as a Lookup/Reference Function. It can be used as a worksheet function (WS) in Excel. As a worksheet function, the MATCH function can be entered as part of a formula in a cell of a worksheet.

Syntax

The syntax for the MATCH function in Microsoft Excel is:

MATCH( value, array, [match_type] )

12)OFFSET function

The OFFSET function is a built-in function in Excel that is categorized as a Lookup/Reference Function. It can be used as a worksheet function (WS) in Excel. As a worksheet function, the OFFSET function can be entered as part of a formula in a cell of a worksheet.

Syntax

The syntax for the OFFSET function in Microsoft Excel is:

OFFSET( range, rows, columns, [height], [width] )

13)ROW function

The ROW function is a built-in function in Excel that is categorized as a Lookup/Reference Function. It can be used as a worksheet function (WS) in Excel. As a worksheet function, the ROW function can be entered as part of a formula in a cell of a worksheet.

Syntax

The syntax for the ROW function in Microsoft Excel is:

ROW( [reference] )

14)ROWS function

The ROWS function is a built-in function in Excel that is categorized as a Lookup/Reference Function. It can be used as a worksheet function (WS) in Excel. As a worksheet function, the ROWS function can be entered as part of a formula in a cell of a worksheet.

Syntax

The syntax for the ROWS function in Microsoft Excel is:

ROWS ( reference )

15)SWITCH function

The SWITCH function is a built-in function in Excel that is categorized as a Lookup/Reference Function. It can be used as a VBA function (VBA) in Excel. As a VBA function, you can use this function in macro code that is entered through the Microsoft Visual Basic Editor.

Syntax

The syntax for the SWITCH function in Microsoft Excel is:

Switch ( expression1, value1, expression2, value2, ... expression_n, value_n )

16)TRANSPOSE function

The TRANSPOSE function is a built-in function in Excel that is categorized as a Lookup/Reference Function. It can be used as a worksheet function (WS) in Excel. As a worksheet function, the TRANSPOSE function can be entered as part of a formula in a cell of a worksheet.

Syntax

The syntax for the TRANSPOSE function in Microsoft Excel is:

TRANSPOSE( range )

17)VLOOKUP function

The VLOOKUP function is a built-in function in Excel that is categorized as a Lookup/Reference Function. It can be used as a worksheet function (WS) in Excel. As a worksheet function, the VLOOKUP function can be entered as part of a formula in a cell of a worksheet.

Syntax

The syntax for the VLOOKUP function in Microsoft Excel is:

VLOOKUP( value, table, index_number, [approximate_match] )

18)ASC function

The ASC function is a built-in function in Excel that is categorized as a String/Text Function. It can be used as a VBA function (VBA) in Excel. As a VBA function, you can use this function in macro code that is entered through the Microsoft Visual Basic Editor.

Syntax

The syntax for the ASC function in Microsoft Excel is:

Asc( string )

19)CHAR function

The CHAR function is a built-in function in Excel that is categorized as a String/Text Function. It can be used as a worksheet function (WS) in Excel. As a worksheet function, the CHAR function can be entered as part of a formula in a cell of a worksheet.

Syntax

The syntax for the CHAR function in Microsoft Excel is:

CHAR( ascii_value )

20)CHR function

The CHR function is a built-in function in Excel that is categorized as a String/Text Function. It can be used as a VBA function (VBA) in Excel. As a VBA function, you can use this function in macro code that is entered through the Microsoft Visual Basic Editor.

Syntax

The syntax for the CHR function in Microsoft Excel is:

Chr( ascii_value )