RAJNI COMPUTER CENTER IN PAHAR GANJ IN DELHI

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