Enquiry




    MICROSOFT WORD

    Microsoft Office Course - MS Word

    Microsoft Word, is a word processor developed by Microsoft. MS Word is available stand-alone or as part of the Microsoft Office suite. Word contains rudimentary desktop publishing capabilities and is the most widely used word processing program in the market.

    Word files are commonly used as the format for sending text documents because almost every user with a computer can read a Word document by using the Word application, a Word viewer or a word processor that imports the Word format.

    CREATE AND MANAGE DOCUMENTS

    CREATE A DOCUMENT

    • Create a blank document
    • Create a document using a template
    • Open a PDF in Word for editing

    NAVIGATING THROUGH A DOCUMENT

    • Search for text
    • Insert hyperlinks
    • Create bookmarks
    • Navigate with Headings
    • Cross-reference
    • Move to a specific locations or object in a document

    FORMATTING A DOCUMENT

    • Modify page setup
    • Apply document themes
    • Apply document style sets
    • Insert Headers and Footers
    • Insert page numbers
    • Format page background elements

    CUSTOMIZE OPTIONS AND VIEWS FOR A DOCUMENT

    • Change document views
    • Customize views by using zoom settings
    • Customize the quick access toolbar
    • Split the window
    • Add document properties
    • Show or hide formatting symbols

    PRINT AND SAVE DOCUMENTS

    • Modify print settings
    • Save documents in alternative file formats
    • Print all or part of a document
    • Inspect a document for hidden properties or personal information
    • Inspect a document for accessibility issues
    • Inspect a document for compatibility issues
    • Create PDF documents

    FORMAT TEXT, PARAGRAPHS, AND SECTIONS

    INSERT TEXT AND PARAGRAPHS

    • Find and replace text
    • Cut, copy, and paste text
    • Replace text by using autocorrect
    • Insert special characters

    FORMATTING TEXT AND PARAGRAPHS

    • Apply font formatting
    • Apply formatting by using format painter
    • Set line and paragraph spacing and indentation
    • Clear formatting
    • Apply a text highlight color to text selections
    • Apply built-in styles to text
    • Change text to WordArt

    ORDER AND GROUP TEXT AND PARAGRAPHS

    • Format text in multiple columns
    • Insert page, section, or column breaks
    • Change page setup options for a section

    CREATE TABLES AND LISTS

    CREATE A TABLE

    • Convert text to tables
    • Convert tables to text
    • Create a table by specifying rows and columns
    • Apply table styles

    MODIFY A TABLE

    • Sort table data
    • Configure cell margins and set spacing
    • Merge and split cells
    • Resize tables, rows, and columns
    • Split tables
    • Configure a repeating row header

    CREATE AND MODIFY A LIST

    • Create a numbered or bulleted list
    • Change bullet characteristics or number formats for a list level
    • Define a custom bullet character or number format
    • Increase or decrease list levels
    • Restart or continue list numbering
    • Set starting number values

    CREATE AND MANAGE REFERENCES

    CREATE AND MANAGE REFERENCE MARKERS

    • Insert footnotes and endnotes
    • Modify footnote and endnote properties
    • Create bibliography citation sources
    • Modify bibliography citation sources
    • Insert citations for bibliographies
    • Insert figure and table captions
    • Modify caption properties

    CREATE AND MANAGE SIMPLE REFERENCES

    • Insert standard table of contents
    • Update table of contents
    • Insert cover page

    INSERT AND FORMAT GRAPHIC ELEMENTS

    INSERT GRAPHIC ELEMENTS

    • Insert shapes
    • Insert pictures
    • Insert screen shot or screen clipping
    • Insert text boxes

    FORMAT GRAPHIC ELEMENTS

    • Apply artistic effects
    • Apply picture effects
    • Remove picture backgrounds
    • Format objects
    • Apply a picture style
    • Wrap text around objects
    • Position objects
    • Add alternative text to objects for accessibility

    INSERT AND FORMAT SMARTART GRAPHICS

    • Create a SmartArt graphic
    • Format a SmartArt graphic
    • Modify a SmartArt graphic content

    REVIEW A DOCUMENT

    PROOFING A DOCUMENT

    • Spell Check
    • Check document statistics
    • Translate content

    COMMENTS & TRACKING

    • Inserting comments
    • Managing Comments
    • Track the changes
    • Manage Markups
    • Accept/ Reject changes
    • Compare & Combine Documents

    MAIL MERGE

    PREPARING FOR MAIL MERGE

    • Creating a new list of recipients
    • Using an existing list of recipients
    • Using Outlook contacts
    • Editing the list of recipients

    WORKING WITH FIELDS

    • Inserting Merge Fields
    • Inserting Greeting Line
    • Inserting Rules
    • Match Fields

    FINISHING MAIL MERGE

    • Preview documents
    • Finish & Merge
      1. Individual documents
      2. Print Mail Merge files
      3. E-mail mail Merge files

    PROTECT A DOCUMENT

    • Formatting Restrictions
    • Editing Restrictions
    • Enforcing Protection
    • Encrypt with a password

    MICROSOFT POWERPOINT

    Microsoft Office Course - MS PowerPoint

    Microsoft PowerPoint is a presentation program from Microsoft.PowerPoint is available stand-alone or as part of the Microsoft Office suite. It offers users many
    ways to display information from simple presentations to complex multimedia presentations.

    CREATE AND MANAGE PRESENTATIONS

    CREATE A PRESENTATION

    • Create a new presentation
    • Create a presentation based on a template
    • Import Word document outlines
    • Apply a theme

    INSERT AND FORMAT SLIDES

    • Insert specific slide layouts
    • Duplicate existing slides
    • Hide and unhide slides
    • Delete slides
    • Apply a different slide layout
    • Modify individual slide backgrounds
    • Insert slide headers, footers, and page numbers

    MODIFY SLIDES, HANDOUTS, AND NOTES

    • Change the slide master theme or background
    • Modify slide master content
    • Create a slide layout
    • Modify a slide layout
    • Modify the handout master
    • Modify the notes master

    ORDER AND GROUP SLIDES

    • Create sections
    • Modify slide order
    • Rename sections

    CHANGE PRESENTATION OPTIONS AND VIEWS

    • Change slide size
    • Change views of a presentation
    • Set file properties

    CONFIGURE A PRESENTATION FOR PRINT

    • Print Settings
    • Print all or part of a presentation
    • Print notes pages; print handouts
    • Print in color, gray scale, or black and white

    CONFIGURE AND PRESENT A SLIDE SHOW

    • Create custom slide shows
    • Configure slide show options
    • Rehearse slide show timing
    • Present a slide show by using Presenter View

    INSERT AND FORMAT TEXT, SHAPES, AND IMAGES

    INSERT AND FORMAT TEXT

    • Insert text on a slide
    • Apply formatting and styles to text
    • Apply WordArt styles to text
    • Format text in multiple columns
    • Create bulleted and numbered lists
    • Insert hyperlinks

    INSERT AND FORMAT SHAPES AND TEXT BOXES

    • Insert or replace shapes
    • Insert text boxes, resize shapes and text boxes
    • Format shapes and text boxes
    • Apply styles to shapes and text boxes

    INSERT AND FORMAT IMAGES

    • Insert images
    • Resize and crop images
    • Apply styles and effects

    ORDER AND GROUP OBJECTS

    • Order objects
    • Align objects
    • Group objects
    • Display alignment tools

    INSERT TABLES, CHARTS, SMARTART, AND MEDIA

    INSERT AND FORMAT TABLES

    • Create a table
    • Insert and delete table rows and columns
    • Apply table styles
    • Import a table

    INSERT AND FORMAT CHARTS

    • Create a chart
    • Import a chart
    • Change the Chart Type
    • Add a legend to a chart
    • Change the chart style of a chart

    INSERT AND FORMAT SMARTART GRAPHICS

    • Create SmartArt graphics
    • Convert lists to SmartArt graphics
    • Add shapes to SmartArt graphics
    • Reorder shapes in SmartArt graphics
    • Change the color of SmartArt graphics

    INSERT AND MANAGE MEDIA

    • Insert audio and video clips
    • Configure media playback options
    • Adjust media window size
    • Set the video start and stop time
    • Set media timing options

    APPLY TRANSITIONS AND ANIMATIONS

    APPLY SLIDE TRANSITIONS

    • Insert Slide Transitions
    • Set transition effect options

    ANIMATE SLIDE CONTENT

    • Apply animations to objects
    • Apply animations to text
    • Set animation effect options
    • Set animation paths

    SET TIMING FOR TRANSITIONS AND ANIMATIONS

    • Set transition effect duration
    • Configure transition start and finish options
    • Reorder animations on a slide

    MANAGE MULTIPLE PRESENTATIONS

    MERGE CONTENT FROM MULTIPLE PRESENTATIONS

    • Insert slides from another presentation
    • compare two presentations
    • insert comments, review comments

    FINALIZE PRESENTATIONS

    • Protect a presentation
    • Inspect a presentation
    • Proof a presentation
    • Preserve presentation content
    • Save in different formats
    • Export presentations to other formats

    TEMPLATES AND MASTERS

    CREATING AND MODIFYING TEMPLATES

    • Working with slide masters
    • Inserting Placeholders
    • Modifying backgrounds and color schemes
    • Saving templates

    MICROSOFT OUTLOOK

    Microsoft Office Course – MS Outlook

    Microsoft Outlook is a personal information manager fromMicrosoft, available as a part of the Microsoft Office suite. Primarily an email application, it also includes a calendar, task manager, contact manager etc.,

    It can be used as a stand-alone application. Outlook mobile applications for most mobile platforms, including iOS and Android is also available.

    MANAGE THE OUTLOOK ENVIRONMENT FOR PRODUCTIVITY

    CUSTOMIZE SETTINGS

    • Customize reply messages
    • Change text formats for all outgoing messages
    • Customize the Navigation Pane
    • Manage multiple accounts
    • Add an account

    PRINT AND SAVE INFORMATION

    • Print message, calendar, contact, or task information
    • Save message attachments
    • Preview attachments
    • Perform Search Operations in Outlook
    • Create new search folders

    SEARCH FOR ITEMS IN MESSAGES, TASKS, CONTACTS, OR CALENDARS

    • Search by using advanced find; search by folder
    • Sort by Date, Category, Size etc.
    • Sort by Read, Unread

    MANAGE MESSAGES

    CONFIGURE MAIL SETTINGS

    • Set fonts for new messages and responses
    • Create, assign, and modify signatures
    • Create and manage rules
    • Create automatic replies
    • Create messages by using Quick Steps
    • Configure Junk Email and Clutter settings

    CREATE MESSAGES

    • Create a message
    • Add or remove message attachments
    • Add cc and bcc to messages
    • Add tracking and voting options
    • Forward and reply to messages
    • Request a delivery or read receipt
    • Redirect replies
    • Flag outgoing messages for follow up, importance, and sensitivity
    • Recall a message

    FORMAT A MESSAGE

    • Format text
    • Insert hyperlinks
    • Apply themes and styles
    • Insert messages
    • Add a signature to specific messages

    ORGANIZE AND MANAGE MESSAGES

    • Sort messages
    • Move messages between folders
    • Add new local folders
    • Apply categories
    • Clean up messages
    • Mark a message as read or unread
    • Flag received messages, ignore messages
    • Sort messages by conversation
    • Delete messages
    • Automate repetitive tasks by using Quick Steps
    • Configure basic Auto Archive settings

    MANAGE SCHEDULES

    CREATE AND MANAGE CALENDARS

    • Create and add calendars
    • Appointment/ Meeting
    • Adjust viewing details for calendars
    • Modify calendar time zones
    • Delete calendars
    • Manage multiple calendars
    • Manage calendar groups
    • Display multiple calendars
    • Share calendars

    CREATE APPOINTMENTS, MEETINGS, AND EVENTS

    • Create calendar items
    • Create recurring calendar items
    • Cancel calendar items
    • Create calendar items from messages
    • Set calendar item times
    • Set up meetings
    • Set free or busy status for calendar items

    ORGANIZE AND MANAGE APPOINTMENTS, MEETINGS, AND EVENTS

    • Set calendar item importance
    • Forward calendar items
    • Configure reminders
    • Add participants
    • Respond to invitations
    • Update individual or recurring calendar items
    • E-mail Calendar
    • Categorize calendar items

    CREATE AND MANAGE TASKS

    • Create and manage tasks
    • Forward, Move, Delete Tasks
    • Set reminders
    • Assign a Task
    • Set recurrence
    • Mark as completed

    MANAGE CONTACTS AND GROUPS

    • Create and Manage Contacts
    • Create a new contact
    • Delete contacts
    • Import contacts from external sources
    • Edit contact information
    • Attach an image to a contact
    • Add tags to contacts
    • Share contacts

    CREATE AND MANAGE ADDRESS BOOKS

    • Create and Manage Contact Groups
    • Create new contact groups
    • Add contacts to existing contact groups
    • Add notes to a contact group
    • Update contacts within contact groups
    • Delete contact groups
    • Delete contact group members

    MICROSOFT EXCEL

    Advanced Excel

    Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android and IOS. It features calculation, graphing tools, pivot tables. It has been a very widely applied spreadsheet for these platforms. Excel has replaced Lotus 1-2-3 as the industry standard for spreadsheets. Excel forms part of the Microsoft Office suite of software.

    Microsoft Excel has the basic features of all spreadsheets, using a grid of cells arranged in numbered rows and letternamed columns to organize data manipulations like arithmetic operations. It has a battery of supplied functions to answer statistical, engineering and financial needs.

    CREATE AND MANAGE WORKSHEETS AND WORKBOOKS

    CREATE WORKSHEETS AND WORKBOOKS

    • Create a workbook
    • Import data from a delimited text file
    • Add a worksheet to an existing workbook
    • Copy and move a worksheet

    NAVIGATE IN WORKSHEETS AND WORKBOOKS

    • Search for data within a workbook
    • Navigate to a named cell, range, or workbook element
    • Insert and remove hyperlinks

    FORMAT WORKSHEETS AND WORKBOOKS

    • Change worksheet tab color
    • Rename a worksheet
    • Change worksheet order
    • Modify page setup
    • Insert and delete columns or rows
    • Change Workbook themes
    • Adjust row height and column width
    • Insert headers and footers

    CUSTOMIZE OPTIONS AND VIEWS

    • Hide or unhide worksheets
    • Hide or unhide columns and rows
    • Customize the Quick Access toolbar
    • Change workbook views
    • Change window views
    • Modify document properties
    • Change magnification by using zoom tools
    • Display formulas

    CONFIGURE WORKSHEETS AND WORKBOOKS FOR DISTRIBUTION

    • Set a print area
    • Save workbooks in alternative file formats
    • Print all or part of a workbook
    • Set print scaling
    • Display repeating row and column titles on multiple worksheets
    • Inspect a workbook for hidden properties or personal information
    • Inspect a workbook for accessibility issues
    • Inspect a workbook for compatibility issues

    MANAGE DATA CELLS AND RANGES

    INSERT DATA IN CELLS AND RANGES

    • Replace data
    • Cut, copy, or paste data
    • Paste data by using special paste options
    • fill cells by using Auto Fill
    • Insert and delete cells

    FORMAT CELLS AND RANGES

    • Merge cells
    • Modify cell alignment and indentation
    • Format cells by using Format Painter
    • Wrap text within cells
    • Apply number formats
    • Apply cell formats, apply cell styles

    SUMMARIZE AND ORGANIZE DATA

    • Insert sparklines
    • Outline data
    • Insert subtotals
    • Apply conditional formatting

    CREATE TABLES

    CREATE AND MANAGE TABLES

    • Create an Excel table from a cell range
    • Convert a table to a cell range
    • Add or remove table rows and columns

    MANAGE TABLE STYLES AND OPTIONS

    • Apply styles to tables
    • Configure table style options
    • Insert total rows

    FILTER AND SORT A TABLE

    • Filter records
    • Sort data by multiple columns
    • Change sort order
    • Remove duplicate records

    PERFORM OPERATIONS WITH FORMULAS AND FUNCTIONS

    SUMMARIZE DATA BY USING FUNCTIONS

    • Insert references
    • Perform calculations by using the SUM function
    • Perform calculations by using MIN and MAX functions
    • Perform calculations by using the COUNT function
    • Perform calculations by using the AVERAGE function

    PERFORM CONDITIONAL OPERATIONS BY USING FUNCTIONS

    • Perform logical operations by using the IF function
    • Perform logical operations by using the SUMIF function
    • Perform logical operations by using the AVERAGEIF function
    • Perform statistical operations by using the COUNTIF function

    FORMAT AND MODIFY TEXT BY USING FUNCTIONS

    • Format text by using RIGHT, LEFT, and MID functions
    • Format text by using UPPER, LOWER, and PROPER functions
    • Format text by using the CONCATENATE function

    MODULE FIVE: CREATE CHARTS AND OBJECTS

    CREATE CHARTS

    • Create a new chart
    • Add additional data series
    • Switch between rows and columns in source data
    • Analyze data by using Quick Analysis

    FORMAT GRAPHIC ELEMENTS

    • Resize charts
    • Add and modify chart elements
    • Apply chart layouts and styles
    • Move charts to a chart sheet

    INSERT AND FORMAT OBJECTS

    • Insert text boxes and shapes
    • Insert images
    • Modify object properties
    • Add alternative text to objects for accessibility

    MICROSOFT EXCEL ADVANCED

    Advanced Excel

    Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android and IOS. It features calculation, graphing tools, pivot tables. It has been a very widely applied spreadsheet for these platforms.

    Microsoft Excel has the basic features of all spreadsheets, using a grid of cells arranged in numbered rows and letternamed columns to organize data manipulations like arithmetic operations. It has a battery of supplied functions to answer statistical, engineering and financial needs.

    MANAGE WORKBOOK OPTIONS AND SETTINGS

    MANAGE WORKBOOKS

    1. Save a workbook as a template
    2. Copy macros between workbooks
    3. Mange Document Versions
    4. Reference data in another workbook
    5. Reference data by using structured references
    6. Enable macros in a workbook
    7. Display hidden ribbon tabsSave a workbook as a template
    8. Copy macros between workbooks
    9. Mange Document Versions
    10. Reference data in another workbook
    11. Reference data by using structured references
    12. Enable macros in a workbook
    13. Display hidden ribbon tabs

    MANAGE WORKBOOK REVIEW

    • Restrict editing
    • Protect a worksheet
    • Configure formula calculation options
    • Protect workbook structure
    • Mange workbook versions
    • Encrypt workbooks with a password

    APPLY CUSTOM DATA FORMATS AND LAYOUTS

    APPLY CUSTOM DATA FORMATS AND VALIDATION

    • Create custom number formats
    • Populate cells by using advanced Fill Series options
    • Configure data validation

    APPLY ADVANCED CONDITIONAL FORMATTING AND FILTERING

    • Create custom conditional formatting rules
    • Create conditional formatting rules that use formulas
    • Manage conditional formatting rules

    CREATE AND MODIFY CUSTOM WORKBOOK ELEMENTS

    • Create custom color formats
    • Modify fonts
    • Insert Form Controls
    • Create and modify cell types
    • Create and modify custom themes
    • Create and modify simply macros
    • Configure form controls

    PREPARE A WORKBOOK FOR INTERNATIONALIZATION

    • Display data in multiple international formats
    • Apply international currency formats
    • Manage multiple options for +Body and +Heading fonts

    CREATE ADVANCED FORMULAS

    PERFORM DATA ANALYSIS AND BUSINESS INTELLIGENCE

    • Import, transform, combine, display, and connect to data
    • Consolidate data
    • Perform what-if analysis by using Goal Seek and Scenario Manager
    • Use cube functions to get data out of the Excel data model
    • Calculate data by using financial functions

    TROUBLESHOOT FORMULAS

    • Trace precedence and dependence
    • Monitor cells and formulas by using the Watch Window
    • Validate formulas by using error checking values
    • Evaluate formulas
    • Calculate data by using financial functions

    FORMAT AND MODIFY TEXT BY USING FUNCTIONS

    • Format text by using RIGHT, LEFT, and MID functions
    • Format text by using UPPER, LOWER, and PROPER functions

    APPLY FUNCTIONS IN FORMULAS

    • Perform logical operations by using AND, OR, and NOT functions
    • Perform logical operations by using nested functions
    • Perform statistical operations by using SUMIFS, AVERAGEIFS, AND COUNTIFS functions

    LOOK UP DATA USING FUNCTIONS

    • Look up data by using the VLOOKUP
    • Look up data by using the HLOOKUP function
    • Look up data by using the MATCH function
    • Look up data by using the INDEX function

    APPLY ADVANCED DATE AND TIME FUNCTIONS

    • Reference the date and time by using the NOW and TODAY functions
    • Serialize numbers by using date and time functions

    PERFORM DATA ANALYSIS AND BUSINESS INTELLIGENCE

    • Import, transform, combine, display, and connect to data
    • Consolidate data
    • Perform what-if analysis by using Goal Seek and Scenario Manager
    • Use cube functions to get data out of the Excel data model
    • Calculate data by using financial functions

    TROUBLESHOOT FORMULAS

    • Trace precedence and dependence
    • Monitor cells and formulas by using the Watch Window
    • Validate formulas by using error checking values
    • Evaluate formulas
    • Calculate data by using financial functions

    FORMAT AND MODIFY TEXT BY USING FUNCTIONS

    • Format text by using RIGHT, LEFT, and MID functions
    • Format text by using UPPER, LOWER, and PROPER functions

    PERFORM DATA ANALYSIS AND BUSINESS INTELLIGENCE

    • Import, transform, combine, display, and connect to data
    • Consolidate data
    • Perform what-if analysis by using Goal Seek and Scenario Manager
    • Use cube functions to get data out of the Excel data model
    • Calculate data by using financial functions

    TROUBLESHOOT FORMULAS

    • Trace precedence and dependence
    • Monitor cells and formulas by using the Watch Window
    • Validate formulas by using error checking values
    • Evaluate formulas
    • Calculate data by using financial functions

    FORMAT AND MODIFY TEXT BY USING FUNCTIONS

    • Format text by using RIGHT, LEFT, and MID functions
    • Format text by using UPPER, LOWER, and PROPER functions

    PERFORM DATA ANALYSIS AND BUSINESS INTELLIGENCE

    • Import, transform, combine, display, and connect to data
    • Consolidate data
    • Perform what-if analysis by using Goal Seek and Scenario Manager
    • Use cube functions to get data out of the Excel data model
    • Calculate data by using financial functions

    TROUBLESHOOT FORMULAS

    • Trace precedence and dependence
    • Monitor cells and formulas by using the Watch Window
    • Validate formulas by using error checking values
    • Evaluate formulas
    • Calculate data by using financial functions

    FORMAT AND MODIFY TEXT BY USING FUNCTIONS

    • Format text by using RIGHT, LEFT, and MID functions
    • Format text by using UPPER, LOWER, and PROPER functions

    DEFINE NAMED RANGES AND OBJECTS

    • Name cells
    • Name data ranges
    • Name tables
    • Mange named ranges and objects

    CREATE ADVANCED CHARTS AND TABLES

    CREATE ADVANCED CHARTS

    • Add trend lines to charts
    • Create dual axis charts
    • Save a chart as a template

    CREATE AND MANAGE PIVOT TABLES

    • Create PivotTables
    • Modify field selections and options
    • Create slicers
    • Group PivotTable data
    • Reference data in a PivotTable by suing the GETPRIVOTDATA function
    • Add calculated fields
    • Format data

    CREATE AND MANAGE PIVOTCHARTS

    • Create Pivot Charts
    • Manipulate options in existing Pivot Charts
    • Apply styles to Pivot Charts
    • Apply Styles to Pivot Charts
    • Manipulate options in existing Pivot Charts
    • Apply styles to pivot Charts
    • Drill down into PivotChart details