Basic ICT tutorials (Information Communication Technology)

34. The COUNTIFS Function

11. Editing a Table | Borders | Spacing | Merging cells | Making text bold and italic

6. Editing Bullets| Applying All master slide elements

34. The COUNTIFS Function

(3) Drawing relationships in an ERD (Conceptual)

4. Applying appropriate fade in and fade out effects

(2) IF Statement

Static and Dynamic queries

(5) Take a still image of the last frame of a video clip

(2) Removing sound from a video clip and trimming a video clip

2. Importing files into Access | Changing field names | Making relationships

(1) Merging Files and Importing

2. Inserting Merge Fields

(1) Pseudocode (Commands and assignments)

Q4. Making a Report

(9) Continuing storyboard (Part 2)

(8) Importing audio

(4) Exporting a video file as a .mp4 file

13. Noise Reduction

(7) Making a video according to a storyboard (Part 1)

Example - 3NF (Part 1)

(4) The CASE Statement

Example - 3NF (Part 2)

(3) IF ELSE

(1) Reading the question

(6) Splitting video clips

(3) Change the speed of a video clip

10. Copying data as a table | Sorting data in a table | Applying styles to a table

9. Making Bookmarks (Anchors)

2. Subtracting cells (Excel)

Expert Systems - Lesson 1

12. Setting the name for a default target window

(b) Changing field names and forming relationships

20. Data Validation (Validation rules)

(1) ERD: Conceptual vs Logical vs Physical

10. How to edit images in Microsoft Office Picture Manager

5. Exporting a file as mp3

(2) Making files in 3NF

10. Radio buttons in forms

19b. Conditional Formatting (Part2)

(1) Importing a file and changing the aspect ratio of a video clip

14. High and Low Pass Filters

(c) Validation Rules

12. Converting from Stereo to Mono

7. Pan and zoom effects

15. Applying an Echo