Navigate in Microsoft Word, Create and Save Word Documents, Manage Your Workspace, Edit Documents, Preview and Print Documents, Customize the Word Environment, creating new blank documents, creating new documents using templates, importing files, opening non-native files directly in Word, opening a PDF in Word for editing

searching for text within document, inserting hyperlinks, creating bookmarks, using Go To, using navigation keys and shortcut keys

Typing the text, Alignment of text, Editing Text: Cut, Copy, Paste, Select All, Clear, Find & Replace, Office Clipboard, document map

modifying page setup, changing document themes, changing document style sets, inserting simple headers and footers, inserting watermarks, inserting page numbers

changing document views, using zoom, customizing the quick access toolbar, customizing the ribbon, splitting the window, adding values to document properties, using show/hide, recording simple macros, assigning shortcut keys, managing macro security

Insert Shapes and Clipart, inserting images, applying artistic effects, applying picture effects, modifying image properties (color, size, shape), adding uick styles to images, wrapping text around images, positioning images Word Art, Smart Art, modifying SmartArt properties (color, size, shape), wrapping text around shapes, positioning shapes, Columns and Orderings - To Add Columns to a Document, Change the Order of Objects, Page Number, Date & Time, Inserting Text boxes, Inserting symbols & Equation, Ins

appending text to documents, finding and replacing text, copying and pasting text, inserting text via AutoCorrect, removing blank paragraphs, inserting built-in fields, inserting special characters,

changing font attributes, using find and replace to format text, using format painter, setting paragraph spacing, setting line spacing, clearing existing formatting, setting indentation, highlighting text selections, adding styles to text, changing text to WordArt, modifying existing style attributes

preventing paragraph orphans, inserting breaks to create sections, creating multiple columns within sections, adding titles to sections, forcing page breaks

Bullets and Numbering, Sort a List, Format a List, Page border, Page Background

Page setup, Dropcap, Document map, Watermark, Cover page, Blank page & Page break, Track changes, Compare & combine a document, Protect Document

Insert a Table, Modify a Table, Table AutoFormat, converting text to tables, converting tables to text, defining table dimensions, setting, AutoFit options, using quick tables, establishing titles, applying styles to tables, modifying fonts within tables, sorting table data, configuring cell margins, using formulas, modifying table dimensions, merging cells, Alignment option, Merge and split option, Control Cell Layout, Create a Chart, Add an Excel Table to a Word Document (Optional)

Create and Modify Text Styles, Create Custom List or Table Styles, Apply Document Themes

Inserting custom Header and Footer, Inserting objects in the header and footer, Add section break to a document

inserting endnotes, managing footnote locations, configuring endnote formats, modifying footnote numbering, inserting citation placeholders, inserting citations, inserting bibliography, changing citation styles

inserting endnotes, managing footnote locations, configuring endnote formats, modifying footnote numbering, inserting citation placeholders, inserting citations, inserting bibliography, changing citation styles

The Mail Merge Feature, Merge Envelopes and Labels

Create a Document Using a Template, Create a Template, Manage Templates with the Template Organizer

Check Spelling As You Type, Mark Grammar Errors, AutoCorrect Options, macros, Research and thesaurus, Translate, Word count

Page Setup, Setting margins, Print Preview, Print

Introduction to Excel interface, Understanding rows and columns, Naming Cells, Working with excel workbook and sheets

Create a workbook, Import data from a delimited text file, Add a worksheet to an existing workbook, Copy and move a worksheet

Search for data within a workbook, Navigate to a named cell, range, or workbook element, Insert and remove hyperlinks

Change worksheet tab color, Rename a worksheet, Change worksheet order, Insert and delete columns or rows, Change workbook themes, Adjust row height and column width, Insert headers and footers

Hide or unhide worksheets, Hide or unhide columns and rows, Customize the Quick Access toolbar, Modify document properties, Display formulas

Inspect a workbook for hidden properties or personal information, Inspect a workbook for accessibility issues, Inspect a workbook for compatibility issues

Create custom number formats, Populate cells by using advanced Fill Series options, Configure data validation

Create custom conditional formatting rules, Create conditional formatting rules that use formulas, Manage conditional formatting rules

Create and modify simple macros, Insert and configure form controls

Create an Excel table from a cell range, Convert a table to a cell range, Add or remove table rows and columns

Apply styles to tables, Configure table style options, Insert total rows

Filter records, Sort data by multiple columns, Change sort order, Remove duplicate records

Insert references, Perform calculations by using the SUM function, Perform calculations by using MIN and MAX functions Perform calculations by using the COUNT function, Perform calculations by using the AVERAGE function

