Microsoft Office 2003 – Word– Excel – Outlook – PowerPoint – Access

OBJECTIVES
At the end of the course, the participant will be able to navigate in Windows, create simple text documents using Word, perform basic operation in Excel, manage e-mails in Outlook, create simple presentations using PowerPoint, and create a basic database using Access. 

CLIENTELE

The public

PREREQUISITES

Basic knowledge of a computer 

DURATION

45 hours (6 days)  

 

COURSE SYLLABUS

1. Introduction to Windows

  • Windows Environment
  • Start menu
  • Contextual menus
  • exiting Windows
  • Dialog boxes
  • Selecting options using the keyboard
  • Change users
  • Applications
  • Organizing windows

2. Managing disks and files

  • Copy
  • Windows Explorer
  • Managing files
  • Moving files using the slide and move method
  • Perform quick tasks on files

 

3. File management

  • File management
  • Trash application
  • Look up

 

4. Desktop management

  • Software installation
  • Installing a Windows component
  • Personalizing Start menu
  • Desktop shortcuts
  • Personalizing the desktop
  • Hybernation

 

5. Elemental notions

  • Launching Word
  • Menus
  • Tool bars
  • Exiting Word
  • Quit, save and open a file
  • Entering data
  • Automatic corrector
  • Moving the cursor
  • Selecting text
  • Erase text
  • Undo and redo operations
  • Copy and move

 

6. Data entry

7. Display and print

  • Formats
  • Displaying a document
  • Organizing document windows
  • Print

 

8. Character formatting

  • Character formatting
  • Font
  • Attributes
  • Quick formatting
  • Symbols and special characters
  • Margins
  • Tabs
  • Bullets

 

9. Paragraphs

  • Formatting paragraphs
  • Alignment
  • Spacing between lines and paragraphs
  • Protect lines and paragraphs
  • Borders and backgrounds

 

10. Paging

  • Sections in a document
  • Vertical alignment
  • Borders
  • Headers and footers
  • Pagination

 

11. Excel

  • Launching Excel
  • Desktop
  • Exiting Excel
  • Cell content
  • Data entry
  • Managing sheets
  • Editing data
  • Undo and redo
  • Moving in an active sheet
  • Selecting cells
  • Automatic data entry
  • Copy and move

 

12. Formulas

  • Entering a formula
  • Finding cells linked to a formula
  • References
  • Automatic formulae
  • Insert and delete rows or columns

 

13. Data formatting

  • Tools
  • Fonts
  • Display
  • Alignment
  • Column width
  • Visualizing before printing
  • Printing
  • Page format
  • Margins and centering
  • Headers and footers

 

14. Page layout and printing

 

15. Statistics

  • Syntax of functions
  • Statistics

 

16. Charts

  • Charts
  • Modifying a chart
  • Options
  • Deleting a chart

 

17. Outlook

  • E-mail
  • Outlook

 

18. Manage e-mails

  • E-mails

 

19. PowerPoint

  • Launching PowerPoint
  • Exploring PowerPoint
  • Default display parameters
  • Exiting PowerPoint
  • Creating presentations
  • Close, save and open

 

20. Moving and display

  • Moving in a presentation
  • Displaying a presentation
  • View a presentation

 

21. Access

  • Launch Access
  • Create a database
  • Create file
  • Desktop
  • Database Window
  • Exit Access
  • Display date
  • Open a database
  • Create a data table
  • Data entry
  • List of choices

 

22. Modifying a database

  • Select data
  • Move cursor
  • Modify data
  • Language tools
  • Commands
  • Modifying the structure of a table
  • Sort data

 

23. Organizing a database

  • Fields

 

24. Data sheet

  • Format data sheet
  • Print
  • Page layout

 

25. Filters and relations

  • Filter
  • Main key
  • Relationship between tables

 

26. Selection request

  • Create selection request
  • Modify a request
  • Operators
  • Move text using the generic s
TOP