Row case

Peridot systems in Chennai offers best Oracle training with 100% placement.The training will be on practical basis with case studies and experiments.Trainers in our institute are with required subject knowledge and having working experience in top MNCs. Feature of Peridot: Experienced Faculties Training with live projects Least number of students for every batch. Interactive classes Guidance and attention for every student Free lab access Software installations are free Reasonable and affordable fee for the course Syllabus Content: SQL Statement Introduction Basic SQL Statement Storing and restricting data Row functions Subqueries Manipulating data Managing and creating data Database objects PL/SQL Functions Arrays and Variables For further details contact, ph-(papitha) landline:044- kamatchi krupa Apts, Ground floor, venkatarathinam nagar, LB road, Adyar, Chennai-

FOR FREE DEMO contact us at: Phone/WhatsApp: +91-(850) 012-2107 HADOOP ONLINE TRAINING BY REALTIME CORPORATE PROFESSIONALS Hadoop Course Content (we can customize the course content as per your requirement) HADOOP Using Cloudera Development & Admin Course Introduction to BigData, Hadoop:- • Big Data Introduction • Hadoop Introduction • What is Hadoop? Why Hadoop? • Hadoop History? • Different types of Components in Hadoop? • HDFS, MapReduce, PIG, Hive, SQOOP, HBASE, OOZIE, Flume, Zookeeper and so on… • What is the scope of Hadoop? Deep Drive in HDFS (for Storing the Data):- • Introduction of HDFS • HDFS Design • HDFS role in Hadoop • Features of HDFS • Daemons of Hadoop and its functionality • Name Node • Secondary Name Node • Job Tracker • Data Node • Task Tracker • Anatomy of File Wright • Anatomy of File Read • Network Topology • Nodes • Racks • Data Center • Parallel Copying using DistCp • Basic Configuration for HDFS • Data Organization • Blocks and • Replication • Rack Awareness • Heartbeat Signal • How to Store the Data into HDFS • How to Read the Data from HDFS • Accessing HDFS (Introduction of Basic UNIX commands) • CLI commands MapReduce using Java (Processing the Data):- • Introduction of MapReduce. • MapReduce Architecture • Data flow in MapReduce • Splits • Mapper • Portioning • Sort and shuffle • Combiner • Reducer • Understand Difference Between Block and InputSplit • Role of RecordReader • Basic Configuration of MapReduce • MapReduce life cycle • Driver Code • Mapper • and Reducer • How MapReduce Works • Writing and Executing the Basic MapReduce Program using Java • Submission & Initialization of MapReduce Job. • File Input/output Formats in MapReduce Jobs • Text Input Format • Key Value Input Format • Sequence File Input Format • NLine Input Format • Joins • Map-side Joins • Reducer-side Joins • Word Count Example • Partition MapReduce Program • Side Data Distribution • Distributed Cache (with Program) • Counters (with Program) • Types of Counters • Task Counters • Job Counters • User Defined Counters • Propagation of Counters • Job Scheduling PIG:- • Introduction to Apache PIG • Introduction to PIG Data Flow Engine • MapReduce vs PIG in detail • When should PIG used? • Data Types in PIG • Basic PIG programming • Modes of Execution in PIG • Local Mode and • MapReduce Mode • Execution Mechanisms • Grunt Shell • Script • Embedded • Operators/Transformations in PIG • PIG UDF’s with Program • Word Count Example in PIG • The difference between the MapReduce and PIG SQOOP:- • Introduction to SQOOP • Use of SQOOP • Connect to mySql database • SQOOP commands • Import • Export • Eval • Codegen and etc… • Joins in SQOOP • Export to MySQL HIVE:- • Introduction to HIVE • HIVE Meta Store • HIVE Architecture • Tables in HIVE • Managed Tables • External Tables • Hive Data Types • Primitive Types • Complex Types • Partition • Joins in HIVE • HIVE UDF’s and UADF’s with Programs • Word Count Example HBASE:- • Introduction to HBASE • Basic Configurations of HBASE • Fundamentals of HBase • What is NoSQL? • HBase DataModel • Table and Row • Column Family and Column Qualifier • Cell and its Versioning • Categories of NoSQL Data Bases • Key-Value Database • Document Database • Column Family Database • SQL vs NOSQL • How HBASE is differ from RDBMS • HDFS vs HBase • Client side buffering or bulk uploads • HBase Designing Tables • HBase Operations • Get • Scan • Put • Delete MongoDB:-- • What is MongoDB? • Where to Use? • Configuration On Windows • Inserting the data into MongoDB? • Reading the MongoDB data. Cluster Setup:-- • Downloading and installing the Ubuntu12.x • Installing Java • Installing Hadoop • Creating Cluster • Increasing Decreasing the Cluster size • Monitoring the Cluster Health • Starting and Stopping the Nodes OOZIE • Introduction to OOZIE • Use of OOZIE • Where to use? Hadoop Ecosystem Overview Oozie HBase Pig Sqoop Casandra Chukwa Mahout Zoo Keeper Flume • Case Studies Discussions • Certification Guidance • Real Time Certification and • interview Questions and Answers • Resume Preparation • Providing all Materials nd Links • Real time Project Explanation and Practice Phone/WhatsApp: +91-(850) 012-2107

