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 Courses


Infographics Courses


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