- 1 Month
- 25 Hours
Our courses offer a good compromise between the continuous assessment favoured by some universities and the emphasis placed on final exams by others.
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.
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...
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
Trace Cell, Trouble Shoot Error In Formulas, Troubleshoot invalid Data And Formula, Watch And Evalute Formula
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
Freelance Accountants, Business Owners, Students aspiring for a Career in finance, accounting & taxation. (12th, Undergraduates, Graduates, B.com, M.com, MBAs)