Advanced Information and Communication Technology
IT in Business - Advanced Spreadsheet
IT in Business - Advanced Spreadsheet
Couse contents includes:
- Forecasting using Goal Seek, Scenarios and Data tables
- Formula auditing, tracing precedents, tracing errors
- Data Validation
- Lookup Tables
- Importing different file types
- Linking objects in another application
- Functions, Financial, Date and Time, Forecast and Growth
Entry Requirements: IT in Business – HN Equivalent unit. Our tutors would be happy to discuss your suitability and help you make the right choice
Certification: SQA Higher National Unit
Duration: 12 weeks, 3 hours per week
Price: £86
IT in Business - Advanced Word
IT in Business - Advanced Word
Course content includes:
- Couse contents includes:
- Creating, modifying, and applying Style in documents
- Text Effects, WordArt, Drop Caps
- Themes
- Working with multiple columns
- Referencing, Table of Content, Indexing, End and Foot Notes
- Tables and Forms
- Mail Merge
- Macros
Entry Requirements: IT in Business – HN Equivalent unit. Our tutors would be happy to discuss your suitability and help you make the right choice
Certification: SQA Higher National Unit
Duration: 12 weeks, 3 hours per week
Price: £86
IT in Business - Advanced Database
IT in Business - Advanced Database
Couse contents includes:
- Analysing Databases
- Relationships
- Importing and linking databases
- Sub forms and Controls
- Calculations within a form
- Create a Switchboard
- Calculations within Queries
- Action Queries
Entry Requirements: IT in Business – HN Equivalent unit. Our tutors would be happy to discuss your suitability and help you make the right choice
Certification: SQA Higher National Unit
Duration: 12 weeks, 3 hours per week
Price: £86