City & Guilds Courses in Mauritius

• Start-up with MS Excel, Quick review on MS Excel Customize Ribbon, Quick Access Toolbar, Mini Toolbar.
• Introduction of Excel shortcut keys
• Introduction to Excel Worksheet, Row, Column, Cells etc.
• Use of Basic Operators Like: + – / * ^ %.
• Introduction to the Data and Data Formats.
• Copy, Cut, Paste, Hide, Unhide, Link the Data in Rows, Columns and Sheet.
• Inserting, Deleting, Moving, and linking the data in between the multiple sheets.
• Protection of Cells, Rows, Columns and Sheets.
• Printer Properties and Page Setup (Page, Margin, Header/Footer and Sheet) for Printing.

• Text Functions: Concatenate, Left, Mid, Right, Lower, Upper.
• Date and Time Functions: Date, Datevalue, Day.
• If, If with OR, If with AND, If with AND & OR, If with OR&AND.
• Nested If (For Multiple Conditions), If condition used more than one time in the same formula.
• Preparation of the TAX Calculation Sheet by Nested if
• Use of Name Manager: Creating, Editing, and Deleting of Names.

• Statistical Functions: Average, AverageA, Averageif, Averageifs, Count
• Use of Sumif, Sumifs, Count if, Countifs.
• Conditional formats, Data validation.

• Lookup Functions: Discussion on Lookup Functions, Use of Lookup, Vlookup, Hlookup, Index, Indirect Match, Offset. Choose.

• Use of Sorting to arrange the data in ascending and descending order. Addition and deletion of levels to sort the data on multiple parameters.
• Use of Filter to extract the unique and desired data.
• Import the data from the multiple applications to Excel.
• Remove Duplicates from Data.
• Use of Data Validation and Consolidation.
• What if Analysis. Analysis of Data by using Scenario Manager and Data Table and Goad Seek.
• Working With Charts: Detailed discussion on graphically presentation of Data by using Charts.

• Presentation with different kind to Basic charts like Column Charts, Line Charts, Pie Charts, Bar Charts, Scatter Charts
• Use of Sparkline to your Sheet, Interactive Sparklines

• Pivot Table, Do the Multiple Field Setting in Pivot Table.
• Start-up with Pivot charts.
• Insert slicer in Pivot Table and Pivot charts.

Lesson 1: Getting Started with PowerPoint
Topic A: Navigate the PowerPoint Environment
Topic B: View and Navigate a Presentation
Topic C: Create and Save a PowerPoint Presentation
Topic D: Use PowerPoint Help

Lesson 2: Developing a PowerPoint Presentation
Topic A: Select a Presentation Type
Topic B: Edit Text
Topic C: Build a Presentation

Lesson 3: Performing Advanced Text Editing Operations
Topic A: Format Characters
Topic B: Format Paragraphs
Topic C: Format Text Boxes

Lesson 4: Adding Graphical Elements to Your Presentation
Topic A: Insert Images
Topic B: Insert Shapes

Lesson 5: Modifying Objects in Your Presentation
Topic A: Edit Objects
Topic B: Format Objects
Topic C: Group Objects
Topic D: Arrange Objects
Topic E: Animate Objects

Lesson 6: Adding Tables to Your Presentation
Topic A: Create a Table
Topic B: Format a Table
Topic C: Insert a Table from Other Microsoft Office Applications

Lesson 7: Adding Charts to Your Presentation
Topic A: Create a Chart
Topic B: Format a Chart
Topic C: Insert a Chart from Microsoft Excel

Lesson 8: Preparing to Deliver Your Presentation
Topic A: Review Your Presentation
Topic B: Apply Transitions
Topic C: Print Your Presentation
Topic D: Deliver Your Presentation

Course Content

Lesson 1: Getting Started with Access
Topic A: Orientation to Microsoft Access
Topic B: Create a Simple Access Database
Topic C: Get Help and Configure Options in Microsoft Access

Lesson 2: Working with Table Data
Topic A: Modify Table Data
Topic B: Sort and Filter Records

Lesson 3: Querying a Database
Topic A: Create Basic Queries
Topic B: Sort and Filter Data in a Query
Topic C: Perform Calculations in a Query

Lesson 4: Using Forms
Topic A: Create Basic Access Forms
Topic B: Work with Data on Access Forms

Lesson 5: Generating Reports
Topic A: Create a Report
Topic B: Add Controls to a Report
Topic C: Enhance the Appearance of a Report
Topic D: Prepare a Report for Print
Topic E: Organize Report Information
Topic F: Format Reports

Lesson 6 Designing a Relational Database
Topic A: Relational Database Design
Topic B: Create a Table
Topic C: Create Table Relationships

Lesson 7: Sharing Data Across Applications
Topic A: Import Data into Access
Topic B: Export Data to Text File Formats
Topic C: Export Access Data to Excel

Course Objectives
In this course, you will create, format, edit, and share publications.
You will:
Perform basic tasks in the Microsoft Publisher interface.
Add content to a publication.
Format text and paragraphs in a publication.
Manage text in a publication.
Work with graphics in a publication.
Prepare a publication for printing and sharing.

Target Student
This course is intended for persons in a variety of job roles such as publishing specialists, layout specialists, graphic designers, or any other knowledge workers who need to use Microsoft Office Publisher to create, lay out, edit, and share publications.

Prerequisites
To ensure your success in this course, you should have experience with basic Microsoft® Windows® 10 tasks and be comfortable in the Windows 10 environment.

Course Content

Lesson 1: Getting Started with Microsoft Publisher
Topic A: Navigate the Interface
Topic B: Customize the Publisher Interface
Topic C: Create a Publication

Lesson 2: Adding Content to a Publication
Topic A: Add Text to a Publication
Topic B: Add Pages and Picture Placeholders to a Publication
Topic C: Control the Display of Content in Text Boxes
Topic D: Apply Building Blocks to a Publication

Lesson 3: Formatting Text and Paragraphs in a Publication
Topic A: Format Text
Topic B: Format Paragraphs
Topic C: Apply Schemes

Lesson 4: Managing Text in a Publication
Topic A: Edit Text in a Publication
Topic B: Work with Tables
Topic C: Insert Symbols and Special Characters

Lesson 5: Working with Graphics in a Publication
Topic A: Insert Graphics in a Publication
Topic B: Customize the Appearance of Pictures

Lesson 6: Preparing a Publication for Sharing and Printing
Topic A: Check the Design of a Publication
Topic B: Save a Publication in Different Formats
Topic C: Print a Publication
Topic D: Share a Publication

This is a COMPULSORY module to complete a DIPLOMA for IT USERS from City & Guilds. The main topics will be:

• Computer Components (hardware and software)
• Operating Systems functions and operations
• IT Security
• Productivity tools in Windows OS
• Productivity tools in Word
• Productivity tools in Excel

The other modules available for you to complete your DIPLOMA for IT USERS are as follows (The syllabus for each module is provided on separate web pages) :

1. IT Users Fundamentals
2. Setting Up IT Systems
3. Optimise IT System
4. Security for IT Users
5. Internet
6. Email
7. Communication Fundamentals
8. Graphics Design
9. Imaging
10. Desktop Publishing
11. Databases
12. Multimedia
13. IT Software Fundamentals
14. CAD 2D
15. CAD 3D
16. Web Design
17. Computerised Accounting
18. Payroll Software
19. Mobile Devices
20. Others