Join Best Excel and Advanced Excel Training in Bangalore, Excel and Advanced Excel Course in Bangalore, Excel and Advanced Excel Institute in Bangalore

PHILLOS training institute Bangalore offers an inclusive Excel and Advanced Excel training in Bangalore. The extensive practical training provided by Excel and Advanced Excel training institute in Bangalore equips live projects and simulations. Such detailed Excel and Advanced Excel course has helped our students secure job in various MNCs. The trainers at PHILLOS training institute Bangalore are subject specialist corporate professionals providing in-depth study in Excel and Advanced Excel course in Bangalore. Participants completing the Excel and Advanced Excel certification have plethora of job opportunities in the industry.

Elegiblity of learning Advanced Excel course from various quantitative backgrounds Freshers, Graduates, undergraduates, working proffesional, BPO, KPO executives, etc. For anybody and Everybody who is looking for best career in IT, Finance, Clinical data, business analysts or analysts, HR, Etc domains advance Excel training but also want to learn job oriented Analytics & Reporting skills using MS-Excel, VBA, MS-Access, SQL and Tableau.

Our Advanced Excel Training in Bangalore is scheduled normally at a time that best suites you, we offer regular training classes (day time classes), weekend training classes, and fast track training classes. Our Advanced Excel Training course fee is economical and tailor-made based on training requirement. Our team will make you confident & comfortable in cracking interviews.

We also provide weekend training through which you can access our tutorial Anywhere, Anytime which is valuable and Low Cost. We provide a captivating effective interactive environment with dynamic content, e-Learning that not only effectively keeps people up-to-date, but interested as well. Its a One Stop Learning solutions for all IT and Non IT Training in Jayanagar, Bangalore.

Do you know...?

For MS Excel 2010, Row numbers ranges from 1 to 1048576; in total 1048576 rows,
and Columns ranges from A to XFD; in total 16384 columns.

SAP Fico Course Duration

Regular Track - 1 month | 1.5 hours a day | Live Classroom
Online Class - 1 month | 1 hour a day | Live Classroom
Weekend Track - 4 to 5 Weekends | 3 hours a day | Live Classroom
Fast Track - 3 to 5 Days | 3 to 4 hours a day | Live Classroom

Introduction to MS Excel

What you learn ? Basic to advanced excel | Data importing | Analysis | Reporting | Automation using VBA Macros | MIS Reporting

INSERT SHEET ROW,SHEET
COLUMN,FORMAT OPTIONS, CONDITIONAL,
FORMATING, FILL OPTIONS,

LINEAR, GROWTH, DATE, AUTOFILL,
CLEAR OPTIONS,

SORT AND FILTER, FIND OPTIONS

Insert Menu Option In Excel

How to use the Pivot Tables & Pivot Table With Pivot Charts in Excel
Using the Table Options, Picture, Clip Art, Shapes
Using the Columnar Chart, Bar Chart, Pi Chart, Doughnut
Using the Smart Art, Hyperlink, Text Boxes

Using the Word Art, Header & Footer, Object, Symbol options

Working with PAGE LAYOUT MENU

MARGINS, ORIENTATION, SIZE, SET PRINT AREA,

REMOVE PRINT AREA, PAGE BREAK, BACK GROUND,

PRINT TITLES, GRID LINES, HEADING.

FORMULA MENU

MATHEMATICAL FUNCTIONS

SUM, SUMIF, SUMIFS, COUNT, COUNTIF, COUNTIFS,

MOD, SQRT, ROUND, ROMAN, COUNTA, AVERAGEIF

CHARACTER FUNCTIONS

UPPER, LOWER, PROPER, CONCATENATE,

LEFT, RIGHT,LENGTH

DATE FUNCTIONS

TODAY(), NOW(), EDATE(), EOMONTH(), NETWORKDAYS(), DATEDIF()

BOOLEAN FUNCTIONS

AND, OR IF CONDITION,

COMPOUND IF STATEMENTS TRACE PRECEDENCTS,

TRACE DEPENDENTS,

WATCH WINDOW,

FORMULA AUDITING,

ERROR CHECKING,

DEFINE NAME, NAME MANAGER

DATA MENU

SUBTOTAL,GROUP,UNGROUP,

SCENARIO MANAGER

GOAL SEEK,DATA TABLE,

CONSOLIDATE

DATA VALIDATION,

REMOVE DUPLICATES,

TEXT TO COLUMNS,

ADVANCED FILTER,

SORT, GET EXTERNAL DATA

REVIEW MENU

COMMENT,

PROTECTING SPREAD SHEET,

PROTECT WORKBOOK,

ALLOWS USER TO EDIT RANGES.

VIEW

NORMAL, PAGE LAYOUT,

CUSTOM VIEW,

FULL SCREEN,

SHOW HIDE, ZOOM,

NEW WINDOW,

FREEZE PANES,

SAVE WORK SPACE

OTHER FUNCTIONS

VLOOKUP

HLOOKUP

MATCH
INDEX
INDIRECT
ISNA

VBA & Macros Course Outline

CONTROLE FLOW STRUCTURES

LINEAR

SEQUENTIAL

ITERATIVES

HOW TO WRITE RANGE PRINT USING LINEAR PROGRAMMING

HOW TO USE EXIT SUB

HOW TO USE MESSAGE BOX and INPUTBOX

HOW TO DECLARE VARIABLES AND USING VARIABLES HOW TO TAKE PRINT ON

EXCEL SHEET AND MESSAGE BOX

IF STATEMENTS

GOTO STATEMENTS IN IF CONDITION

IF ELSE STATEMENTS

DO LOOP (ENTRY CONDITIONAL LOOP)

DO WHILE LOOP (EXIT CONDITIONAL LOOP)

DO UNTIL LOOP

FOR LOOP

SINGLE DIMENTIONAL ARRAY

TWO DIMENTIONAL ARRAY

SWITCH CASE PROGRAMMING

EVENT DRIVEN PROGRAMMING

HOW TO CREATE COMMAND BUTTONS

HOW TO WRITE LINEAR, SEQUENTIAL, ITERATIVES USING COMMAND BUTTONS

ASIGNING MACROS TO SHAPES

CREATING USER FORMS

HOW TO CREATE PAY SLIP USING FORMS

HOW TO TAKE PRINT ON EXCEL SHEET USING FORMS

HOW TO WRITE VLOOKUP USING FORM

HOW TO CREATE MENU ITEMS USING MULTITAB, TABS ON FORM

HOW TO USE CHECK BOX AND OPTION BUTTONS ON FORMS

HOW TO CALL USER DEFINED FUNCTIONS IN FORMS

USER DEFINED FUNCTIONS

HOW TO CONVERT FORMULAS INTO USER DEFINED FUNCTIONS

HOW TO WRITE IF ELSE STATEMENTS USING FUNCTIONS

HOW TO CALL USER DEFINED FUNCTIONS ON EXCEL SHEETS

HOW TO CALL USER DEFINED FUNCTIONS IN MACROS AND FORMS

CLASSES AND OBJECTS

HOW TO CREATE CLASS FUNCTIONS AND

CREATING OBJECT AND

CALLING FUNCTION IN FORMS

Advanced Excel Course MaterialS Will Be GIVEN to students

Advanced Excel Trainer Profile & Placement

More than 9+ Years of experience in Advanced Excel, SAS, SQL & other analytical Technologies.
Trained 3000+ Students so far.
Strong Theoretical & Practical Knowledge