Advanced excel Training institute in bangalore

BASIC Microsoft Excel:
Spreadsheet fundamentals
Creating, modifying, saving and printing spreadsheets
Working with features & formulae
Graphically representing knowledge : Charts & Graphs
Analyzing knowledge : Knowledge Menu, Subtotal, Filtering Knowledge
Formatting worksheets , Securing & Defending spreadsheets

ADVANCED Excel Coaching in Bangalore
Formulation & Macros Formulation:

Use the Perform Wizard, Widespread features (AVERAGE, MIN, MAX, COUNT,COUNTA, ROUND, INT)
Nested features , Identify cells /ranges /constants
Relative, Absolute, Combined cell references : >,<,= operators
Logical features utilizing IF, AND, OR, NOT
The LOOKUP perform , Date and time features , Annotating formulation

DATA Evaluation:

Sub Complete Reviews, Auto Filter
Password Defending Worksheets
Linking A number of Sheets
Sheet Referencing
Linking Between Phrase/Excel/Ppt
Features:- LOOKUP, VLOOKUP, HLOOKUP, COUNTIF, SUMIF
What-if-evaluation, GOAL SEEK
PIVOT Tables, NESTED IF
Reporting
Character Features
Date Features
Age Calculations
Consolidation of Knowledge
Knowledge Validation
MACRO S

Macros:

Definition and use , Report a macro
Assign a macro , Run a macro
Retailer a macro, Introduction to VBA Prog.

Develop the Worksheet:

Plan a worksheet , Row and Column labels
Cut up worksheet /field /bar, Copy knowledge and formulation
Show /transfer toolbars , Improve worksheet Look

Particular Operations:

Use a number of home windows : Copy/ paste between Worksheets
Hyperlink worksheets , Consolidate worksheets
Import and hyperlink from different Purposes
Use AutoFormat : Create, use and modify types and templates
Print options : Create /edit an overview

Graphic Operations:

Create charts , Improve charts, Drawing toolbar options

Bizsmart solutions India pvt ltd
354,Aswath nagar, varthur road,
Marathahalli bridge,
opp safal fresh,
Marathahalli, Bangalore - 560037
www.bizsmart.in
Cal 7204451306