Online

thumbnail_general11.png

thumbnail_general11mobile.png

Works 4 you

Microsoft Office Suite (Intermediate) – Online Course

Short course

- Create a professional word document
- Using key editing functions and keyboard shortcuts
- Formatting features including tables, graphics, and clip art
- Using Themes and Styles in your document
- Adding a table of contents to a document
- Using mail merge function, to prepare an email (also uses MS Excel)
- Adding a border to a page
- Adding a watermark


1. Using MS Word essentials to:

- Entering data into a spreadsheet
- Creating and using formulas such as sum, IF Function and arithmetic formulas.
- Use V-Look up tables
- Setting a Spreadsheet to use for mail merge
- Pivot Table
- Creating charts
- Understanding relative and absolute cell reference
- Using Auto-fill function


2. Using MS Excel essentials to:

- Creating a database to store, manage and enter data
- Filtering and sorting data
- Running queries
- Producing reports

3. Using MS Access essentials to:

- Send and receive emails
- Storing emails by creating and editing folders
- Inserting documents into emails
- Creating signatures
- Creating an email account
- Using calendar
- Using To-Do List


4. Using MS Outlook essentials to:

- Create a catchy animated slide presentation
- Adding Smart Art
- Inserting Shapes
- Inserting an image
- Slide Transitions
- Adding animations
- Using the Design Tab
- Printing slides
- Target Audience
