...Unfortunately, even the advanced users are frequently not aware of dozens of highly-useful features and techniques because they are self taught. Based on over 20 years of using and teaching spreadsheets to Accountants, this session is packed with tips and techniques that will save you time and make you more effective. Topics include using global rounding, using hyperlinks in Excel, standardizing spreadsheet design, 24/7 free support for Excel problems, using the camera feature to create reports that are separate from the Excel data and much, much more. Table of Contents Using Wildcards to Sum Cells in Sheets ............................................................................. 3 End Down and End Right with a Double Click of the Mouse ............................................ 4 Fill an Entire Column with One Double Click .................................................................... 4 Using Internet Newsgroups for Excel Help......................................................................... 5 Using the Google Web Site to Search Newsgroups ............................................................ 6 Format Painter ................................................................................................................. 8 Creating Formula that Only Reference Non-Blank Cells ................................................... 8 Working with Styles ...............................................................................................................
Words: 7500 - Pages: 30
...multimedia content. * Which of the following is an example of disintermediation? * Which of the following is a mechanism for consumer-to-consumer transactions? Topics:1 Chapter 1 * Globalization * Economic Changes: in crease in * Outsourcing * Cloud Computing * Business Changes from IS * Five Aspects of IT * Data, Information, Knowledge * IS Personnel Competencies * System Types/Purposes P28 * Ethics/Issues * Issues: a) Information Privacy b) Intellectual Property c) The Need for a code of Ethical Conduct - Responsible Computer Use d) The Digital Divide Chapter 3 * Infrastructure Components * * Computer Classes * Data Storage and Concerns * Internet vs. WWW * How Data is Transmitted * Network Types - P119 * How the Internet/Web works * What the Web Uses – Files, Addresses, Suffixes, etc. *...
Words: 332 - Pages: 2
...Your task is: 1. Using IF, filter the data for these students by major. You will need to add a column for each major and then use the IF function to filter the data by major. Your formula should use proper anchoring so it is copyable both down and across. 2. Calculate the overall average GPA as well as the average GPA for each major. 3. Use conditional formatting to shade cells pink if a GPA is less than 2.2 Your solution must look like this (including the formatting): Your solution must take into account the possibility that the data could change, i.e., do not “hard code” any data values. If the major of a student changes, your calculations should update to the correct values automatically. Additionally, if new rows are inserted or existing rows are deleted, your spreadsheet model should still work. Problem 2 (40 Points) In the sheet “Problem 2”, you are given information about a savings account. Use this information to create a savings calculator. Notice that some cells have been given names. Use these names in formulas where appropriate. You can view all named cells in the Name Manager under the Formulas tab. 1. Use formulas to fill in the columns as shown below, including the column for DepNo. Lookup the DATE formula to figure out how to fill in the Payment Date column. You...
Words: 1130 - Pages: 5
...data by season. Your formula should use proper anchoring so it is copyable both down and across. 2. Calculate the total number of festivals each season as well as the percentage of festivals that fall in each season. Your solution must look like this (including the formatting): Problem 2 (40 Points) Your solution must take into account the possibility that the data could change, i.e., do not “hard code” any data values. If the season of a festival changes, your calculations should update to the correct values automatically. Additionally, if new rows are inserted or existing rows are deleted, your spreadsheet model should still work. In the sheet “Problem 2”, you are given information about a savings account. Use this information to create a savings calculator. Notice that some cells have been given names. Use these names in formulas where appropriate. You can view all named cells in the Name Manager under the Formulas CS1100 Lab E1 tab. 1. Use formulas to fill in the columns as shown below, including the column for DepNo. Lookup the DATE formula to figure out how to fill in the Payment Date column. You may type in the...
Words: 1159 - Pages: 5
...BIT 200 FINAL STUDY GUIDE • What is the difference between data and information: o Data is a set of discrete, objective facts about events. In an organizational context, data is most usefully described as structured records of transactions. o Information is a message to change the way the receiver perceives something to have an impact on his or her judgment or behavior. • Ex. Your doctor tells you are on the verge of being obese. If you do not want to increase your risk of heart disease or diabetes, then you need to change your eating habits. • What are the reference disciplines in information systems: o Computer Science- Computer Science is the discipline that seeks to build a scientific foundation for topics like computer design, computer programming, information processing, algorithmic solutions or problems, and the algorithmic process itself. o Management Science-The discipline using math and other analyzed methods to help make better decisions in business. Field includes- decision analysis, probability, and math modeling. • Management Science body of knowledge – uses quantitative approaches to decision making and is referred to as management science, operations research, and decisions science. • What do processors do: o A processor interprets computer program instructions and processes data. • Moore’s Law- Moore’s Law state that processor speeds will double every 18 months • The different kinds of storage memory are: kilobyte, megabyte, gugabyte, terabyte...
Words: 6356 - Pages: 26
...Computer Science Chapter 1: Introduction to Computer Hardware Different Categories of Computer and Computing Devices Tablets The lightest and most portable Touch interface, good for “light” work Laptops/Notebooks Larger display area; adds CD or DVD as well as physical keyboard They are portable; price for performance is not as good as desktop, choice of hardware is limited Specialized Variant Laptops Ultrabooks Thinner, and lighter than laptops Cost is higher than laptop (all hardware being equal) Netbooks Cheaper more portable laptop that is smaller and has a lower quality display and overall less powerful hardware Much less common than tablets today Desktop Computers Everything is separate (monitor, computer, keyboard, etc); this allows you to mix and match and customize your desktop computer, at the cost of increased complexity (some compatibility issues may arise – not everything works together) and decreased portability. Larger ‘footprint’ (More space is required, but this allows for increase expandability) ------------------------------------------------- Reduced costs/more options (compared to laptops) ------------------------------------------------- The purpose of an operating system is to run the computer. The operating system determines the interface of a computer, its configurability, and its security. In general, due to popularity and tweak-ability, the MS-WINDOWS (PC) OS has more viruses than the MAC OS. In general, the MAC OS...
Words: 3669 - Pages: 15
...MS-EXCEL FOR CHARTERED ACCOUNTANTS SUNIL B GABHAWALLA CHARTERED ACCOUNTANT WESTERN INDIA REGIONAL COUNCIL OF THE INSTITUTE OF CHARTERED ACCOUNTANTS OF INDIA TABLE OF CONTENTS 1 2 Basics & Beyond......................................................................................................... 4 1.1 Introduction......................................................................................................... 4 1.2 The EXCEL Screen............................................................................................. 4 1.3 Moving Around................................................................................................... 5 Data Entry ................................................................................................................... 8 2.1 Text ..................................................................................................................... 8 2.2 Number (including date, time, percent) .............................................................. 8 2.3 Formulae ............................................................................................................. 8 2.4 Functions............................................................................................................. 9 2.5 AutoComplete ..................................................................................................... 9 2.6 AutoCorrect........................................................................................
Words: 16077 - Pages: 65
...Checking Your Spelling 25 Module Four: Working with Excel Files 26 Saving Files 27 Publishing Files to PDF 28 Sending Files via E-Mail 30 Closing Files 31 Opening Files 32 Module Five: Viewing Excel Data 34 An Overview of Excel’s Views 35 Switching Views 36 Creating Custom Views 38 Using Zoom 41 Switching Between Open Files 43 Module Six: Printing Excel Data 44 An Overview of the Page Layout Tab 45 Setting Up Your Page 46 Using Print Preview 48 Printing Data 49 Module Seven: Building Formulas 50 The Math Basics of Excel 51 Building a Formula 52 Editing a Formula 54 Copying a Formula 56 Relative vs. Absolute References 58 Module Eight: Using Excel Functions 59 Formulas vs. Functions 60 Using the SUM Function 61 Using Other Basic Excel Functions 63 Understanding the Formulas Tab 64 Using the Status Bar to Perform Calculations 65 Understanding the New Function Names 67 Module Nine: Using Time Saving Tools 68 Using AutoFill 69 Using AutoComplete 71 Sorting Data 73 Filtering Data 75 Adding Sparklines 80 Module Ten: Formatting Your Data 82 Changing the Appearance of Text 83 Changing the Appearance of Numbers 84 Setting Alignment Options 86 Using Merge 87 Removing Formatting 89 Module Eleven: Advanced Formatting Tools 90 Adding Borders 91...
Words: 3351 - Pages: 14
...SPREADSHEET MODELING IN CORPORATE FINANCE To accompany Principles of Corporate Finance by Brealey and Myers CRAIG W. HOLDEN Richard G. Brinkman Faculty Fellow and Associate Professor Kelley School of Business Indiana University Prentice Hall, Upper Saddle River, New Jersey 07458 To Kathryn, you’re the inspiration, and to Diana and Jimmy, with joy and pride. Craig CONTENTS Preface PART 1 TIME VALUE OF MONEY Chapter 1 Single Cash Flow 1.1 Present Value 1.2 Future Value Problems Chapter 2 Annuity 2.1 Present Value 2.2 Future Value 2.3 System of Four Annuity Variables Problems Chapter 3 Net Present Value 3.1 Constant Discount Rate 3.2 General Discount Rate Problems Chapter 4 Real and Inflation 4.1 Constant Discount Rate 4.2 General Discount Rate Problems Chapter 5 Loan Amortization 5.1 Basics 5.2 Sensitivity Analysis Problems PART 2 VALUATION Chapter 6 Bond Valuation 6.1 Basics 6.2 By Yield To Maturity 6.3 System Of Five Bond Variables 6.4 Dynamic Chart Problems Chapter 7 Stock Valuation 7.1 Two Stage 7.2 Dynamic Chart Problems Chapter 8 The Yield Curve 8.1 Obtaining It From Bond Listings 8.2 Using It To Price A Coupon Bond 8.3 Using It To Determine Forward Rates Problems Chapter 9 U.S. Yield Curve Dynamics 9.1 Dynamic Chart Problems PART 3 CAPITAL BUDGETING Chapter 10 Project NPV 10.1 Basics 10.2 Forecasting Cash Flows 10.3 Working Capital 10.4 Sensitivity Analysis Problems Chapter 11 Cost-Reducing Project 11...
Words: 49278 - Pages: 198
...Overview of Applications by Discipline ECONOMICS Estimating sensitivity of demand to price 352–356 Pricing problems 352–366, 422–427 Estimating cost of power 363–366 47–56, Assessing a utility function 554–556 Estimating demand for products 632–638, 649–650, 764–771, 965 Subway token hoarding 792 FINANCE AND ACCOUNTING Collecting on delinquent credit accounts 14–16 Cost projections 29–33 Finding a breakeven point 33–41 Calculating NPV 57–62 Calculating NPV for production capacity decision 58–62 Portfolio management 173–178, 345–346, 387–394, 442–444, 689–691 Pension fund management 178–182 Financial planning 210–214, 676–681, 734–735 Arbitrage opportunities in oil pricing 215–219 Currency trading 220 Capital budgeting 290–295 Estimating stock betas 396–401 Hedging risk with put options 407–408 Stock hedging 407–408 Asset management 409–410 New product development 503–504, 574, 673–676, 715–722 Bidding for a government contract 513–518, 523–533, 653–657 Investing with risk aversion 557–560 Land purchasing decision 575 Risk analysis 582–583 Liquidity risk management 651–653 Estimating warranty costs 657–661 Retirement planning 681–685 Modeling stock prices 685–686 Pricing options 686–689, 691–693 Investing for college 732 Bond investment 733 HUMAN RESOURCES AND HEALTH CARE Fighting HIV/AIDS 23–24 DEA in the hospital industry 184–189 Salesforce allocation problems 454–456 Assigning MBA students to teams 462 Selecting...
Words: 68271 - Pages: 274
...SECOND EDITION ELECTROCHEMICAL METHODS Fundamentals and Applications Allen J. Bard Larry R. Faulkner Department of Chemistry and Biochemistry University of Texas at Austin JOHN WILEY & SONS, INC. New Yorke Chichester • Weinheim Brisbane e Singapore e Toronto Acquisitions Editor David Harris Senior Production Editor Elizabeth Swain Senior Marketing Manager Charity Robey Illustration Editor Eugene Aiello This book was set in 10/12 Times Roman by University Graphics and printed and bound by Hamilton. The cover was printed by Phoenix. This book is printed on acid-free paper, oo Copyright 2001 © John Wiley & Sons, Inc. All rights reserved. No part of this publication may be reproduced, stored in a retrieval system or transmitted in any form or by any means, electronic, mechanical, photocopying, recording, scanning or otherwise, except as permitted under Sections 107 or 108 of the 1976 United States Copyright Act, without either the prior written permission of the Publisher, or authorization through payment of the appropriate per-copy fee to the Copyright Clearance Center, 222 Rosewood Drive, Danvers, MA 01923, (978) 750-8400, fax (978) 750-4470. Requests to the Publisher for permission should be addressed to the Permissions Department, John Wiley & Sons, Inc., 605 Third Avenue, New York, NY 10158-0012, (212) 850-6011, fax (212) 850-6008, E-Mail: PERMREQ@WILEY.COM. To order books or for customer service, call 1 (800)-CALL-WILEY (225-5945). Library of Congress Cataloging...
Words: 42329 - Pages: 170
...DETAILED SYLLABUS POST GRADUATE DIPLOMA IN COMPUTER APPLICATIONS (PGDCA) (EFFECTIVE FROM JULY 2011) Department of Computer Applications Makhanlal Chaturvedi Rashtriya Patrakarita Evam Sanchar Vishwavidyalaya B-38, Press Complex, M.P. Nagar, Zone-I, Bhopal Ph.: 4294448, 2768274 www.mcu.ac.in SCHEME FOR POST GRADUATE DIPLOMA IN COMPUTER APPLICATIONS (PGDCA) (Effective From July 2011 Session) SEMESTER -I Subject Code Subject Name Scheme L 1PGDCA1 1PGDCA2 1PGDCA3 1PGDCA4(A) 1PGDCA4(B) Fundamentals of Computers & Information Technology Introduction to Operating Systems (Dos, Windows, Linux) PC Packages Elective - 1 Foxpro MS-Access 4 4 1 3 T P Theory Paper 80 80 Internal Evaluation 20 20 Practical Exams Total Marks 100 100 4 4 1 3 3 80 80 20 20 25 25 125 125 Semester Total 450 (*L-Lecture, T-Tutorial, P-Practical) SEMESTER –II Subject Code Subject Name Scheme L 2PGDCA1 2PGDCA2 2PGDCA3 2PGDCA4(A) 2PGDCA4(B) 2PGDCA5 System Analysis and Design Programming with Visual Basic.NET Internet & E-Commerce Elective - 2 OOPs & Programming with C++ Financial Accounting with Tally Project Work 4 4 4 4 T 1 P 3 3 3 Theory Paper 80 80 80 80 Internal Evaluation 20 20 20 20 Practical Exams Total Marks 100 125 100 125 25 1 25 4 100 Semester Total 550 General Instructions: 1. For passing the subject examination minimum 40% marks must be separately scored in Theory Paper, Practical Exams and Internal Evaluation in the subject. 2. For...
Words: 4021 - Pages: 17
...Life cycle cost comparison: Primozone GM192 vs. Ozonia CFV15 A guide of how to create value for your customer. Course: ISM 13 Module 3 Pricing Authors: Blume, Anna 900711 Collu, Giulia 850511 Tutor & Examiner: Hand in date: 1 Caesar, Peter 15-01-15 Primozone Abstract This paper is aimed at providing a comparison of the total cost of owner ship (TCO) of two comparable products through the tool of a lifecycle cost analysis (LCCA). The compared products are ozone generators from Primozone and Ozonia. Firstly the importance of pricing is presented followed by the discussion of the four most common pricing approaches and the best pricing method according to literature to achieve high margins is introduced. The described topics will be explained in detail in the theoretical framework followed by a comprehensive description of how value based pricing can be put into practice through economic value analysis and quantification and be therefore used as sales arguments based on the LCCA presented in Appendix A. The parameters for the LCCA were chosen with the help of the head of sales of Primozone, Jürgen Bischhaus. The collected data are presented in Chapter 4 and implemented into the excel spreadsheet in Appendix A. Several changing parameter scenarios were applied with the result that Primozone outperforms Ozonia in each of them except energy consumption, which are marginally higher, but not significantly. This also results in the ability...
Words: 16342 - Pages: 66
...Full Circle THE INDEPENDENT MAGAZINE FOR THE UBUNTU LINUX COMMUNITY ISSUE #90 - October 201 4 Photo: miss_millions (Flickr.com) P R I S O N AR C H I T E C T BUILD YOUR OWN OPEN SOURCE PRISON Fu ll Ci rcle M a g a zi n e i s n e i th e r a ffi li a te d wi th , n o r e n d o rse d b y, Ca n o n i ca l Ltd . full circle magazine #90 1 contents ^ HowTo OpenConnect to Cisco p.1 4 Full Circle THE INDEPENDENT MAGAZINE FOR THE UBUNTU LINUX COMMUNITY Linux News p.04 BACK NEXT MONTH LibreOffice p.1 5 Command & Conquer p.1 2 Arduino p.25 LinuxLabs p.XX Broadcast With WCS p.1 7 Linux Labs p.28 Review p.36 My Story p.37 BACK NEXT MONTH Blender p.XX Letters p.40 Tuxidermy p.41 Q&A p.42 BACK NEXT MONTH Inkscape BACK NEXT MONTH Ubuntu Women p.XX Ubuntu Games p.44 Graphics p.22 Security p.XX The articles contained in this magazine are released under the Creative Commons Attribution-Share Alike 3.0 Unported license. This means you can adapt, copy, distribute and transmit the articles but only under the following conditions: you must attribute the work to the original author in some way (at least a name, email or URL) and to this magazine by name ('Full Circle Magazine') and the URL www.fullcirclemagazine.org (but not attribute the article(s) in any way that suggests that they endorse you or your use of the work). If you alter, transform, or build upon this work, you must distribute the resulting work under...
Words: 22047 - Pages: 89
...CARIBBEAN EXAMINATIONS COUNCIL Caribbean Secondary Education Certificate CSEC ® INFORMATION TECHNOLOGY SYLLABUS Effective for examinations from May/June 2010 C XC 30/G /S YLL 08 1 Published by the Caribbean Examinations Council All rights reserved. No part of this publication may be reproduced, stored in a retrieval system, or transmitted in any form, or by any means electronic, photocopying, recording or otherwise without prior permission of the author or publisher. Correspondence related to the syllabus should be addressed to: The Pro-Registrar Caribbean Examinations Council Caenwood Centre 37 Arnold Road, Kingston 5, Jamaica, W.I. Telephone: (876) 630-5200 Facsimile Number: (876) 967-4972 E-mail address: cxcwzo@cxc.org Website: www.cxc.org Copyright © 2008, by Caribbean Examinations Council The Garrison, St Michael BB14038, Barbados CXC 30/G/SYLL 08 Contents RATIONALE .............................................................................................................................................. AIMS ...................................................................................................................................................... 1 2 2 2 3 4 5 5 7 7 8 10 12 13 15 16 19 21 23 46 47 ORGANIZATION OF THE SYLLABUS .................................................................................................. SUGGESTED TIME-TABLE ALLOCATION .......................................................................................... FORMAT...
Words: 16882 - Pages: 68
