Syntax error

Working with Formulas/Functions • Lookup and Reference Functions: VLOOKUP, HLOOKUP, INDEX, ADDRESS, MATCH, OFFSET, TRANSPOSE etc • Logical Function: IF / ELSE, AND, OR, NOT, TRUE, NESTED IF/ELSE etc • Database Functions: DGET, DMAX, DMIN, DPRODUCT, DSTDEV, DSTDEVP, DSUM, DVAR, DVARP etc • Date and Time Functions: DATE, DATEVALUE, DAY, DAY360, SECOND, MINUTES, HOURS, NOW, TODAY, MONTH, YEAR, YEARFRAC, TIME, WEEKDAY, WORKDAY etc • Information Functions: CELL, ERROR.TYPE, INFO, ISBLANK, ISERR, ISERROR, ISEVEN, ISLOGICAL, ISNA, ISNONTEXT, ISNUMBER, ISREF, ISTEXT, TYPE etc • Math and Trigonometry Functions: RAND, ROUND, CEILING, FLOOR, INT, LCM, MOD, EVEN, SUMIF, SUMIFS etc • Statistical Functions: AVEDEV, AVERAGE, AVERAGEA, AVERAGEIF, COUNT, COUNTA, COUNTBLANK, COUNTIF,FORECAST, MAX, MAXA,MIN, MINA, STDEVA etc • Text Functions: LEFT, RIGHT, TEXT, TRIM, MID, LOWER, UPPER, PROPER, REPLACE, REPT, FIND, SEARCH, SUBSTITUTE, TRIM, TRUNC, CONVERT, CONCATENATE, DOLLAR etc Conditional Formatting • Using Conditional Formatting • Using Conditional Formatting with Multiple Cell Rules • Using Color Scales and Icon Sets in Conditional Formatting • Creating New Rules and Managing Existing Rules Data Sorting and Filtering • Sorting Data A-Z and Z-A • Using Filters to Sort Data • Advance Filtering Options Pivot Tables • Creating Pivot Tables • Using Pivot Table Options • Changing and Updating Data Range • Formatting Pivot Table and Making Dynamic Pivot Tables Pivot Charts • Creating Pivot Charts • Types of Pivot Charts and Their Usage • Formatting Pivot Charts and Making Dynamic Pivot Charts VBA Macro • Introduction to VBA Macro • Recording Macro & Understanding Code Behind • Editing, Writing VBA Code and Saving as Macro or Add-In • Adding Add-Ins in Excel Advance VBA Macro Training Syllabus • Introduction of VBA Macros • Recordings Macro • Working with VBA Editor • VBA Programming Concept • VBA Syntax and Semantics • Variable Type and Declaration • Decisions Making with Operators • Repeating Actions with a Loops • Procedures and Events • Functions • User Forms and GUI • Sort and Filter, PivotTables and Pivot charts with VBA Macros • ODBC Connectivity to SQL Database and Query Handling • File Handling

