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

 

Introduction

 

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,

CLEAR OPTIONS,

SORT AND FILTER, FIND OPTIONS

 

INSERT MENU


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

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,

TRACE DEPENDENTS,

WATCH WINDOW,

FORMULA AUDITING,

ERROR CHECKING,

DEFINE NAME, NAME MANAGER

 

DATA MENU

SUBTOTAL,GROUP,UNGROUP,

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

 

 

 


Contact US


A : :PHILLOS,

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

 3rd Block, Jayanagar, Bangalore - 560011

 

E : : nishu.phillos@gmail.

 

Ph : : 984488 5059 / 96208 90035 / 903588 5059

 

Whatsapp : 984488 5059 / 96208 90035

 

Facebook | Linked in | Google + | Google Web


 



ANIMATION & MULTIMEDIA

 

Adobe photoshop Course


 

Adobe illustrator Course



Corel draw Course



Graphic designing Course



Infographics



DTP Course



Web designing Course



Video editing Course



Audio editing Course



2D Animation Course



3D Animation Course



 



BUSINESS ANALYTICS & REPORTING TOOLS



 

Microsoft Advanced Excel Course


 

VBA & Macros Course


 

Microsoft Access Course


 

SAS Base & Advanced Course



Clinical sas Course



Statistical SAS Course



MSBI SSIS SSRS SSAS Course



Tableau Course



Business Analytics


 

 



SAP ERP Course



 

 

SAP fico Course


 

SAP ABAP Course


 

SAP WM Course



SAP PP Course



SAP SD Course



SAP MM Course



SAP HANA Course



SAP BI BO Course


 

 



.net Course



java / J2EE Course



Android Course



Oracle Sql & Plsql Course



Sql Server Course



PHP and MYSQL Course



Sql Course



Vmware Course



Tally ERP Course



Basic Excel


 

 



Why Phillos.....?


 

In Depth technical Knowledge

 

Live Project guidence

 

Real Time Working Environment

 

100% Placement Support

 

One On One Sessions availablity

 

Fast track & Super fast track classes

 



 

 

 

 

Related Links

Related Links