Some Answers

Creating a Pivot Chart

Create a Pivot chart with a Slicer

  • You have already created a Pivot Table from you data and would like to analyse it further.

  • Select the Analyze tab

  • Select the pivot chart icon

  • A dialog box will present you with options for the chart that you would like to select

  • We will select the pie chart.
  • Select your chart and copy it to another sheet

  • Select your chart and analyze tab will appear.
  • Select the analyse tab

  • From the menu select inset slicer

  • We will select Posted date

  • Move the date box to the side of the chart and stretch it longer
  • With all the dates selected you are able to see all the sales
  • Select just a few days and you will see the sales for that period only
  • To view all dates; all dates must be selected

Linking Excel Files

View Instructions for Linking two Excel files

  • Linking two different excel files is not ideal but maybe necessary.
  • Changes in the format of either file may result in corrupted data.
  • For the purposes of confidentiality of one file; it may be necessary to link to another file.
  • There are a few steps that you can use to improve the integrity of your data.
  • Ideally the source and the dependant file are kept in the same folder on your network
  • Maintain the format of the source file and the destination file

  • From the cell in the destination file enter =
  • Select the cell in the source file that you would like to like and press enter

  • Once the file has an external link, the Edit Links button become activated on the Data tab.

  • The dialog box allows you to manage your external links.

    Managing Named Ranges

    View instructions how to manage named ranges

    • Naming ranges is an effective method of securing your data source and allows you to create complicated formulas relatively easily.
    • With Excel 2010 they have created a section on the Formula tab to help manage named ranges.

    • Select a group of cells that you would like to name
    • Click on the Define name

    • Enter the desired name for the range of cells
    • In comments, enter a description of what the group of cells
    • Click O.K.
    • Click Name Manager
    • The dialog box will be displayed

    • To delete the name of the range; select the name from the list and click delete
    • To edit the name of the range; select the name from the list and click edit.
    • With the dialog box that appears, you are able to change the name, add comments or change the range of cells that this name refers.

Sign up for our newsletter and receive a free calendar pop-up for entering dates

* indicates required