Instructor Led Microsoft Training   

In this course, you will create, edit, and format documents.

You will:

• Get familiar with Word’s layout, its various parts, commands, and terminology.
• Format text and paragraphs.
• Perform repetitive operations efficiently using tools such as Find and Replace, Format Painter, and Styles.
• Enhance lists by sorting, renumbering, and customizing list styles.
• Create and format tables.
• Insert graphic objects into a document, including symbols, special characters, illustrations, pictures, and clip art.
• Format the overall appearance of a page through page borders and colors, watermarks, headers and footers, and page layout.
• Use Word features to help identify and correct problems with spelling, grammar, readability, and accessibility.

In this course, you will create and modify complex documents and use tools to customize those documents.

You will:

• Organize content using tables and charts.
• Customize formats using styles and themes.
• Insert content using Quick Parts.
• Use templates to automate document formatting.
• Control the flow of a document.
• Simplify and manage long documents.
• Use mail merge to create letters, envelopes, and labels.

In this course, you will leverage the power of data analysis and presentation to make informed, intelligent organizational decisions.

You will:

• Work with ranges and functions; including specialized, logical, date/time and text functions.
• Sort and filter data and lists.
• Create/modify tables and apply conditional formatting.
• Create and modify charts.
• Create and analyze PivotTables and PivotCharts.

In this course, you will perform advanced data analysis, collaborate on workbooks with other users, and automate workbook functionality.

You will:

• Work with multiple worksheets and workbooks.
• Share and protect workbooks.
• Automate workbook functionality.
• Use Lookup functions and formula auditing.
• Forecast data.
• Create sparklines and map data.