MS Office (Excel+Word+Powerpoint)

MS Office (Excel+Word+Powerpoint)

MS Office (Excel+Word+Powerpoint)

Version 2007 onwards
Part 1  - Understanding Excel      

What is a Spreadsheet?
1 .Excel Rows and Columns
2 .Enter text and numbers in a Cell
3 .How to Edit text in a Cell
4. How to Centre text and numbers
5 .Font Formatting in Excel
6 .How to change the colour of a Cell
7 .How to Save your work in Excel
8 .Currency Symbols in Excel
9. How to Merge Cells

Part 2 - Complex  Spreadsheet  

1. How to use AutoFill in Excel
2. Entering Simple Addition Formula
3. The SUM Function in Excel
4. The SUM Function Continued
5. Copy and Paste
6. How to use Paste Special
7.How to Multiply in Excel
8. Finishing your spreadsheet for this section
9. How to Add a Comment to a Cell                                                                                                                                                                  
Part 3  - Microsoft Excel Charts                                                                                                                                                                               
1. How to Sort Data in Excel
2 .Create an Excel Chart
3 .Move and Resize your Chart
4 .Chart Styles and Layouts
5 .Chart Titles and Series Titles
6 .Chart Layout Panel in Excel
7. The Format Chart Panel
8 .Create a Pie Chart in Excel
9 .Add Labels to a Pie Chart
10. Format Pie Chart Segments
11.Create a 2D Line Chart in Excel
12.Format your Axis Titles
13 .Predict the future with a Trendline Chart
14 .Sparkline Charts                                                                                                                                                                                             
Part 4  - Formulas in Excel                                                                                                                                                                                    
1.The SUM Function
2.How to Multiply in Excel
3.Subtract and Divide
4. Combining the Arithmetic Operators
5. A Budget Spreadsheet                                                                                                                                                                                   
Part 5  - Functions in Excel                                                                                                                                                                                
1. The Average Function
2. The Date Function
3. Time Functions in Excel
4. A TimeTable Project
5. Financial Functions

Part 6  - Conditional Logic in Excel                                                                                                                                                                      
1 The IF Function
2 Conditional Formatting in Excel
3 CountIF
4 SumIF

Part 7 - Processing Data in Excel                                                                                                                                                                         
1.Data Tables in Excel
2.A Second Data Table
3.Excel Scenarios
4.Absolute Cell References
5.Name  Ranges in Excel
6.Create a Custom Name in Excel
7. Excel Pivot Tables
8. The LOOKUP Function
9. The VLOOKUP Function in Excel
10. Searching with MATCH and INDEX
11.Create a Excel Business Invoice

Part 8 - Advanced Excel                                                                                                                                                                                          
1. How to Create an Excel Template
2.Data Forms in Excel
3. Drop Down Lists in Excel
4. Add your own Error Messages
5. Array Formulas Intermediate Excel
6. Frequency Distribution Intermediate Excel
7. Excel and Web Integration
8. Hyperlinks in Excel
9. Object Linking and Embedding
10. Insert Drawing Objects

11. Customizing common options in Excel
12. Absolute and relative cells
13. Protecting and un-protecting worksheets and cells- Using logical functions (AND, OR, NOT)
       VlookUP       with Exact Match, Approximate Match
14. Nested VlookUP with Exact Match
15. VlookUP with Tables, Dynamic Ranges
16. Nested VlookUP with Exact Match
17. Using VLookUP to consolidate Data from Multiple Sheets ~ Specifying a valid range of values for a cell
18. Specifying a list of valid values for a cell
19. Specifying custom validations based on formula for a cell
        -Designing the structure of a template
20. Using templates for standardization of worksheets~ Sorting tables
21. Using multiple-level sorting
22. Using custom sorting     
23. Filtering data for selected view (AutoFilter)
24. Using advanced filter options

Part 9 - Working with Reports  

1.    Creating subtotals
2.    Multiple-level subtotals
3.    Creating Pivot tables
4.    Formatting and customizing Pivot tables
5.    Using advanced options of Pivot tables
6.    Pivot charts
7.    Consolidating data from multiple sheets and files using Pivot tables
8.    Using external data sources
9.    Using data consolidation feature to consolidate data
10.    Viewing Subtotal under Pivot                                                                                                                                                                     Using auto formatting option for worksheets
11.    Using conditional formatting option for rows, columns and cells  

Part 10 - Charts

1.    Using Charts
2.    Formatting Charts
3.    Using 3D Graphs
4.    Using Bar and Line Chart together
5.    Using Secondary Axis in Graphs
6.    Sharing Charts with PowerPoint / MS Word, Dynamically
7.    (Data Modified in Excel, Chart would automatically get updated) 

Part 11 - WhatIf Analysis

1.    Goal Seek
2.    Data Tables
3.    Scenario Manager 

Part 12 - New Features Of Excel

1.  Sparklines, Inline Charts, data Charts
2.  Overview of all the new features




MS Word is software used for word processing. It is part of the Microsoft Office Suite. You can use MS Word to write letters, memos, reports, essays and any other documents you wish. You can also create documents for the web and also create tables.

Getting started with Word
Starting Word
Understanding the start screen
Creating a new blank document
The word screen
How Microsoft Word works
Using the ribbon
Showing and collapsing the ribbon
Understanding the backstage view
Accessing the backstage view
Using shortcut menus
Understanding dialog boxes
Launching dialog boxes
Understanding the quick access toolbar
Adding commands to the QAT
Understanding the status bar
Exiting safely from Word