Perform logical operations by using the IF function, Perform logical operations by using the SUMIF function, Perform logical operations by using the AVERAGEIF function, Perform statistical operations by using the COUNTIF function

Format text by using RIGHT, LEFT, and MID functions, Format text by using UPPER, LOWER, and PROPER functions, Format text by using the CONCATENATE function

Create a new chart, Add additional data series, Switch between rows and columns in source data, Analyze data by using Quick Analysis

Resize charts, Add and modify chart elements, Apply chart layouts and styles, Move charts to a chart sheet

Insert text boxes and shapes, Insert images, Modify object properties, Add alternative text to objects for accessibility

Save a workbook as a template, Enable macros in a workbook, Display hidden ribbon tabs

Protect a worksheet, Configure formula calculation options, Protect workbook structure, Manage workbook versions, Encrypt a workbook with a password

Create custom number formats, Populate cells by using advanced Fill Series options, Configure data validation

Create custom conditional formatting rules, Create conditional formatting rules that use formulas, Manage conditional formatting rules

Create custom color formats, Create and modify cell styles, Create and modify custom themes, Create and modify simple macros, Insert and configure form controls

Display data in multiple international formats, Apply international currency formats, Manage multiple options for +Body and +Heading fonts

Perform logical operations by using AND, OR, and NOT functions, Perform logical operations by using nested functions, Perform statistical operations by using SUMIFS, AVERAGEIFS, and COUNTIFS functions

Look up data by using the VLOOKUP function, Look up data by using the HLOOKUP function

Reference the date and time by using the NOW and TODAY functions, Serialize numbers by using date and time functions

Import, transform, combine, display, and connect to data, Consolidate data, Perform what-if analysis by using Goal Seek and Scenario Manager, Calculate data by using financial functions

Trace precedence and dependence, Monitor cells and formulas by using the Watch Window

Name cells, Name data ranges, Name tables, Manage named ranges and objects

Create PivotTables, Modify field selections and options, Create slicers, Group PivotTable data, Add calculated fields, Format data

Create PivotCharts, Manipulate options in existing PivotCharts, Apply styles to PivotCharts, Drill down into PivotChart details

create blank presentations, create presentations using templates, import text files into presentations, import Word document outlines into presentations, (New, Open, Close, Save, Save As, Typing the text, Alignment of text, Formatting Text: Font Size, Font Style, Font Color, Use the Bold, Italic, and Underline, Cut, Copy, Paste, Select All, Clear text)

Inserting new slide, Changing layout of slides, Duplicating slides, hide slides, delete slides, modify slide backgrounds, apply styles to slides, Copying and pasting slide, Applying themes to the slide layout, Changing theme color, Slide background, Formatting slide background, Using slide views

modify shape backgrounds, apply borders to shapes, resize shapes, insert shapes, create custom shapes, apply styles to shapes

change text to WordArt, create multiple columns in a single shape, insert hyperlinks, apply formatting and styles to text, create bulleted and numbered lists

create new tables, modify number of rows and columns, apply table styles, import tables from external sources

create and modify chart styles, insert charts, modify chart type, add legends to charts, modify chart parameters, import charts from external sources

add shapes to SmartArt, change color of SmartArt, move text within SmartArt shapes, reverse direction, convert lists to SmartArt

resize images, crop images, apply effects, apply styles

adjust media window size, trim timing on media clips, set start/stop times, set media, options, link to external media

insert section headers, modify slide order, align and group shapes, display gridlines

Inserting Hyperlinks and Action Buttons, Edit Hyperlinks and Action Button

insert transitions between slides, manage multiple transitions, modify transition effect options

apply animations to shapes, apply animations to text strings, add paths to animations, modify animation options, modify duration of effects, configure start and finish options, reorder animations, use the Animation pane

apply a slide master, add new layouts, modify existing layouts, add background images, control page numbers, insert headers and footers, modify presentation themes

change page setup options, change to view in color/grayscale, use views to navigate through presentations, modify presentation properties

Start slide show, Start show from the current slide, Rehearse timing, Creating custom slide show, configure slideshow options, use Presenter View, navigate within slideshows, annotate slideshows, Save as JPEG files, Solar system

merge multiple presentations, reuse slides from other presentations, view multiple presentations

set track changes, modify options for track changes, discard changes from specific users, manage comments

encrypt presentations with a password, proof presentations, mark as final, compress media, embed fonts, restrict permissions, remove presentation metadata, check for accessibility issues, check for compatibility issues