Course Description:
The course qualifies the person to obtain the ICDL certificate which includes seven tests: the first is a theoretical assessment of the applicant's knowledge of the basic principles of computer and information technology. The other six tests are a process to evaluate the competence of the applicant in the use of the personal computer and the extent of his knowledge of applications and common computer programs.
Course Outlines:
- ICT, Hardware, Software, Operating Systems
- MS Win 7, File Management, Applications, Settings
- IT Security, Network Security, File Security
- Malware, Secure Web use & Communications
- Web Browsing, Network Concepts, Advanced Search
- MS Outlook use, Email, Calendar, Contacts, Tasks
- MS Word use, Create & Format Documents
- Insert Objects, Mail Merge, Outputs & Printing
- MS Excel use, create & manage Worksheets
- Cells, Formulas & Functions, Charts, Outputs
- MS PowerPoint use, create slides & Design
- Insert Objects, Transitions, Animations, Slide Show
- MS Access use, Database create & Relationships
- Create Tables, Queries, Forms, Reports, Data Export
- Teacher: Badruddin Al Noaimi
Course Description:
Microsoft Excel is the most commonly used spreadsheet application that allows users to:
- Quickly store, sort, and analyze large amounts of information
- Create graphs or charts to identify data trends easily
- Perform mathematical operations with ease
Course Outlines:
- Microsoft Excel - Basic
- Microsoft Excel - Expert
- Microsoft Excel - Advanced
- Sharing Data
- Protecting Workbook
- Sharing Workbook
- Organizing Information
- Formula Auditing
- Grouping & Outlining Data
- Data Analysis
- Conditional Formatting
- Data Validation
- Consolidation
- What if Analysis
- Programming Excel
- Automating tasks with Macro
- Power Query
- Power Pivot
- Power View
- Sharing Data
- Teacher: Badruddin Al Noaimi
- Teacher: Abdulazez Algenaimi
- Teacher: Ziad Mohammadieh
Course Description:
Microsoft Access is a database creation and management program that allows users to:
- Enter, manage and run reports on a larger scale
- Organize large amounts of data quickly
- Import and export to other Microsoft Office and other applications
- Ready templates for regular users to create and publish data
- Tables
- Building Tables
- Data Types
- Blocking Bad Data
- Linking Tables with Relationship
- Queries
- Select Query
- Crosstab Query
- Update Query
- Delete Query
- Append Query
- Make Table Query
- Forms
- Creating Simple Forms
- Designing Advanced Forms
- Building Navigation System
- Report
- Creating Reports
- Designing Advanced Reports
- Teacher: Badruddin Al Noaimi
- Teacher: Obada Homsi