This website uses cookies to ensure you have the best experience. Learn more

Introduction To Excel Essay

590 words - 3 pages

Introduction to Excel

Formatting and Graphs

Login to blackboard and download the spreadsheet and tutorial notes from the tutorials section of BN1160.

Do not run the files from within blackboard but save them to your drive as you need all the Excel functions to do the exercise.

Formatting in Excel (Point 1 on the Formatting sheet)
In Excel cells can be formatted to enhance the appearance and improve the clarity of the spreadsheet.
*
* Process
* Highlight the cells you wish to format (left click on mouse and drag mouse over cells)
* Go to Format Cells by right clicking on the mouse and choosing the ‘Format Cells…’ option)
Figure 1 – Format Cells Dialog Window | * The Format Cells Dialog Window will appear on your screen (see Figure 1) * You can now format the different characteristics of the cells – in this task you are concerned with turning ...view middle of the document...

*
* Process
* Highlight the cells you wish to chart (months and cumulative balance) - left click on mouse and drag mouse over month cells, press Ctrl on keyboard and left click on mouse and drag mouse over cumulative balance cells
* Choose the ‘Insert’ tab
* Step 1 – choose a sensible graph type from the Charts section * Step 2 – choose ‘select data’ from the Data section and ensure that your x-axis labels are months taken from row 5 of the spreadsheet * Step 3 – Edit Titles (label x and y axis as well), Axes, Gridlines, Legends (no need for legend as only one data series shown on graph), Data Labels and Data Table accordingly * Colours etc can be formatted by double-clicking on them within the chart |
*

*

* Line Graphs in Excel (Line graph sheet)

* There are different types of Line Graph that can be used to representing time series data on the X-axis.
* Have a look at the different line charts by selecting the ‘change chart type’ from the ‘type’ section of the menu (figure 3)
* Work through the tasks listed on the Line graph sheet

Figure 3 – Change Chart Type Window | |

Pie Charts in Excel (Pie chart sheet)

* There are different types of Pie Chart that can be used to represent percentage and proportion data. * Have a look at the different pie charts by selecting the ‘change chart type’ from the ‘type’ section of the menu (figure 3). * Work through the tasks listed on the Pie chart sheet. | |

Bar Charts in Excel

* There are different types of Bar Chart that can be used to represent a wide range of data.
* Have a look at the different bar charts by selecting the ‘change chart type’ from the ‘type’ section of the menu (figure 3).
* Work through the tasks listed on the Bar chart sheet.

| | |
* Don’t Forget – Excel has an extensive Help facility if you require more information about charts etc.
E.g. Click on Help and then type “line chart” – Excel has information about creating line charts.

Other Essays Like Introduction to Excel

M & L Industry Case Analysis

1144 words - 5 pages equation based on the existing demand trend. This is done using calculations. However, rather than manual calculations, MS EXCEL provides a faster mode of calculating and plotting the historic demand figures to develop a regression trend line.. EXCEL allows creating a chart of the demand units against weeks. The chart generates a linear representation of the data which can be further projected for forecasting future sales of the next four

Assign 1: Jet Copies Essay

1019 words - 5 pages 1 Assignment #1: JET Copies Case Problem Read the ³JET Copies´ Case Problem on pages 678-679 of the text. Using simulation estimate the loss of revenue due to copier breakdown for one year, as follows: 1. In Excel, use a suitable method for generating the number of days needed to repair the copier, when it is out of service, according to the discrete distribution shown. 2. In Excel, use a suitable method for simulating the interval between

Calculating Heats of Formation

1302 words - 6 pages Calculation of heats of formation with group increments Abstract For this report an experiment will be done to derive a model to determine the heat of formation for any alkane. Using known results gathered from online sources a model was derived using the LINEST function found on Microsoft Excel. The derived model was not extremely accurate owing to lack of sufficient chosen data. The model however can be used to obtain an estimated value for

Analyse and Present Research Information

669 words - 3 pages task is to collect articles from newspapers, journals and the internet that refer to accidents. Classify the accidents into various types such as industrial, aviation, sporting, home, transport etc Analyse the articles, select and collect relevant data, e.g.: fatalities, area of injury, and number of accident per type. Present the data in a table and graph. Format your work using Microsoft Word and Excel or equivalent software. Review the data

Market Research for Interphone in China 2016

552 words - 3 pages March., 10, 2016, Mumbai, India: Market Reports on China presents the report, on “Market Research for Interphone in China 2016”. It will provide you with a comprehensive understanding of this industry from the following aspects: market size, status in the world, product structure, company analysis of major players, etc., as well as make scientific prediction on the future development interphone industry. 1.INTRODUCTION In this report

