Job Oriented Training :”e-Accounting” in Delhi-NCR

e-Accounting :Best Career Option in the field of Accounting & Finance

Financial E-Accounting Course is an important course which helps the freshers/experienced accountants to understand and improve their professional skills. This course covers all major aspects of a business activity for the various industries like “accounting, inventory, manufacturing, taxation , banking and payroll etc. Now in Today World Computer Accounting Softwares and Server Based Accounting Portals have been used to perform several functions that were done manually with better speed efficiency and accuracy.

This training program is very beneficial for students who have completed 12th in commerce, B.Com (Graduate), MBA and also for whom who want to start their career as accounting professionals. It is designed to equip them with valuable skills, a graduate after this training becomes valuable asset for any company. During this course we focus on the pratical learning aspects of computer accounting software like Tally ERP and Busy , Taxation software like: Spactrum and Webtel, Payroll software like Pay-Soft.

Course Contents

Duration : 10 Months /5 Months [Fast Track] | Classes: Mon-Sat, 1½ Hrs./day

• Module 1: (Computer Fundamentals & MS-Office)
  • Computer Hardware & Software, Windows 7/8/10.
  • MS-Office : Word, Excel, PowerPoint, Access & Outlook.
  • Internet Concept, Surfing, Mailing & Social Media.
  • Using PC Tools: WinRar, PDF Readers, Teamviewer, Skype.

• Module 2: (Advanced Excel / MIS)
  • About Excel 2010/13, Tabs & Ribbons, Workbook, Workspace & Sheets.
  • Cell Referencing: Relative, Mix & Fix, Creating & Formatting Options.
  • Conditional Formatting, Data Sorting & Searching, Filter & Data Validation.
  • IF Conditions, Vlookup, Hlookup, Index, Match, Sumproduct, Text Functions.
  • What if Analysis, Text to Columns, Consolidate, Subtotal, External Data.
  • Freeze Panes, Print Setup, Share Workbook, Security Features etc.

• Module 3: (Financial Accounting)
  • Accounting Fundamentals, Accounting Terms, Principals & Equations.
  • Accounting Cycle & Golden Rules of Accounting, Journal Entries & Ledger
  • Subsidiary Books, Cash Book, BRS, Depreciation & Error Rectifications.
  • Final Accounts: Trial Balance, Balance Sheet and Profit & Loss A/c.
  • Practical Accounting Vouchers and Documentation.

• Module 4: (E-Commerce)
  •  E-Commerce, Using Job Portals, Online Shopping, Ticketing & Payment.
  •  Accessing Government sites and services, Employment Registration etc.
  • Online Application for : Pan Card, Voter ID, UID Etc.
  • Surfing Internet, Downloading Apps, Software, Music , Games & E-Books

• Module 5: (Tally.ERP9- Complete Business Accounting)
  • About Tally.ERP9 : Latest Updates, Installation, Company Setup & Features.
  • Creating Masters: Groups, Ledgers, Cost Centre, Stock Details, Budgets etc.
  • Passing Transactions/ Voucher Entries: Payment, Rcpt, Contra Journal etc.
  • Sales/Purchase Order Process Entries, Making Challans, Rejection & Billing.
  • About TDS, TDS Entries & Challans, VAT & CST, Voucher Type & Classes.
  • Automatic Interest Calculation, Cheque Printing, BRS and Discounts.
  • Service Tax Entries, Dealer Excise Setup and Transactions, Vat on CG.
  • Payroll Setup, Payroll Masters, Pay Heads & Dept., Attendance & Pay Slip.
  • MIS Reports, Print Setup, Import-Export, TallyODBC, Backup Restore etc.

• Module 6: (Busy- Business Accounting Software)
  • Installing Busy Software, Company Setup, Creating Inventory Masters.
  • Passing Day-Wise Transactions : Payment, Receipts and Credit Entries.
  • Sales/Purchase: Vat Invoicing(Tax & Retail), Tax Inclusive MRP Billing etc.
  • Service Tax & TDS Setup and Transactions, BoM & Manufacturing Entries.
  • Sales Tax/VAT Reports, MIS Reports and Analysis, Utilities & Controls.

• Module 7: (Marg Inventory & Accounting Software)
  • Introduction to Pharma Industry & Marg Inventory Software.
  • Marg Installation and Company Creation, Features in Marg.
  • Creating Masters, Passing Voucher Entries, Reports in Marg.
  • Bar Code, E-Mail & SMS Setup, DATA Import & Export.
  • Marg on Net, Print Setup & Cheque Printing.
  • Marg Utilities, Multi Firm Billing, Budgets &Targets.
  • Advanced Inventory System, Order Processing & Point of Sale(PoS).
  • Supplier wise Company, Changing Operator Power & Sales Analysis.

• Module 8: (Taxation)
  • Direct Tax
  • Basic Concepts of Income Tax.
  • Heads of Income and Slab Rates.
  • Income from Salary, House Property, Business, Profession, Other Sources.
  • Capital Gain , Deduction under U/A.
  • Agricultural Income, Return of Income, Advance Tax & TDS.
  • Indirect Tax
  • Value Added Tax(VAT)
  • Central Sales Tax(CST)
  • Service Tax
  • Central Excise Duty
  • About Goods & Services Tax (GST).

• Module 9: (E-Filing)
  • Income Tax Returns.
  • TDS e-Filing. | VAT e-Filing. | Service Tax e-Filing.
  • Using Software : Spacturam, WebTel & TDSMAN.

• Module 10: (Personality Grooming)
  • Resume Writing : Resume Types, Fresher Resume, Professional Resume.
  • Persoality Development : Interview Preparation, Self Motivational Classes, Typing Test, Communication Skills, Confidence Building, Interview Tips.

