Computer Literacy Training

Basic Computer Components:

Operating a computer.
Main components: processor, RAM, hard disk.
Main peripherals: keyboard, mouse, screen, CD-ROM, DVD.
Connecting other devices: printers, scanners, smartphones, cameras …
Role of the operating system
Working with the Windows environment
Office, taskbar, windows.
Opening, closing a program, window reduction, full screen.
Juggling between applications.
Workstation organization & creation and organization of files
Creating, copying, moving, renaming, & deleting files.
Searching for a document.
Mastering the multimedia options & importing photos.
Watching a movie.

Outlook Email Training:

Principle of electronic mail.
Creating and sending a message.
Consulting inbox, replying to & forwarding emails
Attaching a file to a message.
Organizing the mailbox
Accessing and working with calendars
Work with and use contacts
Work with along with use tasks
Recalling emails
Requesting Read Receipts
Scheduling emails
Archiving emails

Microsoft Word Training:

Entering, modifying and correcting a text
Presentation and formatting of a document
Layout and printing of a document
Controlling type style and size
Managing lines to format documents into pages and to number pages
Using spell and grammar check, thesaurus,
Creating tables of contents.
Inserting visual aids like illustrations, diagrams etc.
Cross-references to pages or notes
Non-printing comments and annotations
Typing letters, notes, memos, circulars
Formatting layouts and designs for mailers/brochures/fliers/posters
Relating various page layout techniques
Saving a document as a PDF as well as view it in a PDF reader
Customizing mail merges
Inserting and working with text boxes

Creating with Smart Art
Using building blocks
Making and deleting bookmarks
Working with a table of contents in a document
Creating an index in a document
Utilizing interactive fields
Inserting as well as edit footnotes along with endnotes
Using a range of document proofing features
Creating and using master documents to manage complex documents
Understanding and utilizing the tracking features
Comparing multiple versions of the same document
Creating/removing several forms of defense for your document
Creating and working with electronic forms in the Microsoft Word
Creating and working with macros
Inserting content from other related sources
Minimizing, maximizing, moving and resizing windows.
Sharing data among Microsoft Office applications.

Microsoft Excel Training:

The Basics:

Integration of an Excel table in a Word document: principle of copy/paste.
Discover the use of a spreadsheet with Excel –
Construction of a basic table.
Creation of simple calculation formulas.
Formatting the table and recording his work.
Examining the Excel interface
Working with cell ranges—navigating and selecting cells with the mouse and keyboard
Entering and editing data, and employing AutoFill to enter data
Inserting and deleting rows and columns, and adjusting column width and row height
Manipulating data with cut, copy, paste, and the clipboard
Dragging and dropping data with the mouse without using the clipboard
Leveraging multiple worksheets

Formulas and Functions

Writing simple formulas
Exploring audit tools to examine and evaluate formulas
Referencing cells in formulas using relative and absolute references
Configuring cells for the number format and alignment
Constructing common functions with the aid of the function wizard and the formula tab
Implementing names in formulas and functions

Worksheet Formatting and Presentation

Setting up initial cell formatting
Drawing attention to data with formatting
Working with templates
Protecting cell ranges and worksheets
Analyzing data with conditional formatting

 Getting Data In and Out

Importing data into Excel from various sources: text, web, Microsoft Access, SQL
Fixing data with global replace and data tools
TEXT and DATE functions
Sorting, filtering, and summarizing data with auto filter and tables

EXCEL2

Creating Visual Presentation of Data

Leveraging charts to create a visual presentation
Creating charts using wizards
Adjusting chart settings, including titles, labels, and chart types
Setting up your workbook for printing
 

Introducing Advanced Features

Implementing dates
Summarizing data from other worksheets with 3-D formulas
Designing IF functions and conditional formatting
Analyzing summary data with Pivot tables and slicers

Microsoft PowerPoint Training:

PowerPoint :

Formatting pictures
Adding effects to a picture
Removing background from images
Inserting shapes
Using text boxes & WordArt
Aligning, ordering, and grouping objects
Animating text and objects
Inserting videos
Inserting audio
Inserting tables
Presenting your slideshow

Getting started with PowerPoint
Creating and opening presentations
Saving presentations
Working with slides
Slide basics
Text basics
Applying themes
Customizing layout of the slide and group slides
Applying transitions
Managing slides
Using Find & Replace
Printing slides

X