Training
At KT TEC, we provide specialized, hands-on training programs designed to equip professionals with the skills they need to effectively use Infor SunSystems, Microsoft Excel, and financial modelling tools. Whether you're new to a system or looking to deepen your expertise, our training courses offer real-world knowledge and practical application.
SunSystems Bootcamp Training
This intensive bootcamp is ideal for new users or companies rolling out SunSystems. It provides a broad foundation across three critical modules.
Topics:
- Ledger Accounting: General ledger setup, journal entries, period-end processing, and inquiries.
- Fixed Assets: Asset registration, depreciation, disposal, and reporting.
- Infor Q&A: Introduction to SunSystems data querying, basic reporting, and Excel integration.
Who Should Attend: Accountants, Finance staff, ERP support teams, New SunSystems users
SunSystems Ledger Training
A focused training on the financial ledger module in SunSystems.
Topics:
- Chart of accounts structure
- Journal entries and controls
- Financial periods and closures
- Transaction analysis and drill-downs
- Ledger inquiries and financial reporting
Who Should Attend: Finance professionals, Accountants, System administrators
SunSystems Fixed Asset Training
Gain a complete understanding of how to manage fixed assets in SunSystems.
Topics:
- Asset registration and categorization
- Depreciation methods and schedules
- Transfers, revaluations, and disposals
- Fixed asset reporting and audit trails
Who Should Attend: Asset accountants, Finance teams, Auditors
Infor Q&A Reporting
A practical course designed to teach users how to create reports in Infor Query & Analysis (Q&A).
Topics:
- Introduction to Q&A XL and Q&A Add-In
- Connecting to SunSystems data
- Building financial and operational reports in Excel
- Filtering, grouping, and formatting
Who Should Attend: Accountants, Finance analysts, Report developers
Infor Q&A Advanced Reporting
Take your Q&A reporting skills to the next level with advanced techniques and automation.
Topics:
- Complex formulas and multi-level grouping
- Linked worksheets and consolidated reports
- Drilldown views and dynamic analysis
- Report automation and template creation
- Integration with external data sources
Who Should Attend: Senior finance professionals, BI/reporting specialists, Auditors
SunSystems Report Designer
Master the built-in Report Designer tool within SunSystems for advanced and customized reporting.
Topics:
- Report structures and design principles
- Column and row definition techniques
- Formula-based reports and aggregations
- Output formatting and scheduling
- Real-world report development workshops
Who Should Attend: Financial controllers, SunSystems administrators, Report builders
SunSystems for Executives
A strategic course tailored for business leaders to understand and utilize SunSystems effectively in decision-making.
Topics:
- High-level system navigation and interpretation of reports
- Reviewing key financial KPIs and dashboards
- Executive dashboards with Q&A and Report Designer
- Insights on internal controls and audit trails
- Leveraging SunSystems data for business decisions
Who Should Attend: CEOs, CFOs, COOs, Senior management
Microsoft Excel for Accountants
This training equips finance professionals with essential Excel skills for accounting tasks.
Topics:
- Data organization and formatting best practices
- Lookup functions, pivot tables, and conditional formatting
- Financial functions (NPV, IRR, amortization)
- Error checking and formula auditing
- Template creation for reporting
Who Should Attend: Accountants, Finance officers, Auditors, Junior analysts
Microsoft Excel for Managers
A business-oriented Excel course focused on data analysis, presentation, and decision-making.
Topics:
- Dashboard creation with tables and charts
- Scenario analysis and data modeling
- Trend analysis and summary reports
- Collaboration and version control
- Business KPIs and metrics in Excel
Who Should Attend: Project managers, Department heads, Operational leaders
Microsoft Dashboard and Reporting
Learn to build interactive, presentation-ready dashboards for data-driven decision-making.
Topics:
- Advanced pivot tables and slicers
- Dashboard layout and visual design principles
- Conditional formatting and trend indicators
- Power Query basics for data transformation
- Integrating Excel dashboards with external data
Who Should Attend: Analysts, Business managers, BI professionals
Financial Modelling for CFOs
An intensive course for senior finance leaders to build and interpret strategic financial models.
Topics:
- Building robust integrated financial models (P&L, balance sheet, cash flow)
- Scenario and sensitivity analysis
- Investment appraisal and ROI modeling
- Valuation techniques and performance metrics
- Presentation-ready outputs for boards and investors
Who Should Attend: CFOs, Finance directors, Strategic planning teams, Senior analysts