...Using Microsoft Excel Getting Started Using Microsoft Excel About Excel What is a Spreadsheet? Microsoft Excel is a program that’s used for creating spreadsheets. So what is a spreadsheet? Before personal computers were common, “spreadsheet” referred to large sheets of lined paper, which were used by people in various businesses to record facts and figures in rows and columns, and then make calculations based on the information. When personal computers first began appearing, one of the first applications was a program released in 1979 called VisiCalc. It was used as a tool for performing spreadsheet style calculations that would have been to difficult to do on a calculator. The program quickly became so popular that people began buying personal computers for their businesses just so they could use VisiCalc. VisiCalc Since then, many other spreadsheet programs have been popular over the years, such as Quattro Pro and Lotus 123. Microsoft Excel was first released in 1985 with newer versions being released every couple of years. The most recent version is Excel 2003 (version 11). © Stephen O’Neil 2005 Page 1 Of 17 www.oneil.com.au/pc Using Microsoft Excel Getting Started How Do Spreadsheets Work? Computer spreadsheets are based on their old paper formats. A spreadsheet on a computer uses rows and columns to record information such as text and numbers, such as the example below. Graduates from University 1996 1997 1998 1999 2000 2001 Total Nursing...
Words: 4397 - Pages: 18
..."Feasibility Study Suitability Tool - Instructions 1. For each criteria, select a value between one and three, where one is the highest and three is the lowest assignable score. For ""Anticipated Project Size"" use your internal metrics as guidance. For example, if you use lines of code, then mentally assign ball park values to Small, Medium and Large as part of determining whether to give this criteria a high or low score. Follow a similar process ""Anticipated Duration"". Since project duration depends on project complexity, mentally categorize earlier projects as short, average or long duration to help put the current project in context. 2. After assigning a score for each criteria, view the Feasibility Study Suitability Indicator to discover the best method to use for determining project viability. 3. Omitted criteria will give an inaccurate result, so ensure all criteria are scored before checking the indicator." Criteria "Score (1=high, 3=low)" Guidelines Business Risk "1 = Significant, high-risk projects 2 = Low-to-modertate risk projects 3 = Small, low risk projects" Technology Risk "1 = Significant, high risk technological risks 2 = Low-to-moderate technological risks 3 = Small, low technological risks" Anticipated Project Size "1 = Large 2 = Medium sized 3 = Small" Anticipated Project Duration "1 = Long 2 = Medium...
Words: 451 - Pages: 2
...Instructions as Applied to Microsoft® Excel for Teachers Project summary Goal Given access to a personal computer with Internet Explorer, instructor led, web-based lessons, and the Microsoft® Excel program, the learners will be able to create an Excel grade book. The teachers at Roosevelt Elementary School are urged to use technology daily. And while all teachers have access to the Microsoft® Office professional software suite, in addition to a schoolmaster program, staff surveys (January 2004, Technology staff survey and march technology committee meetings) single out Microsoft excel as the program in which they most need training. Using a spreadsheet program to maintain a grade book will allow the learners (teachers at Roosevelt Elementary School) to follow through with their technology goal of learning to use the software programs they have. It is also a potential time saver for the very busy teachers. Most teachers realize that Microsoft® Excel is a powerful Program. Once a teacher learns Microsoft® Excel to create their own grade book, a small first step; they will then be able to utilize other aspects of Excel relating to the grade book. For example, they can customize their grade book by adding comments, charts or graphs or might possible use the charts and graphs feature on their own for other classroom applications. This would provide a visual representation of their students’ classroom performance. Other well-utilized options for using Excel include making rubrics...
Words: 11547 - Pages: 47
...SIMULASI PENILAIAN KINERJA PORTOFOLIO SAHAMMENGGUNAKAN MICROSOFT EXCEL | | | | | | | | | | | | | | | | | | | | OLEH : | BASITH AHMAD AGUSTA (1306418865) | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | PROGRAM PASCASARJANA ILMU MANAJEMEN | FAKULTAS EKONOMI | UNIVERSITAS INDONESIA | DEPOK | 2013 | PENDAHULUAN TUJUAN Pada penulisan makalah ini penulis akan mennyajikan simulasi mekanisme dasar perhitungan portofolio. Data yang digunakan adalah data yang berasal dari Pasar Modal Indonesia (kode:idx). Diplih ada 6 saham LQ45 yang diperkirakan memiliki jumlah transaksi yang aktif (likuid) Selain itu pemilihan saham-saham LQ45 diukarenakan ketersediaan data yang lengkap, akurat dan mudah didapatkan. Digunakan juga Index pasar IHSG guna menghitung Korelasi antara masing-masing saham dengan kondisi pasar. Kondisi pasar dapat diasumsikan tersirat pada harga Index IHSG TEORI PENDUKUNG 1. Return Measures Dengan asumsi tidak ada tambahan dana investasi atau pinjaman selama periode evaluasi,perubahan dalam investor’s total wealth selama periode evaluasi adalah: r = (Pt – Pt-1)/Pt di mana : V0 = nilai awal portofolio V1 = nilai akhir portofolio Penggunaan istilah Hoding Period Retun juga dipergunakan pada beberapa referensi (Bodie...
Words: 1174 - Pages: 5
...of Microsoft Word, Excel and PowerPoint in the workplace today and how do they make work easier for employers and employees? Imagine being in an office five, ten, or even fifteen years ago and you have to create a financial report for your investors. Computers are not there and you have to have a description of the past year's income and expenses, and also planned income and expenses for the coming year. You are to prepare financial charts of income and expenses accompanied by charts and graphs. Writing it all out, getting the graphics perfect, editing it all and then typing it all up, getting it copied and ready for your presentation would be a very discouraging task. Without the office tools of today, you would be writing on chalk boards and using charts created on pieces of paper. Microsoft Office programs such as Word, Excel, and PowerPoint are available in most desktop publishing programs for preparing, editing, or handling any type of document you might need to work with. The uses of these programs are: • Microsoft Word Is a program used to create letters, reports, invitations and flyers for all types of businesses. It is the basic part in all documents where spelling, grammar and punctuation are corrected in order for the individual to be able to communicate at a professional level with their associates, classmates or family. It also comes with templates to help you design different documents such as resumes or invitations, letterheads, or invoices. • Excel Is...
Words: 482 - Pages: 2
...MANFAAT YANG DAPAT DIAMBIL DARI MICROSOFT EXCEL 6 Microsoft Excel merupakan perangkat lunak untuk mengolah data secara otomatis meliputi perhitungan dasar, penggunaan fungsi-fungsi, pembuatan grafik dan manajemen data. Perangkat lunak ini sangat membantu untuk menyelesaikan permasalahan administratif mulai yang paling sederhana sampai yang lebih kompleks. Permasalahan sederhana tersebut misalnya membuat rencana kebutuhan barang meliputi nama barang, jumlah barang dan perkiraan harga barang. Contoh permasalahan yang lebih kompleks adalah pembuatan laporan keuangan (general ledger) yang memerlukan banyak perhitungan, manajemen data dengan menampilkan grafik atau pivot tabel atau penggunaan fungsi-fungsi matematis ataupun logika pada sebuah laporan. Microsoft Excel sudah tak asing dalam kehidupan kita sehari-hari, Microsoft Excel memiliki banyak sekali fungsi antara lain : 1. Membuat sebuah laporan keuangan 2. Membuat Daftar Nilai 3. Membuat daftar hadir 4. Melakukan operasi kali,bagi, rerataan dengan cepat 5. Menghitung Kurs Mata Uang 6. Membuat Grafik dan Tabel dari suatu penghitungan 7.Membuat diagram batang,diagram garis dan diagram lingkaran 8. Membantu kita dalam menyelesaikan soal-soal logika dan matematika 9. Membuat presentasi jadi lebih praktis dan mudah 10.Menyajikan data secara tepat,rapi dan akurat Sebelumnya kita perlu mengetahui bentuk dari microsoft excel terlebih dahulu dasar dasar microsft excel 2007 sebelum memulai menggunakan...
Words: 1281 - Pages: 6
...1 Microsoft Excel 2010 Tutorial Excel is a spreadsheet program in the Microsoft Office system. You can use Excel to create and format workbooks (a collection of spreadsheets) in order to analyze data and make more informed business decisions. Specifically, you can use Excel to track data, build models for analyzing data, write formulas to perform calculations on that data, pivot the data in numerous ways, and present data in a variety of professional looking charts. The Ribbon Understanding the Ribbon is a great way to help understand the changes between Microsoft 2003 to Microsoft 2010. The ribbon holds all of the information in previous versions of Microsoft Office in a more visual stream line manner through a series of tabs that include an immense variety of program features. Home Tab This is the most used tab; it incorporates all text and cell formatting features such as font and paragraph changes. The Home Tab also includes basic spreadsheet formatting elements such as text wrap, merging cells and cell style. Insert Tab This tab allows you to insert a variety of items into a document from pictures, clip art, and headers and footers. Page Layout Tab This tab has commands to adjust page such as margins, orientation and themes. Created By: Amy Beauchemin Source: office.microsoft.com 1/13/11 2 Formulas Tab This tab has commands to use when creating Formulas. This tab holds an immense function library which can assist when creating any formula or function...
Words: 7496 - Pages: 30
...Mileage Rate Schedule 11 Complete Mileage Expense Type Definition in Payables 12 SA: Define Profile Options 13 System Administration Integration 18 Customize the Internet Expenses Workflow 19 Define a new OIEADMIN Role 19 Define Workflow Notification Performers 20 Change the Find Approver Method 21 Personalize Expense Report Submission Instructions 22 Integrating with Oracle Projects Summary 23 7. Enable the Display of Project and Task. Use the Region Items window to enable the display of project and task information. You need to perform this step in order to view projects and tasks in View Expense Report History. 24 Set Up Offline Expense Spreadsheet Template 25 Configure the Expense Report Sheet 25 Testing a New Custom Microsoft Excel Template 28 Save the spreadsheet to the database 29 Other Configuration Considerations 30 Open and Closed Issues 31 Enable Project Expenditure Types for Expense Report Entry Project...
Words: 6272 - Pages: 26
...efficient method for the college students to make copies. The three students James, Ernie, and Terri decided to go into business together with a copying business initiative. Considering what was ahead of the new business, for example, possible machine downtime and days to repair the copier, they had to determine the average number of days that it would take for them to acquire a repair team to fix the machine in the event that it broke down. As discovered, the average time for repair was between one and four days. In order to calculate the average, a probability distribution was developed using Microsoft Excel. From there, the cumulative probability was obtained by adding the probability, P(x), from the previously itemized probabilities where the cumulative summation of a probability is always equal to one (1) or 100%. A random number formula, =RAND(), was plugged into the Microsoft Excel desired cell, in this situation, (H4), which generated a random range of numbers that are greater than or equal to zero and less than one. The interim time between breakdowns were achieved simply by soliciting the experience several staff members in the college of business who were familiar with frequency of the copier’s inconsistent behavior. It was estimated that the time between breakdowns was probably between zero and six weeks. Using the continuous probability distribution formula, x=6√r1, where six is the maximum number of weeks in this study and r1 is the random number. The amount of breakdowns...
Words: 679 - Pages: 3
...security of these materials. By classifying smaller goods, like dry batteries, we can categorize them into one shipment package that can be transported safely back. Other products like cell phones and their accessories, we can pack them together so we have a safety for the products to remain in one carton. Likewise, keeping computer accessories with laptops and keeping LCDs separate, we can ensure that the products do not get damaged during transportation. Data base system is not that compulsory for managing this equipment, although it is a good thing to have it but it gets costly, when we can easily keep track of the items through Microsoft Excel software. Every product that is being classified can be easily recorded in Excel. Although, there are some advantages and disadvantages for using Excel for storing information. First of all, Excel is really portable and it can be easily sent through e-mail and can be synchronized with PDAs such as iPhone, secondly, it can be protected...
Words: 1125 - Pages: 5
...Job Description | Job Title | -Medical Representative | Edition | 1/2013 | Division | NevellaHeartland | Department/Unit/Section | Prospection | Creation Date | January 2013 | Revision date | 1/2013 | Employee Name | Diana Michailidis | Employment Date | May 2012 | | | Employee Starting Date in Position | 1/2013 | 1- Job Purpose | Responsible for bringing business for the pharmaceutical company by effectively promoting pharmaceutical products to healthcare professionals (Doctors and Selected Pharmacist) and asking them to prescribe such products to appropriate patients. | 2- Lines of Reporting | General Manager Dr. Khaled Alam General Manager Dr. Khaled Alam Product Manager Miss Jinane Al Agha Product Manager Miss Jinane Al Agha Diana Michailidis Medical Representative Diana Michailidis Medical Representative | 3- Duties and Responsibilities | * Plan, organize and execute product presentation to Doctors and pharmacists regarding the therapeutic use of the product, mode of action, features and benefits; * Plan each call through the proper identification of appropriate product or products to promote, which sales tools to use and the right schedule to execute the call; * Calling on pharmacies to create awareness and educate clients on products and sell to target accounts; * Observe, record and report competitor activities executed in the territory and identify appropriate counter strategy. * Constantly endeavor...
Words: 404 - Pages: 2
...CONTENTS OF PERFORMANCE APPRAISAL FORM: 1. Quality of work • Consider accuracy, thoroughness, effectiveness. • Pressure, ability to meet standards of quality. • Use of time and volume of work accomplished. • Work output matches the expectations established. 2. Quantity of work • Competence, thoroughness, and efficiency of work regardless of volume. • Neatness and accuracy. 3. Teamwork: • Establish and maintain effective working relationship with others. • Shares information and resources with others • Follows instructions of supervisor and respond to requests from others in the team in a helpful manner. • Contributing work and effort to group performance to meet agreed upon objectives and achieve team success 4. Job knowledge • Application of appropriate level of technical and procedural knowledge in specific field • Degree of technical competence • Understanding of job procedures, methods, facts and information related to assignments. • Perform duties with minimal supervision but seek guidance where and when appropriate to the job, consults the appropriate staff 5. Initiative • Consider the extent to which the employee sets own constructive work practice and recommends and creates own procedures. • Self-starter, develop and implement new methods, procedures, solutions, concepts, designs and/or applications of existing designs or procedures. • Accepts additional challenges and responsibilities and willingly assist others, self-reliant. • Completes assignment...
Words: 840 - Pages: 4
...Chapter 6 Reading Excel Worksheets 0.1 0.2 Introduction.............................................................................. Error! Bookmark not defined. A Section Title .......................................................................... Error! Bookmark not defined. Demonstration: .............................. Error! Bookmark not defined. Exercises .................................................................................. Error! Bookmark not defined. 0.3 0.4 Chapter Summary ................................................................... Error! Bookmark not defined. Solutions .................................................................................. Error! Bookmark not defined. Solutions to Exercises .............................................................. Error! Bookmark not defined. Solutions to Student Activities (Polls/Quizzes) .......................... Error! Bookmark not defined. 6-2 Chapter 6 Reading Excel Worksheets 6.1 Using Excel Data as Input 6-3 6.1 Using Excel Data as Input Objectives Use the DATA step to create a SAS data set from an Excel worksheet. Use the SAS/ACCESS LIBNAME statement to read from an Excel worksheet as though it were a SAS data set. 3 Business Scenario An existing data source contains information on Orion Star sales employees from Australia and the United States. A new SAS data set needs to be created that contains a subset of this existing data source. This...
Words: 4761 - Pages: 20
...a key parameter in the Capital Asset Pricing Model (CAPM) which is most commonly used asset pricing model for the estimation of required rate of returns on a share (i.e. cost of equity=rE). This assignment consists of two parts. Part I directs you to work with real financial data in Excel and aims to take you through the basic exercise of estimating a company beta and computing statistics which can be evaluated as part of investment decision-making process. Part II requires you to write a report based on interpretations of the outputs obtained from the first part. In this manual, you will also find out how to download historical share price, market index data and interest rates from the web portal. ➢ Details of Questions PART 1 [30 marks] To successfully complete PART 1, please read each section carefully. You must read “Format and printing requirement” before you produce any outputs. I also encourage you to read the entire manual before you choose your companies for analysis. If you have read “Format and printing requirement”, then proceed. Provide your answers (or outputs) for the following questions. All the calculations and computations are required to be produced in Excel (This manual has been designed for you to do this assignment using...
Words: 3262 - Pages: 14
...business which is held available in stock. Updating the records of the stocks in a business plays an important part for the organization of business functions. Manual application of transaction can bring interruption, thus, the Automated Sales and Inventory System is considered as the best solution to this problem. A business owner can franchise more than one line of franchise, Mrs. Teresa has a group of franchised business which she named, R and E food station. Her business started last February 2014 and successfully opened 2 branches in 3 months. Since then, they record their daily sales and inventory manually by the use of record book and Microsoft excel. It starts from counting and checking their previous available stocks individually, computer for the total used stocks, record it in a record book and update the whole record in Microsoft excel. It takes a lot of time and the possibility for human errors is always present which could result to inaccurate information. The researchers aim to design and develop computer based system that will automate the manual system that the business is currently using to provide a more reliable, accurate and fast results. Objectives of the study The researchers aim to accomplish the...
Words: 927 - Pages: 4
