![]() Cell, Column, Row, Worksheet and Workbook. Sum & Sumif Average Max and Min Basic Operator (+ - / *^) Greater than, equal to or less than (< = >) Round , Roundup and Round down Sorting and filtering data If and Else Conditional Formatting Vlookup True & False ![]() Module 2 : Data Handling - I Data Validation Grouping, Ungrouping and Subtotals Filters, Custom Filters, Advanced Filters & List Type Pivot Tables & Merge pivots from multiple locations Goal Seek Consolidate data From multiple files Split Data using Text to Columns Remove Duplicates Watch Window Data Recovery ![]() | Module 3 : Data Handling - II Importing Data from another location or file. Sort Data on single & multiple criteria. Protect Excel Files, Workbook, Protect Worksheet and Cells Find Replace Blank Cells Format Painter Hyperlinks Naming a Range, Cell etc. Module 4 : Advance Excel a) Text Functions LEFT,RIGHT,MID & TRIM PROPER, UPPER, LOWER, Clean…..etc. FIND & REPLACE Exact b. Date and Time Functions Day Days360 Now Today Time…etc. c. Mathematical Functions SumIFS Even Combine ODD Product RAND RANDBETWEEN d. Statistical Functions Len Count Count A CountIF, CountIFS Count Blank Rank Average,AverageIF &AverageIFS SubtotalSign. e) Logical Informatics Functions Cell ISERROR ISNA INFO...etc. Formula editing mode. Show Formula Error Checking Calculations Options. And & OR IF & Nested IF IF Error , Is Error & ISNA Multiple IF Conditions IF….Vlookup….Match IF…Hlookup….Match CONCATENATE & “&”. f) Look Up & Reference Functions Lookup & H-lookup Address Choose INDEX MATCH Rows Transpose…etc. | Module 5: Macro & VBE Basics Excel and Visual Basic Editor Cell, Column, Row, Worksheet and Workbook. Basic formula SUM, Max and Min, If & Else, Vlookup, Sum, Mid, Is Error Etc. Combine Multiple Formulas in One Record and running macro Store Macro in different books Create Buttons & Assign Macro to it Sort and Filter Data Create Custom Menus & Toolbars Module 6: Automation with VBA Macros Introduction to VBE (Visual Basic Editor) Edit Macro Using VBE How to start write code Create Conditions (If…. Elseif …… Else or Select Case) Loop constructs (For….. Next, Do….. Loop, While… Wend) Logical Operators ( + - x ÷) Working with Cell, Column, Row, Range, Worksheet and Workbook. Copying and pasting Module 7 : User Forms and its Toolbox Variables, data types and constants Creating Data Entry forms and other Use of User forms. Working with VBA Toolbox and forms Creating Add-ins Assignment Module 8 : Excel Re-Engineering Creating functions Error Handling Call Macros Pivot Table Module 9 - MS - Access & SQL Basics Introduction to MS - Access, Create Query, Tables & Relationships, Basic Queries Using SQL Import & Export Data from Other Sources Data Queries Left Inner & Right Joints SQL Expressions Terminology SQL Basic - DDL, DML, DCL, DQL Import, Export, Joints,Truncate Database key - - - - - - - - - - - - - - - - - - - - Placement Support Services available for Trainees at no additional cost Call 96505 15620 for a Free Demo Class - - - - - - - - - - - - - - - - - - - - Practical MIS & Analytics Training Provided by Experienced Sr. Managers with Leading Corporates & MNC's Interview Questions Covered throughout the Program |