Microsoft Office Course Syllabus

About The Course:  

Designed to help you accomplish office tasks easily and with greater efficiency, Microsoft Office is the choice of many office professionals. If you're working in an office, you'll likely need to use the Microsoft Office suite and it's likely you're working for it, rather than having it work for you. Turn that around today and finally learn all the deep, dark secrets of Microsoft Office from these 8 courses in one bundle. Master Microsoft Excel, start at the beginning if you're brand new to spreadsheets or pick up at Intermediate or Advanced level.

Course Certification:  

Unlock your full potential with our comprehensive Online Microsoft Office Course! Master the essential tools of the trade and boost your professional skills with our in-depth training program. Upon successful completion, you will receive the prestigious Microsoft Office Mastery Certification, validating your expertise in the world's most widely used productivity suite.

Microsoft Word

Text Basics

1. Typing the text, Alignment of text

2. Editing Text: Cut, Copy, Paste, Select All, Clear

3. Find & Replace

Text Formatting and Saving Files

1. New, Open, Close, Save, Save As

2. Formatting Text: Font Size, Font Style, Font Color

3. Use Bold, Italic, and Underline

4. Change Text Case

5. Line Spacing, Paragraph Spacing

6. Shading Text and Paragraph

7. Working with Tabs and Indents

Working with Objects

1. Shapes, Clipart and Picture, Word Art, Smart Art

2. Adding Columns to a Document

3. Change the Order of Objects

4. Page Number, Date & Time

5. Inserting Text Boxes, WordArt, Symbols, Charts

Headers & Footers

1. Inserting Custom Header and Footer

2. Inserting Objects in Headers and Footers

3. Adding Section Breaks

Working with Bullets and Numbered Lists

1. Multilevel Numbering and Bulleting

2. Creating and Customizing Lists

3. Page Borders and Backgrounds

Tables

1. Working with Tables, Table Formatting, Table Styles

2. Alignment Options

3. Merge and Split Tables

Styles and Content

1. Using and Modifying Built-in Styles

2. Creating and Customizing Styles

3. Table of Contents, References

4. Adding Footnotes and Endnotes

Merging Documents

1. Typing New Address Lists

2. Importing Address Lists from Excel

3. Using Fields, Merging with Outlook Contacts

4. Previewing Results, Merging to Envelopes and Labels

5. Setting Rules and Options for Merges

Sharing and Maintaining Documents

1. Changing Word Options, Proofing Tools

2. Managing Templates, Document Access

3. Using Protected View, Working with Templates

4. Understanding Building Blocks

Proofing and Printing

1. Check Spelling and Grammar

2. Setting AutoCorrect Options

3. Page Setup, Margins, Print Preview, Printing

Microsoft Excel

Introduction to Excel

1. Excel Interface, Rows, Columns, Naming Cells

2. Working with Workbooks and Sheets

Formatting Excel Workbooks

1. New, Open, Close, Save, Save As

2. Formatting Text, Cells: Font Size, Style, Color

3. Wrap Text, Merge and Center

4. Currency, Accounting Formats

5. Modifying Columns, Rows, Cells

Performing Calculations with Functions

1. Creating and Using Formulas

2. Date and Time, Financial Functions

3. Logical, Lookup, Reference Functions

4. Mathematical, Statistical, Text Functions

Sorting and Filtering Data

1. Sorting and Filtering Data

2. Number and Text Filters, Custom Filters

3. Conditional Formatting

Creating Effective Charts

1. Inserting Column, Pie Charts

2. Design, Format, Layout Options

3. Adding Chart Titles, Styles

4. Editing Data Ranges, Series, Charts

Analyzing Data with PivotTables and Pivot Charts

1. Understanding and Creating PivotTables

2. Using PivotCharts, Slicers

3. Creating Calculated Fields

Protecting and Sharing Workbooks

1. Workbook Protection with Passwords

2. Allowing User Editing Ranges

3. Tracking Changes, Working with Comments

4. Inserting Excel Objects, Charts in Word and PowerPoint

Using Macros to Automate Tasks

1. Recording and Assigning Macros

2. Saving Macro-Enabled Workbooks

Proofing and Printing

1. Page Setup, Print Area, Print Titles

2. Inserting Custom Header and Footer

3. Page Setup, Margins, Print Preview, Printing

Microsoft PowerPoint

Setting Up PowerPoint Environment

1. New, Open, Close, Save, Save As

2. Typing Text, Alignment, Formatting

3. Cut, Copy, Paste, Select All, Clear

4. Find & Replace

5. Working with Tabs and Indents

Creating Slides and Applying Themes

1. Inserting New Slides, Changing Layout

2. Duplicating, Copying, Pasting Slides

3. Applying Themes, Changing Theme Colors

4. Formatting Slide Backgrounds, Views

Working with Bullets, Numbering, and Text

1. Multilevel Numbering, Bulleting

2. Creating Lists, Page Borders, Backgrounds

3. Aligning Text, Text Directions, Columns

Working with Objects

1. Shapes, Clipart, Pictures, WordArt, SmartArt

2. Ordering Objects

3. Inserting Slide Headers, Footers

Inserting Text Boxes, Symbols, Charts

Hyperlinks and Action Buttons

1. Inserting and Editing Hyperlinks, Action Buttons

2. Using WordArt, Shapes

Working with Movies and Sounds

1. Inserting Movies, Audio Files

2. Playback, Format Options

3. Video Options, Adjustments, Reshaping

Using SmartArt and Tables

1. Working with Tables, Table Formatting, Styles

2. Alignment Options, Merge and Split Tables

3. Converting Text to SmartArt

Animation and Slide Transition

1. Default and Custom Animation

2. Modifying Animation, Transitions

3. Applying and Modifying Slide Transitions

Using Slide Master

1. Working with Slide Master

2. Inserting Layout Options, Creating Custom Layouts

3. Formatting Placeholders

Slide Show Options

1. Starting Slide Show, Rehearsing Timing

2. Creating Custom Slide Shows

Proofing and Printing

1. Check Spelling, Set AutoCorrect Options

2. Save as Video, JPEG Files, PowerPoint Show

3. Print Preview, Printing