For More Details please visit : http://www.dga-edu.com/e-accounting.html or mail us: info@dga-edu.com

Best Website Designing Training Institute in Delhi-NCR

Learn to make Responsive Website with HTML5, CSS3, Bootstrap & PHP

Website Designing

Website Designing Course Due to mass use of Internet Business, Education, Entertainment, Communication, Security and almost all sectors are now dependent on online means web. To make a business, education entertainment or communication or any sector based on online you need to make a good website Nowadays businessman, entrepreneur or different institution are finding skilled web designer to make nice website for them. So now it has become a big local and international market. Even from living in India you can also get scope to collect different web-design related works from local or international market.

But first all you need to learn how to design a website. You can learn that by searching on internet or by reading different kinds of books. But to learn practically you must need to learn that from any web design training center. We, (DGA Professional Institute) are offering a complete web design course.

Course Contents

Duration : 6 Months / 4 Months | Classes: Mon-Sat, 1½Hrs./day

• Module 1: (Web Designing Concepts & HTML)
  • Overview of Web Design.
  • About Browser: Chrome, Firefox etc.
  • HTML Basics, Elements & Attributes.
  • HTML T ext Formatting, Heading Styles.
  • Hyperlinks-absolute, relative & bookmark.
  • List Style, Adding Images to web pages.
  • HTML Tables : Simple & Complex.
  • HTMLForms, HTMLFrames etc.

• Module 2: (Styling a Web Page using CSS)
  • Introduction to CSS.
  • Style Sheet Syntax, Selectors in CSS.
  • The DIVand SPANElements.
  • External, Internal & Inline CSS.
  • Background Techniques, Floating elements
  • CSSBox Model
  • CSS T ext & Font Properties
  • Postponing: Absolute and Relative

• Module 3: (Website Layout & Elements: Photoshop)
  • Introductions to Graphics & Photoshop.
  • Installing Photoshop & Working.
  • Working with Photoshop Tools.
  • Various Picture file formats for web.
  • Working with Layers.
  • Creating web backgrounds and Patterns.
  • Blending Mode, Opacity & Fill.
  • Creating T ext Styles effects.
  • Creating web banners & Layouts.
  • Photoshop to HTML.

• Module 4: (Dreamweaver)
  • About Dream weaver.
  • Understanding site creation process.
  • Code window, Split & Design Window.
  • Adding Spry Menu, Tabs, Accordion.
  • Adding Time line Animation in Website.
  • Insert Tags, Table, Div, Images etc.
  • Using Dreamweaver Tools.
  • Adding Frames & Bahivours.
  • Preview & Debug in Browsers.
  • Setting your preferences.

• Module 5: (Advance Web Designing: HTML5, CSS3)
  • Introduction to HTML5 & CSS3.
  • New Features in HTML5.
  • The Canvas Element.
  • Media Playback : Audio and Video.
  • New Content Specific elements.
  • Article, Header, Footer , Nav , Section.
  • New Form Controls in HTML5.
  • Calender, Date & Time, Url & Search.
  • HTML5 T empletes.
  • What’s New in CSS3.
  • CSS3 Background and Boarders.
  • CSS3 T ext Effects & Fonts.
  • CSS3 Shapes.
  • CSS3 Fill Effects, Gradients.
  • Transformation & 2D Effects.
  • CSS3 Animatons.
  • Clip Controls.
  • CSS3 Templates.

• Module 6: (Javascript, Jquery & Plugins)
  • Javascript Statements.
  • Writing Javascript codes.
  • Adding JSCode to Webpage.
  • Jquery Events, Effects, Popup boxes.
  • If…else.. , Switch Case & Loops.
  • Javascript Alert, Input Box, MsgBox.
  • Jquery Intro., Syntex & Selectors.
  • Javascript Form V alidations.
  • Using Time Function & Calculator.
  • Javascript Animation/SlideShow.
  • Array, Functions & Events.
  • Variables & Operators.
  • Adding Jquery to Web Page.
  • Inserting Plugins & Automation.

• Module 7: (Flash Animation)
  • Introduction to Animation.
  • Introduction to Adobe Flash.
  • Adding JSCode to Webpage.
  • Tools in Adobe Flash.
  • Time line, Type of Animations.
  • Frame-by-frame Animation.
  • Motion & Shape Tween.
  • Shape Hints.
  • Masking in Flash.
  • Creating Flash Banners.
  • Creating Flash Intro’s.
  • Basics of Action Scripting.
  • Adding Audio and Video in Flash.
  • Action Script 2.0.
  • Adding Controls in Animations.
  • Creating Website Advt.
  • Creating Flash Banners.

• Module 8: (Domain Registration & Web Hosting)
  • About Domain Name & DNS.
  • Searching Domain Name.
  • Registering Domain.
  • Purchase Hosting Package.
  • Uploading Website.
  • Using CPanel.
  • Adding Domain & Subdomains.
  • Creating Email Account for Clients.

For More Details please visit : http://www.dga-edu.com/website_designing_course.html or mail us at : info@dga-edu.com

Best html5 css3 training institute in dwarka mor, New Delhi

HTML5 & CSS3

HTML5 & CSS3, Responsive Web Design is a collection of techniques that allow a website to flex and adapt to the size of screen it’s being viewed on. Someone opening your site on a small smartphone will be shown the same site as the person opening it on their laptop but the site will have noticed the constraints and automatically reformatted to give the user an experience better suited to their device. No more loading a huge website and having to zoom in and out to find the content you’re looking for. Responsive web design takes into account interaction too and makes your site easier to use by acknowledging and integrating things like touch screens to aid navigation.