CSDT Patna is leading PHP Web Training Center or Institute in Patna, Bihar, India.CSDT provides Websites Development training courses/tutorial in PHP.PHP Based Summer training, 6 months project based training,6(six) weeks summer training programme, website development Training. CSDT Qiuck lunch Online PHP Based Courses in patna. CSDT IT Solution is first PHP Based Training Institute, web Training,Industrial Training,Live Project.CSDT Provides Live Project Training for MCABCAB.tech and Other Students. csdt centre is Best PHP website development training institute in Patna bihar India. PHP Training in Patna CSDT PHP/MySql,Web Designing Training in Patna Web Designing is evergreen technologies which will be present our information to the whole web world. Our Web Designing Training in Patna provides End to End support. It’s really an art while creating a full-fledged Website of a client or for a product. If a website’s design is not up-to the standard it will get very minimum impact to the specific audience. Our Trainers for Web Designing is famous freelancers and corporate experts. They are working for companies and they know the international standards in web designing. By using the experience of them anyone can learn the basic to complex level website designing in short time period. After getting enough knowledge in static designs we started to train the students in dynamic languages. We chose PHP and MySQL for that. Reason for that is simple. PHP is the most powerful front end dynamic language in this world. So, by using PHP Training our students convert the static designs into dynamic websites. MySQL is a perfect open source RDBMS which will use by most web applications. Our Web Designing Training in Patna combined both PHP and MySQL in static pages to build a complete Dynamic application. We trained the students to work with MySQL to build a custom CMS. Web Design is not just creating web pages to display some image and content. We have to analyse the purpose of that website first. After reviewing the purpose we can have an idea about what we are going to do with that website. Then we have to mix the perfect composition of ideas and creativity into that to build a solid new website for clients. Each a every project should be unique. CSDT centre are the Best Web Designing Training Institute in Patna with complete structured syllabus.Web Designing Training is combination of both design and development of a website. CSDT Web Designing Training Syllabus covers from basic introduction of web to the perfect dynamic creation of CMS [Content Management System] using PHP. CSDT PHP Syllabus Web Designing:-(HTML,CSS,JAVASCRIPT,JQUERY,AJAX,XML,PHOTOSHOP) PHP Introduction The Origin of PHP, PHP is better than Its alternatives,Interfaces to External systems,Hardware and Software requirements,What a PHP Script Looks Like,Web Designing Basics and WYSIWYG Editor,Receiving User Input,Repeating Code Basic PHP Development How PHP scripts work,Basic PHP syntax,PHP data types,Google Caffeine,displaying type information,Testing for a specific data type, Changing type with Set type,Operators,Variable manipulation,Dynamic variables,Static vs. Dynamic Optimization,Analytics, Analysis and ROI Concept String Manipulation Formatting String for Presentation,Formatting String for Storage,Joining and Splitting String,Comparing String,Matching and replace Substring Control Structures If(), else if() and else if condition Statement,The switch statement,Using the ? operator,Using the while() Loop,The do while statement,Using the for() Loop,Breaking out of loops,Nesting loops Functions What a function,Creating a function,Returning value from function,User-defined functions,Dynamic function calls,Variable scope,Accessing variable with the global statement,Function calls with the static statement,Setting default values for arguments,Passing arguments to a function by value,Passing arguments to a function by reference,Testing for function existence Arrays,Single-Dimensional Arrays,Multidimensional Arrays,Associative arrays,Accessing arrays,Getting the size of an array,Looping through an array,Looping through an associative array,Examining arrays,merging arrays,Sorting arrays,Sorting an associative arrays Working With The File System Creating and deleting a file,Reading and writing text files,Working with directories in PHP,Checking for existence of file,Determining file size,Opening a file for writing, reading, or appending,Writing Data to the file,Reading characters Working With Forms Forms,Super global variables,Super global array,A script to acquire user input,Importing user input,Accessing user input,Combine HTML and PHP code,Using hidden fields,Redirecting the user,File upload and scripts,Delete a File Working With Regular Expressions The basic regular expressions,Matching patterns,Finding matches,Replace patterns Classes And Objects Object oriented concepts,Define a class,Class attributes,An Object,Creating an object,Object properties,Object methods,Object constructors and destructors,Class constants,Static method,Class inheritance,Abstract classes,Final keyword,Implementing Interface,Object serialization,Understanding Advance and New,Checking for class and method existence,Iterators Introduction To Database What is RDBMS technology?,Introduction to SQL,Connecting to the MYSQL,Selecting a database,Adding data to a table,Displaying returned data on Web pages,Finding the number of rows,Looping through database,Inserting data,Deleting data,Entering and updating data,Executing multiple queries,Understanding Primary and Foreign Keys,Understanding Database Normalization,Dealing with Dates and Times Cookies What is a Cookie?,Setting time in a cookie with PHP,Deleting a cookie,Creating session cookie,Working with the query string Session what is session?,Starting a session,Registering Session variables,working with session variables,destroying session,passing session Ids,encoding and decoding session variables,How to increase session expire time,How to work session without cookie? Advance PHP techniques Introduction about FTP/SMTP server,Math functions,File upload,File Download,E-mail with PHP,PHP configuration file,Error tacking and debugging JavaScript (Jquery) Introduction to JavaScript,Form validation using JavaScript,Email validation using JavaScript,Jquery Introduction to XML and its use. AJAX (Asynchronous JavaScript and XML) Introduction to AJAX,Introduction to XMLHttpRequest Object,Method and Properties of XMLHttpRequest,Application of AJAX in web application FrameWork Basic Concepts of Framework,Basic Concept of Code Igniter OsCommerce (Open Source Shopping Cart) Introduction to Shopping Cart,Introduction to osCommerce opensource,Discussion of various module of osCommerce

Providing online and class room training with real scenario's by Python Language professional like SME level person almost all having 13yrs of experience on writing scripts and teaching Introduction History Features Setting up path Working with Python Basic Syntax Variable and Data Types Operator Conditional Statements If If- else Nested if-else Looping For While Nested loops Control Statements Break Continue Pass String Manipulation Accessing Strings Basic Operations String slices Function and Methods Lists Introduction Accessing list Operations Working with lists Function and Methods Tuple Introduction Accessing tuples Operations Working Functions and Methods Dictionaries Introduction Accessing values in dictionaries Working with dictionaries Properties Functions Sets Introduction Accessing values in sets Working with sets Properties Functions Functions Defining a function Calling a function Types of functions Function Arguments Anonymous functions Global and local variables Modules Importing module Math module Random module Packages Composition Input-Output Printing on screen Reading data from keyboard Opening and closing file Reading and writing files Functions Exception Handling Exception Exception Handling Except clause Try ? finally clause User Defined Exceptions & Assertions Advance Python OOPs concept Class and Object Attributes Inheritance Overloading Overriding Data hiding Regular expressions Match function Search function Matching VS Searching Modifiers Patterns Numpy Python  Numpy  Arrays  Array indexing  Datatypes  Array math  Broadcasting  SciPy  Image operations  MATLAB files  Distance between points 4  Matplotlib  Plotting  Subplots  Images  Image Processing with Image Library Pillow Database Introduction Connections Executing queries Transactions Handling error Pandas Introduction to Pandas Pandas-Import modules Create a Data Frame & Write to a CSV file Read data from a file Get data types Add a new column