Microsoft Word 2010, Advanced (12-hour course)

What You Will Learn:

1. use proofing tools: the Thesaurus, add words to Custom Dictionary; Automatic spell checking, Browse  Selector, find/replace text;
2. work with parts of a Table: borders/gridlines, end marks, cell spacing/margins;
3. create/edit Tables: insert/modify, enter text in a Table; add/delete Rows/Columns/Cells;
4. draw/format a Table: merge/split cells, change column/row width/height, work with Borders;
5. work with Tables/table Cells: change alignments/spaces of cells/margins; move/resize/break Tables;
6. use tables as Spreadsheets: do calculations/sort columns/lists; create/link/embed Excel Worksheets;
7. create/edit columns: insert/add breaks; create newsletter-style columns; format columns: headings, text boxes; flow/linked text boxes; short cuts

R1195

Microsoft Excel 2010, Introduction (12-hour course)

What You Will Learn:

1. use edit keys, select cells/blocks/ranges, open/close/save a spreadsheet;
2. draw outlines/lines, use copy/move commands, set column widths/row heights;
3. perform calculations, use formulas, format figures, use cell addresses;
4. freeze panes; insert/delete columns/rows, insert headers/footers
5. print a spreadsheet/titles, scaling in portrait/landscape,
6. working with and inserting graphs (line/bar/column/pie), and sorting a database.

R1195

Microsoft Excel 2010, Intermediate (12-hour course)

What You Will Learn:

1. use functions (mathematical/statistical/logical), use cell addresses (absolute/relative);
2. use look up/reference/worksheet tools; use worksheet tools;
3. link worksheets/workbooks, add comments;
4. use database functions/concepts/terminology; creating/using a database;
5. sort data, filtering/summarising information; using auto-filter; using form criteria;
6. use pivot tables; protecting files/worksheets/workbooks; using templates.

R1195

Microsoft Excel 2010, Advanced (12-hour course)

What You Will Learn:

1. sort data by levels, lookup references; show/hide, group/ungroup/create own data groups;
2. filter data, search using advanced filters;
3. review/share workbooks, tracking changes, working with comments, handling changes;
4. finalise/protect/unprotect workbooks, check spelling, use Document Inspector;
5. work with sparklines; work with charts; use conditional formatting; create pivot tables; use slicers;
6. transpose using “what if” analysis; use Goal Seek; merge shared workbooks, work with reference styles, record macros, function keys, and shortcuts.

R1195

Microsoft PowerPoint 2010, Introduction (12-hour course)

What You Will Learn:

1. use the basics; use the screen, navigating the screen;
2. save/close/open a document/slide;
3. work with slides, create a presentation, add/edit text;
4. select objects/text, add/delete slides;
5. format text, change text alignment, select a master;
6. use outline view, use proofing tools.

R1195

Microsoft PowerPoint 2010, Intermediate (12-hour course)

What You Will Learn:

1. work with/create/arrange/enhance objects, create organisation charts;
2. work with graphics, link/embed objects, create data charts, customise bullet charts;
3. put it all together: rearrange slides, print a presentation, create notes/hand-outs;
4. add special effects,
5. view slide show

R1195

Microsoft PowerPoint 2010, Advanced (12-hour course)

What You Will Learn:

1. insert a chart, change layout of style/chart and chart elements; work with Excel datasheets;
2. create a diagram: use/create SmartArt graphics; enter/delete Text/add Shapes; apply SmartArt styles;
3. create/modify an Organisation Chart; create simple drawing of Shapes, add Text to Shapes/Objects;
4. import/export data: insert/paste OLE objects; export Test/Slides to Word; edit/print PP handouts in Word; insert Slides from Other Presentations;
5. arrange/transform Objects; move Images/Objects; use Action Settings: add animation, set timing/order; add audio;
6. work with Master Slides: modify Master Slide; use Slide Master Tab; shortcuts and glossary.

R1195

Microsoft Outlook 2010 (12-hour course)

What You Will Learn:

1. use the basic sending/receiving of email (what is an email address); how to connect;
2. reply to an email, use the inbox/outbox, forward a message, how to use RE/CC/BCC fields;
3. create folders under the inbox, delete items, add a signature file;
4. manage your address book, send an email to multiple recipients;
5. add/delete an attachment;

R1195

Internet Basics 2010 (12-hour course)

What You Will Learn:

1. what the internet is, what an internet address is, useful terms;
2. how to start Internet Explorer, explore a website, create a favourite;
3. how to view your browsing history, how to use applications for communication (text/voice/video);
4. how to set your home page, work offline;
5. how to find information you want, print a web page, how to save a web page to your PC;

R1195

Introduction to Computers 2010 (12-hour course)

What You Will Learn:

1. what is a computer, work with data (files); basics of: hardware/software/media storage/viruses;
2. Introduction to Windows: working with computers/devices, the mouse, operating systems;
3. switching on/off, screen layout, launching a program/application, files/file names;
4. using/managing drives/folders/files, checking disk properties, viewing files, activate My Computer;
5. Introduction to MS Word, Excel, PowerPoint and the keyboard.

R1195