Microsoft Office

Course content

Microsoft Word:

•          Introduction to Microsoft Word Interface

•          Font Operation in Microsoft word

•          Paragraph Formatting in Microsoft Word

•          Heading Styles in Microsoft Word

•          Editing Options in Home Tab

•          Clipboard & Format Painter Options in Microsoft Word

•          Page Insert Options in Microsoft Word

•          Inserting Tables in Microsoft Word

•          Insert Pictures in Microsoft Word

•          Shapes, Icons & 3d Models in Microsoft Word

•          SmartArt Options in Microsoft Word

•          Inserting Charts in Microsoft Word

•          Text Box & Drop Cap Options in Microsoft Word

•          Hyperlink in Microsoft Word

•          Header, Footer & Page Number Options in Microsoft Word

•          Equations & Symbols in Microsoft Word

•          Water Mark, Page Color & Page Border Options in Microsoft Word

•          Page Setup Options in Microsoft Word

•          Table of Contents & Table of Figures in Microsoft Word

•          Endnote & Footnote Options in Microsoft Word

•          Mailings Tab Options in Microsoft Word

•          Review Tab Options in Microsoft Word

•          View Tab Options in Microsoft Word

•          File Tab Options in Microsoft Word

Microsoft Excel:

•          Introduction to Microsoft Excel Interface

•          Basic Math Functions

•          AutoSum Functions

•          Sum IF Function & Remove Duplicates Option

•          Sum IF & Sum IFs, Count IF & Count IFs Functions

•          Sub Total Function

•          Arrays & Sum Product Functions

•          Other Math Functions

•          Cell or Range Name

•          Absolute & Relative References

•          Formatting Techniques in Excel

•          Excel Data Types

•          Roaming in Excel

•          Go to & Replace Options

•          Auto Fill Options

•          Flash Fill Option

•          Copy, Paste & Paste Special Options

•          Conditional Formatting

•          Sort & Filter

•          Excel Operators

•          Equations Solving in Excel

•          Errors in Excel Sheet

•          Logical Function IF

•          Logical Function IF Error

•          Logical Function (IF, Nested IF, OR)

•          Logical Function AND

•          VLOOKUP Function

•          VLOOKUP with Data Validation

•          VLOOKUP Function with Wildcard

•          VLOOKUP Function with Helper Column

•          Nested VLOOKUP

•          HLOOKUP Function

•          Quick Audit Using Charts

•          Sheet Formulas Auditing Tools

•          Selecting the Chart

•          Charts in Excel

•          Tables in Excel

•          Pivot Table & Chart

•          Sparklines & Slicer Filter Options

•          Inserting Comments

•          Inserting Hyperlink

•          Info Functions

•          Text Functions

•          Date, Time & Reference Functions

•          Printing & viewing the Excel Sheet

•          Text to Columns Tool

•          Data Consolidation

•          Data Table Option

•          Queries in Excel | Importing External Data

•          Dashboards

•          Form Controls

•          Recording & Using Macros

Microsoft Power Point:

•          Introduction to Microsoft PowerPoint Interface

•          Font & Slide Options in Microsoft PowerPoint

•          Paragraph Formatting in Microsoft PowerPoint

•          Drawing Tools in Microsoft PowerPoint

•          Editing Options in Home Tab

•          Inserting Tables in Microsoft PowerPoint

•          Inserting Pictures in Microsoft PowerPoint

•          Screenshot Option in Microsoft PowerPoint

•          Inserting Photo Albums in Microsoft PowerPoint

•          Inserting Icons in Microsoft PowerPoint

•          Inserting 3D Models in Microsoft PowerPoint

•          Inserting Smart Arts in Microsoft PowerPoint

•          Inserting Charts in Microsoft PowerPoint

•          Some Other Inserting Options in Microsoft PowerPoint

•          Inserting Videos in Microsoft PowerPoint

•          Audio & Screen Recording in Microsoft PowerPoint

•          Design Tab Options in Microsoft PowerPoint

•          Transitions Tab Options in Microsoft PowerPoint

•          Animations Tab Options in Microsoft PowerPoint

•          Slide Show Tab Options in Microsoft PowerPoint

•          Review Tab Options in Microsoft PowerPoint

•          View Tab Options in Microsoft PowerPoint

•          'Tell me what you want t do' bar in Microsoft PowerPoint

•          Quick Access Toolbar & File Tab Options in Microsoft PowerPoint

•          Built-in Presentation Templates in Microsoft PowerPoint