Training
|
F9 offers the F9 Fundamentals and F9 Advanced courses at the F9 Training Centre in Vancouver, BC, Canada, and through our F9 Authorized Training Centres.
The F9 Fundamentals course is also available via Remote Training sessions. To find out more
or to register, please call 1-800-663-8663 ext. 317.
The courses are outlined below.
|
| F9 Fundamentals
|
|
Prerequisites: This course assumes the participant has basic spreadsheet skills. The participant should be comfortable with cutting, copying and pasting. Understanding how to use formulas, cell references and assigning absolute and relative cell references is also important. Additionally participants should be familiar with basic accounting principles and have worked with at least one computer based accounting system.
Learning Objectives: Upon completion of this course, participants will know how to:
-
Install and configure F9
-
Utilize the online help documentation
-
Create and copy GL and NGL functions
-
Use BSPEC in order to enhance GL and NGL functions
-
Use the DESC, SDESC and CODATA functions
-
Build spreadsheets using the Lists facility
-
Use Report Wizard to create a wide variety of reports automatically
-
Use the Analyze and Drill functions to diagnose problems and to explore the source of various balances
-
Use the GLTRAN function to create reports on periods other than fiscal periods
-
Use Budget Write Back to create and maintain budgets and write them back to the accounting system
-
Create any financial report imaginable, including but not limited to: multi-period income statements, departmental income statements, cash flows, pro forma books, etc
|
|
F9 Advanced
|
|
Prerequisites: The participant must have taken the F9 Fundamentals course, or be able to prove you possess the skills described above. Exposure to macros and/or Visual Basic would be beneficial.
Learning Objectives: Upon completion of this course, participants will know how to:
-
Create and use Financial Entities
-
Use the WGL and WDESC functions to create and maintain budgets, forecasts and pro forma books
-
Use Artificial Segmentation in order to support user defined account segmentation
-
Utilize View Manager and Report Manager for production reporting
-
Be able to customize the spreadsheet including the creation of new toolbar buttons
-
Use Silent Running in macros and VB to create Executive Information Systems
-
Customize the spreadsheet and automate often repeated actions
-
Get more out of your spreadsheet than you had thought possible.
|
|
|
|
