Blog Development Secrets

Develop and Publish Your Own Blog!

Σχεδιάστε και Ανεβάστε το δικό σας BLOG, εύκολα και γρηγορα
σεμιναριο

28,29,30,31 Ιουλίου 2009, Λευκωσια

Join the Excel basic Teleclass

You may visit the teleclass on Excel ECDL Basic level at excel teleclass

for info send us an email info@paschalisconsulting.com

Internet and email

Internet email Syllabus

• The Internet
  • Concepts/Terms
  • Security Considerations
  • First Steps with the Web Browser
  • Adjust Settings


• Web Navigation
  • Accessing Web Pages
  • Using Bookmarks
  • Organizing Bookmarks


• Web Searching
  • Using a Search Engine
  • Preparation
  • Printing


• Electronic Email
  • Concepts/Terms
  • Security Considerations
  • First Steps with E-mail
  • Adjust Settings


• Messaging
  • Read a Message
  • Reply to a Message
  • Send a Message
  • Duplicate, Move, Delete


• Mail Management Techniques
  • Using Address Books
  • Organising Messages
  • Prepare to Print

Outlook Avanced

Syllabus includes:

Customising Outlook The Outlook environment The Outlook bar Using the Reading Pane Customising View Settings Messages Searching and filtering messages Creating Search Folders Customizing messages The Inbox Organizing the Inbox The rules wizard Managing your mailbox Alternate email methods Folders The notes folder The journal folder The calendar folder The contacts folder

Templates and forms Stationery and templates Forms Integration Changing the mail format Importing and exporting data Creating Office documents Using Folders to Share Information Working with public folders Working with Personal Folders Sharing your Outlook folders

Outlook Basic

Course Syllabus

Getting Started The program window The Help system E-mail E-mail accounts E-mail messages Handling messages Printing messages Address Books E-mail and Contact Management E-mail management Contact management The master category list Tasks Working with tasks Managing tasks

Appointments and Events Working with appointments Modifying appointments Working with events Meeting Requests and Responses Working with meeting requests Managing meeting requests Handling meeting responses Customizing Outlook Personal folders The organize panel Signatures Voting buttons Interacting with the internet

Powerpoint Intermediate/Advanced

Course Syllabus

Building Custom Presentations Modifying templates Building custom templates Building custom slide masters Advanced slide master techniques Using Multimedia in Presentations Advanced clip art and drawing techniques Adding movies and sound Using animations Using scanned images Using Organisation Charts and Tables Advanced organisation chart options Formatting and modifying tables

Advanced Presentation Techniques Adding special effects Working with slide show options Setting up review cycles Advanced Presentation Delivery Options Working with shared workspaces Working with the Pack and Go Wizard Advanced delivery techniques Customising the Environment Customising and creating toolbars Automating your work Microsoft Office Integration Working with Excel Working with Word

Powerpoint Basic

Course Syllabus

PowerPoint Basics Exploring the PowerPoint environment Help options Closing presentations and closing PowerPoint Building New Presentations Creating new presentations Saving presentations Working in the outline tab Rearranging and deleting slides Using slides from other presentations Formatting and Proofing Exploring text formatting Moving and copying text Setting tabs and alignment Using the spelling checker Examining AutoCorrect and the style checker Using Drawing Tools Drawing objects Using AutoShapes

Working with text in objects Enhancing objects Working with WordArt and Clip Art Working with WordArt Adding clip art Using Tables and Charts Working with tables Creating and enhancing charts Creating organization charts Enhancing Presentations Using templates Working with the slide master Working with multiple slide masters Adding transitions and timings Adding speaker notes and footers Delivering Presentations Running presentations Printing presentations Exporting to other formats Saving presentations for web delivery

Excel Advanced

Course Syllabus

Working with Advanced Formulas Using names Using decision-making functions Creating nested functions Using financial functions Lookups and Data Tables Working with lookup functions Creating data tables Advanced List Management Creating subtotals Validating cell entries Exploring database functions Working with PivotTables and PivotCharts Working with PivotTables Rearranging PivotTables Formatting PivotTables Working with PivotCharts Exporting and Importing

Exporting and importing text files Querying external databases Using Analytical Options Working with Goal Seek and Solver Working with scenarios Working with views Working with Macros Running and recording a macro Viewing VBA code Function procedures Interactive Web Pages Creating interactive Web spreadsheets Publishing PivotTables on the Web

Excel Intermediate

Course Syllabus