As smartphone and tablet adoption rapidly increases, so does the importance of mobile-friendly websites. If SEO is a core component of your digital marketing strategy, having a mobile–friendly website is becoming essential. Mobile sales have already overtaken desktop sales, and mobile Internet usage is predicted to overtake desktop internet usage by 2014. It is only logical that mobile search will overtake desktop search at some point in the near future as well.

Course Contents

 Duration : 3 Months | Classes: Mon-Sat, 1.5 Hrs./day

• Module 1: (HTML 4.01)
  • Basic Web Pages Creation Using HTML Tags (V 4.01)
  • What is HTML?
  • HTML Editors.
  • Creating and Displaying HTML Documents.
  • About Browsers and Compatibility.
  • Adding comments in HTML Documents.
  • Making your HTML Codes Readable : A Proper HTML Document.
  • Spaces, Line Break and Horizontal Rule.
  • Writing a proper tags.
  • Working with Text
  • Creating a paragraph.
  • Text alignment with the align attribute.
  • Working with character tags: logical and physical.
  • Creating headings.
  • HTML lists.
  • Unordered list (bulleted list).
  • Ordered list (numbered list).
  • Definition list, Nesting lists.
  • Line breaks.
  • Preformat text.
  • Quotation blocks.
  • Alter the Face, Size and Color of text with the <font> tag.
  • Controlling the font size with the <font> tag.
  • Changing the font color with the <font> tag.
  • Changing the font face with the <font> tag.
  • Combining <font> tag attributes.
  • Horizontal rules.
  • Divisions (with div tag).
  • METADATA & SEO Techniques
  • Meta tag attributes.
  • HTML Meta Tags: Keywords and Descriptions.
  • Robot exclusion.
  • Robot.txt file.
  • Robot control with <meta> tag.
  • Search engine optimization.
  • Document caching.
  • HTML Hyperlinks
  • Understanding URL.
  • Relative Link.
  • Absolute Link.
  • Reference Link.
  • E-Mail Link.
  • Changing the link color.
  • Setting Link Title.
  • Setting Tab Order of Link.
  • Adding Keyboard Shortcut to Link.
  • HTML Graphics
  • Adding Graphics to web pages.
  • Image file formats.
  • Alt Property.
  • Controlling Image size.
  • Controlling vertical and horizontal spacing.
  • IMAGEMAP
  • Server Side Image Map.
  • Client Side Image Map.
  • Rectangular Hotspots.
  • Circular Hotspots.
  • Polygonal Hotspots.
  • HTML Tables
  • Adding Tables.
  • Cellpadding & Cellspacing.
  • Table Background color and image.
  • Table alignments.
  • Controlling text placements.
  • Spanning rows and columns.
  • HTML Forms
  • Creating Forms.
  • Using Form tag.
  • Input type, text, password etc.
  • Radio Buttons, Check Boxes.
  • Selection list.
  • Multiline text areas.
  • Form Processing.

• Module 2: (HTML V5.0)
  • What is HTML 5?
  • Browser Support.
  • W3C and Web Hypertext Application Technology Working Group (WHATWG). Specifications.
  • Overview of updated new features.
  • HTML5 Syntax.
  • The DOCTYPE.
  • Character Encoding.
  • The <script> tag.
  • The <link> tag.
  • HTML5 Document.
  • Forms.
  • Color, date, datetime, datetime-local, email, month.
  • Number, range, search, tel, time, url, week.
  • Form Elements.
  • <datalist>, <keygen>, <output>.
  • Autocomplete, novalidate.
  • New attributes for <input>.
  • Autocomplete, autofocus, form, formaction, formenctype.
  • Formmethod, formnovalidate, formtarget, height, width.
  • List, min, max, multiple, pattern(regexp), placeholder, required.
  • Video and Audio.
  • Media.
  • <audio>, <video>.
  • <source>, .
  • <track>, plugins.
  • youtube.
  • HTML5 NEW ELEMENTS
  • <article>, <aside>, <canvas>, <details>, <figcaption>.
  • <footer>, <header>, <hgroup>, <main>, <meter>, <nav>.
  • <section>, <summary>, <time>.
  • Migration from HTML4 to HTML5.
  • HTML5 Browser Support.
  • HTML5 Elements as Block Elements.
  • Adding New Elements to HTML.
  • Problem With Internet Explorer.
  • Complete Shiv Solution.
  • HTML5 Skeleton.
  • HTML5 DEPRECATED TAGS.
  • <acronym>.
  • <center>.
  • <font>.
  • <frame>.
  • <frameset>.
  • <s>.
  • <u>.
  • Canvas Overview.
  • Lines.
  • Curves.
  • font.
  • Image.
  • Paths.
  • Shapes.
  • Color, gradients.
  • SVG.
  • What is SVG?
  • SVG Advantages.
  • Differences Between SVG and Canvas.
  • Rectangle.
  • Circle.
  • Ellipse.
  • Line.
  • Polyline.
  • Polygon.
  • Path.

