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

 

Introduction to MS Excel

 

Sort And Filter, Find Options


Pivot Table, Pivot Table With Pivot Chart


Table Options, Picture, Clip Art, Shapes,
Columnar Chart, Bar Chart,


Pi Chart, Doughnut, Hyperlink, Text Box,

 

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

Address : 2/B, #257, (BIIT Building),

9th A Main, Near Nagarjuna Chimney,

3rd Block, Jayanagar, Bangalore - 560011

 

E : : nishu.phillos@gmail.com


Click to call : 9844885059 / 9620890035


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


PHILLOS 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 Links