Basic Courses


  •      

    Ms-Office

  •      

    D.T.P

  •      

    Internet

  •      

    Special Offer Choose 3




  •    Accounting Courses


  •      

    Tally Diploma

  •      

    Tally Certification

  •      

    Advance Excel

  •      

    Ms-Access

  •      

    Financial Management



  •    Graphic & Web Design


  •      

    Advance Web Designing

  •      

    Advance Graphic Designing

  •      

    2D Animation

  •      

    2D Animation

  •      

    Advance Photoshop

  • Diploma in Excel & Advanced Excel
    Fees: Rs. 2500 Duration:2 Months (Special Internet Offer)
    (Fast Track Batch Available)


    Software Covered:- Advance EXCEL TRAINING


    MS-EXCEL & ADVANCED EXCEL:

    -  Electronic Spreadsheet Concept

    -  Formatting Fonts, Numbers

    -  Relative & Absolute Reference

    -   Date & Currency Formatting

    -   Formula charts & Graphs

    -  2D/3D Graphs, Pie, Line Cone

    -   Formatting Charts, Data Values


    INVENTORY:

    -  Sub Total Reports, Auto Filter

    -  Password Protecting Worksheets

    -   Linking Multiple Sheets

    -   Sheet Referencing

    -  Linking Between Word/Excel/Ppt

    -   Functions:- LOOKUP, VLOOKUP, HLOOKUP,

    -  COUNTIF, SUMIF. What-if-analysis

    -  Pivot Tables, NESTED IF

    -  Reporting

    -  Character Functions

    -   Date Functions

    -  Age Calculations

    -  Consolidation of Data

    -  Data Validation

    -  MACROS (Intro)

    -   Introduction to VBA Prog



    LIVE Projects: More than 35+ projects covered






    Copyright © 2018-19 American Computer Center | All Rights Reserved Designed By: Raju Vishwakarma