Working with Large Worksheets Viewing options Hiding and displaying data Printing large worksheets Working with Multiple Worksheets and Workbooks Using multiple worksheets Linking worksheets by using 3-D formulas Consolidating data Linking workbooks Managing workbooks Customising Excel Changing options Customising toolbars and menus Advanced Charting Chart formatting options Creating combination charts Using graphic elements Advanced Formatting Borders and shading Using special number formats Working with dates Working with styles Other advanced formatting

List Management Working with lists Sorting and filtering lists Advanced filtering Documenting and Auditing Comments and text boxes Auditing features Protection Workgroup collaboration Using Templates Built-in templates Creating and managing templates

Excel Basic

Course Syllabus

Getting Started Spreadsheet terminology Exploring the Excel window Getting help Opening and navigating workbooks Closing workbooks Entering and Editing data Creating workbooks Entering and editing labels and values Entering and editing formulas Saving and updating workbooks Modifying a Worksheet Moving and copying data Moving and copying formulas Using absolute references Inserting and deleting ranges

Using Functions Entering functions Using AutoSum Using AVERAGE, MIN, and MAX Formatting Worksheets Formatting text Formatting rows and columns Number formatting Using Format Painter and AutoFormat Printing Preparing to print Page Setup options Printing worksheets Creating Charts Chart basics Modifying charts Printing charts

Word Advanced

Course Syllabus

Using Mail Merge Creating form letters Working with data sources Creating mailing labels Working with Forms Creating forms Modifying forms Protecting and printing forms Working with Large Documents Master documents Footnotes and endnotes Indexes Bookmarks and cross-references

Managing Document Revision Using track changes Comparing document versions Creating Macros Recording and running macros Modifying and deleting macros Using macros in forms Creating custom menus Customising toolbars

Word Intermediate

Course Syllabus

Working with Sections and Columns Creating and formatting sections Working with multiple columns Working with text in columns Formatting Tables Table formatting basics Borders and shading Table AutoFormat Drawing tables Working with Excel Data Working with Excel data in word Creating Charts in Word Performing calculations in tables Working with Styles Defining and Applying styles Modifying and deleting styles Using Styles to create outlines Using AutoText and AutoFormat

Headers and Footers Different headers and footers Page numbering Printing Options Advanced Printing options Labels and envelopes Working with Graphics and Objects Working with graphics and clip art Inserting WordArt and symbols Applying watermarks Using drawing tools Document Templates Using templates Creating templates

Word Basic

Course Syllabus

Getting Started Exploring the Word window Creating and saving documents Printing Documents Getting Help Editing Documents Opening and navigating in documents Automated tasks Editing text The undo and redo commands Moving and Copying Text Selecting text Cutting, copying, and pasting text Finding and replacing text Formatting Characters and Paragraphs Character formatting Using tabs Paragraph formatting Advanced paragraph formatting

Creating and Managing Tables Creating tables Working with tables Modifying tables Controlling Page Layout Creating headers and footers Working with margins Working with page breaks Proofing and Printing Documents Checking spelling and grammar Previewing and printing documents Web Features Saving documents as web pages Working with hyperlinks Emailing documents

Access Intermediate

Course Syllabus

Creating relational databases Database normalising Introducing relating tables Adding referential integrity Working with related tables The lookup wizard Changing lookup fields Inputting data to related tables Defining data entry rules Using input masks Setting a property Setting a validation rule Using advanced query features How to join a table in queries Creating a calculated field Using an action query

Creating advanced queries Summarise and group values Create a crosstab query Using a parameter query Creating advanced form design Working with graphics Working with calculations Working with combo boxes Working with unbound controls Using advanced report features Create customized headers and footers Add a calculated value Work with sub-reports

Access Basic

Course Syllabus

Database Concepts Database concepts and terminology Exploring the Access environment Planning and designing databases Getting help Closing a database and Access Access Basics Exploring tables Examining queries Exploring reports Creating Databases Creating a database Using the table wizard Working in design view Working with Fields and Records Changing the design of a table Adding and deleting records Finding and editing records Sorting and filtering records Querying Tables Creating and using queries Modifying query results and queries Using calculations in queries

Creating and Using Forms Creating forms by using AutoForm Using the form wizard Using design view Finding, sorting and filtering records Creating and Using Reports Using the report wizard and queries Creating, modifying and printing reports Importing, Exporting and Linking Objects Importing Access objects Exporting Access objects Linking Access objects

Welcome to Information and Communication training

Follow here training on computer productivity for Office!