• Module 3: (Overview of CSS & CSS 3.0)
  • CSS 2.0 vs CSS 3.0.
  • Introduction to css3.
  • Whats new in css3.0.
  • Border.
  • Box-shadow.
  • Border-image.
  • Border-radius.
  • Background.
  • Background-clip.
  • Background-origin.
  • Background-size.
  • Multiple Background Images.
  • Gradients.
  • Linear Gradients.Top to Bottom.
  • Left to Right.
  • Angles.
  • Multiple Color Stops.
  • Transparency.
  • Repeating-linear-gradient.
  • Radial Gradients.
  • Evenly Spaced Color Stops.
  • Differently Spaced Color Stops.
  • Set Shape.
  • Use of Different Size Keywords.
  • Closest-side.
  • Farthest-side.
  • Closest-corner.
  • Farthest-corner.
  • Repeating-radial-gradient.
  • Text effects.
  • Text-shadow.
  • Word-wrap.
  • @FONT Face.
  • Browser Support.
  • Font Formats, Using The Font.
  • Browser Support for Font Formats.
  • Working with third party plugins.
  • Google fonts.
  • 2D Transforms.
  • Browser Support for 2D Transforms.
  • Transform, transform-origin.
  • Matrix().
  • Translate(x,y), X(n), Y(n).
  • Scale(x,y), X(n), Y(n).
  • Rotate(angle).
  • Skew(x-angle,y-angle), X(angle), Y(angle).
  • 3D Transforms.
  • Transform.
  • Transform-origin.
  • Transform-style.
  • Perspective.
  • Perspective-origin.
  • Backface-visibility.
  • RGBA.
  • Box Resize.
  • Box Sizing.
  • Outline.
  • Transitions.
  • Transition-delay.
  • Transition-duration.
  • Transition-property.
  • Animations.
  • @keyframes.
  • Animation.
  • Animation-delay.
  • Animation-direction.
  • Animation-duration.
  • Animation-iteration-count.
  • Animation-name.
  • Selectors.
  • Multiple Columns.
  • Column-count.
  • Column-fill.
  • Column-gap.
  • Column-rule.
  • Column-rule-color.
  • Column-rule-style.
  • Column-rule-width.
  • Column-span.
  • Column-width.
  • Columns.
  • User Interface.
  • Box-sizing.
  • Resize.
  • Outline-offset.
  • Appearance Property.
  • Nav-down.
  • Overview of CSS 3.0 compatabilities for Internet Explorer.

For More Details please visit : http://www.dga-edu.com/html5_css3_training.html or mail us at : info@dga-edu.com

Corel Draw & Photoshop Training Institute in Dwarka Mor, New Delhi

COREL DRAW /PHOTOSHOP TRAINING

Graphic Designing has now become an integral part of various business activities that calls for visual communication, in form of print/digital Ads, brochures, leaflets etc. As per a report published by the CII, about 20% of the design industry comprises of graphic design work and the graphic design industry is said to be booming at a projected rate of 13%*. To tap the increasing opportunities in the field, IMAGE has designed this course that would enable students to build a strong foundation in visual design and communication, and specialize in designing a range of marketing collaterals.

Course Contents

Duration : 2 Months | Classes: Mon-Fri, 1½ Hrs./day   Weekend: Sat-Sun, 2½ Hrs./day

Corel Draw

CorelDraw is a vector-based, graphic drawing program or application that lets you create professional artwork and illustrations, from simple logos to advertisements.

• CorelDRAW Basics and Interface
  • Getting Start: Corel Draw Screen & Options.
  • Tool Bar & File Operations.
  • Setting Up Document.
  • Moving Around Current page.
  • Page Setup.
  • Save Import, Export, and Print etc.
• Using Selection Tool: Pick Tool, Freehand Tool.
  • Creating Objects: Rectangle, Ellipse, Polygon, Star, Basic Shapes etc.
  • Shaping Objects: Shape Tool, Crop Tool, Smear Tool, Attract, Repeal Tools.
  • Moving Objects, Copying and Deleting Objects.
  • Transforming Objects.
  • Using Transform Docker.
  • Outlining & Filling Objects.
  • Eyedropper and Paint bucket Tools.
  • Outlining & Filling Objects.
  • Outline Tool, Using Fill Tool, Interactive Mesh fill.
  • Copying Attributes, Setting Outline and Fill Defaults.
  • Arranging Objects, Grouping and Ungrouping Objects.
  • Using Guidelines, Using Dynamic Guides, Using Snap To.
  • Aligning Objects, Group and Child Objects.
  • Combining and Breaking Objects.
  • Welding, Intersection, Trim Objects.
  • Editing Layers.
  • Moving, Copying, and Locking Layers.
  • Using the Object Manager.Objects- Creation And Manipulation
• Using Menu Option – Advance
  • Save as Template, Acquire Image, Export HTML, Publish to PDF.
  • Paste Special, Duplicate, Clone, Insert Barcode.
  • Lock Objects, Covert Outline to Object.
  • Creating Rollovers, Copying Effects, Power Clip.
  • 3d Effects, Distort, Creative Effects.
  • Fit text to path, Align to baseline, Change Case.
  • Tables Create, Insert & Delete.
  • Running Scripts, Macros.
  • Calendar Wizard, File Converter.
• Page Layout, Printing, Exporting and Advanced Features
  • Page Layouts & Printing.
  • Greeting Card, Creating & Using Templates.
  • Print Preview Setup.
  • Printing Options.
  • Exporting to Graphic Formats.
  • Creating Symbols & Custom Patterns.
• Working with Special Effects and Texts
  • Special Effects.
  • Drawing With the Artistic Media Tool.
  • Shaping an Object with an Envelope.
  • Extruding an Object.
  • Blending Objects.
  • Lens Effect & Add Perspectives.
  • Using Power Clips.
  • Applying Contours.
  • Applying Drop Shadows.
  • Applying Distortions.
  • Using Interactive Fills.
  • Using Interactive Transparencies.
  • Mesh Fills.
  • Working with Text.
  • Text Tool, Artistic Text & Paragraph Text.
  • Paragraph Options, Indents & Ruler.
  • Imparting Text.
  • Paragraph formatting & Spell Checker.
  • Special Text Effects.
  • Fitting Text to a Path, Converting Text to Curves, Creating Blended Text Shadows.
  • Special Text Effects, Jumpy Text, Neon Text, Glowing Text, Chrome Text.
  • Working with Bitmap.
  • Importing Bitmap, Adjusting Color.
  • Hiding Certain Colors in a Bitmap.
  • Applying Special Bitmap Effects.
  • Creating Web Images.
  • Advanced GIF Options.