BIGDATA –HADOOP REALTIME TRAINING,JOB SUPPORT,INTERVIEW SUPPORT BY HANDS-ON EXPERTS Phone/WhatsApp: +91-(850) 012-2107 Course Content HADOOP Using Cloudera Development & Admin Course Introduction to BigData, Hadoop:- • Big Data Introduction • Hadoop Introduction • What is Hadoop? Why Hadoop? • Hadoop History? • Different types of Components in Hadoop? • HDFS, MapReduce, PIG, Hive, SQOOP, HBASE, OOZIE, Flume, Zookeeper and so on… • What is the scope of Hadoop? Deep Drive in HDFS (for Storing the Data):- • Introduction of HDFS • HDFS Design • HDFS role in Hadoop • Features of HDFS • Daemons of Hadoop and its functionality • Name Node • Secondary Name Node • Job Tracker • Data Node • Task Tracker • Anatomy of File Wright • Anatomy of File Read • Network Topology • Nodes • Racks • Data Center • Parallel Copying using DistCp • Basic Configuration for HDFS • Data Organization • Blocks and • Replication • Rack Awareness • Heartbeat Signal • How to Store the Data into HDFS • How to Read the Data from HDFS • Accessing HDFS (Introduction of Basic UNIX commands) • CLI commands MapReduce using Java (Processing the Data):- • Introduction of MapReduce. • MapReduce Architecture • Data flow in MapReduce • Splits • Mapper • Portioning • Sort and shuffle • Combiner • Reducer • Understand Difference Between Block and InputSplit • Role of RecordReader • Basic Configuration of MapReduce • MapReduce life cycle • Driver Code • Mapper • and Reducer • How MapReduce Works • Writing and Executing the Basic MapReduce Program using Java • Submission & Initialization of MapReduce Job. • File Input/output Formats in MapReduce Jobs • Text Input Format • Key Value Input Format • Sequence File Input Format • NLine Input Format • Joins • Map-side Joins • Reducer-side Joins • Word Count Example • Partition MapReduce Program • Side Data Distribution • Distributed Cache (with Program) • Counters (with Program) • Types of Counters • Task Counters • Job Counters • User Defined Counters • Propagation of Counters • Job Scheduling PIG:- • Introduction to Apache PIG • Introduction to PIG Data Flow Engine • MapReduce vs PIG in detail • When should PIG used? • Data Types in PIG • Basic PIG programming • Modes of Execution in PIG • Local Mode and • MapReduce Mode • Execution Mechanisms • Grunt Shell • Script • Embedded • Operators/Transformations in PIG • PIG UDF’s with Program • Word Count Example in PIG • The difference between the MapReduce and PIG SQOOP:- • Introduction to SQOOP • Use of SQOOP • Connect to mySql database • SQOOP commands • Import • Export • Eval • Codegen and etc… • Joins in SQOOP • Export to MySQL HIVE:- • Introduction to HIVE • HIVE Meta Store • HIVE Architecture • Tables in HIVE • Managed Tables • External Tables • Hive Data Types • Primitive Types • Complex Types • Partition • Joins in HIVE • HIVE UDF’s and UADF’s with Programs • Word Count Example HBASE:- • Introduction to HBASE • Basic Configurations of HBASE • Fundamentals of HBase • What is NoSQL? • HBase DataModel • Table and Row • Column Family and Column Qualifier • Cell and its Versioning • Categories of NoSQL Data Bases • Key-Value Database • Document Database • Column Family Database • SQL vs NOSQL • How HBASE is differ from RDBMS • HDFS vs HBase • Client side buffering or bulk uploads • HBase Designing Tables • HBase Operations • Get • Scan • Put • Delete MongoDB:-- • What is MongoDB? • Where to Use? • Configuration On Windows • Inserting the data into MongoDB? • Reading the MongoDB data. Cluster Setup:-- • Downloading and installing the Ubuntu12.x • Installing Java • Installing Hadoop • Creating Cluster • Increasing Decreasing the Cluster size • Monitoring the Cluster Health • Starting and Stopping the Nodes OOZIE • Introduction to OOZIE • Use of OOZIE • Where to use? Hadoop Ecosystem Overview Oozie HBase Pig Sqoop Casandra Chukwa Mahout Zoo Keeper Flume • Case Studies Discussions • Certification Guidance • Real Time Certification and • interview Questions and Answers • Resume Preparation • Providing all Materials nd Links • Real time Project Explanation and Practice

