|
Microsoft Office
Nowadays, learning to have a good command of the Microsoft Office automation package is essential, since it is widely used on the market and has many advantages. This office automation suite is composed of a set of programs and a server allowing to have a lively management of information and an effective communication.
On the Web, there are courses offering global training on Office, whose purpose is that students acquire the necessary tools to have a good command of the different applications. In these courses, a summary of the contents belonging to each program and browser is taught: Microsoft Word, Microsoft Excel, Microsoft Access, Microsoft PowerPoint, Microsoft Outlook and Microsoft Internet Explorer. This kind of training is targeted at people without previous computing knowledge. Once a training of this type is completed, the users will be able to:
 Word
conduct basic operations of this word processor
create text, edit and format them (fonts, paragraph, bullets, etc.)
use grammar and spelling checker
manage documents
create text based on templates
create tables
draw up graphics
create Web pages from Word
include hyperlinks
print documents
Excel
have a good command of the concepts of spreadsheet, tables, workbooks, cells, rows, columns and ranges
be familiar with and change the spreadsheet formats
make basic operations to use the spreadsheets
edit content of cells, rows and columns (copy, cut, paste)
open and save workbooks
use formulas and functions (mathematical, statistical, dating, searching, etc.)
preview and print spreadsheets
create graphics
make backups
use tools to draw up budgets and forecasts
Access
have a good command of the concept of database and the way it works
design a database
organize and use tables of a database
conduct basic operations to use a database
edit and format tables
be familiar with the different types of data
import and export objects
make basic and advanced queries
create forms and subforms
make reports
print reports
use data security features
PowerPoint
create original and template presentations
use slides
insert text and images on the slides
show slides using different effects
import and export text from Word
edit text
draw up graphics and insert them
create text and image animations
add movies
print presentations
Outlook
be familiar with basic Outlook operation
use e-mail through Outlook
open e-mail accounts
write e-mails and format them
read, send, forward, reply, mark and delete e-mails
attach files to an e-mail
organize the inbox
filter e-mails
set contact list as address book
use the calendar (create, change and delete appointments)
use Outlook journal
create, open, send and delete notes
schedule regular tasks
Internet Explorer
be familiar with this browser
configure basic connections
browse the web
search information effectively through advanced search
print a Web page
use an Internet address (URL)
download files from the web
return to a lost page
delimit security regions and permits
carry out e-commerce operations
protect personal data
These are the main contents of the Microsoft Office software package. Online courses offering training on this package last more, due to the amount of contents included. The training average duration is from 5 to 6 months (between 60 and 70 hours, attending 3 hours per week). The educational material used includes enough exercises to allow the student to practise all contents. Usually, once each subject unit is completed, a small test is taken and once the whole course is completed, there is a final exam. On that exam, main operations with Word, Excel, Access, PowerPoint, Outlook and Internet Explorer are tested through practical activities. Besides, there are theoretical questions about main concepts. Passing the exam implies getting the certificate that proves the knowledge acquired on this office automation package.
Courses with tutoring are recommended, specially for the Office training, since the operation of different programs is complex. Tutors are in charge of answering all the questions the students may have on the office automation suite. There are also courses without tutoring, which are usually more affordable. The cost of the training with tutors is higher than in the previous cases, but only because it implies more credit hours and contents. There are also free Office course on the Web, although they are usually introductory.
|
