Using Microsoft Excel

Good Essays
Using Microsoft Excel 2010

Advanced Skills

Using Microsoft Excel
Advanced Skills
Excel contains numerous tools that are intended to meet a wide range of requirements. Some of the more specialised tools are useful to only certain types of people while others have value for more general excel users. These exercises will cover some of the advanced features that may be useful for most excel users. These features will include cell naming, cell notes, conditional formatting, data validation and custom number formats. Naming Cells
In a large spreadsheet, cell referencing and selection may be simplified by making use of names. You can assign a unique name to an individual cell or to a range of cells.
This can make it quicker and easier to refer to the cells in charts and functions.
Additionally, functions that make use of names are easier to read. For instance, a formula that says =B4-B5 doesn’t make as much sense as a formula that says
=Sales-Expenses.

Exercise 1. Creating Cell Names
1) Create a new workbook in Excel and create a table like the one below.

© Steve O’Neil 2010

Page 1 of 24

http://www.oneil.com.au/pc/

Using Microsoft Excel 2010

Advanced Skills

2) Save the file as Budget.
3) Click on Cell A3 which will have the current date.
4) Click in the Names box which is to the left of the formula bar. Currently it will display the reference of the currently selected cell.

5) Type Date in the box and press [Enter] to create the name for that cell.
6) Click in another cell anywhere on the worksheet (or even in another worksheet).
7) Click on the dropdown arrow next to the Names box. A list of names for the current workbook will appear.

8) Click on the Date name. Excel will automatically go to, and select that named cell, even if you were on a different sheet.
Note

Whenever you select a cell or range of cells that is named, the name will appear in the names box instead of the cell reference.

9) Select the

You May Also Find These Documents Helpful

  • Powerful Essays

    Microsoft Excel

    • 1757 Words
    • 8 Pages

    Microsoft Excel 2007: Create a macro by using Microsoft Visual Basic | Add to Favorites | In Microsoft Excel 2007, macros can be created using Microsoft Visual Basic. The following will show you how to create a macro using Microsoft Visual Basic: 1. If the Developer tab is unavailable, complete the following to display it: a. Click the Microsoft Office Button, and then click Excel Options. b. In the Popular category, under Top options for working with Excel, choose…

    • 1757 Words
    • 8 Pages
    Powerful Essays
  • Good Essays

    Microsoft excel

    • 575 Words
    • 3 Pages

    On the morning of April 15, 1912, the sinking of the Titanic the previous night shocked the world. The year had dawned bright with promise and the maiden voyage of the Titanic was a symbol of the advances mankind had made in the last few years. The ship was considered to have been so well constructed it was believed she could sustain any amount of damage and still remain afloat. Late on the night of April 14, 1912, the sinking of the Titanic proved this idea wrong in a horribly tragic way. The…

    • 575 Words
    • 3 Pages
    Good Essays
  • Good Essays

    Microsoft Access and Excel: How They Are Different and How They Are Applied In the Business World. Both Microsoft Access and Microsoft Excel are programs created by Microsoft Corporation as a part of Microsoft Office. Though these two programs are quite similar, they are different in some ways simply because each of them is more efficient at solving certain important tasks. In order for a decision to make the best decision in obtaining maximum efficiency, performance and accuracy when drawing…

    • 788 Words
    • 4 Pages
    Good Essays
  • Good Essays

    Cynthia Computer Application-205 Microsoft Word, Excel, and PowerPoint Microsoft Word-Microsoft Corporation was founded in 1975 lead global in the development and production of software and software-related services and solutions. Initially known for home computers, Microsoft, headquartered in Washington, now offers various operating systems and software for desktop computers. This multinational company strives to help the worldwide business community improve efficiency and productivity…

    • 756 Words
    • 4 Pages
    Good Essays
  • Powerful Essays

    Microsoft Excel

    • 8907 Words
    • 36 Pages

    2. Costing aircraft components A British Aerospace case study Introduction When we think about the cost of an aircraft, we tend to think of the cost of buying the product rather than the costs of running it! British Aerospace’s service to the customer does not stop at the aircraft acquisition stage, when the aeroplane is sold to the customer. If anything, this is when the customer relationship begins. This case study focuses upon the processes involved in costing aircraft components. Given the…

    • 8907 Words
    • 36 Pages
    Powerful Essays
  • Powerful Essays

    The 'Excel 3D Scatter Plot' macro – The Manual Copyleft by Gabor Doka, Switzerland, © 2006 – 2012 reach the author under: scaplo {at} doka {dot} ch A very quick introduction: A first chart 1. Open the workbook "3Dscatterplot.xls" that contains the necessary macros. 2. In a trial workbook enter some data you want to display in three columns (x,y,z). 3. Optionally you can enter a header column containing text labels for each point. 4. Leave 10 empty rows above the data range and one empty column…

    • 4152 Words
    • 17 Pages
    Powerful Essays
  • Satisfactory Essays

    Microsoft Excel Test

    • 306 Words
    • 3 Pages

    Question 1 Consider the following Excel screenshot: Cells C10:C13 are a named range called “Province”. Which of the following is the correct entry in the ‘Source’ field in the data validation dialogue box to display the drop-down list in the cell F4 if cells C10:C13 is a named range called “Province”? A) B) C) D) Ontario,Quebec,Alberta,British Columbia =C10:C13 Province ={Ontario,Quebec,Alberta,British Columbia} Questions 2, 3 Consider the following Excel screenshot: Which of the following is…

    • 306 Words
    • 3 Pages
    Satisfactory Essays
  • Good Essays

    Microsoft Excel Questions

    • 305 Words
    • 2 Pages

    company providing onsite and telephone support to customers with Microsoft Excel questions. On this particular day, you are presented with the following three situations: Situation 1: A business professional wants to use Excel to organize data for the monthly expense report. He has never used Excel and is inquiring about the functions that would support him with this task. Situation 2: A husband is having difficulties with his Excel spreadsheet. He has been trying to track his monthly grocery…

    • 305 Words
    • 2 Pages
    Good Essays
  • Satisfactory Essays

    Microsoft Excel Test

    • 380 Words
    • 2 Pages

    BIA 0075 Formative Assessment for Spreadsheet Exercise Instructions Time allowed - 45 minutes Produce a spreadsheet that will deal with the following situation The Garden Gnome company is undertaking its five year forecast process and is in the process of constructing its profit and loss account. The following information is available a) In 2012 Sales are expected to be 50,000 gnomes at £20 each but volumes and prices are expected to increase by 2% and 3% per annum respectively on a cumulative…

    • 380 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Complete the following tasks by using the Microsoft® Excel®document provided in Course Materials:  Format appropriate cells for currency.  Merge title cells.  Construct a bar graph using the existing data and provide labels and a legend.  Insert a border around data.  Freeze the first column of the data set.  Sort the daily spending amounts in ascending order.  Using the Tools menu, set the Excel spreadsheet to be protected.  Calculate the sum of the entire data set.  Calculate…

    • 409 Words
    • 2 Pages
    Satisfactory Essays