Illinois

Illinois


Illinois COMPdata ROLAP Webinar: #4 Calculations


Basic Query Worksheet Review with Adding Worksheet and Adding Calculations

What are Calculations?
Calculations are worksheet items based on formulas or expressions (mathematical formulas).

What is Percentage?
Percentages are worksheet items that enable you to quickly and easily calculate percentages of specific row and/or columns.

  • To access percentage click on conditions tab, right mouse on percentage.
  • Click on "New Percentage."
  • Complete New Percentage screen.

What is Total?

  • Totals are worksheet items that enable you to quickly and easily summarize rows and columns.
  • To access "Total" on conditions tab, right mouse on "Total."
  • Click on "New Total."
  • Complete New Total screen.

Benefits:

  • Each can provide additional analysis to worksheets.
  • Example to calculate increase of 10% (i.e., Sum *1.10)

Agenda - Learn how to:

  1. Use Existing Workbook
    1. Add new worksheet
    2. Add duplicate worksheet
    3. Move worksheet
    4. Delete worksheet and workbook
    5. Copy a workbook
  2. Add Calculation to Worksheet
    1. Calculations
    2. Percentage
    3. Totals
  3. Change Options Screen

Duration - 30 minutes

Participants must register no later than 24 hours prior to the Webinar training. Registered participants will receive the Webinar training details via e-mail the day before the Webinar. Webinars will open 5 minutes prior to the scheduled start time and will begin promptly on time.

Click on the date below to complete registration form.

Training Dates and Times:

  • No dates scheduled at this time.