1 / 14

Business computing

Business computing. Session 7 Excel, Links, Graphics, Goal seeking. Today’s topics. Excel Links Graphics Goal seeking. P&L of a small shop. Enter sales (per quarter) Purchases Etc. To have real numbers go to http://www.societes.com And enter the name and address of a shop you know.

salenas
Télécharger la présentation

Business computing

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Business computing Session 7 Excel, Links, Graphics, Goal seeking

  2. Today’s topics • Excel • Links • Graphics • Goal seeking

  3. P&L of a small shop • Enter sales (per quarter) • Purchases • Etc. • To have real numbers go to • http://www.societes.com • And enter the name and address of a shop you know

  4. Excel • In an Excel sheet some data are « hard data » and some data displayed are actually the result of formulas

  5. Plain pasting • No change in Word when we change the table in Excel

  6. Special pasting with a link • When we change the table in Excel, this entails an change into Word

  7. Checks • Within Excel it is a good idea to perform frequent checks of our formulas

  8. The concept of dynamic link • We prepare a table into Excel and paste it dynamically into Word • Excel is the « computing » software • Word is the « display » software • The same applies to dynamic Web pages • The Camif catalog in the Web displays price data extracted from a database • They are displayed into HTML pages • This applies to mail order firms.

  9. The concept of dynamic link (2) • The Camif main page does not have the HTML suffix but the ASP suffix (Active server page) • When we call http://www.camif.fr we actually obtain the display on our computer screen of a page constructed at the time of our request (just like the word page we created a minute ago)

  10. The concept of dynamic link (3) • The idea of separating data creation and data display is very important in the computer industry • All mail order firm Web sites display pages created « on demand » from commercial data contained in databases • HTML itself is an old language that mixes up data information and display information. It has been replaced by XML that separates the two functions.

  11. Excel graphics

  12. The goal seeking tool • The standard situation • An excel formula is a mathematical formula • Usually of the form • F(A,B,C) = a computation with A, B and C • Excel computes for us F for a set of AB and C we enter as operands • Sometime we decide the F value we want to reach and « adjust » B to reach that

  13. The goal seeking tool (2) • Example : • F(A,B,C) = [ (1 + A)^B ] / (1 + C) • If A=2, B=3, and C = 5, then F = 4,5 • If A =2, and C=5 and we want F to be equal to 6,75 what should B be ?

  14. The goal seeking tool (3) • Example 2 • A corridor has a width we don’t know (and we call w) • A ladder of length 4 meters is put in the corridor, and another one of 3 meters (in the other direction) • They cross 1 meter above the ground • What is w ?

More Related