Diploma in Excel & Advanced Excel Course

Diploma in Excel & Advanced Excel Course

Diploma in Excel & Advanced Excel Course
Rs. 9,550 6,990 /-

  • Fees: Rs. 9,550 5,990
  • Duration: 6 Weeks
  • Work on Projects & Assignments
  • All Inclusive of Books, Certification and GST
  • Software Covered : Microsoft Excel
  • Fast Track Batch Available

Softpro offers professional courses in Advanced Excel. The Advanced Excel course in Mumbai is a short-term course for students from accounting, finance and Management background. With the application of the formulas & functions your financial analysis skills to the next level.

  • Advanced Excel
  • MS- Excel

Course Content

MODULE 1. ADVANCED EXCEL DIPLOMA

  • Sub Total Reports, Auto Filter
  • Sorting Data
  • Password Protecting Worksheets
  • Linking Multiple Sheets
  • Sheet Referencing
  • Linking Between Word/Excel/Ppt
  • COUNTIF, SUMIF.
  • What-if-analysis
  • Pivot Tables, Pivot Charts
  • NESTED IF
  • Reporting
  • Character Functions
  • Scenario Manager
  • Date Functions
  • Age Calculations
  • Consolidation of Data
  • Data Validation
  • Logical Functions
  • MACROS Definition & Concepts
  • Record & Run a Macro
  • Store a Macro
  • Intro to VBA Prog (25 Projects)

MODULE 2. MS EXCEL

  • Electronic Spreadsheet basics
  • Formatting Fonts, Numbers
  • Relative & Absolute Reference
  • Date & Currency Formatting
  • Formula charts & Graphs
  • 2D/3D Graphs, Pie, Line Cone
  • Formatting Charts
  • Data Values

INSTANT INQUIRY

CALL: 9833900330 / 9324347326

    Tally Excel Books

    Other Courses

    Tally PRO Executive

    Tally ERP, Tally Champs, GST, Inventory & Accounting

    Advanced Excel Course

    Formulas & functions, financial analysis.

    Corporate Advanced Excel

    Lookup, Pivot Tables, Macro’s, Function, Data Analysis

    Financial Accounting & Master Excel

    Excel, Tally ERP, Tally Champs, GST, Inventory & Accounting, Macros

    INSTANT INQUIRY

      1. Honest Counselling : Choose the Right Course @ Right Price.
      2. Small Batches 7-10 Students leads to Personal Attention.
      3. 100% Practicals with Projects.
      4. Original, Leagal & Official Software from Autodesk, Adobe.
      5. Industry Endrosed Cirriculum.
      6. Highly Trained, Experienced & Certified Faculty.
      7. High Emphasis on Projects & Assignments.
      8. Friendly, Supportive, Patient & Qualified Faculty.
      9. Easy Installment Facility.

      Who Can Do This Course:

      • Graduates, Undergraduates, 10+2
      • Having the minimum knowledge on Bussiness management
      • Commerce Subject Students

      More You Learn Less You Pay
      Professional Training – Take a Free DEMO
      Call 9833900330 / 9930375161

      Fees: Rs. 9,550 6,990/-

      What do my Tuition Fees include?
      1. Course Book.
      2. GST Included.
      3. Certificate.
      4. Extra Practice/Computer Time.
      5. 100% Placement Assistance.

      Morning Batches : 7:30-9am, 9-10am, 10-11am, 11-12pm
      Afternoon Batches : 12-1pm, 1:30-2:45pm, 3-4pm, 4-5pm
      Evening Batches : 5-6pm, 6-7pm, 7-8pm.
      Weekend & Fast Track Batches are conducted.
      Please call to confirm the Timings.
      Daily & Alternate Day batches are conducted.
      Call 9833900330 / 9930375161

      JOB PLACEMENT

      We provide 100% job placement support to all our candidates to get achieved a bright career in the Industry.

      Get Certified. Get Hired
      More You Learn Less You Pay - Call 9833900330

      INSTANT INQUIRY

        Other Courses

        Diploma in 3D Animation Course

        Character Modelling, VFX, Visual Effects, Sketching

        Digital Marketing Course

        Advance Digital Marketing Diploma

        Classroom Training, 25 Modules, 80% Practicals, ADMD

        Architecture CAD Diploma Course

        Autocad, Revit, MEP, 2D, 3D, Architecture Course

        Graphic Design Diploma Course

        Create Professional Brochures, Logo, Website Designer

        INSTANT INQUIRY