Office Automation with MS Office 2016 using Excel, Word, Power Point & Access database. 3 x 10 days 30 Hrs Rs. 5,000
These Courses are designed for Undergraduate Students
a) Microsoft Windows
·         Introduction to Windows
·         Desktop Properties (Screen Saver, Wall Paper etc)
·         Working with Shortcuts & Folders
·         Working with Windows Explorer
·         Working with Control Panels
·         Working with Accessories (Paint, Word Pad etc)
·         Working with Device Manager
·         Installing Printers & Modem
b) MS-Word (Word Processing)
Class 1 – MS Word Home Ribbon
1 – Creating Microsoft Office Document for al Business
2 – Underline text
3 – Change text formatting
4 – Find and replace text or other items
5 – Heading
6 – Create a bulleted or numbered list
7 – Create a multilevel list
8 – Change the bullet or number formatting
9 – Add picture bullets or symbols to a list
Class 2 – MS Word  Insert Ribbon
1 – Working with graphics and charts > Adding charts, diagrams, or tables
2 – Draw or delete a line, connector shape
3 – WordArt, or clip art
4 – Change the spaces between text
5 – Changing  spacing or alignment
6 – Creating specific documents > Forms
7 – Use titles on a chart
8 – Working with graphics and charts > Adding charts, diagrams, or tables
Class 3 – MS Word Page Layout Ribbon
1 – Page breaks and section breaks
2 – Change the horizontal alignment of text on a page
3 – Add, change, or delete shapes
4 – Double-space the lines in a document
5 – Formatting text > Change spacing or alignment
6 – Add a Watermark or Background
7 – Add Borders, Shading, and Styles
8 – Work with Building Blocks
9 – Format your Document with Styles
10 – Formatting a Margin
Class 4 – MS Word Mailing Ribbon
1 – Create and print labels for a mass mailing
2 – Create and print envelopes for a mass mailing
3 – Use mail merge to create and print letters and other documents
4 – Create and print labels for a single item or address
5 – Saving and printing > Envelopes and labels
6 – Use mail merge to send personalized e-mail messages to your e-mail address list
7 – Create and print a single envelope
8 – Saving and printing > Envelopes and labels
9 – Field codes: IF field
10 – Mail merge > Mail merge fields
11 – Field codes: SKIPIF field
12 – Mail merge > Mail merge fields
13 – Field codes: NEXTIF field
14 – Mail merge fields
15 – Create and print a sheet of different labels
16 – Automation and programmability > Field codes
17 – Set the rules for a mail merge
Class 5 – MS Word References Ribbon
1 – Insert or delete a footnote or an endnote
2 – Create a bibliography
3 – Create a table of contents
4 – Convert footnotes to endnotes and vice versa
5 –  Add or delete bookmarks
6 – Tables of contents and other references
7 – Restart footnote or endnote numbering from
8 – Enable or disable add-ins in Office programs
Class 6 – Summary of MS Word Topics
1 – ·         Features of MS Word
2 – ·         Working with Menus & Icons
3 – ·         Customizing Menus and Toolbars
4 – ·         Document Formatting
5 – ·         Word Art
6 – ·         Style & Style Gallery
7 – ·         Mathematical Formulas
8 – ·         Find & Replace
9 – ·         Grammar & Thesaurus
10 – ·         Working with Tables
11 – ·         Index & Document Protection
12 – ·         Mail Merging
13 – ·         Drawing Objects & Graphics with 3D
14 – ·         Working with Macros
c) MS-Excel (Spreadsheet)
Working with MS-Excel Worksheets
1 – Insert a row
2 – To delete a row
3 – Undo
4 – copying a range of cells
5 – Moving a range of cells
6 – Using paste special
7 – Clearing cell contents
Writing formulas
1 – Constructing formulas
2 – Using operators (+,-,x, ¸,etc…)
3 – Using references
4 – Tips on entering formulas
File operations
1 – Saving workbooks
2 – Save as…
3 – Save
4 – Closing workbooks
5 – Deleting workbooks
Printing worksheets
1 – Using print preview
2 – Page setup
3 – Header and footer settings
4 – Margin settings
5 – Turning the gridlines on or off
6 – Turn the row/column heading on or off
7 – Auto scaling printout
8 – Setting manual page breaks
9 – Setting row or column titles
10 – Setting print area
Useful functions
1 – SUM( )
2 – AVERAGE( )
3 – MAX( )
4 – MIN( )
5 – IF()
6 – Count()
Tips in editing a worksheets
1 – Paste insert row/column
2 – Drag and drop
3 – Autofill
4 – Fill down
5 – Fill right
Understanding address notations
1 – Relative address
2 – Absolute address
Polishing worksheets
1 – Adding border
2 – Adjusting row heights and column widths manually
3 – Adjusting row heights and column widths automatically
4 – Setting text alignments ( horizontal and vertical )
5 – Setting text orientations
6 – Shading cell background
7 – Font settings
8 – Number format
9 – Adding thousand separator
10 – Adding currency sign number
11 – Adding decimal points
Creating a master spreadsheet
1 – Creating document templates
2 – Using document templates
3 – Exchange files with other applications
4 – Understanding various Excel file formats
5 – Saving workbook for backward compatibility
6 – Exporting excel workbook for other software
Styles
1 – Creating styles
2 – Using styles
3 – Editing styles
4 – Merging styles from other workbooks
5 – Data sorting
6 – Drawing
7 – Inserting shapes
8 – Drawing lines, rectangles, ovals etc.
Charting
1 – Inserting various kinds of chart – column, line, bar and pie chart
2 – Adding and modifying chart’s elements
3 – Chart title, Legend, Axis, Grids, Data table, Data label
4 – Polishing charts
5 – Adding special effects to chart elements
6 – Filling charts with gradients or pictures
7 – Using Layout tab
8 – Filling charts with gradients or pictures
Summary of Excel Sheets Topics
1 – ·         What is Spread Sheet ?
2 – ·         Introduction to MS Excel
3 – ·         Features of MS Excel
4 – ·         Working with Worksheets
5 – ·         Working with Menus & Icons
6 – ·         Customizing Menus and Toolbars
7 – ·         Cell Formatting
8 – ·         Writing Formulas
9 – ·         Sorting
10 – ·         Filters
11 – ·         Worksheet Protection
12 – ·         Working with Function wizard
13 – ·         Built-in Macros
14 – ·         Charts
15 – ·         Graphics & Drawing Toolbar
d) MS-Power Point (Graphics Presentation)
Class 1 – MS Power Point Home Ribbon
1 – Slides
2 – Change slide formatting
3 – Find and replace text or other items
4 – Heading
5 – Create a bulleted or numbered list
6 – Create a multilevel list
7 – Change the bullet or number formatting
8 – Add picture bullets or symbols to a list
Class 2 – MS PowerPoint insert Ribbon
1 – Working with graphics and charts > Adding charts, diagrams, or tables
2 – Draw or delete a line, connector shape
3 – WordArt, or clip art
4 – Change the spaces between text
5 – Changing  spacing or alignment
6 – Creating specific documents > Forms
7 – Use titles on a chart
8 – Working with graphics and charts > Adding charts, diagrams, or tables
Class 3 – MS PowerPoint Ribbon
1 – Slide  breaks and section breaks
2 – Change the horizontal alignment of text on a page
3 – Add, change, or delete shapes
4 – Double-space the lines in a document
5 – Formatting text > Change spacing or alignment
6 – Add Borders, Shading, and Styles
7 – Work with Building Blocks
8 – Format your Document with Styles
9 – Formatting a Margin
Class 4 – PowerPoint Using Outline View
1 – Create content using the Outline View
2 – Update, delete and modify text in the Outline View
3 – Promote and Demote slides using shortcut keys
4 – Move slides and text outlines using the right click mouse menu
5 – Import presentation content from a word document
6 – PowerPoint Slide Masters
7 – Work in the Slide Master view using the Slide Master Tab
8 – Create a consistent looking Presentation using Slide Master
9 – Edit and customize an existing design template
10 – Work with templates to apply designs and modify existing templates
11 – Create new templates from the beginning
12 – Insert graphics into the Master Slides
13 – Customize the Handout and Notes Master
14 – Technology assignments listed at this site utilize a distance learning approach in the delivery of instruction.
Class 5 – Summary Topics – PowerPoint
1 – ·         Features of Power Point
2 – ·         Working with Menus & Icons
3 – ·         Customizing Menus & Toolbars
4 – ·         Templates, Clip Art
5 – ·         Charts & Objects
6 – ·         Slide Show
7 – ·         Slide Sorter / Notes
8 – ·         Slide Transitions
9 – ·         Sound and Animations
e) MS-Access (Database)
1 – ·         Introduction to Database
2 – ·         Introduction to RDBMS
3 – ·         Creating tables
4 – ·         Applying Constraints
5 – ·         Query builder
6 – ·         Form Wizard
7 – ·         Report Wizard
f) – Internet
1 – ·         What is Internet
2 –           Technologies used in Internet
3 – ·         World Wide Web, Terminologies
4 – ·         Connecting to the Internet
5 – ·         Email System and its working
6 – ·         Web Browsers
7 – ·         Chatting Concept