Fundamentals of Computer (Vol-1)

Introduction • Typing • MS Paint • Internet • Window 7
Introduction, Intro About tab, Bookmark, Hyperlink and cross, Group, Office Button, Quick Access Reference Footnote, Toolbar, Paragraph, Alignment and Citation and Captions, Bordering, Finding and Replacing, Complete mail Merge, Table, Designing and Setting, Document View and Setting Header, Footer, Page Setup, Assignments after every Chapter, Projects

Fundamentals of Computer (Vol-2)

MS WORD

Introduction, Intro About tab, Bookmark, Hyperlink and cross, Group, Office Button, Quick Access Reference Footnote, Toolbar, Paragraph, Alignment and Citation and Captions, Bordering, Finding and Replacing, Complete mail Merge, Table, Designing and Setting, Document View and Setting Header, Footer, Page Setup, Assignments after every Chapter, Projects

MS EXCEL

Introduction, Wrapping and Merging, Number Formatting, Conditional Formatting, Paste Special, Data Validation, IF Function, OR Function, Sumif, Engineering Function, Workspace, Loan, PMT, PPMT, IPMT, FV, PV, Basics of V lookup and H lookup, Working with Chats, inks, Text to Columns, Basic Formulas, Data Filter, Formatting tables.

POWER POINT

Introduction, Use of Powerpoint, Modifying an existing Presentation, Pictures and Shapes, Tables, Charts, Word Art, Animating a Presentation, Notes and Misc., Creating own Animation. Extra Effect-Sounds

Advance Excel and PDP Classes

Advance data Validation, Advance Database Function, Cell Reference, Protection, Advance V Lookup and H lookup, with Absolute Cell, Loan Calculation, Advance Tax Function, Pivot table and Pivot Chart. Formula Auditing IF, Count IF, Average, IFS, Advance SUM and More, Live Project with Live Database, MIS Reporting, Updated Study Material…… Resume Writing, How to Face Interview, Interview Question, How to communicate.