MS Word  Advanced

Course content

Creating a Style Create and modify a style • Apply a style • Assign a style to a shortcut key

Creating a Template Create and modify a template • Attach a different template to a document • Load a global template • Modify the location of workgroup templates

Tables of Contents Create and modify a table of contents, table of authorities, and table of figures • Create and modify an index • Automatically summarise a document

References Bookmark selected text • Create cross-references • Create and revise footnotes and endnotes • Add captions to objects manually and automatically

Formatting an Outline List Create an outline numbered list • Promote and demote outline levels • Restart and continue numbering from another list

Managing Styles Create bulleted and numbered list styles • Create outline list styles • Create table styles • Manage styles using the Organizer • Switch styles using the Style Gallery • Apply and remove direct formatting • Reveal styles and check formatting

Object Linking and Embedding Link or embed an OLE object (Excel worksheet or chart) • Import Excel data as a Word table • Modify an OLE object • Update or unlink a linked data object • Create a chart from existing data (worksheet, table, delimited text) • Append text from another document • Convert existing text into a table • Build and edit an equation

Mail Merge Wizard Create a Main Document • Create and edit a Recipient List • Print a merged document • Merge to a new document • Use an alternate data source • Prepare and print mail merge envelopes and labels

WordArt Insert and format WordArt text

Modifying a Table Use a table for page layout • Specify table properties • Align and position a table • Merge and split cells and tables • Set cell margins and spacing • Align and orient cell contents

Desktop Publishing Use linked text boxes • Edit and format text boxes • Position and align text around objects • Create a watermark • Create and modify a page border • Print a book fold document • Scale documents to print on different paper or print multiple pages on a single sheet 

MS Excel  Advanced

Course content

Application Options and File Properties View and change application options • View and change workbook properties

Using Named Ranges Apply a name to a range of cells • Apply a name to a constant value • Modify and delete range names • Print a list of range names • Use a range names and labels in formulas • Define and modify a list range

Custom Number and Conditional Formatting Use formatting options with Paste Special • Create a custom number or date format • Use scientific and fractional number formats • Use conditional formatting

Linking Worksheets and Workbooks Create a formula to link worksheets and workbooks • Consolidate data using 3D references in common functions • Use Paste Special to link worksheets and workbooks • Use Paste Special to manipulate data • Manage and update linked workbooks

Consolidating Data Use Consolidate to summarise data in multiple lists

Summarizing a List Extract data using advanced filters • Group and subtotal data using the outlining tools • Use function to perform calculations on a data list

PivotTable and PivotChart Reports Create a PivotTable Report • Modify PivotTable field layout • Modify field settings and grouping intervals • Use PivotTable AutoFormat • Create a PivotChart Report

Lookup Functions Use VLOOKUP and HLOOKUP to get values from multi-column tables • Sort values in rows or from left-to-right • Use other lookup functions (LOOKUP, MATCH, INDEX, OFFSET) • Prevent lookup errors

Customizing a Chart Change the source data for a chart and modify data series • Explode segments of a pie chart • Insert an image into a chart • Add a text box to a chart • Store a custom chart as a chart template

Importing Text Data Import data from a text file

Inserting Spreadsheets and Charts Insert a worksheet from Microsoft Excel • Insert a chart from Microsoft Excel

Publishing to a Web Page Save a worksheet or chart as a web page • Use Web Page Preview

Working with Objects Select, position, and delete an object • Resize an object • Move or copy an object

Macros Record a new macro • Assign keyboard shortcuts • Create tool buttons • Use of personal macro workbook • Edit a macro • Delete a macro