Advance Excel Training Institute
in Delhi

Advance Excel Training Course in Delhi

Advance Excel Training Institute in Delhi

About Advance Excel Training Course

Learn the foremost advanced formulas, functions and kinds of monetary analysis to be an Excel computer user . This advanced Excel training institute course builds on our free Excel crash program and is meant specifically for spreadsheet users who are already proficient and searching to require their skills to a complicated level..

This advanced tutorial will assist you become a world-class securities analyst for careers in investment banking, private equity, corporate development, equity research and FP&A. By watching the trainer build all the formulas and functions right your screen, you’ll easily pause, rewatch, and repeat exercises until you’ve mastered them.

Who Should Join

Freelance Accountants, Business Owners, Students aspiring for a Career in finance, accounting & taxation. (12th, Undergraduates, Graduates, B.com, M.com, MBAs)

How to Apply For Excel Training Institute in Delhi

– Admission Form: form duly filled and signed ( available at admission Counter )
– Qualification Proof: Self attested photocopy of last qualifying Mark Sheet
– Photo: Two latest passport size color photographs
– ID proof: Self attested photocopy of Photo ID proof.( Adhaar/ Passport any one)
– Fee Submission: Fees can be paid through Cash or Online Transfer
– EMIs: Fee can be paid in Monthly EMI

Drop Us A Query

Course Query Form

Student Reviews

Harsimar Singh

Best Institute to learn Digital Marketing. I Learned DM Course from Gyan Vigyan And Got An Paid Internship. Thanks To Gyan Vigyan and Specially Manoj Sir And Vipin Sir For Their Proper Guidence.

Harsimar Singh

Digital Marketing
Bhanvi Sonkar

Gyan Vigyan is the best computer education institute and their teachers are very helpful and best

Bhanvi Sonkar

Digital Marketing

    Course Content

    Module-1 ( Functions )

    – Text Functions – UPPER,LOWER,CONCATENATE,PROPER,LEFT,RIGHT,MID,SEARCH,SEARCH,FIND,LEN,TRIM….
    – DATE & TIME – DATE,YEAR,DAY,MONTH,EOMONTH,TODAY,TIME,HOUR,MINUTE,DATEVALUE,WEEKDAY,DATEIF….
    – FINANCIAL – DB,DDB,SIN,PPMT,PMT,RATE,NPER,PV,FV,PRICE…..
    – LOGICAL – IF,AND.OR,NOT,TRUE,FALSE,IFERROR….
    – LOOKUP & REFERENCES – LOOKUP,HLOOKUP.VLOOKUP,MATCH,INDEX,INDIRECT,HYPERLINK….
    – MATHEMATICS – SUM,SUMIFS,COUNT,COUNTIFS,AVERAGE,ABS,FACT,FLOOR,COS,PI,ROUND,POWER,PRODUCT…

    Module-2 ( Macro )

    STREAMING WORKFLOW
    – CREATE A MACRO, EDIT A MACRO, APPLY CONDITIONAL FORMATING, ADD DATA VALIDATION CRITERIA, UPDATE A WORKBOOK PROPERTIES, MODIFYING EXCEL DEFAULT SETTIING

    COLLABORATING WITH OTHERS
    – PROTECT FILES, SHARE A WORKBOOK, SET REVISION TRACKING, MERGE WORKBOOK, ADMINISTRATOR DIGITAL SIGNATURE

    Module-3 ( Organising And Presenting Data )

    CALCULATING DATA WITH ADVANCE FORMULA
    – MANAGE CELL & RANGE NAME, CALCULATING DATA ACROSS WORKSHEETS, USE SPECIAL FUNCTIONS, USING FORMULA TO SEPERATE DATA INTO SEPERATE COL., LINKING FILES IN EXCEL WORKSHHETS BY USING BUTTON
    Organizing Worksheet And Table Data
    – Create A Chart, Chart Element, Changing A Chart Type, Modifying A Chart, Format A Chart, Set Up Dynamic & Intreactive Chart, Calculating In Pivot Table

    Module-4 ( Auditing & Analysing Data )

    Auditing WorkSheets
    – Trace Cell, Trouble Shoot Error In Formulas, Troubleshoot invalid Data And Formula, Watch And Evalute Formula
    Analyzing Data
    – Create A Scenarios, Perform What-if-analysis, Perform Statistical Analysis, Anlysis Toolpack

    Module-5 ( Organizing Worksheet)

    Organizing Sheet And Table Data
    – Table, Create Table Dialog Box, Styles And Quick Style Set, Formate Table, Sort Or Filter Worksheet Or Table Data, Database function…….Dsum(), Daverage(),Dcount()
    Inserting Graphics Object
    – Insert And Modify Picture And Clipart, Draw And Modify Shapes, Illustrate Workflow Using SmartArt graphics, Layer And Group Graphics Object, Customizing And Enahancing Workbook, Customizing Workbook, Manage Themes, Create And Use Template(ex-bills)

    Module-6 ( Importing And Exporting)

    Import/Export & Publish
    Exporting Excel Data, Importing Delimited Text File, Publish A Worksheet To The Web, Importing Data From The Web, Create A Web Query

    Enquire Now

    Popup Enquiry Form