Swami Vivekanand Vocational Training Institute
K-1 MARUTI PURAM FAIZABAD ROAD INDRA NAGAR, LUCKNOW - 226016
Microsoft Office Course
Microsoft Excel
ü Microsoft Excel Introduction
ü How to Work in Excel And Use Basic Formulas
ü Use Clipboard Like Pro Full Explain
ü Organize Row Column And Worksheet
ü Data Entry Like Pro
ü Create Your Own Custom List
ü How Make Password your Excel File
ü How To Create a Backup Excel File
ü How to Use Sum Formula
ü How to Use Skip Blanks
ü Subtract, Multiple, Divide And Percentage
ü Use of Number Format in Excel
ü Use Conditional Formatting
ü How to Sort & Filter Data
ü Using Find and Replace and Using GoTo
ü How to Use Status Bar
ü Freeze Panes Option
ü Concatenate
ü Fill Option
ü Flesh Fill
ü Pivot Table
ü All Table Option
ü Pictures Option
ü Use Shape
ü Smart Art
ü Advanced Charts & Graph
ü Create Hyperlinks
ü Dashboard
ü Complete Page Setup
ü Scale to Fit Setup
ü IF Formula
ü IF Formula With Multiple Conditions
ü Change Case and Round Figure Formula
ü VLOOKUP Formula
ü Stock Record
ü HLOOKUP Formula
ü Subtotal Formula
ü Calculate Age With Date, Date If Formula
ü Date and Eo-Month Formula
ü Calculating Percent Formula
ü Concatenate Formula
ü Count, Counta, Countblank Formula
ü Countif Formula
ü Countifs Formula
ü Sumif Formula
ü Sumifs Formula
ü Text Formula
ü Employees Payroll and Salary Slip
ü Dropdown List
ü Make Attendance Sheet
ü Mail Merge
Microsoft Word
ü Introduction to Microsoft Word
ü Use Clipboard Group of Home Tab
ü Text Formatting in Microsoft Word
ü Line and Paragraph Spacing
ü Sort Paragraph, Bullet and Number Lists
ü Using Find, Replace, and Go To
ü Page Setup and Printing
ü How to Create Custom Cover Pages
ü Hyperlink, Bookmark and Cross Reference
ü Creating and Formatting Tables
ü Insert Pictures in Word
ü Insert ClipArt & Online Image
ü Using Word Text Boxes
ü Create a SmartArt graphic
ü Add or Edit Shapes in MS Word
ü Create Fillable Forms
ü Use Autocorrect in Word
ü How to Insert Watermarks
ü Check Spelling and Grammar
ü Perfect Text Alignment Using Tabs
ü Add Footnote and Endnote
ü Insert Table of Contents
ü Microsoft Word Best Keyboard Shortcuts
ü How to Create a Resume in Word
ü Using Mail Merge in MS Word
ü Create Certificate in MS Word
ü How To Make Visiting Card
Microsoft Power Point
ü Power Point Intro
ü Make New Slideshow in PowerPoint
ü Add Transitions to PowerPoint
ü Text Animation in PowerPoint
ü Add Animations To PowerPoint
