My First Business ToolsThe course is designed to equip students with basic financial knowledge and information technology skills for business reporting and presentation using spreadsheet software. At the end of the course, students will be able to manage financial data through the creation of meaningful charts for analysis and presentation, as part of the in-course project.Related ITE Course: Higher Nitec in Business Information Systems
At the end of the module, students will be able to:Understand Basic Financial TermsManage Financial Records using Spread sheet Software
S/N Module Outline 1Manage financial records using spreadsheet software Describe the financial components that will affect the financial records.Prepare an electronic financial document. 2Create and summarise financial records using spreadsheet software Describe the use of formatting, formulas, functions, range names, charts and data filter to manage the financial records in spreadsheet.Create appropriate charts for display and range names for references and apply formula and functions in specified cells to automate calculation.Configure Security features to protect the data and use pivot table to filter and summarized the financial records.Link Spreadsheet data objects to Presentation software and export data to generate an electronic financial document.