• Adobe Photoshop
  • Photoshop Environment Overview.
  • Raster & Vector Graphics.
  • Exploring Photoshop Environment.
  • Working with Navigation Tools.
  • Explore Adobe Bridge.
  • Working with Images (JPEG, PNG, Gif etc.).
  • Build, Create & Manage Actions.
  • Display & Print Resolution.
  • Working with Tools: Marquee, Lesso, Quick Selection, Magic Wand, Crop, Perspective, Slice Tool, Color Sampler etc.
  • Working with Tools: Healing Brush, Patch Tool, Clone, Red Eye Tool, Brush Tools, Pattern Stamp, History, Art History, Gradient, Erasers, Blur, Smudge Tool.
  • Creating Image Composites: Floating Vs Fixed Selection, Create layers, Smart objects, Transform Layers, Copy layers between images, Arrange Layers, Working with Channels.
  • Blending Composite Images.
  • Working with Images & Exploring Image Modes.
  • Applying Colors, Working with Layers, Working with Vector.
  • Enhancing Images with Text and Special Effects.
  • Creating Special Effects.
  • Saving Completed Images.
  • Blending Modes, Masking and Clipping Layers.
  • Automating Tasks, Removing Image Defects.
  • Working with Vanishing Points.
  • Filter Effects, Working with Menus Options.

For More Details please visit : http://dga-edu.com/corel_draw_photoshop_training.html or mail us at : info@dga-edu.com

Advanced Computer Course in West Delhi, Dwarka

Advanced Computer Training : Microsoft Office is the most widely used software suite in business and office environments. It is essential if you want to keep up to date with the skills demanded by many employers and to progress your career DGA Professional Institute provides a comprehensive range of Microsoft office training courses designed to train you in all aspects of Microsoft Office, and the individual programmers it contains such as Excel, PowerPoint and Microsoft Word.

If you have some Office skills, with DGA Professional Institute, you can update to the latest version fast, or you if you’re just beginning, you can gain a comprehensive knowledge that include realistic work-place exercises.

Course Contents

Duration : 2 Months | Classes: Mon-Sat, 1.5 Hrs./day

• Module 1: (Operating System – Windows)
  • About Computers.
  • Hardware and Software.
  •  Operating System and Windows.
  •  Using Windows 7,8,10.
  •  Working with Windows environment.
  •  Using Windows Elements.
  •  Windows Explorer, Control Panel, properties etc.
  •  Installing Programs, creating files & folders.
  •  Various Storage Devices.
  •  Using Pen Drive, CD, DVD etc.
  •  About Drivers and Their Uses.
  •  Printing & Networking.

• Module 2: (Microsoft Word – Professional Level)
  • Introduction & Word Basics.
  • Introduction of MS-Word Window Elements.
  • Format Your Document.
  • Bullets & Numbering.
  • Working with Tabs.
  • Create & Apply Styles.
  • Advance Find and replace Techniques.
  • Inserting Graphics, Charts and Objects.
  • Setting up your Document.
  • Advanced Page Layout Tools.
  • Tables in Microsoft Word.
  • Creating Reports in Various Tabular format.
  • Inserting and formatting Pictures, Clip arts, Smart art, etc.
  • Hyperlinks and bookmarks with Cross Reference.
  • Inserting Header, Footers,Page Numbers.
  • Inserting Equations and Symbols.
  • Working with themes & Page backgrounds.
  • Paragraph formatting and Objects arrangement.
  • Setting Up Document for Print with Page Setup.
  • Using Referencing Tools.
  • Using Mailing Feature with Advance Mail Merge Technique.
  • Creating Master Documents.
  • Track and Merge Documents.
  • Spelling & Grammar.
  • Using Track Changes & Comments.
  • Document Protection with passwords.
  • Introduction to Macros, Recording & Uses.
  • Using macros to Automate Difficult tasks in Word Document.