Creating documents in word
Typing text
The save as place
The save as dialog box
Saving a new document on your computer
Typing numbers
Inserting a date
Document proofing
Checking spelling and grammar
Making basic changes
Saving an existing document
Printing a document
Safely closing a document

The open place
The open dialog box
Opening an existing document
Navigating with the keyboard
Scrolling through a document
Page zooming
Viewing the ruler
Showing paragraph marks
Counting words

Viewing documents
Viewing multiple pages
Splitting the window
Opening a new window
Understanding document views
Changing document views
Understanding read mode
Viewing a document in read mode
Using resume reading

Working with text
Techniques for selecting text
Selecting text using the mouse
Selecting text using the keyboard
Editing text in insert mode
Editing text in overtype mode
Deleting text
Using undo
Using redo
Understanding find and replace
Finding words
Replacing words
Using go to
Understanding cutting and copying
Cutting and pasting
Copying and pasting
Drag and drop cutting
Drag and drop copying
Using the clipboard task pane

Text appearance
Understanding font formatting
Understanding font formatting tools
Working with live preview
Changing fonts
Changing font size
Increasing and decreasing font size
Making text bold
Italicising text
Underlining text
Highlighting text
Changing text colour
Using the format painter
Using the font dialog box
Clearing font formatting

Working with paragraphs
Understanding paragraph formatting
Understanding text alignment
Changing text alignments
Changing line spacing
Changing paragraph spacing
Indenting paragraphs
Outdenting paragraphs
Starting a bulleted list
Adding bullets to existing paragraphs
Removing existing bullets
Starting a numbered list
Numbering existing paragraphs
Removing existing numbers
Shading paragraphs
Applying borders to paragraphs
Using the paragraph dialog box

Working with pages
Changing page margins
Setting custom margins
Changing page orientation
Changing paper sizing
Setting custom paper sizes
Inserting page breaks
Removing page breaks
Inserting page numbers
Formatting page numbers
Removing page numbers

Tabs and tables
Using default tabs
Setting tabs on the ruler
Modifying tabs on the ruler
Setting tabs in the tabs dialog box
Setting tab leaders
Setting bar tabs
Setting mixed tabs
Removing tabs
Understanding tables
Creating a table
Adding data to a table
Selecting in tables using the ribbon
Selecting in tables using the mouse
Inserting columns and rows
Deleting columns and rows
Changing column widths
Changing row heights
Autofitting columns
Shading cells
Modifying borders
Adding custom borders
Choosing a table style

Clip Art and pictures
Understanding clip art and pictures
Inserting clip art
Selecting clip art
Applying text wrapping styles
Positioning clip art
Resizing clip art
Applying picture styles to clip art
Resetting clip art
Deleting clip art
Inserting a picture
Inserting an online picture
Resizing a picture
Changing the picture
Cropping a picture

Performing a mail merge
Understanding mail merge
Understanding the mail merge process
Creating a recipient list
Creating the starting document
Starting the mail merge wizard
Selecting a recipient list
Inserting mail merge fields
Previewing the merged documents
Completing the merge

Printing your documents
Understanding printing
Previewing your document
Quick printing
Selecting a printer
Printing the current page
Specifying a range of pages
Specifying the number of copies

Getting help
Understanding how help works
Accessing the help window
Navigating the help window
Using the office website
Googling help
Printing a help topic

A guide to brilliant documents
The four pillars of great design
Perfect page layouts
Make it readable
Pictures tell a story
The tips and traps of writing



Certificate will be provided after completion of the course

Creating Presentation
Adding New Slides
Adding Text in Boxes
Adding New Text Boxes
Deleting Existing Slide
Rearranging Slides
Adding Slide Notes
Working with Outlines
Presentation Views
Setting Backgrounds
Slide Orientations
Saving Presentation
Reviewing Presentation
Adding Slide Numbers
Adding Header & Footer
Running Slideshow
Keyboard Shortcuts
Getting Context Help

Copy & Paste Content
Find & Replace Content
Undo Edited Changes
Spell Check
Content Translation
Setting Language Type
Duplicating Content
Special Characters
Slides Zoom In-Out

FORMATTING PRESENTATION                                                                                                       
Font Management
Setting Text Fonts
Text Decoration
Changing Text Case
Changing Text Size
Changing Text Color
Text Alignments
Indent Paragraphs
Setting Line Spacing
Borders and Shades
Apply Formatting
Using Slide Master
Saving Design Template

Adding Pictures to Slide
Editing Added Pictures
Formatting Added Pictures
Inserting a Screenshot
Adding Shapes to Slide
Editing Added Shapes
Formatting Added Shapes
Adding Text to Shapes
Arranging Shapes/Images
Grouping/Ungrouping Objects
Adding Audio & Video
Adding & Formatting Tables
Adding & Formatting Charts
Adding & Formatting SmartArt
Adding & Previewing Animations
Adding & Previewing Transitions

Creating a PDF File
Creating a Video File
Creating an Image File
Printing Presentation
Broadcasting Slideshow
Packaging Presentation
Setting Document Password
Emailing Slideshow

  • Start: Aug. 24, 2020
  • Package Duration: 40 Days
  • Seats Available: 80
  • Total Classes: 40
  • Time: 7 p.m. - 8 p.m.