Advance It Professional (AIP)

Course Contents:

Introduction ☛ what is Computer, Use of Computer, Full form of Computer & etc.

Windows ☛ Paint, Notepad, WordPad, New page, cut, copy, Paste, Save, open, print, & many more...

Microsoft Word ☛ Word how to Make a Document, Like Later, Bio-data, Application Later, Agreements, Creating, editing, saving and printing text documents, Font and paragraph formatting , Simple character formatting, Inserting tables, smart art, page breaks , Using lists and styles , Working with images, Using Spelling and Grammar check , Understanding document properties , Mail Merge, Projects & many more...

Microsoft Excel ☛ How to make Salary Report, Attendance, Profit Loss, Data Record, A first look at Excel, Excel Rows and Columns, Enter text and numbers in a Cell, How to Edit text in a Cell, How to Centre text and numbers, Font Formatting in Excel, How to change the color of a Cell, How to Save your work in Excel, Currency Symbols in Excel, How to Merge Cells, Review Number , How to use AutoFill, Entering Simple Addition Formula, The SUM Function in Excel, The SUM Function Continued, How to use Paste Special, How to Multiply, Finishing your spreadsheet for this section, How to Add a Comment to a Cell, How to Sort Data in Excel, Create an Excel Chart, Move and Resize your Chart, Chart Styles and Layouts, Chart Titles and Series Titles, Chart Layout Panel, The Format Chart Panel Create a Pie Chart in Excel Combining the Arithmetic Operators, A Budget Spreadsheet, The Average Function, The Date Function, Time Functions in Excel, A Timetable Project, Financial Functions, The Student Averages Project, The IF Function, Conditional Formatting in Excel, Count IF, Sum IF, Data Tables in Excel, Excel Scenarios, Goal Seek, Absolute Cell References, Named Ranges in Excel, Create a Custom Name in Excel, Excel Pivot Tables, The LOOKUP Function, The VLOOKUP Function in Excel, Create a Business In voice, Data Forms in Excel , Drop Down Lists in Excel, Add your own Error Messages, Excel and Web Integration, Hyperlinks in Excel, Object Linking and Embedding, Definition and use , Record a macro, Assign a macro , Run a macro, Insert Drawing Objects, Projects & Many More...

Microsoft PowerPoint ☛ Creating presentations using Auto Content Wizard, Different views in PowerPoint (Normal, Sorter, Outline, Notes Page, Slide Show), Saving, opening, and closing presentations, Using title slide, Using bullets and pictures, Creating tables, Creating chart, Slide Formatting, Paragraph alignment, Line spacing, Bullets and numbering, Slide color schemes, Background colors Applying preset animation/animation scheme for slides Custom animations, Slide transitions, Rehearse timing for slides, Working with media files, The Drawing Toolbar, Using WordArt, Line and Fill Color, Using AutoShapes, Applying 3-D effects to objects, Object alignment and rotation, Grouping and ungrouping, Side master and title master, Adding a logo and custom bullets in slide master, Delivering Presentations, Using the action button, Working with hyperlinks using Word, Excel, and Internet, Delivering presentations using custom show, Saving a PowerPoint Presentation with different extension, Creating a complete pack of a presentation, Projects & many more...

Internet Operation ☛ Creating E-mail-id, Sending, Mail, Send attachment document, Checking Mail, Inbox, Outbox, Draft, how to Search any information, Images, Song, Video Downloading & many more…

Getting Functional with Tally.ERP 9 ☛ Company Info, Set-Up of Accounts, Inventory / Items & Goods/Stock, Features of Tally.ERP 9 and Their Uses ( F11), VAT (Value Added Tax), Accounting Vouchers in Tally.ERP 9, Advanced Inventory Vouchers in Tally.ERP 9, Advanced Usage Vouchers in Tally.ERP 9, Tally.ERP 9 Reporting, Bills of Materials (BOM), Service Tax, Interest Calculations, Voucher Classes & Voucher Types ( Creations), Point of Sale ( POS Invoicing ), CTCS ( Tax Collected at Source), FBT ( Fringe Benefit Tax ), EXCISE DEALER in Tally.ERP 9, PAYROLL, Short-Cut Keys & etc.,

Graphic Designing ☛ is a popular graphic design application that is used to create illustrations, page layout, web graphics, logos, advertisements, Also students & professionals will be using advanced tools for creating drawings, advanced techniques for text manipulation, advanced output options for printing etc. The course will cover the basics of computer illustration, introduce the student to the tools, how to use them, how to work with objects, clip art, text, color, special effects, gradient meshes, masks and blends. Special focus lectures provide in depth menu studies of the more difficult-to-use tools, and students will receive instruction in basic art principles.
the premiere image manipulation tool for print design, Web design, and photography. It's a must-know if you're planning to work with photos or design projects at any level.

Website Designing ☛ MGS Computer Academy providing wed designing courses. Is a dedicated division for Students & Professionals wanting to make a Career in Web Designing. It is one of the best web designing Computer Academy. We specialize in Internet Web Page Training.
What is the full form of html and CSS., What is internet, Overview of Web Browser, URLs (Uniform Resource Locator), World Wide Web (www), HTML Tools, Writing Tools, Structure of an HTML document, Basic tags and Attributes, Body Attributes, Text attributes, Marquee tag & its attributes, Headings, Font, Paragraph, Line Break, Ordered and Unordered Lists, Block quote, Image formats, Image attributes, Alignment of images, Create a table, Combine cells in a row or column, Create a form, Accept input and Submit. HTML and CSS are the codes for writing web pages. HTML tags format the document and adds functionality. For example, the headline of your site can use the headline tags and so forth.

