Intermediate Courses
Microsoft Access Essentials
There are five units in this Microsoft Access Basic and Intermediate level.
In Microsoft Access Essentials workshop, you will learn how to structure and construct a database design. You will also learn the elements that make up the Access environment and set up options applicable to the database. We will create a new database and learn about the different objects
- Plan and design a database
- Work with different Tables data types
- Define the primary key, join type, and referential integrity
- Construct Queries to analyse data.
- Build Forms and Reports
Course Code: MSO-PPT-IA
Duration : Two Full Day
Time : 9:00 am to 5:00 pm
Special rates will be given to a group of above 5 participants.
Venue: Virtual Learning / In-House
Training Schedule:
Please contact us for the course fee and schedule.
Please click the link below to register.
Interested participants from the respective Ministries, HRMS agencies or ACE, please register with your Training Coordinator the Course Code, Course Title, Course Date and the Training Provider.
Microsoft Excel Intermediate
There are four units in this Microsoft Excel Intermediate level.
1.1. Relative, Absolute and Mixed Referencing.
1.2. Create, Manage and Apply Names
1.3. Logical Functions
1.4. Lookup Functions
1.5. Mathematical Functions
1.6. Text Functions
2.1. Creating and Manage Links
2.2. Using 3D Formulas
2.3. Using Data Consolidation
3.1. Apply Conditional Formatting
3.2. Manage Conditional Formatting Rules
3.3. Use Recommended Charts
3.4. Add Chart Elements
3.5. Apply Chart Styles and Chart Filters
3.6. Calculate Totals Automatically
3.7. Convert Data Range to Table
3.8. Use Table Formula
3.9. Work with Total Row
3.10. Convert Table to Range
4.1. Create a Pivot Table
4.2. Refresh Pivot Table
4.3. Format and Filter the Pivot Table
4.4. Customise Pivot Table
4.5 Change the Summary Function
4.6 Working with Pivot Charts
At the end of the course, participants will be able to:
- quickly summarise data from various worksheets and workbooks.
- apply and manage conditional formatting to visually enhance data to analyse, detect critical issues, and identify patterns and trends.
- use functions such date, logical statistical and lookup functions.
- time-saving features such as Quick Analysis Tools to analyse your data quickly.
- create a Pivot Table for the reporting
Course Code: MSO-EXCEL-INT
Duration : Two Full Day
Time : 9:00 am to 5:00 pm
Special rates will be given to a group of above 5 participants.
Venue: Virtual Learning / In-House
Training Schedule:
Please contact us for the course fee and schedule.
Please click the link below to register.
Interested participants from the respective Ministries, HRMS agencies or ACE, please register with your Training Coordinator the Course Code, Course Title, Course Date and the Training Provider.
Microsoft PowerPoint Comprehensive
There are eight units in this Microsoft PowerPoint Comprehensive. It is an Intermediate and Advanced level.
1.1. Working with Different Layouts
1.2. Customise Background Graphics
1.3. Formatting Slides
1.4. Using Slide Sections
7.1. Merge slides and a word-processed outline into an existing presentation.
7.2. Save a specified slide as a jpeg or png file format.
7.3. Save a presentation as another file type like: rtf, video format.
7.4. Add, remove password protection for a presentation to open, to modify.
8.1 Using Comments
8.2. Comparing and Merging Presentations
8.3. Creating a Custom Slideshow
8.4. Creating a Self-Running Presentation.
8.5. Creating Control Buttons
8.6. Creating Slide Summary Zoom
8.7. Setting Slide Show
8.8. Presenting a Slideshow Online
8.9. Sharing your Presentation
This is an Intermediate and Advanced presentation workshop. At the end of the workshop, the learners will be able to:
- Work with Different Slides Layouts
- Use linking, embedding, importing and exporting features to integrate data.
- Apply advanced chart formatting features and create, edit and animate diagrams.
- Create SmartArt and work with drawing tools
- Apply Transitions and Animations.
- Create and modify templates and themes, and work with slide master and custom layouts.
- Insert audio and video, create audio and screen recordings, and apply built-in animation features.
- Use password protection to secure a presentation.
- Work with custom slide shows and apply slide show settings. Use presenter view and control a slide show.
Course Code: MSO-PPT-IA
Duration : Two Full Days
Time : 9:00 am to 5:00 pm
Special rates will be given to a group of above 5 participants.
Venue: Virtual Learning / In-House
Training Schedule:
Please contact us for the course fee and schedule.
Please click the link below to register.
Interested participants from the respective Ministries, HRMS agencies or ACE, please register with your Training Coordinator the Course Code, Course Title, Course Date and the Training Provider.