Tier- 3: e-skills180⁰ (Computer E-Business Savviness)

In today's digital age, business transformation must take place over months, not years; hence it is critical that we have not only sufficient number of computer professionals but also a pool of computer and e-business savvy workforce ready for this transformation in their respective sectors. As the workforce is part of the large community, individual upgrading at all levels also needs to take place simultaneously to provide the support for this change. The objective of Tier-3 E-Business Savviness Programme or e-skills180⁰ is to train a pool of skilled manpower with complete office skills to support the e-business industry. The programme aims to equip non-computer Professionals with PC skills to enhance company's competitiveness and the trainees will undergo training of intermediate and advanced levels of PowerPoint, Excel and Access (databases).

Pre-requisites:
e-skills90⁰

[This program is available in English only and can be distributed on CD's.]

Course content of e-skills180⁰ (Tier - 3)

e-skills180⁰ Consists of PowerPoint, Excel and Access.

MS-POWERPOINT

First Steps

• What can you do with PowerPoint?
• Terminology
• Starting PowerPoint
• Setting up a default folder
• The PowerPoint window
• Online Help
• The Research task pane
• Automatic Repair
• Office advanced clipboard
• The Office Assistant
• Changing the behaviour of the Office Assistant
• Understanding Views
• Your First Presentation
• Creating a new presentation
• The AutoContent Wizard
• Using a pre-defined Design Template
• Altering the design of a Template
• Creating your own Design Template
• Creating a photo album
• Opening an existing presentation
• Inserting a new slide

Adding objects to slides

• Before starting
• Working with text
• Adding pictures
• Adding WordArt Objects
• Recording a voice comment
• Recording narrative
• Inserting a CD audio track
• Adding a movie
• Adding charts
• Changing a chart
• Importing an Excel chart
• Automatic shapes
• Modifying shape settings
• Adding organisation charts
• Adding tables
• Embedding tables
• Using existing tables
• Importing Word text
• Adding clip art

Annotating and formatting slides

• Adding notes
• Adding comments
• Headers and footers
• Changing the slide background
• Slide background picture
• Changing the font
• Aligning objects
• Grouping objects
• Layering objects
• Page Setup
• Printing

Delivering presentations

• Delivering a presentation
• Using two monitors
• Using action buttons
• Web presentations
• Using handouts
• Sending slides to Word
• Embedding fonts in a presentation
• Packaging a presentation
• Custom Shows
• Saving a presentation as a slide show
• Continuous presentation
• Setting timings for a slide show

Advanced techniques

• Using transitions
• Animating text and objects
• Using animation schemes
• Add shadow to text
• Creating -D effects
• Changing the size of a picture
• Adding hyperlinks
• Adding Internet hyperlinks
• Correcting automatically while typing
• Using Style Checker
• Using Style Sorter
• Hiding Slides

Customisations

• Customising toolbars
• Creating a new toolbar
• Customising the menu bar
• Automating repetitive work with a macro

PowerPoint and Workgroups

• Sending a presentation for review
• Using the Reviewing toolbar
• Sending a presentation as an attachment
• Using passwords
• Digital signature
• Sending faxes with PowerPoint

MS-EXCEL

Getting a good start

• Starting Excel
• Setting up a default folder
• The Excel window
• Keyboard shortcuts
• The online help
• Pop Up menus
• Automatic repair
• Office advanced clipboard
• The Research task pane

File management

• Creating a new file
• Retrieving recently saved files
• Opening an existing file
• Saving a file
• Print preview
• Printing a file
• Adding a sheet in a workbook
• Hiding or displaying files
• Deleting a group of worksheets in a workbook
• Changing the order of worksheets in a workbook
• Sending faxes
• Creating E-mail messages

Selections and movements

• Moving within a worksheet
• Setting a data entry range
• Cutting / pasting the contents of a cell
• Copying / pasting the contents of a cell
• Transposing data
• Deleting data in a worksheet
• Moving cells
• Finding items in a worksheet
• Replacing text
• Copying one or more cells
• Custom lists

Working with worksheets

• Data entry
• Correcting as you type
• Formulas
• Viewing formulas
• Numeral data series and dates
• Naming a range of cells
• Using the function assistant
• Auto calculation
• Digital signature
• Track changes
• Comparing workbooks
• Automating repetitive work with a macro
• Assigning a keyboard shortcut to a macro
• The Web components of Excel

Formatting a worksheet

• Deleting rows and columns
• Inserting rows and columns
• Deleting cells
• Inserting one or more cells
• Setting row height
• Setting column width
• Formatting numbers
• Alignment
• Centring across more columns
• Formatting characters
• Using borders
• Using patterns
• Auto Formatting
• Copying a format
• Clearing a format
• Creating and using styles

Display and page set-up

• Protecting a file
• Protecting a worksheet
• Adding comments
• Customised displays
• Freezing panes
• Outline mode
• Displaying toolbars
• Setting up the page
• Changing the margins
• Headers and footers
• Setting the print area
• The Drawing toolbar
• Inserting a picture
• Changing the size of a picture
• Interfacing with a scanner

Databases

• Creating a database
• Adding records
• Searching for a record
• Modifying a record
• Deleting a record
• Sorting data
• Interrogating a database
• Customising a filter
• Cancelling a filter
• Setting a criteria range
• Using a criteria range
• Using a list

Data and graph processing

• Combining data
• Consolidating data
• Goal seek and solver
• The PivotTable wizard
• Creating a chart
• Changing a chart
• Printing a chart
• Inserting a diagram

MS-ACCESS

First contact with Access

• Starting Access
• The Access window
• The Database window
• Showing and positioning toolbars
• Customising toolbars
• Objects and toolbars
• Creating a new toolbar
• The Office Assistant
• Changing the behaviour of the Office Assistant
• Online help
• The right mouse button
• Creating a new database
• Opening an existing database
• Sending objects via e-mail

Creating a new table

• Working with tables
• Using the Table Wizard
• Creating a table manually
• Format property
• The Input Mask Wizard
• "Mister" as a default value
• Validation Rule property
• Tables relationships
• Defining a primary key

The Data mode

• Modifying the aspect of a table
• Moves in a table
• Finding text
• Replacing text
• Formatting the characters
• Rapid sorting
• Advanced sort
• Records filtering

Queries

• Working with queries
• Different types of queries
• Select queries
• Changing the name of a field
• Sorting order
• Simple Criteria
• Hiding fields in a datasheet
• Using wildcard characters in a criterion
• The Expression Builder
• AND and OR operators
• Calculated fields
• Number of records
• Grouping records
• Top Ten records
• Make-Table Queries
• Append queries
• Delete queries
• Update queries
• Parameter queries

Forms

• Working with Forms
• Creating a form by using AutoForm
• Rapid sorting of records
• Creating a form with a wizard
• Modifying a form
• Check boxes and options buttons
• Defining an option group
• Moving and aligning controls
• Moving in a form
• Tabulation order
• Sections of a form
• Defining a sub-form
• Calculated fields
• Calculated fields and sub-forms
• Adding pictures to a form
• Defining a chart with MSGraph
• Data access pages

Reports

• Working with reports
• Defining an instant report
• Data sorting
• Grouping in a report
• The Report Wizard
• Modifying a report
• Sections of a report
• Inserting a chart in a report
• Calculations in a report
• The Label Wizard
• Mailing and envelopes

Macros

• Defining your first macro
• Assigning a command button to a macro
• Assigning an access key to a macro
• Conditions in a macro
• Running a macro in response to an event
• The Autoexec macro
• Setting the value of a property