Over 10 years we help companies reach their financial and branding goals. Engitech is a values-driven technology agency dedicated.



411 University St, Seattle, USA


+1 -800-456-478-23

About the Course

This training focuses on introducing advanced functions of MS Word, MS Excel, MS Power point and MS Project applications.

MS Word (2 Days)
Use ZoomDraw Shapes
Understand Word ViewsAdd a Text Box
Split a DocumentAdd a Table of Contents
Use the Navigation PaneManage Sources
Insert ClipArt, Pictures from Files, and Screen ShotsAdd Footnotes, Endnotes, and Citations
Move or Delete a PictureInsert a Bibliography
Use the Picture Tools TabCreate an Index
Remove a Picture’s BackgroundView Synonyms
Adding Artistic EffectsUse the Research Task Pane
Changing a Picture’s LayoutUse Translation ScreenTips
Use SmartArtSet Your Language
Work with TablesUse Comments
Use the Table Tools TabTrack and Review Changes
Apply a Style to a TableCompare Documents
Add a Cover PageMinimize the Ribbon
Add Word ArtCustomize the Quick Access Toolbar
Access Word Options 
MS PowerPoint (2 Days)
Insert a pictureRotate and flip objects
Insert screen shotsAlign and distribute objects
Insert clip artOrder objects
 Insert SmartArtGroup objects
Insert a text box and add textCheck spelling
Insert a Table and add textUse the Research Task pane
SmartArtUse Translation ScreenTips
Remove a picture’s backgroundSet the Language
Use the Picture Tools tabAdd Notes to Slides
Use the Text Box Tools tabCreate a Notes Master
Use the SmartArt Tools tabCreate a Handout Master
Use the Table Tools tabPrint Notes and Handouts
Format a text boxSwitch to the Slide Master View
Modify table rows and columnsUse the Slide Master tab
Format a tableCreate a Slide Master
Add a movieApply a Slide Master
Add a sound clipEdit a Slide Master
Create WordArtInsert slides from other presentations
Draw shapesCreate a custom show
Use the Drawing Tools tabRecord a presentation as a video
Use the Grid and GridlinesPackage your presentation for CD
Understand the PowerPoint Viewer 
MS Excel
 Insert SmartArtCreate a Pivot Chart from a Pivot Table
Add text to a diagramCreate a Pivot Chart from Data
Resize and move a diagramDisplay the Developer tab
Reset a diagramRecord and run macros
Understand the contextual tabsChange the security level
Add pictures from your computerCustomize and Change the Quick Access Toolbar
Add Clip ArtUse named ranges in formulas
Add text boxesUnderstand formula errors
Draw shapesTrace dependents and precedents in formulas
Trace precedent cellsUse the Trace Errors Commands
Trace dependents of a cellEvaluate formulas
Display formulas within the sheetUse Goal Seek
Work with commentsUse the Scenario Manager
Insert a chartUse a One Input Data Table
Use the Chart Tools tabUse a Two Input Data Table
Understand the parts of a chartTransposing Data from rows to columns
Change the chart styleUse the Text to Columns feature
Resize and move a chartCheck for duplicates
Insert a Pivot TableCreate data validation rules
Use the Pivot Table Tools tabConsolidate Data
Choose fields and group data in a Pivot TableGroup Data
Change Pivot Table data and refresh the viewAdd Subtotals
Apply a Style to a Pivot tableOutline Data view Grouped and Outlined Data
Use Real-life examples in a Pivot Table 
MS Project
Split the viewEntering task fixed costs
Sort, group, and filter tasksSchedule resource overtime
Use zoomIdentify and balance resource overallocation
Overlap, delay, or split tasksSave a baseline plan
Set task deadlines and constraintsUpdate project, actual task values, actual work and actual costs
Understand task typesView project statistics and costs
Assign a task calendarCheck duration variance, work variance, and cost variance
Understand task indicatorsIdentify slipped tasks
Assign a resource calendarSave an interim plan
Customize a resource calendarCustomize a basic or visual report
Apply predefined resource contoursCreate a custom report
Specify resource availabilitySort a report
Group resourcesInserting a subproject
Enter resource rates and overtime ratesConsolidate multiple projects
Specify pay rates for different datesView multiple project critical paths
Apply a different pay rate to an assignmentView consolidated project statistics
Use material resource consumption ratesCreate a resource pool