1 / 14

Information Technology In Finance

Information Technology In Finance. Stefano Grazioli. Critical Thinking. Overall you are doing well! First optional lab: Friday 2-3:30 room 395 Solutions are available . XLSX vs. . XLXM Running from R: or S: Do not follow the lab blindly EasyMeter . You D o T he Talking.

phiala
Download Presentation

Information Technology In Finance

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. Information Technology In Finance Stefano Grazioli

  2. Critical Thinking • Overall you are doing well! • First optional lab: Friday 2-3:30 room 395 • Solutions are available • .XLSX vs. .XLXM • Running from R: or S: • Do not follow the lab blindly • EasyMeter

  3. You Do The Talking • Name, year, program • Learning objectives • What you like about the class • What can be improved • Looking for a Team? Strengths? • Attitude towards the Tournament

  4. Control Structures Loops forrepetitive tasks

  5. Loops – For … Next Fori AsInteger = 1 To 10 Step 1 Application.ActiveCell.Offset(i, 0).Value = i * 100 next

  6. Loops – For Each ForEachmyCellAsExcel.Rangein Application.Range("A1:B4") MyCell.Value = myCell.Value * 2 Next

  7. Loops – Do Loop 1 Do ‘ body of the loop Loop While <test>

  8. Loops – Do Loop 2 Do While <test> ‘ body of the loop Loop

  9. WINIT What Is NewIn Technology?

  10. Homework

  11. Suggestions • Test what you build • Email me. Come and see me.

  12. Debugging • Error window • Breakpoints & Cursor • Watch • Searching for help

  13. Individual Productivity Tricks &Best Practices

  14. Shortcuts • Well worth the effort: “the difference between having to stay at work after dinner or not” • Alt will visualize them • Find & Memorize those who are useful to you • Alt + w + e = full screen(esc to escape)

More Related