• Module 3: (MS Excel Training (Intermediate & Advanced))
  • Excel BASIC OPTIONS
    • An overview of the Screen, Navigation and Basic Spreadsheet concepts.
    • Understand Excel terminology Workbooks, Worksheets, Rows, Columns and Cells.
    • Various Selection techniques.
    • Various ways to Enter, Edit and Delete information (Text, Numbers, Dates).
    • Methods to Move, Copy & Paste data.
    • All the Options in Paste Special and Go To.
    • Insert, Delete and Hiding Rows & Columns.
    • Inserting and Deleting ranges.
    • Insert, Delete and Move Cells.
    • Various Navigation techniques.
    • Sheet tab formatting and Renaming.
    • Copy and Clear Formats and Merge Cells.
    • Find, Replace and AutoCorrect.
    • All Format Cells Options.
    • Methods to Move and Copy sheets.
    • Various Printing Technique like Page break preview, Headers and footers, Freezing print titles & Data Alignments.
    • Formatting of Cells with Number formats, Font formats, Alignment, Borders, Fill colors and Patterns.
    • Uses Conditional Formatting and Auto Formatting.
    • Uses of Toolbars and Formula Bar.
    • Viewing, Adding, Editing and Deleting Comments.
    • Auditing features and Tracing Formula errors.
    • Protect and Share Workbook, Worksheet and Cell ranges.
    • Using Freeze Panes.
    • Worksheets and Workbooks Calculation method.
    • Hide & Display Rows, Columns, Worksheet & Workbooks.
    • Uses of Hyperlinks and Define Name.
  • EXCEL BASIC FUNCTIONS
    • SUM, SUBTOTAL, ADDRESS, AVERAGE, CHAR, COLUMN, COLUMNS, CONCATENATE, COUNT.
    • COUNTA, COUNTBLANK, EXACT, HYPERLINK, RIGHT, LEFT, MID, LEN, LOWER, UPPER, TEXT.
    • OFFSET, PROPER, MAX, SEARCH, TIME, DATE, DAY, MONTH, YEAR, FIND, REPLACE, ROUND.
    • ROW, ROWS, SUBSTITUTE, TODAY, TRANSPOSE, TRIM, INDIRECT, NETWORKDAYS, DATEDIF, MOD, NOW etc.
  • EXCEL ADVANCE FUNCTIONS
    • VLOOKUP, HLOOKUP, SUMIF, SUMIFS, SUMPRODUCT, DSUM.
    • COUNTIF, COUNTIFS, IF, IFERROR, ISERROR, ISNA, ISNUMBER, ISNONTEXT, ISBLANK, ISTEXT.
    • GETPIVOTDATA, DCOUNT, DCOUNTA, OR, AND, SEARCH, INDEX, MATCH etc
  • EXCEL OPTIONS
    • Various Methods of Filter and Advance Filter options.
    • Creating and Updating Subtotals.
    • Various Methods of Text to Column options.
    • Uses of Data Grouping and Consolidation options.
    • Uses of Goal Seek and Scenarios Manager.
    • Various Method of Sorting Data.
    • Creating, Formatting and Modifying Chart.
    • Data Validation, Creating drop down lists using different data sources.
    • Linking Workbooks and Uses of Edit Link options.
    • Excel Options, Customizing the Quick Access Tool Bar.
    • Formula Auditing features and Trace formula error.
  • ADVANCED EXCEL FUNCTIONS
    • When should use the “IF” Conditions?
    • How to use nested IF statements in Excel with AND, OR Functions.
    • Use the IF Conditions with the Other Advance Functions.
    • Creation of Multiple IF Conditions in One Cell.
    • How to combine two or more excel formulae to get desired results.
    • How to combine the formulae with IF Condition.
  • ADVANCED EXCEL OPTIONS
    • Various Methods and Options of Pivot Table.
    • Using the Pivot Table Wizard.
    • Changing the Pivot Table Layout.
    • Pivot Table Options.
    • Subtotal and Grand total Options.
    • Formatting, Grouping items.
    • Inserting calculated fields.
    • Display and hide data in fields.
    • Select, Move & Clear Pivot data.
    • Creating and Modifying a PivotChart.
  • The sessions will include:
    • Introducing the above mentioned options.
    • How to use/apply the excel formulae in various situations.
    • How to combine two or more excel formulae to get desired results
    • How to combine the formulae with IF Condition.

• Module 4: (MS Power Point)
  • Getting Started with PowerPoint.
  • Customizing the PowerPoint Environment.
  • Customizing a Design Template.
  • Creating a Presentation.
  • Formatting Text on Slides.
  • Adding Graphical Objects to a Presentation.
  • Modifying Objects.
  • Adding Tables to a Presentation.
  • Inserting Charts in a Presentation.
  • Adding Diagrams to a Presentation.
  • Adding Special Effects to Presentations.
  • Preparing to Deliver a Presentation.
  • Customizing a Slide Show Presentation.
  • Securing and Distributing a Presentation.

• Module 5: (MS Access)
  • Microsoft Access Environment.
  • Describe the seven main Access 2007/2010 objects.
  • Start Access and open a database.
  • Understand the Access Program Screen.
  • Add, Edit and Delete Records in Table View.
  • Add, Edit and Delete records in Forms.
  • Open and run a query.
  • Open and run a report.
  • Understand Primary Keys.
  • Understand data types.
  • Create a database.
  • Create a table.
  • Create a query.
  • Create a form.
  • Use the form wizard.
  • Create a report using the report wizard.
  • Understand field properties.
  • Index a field.
  • Change a field’s data type.
  • Apply formats to number and text fields.
  • Set default values and apply field validation.
  • Create input masks.
  • Create and modify lookup fields.
  • Create value lists.
  • Understand table relationships.
  • Create relationships between tables.
  • Understand referential integrity.
  • Implement and test referential integrity.
  • Understand relationship types.

For More Details please visit : http://dga-edu.com/advanced_ms_office.html or mail us at : info@dga-edu.com

Join Basic Computer Course in Dwarka Mor, New Delhi

Basic Computer Course

Basic Computer Course, As we all know very well the uses of computer system in every sector of our day by day work is increasing.
If you have some Office skills, with DGA Professional Institute, you can update to the latest version fast, or you if you’re just beginning, you can gain a comprehensive knowledge that include realistic work-place exercises.

Course Contents

Duration : 1½ Month | Classes: Mon-Sat, 1½ Hrs./day

• Module 1: Operating System- Windows
  • About Computers.
  • Hardware and Software.
  • Operating System and Windows.
  • Using Windows 7,8,10,
  • Working with Windows environment,
  • Using Windows Elements,
  • Windows Explorer, Control Panel, properties etc.
  • Installing Programs, creating files & folders.
  • Various Storage Devices.
  • Using Pen Drive, CD, DVD etc.
  • About Drivers and Their Uses.
  • Printing & Networking.