BEST HADOOP LIVE TRAINING BY REALTIME CORPORATE PROFESSIONALS Hadoop Course Agenda (we can customize the course content as per your requirement) HADOOP Using Cloudera Development & Admin Course Introduction to BigData, Hadoop:- • Big Data Introduction • Hadoop Introduction • What is Hadoop? Why Hadoop? • Hadoop History? • Different types of Components in Hadoop? • HDFS, MapReduce, PIG, Hive, SQOOP, HBASE, OOZIE, Flume, Zookeeper and so on… • What is the scope of Hadoop? Deep Drive in HDFS (for Storing the Data):- • Introduction of HDFS • HDFS Design • HDFS role in Hadoop • Features of HDFS • Daemons of Hadoop and its functionality • Name Node • Secondary Name Node • Job Tracker • Data Node • Task Tracker • Anatomy of File Wright • Anatomy of File Read • Network Topology • Nodes • Racks • Data Center • Parallel Copying using DistCp • Basic Configuration for HDFS • Data Organization • Blocks and • Replication • Rack Awareness • Heartbeat Signal • How to Store the Data into HDFS • How to Read the Data from HDFS • Accessing HDFS (Introduction of Basic UNIX commands) • CLI commands MapReduce using Java (Processing the Data):- • Introduction of MapReduce. • MapReduce Architecture • Data flow in MapReduce • Splits • Mapper • Portioning • Sort and shuffle • Combiner • Reducer • Understand Difference Between Block and InputSplit • Role of RecordReader • Basic Configuration of MapReduce • MapReduce life cycle • Driver Code • Mapper • and Reducer • How MapReduce Works • Writing and Executing the Basic MapReduce Program using Java • Submission & Initialization of MapReduce Job. • File Input/output Formats in MapReduce Jobs • Text Input Format • Key Value Input Format • Sequence File Input Format • NLine Input Format • Joins • Map-side Joins • Reducer-side Joins • Word Count Example • Partition MapReduce Program • Side Data Distribution • Distributed Cache (with Program) • Counters (with Program) • Types of Counters • Task Counters • Job Counters • User Defined Counters • Propagation of Counters • Job Scheduling PIG:- • Introduction to Apache PIG • Introduction to PIG Data Flow Engine • MapReduce vs PIG in detail • When should PIG used? • Data Types in PIG • Basic PIG programming • Modes of Execution in PIG • Local Mode and • MapReduce Mode • Execution Mechanisms • Grunt Shell • Script • Embedded • Operators/Transformations in PIG • PIG UDF’s with Program • Word Count Example in PIG • The difference between the MapReduce and PIG SQOOP:- • Introduction to SQOOP • Use of SQOOP • Connect to mySql database • SQOOP commands • Import • Export • Eval • Codegen and etc… • Joins in SQOOP • Export to MySQL HIVE:- • Introduction to HIVE • HIVE Meta Store • HIVE Architecture • Tables in HIVE • Managed Tables • External Tables • Hive Data Types • Primitive Types • Complex Types • Partition • Joins in HIVE • HIVE UDF’s and UADF’s with Programs • Word Count Example HBASE:- • Introduction to HBASE • Basic Configurations of HBASE • Fundamentals of HBase • What is NoSQL? • HBase DataModel • Table and Row • Column Family and Column Qualifier • Cell and its Versioning • Categories of NoSQL Data Bases • Key-Value Database • Document Database • Column Family Database • SQL vs NOSQL • How HBASE is differ from RDBMS • HDFS vs HBase • Client side buffering or bulk uploads • HBase Designing Tables • HBase Operations • Get • Scan • Put • Delete MongoDB:-- • What is MongoDB? • Where to Use? • Configuration On Windows • Inserting the data into MongoDB? • Reading the MongoDB data. Cluster Setup:-- • Downloading and installing the Ubuntu12.x • Installing Java • Installing Hadoop • Creating Cluster • Increasing Decreasing the Cluster size • Monitoring the Cluster Health • Starting and Stopping the Nodes OOZIE • Introduction to OOZIE • Use of OOZIE • Where to use? Hadoop Ecosystem Overview Oozie HBase Pig Sqoop Casandra Chukwa Mahout Zoo Keeper Flume • Case Studies Discussions • Certification Guidance • Real Time Certification and • interview Questions and Answers • Resume Preparation • Providing all Materials nd Links • Real time Project Explanation and Practice

