Advanced Excel & Word

This course is meant for learners who wish to equip themselves with advanced skills in the concepts and features of Microsoft Word and Excel applications. The course content gives a customized solution for students who aspire to enhance their office software skills and have that extra edge in their office.

• Using shapes, smart art and Word Art in documents

• Working with Pictures; Working with Clip Art; Working with Text Boxes and Shapes

• Using Section Breaks; Working with Sections

• Creating a Table of Contents ; Creating an Index table

• Working with Quick Styles; Using Installed Templates; Creating a Custom Template

• Modifying Document Properties; Creating Custom Themes; Customizing the Quick Access Toolbar; Customizing the Microsoft Word Environment

• Mail Merge Process; Setting Up the Main Document; Previewing and Completing the Merge; Merging Envelopes; Merging Labels

• Using Bookmarks; Using Footnotes, Endnotes, text and picture watermarks

• Creating an Electronic Form; Creating a Printed Form

Excel Part:

• Creating Custom Themes; Working with Quick Styles; Using Conditional and Custom Formatting

• Referencing Data; Using Hyperlinks; Ensuring Data Integrity

• Built in functions in Excel, Financial Functions

• Creating Tables; Sorting and Filtering Data; Grouping and Outlining

• Understanding PivotTable and PivotChart Reports; Creating PivotTable and PivotChart Reports

• Protecting a Workbook; Sharing a Workbook with Others; Reviewing and Consolidating Workbook

• VLOOKUP’s and Data Cleansing