• Module 2: Microsoft Word- Professional Level
  • Introduction & Word Basics.
  • Introduction of MS-Word Window Elements.
  • Format Your Document.
  • Bullets & Numbering.
  • Working with Tabs.
  • Create & Apply Styles.
  • Advance Find and replace Techniques.
  • Inserting Graphics, Charts and Objects.
  • Setting up your Document.
  • Advanced Page Layout Tools.
  • Tables in Microsoft Word.
  • Creating Reports in Various Tabular format.
  • Inserting and formatting Pictures, Clip arts, Smart art, etc.
  • Hyperlinks and bookmarks with Cross Reference.
  • Inserting Header, Footers,Page Numbers.
  • Inserting Equations and Symbols.
  • Working with themes & Page backgrounds.
  • Paragraph formatting and Objects arrangement.
  • Setting Up Document for Print with Page Setup.
  • Using Referencing Tools
  • Advance Mail Merge Technique.
  • Creating Master Documents.
  • Track and Merge Documents.
  • Spelling & Grammar.
  • Using Track Changes & Comments.
  • Document Protection with passwords
  • Introduction to Macros, Recording & Uses.
  • Using macros to Automate Difficult tasks in Word Document.

• Module 3: Microsoft Excel
  • Excel Tabs, Options, Formatting & Printing.
    • An overview of Excel, Version & Spreadsheet concepts.
    • Workbooks, Worksheets, Rows, Columns and Cells.
    • Various Selection techniques.
    • Cell Contents – General, Text, Numbers, Dates etc.
    • Methods to Move, Copy & Paste data.
    • All the Options in Paste Special and Go To.
    • Insert, Delete and Hiding Rows & Columns.
    • Inserting and Deleting ranges.
    • Insert, Delete and Move Cells
    • Various Navigation techniques.
    • Sheet tab formatting and Renaming.
    • Copy and Clear Formats and Merge Cells.
    • Find, Replace and AutoCorrect.
  • Working With Formulas & Functions
    • SUM, SUBTOTAL, ADDRESS, AVERAGE, CHAR.
    • COLUMN, COLUMNS, CONCATENATE, COUNT
    • COUNTA, COUNTBLANK, EXACT, HYPERLINK.
    • RIGHT, LEFT, MID, LEN, LOWER, UPPER, TEXT
    • OFFSET, PROPER, MAX, SEARCH, TIME, DATE.
    • Page break preview, Headers and footers, Freezing
    • Print Preview, Page Setup, Print Titles & Data Alignments.
    • Cell Formatting, Alignment, Borders, Fill colors and Patterns.
    • Uses Conditional Formatting and Auto Formatting.
    • All Format Cells Options.
    • Uses of Toolbars and Formula Bar.
    • Viewing, Adding, Editing and Deleting Comments.
    • Auditing features and Tracing Formula errors.
    • Protect and Share Workbook, Worksheet and Cell ranges.
    • Using Freeze Panes.
    • Worksheets and Workbooks Calculation method.
    • Hide & Display Rows, Columns, Worksheet & Workbooks.
    • Methods to Move and Copy sheets.
    • Uses of Hyperlinks and Define Name.
    • DAY, MONTH, YEAR, FIND, REPLACE, ROUND, ROW, ROWS.
    • SUBSTITUTE, TODAY, TRANSPOSE, TRIM, INDIRECT.
    • NETWORKDAYS, DATEDIF, MOD, NOW etc.

• Module 4: Internet Concepts
  • Internet Concepts & Mail
  • How to connect to Internet.
  • Browsers & Surfing Inernet
  • Best Modern Browsers for Internet.
  • Network Concepts-LAN,MAN & WAN.
  • Using Search Engines(Google, Bing, Yahoo etc).
  • Mailing : Creating New Account, Send & Receive Mails.
  • Using MS-Outlook.

For More Details please visit : http://www.dga-edu.com/basic_computer_course.html or mail us at : info@dga-edu.com

Best Graphic Designing Institute In Delhi-NCR

GRAPHIC DESIGNING

Graphic Designing Course have great potential in providing creative solutions to communication of complex phenomena of print media such as books, magazines and newspaper, known as pictographic depictions or concept visualization. It can be traditionally applied in typography, cartooning (social, political and educational), and designing poster, book-covers, letter heads, newspapers, brochure, logo, textile prints, or even jewelries. Since the advent of personal computers and design software, graphic design is being utilized in electronic media-often referred to as interactive design which has unlimited applications in advertisements. The students can later become graphic designers working in print production (newsletters, posters, brochures, etc). Graphic designers combine text and images to communicate a message: sell a product or service, inform, or entertain.

Design is an activity of problem solving for the well being of society and individuals. Today, in the world of information and communication everyone has to communicate and get communicated by different groups of people through a wide variety of communication systems. Graphic designs course have great potential in providing creative solutions to communication of complex phenomena of print media such as books, magazines and newspaper, known as pictographic depictions or concept visualization. It can be traditionally applied in typography, cartooning (social, political and educational), and designing poster, book-covers, letter heads, newspapers, brochure, logo, textile prints, or even jewelries. Since the advent of personal computers and design software, graphic design is being utilized in electronic media-often referred to as interactive design which has unlimited applications in advertisements. The students can later become graphic designers working in print production (newsletters, posters, brochures, etc). Graphic designers combine text and images to communicate a message: sell a product or service, inform, or entertain.

Course Contents

Duration : 4 Months | Classes: Mon-Sat, 1½ Hrs./day