Market Report on Production and Market of Sensor in China 2016

561 words - 3 pages March., 11, 2016, Mumbai, India: Market Reports on China presents the report, on “Market Report on Production and Market of Sensor in China 2016”. It will provide you with a comprehensive understanding of this industry from the following aspects: market size, status in the world, product structure, company analysis of major players, etc., as well as make scientific prediction on the future development sensor industry. 1.INTRODUCTION In

Market Research Report for Lapped Wire in China 2016

577 words - 3 pages March., 10, 2016, Mumbai, India: Market Reports on China presents the report, on “Market Research Report for Lapped Wire in China 2016”. It will provide you with a comprehensive understanding of this industry from the following aspects: market size, status in the world, product structure, company analysis of major players, etc., as well as make scientific prediction on the future development lapped wire industry. 1.INTRODUCTION In this

Wireless World Budget Proposal for 10 Years

916 words - 4 pages , remove this text and all text that is in italics in this template when finished your project.) (Also, please submit your Excel spreadsheet that shows your supporting calculations.)   The first paragraph of this executive summary should give a brief description of the business to which this budget applies. Very briefly describe the products and services of this company, the geography or demographics of the customers it serves, and why

Chapter 3

1442 words - 6 pages I. Introduction For almost 6 yrs. Luz Banzon Multi-purpose Cooperative is using excel system for their payroll. Exerting more effort and time, facilitator calculates and records the employee’s salary. Sometimes one mistake can be mistake of everything, starting again from the beginning. This is the reason why this research is aiming to upgrade their current payroll system. Computerized payroll system automates many functions, which saves

Survey of China's Lemon Oil Industry in 2016

590 words - 3 pages May., 03, 2016, Mumbai, India: Market Reports on China presents the report, on “Survey of China's Lemon Oil Industry in 2016”. It will provide you with a comprehensive understanding of this industry from the following aspects: market size, status in the world, product structure, company analysis of major players, etc., as well as make scientific prediction on the future development lemon oil industry. 1.INTRODUCTION In this report

Production and Market of Enoxaparin Sodium Injection in China

606 words - 3 pages May., 28, 2016, Mumbai, India: Market Reports on China presents the report, on “Production and Market of Enoxaparin Sodium Injection in China”. This report provide readers with comprehensive & in-depth understanding of Chinese enoxaparin sodium injection industry. 1.INTRODUCTION In this report, analyzes the investment opportunities of China’s enoxaparin sodium injection industry. It will provide you with a comprehensive understanding of

Related Papers

Bis220 Propossal Essay

775 words - 4 pages  Efficiency and Collaboration Proposal Team a Reflection Summary Maybelline Torres, Jennifer Martinez, Telizmary Pinales, Rose Rivera BIS/220 August 14, 2014 University of Phoenix Efficiency and Collaboration Proposal This proposal addresses the feasible implementation of innovative information system in the Party Plates Organization. In addition evaluate the advantages and benefits of modifying data from Microsoft Excel to

Accounting Essay

1397 words - 6 pages due at a different date as shown in your syllabus. The entire project will be graded by the instructor at the end of the final submission in week 7 and one grade will be assigned for the entire project.     |   | Overall Requirements | Back to Top |   |   | For Parts 1 and 2: Create an Excel spreadsheet to show your computations for the six ratios listed under each part.   For Part 3: Create an Excel spreadsheet to show your

Assignment

2896 words - 12 pages 1.0 Super Capacitor Lab 2.0 Flywheel Lab 3.0 Introduction to Labview 1.0 SUPER CAPACITOR LAB The aim of this task is to observe charge and discharge characteristics of a super capacitor, after that to compare achieved and theoretical characteristics. 1. 1: Recording the Supercapacitors Charge Characteristic PANASONIC - EECHW0D306 - CAPACITOR, RADIAL, 30F, 2.3V Farnell 1305076 Using the battery discharge test PCB setup the

Mat 540 Assignment 1: Jet Copies

617 words - 3 pages the probability of demand demonstrated below. Probability of Weekly Demand | | | | P(X) | Cumulative | Repair Time (days) | 0.20 | 0.00 | 1 | 0.45 | 0.20 | 2 | 0.25 | 0.65 | 3 | 0.10 | 0.90 | 4 | 1.00 |   |   | For the second component of the case, I was asked to find the number of days needed to repair the copier. To begin, I used the RAND() function in Excel to produce random values for column F6:F57. Once the RAND