{"id":5767,"date":"2023-12-29T14:41:08","date_gmt":"2023-12-29T09:11:08","guid":{"rendered":"https:\/\/www.cognitel.com\/?page_id=5767"},"modified":"2023-12-29T14:47:14","modified_gmt":"2023-12-29T09:17:14","slug":"ms-office-advanced","status":"publish","type":"page","link":"https:\/\/www.cognitel.com\/ms-office-advanced\/","title":{"rendered":"MS Office Advanced"},"content":{"rendered":"\t\t
\n\t\t\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t
About the Course<\/span><\/h6>

This training focuses on introducing advanced functions of MS Word, MS Excel, MS Power point and MS Project applications.<\/span><\/p>

MS Word (2 Days)<\/strong><\/span><\/h6>
Use Zoom<\/span><\/td>Draw Shapes<\/span><\/td><\/tr>
Understand Word Views<\/span><\/td>Add a Text Box<\/span><\/td><\/tr>
Split a Document<\/span><\/td>Add a Table of Contents<\/span><\/td><\/tr>
Use the Navigation Pane<\/span><\/td>Manage Sources<\/span><\/td><\/tr>
Insert ClipArt, Pictures from Files, and Screen Shots<\/span><\/td>Add Footnotes, Endnotes, and Citations<\/span><\/td><\/tr>
Move or Delete a Picture<\/span><\/td>Insert a Bibliography<\/span><\/td><\/tr>
Use the Picture Tools Tab<\/span><\/td>Create an Index<\/span><\/td><\/tr>
Remove a Picture\u2019s Background<\/span><\/td>View Synonyms<\/span><\/td><\/tr>
Adding Artistic Effects<\/span><\/td>Use the Research Task Pane<\/span><\/td><\/tr>
Changing a Picture\u2019s Layout<\/span><\/td>Use Translation ScreenTips<\/span><\/td><\/tr>
Use SmartArt<\/span><\/td>Set Your Language<\/span><\/td><\/tr>
Work with Tables<\/span><\/td>Use Comments<\/span><\/td><\/tr>
Use the Table Tools Tab<\/span><\/td>Track and Review Changes<\/span><\/td><\/tr>
Apply a Style to a Table<\/span><\/td>Compare Documents<\/span><\/td><\/tr>
Add a Cover Page<\/span><\/td>Minimize the Ribbon<\/span><\/td><\/tr>
Add Word Art<\/span><\/td>Customize the Quick Access Toolbar<\/span><\/td><\/tr>
Access Word Options<\/span><\/td>\u00a0<\/td><\/tr><\/tbody><\/table>
MS PowerPoint (2 Days)<\/strong><\/h6>
Insert a picture<\/td>Rotate and flip objects<\/td><\/tr>
Insert screen shots<\/td>Align and distribute objects<\/td><\/tr>
Insert clip art<\/td>Order objects<\/td><\/tr>
\u00a0Insert SmartArt<\/td>Group objects<\/td><\/tr>
Insert a text box and add text<\/td>Check spelling<\/td><\/tr>
Insert a Table and add text<\/td>Use the Research Task pane<\/td><\/tr>
SmartArt<\/td>Use Translation ScreenTips<\/td><\/tr>
Remove a picture\u2019s background<\/td>Set the Language<\/td><\/tr>
Use the Picture Tools tab<\/td>Add Notes to Slides<\/td><\/tr>
Use the Text Box Tools tab<\/td>Create a Notes Master<\/td><\/tr>
Use the SmartArt Tools tab<\/td>Create a Handout Master<\/td><\/tr>
Use the Table Tools tab<\/td>Print Notes and Handouts<\/td><\/tr>
Format a text box<\/td>Switch to the Slide Master View<\/td><\/tr>
Modify table rows and columns<\/td>Use the Slide Master tab<\/td><\/tr>
Format a table<\/td>Create a Slide Master<\/td><\/tr>
Add a movie<\/td>Apply a Slide Master<\/td><\/tr>
Add a sound clip<\/td>Edit a Slide Master<\/td><\/tr>
Create WordArt<\/td>Insert slides from other presentations<\/td><\/tr>
Draw shapes<\/td>Create a custom show<\/td><\/tr>
Use the Drawing Tools tab<\/td>Record a presentation as a video<\/td><\/tr>
Use the Grid and Gridlines<\/td>Package your presentation for CD<\/td><\/tr>
Understand the PowerPoint Viewer<\/td>\u00a0<\/td><\/tr><\/tbody><\/table>
MS Excel<\/strong><\/h6>
\u00a0Insert SmartArt<\/td>Create a Pivot Chart from a Pivot Table<\/td><\/tr>
Add text to a diagram<\/td>Create a Pivot Chart from Data<\/td><\/tr>
Resize and move a diagram<\/td>Display the Developer tab<\/td><\/tr>
Reset a diagram<\/td>Record and run macros<\/td><\/tr>
Understand the contextual tabs<\/td>Change the security level<\/td><\/tr>
Add pictures from your computer<\/td>Customize and Change the Quick Access Toolbar<\/td><\/tr>
Add Clip Art<\/td>Use named ranges in formulas<\/td><\/tr>
Add text boxes<\/td>Understand formula errors<\/td><\/tr>
Draw shapes<\/td>Trace dependents and precedents in formulas<\/td><\/tr>
Trace precedent cells<\/td>Use the Trace Errors Commands<\/td><\/tr>
Trace dependents of a cell<\/td>Evaluate formulas<\/td><\/tr>
Display formulas within the sheet<\/td>Use Goal Seek<\/td><\/tr>
Work with comments<\/td>Use the Scenario Manager<\/td><\/tr>
Insert a chart<\/td>Use a One Input Data Table<\/td><\/tr>
Use the Chart Tools tab<\/td>Use a Two Input Data Table<\/td><\/tr>
Understand the parts of a chart<\/td>Transposing Data from rows to columns<\/td><\/tr>
Change the chart style<\/td>Use the Text to Columns feature<\/td><\/tr>
Resize and move a chart<\/td>Check for duplicates<\/td><\/tr>
Insert a Pivot Table<\/td>Create data validation rules<\/td><\/tr>
Use the Pivot Table Tools tab<\/td>Consolidate Data<\/td><\/tr>
Choose fields and group data in a Pivot Table<\/td>Group Data<\/td><\/tr>
Change Pivot Table data and refresh the view<\/td>Add Subtotals<\/td><\/tr>
Apply a Style to a Pivot table<\/td>Outline Data view Grouped and Outlined Data<\/td><\/tr>
Use Real-life examples in a Pivot Table<\/td>\u00a0<\/td><\/tr><\/tbody><\/table>
MS Project<\/strong><\/h6>
Split the view<\/td>Entering task fixed costs<\/td><\/tr>
Sort, group, and filter tasks<\/td>Schedule resource overtime<\/td><\/tr>
Use zoom<\/td>Identify and balance resource overallocation<\/td><\/tr>
Overlap, delay, or split tasks<\/td>Save a baseline plan<\/td><\/tr>
Set task deadlines and constraints<\/td>Update project, actual task values, actual work and actual costs<\/td><\/tr>
Understand task types<\/td>View project statistics and costs<\/td><\/tr>
Assign a task calendar<\/td>Check duration variance, work variance, and cost variance<\/td><\/tr>
Understand task indicators<\/td>Identify slipped tasks<\/td><\/tr>
Assign a resource calendar<\/td>Save an interim plan<\/td><\/tr>
Customize a resource calendar<\/td>Customize a basic or visual report<\/td><\/tr>
Apply predefined resource contours<\/td>Create a custom report<\/td><\/tr>
Specify resource availability<\/td>Sort a report<\/td><\/tr>
Group resources<\/td>Inserting a subproject<\/td><\/tr>
Enter resource rates and overtime rates<\/td>Consolidate multiple projects<\/td><\/tr>
Specify pay rates for different dates<\/td>View multiple project critical paths<\/td><\/tr>
Apply a different pay rate to an assignment<\/td>View consolidated project statistics<\/td><\/tr>
Use material resource consumption rates<\/td>Create a resource pool<\/td><\/tr><\/tbody><\/table>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"

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 Zoom Draw Shapes Understand Word Views Add a Text Box Split a Document Add a Table of Contents Use the Navigation Pane Manage Sources Insert ClipArt, Pictures from […]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"_links":{"self":[{"href":"https:\/\/www.cognitel.com\/wp-json\/wp\/v2\/pages\/5767"}],"collection":[{"href":"https:\/\/www.cognitel.com\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.cognitel.com\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.cognitel.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.cognitel.com\/wp-json\/wp\/v2\/comments?post=5767"}],"version-history":[{"count":10,"href":"https:\/\/www.cognitel.com\/wp-json\/wp\/v2\/pages\/5767\/revisions"}],"predecessor-version":[{"id":5777,"href":"https:\/\/www.cognitel.com\/wp-json\/wp\/v2\/pages\/5767\/revisions\/5777"}],"wp:attachment":[{"href":"https:\/\/www.cognitel.com\/wp-json\/wp\/v2\/media?parent=5767"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}