• Module 1: Corel Draw
  • CorelDRAW Basics and Interface
    • Getting Start: Corel Draw Screen & Options.
    • Tool Bar & File Operations.
    • Setting Up Document.
    • Moving Around Current page.
    • Page Setup.
    • Save Import, Export, and Print etc.
  • Objects- Creation And Manipulation
    • Using Selection Tool: Pick Tool, Freehand Tool.
    • Creating Objects: Rectangle, Ellipse, Polygon, Star, Basic Shapes etc.
    • Shape Tool, Crop Tool, Smear Tool, Attract, Repeal Tools.
    • Moving Objects, Copying and Deleting Objects.
    • Transforming Objects.
    • Outlining & Filling Objects.
    • Eyedropper and Paint bucket Tools.
    • Outlining & Filling Objects.
    • Outline Tool.
    • Using Fill Tool.
    • Interactive Mesh fill.
    • Copying Attributes, Setting Outline and Fill Defaults.
    • Arranging Objects.
    • Grouping and Ungrouping Objects.
    • Using Guidelines.
    • Using Dynamic Guides.
    • Using Snap To.
    • Aligning Objects.
    • Group and Child Objects.
    • Combining and Breaking Objects.
    • Welding, Intersection, Trim Objects.
    • Using Layers.
    • Editing Layers.
    • Moving, Copying, and Locking Layers.
    • Using the Object Manager.
  • Page Layout, Printing, Exporting and Advanced Features
    • Page Layouts & Printing.
    • Greeting Card, Cereating & Using Templates.
    • Print Preview Setup.
    • Printing Options.
    • Exporting to Graphic Formats.
    • Creating Symbols & Custom Patterns.
  • Working With Special Effects And Texts
    • Drawing With the Artistic Media Tool.
    • Shaping an Object with an Envelope.
    • Extruding an Object.
    • Blending Objects.
    • Lens Effect & Add Perspectives.
    • Using Power Clips.
    • Applying Contours.
    • Applying Drop Shadows.
    • Applying Distortions.
    • Using Interactive Fills.
    • Using Interactive Transparencies.
    • Mesh Fills.
    • Working with Text.
    • Text Tool, Artistic Text & Paragraph Text.
    • Paragraph Options, Indents & Ruler.
    • Importing Text.
    • Paragraph formatting & Spell Checker.
    • Special Text Effects.
    • Fitting Text to a Path, Converting Text to Curves, Creating Blended Text Shadows.
    • Special Text Effects, Jumpy Text, Neon Text, Glowing Text, Chrome Text.
    • Working with Bitmap.
    • Importing Bitmap, Adjusting Color.
    • Hiding Certain Colors in a Bitmap.
    • Applying Special Bitmap Effects.
    • Creating Web Images.
    • Advanced GIF Options.
  • Using Menu Option – Advanced
    • Save as Template, Aquire Image, Export HTML, Publish to PDF.
    • Paste Special, Duplicate, Clone, Insert Barcode.
    • Lock Objects, Covert Outline to Object.
    • Creating Rollovers, Copying Effects, Power Clip.
    • 3d Effects, Distort, Create Effects.
    • Fit text to path, Align to baseline, Change Case.
    • Tables Create, Insert & Delete.
    • Running Scripts, Macros.
    • Calender Wizard, File Converter.

• Module 2: Adobe Photoshop

  • Photoshop Environment Overview .

  • Raster & Vactor Graphics.

  • Exploring Photoshop Environment.

  • Working with Nevigation Tools.

  • Explore Adobe Bridge.

  • Working with Images(JPEG,PNG,Gif etc.).

  • Build, Create & Manage Actions.

  • Display & Print Resolution.

  • Working with Tools: Marquee, Lesso, Quick Selection, Magic Wand, Crop, Perspective, Slice Tool, Color Sampler etc.

  • Working with Tools: Healing Brush, Patch Tool, Clone, Red Eye Tool, Brush Tools Pattern Stamp, History, Art History,Grediant, Erasors, Blur, Smudge Tool.

  • Creating Image Composites :Floating Vs Fixed Selection, Create layers, Smart objects, Transform Layers, Copy layers between images, Arrange Layers, Working with Channels.

  • Blending Composite Images.

  • Working with Images & Exploring Image Modes.

  • Applying Colors.

  • Working with Layers.

  • Working with Vector.

  • Enhancing Images with Text and Special Effects.

  • Creating Special Effects.

  • Saving Completed Images.

  • Blending Modes.

  • Masking and Clipping Layers.

  • Automating Tasks.

  • Removing Image Defects.

  • Working with Vanishing Points.

  • Filter Effects.

  • Working with Menus Options.

• Module 3: Adobe Illustrator
  • Creating Complex Illustrations.
  • Creating compound path : Pathfinder palette.
  • Creating Compound Shapes.
  • Offset Path, Outline Path.
  • Working with Basic Tools.
  • More on the Layers Palette.
  • Creating new Layers.
  • Moving Objects & Layers.
  • Locking & Viewing Layers.
  • Working with Masks.
  • Creating Clipping Mask.
  • Editing Clipping Mask & Masked Objects.
  • Creating Opacity Mask.
  • Editing Opacity Mask & Masked Objects.
  • Transparency effects.
  • Document Raster Effect Settings.
  • Working in Perspective.
  • Creating Blends, Edit & Blend Options.
  • Graphic Styles.
  • Creating Seamless patterns.
  • Working with Gradient Mesh.
  • Creating Web Graphics.
  • Advanced Filters and Effects.
  • Recording, Playing & Editing Actions.
  • Dynamic Text.
  • Using Menu Options.

• Module 4: Adobe Indesign
  • Introduction.
  • Managing the InDesign Environment.
  • Designing Documents.
  • Managing Text.
  • Utilizing Colors, Swatches and Gradients.
  • Managing Transparency.
  • Utilizing Tables.
  • Administering Advanced Styless.
  • Controlling Text.
  • Handling Page Elements and Graphics.
  • Developing Bézier Paths.
  • Managing Long Documents.
  • Importing and Exporting Files.
  • Adjusting Print Settings.

For More Details please visit : http://www.dga-edu.com/graphic_designing_course.html or mail us at : info@dga-edu.com