Duration : 30 days | 1hr theory/day 1hr Practical

 

Introduction to MS Excel

 

BOLD, UNDERLINE, ITALIC, INCREASE FONTSIZE,
DECREASE FONT SIZE,

MERGE AND CENTER,
WRAP TEXT,

ORIENTATION, INCREASE INDENT,
DECREASE INDENT, ALIGNMENTS,

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,

 

PROTECT 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)

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

 

 


Contact US

A : PHILLOS,
#257, (BIIT Building),9th A Main, Near Upahaara Darshini,

 3rd Block, Jayanagar, Bangalore - 560011

E : : nishu.phillos@gmail.com

Click to call : 9620890035 / 9844885059

Click on Whatsapp: +91-9844885059

Facebook | Linked in | Google + | Google Web




BUSINESS ANALYTICS COURSE


Advanced Excel & MIS Course

VBA & Macros Course

SAS Base & Advanced Course

Clinical sas Course

Statistical Analysis SAS Course

MSBI SSIS SSRS SSAS Course

Tableau Course

Business Analytics



SAP ERP COURSES


 

SAP fico Course

SAP ABAP Course


SAP PP Course

SAP SD Course

SAP MM Course

SAP HANA Course

SAP HR Course




GRAPHIC DESIGNING COURSES



Adobe photoshop Course
Adobe illustrator Course

Corel draw Course

Graphic designing Course

Infographics Course

Web designing Course

Video editing Course

Audio editing Course

3D Animation Course


Our Specialities


Flexible Timings

As per Office Time Or collage Timings Slots Will Be provided


Very Less Fee Structure

Comapred to other institute fee structure here is very less


Daily Theory & Practicals

Theory & Practical will be provided Everyday


Certificate

Certificates will be issued afte the courses


Course materials

Softcopy of course material will be given to every student


Placement Assistance

Placement support will be done after the course completion


Experienced Trainers & In Depth Knowledge

Very Experienced trainers will take sessions


 

 

 

Related course

 

Related Links