CIS105 Week 4 Notes
CIS105 Week 4 Notes CIS 105
Popular in Computer Appls&Info Technology
verified elite notetaker
Popular in Business
This 3 page Class Notes was uploaded by Sarah Booth on Monday September 26, 2016. The Class Notes belongs to CIS 105 at Arizona State University taught by Staff in Fall 2016. Since its upload, it has received 4 views. For similar materials see Computer Appls&Info Technology in Business at Arizona State University.
Reviews for CIS105 Week 4 Notes
Report this Material
What is Karma?
Karma is the currency of StudySoup.
You can buy or earn more Karma at anytime and redeem it for class notes, study guides, flashcards, and more!
Date Created: 09/26/16
Computer Information Systems (CIS105) Arizona State University Sarah Booth Importance of mastering Excel: • It is a business illiteracy to not know Excel • Excel is used all the time in the professional workplace • Excel is the market leader today • Automates many tasks associated with spreadsheet creation and manipulation Spreadsheets • Spreadsheets are the heart and soul of accounting • Financial statements are presented on spreadsheets • Spreadsheets also store data for companies - EDGAR: Electronic Data Gathering, Analysis and Data Retrieval System - Operated by SEC: Securities and Exchange Commission • There website is where you can ﬁnd: - 10-K Annual Report - 10-Q Quarterly Report Data Analysis: • Spreadsheets are used to answer the question “What is going on in my business?” Numeric Analysis • Sort, group, ﬁlter, highlight • Find the largest, the smallest, the average Graphical Analysis • Column • Bar • Pie • Plot • Spreadsheets are also used to answer “What if?” - What will change in our proﬁt if our cost of raw materials increases by 10%? • Excel facilitates answering such questions by automatically recalculating everything that depends on x when you change its value - Modeling a situation with a set of equations Personal Finance • Budgeting • Buying vs. leasing a car - Monthly payments - Down payment • Buying a house - Mortgage payments - Down payment - Interest rate - How much can you afford? • Investment returns • Save or Spend - The importance of living within your means References Absolute and Otherwise • Look at Carpet Calculator • Mixed, absolute and relative addresses The Autoﬁll Function • Copying formulas • Series construction - Numbers - Dates - Days
Are you sure you want to buy this material for
You're already Subscribed!
Looks like you've already subscribed to StudySoup, you won't need to purchase another subscription to get this material. To access this material simply click 'View Full Document'