Oracle HCM Cloud Placements and Training

Advanced Excel Online Training

One of the top Advanced Excel Online Training institutes in Bangalore with highly skilled trainers

  • 4.7
  • 105 Google reviews
Class Availability
Weekdays & Weekends
Course Duration
40-45 Hours
Training Methodology
25% Theory & 75% Practical

Class Availability

Weekdays & Weekends

Course Duration

40-45 Hours

Training Methodology

25% Theory & 75% Practical

4970

Profesionals Trained

350

Workshops Every Month

50

Countries And Counting

100

Corporate Served Successfully

Advanced Excel Online Training in Bangalore

Advanced Excel Online Training in Bangalore

IQ Stream Technologies is one of the top Excel training institutes in Bangalore with highly experienced and skilled trainers. IQ Stream Technologies Bangalore also offers placement assistance for students who enrolled in Advanced Excel VBA Macro Training Courses. We offer advanced Excel Training classes Bangalore BTM in with excellent learning experiences and tools for better learning, understanding and experience. We follow the most advanced and updated syllabus by highly professionally skilled trainers for Advanced Excel Training and VBA Macro in Bangalore BTM. We also offer top level placement support after completing our Excel Training classes successfully.

Rated 4.7/5
based on 105 reviews

Expert Excel Training Institute

Expert Excel Training Institute

Become and Expert in Excel with IQ Stream Technologies’ advanced Excel learning programmes. Main highlights of our Excel Training in Bangalore (BTM Layout) include Working with Formulas/Functions in Excel, Excel Conditional Formatting, Data Sorting and Filtering, Advance VBA Macro Training Syllabus, Intensive Practical Training, Advanced Learning Materials & Tools, Friendly Classrooms etc. IQ Stream Technologies offer beginner, intermediate and advanced lessons for you to become an expert in the area.

Course Overview

Course Name Excel Training
Venue IQ Stream Technologies
Official URL Excel Training
Demo Classes On Demand
Training Methodology: 25% Theory & 75% Practical
Course Duration 40-45 Hours
Class Availability Weekdays & Weekends
Demo Training Email ID : info@iqstreamtech.com

Syllabus

Introduction to MS Excel and Understanding Basic Working with it

Introduction to MS Excel and Understanding Basic Working with it

  • Introduction to MS Excel, Quick Review on MS Excel Options, Ribbon, Worksheets and Toolbar
  • Difference Between Excel 2003, 2007, 2010 and 2013
  • Saving Excel File as CSV, Macro Enable Sheet, PDF and Older Versions
  • List of Excel Shortcuts
  • Copy, Cut, Paste, Hide, Unhide, Delete and Link the Data in Rows, Columns and Sheets
  • Using Paste Special Options
  • Formatting Cells, Rows, Columns and Sheets
  • Protecting & Unprotecting Cells, Rows, Columns and Sheets with or without Password
  • Page Layout, Themes, Background and Printer Properties
  • Inserting Pictures, Hyperlinks, Header/Footers, Shapes and Other Objects in Worksheets

Working with Formulas/Functions in Excel

Working with Formulas/Functions in Excel

  • VLOOKUP, HLOOKUP, INDEX, ADDRESS, MATCH, OFFSET, TRANSPOSE etc
  • IF / ELSE, AND, OR, NOT, TRUE, NESTED IF/ELSE etc
  • DGET, DMAX, DMIN, DPRODUCT, DSTDEV, DSTDEVP, DSUM, DVAR, DVARP etc
  • DATE, DATEVALUE, DAY, DAY360, SECOND, MINUTES, HOURS, NOW, TODAY, MONTH, YEAR,
  • YEARFRAC, TIME, WEEKDAY, WORKDAY etc
  • CELL, ERROR.TYPE, INFO, ISBLANK, ISERR, ISERROR, ISEVEN, ISLOGICAL, ISNA, ISNONTEXT,
  • ISNUMBER, ISREF, ISTEXT, TYPE etc
  • RAND, ROUND, CEILING, FLOOR, INT, LCM, MOD, EVEN, SUMIF, SUMIFS etc
  • AVEDEV, AVERAGE, AVERAGEA, AVERAGEIF, COUNT, COUNTA, COUNTBLANK,
  • COUNTIF,FORECAST, MAX, MAXA,MIN, MINA, STDEVA etc
  • LEFT, RIGHT, TEXT, TRIM, MID, LOWER, UPPER, PROPER, REPLACE, REPT, FIND, SEARCH,
  • SUBSTITUTE, TRIM, TRUNC, CONVERT, CONCATENATE, DOLLAR etc

Excel Conditional Formatting

Excel 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

Data Sorting and Filtering

  • Sorting Data by Values, Colors, etc
  • Using Filters to Sort Data
  • Advance Filtering Options

Pivot Tables

Pivot Tables

  • Creating Pivot Tables
  • Using Pivot Table Options
  • Changing and Updating Data Range
  • Formatting Pivot Table and Making Dynamic Pivot Tables

Pivot Charts

Pivot Charts

  • Creating Pivot Charts
  • Types of Pivot Charts and Their Usage
  • Formatting Pivot Charts and Making Dynamic Pivot Charts

VBA Macro

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

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
  • User Defined Functions
  • Developing Add In
  • User Forms and GUI
  • Sort and Filter, PivotTables and Pivot charts with VBA Macros
  • ODBC Connectivity to SQL Database and Query Handling
  • File Handling

Konanki Manimala

    • 4.7
Positive: Communication, Professionalism, Quality, Value

Iq stream providing best soft skill class.it was very useful for fresher and who are not able to communicate in front of others.i was thankfull to Sidharth for training me and given confidence that I can speak in English.

Ganesh Nandkhile

    • 4.7
Positive: Communication, Professionalism, Quality, Value
Very useful. Trainer explained the topics with relation to actual work scenario

Geetha KLR

    • 4.7
Positive: Communication, Professionalism, Quality, Value

I had taken Oracle SOA training from Mr. Bhaskar. He is highly experienced and helped us with real time scenarios. The training was very effective. Thanks Mr. Bhaskar for all your support during the training.

    Request Course Demo



                     

    Training

    Related Courses

    Enquiry Now
    close slider

      Enquiry1

      Call Now