Demo has Scheduled Today BEST HADOOP ONLINE CERTIFICATION LEVEL TRAINING FROM HYDERABAD,INDIA FOR FREE DEMO contact us: Phone/WhatsApp: +91-(850) 012-2107 Interview Questions and Answers, Recorded Video Sessions, Materials, Mock Interviews Assignments Will be provided Hadoop Key Concepts (we can modify the course content as per your requirement) HADOOP Using Cloudera Development & Admin Course Introduction:- • Big Data Introduction • Hadoop Introduction • What is Hadoop? Why Hadoop? • Hadoop History? • Different types of Components in Hadoop? • HDFS, MapReduce, PIG, Hive, SQOOP, HBASE, OOZIE, Flume, Zookeeper and so on… • What is the scope of Hadoop? Deep Drive in HDFS (for Storing the Data):- • Introduction of HDFS • HDFS Design • HDFS role in Hadoop • Features of HDFS • Daemons of Hadoop and its functionality • Name Node • Secondary Name Node • Job Tracker • Data Node • Task Tracker • Anatomy of File Wright • Anatomy of File Read • Network Topology • Nodes • Racks • Data Center • Parallel Copying using DistCp • Basic Configuration for HDFS • Data Organization • Blocks and • Replication • Rack Awareness • Heartbeat Signal • How to Store the Data into HDFS • How to Read the Data from HDFS • Accessing HDFS (Introduction of Basic UNIX commands) • CLI commands MapReduce using Java (Processing the Data):- • Introduction of MapReduce. • MapReduce Architecture • Data flow in MapReduce • Splits • Mapper • Portioning • Sort and shuffle • Combiner • Reducer • Understand Difference Between Block and InputSplit • Role of RecordReader • Basic Configuration of MapReduce • MapReduce life cycle • Driver Code • Mapper • and Reducer • How MapReduce Works • Writing and Executing the Basic MapReduce Program using Java • Submission & Initialization of MapReduce Job. • File Input/output Formats in MapReduce Jobs • Text Input Format • Key Value Input Format • Sequence File Input Format • NLine Input Format • Joins • Map-side Joins • Reducer-side Joins • Word Count Example • Partition MapReduce Program • Side Data Distribution • Distributed Cache (with Program) • Counters (with Program) • Types of Counters • Task Counters • Job Counters • User Defined Counters • Propagation of Counters • Job Scheduling PIG:- • Introduction to Apache PIG • Introduction to PIG Data Flow Engine • MapReduce vs PIG in detail • When should PIG used? • Data Types in PIG • Basic PIG programming • Modes of Execution in PIG • Local Mode and • MapReduce Mode • Execution Mechanisms • Grunt Shell • Script • Embedded • Operators/Transformations in PIG • PIG UDF’s with Program • Word Count Example in PIG • The difference between the MapReduce and PIG SQOOP:- • Introduction to SQOOP • Use of SQOOP • Connect to mySql database • SQOOP commands • Import • Export • Eval • Codegen and etc… • Joins in SQOOP • Export to MySQL HIVE:- • Introduction to HIVE • HIVE Meta Store • HIVE Architecture • Tables in HIVE • Managed Tables • External Tables • Hive Data Types • Primitive Types • Complex Types • Partition • Joins in HIVE • HIVE UDF’s and UADF’s with Programs • Word Count Example HBASE:- • Introduction to HBASE • Basic Configurations of HBASE • Fundamentals of HBase • What is NoSQL? • HBase DataModel • Table and Row • Column Family and Column Qualifier • Cell and its Versioning • Categories of NoSQL Data Bases • Key-Value Database • Document Database • Column Family Database • SQL vs NOSQL • How HBASE is differ from RDBMS • HDFS vs HBase • Client side buffering or bulk uploads • HBase Designing Tables • HBase Operations • Get • Scan • Put • Delete MongoDB:-- • What is MongoDB? • Where to Use? • Configuration On Windows • Inserting the data into MongoDB? • Reading the MongoDB data. Cluster Setup:-- • Downloading and installing the Ubuntu12.x • Installing Java • Installing Hadoop • Creating Cluster • Increasing Decreasing the Cluster size • Monitoring the Cluster Health • Starting and Stopping the Nodes OOZIE • Introduction to OOZIE • Use of OOZIE • Where to use? Hadoop Ecosystem Overview Oozie HBase Pig Sqoop Casandra Chukwa Mahout Zoo Keeper Flume • Case Studies Discussions • Certification Guidance • Real Time Certification and • interview Questions and Answers • Resume Preparation • Providing all Materials nd Links • Real time Project Explanation and Practice Phone/WhatsApp: +91-(850) 012-2107

