Robotic Process Automation Training in Chennai

gantryrocketLorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industrys standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged.  Neither can you find a centre as excellent as ours nor can you build the developers like we have developed here. We don’t just develop Java experts; we build and recreate IT professionals for a better future in a global scenario. We connect to the students through web interface and a part of our training is completely digitalised, for making the students practically understand the programming language.

When the classes are theoretical, we don’t hurdle up there, there are practical sessions that help the learners learn an epoch regarding Java. While we ponder over Java, we also teach them the basics of other programming languages and help them grow from the scratch. SLA deals with a huge lot of technologically advanced and empirically selected system of education that aids the holistic development of a candidate. Placement, being our forte, we delve into not just growth, but setting a high pedestal for a lifetime.
It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.

Advanced Excel Course Syllabus

Excel Introduction

  • An overview of the screen, navigation and basic spreadsheet concepts
  • Various selection techniques
  • Shortcut Keys
  • Customizing Excel

  • Customizing the Ribbon
  • Using and Customizing AutoCorrect
  • Changing Excel’s Default Options
  • Using Basic Functions

  • Using Functions - Sum, Average, Max,Min, Count, Counta
  • Absolute, Mixed and Relative Referencing
  • Formatting & Proofing

  • Formatting Cells with Number formats, Font formats, Alignment, Borders, etc
  • Basic conditional formatting
  • Mathematical Functions

  • SumIf, SumIfs CountIf, CountIfs AverageIf, AverageIfs
  • Protecting Excel

  • File Level Protection
  • Workbook, Worksheet Protection
  • Text Functions

  • Upper, Lower, Proper
  • Left, Mid, Right
  • Trim, Len, Exact
  • Concatenate
  • Find, Substitute
  • Date & Time Functions

  • Today, Now
  • Day, Month, Year
  • Date, Date if, DateAdd
  • EOMonth, Weekday
  • Advanced Paste Special Techniques

  • Paste Formulas, Paste Formats
  • Paste Validations
  • Transpose Tables
  • New in Excel 2013 / 2016 & 365

  • New Charts - Tree map & Waterfall
  • Sunburst, Box and whisker Charts
  • Combo Charts – Secondary Axis
  • Adding Slicers Tool in Pivot & Tables
  • Using Power Map and Power View
  • Forecast Sheet
  • Sparklines -Line, Column & Win/ Loss
  • Using 3-D Map
  • New Controls in Pivot Table - Field, Items and Sets
  • Various Time Lines in Pivot Table
  • Auto complete a data range and list
  • Quick Analysis Tool
  • Smart Lookup and manage Store
  • Sorting and Filtering

  • Filtering on Text, Numbers & Colors
  • Sorting Options
  • Advanced Filters on 15-20 different criteria(s)
  • Printing Workbooks

  • Setting Up Print Area
  • Customizing Headers & Footers
  • Designing the structure of a template
  • Print Titles –Repeat Rows / Columns
  • Advanced Excel

    What If Analysis

  • Goal Seek
  • Scenario Analysis
  • Data Tables (PMT Function)
  • Solver Tool
  • Logical Functions

  • If Function
  • How to Fix Errors - iferror
  • Nested If
  • Complex if and or functions
  • Data Validation

  • Number, Date & Time Validation
  • Text and List Validation
  • Custom validations based on formula for a cell
  • Dynamic Dropdown List Creation using Data Validation – Dependency List
  • Lookup Functions

  • Vlookup / HLookup
  • Index and Match
  • Creating Smooth User Interface Using Lookup
  • Nested VLookup
  • Reverse Lookup using Choose Function
  • Worksheet linking using Indirect
  • Vlookup with Helper Column
  • Pivot Tables

  • Creating Simple Pivot Tables
  • Basic and Advanced Value Field Setting
  • Classic Pivot table
  • Grouping based on numbers and Dates
  • Calculated Field & Calculated Items
  • Arrays Functions

  • What are the Array Formulas, Use of the Array Formulas?
  • Basic Examples of Arrays (Using ctrl+shift+enter).
  • Array with if, len and mid functions formulas.
  • Array with Lookup functions.
  • Advanced Use of formulas with Array.
  • Charts and slicers

  • Various Charts i.e. Bar Charts / Pie Charts / Line Charts
  • Using SLICERS, Filter data with Slicers
  • Manage Primary and Secondary Axis
  • Excel Dashboard

  • Planning a Dashboard
  • Adding Tables and Charts to Dashboard
  • Adding Dynamic Contents to Dashboard

  • Related Links

    Enquire Now