Web Development☛ The web developer's course contains HTML, CSS, JavaScript, Php & Mysql, Ajax, Jquery, CakePHP, Twitter Bootstrap Framework.
JavaScript Output • JavaScript Variables • JavaScript Operators • JavaScript Arithmetic • JavaScript Data Types • JavaScript Assignment • JavaScript Functions • JavaScript Objects • JavaScript Scope • JavaScript Events • JavaScript Strings and String Methods • JavaScript Numbers and Number Methods • JavaScript Math Facebook.
Installing PHP, PHP Syntax, PHP Variables, PHP Data Types, PHP Strings, PHP Constants, PHP Operators, PHP Programming Loops, PHP Functions, PHP Arrays o PHP Superglobals • PHP Forms and XML, PHP Form Handling, PHP Form Validation (Server side), PHP Required, PHP XML Parsers, PHP SimpleXML Parser, PHP SimpleXML Get, PHP XML DOM, PHP XML Expat
CSS Tables • CSS Box Model • CSS Margins, Dimensions, Display • CSS Navigation Bar • CSS Attribute Selectors CSS Rounded Corners • CSS Border Images • CSS Backgrounds • CSS Colors • CSS Animations • CSS Responsive Web Design - Introduction • CSS Responsive Web Design - Viewport • CSS Responsive Web Design - Media Queries • CSS Responsive Web Design - Images • CSS Responsive Web Design - Videos • CSS Responsive Web Design - Frameworks
MySQL Open source has brought a lot more than UNIX to the computing world. It has also given us Linux, MySQL. MySQL are the world's best combination for creating database-driven sites. MySQL software can be downloaded in less than 15 minutes.MySQL runs on more than 20 platforms, including Windows, Mac OS X, and Linux, and its open source code allows you to customize it to fit your unique requirements. Whether you're looking to post a few things a month to your Web site or looking to add content daily, MySQL is fit to handle Web sites large and small and will easily grow as your business does.

Hardware ☛ Computer hardware is the physical parts or components of a computer, such as the monitor, keyboard, computer data storage, hard disk drive (HDD), graphic cards, sound cards, memory (RAM), motherboard, and so on, all of which are tangible physical objects. Hardware may refer to: Household hardware, equipment such as keys, locks, hinges, latches, handles, wire, chains, plumbing, tools, utensils, and machine parts ... Abbreviated as HW, Hardware is best described as any physical component of a computer system that contains a circuit board, ICs, or other electronics. ... The picture is a Logitech webcam, an example of an external hardware peripheral. ... Below is a list of external hardware and internal ... Computer hardware refers to objects that you can actually touch -- like disks, disk drives, display screens, keyboards, printers, boards, and chips.

Course Outline ☛

• CMOS, BIOS
• Formatting, Installation
• Operating System
• Installation Application Software
• Assembling of Compute

Video & sound Editing☛ Students at MGS Computer Academy are trained professionally and also artistically so that they can think what part of the movie should be included or what part should be exclude. We offer training on the latest software. Students will be taught the basic to advance of video editing for film and televisions. Video editing is the process by which we can edit the different segments of video footage, special effects and sound recordings. MGS Computer Academy of Computer Courses is a well-known institute offering video editing course in MGS Computer Academy. We are renowned name in the field of providing top-quality courses and students can really trust upon us. We provide knowledge of video editing to students and helped them to shape their career in the field of video & sound editing.

Software Development
C Programming ☛ C is a general purpose Programming Language. C has proven to be a pleasant, powerful, and versatile language for a wide variety of Programs. Many of the modern languages like C++, Visual C++, Java, JavaScript, etc. are based on C Language. Therefore, not knowing this Language is considered as a handicap. 90% of UNIX Operating System is written in C Language.

C++ Programing ☛ C++ is an object oriented Programming language which includes concepts like polymorphism, data-hiding, operator overloading, encapsulation and inheritance, which are not observed in C. User defined objects (instances) can be reused with and without modifications to generate new applications. This reduces coding to a great extent. Even for file accessing, we use file objects.

Java Core & Advance☛ Java is platform independent, portable and can run unmodified on all supported platforms, such as Windows or Linux. Java use the JVM or Java virtual Machine and do not access the operating system directly. Java source code is written in an Integrated Development Environment (IDE).An IDE supports in the task of writing code, e.g., auto-formatting of the source code, highlighting of the important keywords, etc.

C#.NET: ☛ The Internet has revolutionized the way organizations think about application development and deployment. The leap from traditional client-server development to web base development takes more than accessing data through a browser. ASP.NET helps to develop web-based applications with high performance and scalability. Develop web-based applications using ASP.NET Apply client-side and server-side programming, DHTML, scripting. Analyze the performance issues involved in developing applications on the net. Evaluate the use of client-side scripting vs. server-side scripting. Develop applications using ASP.NET, XML and databases. Obtain and process information about server, clients, and users. Keeping track of client interactions.

Sql ☛ SQL Server is the Database Management System (RDBMS) that allows to store huge Databases and manage the same easily. It is an enterprise database management and analysis system.

• Understanding Query Flow .Syntactical Flow of the Query Statement
• Logical Flow of the Query Statement
• From Clause Data Sources
• Possible Data Sources
• Named Ranges
• [Table Name]
• Four-Part Table Names
• XML Data Type
• Querying XML Data
• Merging XQuery with Select
• Reading XML into SQL Server
• Creating XML with SQL Server 2005