HADOOP ONLINE TRAINING,CORPORATE TRAINING,JOB AND INTERVIEW SUPPORT BY CORPORATE PROFESSIONALS Interview Questions and Answers, Recorded Video Sessions, Materials, Mock Interviews Assignments Will be provided Hadoop Concepts (we can modify the course content as per your requirement) HADOOP ADMIN AND DEVELOPMENT Introduction:- • Big Data Introduction • Hadoop Introduction • What is Hadoop? Why Hadoop? • Hadoop History? • Different types of Components in Hadoop? • HDFS, MapReduce, PIG, Hive, SQOOP, HBASE, OOZIE, Flume, Zookeeper and so on… • What is the scope of Hadoop? Deep Drive in HDFS (for Storing the Data):- • Introduction of HDFS • HDFS Design • HDFS role in Hadoop • Features of HDFS • Daemons of Hadoop and its functionality • Name Node • Secondary Name Node • Job Tracker • Data Node • Task Tracker • Anatomy of File Wright • Anatomy of File Read • Network Topology • Nodes • Racks • Data Center • Parallel Copying using DistCp • Basic Configuration for HDFS • Data Organization • Blocks and • Replication • Rack Awareness • Heartbeat Signal • How to Store the Data into HDFS • How to Read the Data from HDFS • Accessing HDFS (Introduction of Basic UNIX commands) • CLI commands MapReduce using Java (Processing the Data):- • Introduction of MapReduce. • MapReduce Architecture • Data flow in MapReduce • Splits • Mapper • Portioning • Sort and shuffle • Combiner • Reducer • Understand Difference Between Block and InputSplit • Role of RecordReader • Basic Configuration of MapReduce • MapReduce life cycle • Driver Code • Mapper • and Reducer • How MapReduce Works • Writing and Executing the Basic MapReduce Program using Java • Submission & Initialization of MapReduce Job. • File Input/output Formats in MapReduce Jobs • Text Input Format • Key Value Input Format • Sequence File Input Format • NLine Input Format • Joins • Map-side Joins • Reducer-side Joins • Word Count Example • Partition MapReduce Program • Side Data Distribution • Distributed Cache (with Program) • Counters (with Program) • Types of Counters • Task Counters • Job Counters • User Defined Counters • Propagation of Counters • Job Scheduling PIG:- • Introduction to Apache PIG • Introduction to PIG Data Flow Engine • MapReduce vs PIG in detail • When should PIG used? • Data Types in PIG • Basic PIG programming • Modes of Execution in PIG • Local Mode and • MapReduce Mode • Execution Mechanisms • Grunt Shell • Script • Embedded • Operators/Transformations in PIG • PIG UDF’s with Program • Word Count Example in PIG • The difference between the MapReduce and PIG SQOOP:- • Introduction to SQOOP • Use of SQOOP • Connect to mySql database • SQOOP commands • Import • Export • Eval • Codegen and etc… • Joins in SQOOP • Export to MySQL HIVE:- • Introduction to HIVE • HIVE Meta Store • HIVE Architecture • Tables in HIVE • Managed Tables • External Tables • Hive Data Types • Primitive Types • Complex Types • Partition • Joins in HIVE • HIVE UDF’s and UADF’s with Programs • Word Count Example HBASE:- • Introduction to HBASE • Basic Configurations of HBASE • Fundamentals of HBase • What is NoSQL? • HBase DataModel • Table and Row • Column Family and Column Qualifier • Cell and its Versioning • Categories of NoSQL Data Bases • Key-Value Database • Document Database • Column Family Database • SQL vs NOSQL • How HBASE is differ from RDBMS • HDFS vs HBase • Client side buffering or bulk uploads • HBase Designing Tables • HBase Operations • Get • Scan • Put • Delete MongoDB:-- • What is MongoDB? • Where to Use? • Configuration On Windows • Inserting the data into MongoDB? • Reading the MongoDB data. Cluster Setup:-- • Downloading and installing the Ubuntu12.x • Installing Java • Installing Hadoop • Creating Cluster • Increasing Decreasing the Cluster size • Monitoring the Cluster Health • Starting and Stopping the Nodes OOZIE • Introduction to OOZIE • Use of OOZIE • Where to use? Hadoop Ecosystem Overview Oozie HBase Pig Sqoop Casandra Chukwa Mahout Zoo Keeper Flume • Case Studies Discussions • Certification Guidance • Real Time Certification and • interview Questions and Answers • Resume Preparation • Providing all Materials nd Links • Real time Project Explanation and Practice

