Learn Excel & ADVANCED EXCEL Course with Automation VBA, Macros
Excel & ADVANCED EXCEL Course Duration : Upto 30 days | 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.
Our flexible schedule accommodates different lifestyles, including regular day time classes, weekend classes, and fast-track classes. Our course fee is tailored to your individual training requirements and is affordably priced. With our strong emphasis on placement assistance and job support, our team will empower you with the confidence and skills necessary to excel in job interviews.
For those who are unable to attend regular classes, we offer weekend tutorials that are accessible anytime and anywhere, providing a low-cost learning solution. Our advanced Excel training program also features an interactive and engaging e-learning environment with dynamic content, making it a one-stop-shop 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.
Introduction to MS Excel & VBA Macros Automation
INSERT SHEET ROW,SHEET
COLUMN,FORMAT OPTIONS, CONDITIONAL,
FORMATING, FILL OPTIONS,
LINEAR, GROWTH, DATE, AUTOFILL,
SORT AND FILTER, FIND OPTIONS
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.
SUM, SUMIF, SUMIFS, COUNT, COUNTIF, COUNTIFS,
MOD, SQRT, ROUND, ROMAN, COUNTA, AVERAGEIF
UPPER, LOWER, PROPER, CONCATENATE,
TODAY(), NOW(), EDATE(), EOMONTH(), NETWORKDAYS(), DATEDIF()
AND, OR IF CONDITION,
COMPOUND IF STATEMENTS TRACE PRECEDENCTS,
DEFINE NAME, NAME MANAGER
GOAL SEEK,DATA TABLE,
TEXT TO COLUMNS,
SORT, GET EXTERNAL DATA
PROTECTING SPREAD SHEET,
ALLOWS USER TO EDIT RANGES.
NORMAL, PAGE LAYOUT,
SHOW HIDE, ZOOM,
SAVE WORK SPACE
VISUAL BASIC APPLICATION Course Outline (VBA Automation)
CONTROLE FLOW STRUCTURES
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
GOTO STATEMENTS IN IF CONDITION
IF ELSE STATEMENTS
DO LOOP (ENTRY CONDITIONAL LOOP)
DO WHILE LOOP (EXIT CONDITIONAL LOOP)
DO UNTIL 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 9+ 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
Students can choose a batch of their choice, weekend batches are available for working professionals
Very Less Fee Structure
Comapred to other institute fee structure here is very less
Practical Courses provide effective training since it covers all the areas of the course.
Course Completion certificates will be issued after the courses
Softcopy of course material will be given to every student
Placement support will be done after the course completion
Teachers can focus on the query of all students individually.
While studying you will be working on live projects for better understanding.
courses are more focused on practical knowledge and Live Training rather than theoretical knowledge.
Creative DESIGNING Courses