day 9: excel rahul kavi [email protected] [email protected] september 15, 2015 1
TRANSCRIPT
![Page 2: DAY 9: EXCEL RAHUL KAVI Rahul.Kavi@mail.wvu.edu Rahul.Kavi@mail.wvu.edu SEPTEMBER 15, 2015 1](https://reader036.vdocuments.us/reader036/viewer/2022062322/5697bf891a28abf838c89d07/html5/thumbnails/2.jpg)
2
THINGS TO REMEMBER
• Anything that can go wrong, will go wrong (Murphy’s Law).
• Don’t wait till last minute to do your homework/MyITLab lessons (post test).
• Personal Computers/Library Computers/Open Lab Computers.
• Help from instructors/Proctors in Open Lab.
![Page 3: DAY 9: EXCEL RAHUL KAVI Rahul.Kavi@mail.wvu.edu Rahul.Kavi@mail.wvu.edu SEPTEMBER 15, 2015 1](https://reader036.vdocuments.us/reader036/viewer/2022062322/5697bf891a28abf838c89d07/html5/thumbnails/3.jpg)
3
THINGS TO REMEMBER
• MyITLab lesson B grades are updated.• You are responsible for submitting
homework before due date using submission tool.
![Page 4: DAY 9: EXCEL RAHUL KAVI Rahul.Kavi@mail.wvu.edu Rahul.Kavi@mail.wvu.edu SEPTEMBER 15, 2015 1](https://reader036.vdocuments.us/reader036/viewer/2022062322/5697bf891a28abf838c89d07/html5/thumbnails/4.jpg)
4
THINGS TO REMEMBER
• Something wrong with MyITLab? These are the things to try:1. Try different browser/computer/operating
system.
2. Clear browser cache.
3. Contact MyITLab tech support. More details available on CS101 website.
4. Try googling your problem.
• Have a question in Homework? Checkout the help videos.
![Page 5: DAY 9: EXCEL RAHUL KAVI Rahul.Kavi@mail.wvu.edu Rahul.Kavi@mail.wvu.edu SEPTEMBER 15, 2015 1](https://reader036.vdocuments.us/reader036/viewer/2022062322/5697bf891a28abf838c89d07/html5/thumbnails/5.jpg)
5
THINGS TO REMEMBER
• Homework due on Fridays.• MyITLab lessons due on Mondays.• Check schedule for more details.• Register for MyITLab. Don’t wait till last
moment.• Start early and re-attempt until you get a full
score.• Remember to “submit” your work in
MyITLab.
![Page 6: DAY 9: EXCEL RAHUL KAVI Rahul.Kavi@mail.wvu.edu Rahul.Kavi@mail.wvu.edu SEPTEMBER 15, 2015 1](https://reader036.vdocuments.us/reader036/viewer/2022062322/5697bf891a28abf838c89d07/html5/thumbnails/6.jpg)
6
THINGS TO REMEMBER
• Range Names (will be covered in next class).
• MyITLab lessons in pre-training, post-test, post training (provide more coverage of the syllabus).
• If you are on trial version of MyITLab, take notice of the expiration date on MyITLab and consider purchasing it.
![Page 7: DAY 9: EXCEL RAHUL KAVI Rahul.Kavi@mail.wvu.edu Rahul.Kavi@mail.wvu.edu SEPTEMBER 15, 2015 1](https://reader036.vdocuments.us/reader036/viewer/2022062322/5697bf891a28abf838c89d07/html5/thumbnails/7.jpg)
7
REST OF THE TOPICS
• Switching Axes in a chart.• Scenario Manager.• Range Names.• Goal Seek.
![Page 8: DAY 9: EXCEL RAHUL KAVI Rahul.Kavi@mail.wvu.edu Rahul.Kavi@mail.wvu.edu SEPTEMBER 15, 2015 1](https://reader036.vdocuments.us/reader036/viewer/2022062322/5697bf891a28abf838c89d07/html5/thumbnails/8.jpg)
8
RECAP
• Create Charts (2D line charts, Clustered Column Charts).
• Creating Trend-Lines, Spark-Lines.• Setting Axes titles.• Choosing trend-lines based on R-squared
values.• Pivot Tables and Charts
![Page 9: DAY 9: EXCEL RAHUL KAVI Rahul.Kavi@mail.wvu.edu Rahul.Kavi@mail.wvu.edu SEPTEMBER 15, 2015 1](https://reader036.vdocuments.us/reader036/viewer/2022062322/5697bf891a28abf838c89d07/html5/thumbnails/9.jpg)
9
TODAY
• Printing charts• Printing layouts• Switching Axes in a chart• Transposing Tables• Scenario Manager• Goal Seek, What-If analysis• Range Names
![Page 10: DAY 9: EXCEL RAHUL KAVI Rahul.Kavi@mail.wvu.edu Rahul.Kavi@mail.wvu.edu SEPTEMBER 15, 2015 1](https://reader036.vdocuments.us/reader036/viewer/2022062322/5697bf891a28abf838c89d07/html5/thumbnails/10.jpg)
10
SCENARIO MANAGER
• Scenario manager helps user to store pre-defined values into cells and switch between values in cells.
• This provides a easier way to switch between set of values (for example see how sales performance may affect the profit margin of a company?).
• Examples: What will be profit margin if sales are increased by 5%, 10%, 20%, etc.
![Page 11: DAY 9: EXCEL RAHUL KAVI Rahul.Kavi@mail.wvu.edu Rahul.Kavi@mail.wvu.edu SEPTEMBER 15, 2015 1](https://reader036.vdocuments.us/reader036/viewer/2022062322/5697bf891a28abf838c89d07/html5/thumbnails/11.jpg)
11
GOAL SEEK
• This what-if analysis tool provides us means through which we can find a target value by adjusting other set of values.
• Example: How much should I score (the goal) in final Exam to get an A grade?
![Page 12: DAY 9: EXCEL RAHUL KAVI Rahul.Kavi@mail.wvu.edu Rahul.Kavi@mail.wvu.edu SEPTEMBER 15, 2015 1](https://reader036.vdocuments.us/reader036/viewer/2022062322/5697bf891a28abf838c89d07/html5/thumbnails/12.jpg)