OFFICE SUITE
Microsoft Office is Microsoft's office suite for Windows and Mac computers. Widely used in the business world, it has become an essential tool for word processing, presentations, and more.
Are you interested in learning how to use Word, Excel, or PowerPoint, and do you feel you need some guidance to reach your goals? Then don’t wait any longer—join us!
CONTACT US FOR PRICING AND TERMS
Introduction to Word
Prerequisites
Proficiency with basic Windows tools (launching and locating a program; opening, closing, and moving a file or window).
Duration of training
The program is available year-round in an in-person format. Training durations are determined on an individual basis and included in the individual training plan provided by ADEP, which is then approved by the partner organizations and the learner.
On average, 3.5 hours per week are allocated per trainee for in-person training. An additional 3 hours are required for the end-of-session review.
Discovery
Objective
Be able to type and format a letter using basic formatting.
Contents
- Exploring appropriate vocabulary
- Typing Rules
- Entering and editing text
- Character formatting
- Paragraph formatting
- Search and replace text
- Layout
- Spelling and automatic correction
- File Management
Tables, Tabs, Columns
Objective
Be able to present data in the form of lists or tables and perform simple calculations on that data.
Contents
- Different types of tabs
- Setting tab stops
- Using cleats
- Using ruler tools
- Creating simple and complex tables
- Inserting rows and columns
- Borders and frames
- Simple calculation formulas
- Cell fusion, cell division, cell sorting
- Journalistic column writing
Graphical aspects
Objective
Be able to create or insert images or logos into a Word document.
Contents
- Inserting images
- Using the library
- Image layout and formatting
- Image copyright
- Design
- Inserting frames and shapes
- Drawing options and automatic shapes
- Using WordArt or a similar program
- Using Paint or a similar program
- Importing drawings
- Logo Design
Excel for Beginners
Prerequisites
Proficiency with basic Windows tools (launching and locating a program; opening, closing, and moving a file or window).
Duration of training
The program is available year-round in an in-person format. The duration of training is determined on an individual basis and included in the individual training plan provided by ADEP, which is then approved by the partner organizations and the learner.
On average, 3.5 hours per week are scheduled for each in-person trainee. An additional 3 hours are required for the end-of-session review.
Discovery
Objective
Be able to enter and display data, format it, perform simple calculations, use functions, and manage Excel workbooks.
Contents
- Calculator
- Data entry
- Data sorting
- Cell formats
- Moving and copying cells
- Workbook Management
Using simple calculations and functions
Objective
Be able to enter simple formulas and functions into an Excel spreadsheet.
Contents
- Using functions (sum, average, min, max, etc.)
- Basic calculations, conditional functions, financial functions
- Using calculations and simple functions
Using complex calculations and functions
Objective
Be able to incorporate the Excel spreadsheet containing complex formulas and functions.
Contents
- Nested conditional functions
- Search functions
- Cell names
- Relative and absolute cell addressing, conditional formats, given conditions
Advanced Word
Prerequisites
Proficiency with basic Windows tools (launching and locating a program, opening, closing, and moving a file or window). Proficiency with the skills covered in the MS Word Introduction module.
Duration of training
The program is available year-round in an in-person format. The duration of training is determined on an individual basis and included in the individual training plan provided by ADEP, which is then approved by the partner organizations and the learner.
On average, 3.5 hours per week are scheduled for each in-person trainee. An additional 3 hours are required for the end-of-session review.
Long documents
Objective
Be able to create multi-page documents that include repetitive elements, page numbering, and page layout.
Contents
- Formatting Long Documents
- Formatting of long documents that have already been entered
- Page break
- Skip section
- Footnotes
- Page numbering
- Header and footer
- Table of Contents
- Styles and models
Direct Mail
Objective
Be able to send personalized letters to a large number of recipients on a list.
Contents
- Creation of the main document
- Preparing the database
- Merging documents
- Impression of the merger
- Adding records
- Added fields
- Sorting the database
- Using an existing database (from a word processor, spreadsheet, or database)
- Merge with queries
- Tags
Forms
Objective
Be able to create documents that include empty text fields, checkboxes, and drop-down lists, which will be filled in later by the document users.
Contents
- Creation of the supporting document
- Creating data entry forms
- Inserting fields
- Using checkboxes and drop-down lists
- Document printing
- Using templates
- Form Processing
Advanced Excel
Prerequisites
Proficiency with basic Windows tools (launching and locating a program, opening, closing, and moving a file or window). Proficiency with the skills covered in the Excel Basics module.
Duration of training
The program is available year-round in an in-person format. The duration of training is determined on an individual basis and included in the individual training plan provided by ADEP, which is then approved by the partner organizations and the learner.
On average, 3.5 hours per week are scheduled for each in-person trainee. An additional 3 hours are required for the end-of-session review.
Graphs
Objective
Be able to create charts (histograms, pie charts, etc.) from a data table to make the data easier to read and highlight key features of the table.
Contents
- Entering data into a table
- Selection of data to be presented
- Using the graphical wizard
- Configuring chart options
- Creating the chart
- Changing settings (scale, series, etc.)
- Graph format (colors, shapes, titles, etc.)
- Adding captions, text boxes, and data labels
- Adding data
Databases
Objective
Be able to create a simple database. Be able to sort and filter data based on specific criteria.
Contents
- Creating the data list
- Data modification
- Search for a record
- Data sorting
- Automatic filters
- Advanced filters
- Using criteria fields
- Simple and combined criteria
- Using extraction zones
- Using Database Functions
Pivot Tables
Objective
Be able to easily generate different reports from the same set of data.
Contents
- Creation of the dataset
- Using the wizard
- Pivot Tables
- Selecting and modifying fields
- Table formatting
- Masking
- Sorting and grouping elements
- Subtotals
- PivotTable functions
PowerPoint
Prerequisites
Proficiency with basic Windows tools (launching and locating a program; opening, closing, and moving a file or window).
Duration of training
The program is available year-round in an in-person format. The duration of training is determined on an individual basis and included in the individual training plan provided by ADEP, which is then approved by the partner organizations and the learner.
On average, 3.5 hours per week are scheduled for each in-person trainee. An additional 3 hours are required for the end-of-session review.
Objectives
Be able to present textual, graphical, and photographic information using visual aids and create a slideshow for use in a video presentation.
Contents
- Creating slides with text, charts, bar graphs, flowcharts, and more…
- Text formatting
- Using Styles
- Using images from the library
- Using templates
- Definitions of common masks
- Text animations
- Automatic text animations
- Graphic object animations
- Inserting action buttons
- Inserting hyperlinks
- Slide Management
- Timing Check
- Manual and timed sequences
- Transition effects (zoom, fade-in, etc.)
- Using the Viewer
- Interactive presentations
- Creating slideshows
- Case Studies
