Create Linked Objects|Add Hyperlink between Slides in powrpoint

How to salary & commission calculation?

Commission calculation: = if (sales > choose your rate, sales * maximum

numeric percent, nor sales * minimum numeric percent) Enter.

Example: Commission = if (C2 > 10000, C2 * 5%, C2 * 2%)

–: Following the chart below :–

Total pay: = if (sales > choose your rate, sales * maximum numeric percent, nor sales * minimum numeric percent) + salary Enter.

Example: Total pay = if (C2 > 10000, C2 * 5%, C2 * 2%) + B2

–: Following the chart below :–

How to Calculate Electricity Bill in MS Excel

In this post you can get electricity bills tips, which make you able to calculateelectricity bill in MS Excel. Follow the steps and learn how to calculate electricity bill:

Conditions:

1. If a person who use 200 unit or more, the rate of per unit of electricity of the person will be 2.3
2. If a person who use 250 unit or more, the rate of per unit of electricity of the person will be 3
3. If a person who use 300 unit or more, the rate of per unit of electricity of the person will be 4.5
4. If a person who use 400 unit or more, the rate of per unit of electricity of the person will be 6

Note: These conditions may change among country by country and you have to calculate electricity bill by following the conditions of your own country.

Excel Formula:

=IF(C3<=200,C3*2.5,IF(C3<=250,C3*3,IF(C3<=300,C3*4.5,IF(C3>400,C3*6))))

Note: We have to write the above formula in cell D3 and then drag the cell below.

Or, following with Step by step formula:

How to calculation electricity Bill?

Unit calculation: = Current Reading – Previous Reading

Example:  =E2-D2

–: Following the chart below :–

Bill calculation: = if (Unit<=minimum amount rate, Unit * lowest rupees, if (Unit<=maximum amount rate, Unit * medium rupees, Unit * highest rupees))

Example: = if (F2<=200, F2 * 2.1, if (F2<=450, F2 * 3.7, F2 * 4))

–: Following the chart below :–

 

How to Create Linked Objects in PowerPoint

PowerPoint, Microsoft's presentation and slide software, allows you to create animated presentations featuring text, images, sounds and other media objects. In addition to these custom features, you can also add linked objects to your presentation.
While objects embedded in your PowerPoint presentation remain unchanged even when the source file changes, linked objects reflect any changes made to the source file. For instance, if you insert a spreadsheet into your presentation and then edit that spreadsheet, the updated file will also appear in PowerPoint.

Step 1

Go to the slide in which you wish to place an object in Microsoft PowerPoint 2010. On the “Insert” tab, click “Object” under the “Text” group.

Step 2

Type of the name of the file in the “Insert Object” window that appears or locate the file on your computer by pressing the “Browse” button. Double click the file to select it.

Step 3

Check the box next to the word “Link” to insert the file as a linked object. The “Link” option is located just to the right of the “Browse” button.

Step 4

Check the box next to “Display as icon” on the right side of the “Insert Object” window if you want the linked object to appear as an icon in your PowerPoint presentation until you click it. If you want the content to automatically appear in your presentation – the standard option – leave the box unchecked.

Step 5

Click the “OK” button in the upper right of the “Insert Object” window.

How to Add Hyperlink between Slides within PowerPoint

Microsoft PowerPoint is absolutely the most famous presentation tool in the world. With it, we could easily combine the text, shapes, animations, transitions, background music and video clips together and make an impressive PowerPoint slideshow. Adding hyperlinks in PowerPoint is quite common. Usually you are adding a URL on a select text as hyperlink to a website. How to add hyperlink between slides within PowerPoint then?

Method 1: Add hyperlink on text.

Method 2: Add invisible hyperlink between slides.

Method 1: Add hyperlink on text.

Step 1: Right click on the selected text and choose Hyperlink.

Step 2: The Insert Hyperlink window will pop up. Usually we will fill URL in the Address column here.

Step 3: For adding hyperlink between slides, you need to choose Place in This Document at the left and then select the destination slide.

Method 2: Add invisible hyperlink between slides.

By using invisible hyperlink, you can not only add hyperlink on text, but also on image or even put the hyperlink on any place of a slide.

Step 1: Add an Action Button. In the Insert tab, Illustrations section, find the Shapes. Choose the Action Button: Custom, the last one of the Action Buttons.

Step 2: Add hyperlink on the Action Button. Right click on the button and choose Hyperlink, and the Action Settingswindow will show up. In the Hyperlink to: section, choose Slide…

Select the slide that you want to hyperlink to.

Step 3: Make the Action Button invisible. Right click on the Action Button and choose Format Shape and then chooseNo fill in both Fill and Line Color sections so that you will not see the button any more.

Tips: Remember the location where you put the invisible Action Buttons.