Microsoft Office Course
Windows
Getting Familiar with Windows Versions Desktop – Folders, Icons Wallpaper, Screen Savers, Display Settings/personalize, Date And Time, Wordpad, Notepad Applications, Paint, Checking System Configurations.
Microsoft Word
Introduction to word document home – paragraphs, formatting document, increasing font size, font style color, change 0case, bold, italic, underline, Strikethrough, line spacing, drop cap, find and replace, Bullets/Numbering Alignments, Text Highlighter Insert – table, picture, shapes, chart, smart art, header, Page No., footer, Word art. Page layout – Themes, watermark, page color, Page border Equation / Symbols, Hyperlink page border, Set password =Rand ()
Microsoft Excel
Getting Familiar With Excel Add/delete/rename Sheets Auto Fill/auto Fit/ Auto Sum/total/percentage Merge And Center Date And Time / Comments Chart / Graph, Date & Time, Comment Set Password.
Microsoft Powerpoint
Introduction / Use Of PowerPoint Presentation, Home Tab: Title Only, Title And Content, Picture, Picture Clip Art, Table, Smart Art, Shapes Themes, Design And Background Animation – Custom Animation Or Transition Effect To The Slides Automatic Time Setting Set Password.
Microsoft Access
Introduction
Blank Database
Create Table Design
Report / Auto Format
Saving The File With Password
Internet
Introduction To Internet
Browsing Information
Saving Images ,Copy And Paste Images / Text
Introduction To Email
Creating New Email Id
Log Into Mail Id
Sending And Receiving Mails/ Attaching Files
Deleting Mails / Account Settings / Password/
Move Files From Inbox to Folders
Basic & Advanced Excel Course
To create, Modify, Analyze, and Present Data in Excel understand formulas, Charts, Graphs & Other tasks.
Basic Excel
Dur: 05 hrs / 1 month Certified Program Student database
Percentage Rank Total
Add/delete/rename and hiding the sheets
Understanding cell address The maximum number of columns
and rows Auto fill/ auto fit / auto sum
auto format/ defaults limits Creation Of Database
Graphical Representation Of Database- Chart
Forms, Sorting Database Comments, Merge And Center
Working With Date And Time Format Cells
Number/ Alignment/ Borders/ Fill/ Freeze Panes / Page
Setup/page break preview Printing Of Database
Advanced Excel
Dur: 10 hrs / 1 month Certified Program Working with payroll database Uppercase, Lowercase, Trim, Repeat Proper, Roundup, Round Down Custom List Data Hyperlink With a document (From Text / Hyperlink) Concatenate Sort / Filter / Advanced Filter Remove Duplicates Pivot table and pivot chart, Pie Chart Chart-Layout -Data Label-Inside End Filter records Macro using the keyboard shortcut Protect sheet and workbook Hyperlink
Mathematical expression Importing text file Remove duplicate Conditional formatting Round up Subtotal What if Analysis /Goal seek /Scenario Data Validation /Clear Validation Page break and print preview Customizing data
Text to column
Hlookup
Vlookup
Countif
offset
Choose
PMT