Working with Oros Models in Excel for the Public Sector

This course is not currently scheduled.

Duration: 1.0 day
Course fee:
EPTO units: .
CEUs: 0.6

This outline is provisional and subject to change.

This course teaches how to employ Microsoft Excel and Oros Connect to work with ABC model data.

Learn how to

create connections between ABM models and Excel worksheets
bring data into a worksheet from an Oros model using the Excel Function Wizard
send data back to the model from the worksheet
analyze Oros Links queries in Excel.

Who should attend

Business analysts who use Microsoft Excel and want to connect directly to Oros models for reporting and data analysis

Expand/Collapse All Expand All Collapse All Print version

Prerequisites

Before attending this course, you should have completed the ABC Modeling Using Oros 5.x course.

Course Contents

Connecting a Model to Microsoft Excel

connecting an ABC model to an Excel worksheet

Analyzing and Reporting Model Data Using Excel

exporting ABC data to Excel using function wizards
analyzing Oros Links queries in Excel

Sending Worksheet Data to the Model

updating resources costs in a model
reporting profitability and cost contributions
creating a profit cliff chart

Software

This course addresses SAS Activity-Based Management.

Course Materials

Students receive a hardcopy of the course notes and, in some courses, can choose to take home a copy of the course data.

Share Your Thoughts

Are there additional topics you'd like for this course to address? Would you like for this course to be offered at another training facility? Let us know by adding to our Interest List.

Course fee and EPTO units will differ for on-site training.

This page was created using SAS software.

-	Public
-	On-site training
-	One-to-one Mentoring
-	Courses by Industry Experts
-	Targeted Learning
-	ABM Training
-	TPS Service
-	Find a Course
-	Register now
-	Course list
-	Curriculum paths
-	Locations
-	Special Offers