Basic Computer Components:
♦ 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:
♦ 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:
♦ 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
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:
♦ 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