Module 5 - PowerPoint PPT Presentation

1 / 13
About This Presentation
Title:

Module 5

Description:

Click where you want the top left hand corner of the block to appear. Select variables ... 2. Click where you want the top left hand corner of the block to appear. ... – PowerPoint PPT presentation

Number of Views:45
Avg rating:3.0/5.0
Slides: 14
Provided by: whit99
Category:
Tags: lefthand | module

less

Transcript and Presenter's Notes

Title: Module 5


1
Different Ways to View Data
Module 5
2
Presentation Styles
  • BOA has different block types that you can use to
    format data in your report

Table Block
Financial Block
Chart Block
Cross-tab Block
3
Tables
  • Table is the default style for presenting data.
    All the reports you have used so far in this
    course have been in this format.

4
Creating Tables
In a report, click the Insert Table button in the
Report Toolbar.
Click where you want the top left hand corner of
the block to appear.
Select variables
5
Financial Tables
  • A financial table is like an ordinary table
    except that the headings run vertically rather
    than horizontally.

Headings
Headings
Horizontal data
Vertical data
6
Creating a Financial Table
Select an existing table.
Click the Rotate Table button in the Report
Toolbar.
7
Cross-tabs
  • A cross-tab looks like a spreadsheet with data in
    cells.

Table Block
Cross-tab Block
8
Creating Cross-tabs
  • Three ways to create a cross-tab
  • Turn existing table into a cross-tab
  • From scratch, using the Cross-tab Wizard
  • In Slice and Dice (Mod 6)

9
Creating a Cross-tab from a Table
Select the column of data you want to move.
Drag and drop the data to the top right corner.
You will see this mark if you are doing it
correctly ...
Tip If it does not work, dont worry - just
click the Undo button and try again.
10
Cross-tab using the Wizard
1. Click the Insert Cross-tab button in the
Report Toolbar.
4. Select the variables you wish to use and
click Next.
3. Youre asked if you want to use the data in
the current document. Click Begin.
11
Cross-tab using the Wizard
5. Here you can move or Pivot the data from
one class to another if you chose. When ready,
click Finish.
12
Charts
  • BOA has the following types of charts

(Covered in Advanced Class)
  • Area
  • Column
  • Line
  • Pie
  • XY (Scatter)
  • 3-D Area
  • 3-D Column
  • 3-D Line
  • 3-D Pie

13
EXERCISE TIME
Write a Comment
User Comments (0)
About PowerShow.com