Course Overview:
The syllabus for each of the advanced modules anticipates that the candidate has already mastered the Skills Sets and acquired the knowledge outlined in the core level syllabus. Advanced Word Processing: This module requires the candidate to produce advanced word processing outputs, illustrating sophisticated typographical, formatting and layout presentations, including tables, forms and graphics.
The candidate will be required to use tools like macros and advanced mail merge options within the word processing application.
Session 1 - Introduction Introduction to the course Discussion of needs
Session 2 - Basics Review Opening, saving, closing documents Printing documents Navigating through a document Formatting text Editing text
Session 3 - Paragraph Formatting Working with Indents & Margins Numbered Lists & Bulleted Lists Line Spacing
Session 4 - Tabs & Tables Creating Tabs Creating Tables Enhancing Tables Performing Calculations Creating Charts Importing Worksheets & data
Session 5 - Templates Using Templates Creating Forms Session 6 - Styles Applying Styles Creating & Editing Styles Redefining Styles Linking & Managing Styles
Session 7 - Merging Creating data Sources Completing main documents Creating Mailing Labels
Session 8 - Columns & Graphics Formatting text into columns Using Graphics WordArt
Session 9 - Document Layout Header & Footers Page Breaks Bookmarks, Footnotes Highlighting & Comments
Session 10 - Macros Creating, Editing & Testing Macros Assigning Macros to a toolbar
Advanced Spreadsheets: This module requires the candidate to edit and enhance numeric, text and graphical data, and to sort, query and link data. The candidate will be expected to use logical, statistical and mathematical functions. Ability to use analysis and audit tools is required, as is the ability to record and run macros. Session 1 - Introduction Introduction to the course Discussion of needs
Session 2 - Basics Review Creation of Spreadsheets Shortcuts and proper practice Using formulas
Session 3 - Moving & Copying Data Moving & Copying data Absolute References Fill Series Handle
Session 4 - Formatting Number Formats & Text Alignments Copying & Pasting Formats Special & Custom Formatting Conditional Formatting
Session 5 - Linking & Consolidating Data Linking Cells & Worksheets Goal Seek Scenarios Auditing Tools
Session 6 - Advanced Formulae Nested Functions If Functions Lookup Functions Customising toolbars Creating Templates
Session 7 - Charts & Graphics Creating charts Modifiying Charts Formatting Charts Using Graphic Objects
Session 8 - Database Features Sorting Data Filtering a list Custom Criteria
Session 9 - Pivot Tables Creating Pivot Tables Editing Pivot Tables
Session 10 - Macros Running a Macro Recording a Macro Assigning a Macro to a toolbar |
