MS Excel & ADVANCED EXCEL Course in BTM layout, Vijayanagar, Bangalore

Learn Excel & ADVANCED EXCEL Course with Automation VBA, Macros

Excel & ADVANCED EXCEL Course Duration : Upto 3 to 4 Weeks | Daily - 1 hrs theory & Practicals (Fastrack 5 days)

In short term, embark on a journey of mastery in Excel and Advanced Excel at PHILLOS computer Institute in Bangalore. Our course is specifically designed for individuals from diverse quantitative backgrounds, including freshers, graduates, working professionals, BPO and KPO executives, and more, seeking to advance their careers in domains like IT, finance, clinical data, business analysis, HR, and more.

Our advanced Excel training program is not only about learning how to use Excel, but also acquiring job-oriented analytics and reporting skills using tools such as MS-Excel, VBA, MS-Access, SQL, and Tableau. Our expert trainers are real-time corporate professionals who provide hands-on practical guidance and lab facilities to ensure you have a thorough understanding of the course material.

What is advanced Excel ?

Advanced Excel refers to an enhanced skill set and proficiency in using Microsoft Excel, a widely used spreadsheet program. While basic Excel skills involve tasks like data entry, simple calculations, and basic formatting, advanced Excel skills encompass more sophisticated and powerful features. Here are some aspects of advanced Excel:

Formulas and Functions, Data Analysis and Visualization, Advanced Charting, Data Validation and Protection, Automating Tasks with Macros, Advanced Data Functions, Conditional Formatting, Data Consolidation, Solver and Goal Seek, Scenario Manager, Financial Functions, Power Query and Power Pivot, Database Management, Collaboration and Data Sharing, Reporting

The Benefits of a advanced Excel Course in Bangalore ?

Participating in an advanced Excel course in Bangalore offers a multifaceted advantage by equipping individuals with sophisticated data analysis and automation skills, crucial for diverse professional roles. This comprehensive training not only enhances proficiency in complex functions, data visualization, and automation but also provides a practical understanding of advanced tools like Power Query and Power Pivot. As Bangalore is a thriving hub for technology and finance, acquiring advanced Excel skills becomes a valuable asset, propelling individuals towards career growth, improved productivity, and increased employability in various sectors, from finance and analytics to project management and business intelligence.

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.

Introduction to MS Excel & VBA Macros Automation

Microsoft Excel is a powerful spreadsheet program that has become a staple in both professional and personal settings for data management, analysis, and visualization. Developed by Microsoft, Excel is part of the Microsoft Office suite and provides users with a versatile platform to organize, calculate, and present data in a tabular format.

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

LINEAR, GROWTH, DATE, AUTOFILL,
CLEAR OPTIONS,

SORT AND FILTER, FIND OPTIONS

 

INSERT MENU

PIVOT TABLE, PIVOT TABLE WITH PIVOT CHART,
TABLE OPTIONS, PICTURE, CLIP ART, SHAPES,
SMART ART, COLUMNAR CHART, BAR CHART,
PI CHART,DOUGHNUT, HYPERLINK, TEXT BOX,

WORD ART, HEADER AND FOOTER, OBJECT, SYMBOL

 

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

VISUAL BASIC APPLICATION Course Outline (VBA Automation)

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 provided to students

Weekend Training Batches( 4-5 Saturdays)

Duration : 4 -5 Weekends

Fast Track Training Program( 3-4 hours daily)

Duration : within 5 days ( 3-4hrs /day / Monday to friday / theory & practical)

Excel Trainer Profile & Placement

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

Advanced Excel Placement Support in Bangalore

• More than 5000+ students Trained
• 71% percent Placement Record
• 157+ Interviews Support Given