Length: 1 day
Prerequisites: Knowledge of SKYLINE’s Property Management, GL and AP modules; how to build financial statements; comfortable with spreadsheet processes such as formatting, formulas, working with cell references and creating a Macro.
Course Description and Objectives: The CUMULUS Report Writer works as an add-on to Excel, allowing you to directly access your SKYLINE data and create real-time reports that take advantage of the capabilities and flexibility of a spreadsheet. This course will teach you how to access your SKYLINE data and design “smart” financial statements with Excel or Lotus for Windows. You will build on your spreadsheet and SKYLINE knowledge and combine these two concepts to create financial reports. Course covers initial set-up of Cumulus; Cumulus tools such as Chart, Text Substitution Operator, Zero Suppression, Properties, Drill, OD Commands and Budget Write Back; spreadsheet techniques of functions, cell referencing, named ranges, string concatenation, if-then logic and choose & index.
To request more information, contact us today.