Program Name: Basic Excel 2010 Duration: 8 hrs Training Content:. Creating a Basic Worksheet · Customize the Quick Access Toolbar · Enter Data and Save a Workbook · Explore the User Interface and the Ribbon · Navigate and Select in Excel · Obtain Help Performing Calculations · Calculate with Functions · Copy Formulas and Functions · Create Basic Formulas Modifying a Worksheet · Insert and Delete Cells, Columns, and Rows · Manipulate Data · Search for Data in a Worksheet · Spell Check a Worksheet Formatting a Worksheet · Add Borders and Color to Cells · Apply Cell Styles · Apply Number Formats · Change Column Width and Row Height · Modify Fonts · Position Cell Contents Printing Workbook Contents · Print Workbook Contents Using Default Print Options · Set Page Breaks · Set Print Options Managing Large Workbooks · Format Worksheet Tabs · Manage Worksheets in a Workbook Training Name: HB Certified Programme in Intermediate Excel 2010 Duration: 16 hrs Training Content: Creating and Editing Formulae • Concept of Formulae • Creating Formulae, Editing Formulae • Mathematical Order • Copying Formulae • Using Functions - Sum, Average, Max, Min, Count, Counta • Applying Absolute (Fixed) Referencing Formatting and Proofing • Formatting Cells with Number formats, Font formats, Alignment, Borders, etc • Basic conditional formatting • Copying and Clearing Formats • Working with Styles • Spell Check, Find & Replace and AutoCorrect Range Names • Naming individual or range cells • Deleting and amending named ranges • Using named cells/ranges in formulae Conditional Functions & Formats and Date Calculations • Benefits and purpose • If Statements, Nested If • And, Or, Not • Combining If, And, Or, Not • Sumif, Countif • Conditional Formatting • Entering Dates and Times • Different date/time formats • How dates are stored • Calculating working days • Using the DAY(),MONTH(),YEAR() functions Formulae Auditing • Formula Auditing Tools • Revealing Formulae • Tracing Precedents/Dependents • Goto Special Worksheet Management & Linking • Linking sheets in the same file • Linking different Excel files • Using Edit, Links • Viewing different files at once • Saving a workspace • Viewing different sheets at once • Window Split • Data consolidation Basic List Management • Sorting Data • Adding Subtotals • Autofilter • Freeze Panes • Group and Outline • Data Form Excel Charts / Graphs • Using the Chart Wizard • Editing and Formatting charts • Saving custom chart types • Setting a default chart type Lookup & Information Functions • Vertical Lookup (Vlookup) • Horizontal Lookup (Hlookup) • Match and Index • IsText, IsValue, IsDate, IsNull, IsErr, Is Error, IsNa Advanced List Management • Advanced Filters • Using List Features • Dynamic Lists Pivot Tables • Using the Pivot Table Wizard • Changing the pivot table layout • Formatting • Grouping items • Inserting calculated fields • Pivot Table Options • Display and hide data in fields • Lay out reports directly on worksheet • Pivot Chart What If Analysis • Scenarios • Goal Seek • Solver Protecting & Sharing Files • Sharing a file • Tracking changes • Protecting file • Accepting or rejecting changes • Applying Data validation rules • Inserting comments Introduction to Macros • Purpose of Macros • Recording macros • Where to save macros • Running macros: • Custom buttons, menu items, keyboard shortcuts Visual Basic for Applications Environment • Visual Basic Editor and its options • Component Management • Shortcuts Connecting to Database/Outlook • Connect to MS Access • Access Database & Retrieve Data from MS Access • Create Table & Query Data Filter DB using Query • Update and Modify DB • Retrieve the Information through Excel from Outlook using VBA Advanced Excel 2010 Training Name: HB Certified Programme in Advanced Excel 2010 Duration: 24 hrs Training Content: Getting started with Macros · Recording and Modifying Macros · Assigning Macros to Toolbar, Buttons, Shortcut key Visual Basic for Applications Environment · Visual Basic Editor and its options · Component Management · Shortcuts Introduction to Procedural Programming · Procedures: Functions and Sub-routines · Data Types Control Flow · If...Then....Elseif....Else....Endif · Case · Do...Loop, While · For... Next · Exit · VBA and Sheet Data Exchange (Cells, Range Methods) · Getting and Printing Data from Users (InputBox, MsgBox) · how to link with Ms Access and SQL Call/Whatsapp 8939693655