Microsoft MS Office Excel, Word and PowerPoint

Be proficient in Microsoft MS Office including Excel, Word and PowerPoint Understand the main functions of Excel Do simple to intermediate MS Excel worksheets independently Understand various components of MS Powerpoint Be able to create visually appealing PowerPoint Presentations Be able to create Word documents effectively

Microsoft MS Excel (Basic to Intermediate) 4hrs Create a Basic Worksheet Inputting data Add Borders and Colours to Cells Change column width and row height Merge Cells and Wrap Text Apply Number and Font Formatting Find and Replace Data Autofill Data Data Segregation using Text to Column Working with Lists – Sorting and Filtering (> vs >=, < vs <=, AND vs OR). Sort and Filter by Color 4hrs Create Formulas in a Worksheet Understand commonly used Functions like SUM, AVERAGE, MIN, MAX, COUNT, ROUND, ROUNDUP, ROUNDDOWN. Fixing and anchoring Formulas using $ sign IF, SUMIF and COUNTIF Convert Text to Column Transposing Data Inserting Header and Footer Apply Page Break, Split and Freeze Panes Creating 2D and 3D Charts Showing Data Labels, Legend, Titles, Format Multiple Worksheets Recording Macro MS WORD 2hrs Doubling your typing speed Frequently used keyboard shortcuts Navigating a Document Copying & Moving Text Inserting Symbols & Special Characters Bullets, Numbering and Multi-Level List Using Undo, Redo Finding Text & Replacing Text automatically Spell Check & Grammar Word Count Advantages of multiple Columns Differences of Column, Page and Section Breaks Showing and Hiding Editing Marks Indents and Margins Adding Page Number and Total Pages Using Headers & Footers Changing Font Type, Size & Colour Changing Font Styles & Effects Inserting and formatting Pictures and Shapes Flipping & Rotating Objects, Layering Objects Inserting a Text Box and Understanding difference with text Mail Merge to automate tasks MS POWERPOINT 6hrs Lesson 1: Getting Started A: Navigate the PowerPoint Environment B: Create and Save a PowerPoint Presentation C: Create impressive background with Gradient fill and Title tracking Lesson 2: Developing a Presentation A: Select a Presentation B: View and Navigate a Presentation C: Edit Text Topic D: Build a Presentation E: Portrait and Landscape Lesson 3: Performing Advanced Text Editing A: Format Characters, Paragraphs and Text Boxes B: Create Wavy and Circular Text C: Create 3D text and adjusting depth and rotation Lesson 4: Adding Graphical Elements A: Insert Clip Art and JPEG, GIF Images and Video B: Insert Shapes C: Make 2D image become 3D automatically Lesson 5: Modifying Objects A: Edit and Format Objects B: Group Objects Lesson 6: Adding Tables A: Create and Format Table B: Insert a Table from MS Excel Lesson 7: Adding Charts A: Create and Format Chart B: Insert a Chart from MS Excel Lesson 8: Animations and Transitions A: Transitions between Slides B: Animations within a Slide: Entrance, Emphasis and Exit Effects C: Animation Sequence, Start, Duration, Delay