About Course
Gyan Vigyan offers Best Coaching Classes for Computer Languages like: C, C++, Python, Java , Sql, Data Structure Training in Delhi with most experienced IT Professionals. Our IT Instructors are having sound knowledge in C, C++, Python, Java and Sql related technologies. We aware of industry needs and we are offering C, C++, Python, Java , Sql, Data Structure Training in Delhi in more practical way. Our team of Professional Trainers offers C , C++ and python in Classroom Training, and C, C++, Python, Java , Sql, Data Structure Corporate Training services. We framed our syllabus to match with the real world requirements for both beginner level to advanced level. Our training will be handled in either weekday or weekends programme depends on participants requirement.
Our Training will be focused on assisting in placements as well. Our C, C++, Python, Java , Sql, Data Structure Training in Delhi Course Fees is very moderate compared to others. We do offer Fast-Track C, C++, Python, Java , Sql, Data Structure Training in Delhi and One-to-One Classes.
Course Content
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...
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
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
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
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)
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
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
- 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
